From 18657a960e125336f704ea058e25c27bd3900dcb Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 5 May 2024 19:28:19 +0200 Subject: Adding upstream version 3.40.1. Signed-off-by: Daniel Baumann --- www/releaselog/3_39_0.html | 152 +++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 152 insertions(+) create mode 100644 www/releaselog/3_39_0.html (limited to 'www/releaselog/3_39_0.html') diff --git a/www/releaselog/3_39_0.html b/www/releaselog/3_39_0.html new file mode 100644 index 0000000..22143a2 --- /dev/null +++ b/www/releaselog/3_39_0.html @@ -0,0 +1,152 @@ + + + + + +SQLite Release 3.39.0 On 2022-06-25 + + + +
+ + + +
+
+Small. Fast. Reliable.
Choose any three. +
+
+ +
+ +
+
+ + + +
+
+
+ +

SQLite Release 3.39.0 On 2022-06-25

    +
  1. Add (long overdue) support for RIGHT and FULL OUTER JOIN. +
  2. Add new binary comparison operators IS NOT DISTINCT FROM and IS DISTINCT FROM + that are equivalent to IS and IS NOT, respective, for compatibility with + PostgreSQL and SQL standards. +
  3. Add a new return code (value "3") from the sqlite3_vtab_distinct() + interface that indicates a query that has both DISTINCT and ORDER BY + clauses. +
  4. Added the sqlite3_db_name() interface. +
  5. The unix os interface resolves all symbolic links in database + filenames to create a canonical name for the database before the + file is opened. + If the SQLITE_OPEN_NOFOLLOW flag is used with sqlite3_open_v2() + or similar, the open will fail if any element of the path is a + symbolic link. +
  6. Defer materializing views until the materialization + is actually needed, thus avoiding unnecessary work if the materialization turns + out to never be used. +
  7. The HAVING clause of a SELECT statement is now allowed on any aggregate query, + even queries that do not have a GROUP BY clause. +
  8. Many microoptimizations collectively reduce CPU cycles by about 2.3%. +

    Hashes: +

  9. SQLITE_SOURCE_ID: 2022-06-25 14:57:57 14e166f40dbfa6e055543f8301525f2ca2e96a02a57269818b9e69e162e98918 +
  10. SHA3-256 for sqlite3.c: d9c439cacad5e4992d0d25989cfd27a4c4f59a3183c97873bc03f0ad1aa78b7a + +

+ +

A complete list of SQLite releases + in a single page and a chronology are both also available. + A detailed history of every + check-in is available at + + SQLite version control site.

+ + -- cgit v1.2.3