From de1caa20c41f730e54fb6974ba7821fe48816e40 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 13 Apr 2024 16:07:37 +0200 Subject: Adding upstream version 3.45.2. Signed-off-by: Daniel Baumann --- www/autoinc.html | 12 ++- www/c3ref/c_source_id.html | 6 +- www/c3ref/exec.html | 2 + www/capi3ref.html | 8 +- www/changes.html | 19 ++++ www/chronology.html | 6 +- www/compile.html | 6 +- www/cves.html | 4 +- www/doc_backlink_crossref.html | 37 +++++++ www/doc_keyword_crossref.html | 2 +- www/doc_target_crossref.html | 1 + www/index.html | 4 +- www/json1.html | 8 +- www/keyword_index.html | 1 + www/lang_analyze.html | 2 +- www/lang_createtable.html | 216 ++++++++++++++++++++--------------------- www/lang_datefunc.html | 2 +- www/lang_expr.html | 2 +- www/loadext.html | 2 +- www/news.html | 13 ++- www/opcode.html | 10 +- www/pragma.html | 2 +- www/printf.html | 14 +-- www/queryplanner-ng.html | 2 +- www/releaselog/3_45_2.html | 215 ++++++++++++++++++++++++++++++++++++++++ www/releaselog/current.html | 25 ++++- www/search.d/search.db | Bin 9785344 -> 9781248 bytes www/serverless.html | 2 +- www/testing.html | 10 +- www/toc.db | Bin 90112 -> 90112 bytes www/vfs.html | 2 +- www/wal.html | 2 +- 32 files changed, 472 insertions(+), 165 deletions(-) create mode 100644 www/releaselog/3_45_2.html (limited to 'www') diff --git a/www/autoinc.html b/www/autoinc.html index 4923832..a5854bc 100644 --- a/www/autoinc.html +++ b/www/autoinc.html @@ -230,9 +230,13 @@ are ignored and can be reused.

SQLite keeps track of the largest ROWID using an internal table named "sqlite_sequence". -The sqlite_sequence table is created -and initialized automatically whenever a normal table that contains an -AUTOINCREMENT column is created. The content of the sqlite_sequence table +The sqlite_sequence table is created automatically, if it does not +already exist, whenever a normal table that contains an +AUTOINCREMENT column is created. A row in the sqlite_sequence table +corresponding to the table with the AUTOINCREMENT column is created the +first time the AUTOINCREMENT table is written and updated on any +subsequent writes that increase the maximum rowid. +The content of the sqlite_sequence table can be modified using ordinary UPDATE, INSERT, and DELETE statements. But making modifications to this table will likely perturb the AUTOINCREMENT key generation algorithm. Make sure you know what you are doing before @@ -266,5 +270,5 @@ algorithm, AUTOINCREMENT is not allowed on WITHOUT R table column other than INTEGER PRIMARY KEY. Any attempt to use AUTOINCREMENT on a WITHOUT ROWID table or on a column other than the INTEGER PRIMARY KEY column results in an error.

-

This page last modified on 2022-01-08 05:02:57 UTC

+

This page last modified on 2024-02-22 16:13:38 UTC

diff --git a/www/c3ref/c_source_id.html b/www/c3ref/c_source_id.html index 91a5a78..220b2ae 100644 --- a/www/c3ref/c_source_id.html +++ b/www/c3ref/c_source_id.html @@ -121,9 +121,9 @@ antiRobotDefense();

Compile-Time Library Version Numbers

-#define SQLITE_VERSION        "3.45.1"
-#define SQLITE_VERSION_NUMBER 3045001
-#define SQLITE_SOURCE_ID      "2024-01-30 16:01:20 e876e51a0ed5c5b3126f52e532044363a014bc594cfefa87ffb5b82257cc467a"
+#define SQLITE_VERSION        "3.45.2"
+#define SQLITE_VERSION_NUMBER 3045002
+#define SQLITE_SOURCE_ID      "2024-03-12 11:06:23 d8cd6d49b46a395b13955387d05e9e1a2a47e54fb99f3c9b59835bbefad6af77"

