On Tue, 2005-09-20 at 06:57 +0200, Alain Bertrand wrote:
> Do you have an approximativ dateframe to see
> this fix incorporated in a release ?
>
No. The problem is obscure so I am not in a big rush
to get it out. You can fix the problem in your copy by
downloading the latest from CVS. Or you
D. Richard Hipp a écrit :
I've changed my mind. I think instead that there is a bug in
SQLite that caused LEFT JOINs to be computed incorrectly if one
of the terms in the ON clause restricts only the left table in
the join.
Check-in [2725] at http://www.sqlite.org/cvstrac/chngview?cn=2725
Alain Bertrand wrote:
Puneet Kishor a écrit :
without seeing the data, a good guess would be, "Yes."
What do you mean ? That my query is syntaxically wrong ?
Your query is syntactically correct in that it returns a result without
the SQL engine generating a syntax error... it just doesn't
Puneet Kishor a écrit :
without seeing the data, a good guess would be, "Yes."
What do you mean ? That my query is syntaxically wrong ?
LEFT JOIN selects all the rows with values from the left table and
either matching values or NULL from the right table.
Yes, I know, not very well because I
4 matches
Mail list logo
