SQLite version 3.19.2 is now available on the SQLite website:
https://sqlite.org/download.html
https://sqlite.org/releaselog/3_19_2.html
The 3.19.0 release of SQLite contained a new optimization that attempts to
"uplift" or "flatten" a subquery or view on the right-hand side of a LEFT JOIN
into the main query. Several problems have been found in that new
optimization, necessitating a couple of patch releases. SQLite version 3.19.2
is the latest and (we hope) last patch. If you are using version 3.19.0 and if
you use subqueries or view and LEFT JOINs then you should upgrade to 3.19.2.
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-announce mailing list
sqlite-announce@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-announce
