Problem with joins and where.

[Deane Venske]

Deane Venske wrote:

> Hi there,
>
> I'm getting a 1019 error on a query in the latest VServer. I was not 
> getting this before I upgraded to the latest (I forget which I was 
> last using I think a42)
>
> SELECT userDetails.firstName, userDetails.lastName FROM user, 
> userDetails WHERE user.userID = userDetails.userID AND user.username = 
> 'admin'  --> This works perfectly.
> SELECT userDetails.firstName, userDetails.lastName FROM user, 
> userDetails WHERE user.userID = userDetails.userID AND user.username = 
> 'admi'  --> This throws back an error and kills my connection to the DB
>
> As you can see the only difference is in the WHERE clause. The first 
> query has a match, the second doesn't because there is no user with 
> the username 'admi'.
>
> Anyone have any ideas about this?
>
> Deane.
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/Valentina
>
This seems to be a very big problem. It seems VServer crashes each time 
it returns no results from a join. Even if I don't stipulate things in 
the WHERE.