Re: [sqlite] SQLite 3.7.5 : same query written using NOT IN and EXCEPT does not give out same results

On Tue, Feb 22, 2011 at 14:17, Richard Hipp wrote: > > The query is really more like this: > > SELECT DISTINCT COALESCE(a.xxx, b.value) value >  FROM tbl1 a >  LEFT OUTER JOIN tbl2 b >    ON a.zzz = b.ttt >  WHERE value NOT IN ( >        SELECT DISTINCT ggg >          FROM tbl3 >

Re: [sqlite] SQLite 3.7.5 : same query written using NOT IN and EXCEPT does not give out same results

On Tue, Feb 22, 2011 at 5:22 AM, Benoit Mortgat wrote: > Hello, > > I have come across a strange behaviour of SQLite 3.7.5. > > The following query: > > SELECT DISTINCT COALESCE(a.xxx, b.yyy) value > FROM tbl1 a > LEFT OUTER JOIN tbl2 b >ON a.zzz = b.ttt > EXCEPT >

Re: [sqlite] SQLite 3.7.5 : same query written using NOT IN and EXCEPT does not give out same results

On Tue, Feb 22, 2011 at 5:22 AM, Benoit Mortgat wrote: > I could send a samble database with full query to a developer if > needed in order to reproduce that. > Please do send the sample database and the full queries. -- D. Richard Hipp d...@sqlite.org