On Wed, 9 Mar 2016 10:13:28 -0500 Richard Hipp <drh at sqlite.org> wrote:
> > select id from a where id not in (select a.id from b); > > > > which outputs one result (2), although the expected result would be > > empty. > > > > Thanks for the bug report. What bug? The query is valid SQL, and produces the correct results. The programmer would have been better off writing a useful query, but we've all been there. --jkl
