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