The SQLITE_VERSION C preprocessor macro in the sqlite3.h header diff --git a/www/c3ref/exec.html b/www/c3ref/exec.html index f892dab..98edb23 100644 --- a/www/c3ref/exec.html +++ b/www/c3ref/exec.html @@ -186,6 +186,8 @@ is a valid and open database connection. the 1st parameter to sqlite3_exec() while sqlite3_exec() is running.

  • The application must not modify the SQL statement text passed into the 2nd parameter of sqlite3_exec() while sqlite3_exec() is running. +
  • The application must not dereference the arrays or string pointers +passed as the 3rd and 4th callback parameters after it returns.

    See also lists of Objects, diff --git a/www/capi3ref.html b/www/capi3ref.html index a7fce31..86e5ad8 100644 --- a/www/capi3ref.html +++ b/www/capi3ref.html @@ -2937,6 +2937,8 @@ is a valid and open database connection. the 1st parameter to sqlite3_exec() while sqlite3_exec() is running.

  • The application must not modify the SQL statement text passed into the 2nd parameter of sqlite3_exec() while sqlite3_exec() is running. +
  • The application must not dereference the arrays or string pointers +passed as the 3rd and 4th callback parameters after it returns.

    Enable Or Disable Extended Result Codes

    @@ -6863,9 +6865,9 @@ and EXCLUSIVE.

    Compile-Time Library Version Numbers

    -#define SQLITE_VERSION        "3.45.1"
