1833409 - (SQLite3.42.0) Upgrade to SQLite 3.42.0

Status: RESOLVED FIXED

(Core :: SQLite and Embedded Database Bindings, task, P3)

Description

[Ryan VanderMeulen [:RyanVM]]

+++ This bug was initially created as a clone of Bug #1823960 +++

SQLite Release 3.42.0 On 2023-05-16

• Add the FTS5 secure-delete command. This option causes all forensic traces to be removed from the FTS5 inverted index when content is deleted.
• Enhance the JSON SQL functions to support JSON5 extensions.
• The SQLITE_CONFIG_LOG and SQLITE_CONFIG_PCACHE_HDRSZ calls to sqlite3_config() are now allowed to occur after sqlite3_initialize().
• New sqlite3_db_config() options: SQLITE_DBCONFIG_STMT_SCANSTATUS and SQLITE_DBCONFIG_REVERSE_SCANORDER.
• Query planner improvements:
  • Enable the "count-of-view" optimization by default.
  • Avoid computing unused columns in subqueries.
  • Improvements to the push-down optimization.
• Enhancements to the CLI:
  • Add the --unsafe-testing command-line option. Without this option, some dot-commands (ex: ".testctrl") are now disabled because those commands that are intended for testing only and can cause malfunctions misused.
  • Allow commands ".log on" and ".log off", even in --safe mode.
  • "--" as a command-line argument means all subsequent arguments that start with "-" are interpreted as normal non-option argument.
  • Magic parameters ":inf" and ":nan" bind to floating point literals Infinity and NaN, respectively.
  • The --utf8 command-line option omits all translation to or from MBCS on the Windows console for interactive sessions, and sets the console code page for UTF-8 I/O during such sessions. The --utf8 option is a no-op on all other platforms.
• Add the ability for application-defined SQL functions to have the same name as join keywords: CROSS, FULL, INNER, LEFT, NATURAL, OUTER, or RIGHT.
• Enhancements to PRAGMA integrity_check:
  • Detect and raise an error when a NaN value is stored in a NOT NULL column.
  • Improved error message output identifies the root page of a b-tree when an error is found within a b-tree.
• Allow the session extension to be configured to capture changes from tables that lack an explicit ROWID.
• Added the subsecond modifier to the date and time functions.
• Negative values passed into sqlite3_sleep() are henceforth interpreted as 0.
• The maximum recursion depth for JSON arrays and objects is lowered from 2000 to 1000.
• Extended the built-in printf() function so the comma option now works with floating-point conversions in addition to integer conversions.
• Miscellaneous bug fixes and performance optimizations

Comment 1

[Ryan VanderMeulen [:RyanVM]]

FWIW, I'm planning to let this release bake a bit before creating the patch. I already see a couple branch-3.42 commits upstream and I don't think there's a particularly urgent need to get this landed.

Comment 2

[Marco Bonardo [:mak]]

Agree.

Comment 3

[Ryan VanderMeulen [:RyanVM]]

Try push: https://treeherder.mozilla.org/jobs?repo=try&revision=c29f16f158d7de802a1db6846c082849d1ae17e7

Comment 4

[Ryan VanderMeulen [:RyanVM]]

Attachment: Bug 1833409 - Upgrade to SQLite 3.42.0. r=mak

Comment 5

[Marco Bonardo [:mak]]

Considered the changelog, I'd delay any update to 116. We're just 2 days away from the code freeze and there's nothing particularly interesting we need here.

Comment 6

[Ryan VanderMeulen [:RyanVM]]

Feel free to r+ and Lando whenever you're comfortable doing so. I'll update the patch if/when a 3.42.1 update comes out in the mean time.

Comment 7

[Pulsebot]

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

Comment 8

[Natalia Csoregi [:nataliaCs]]

https://hg.mozilla.org/mozilla-central/rev/cbfbab86b8f2