Hello community, here is the log from the commit of package sqlite3 for openSUSE:Factory checked in at 2020-12-05 20:36:08 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Comparing /work/SRC/openSUSE:Factory/sqlite3 (Old) and /work/SRC/openSUSE:Factory/.sqlite3.new.5913 (New) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Package is "sqlite3" Sat Dec 5 20:36:08 2020 rev:122 rq:852646 version:3.34.0 Changes: -------- --- /work/SRC/openSUSE:Factory/sqlite3/sqlite3.changes 2020-08-19 18:43:48.187432004 +0200 +++ /work/SRC/openSUSE:Factory/.sqlite3.new.5913/sqlite3.changes 2020-12-05 20:36:58.494696136 +0100 @@ -1,0 +2,48 @@ +Wed Dec 2 09:08:39 UTC 2020 - Reinhard Max <m...@suse.com> + +- SQLite 3.34.0: + * Added the sqlite3_txn_state() interface for reporting on the + current transaction state of the database connection. + * Enhance recursive common table expressions to support two or more + recursive terms as is done by SQL Server, since this helps make + queries against graphs easier to write and faster to execute.\ + * Improved error messages on CHECK constraint failures. + * The .read dot-command now accepts a pipeline in addition to a + filename. + * Added options --data-only and --nosys to the .dump dot-command. + * Added the --nosys option to the .schema dot-command. + * Table name quoting works correctly for the .import dot-command. + * The generate_series(START,END,STEP) table-valued function + extension is now built into the CLI. + * The .databases dot-command now show the status of each database + file as determined by sqlite3_db_readonly() and + sqlite3_txn_state(). + * Added the --tabs command-line option that sets .mode tabs. + * The --init option reports an error if the file named as its + argument cannot be opened. The --init option also now honors the + --bail option. + * Improved estimates for the cost of running a DISTINCT operator. + * When doing an UPDATE or DELETE using a multi-column index where + only a few of the earlier columns of the index are useful for the + index lookup, postpone doing the main table seek until after all + WHERE clause constraints have been evaluated, in case those + constraints can be covered by unused later terms of the index, + thus avoiding unnecessary main table seeks. + * The new OP_SeekScan opcode is used to improve performance of + multi-column index look-ups when later columns are constrained by + an IN operator. + * The BEGIN IMMEDIATE and BEGIN EXCLUSIVE commands now work even if + one or more attached database files are read-only. + * Enhanced FTS5 to support trigram indexes. + * Improved performance of WAL mode locking primitives in cases where + there are hundreds of connections all accessing the same database + file at once. + * Enhanced the carray() table-valued function to include a + single-argument form that is bound using the auxiliary + sqlite3_carray_bind() interface. + * The substr() SQL function can now also be called "substring()" for + compatibility with SQL Server. + * The syntax diagrams are now implemented as Pikchr scripts and + rendered as SVG for improved legibility and ease of maintenance. + +------------------------------------------------------------------- Old: ---- sqlite-doc-3330000.zip sqlite-src-3330000.zip New: ---- sqlite-doc-3340000.zip sqlite-src-3340000.zip ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Other differences: ------------------ ++++++ sqlite3.spec ++++++ --- /var/tmp/diff_new_pack.rbl4S1/_old 2020-12-05 20:36:59.122696774 +0100 +++ /var/tmp/diff_new_pack.rbl4S1/_new 2020-12-05 20:36:59.122696774 +0100 @@ -17,10 +17,10 @@ %define oname sqlite -%define tarversion 3330000 +%define tarversion 3340000 %bcond_with icu Name: sqlite3 -Version: 3.33.0 +Version: 3.34.0 Release: 0 Summary: Embeddable SQL Database Engine License: SUSE-Public-Domain _______________________________________________ openSUSE Commits mailing list -- commit@lists.opensuse.org To unsubscribe, email commit-le...@lists.opensuse.org List Netiquette: https://en.opensuse.org/openSUSE:Mailing_list_netiquette List Archives: https://lists.opensuse.org/archives/list/commit@lists.opensuse.org
