1586739 - (SQLite3.30.1) Upgrade to SQLite 3.30.1

Status: RESOLVED FIXED

(Toolkit :: Storage, task, P2)

Description

[Ryan VanderMeulen [:RyanVM]]

2019-10-04 - Release 3.30.0

Version 3.30.0 is a regularly scheduled maintenance release of SQLite containing miscellaneous performance and feature enhancements. This release adds support fo the NULLS FIRST and NULLS LAST clauses on ORDER BY statements and the addition of FILTER clauses on all aggregate functions.

• Add support for the FILTER clause on aggregate functions.
• Add support for the NULLS FIRST and NULLS LAST syntax in ORDER BY clauses.
• The index_info and index_xinfo pragmas are enhanced to provide information about the on-disk representation of WITHOUT ROWID tables.
• Add the sqlite3_drop_modules() interface, allowing applications to disable automatically loaded virtual tables that they do not need.
• Improvements to the .recover dot-command in the CLI so that it recovers more content from corrupt database files.
• Enhance the RBU extension to support indexes on expressions.
• Change the schema parser so that it will error out if any of the type, name, and tbl_name columns of the sqlite_master table have been corrupted and the database connection is not in writable_schema mode.
• The PRAGMA function_list, PRAGMA module_list, and PRAGMA pragma_list commands are now enabled in all builds by default. Disable them using -DSQLITE_OMIT_INTROSPECTION_PRAGMAS.
• Add the SQLITE_DBCONFIG_ENABLE_VIEW option for sqlite3_db_config().
• Added the TCL Interface config method in order to be able to disable SQLITE_DBCONFIG_ENABLE_VIEW as well as control other sqlite3_db_config() options from TCL.
• Added the SQLITE_DIRECTONLY flag for application-defined SQL functions to prevent those functions from being used inside triggers and views.
• The legacy SQLITE_ENABLE_STAT3 compile-time option is now a no-op.

Comment 1

[Ryan VanderMeulen [:RyanVM]]

Attachment: Bug 1586739 - Upgrade to SQLite 3.30.1. r=mak

Comment 2

[Ryan VanderMeulen [:RyanVM]]

I ran the last snapshot prior to release through Try without issue:
https://treeherder.mozilla.org/#/jobs?repo=try&revision=81c31dfe13a31dda00e2bef7fb05bef2e842b466

I'll do a quick sanity check push on Linux64, but I'm not expecting any significant changes.

EDIT - Looks good:
https://treeherder.mozilla.org/#/jobs?repo=try&revision=ab8204927f33a0537ba143a38564a4fa6321de76

Comment 3

[Ryan VanderMeulen [:RyanVM]]

SQLite Release 3.30.1 On 2019-10-11

Version 3.30.1 is a bug-fix release that addresses a problem that can occur when an aggregate function in a nested query makes use of the new FILTER clause capability. Some addition patches for various obscure issues are also included, for completeness.

• Fix a bug in the query flattener that might cause a segfault for nested queries that use the new FILTER clause on aggregate functions. Ticket 1079ad19993d13fa
• Cherrypick fixes for other obscure problems found since the 3.30.0 release

Comment 4

[Pulsebot]

Pushed by [e-mail]:
https://hg.mozilla.org/integration/autoland/rev/9ac856b7b08c
Upgrade to SQLite 3.30.1. r=mak

Comment 5

[Narcis Beleuzu [:NarcisB]]

https://hg.mozilla.org/mozilla-central/rev/9ac856b7b08c