SQLite version 3.20.0 is now available on the SQLite website: https://sqlite.org/ https://sqlite.org/releaselog/3_20_0.html https://sqlite.org/download.html
This is a regularly scheduled maintenance release of SQLite. The release contains performance improvements, new features, and fixes to some obscure bugs. See the change log above for details. In this release, the column names returned by sqlite3_column_name() and sqlite3_column_name16() may shift for some queries. Those routines now return names that are more consistent and more aligned with the column names generated by PostgreSQL, MySQL, and SQLServer. This may cause problems for applications that (incorrectly) depend on specific column names in queries that do not use AS clauses to assign specific column names. The name shift will only occur for queries that use views or subqueries in the FROM clause and that use qualified names (table.column) to specify output columns. The output columns in such queries would formerly sometimes be named by the qualified name "table.column" and sometimes by just the "column" but are now always named by just the "column". The text of some error messages has also been changed (and we hope improved). Applications that depend on specific error message text may be impacted. As with all releases, the code for 3.20.0 has been very carefully tested. Nevertheless, bugs are always possible in a complex system like SQLite. If you detect any malfunctions, please report them on the sqlite-us...@mailinglists.sqlite.org mailing list, or directly to me. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-announce mailing list sqlite-announce@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-announce