-#define SQLITE_VERSION_NUMBER 3045001
-#define SQLITE_SOURCE_ID      "2024-01-30 16:01:20 e876e51a0ed5c5b3126f52e532044363a014bc594cfefa87ffb5b82257cc467a"
+#define SQLITE_VERSION        "3.45.2"
+#define SQLITE_VERSION_NUMBER 3045002
+#define SQLITE_SOURCE_ID      "2024-03-12 11:06:23 d8cd6d49b46a395b13955387d05e9e1a2a47e54fb99f3c9b59835bbefad6af77"

    The SQLITE_VERSION C preprocessor macro in the sqlite3.h header diff --git a/www/changes.html b/www/changes.html index b7f5e21..8812a6c 100644 --- a/www/changes.html +++ b/www/changes.html @@ -129,6 +129,25 @@ https://www.sqlite.org/src/timeline?t=release. See the chronology a succinct listing of releases.

    + +

    2024-03-12 (3.45.2)

      +
    1. Fix an error in UPSERT, introduced by enhancement 3a in version 3.35.0 + (2021-03-12), that could cause an index to get out-of-sync with its table. + Forum thread 919c6579c8. +
    2. Reduce the scope of the NOT NULL strength reduction optimization that was + added as item 8e in version 3.35.0 (2021-03-12). The optimization + was being attempted in some contexts where it did not work, resulting in + incorrect query results. + Forum thread 440f2a2f17. +
    3. Other trifling corrections and compiler warning fixes that have come up + since the previous patch release. See the + timeline + for details. +

      Hashes: +

    4. SQLITE_SOURCE_ID: "2024-03-12 11:06:23 d8cd6d49b46a395b13955387d05e9e1a2a47e54fb99f3c9b59835bbefad6af77" +
    5. SHA3-256 for sqlite3.c: bd76ad2dc9cde151e469e86627a7e8753aa8ef1a6f657c5a80ba48324b53226b + +

    2024-01-30 (3.45.1)

    1. Restore the JSON BLOB input bug, and promise to support the anomaly in diff --git a/www/chronology.html b/www/chronology.html index 51e915f..43e3c5c 100644 --- a/www/chronology.html +++ b/www/chronology.html @@ -125,6 +125,8 @@ antiRobotDefense(); DateVersion +2024-03-12 +3.45.2 2024-01-30 3.45.1 2024-01-15 @@ -941,8 +943,8 @@ var t = new SortableTable(document.getElementById("chrontab"),"nK",1);

      -346 releases -over 23.5 years. +347 releases +over 23.6 years.

      This page last modified on 2023-03-03 01:19:02 UTC

      diff --git a/www/compile.html b/www/compile.html index 5e300e2..b9acc84 100644 --- a/www/compile.html +++ b/www/compile.html @@ -278,7 +278,7 @@ If SQLite is compiled with -DSQLITE_OMIT_AUTOINIT and a routine like without first calling sqlite3_initialize(), the likely result will be a segfault. -

      SQLITE_STRICT_SUBTYPE=1. +

    2. SQLITE_STRICT_SUBTYPE=1. This option causes an error to be raised if an application defined function that does not have the SQLITE_RESULT_SUBTYPE property invokes the sqlite3_result_subtype() interface. The sqlite3_result_subtype() @@ -286,7 +286,7 @@ interface does not work reliably unless the function is registered with the SQLITE_RESULT_SUBTYPE property. This compile-time option is designed to bring this problem to the attention of developers early. -

    +

    • When all of the recommended compile-time options above are used, the SQLite library will be approximately 3% smaller and use about 5% fewer @@ -2129,5 +2129,5 @@ macros is included for completeness.

    This macro may not be used in combination with any of SQLITE_APICALL, SQLITE_CALLBACK, SQLITE_CDECL or SQLITE_SYSAPI.

    -

    This page last modified on 2024-01-09 20:59:08 UTC

    +

    This page last modified on 2024-02-01 18:38:39 UTC

    diff --git a/www/cves.html b/www/cves.html index 7d1714b..75b22da 100644 --- a/www/cves.html +++ b/www/cves.html @@ -443,7 +443,7 @@ be added. CVE-2023-7104 -3.43.2
    (2023-10-10) +3.43.1
    (2023-09-11) This is a bug in the session extension of SQLite, not in the SQLite core. This bug is only reachable by applications that recompile SQLite using the -DSQLITE_ENABLE_SESSION compile-time option and then use the Session @@ -779,5 +779,5 @@ be added. -

    This page last modified on 2024-01-16 16:06:37 UTC

    + diff --git a/www/doc_backlink_crossref.html b/www/doc_backlink_crossref.html index ab6e15c..cbf7cd1 100644 --- a/www/doc_backlink_crossref.html +++ b/www/doc_backlink_crossref.html @@ -208,6 +208,7 @@ antiRobotDefense();
  • -DSQLITE_STRICT_SUBTYPE → changes.html#version_3_45_0 releaselog/3_45_0.html releaselog/3_45_1.html + releaselog/3_45_2.html
  • -DSQLITE_TEMP_STORE → howtocorrupt.html#svptbug news.html
  • -DSQLITE_THREADSAFE → cli.html#compiling @@ -558,6 +559,7 @@ antiRobotDefense(); releaselog/3_23_1.html releaselog/3_45_0.html releaselog/3_45_1.html + releaselog/3_45_2.html releaselog/3_6_18.html releaselog/3_7_3.html releaselog/3_7_6.html @@ -634,6 +636,7 @@ antiRobotDefense(); releaselog/3_42_0.html releaselog/3_45_0.html releaselog/3_45_1.html + releaselog/3_45_2.html releaselog/3_8_0.html releaselog/3_8_0_1.html releaselog/3_8_0_2.html @@ -968,6 +971,7 @@ antiRobotDefense(); releaselog/3_35_4.html releaselog/3_35_5.html releaselog/3_45_1.html + releaselog/3_45_2.html stmt.html
  • bytecode virtual table → changes.html#version_3_32_0 releaselog/3_32_0.html @@ -1299,6 +1303,7 @@ antiRobotDefense(); releaselog/3_44_2.html releaselog/3_45_0.html releaselog/3_45_1.html + releaselog/3_45_2.html releaselog/3_4_0.html releaselog/3_4_1.html releaselog/3_4_2.html @@ -1503,6 +1508,7 @@ antiRobotDefense(); releaselog/3_44_2.html releaselog/3_45_0.html releaselog/3_45_1.html + releaselog/3_45_2.html releaselog/3_6_11.html releaselog/3_6_12.html sqlar.html#cltools @@ -1968,6 +1974,7 @@ antiRobotDefense(); releaselog/3_44_2.html releaselog/3_45_0.html releaselog/3_45_1.html + releaselog/3_45_2.html releaselog/3_4_0.html releaselog/3_4_1.html releaselog/3_4_2.html @@ -3562,6 +3569,7 @@ antiRobotDefense(); releaselog/3_44_2.html releaselog/3_45_0.html releaselog/3_45_1.html + releaselog/3_45_2.html releaselog/3_8_11.html releaselog/3_8_11_1.html releaselog/3_9_0.html @@ -3631,6 +3639,7 @@ antiRobotDefense();
  • FTS5 tokendata option → changes.html#version_3_45_0 releaselog/3_45_0.html releaselog/3_45_1.html + releaselog/3_45_2.html
  • FTS5 tokenizers → fts5.html#fts5_phrases fts5.html#fts5_table_creation_and_initialization
  • FTS5 usermerge option → fts5.html#the_merge_command @@ -4156,10 +4165,14 @@ antiRobotDefense();
  • https://sqlite.org/forum/forumpost/2568d1f6e6 → changes.html#version_3_45_0 releaselog/3_45_0.html releaselog/3_45_1.html + releaselog/3_45_2.html
  • https://sqlite.org/forum/forumpost/3607259d3c → changes.html#version_3_39_2 releaselog/3_39_2.html releaselog/3_39_3.html releaselog/3_39_4.html +
  • https://sqlite.org/forum/forumpost/440f2a2f17 → changes.html#version_3_45_2 + news.html + releaselog/3_45_2.html
  • https://sqlite.org/forum/forumpost/53de8864ba114bf6 → cves.html#cvetab
  • https://sqlite.org/forum/forumpost/58540ce22dcd5fdcd → changes.html#version_3_35_3 releaselog/3_35_3.html @@ -4168,10 +4181,14 @@ antiRobotDefense();
  • https://sqlite.org/forum/forumpost/6f0958b03b → changes.html#version_3_45_0 releaselog/3_45_0.html releaselog/3_45_1.html + releaselog/3_45_2.html
  • https://sqlite.org/forum/forumpost/719a11e1314d1c70 → changes.html#version_3_39_3 releaselog/3_39_3.html releaselog/3_39_4.html
  • https://sqlite.org/forum/forumpost/7481d2a6df8980ff → lang_select.html#bareagg +
  • https://sqlite.org/forum/forumpost/919c6579c8 → changes.html#version_3_45_2 + news.html + releaselog/3_45_2.html
  • https://sqlite.org/forum/forumpost/9b9e4716c0d7bbd1 → changes.html#version_3_39_3 releaselog/3_39_3.html releaselog/3_39_4.html @@ -4430,6 +4447,8 @@ antiRobotDefense();
  • https://sqlite.org/src/timeline?from=version-3.41.0&to=version-3.41.1 → changes.html#version_3_41_1 releaselog/3_41_1.html releaselog/3_41_2.html +
  • https://sqlite.org/src/timeline?from=version-3.45.1&to=version-3.45.2&to2=branch-3.45 → changes.html#version_3_45_2 + releaselog/3_45_2.html
  • https://sqlite.org/src/timeline?p=version-3.38.1&bt=version-3.38.0 → changes.html#version_3_38_1 releaselog/3_38_1.html releaselog/3_38_2.html @@ -5418,6 +5437,7 @@ antiRobotDefense(); windowfunctions.html#grouptype
  • jfuzz → changes.html#version_3_45_1 releaselog/3_45_1.html + releaselog/3_45_2.html
  • join order → eqp.html
  • join-clause → lang_aggfunc.html lang_altertable.html @@ -5519,6 +5539,7 @@ antiRobotDefense(); releaselog/3_10_2.html
  • JSON BLOB input bug → changes.html#version_3_45_1 releaselog/3_45_1.html + releaselog/3_45_2.html
  • JSON function path arguments → changes.html#version_3_31_0 releaselog/3_31_0.html releaselog/3_31_1.html @@ -5533,6 +5554,7 @@ antiRobotDefense(); releaselog/3_42_0.html releaselog/3_45_0.html releaselog/3_45_1.html + releaselog/3_45_2.html testing.html#dbsqlfuzz testing.html#slt
  • json1 → amalgamation.html @@ -5631,12 +5653,14 @@ antiRobotDefense(); json1.html#jsonbx releaselog/3_45_0.html releaselog/3_45_1.html + releaselog/3_45_2.html
  • JSONB → changes.html#version_3_45_0 changes.html#version_3_45_1 json1.html#jgroupobjectb json1.html#jvalid releaselog/3_45_0.html releaselog/3_45_1.html + releaselog/3_45_2.html testing.html#dbsqlfuzz testing.html#slt
  • jsonb_extract → json1.html#jptr @@ -6674,6 +6698,7 @@ antiRobotDefense(); releaselog/3_44_1.html releaselog/3_44_2.html releaselog/3_45_1.html + releaselog/3_45_2.html releaselog/3_7_12.html releaselog/3_7_14.html releaselog/3_7_16.html @@ -6740,6 +6765,7 @@ antiRobotDefense(); pragma.html#pragma_mmap_size pragma.html#toc releaselog/3_45_1.html + releaselog/3_45_2.html security.html#baddb
  • PRAGMA module_list → changes.html#version_3_30_0 compile.html#introspection_pragmas @@ -10680,6 +10706,7 @@ antiRobotDefense(); releaselog/3_11_1.html releaselog/3_45_0.html releaselog/3_45_1.html + releaselog/3_45_2.html releaselog/3_9_0.html releaselog/3_9_1.html releaselog/3_9_2.html @@ -13074,6 +13101,7 @@ antiRobotDefense(); releaselog/3_17_0.html releaselog/3_45_0.html releaselog/3_45_1.html + releaselog/3_45_2.html releaselog/3_7_9.html
  • SQLITE_DIRECTONLY → appfunc.html appfunc.html#sec @@ -14159,6 +14187,7 @@ antiRobotDefense(); compile.html#yystackdepth releaselog/3_45_0.html releaselog/3_45_1.html + releaselog/3_45_2.html
  • SQLITE_MAX_SCHEMA_RETRY → c3ref/prepare.html capi3ref.html#sqlite3_prepare changes.html#version_3_7_17 @@ -14735,6 +14764,7 @@ antiRobotDefense(); news.html releaselog/3_45_0.html releaselog/3_45_1.html + releaselog/3_45_2.html
  • SQLITE_REVERSE_UNORDERED_SELECTS → changes.html#version_3_8_8 releaselog/3_8_8.html releaselog/3_8_8_1.html @@ -15831,6 +15861,7 @@ antiRobotDefense();
  • UPSERT → changes.html#version_3_24_0 changes.html#version_3_35_0 changes.html#version_3_37_1 + changes.html#version_3_45_2 fullsql.html lang.html lang_conflict.html @@ -15846,6 +15877,7 @@ antiRobotDefense(); releaselog/3_35_5.html releaselog/3_37_1.html releaselog/3_37_2.html + releaselog/3_45_2.html
  • upsert clause → lang_insert.html
  • upsert-clause → lang_createtrigger.html lang_insert.html @@ -16207,12 +16239,14 @@ antiRobotDefense();
  • version 3.35.0 → changes.html#version_3_36_0 changes.html#version_3_37_1 changes.html#version_3_37_2 + changes.html#version_3_45_2 chronology.html howtocorrupt.html#svptbug news.html releaselog/3_36_0.html releaselog/3_37_1.html releaselog/3_37_2.html + releaselog/3_45_2.html
  • version 3.35.1 → chronology.html
  • version 3.35.2 → chronology.html
  • version 3.35.3 → chronology.html @@ -16252,16 +16286,19 @@ antiRobotDefense(); testing.html
  • version 3.43.0 → chronology.html
  • version 3.43.1 → chronology.html + cves.html#cvetab
  • version 3.43.2 → chronology.html cves.html#cvetab
  • version 3.44.0 → changes.html#version_3_45_1 chronology.html releaselog/3_45_1.html + releaselog/3_45_2.html
  • version 3.44.1 → chronology.html
  • version 3.44.2 → chronology.html
  • version 3.45.0 → chronology.html news.html
  • version 3.45.1 → chronology.html +
  • version 3.45.2 → chronology.html
  • version 3.5.0 → 35to36.html c3ref/enable_shared_cache.html c3ref/vfs.html diff --git a/www/doc_keyword_crossref.html b/www/doc_keyword_crossref.html index 2bf33f3..0b2b7b2 100644 --- a/www/doc_keyword_crossref.html +++ b/www/doc_keyword_crossref.html @@ -115,5 +115,5 @@ antiRobotGo(); } antiRobotDefense(); -

    This page last modified on 2023-03-31 19:57:15 UTC

    +

    This page last modified on 2023-03-31 19:57:15 UTC

    diff --git a/www/doc_target_crossref.html b/www/doc_target_crossref.html index fc35282..59c9844 100644 --- a/www/doc_target_crossref.html +++ b/www/doc_target_crossref.html @@ -1551,6 +1551,7 @@ antiRobotDefense();
  • releaselog/3_44_2.html → {Version 3.44.2} {version 3.44.2}
  • releaselog/3_45_0.html → {Version 3.45.0} {version 3.45.0}
  • releaselog/3_45_1.html → {Version 3.45.1} {version 3.45.1}
    • +
  • releaselog/3_45_2.html → {Version 3.45.2} {version 3.45.2}
  • releaselog/3_4_0.html → {Version 3.4.0} {version 3.4.0}
  • releaselog/3_4_1.html → {Version 3.4.1} {version 3.4.1}
  • releaselog/3_4_2.html → {Version 3.4.2} {version 3.4.2}
    • diff --git a/www/index.html b/www/index.html index c9e892a..c20b521 100644 --- a/www/index.html +++ b/www/index.html @@ -189,7 +189,7 @@ is in the public-domain and is free to everyone to use for any purpose.

    Latest Release

    -Version 3.45.1 (2024-01-30). +Version 3.45.2 (2024-03-12). Download Prior Releases @@ -284,5 +284,5 @@ by SQLite Consortium members, including:


    -

    This page last modified on 2024-01-23 13:42:58 UTC

    + diff --git a/www/json1.html b/www/json1.html index a3f10da..7e15bc0 100644 --- a/www/json1.html +++ b/www/json1.html @@ -395,7 +395,7 @@ internal "parse tree" representation of JSON to be stored on disk, as a BLOB, in a format that we call "JSONB". By storing SQLite's internal binary representation of JSON directly in the database, applications can bypass the overhead of parsing and rendering JSON when reading and -updating JSON values. The internal JSONB format is also uses slightly +updating JSON values. The internal JSONB format also uses slightly less disk space then text JSON.

    @@ -653,7 +653,7 @@ for infinity and not-a-number.

    Most JSON functions do their internal processing using JSONB. So if the -input is text, they first most translate the input text into JSONB. +input is text, they first must translate the input text into JSONB. If the input is already in the JSONB format, no translation is needed, that step can be skipped, and performance is faster. @@ -698,7 +698,7 @@ text JSON when cast to text, then it is accepted as text JSON. This is actually a long-standing bug in the original implementation that the SQLite developers were unaware of. The documentation stated that a BLOB input to a JSON function should raise an error. But in the -actually implementation, the input would be accepted as long +actual implementation, the input would be accepted as long as the BLOB content was a valid JSON string in the text encoding of the database. @@ -1616,5 +1616,5 @@ SELECT DISTINCT json_extract(big.json,'$.id') WHERE json_tree.key='uuid' AND json_tree.value='6fa5181e-5721-11e5-a04e-57f3d7b32808'; - +

    This page last modified on 2024-03-06 20:59:22 UTC

    diff --git a/www/keyword_index.html b/www/keyword_index.html index a32498e..3a93e33 100644 --- a/www/keyword_index.html +++ b/www/keyword_index.html @@ -3030,6 +3030,7 @@ Other Documentation Indexes:
  • Version 3.44.2
  • Version 3.45.0
  • Version 3.45.1
    • +
  • Version 3.45.2
  • Version 3.5.0
  • Version 3.5.1
  • Version 3.5.2
    • diff --git a/www/lang_analyze.html b/www/lang_analyze.html index 76b5d8a..7f65a7f 100644 --- a/www/lang_analyze.html +++ b/www/lang_analyze.html @@ -346,5 +346,5 @@ approximate ANALYZE is better than not running ANALYZE at all.

    The content in the sqlite_stat4 table cannot be computed with anything less than a full scan. Hence, if a non-zero analysis limit is specified, the sqlite_stat4 table is not computed. -

    This page last modified on 2024-01-09 20:59:08 UTC

    +

    This page last modified on 2024-02-21 13:43:47 UTC

    diff --git a/www/lang_createtable.html b/www/lang_createtable.html index 74f1589..e0af7b8 100644 --- a/www/lang_createtable.html +++ b/www/lang_createtable.html @@ -163,8 +163,8 @@ mk.innerHTML = "►";

    1. Syntax

    create-table-stmt: -

    -
    +

    +
    @@ -274,8 +274,8 @@ mk.innerHTML = "►";

    column-def: -

    -