You are correct. I just run a test on 3.2.6 release, and it does handle joins incorrectly. I cant get the files from cvs, so I am not sure whether the fix also Handles the reverse situation:
Select * >From T1 left join t2 on (t1.ref=t2.id) and (t2.kind=1) Ie if there is a join term that restricts the RIGHT hand table only. Just a thought. > -----Original Message----- > From: D. Richard Hipp [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 20, 2005 12:07 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] query problem > > 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 > contains > a fix for this problem for version 3.x. The problem has > existed in SQLite forever (because it originates from a > conceptual misunderstanding by the code author :-)) so > version 2.8.16 is still broken. Because the problem is > obscure, I am not inclined to fix it in the 2.8.x series... > > -- > D. Richard Hipp <[EMAIL PROTECTED]> > > > >
