On 6/20/17, Eric Sink <e...@sourcegear.com> wrote: > Greetings, > > Version 3.19.3 is yielding different results than previous releases for a > query in the Entity Framework Core test suite. >
The results also differed from Postgres, which is our gold-standard. So, yes, it was a problem. The bug has now been fixed on trunk, as of a few minutes ago. Trouble ticket: https://www.sqlite.org/src/info/892fc34f173e99d8 Proposed fix: https://www.sqlite.org/src/info/483462682d3a57fb This is the third major malfunction in 3.19 to come out of the LEFT JOIN query flattening optimization. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users