Documentation Source Text

Check-in [18e8d6c077]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Update the change log.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 18e8d6c07706e40f4d904321dc6ce185b2356b4ceb015ce8d6789d6018876fdb
User & Date: drh 2020-05-20 15:02:53
Context
2020-05-20
16:59
An extra sentence of clarification on explicit collating sequences on an IN operator. check-in: 568e2f047e user: drh tags: trunk
15:02
Update the change log. check-in: 18e8d6c077 user: drh tags: trunk
01:24
Fix the INSERT syntax diagram so that it is not possible to go from DEFAULT VALUES to the upsert-clause. check-in: e42edf1dd3 user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/changes.in.

31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
<li> INSERT and UPDATE statements now always apply [column affinity]
     before computing [CHECK constraints].  This bug fix could, in
     theory, cause problems for legacy databases with unorthodox
     CHECK constraints the require the input type for an INSERT
     is different from the declared column type. See ticket
     [https://sqlite.org/src/info/86ba67afafded936|86ba67afafded936]
     for more information.
<li> If invalid surrogates are encountered while translating
     UTF16 to some other text representation, convert each invalid
     surrogate into the unicode replacement character, 0xfffd.
<li> Added the [sqlite3_create_filename()] and [sqlite3_free_filename()]
     interfaces to better support of [VFS shim] implementations.
<li> Increase the [SQLITE_MAX_VARIABLE_NUMBER|default upper bound]
     on the number of [parameters] from 999 to 32766.
<li> Added code for the [UINT collating sequence] as an optional
     [loadable extension].
<li> Enhancements to the [CLI]:







<
<
<







31
32
33
34
35
36
37



38
39
40
41
42
43
44
<li> INSERT and UPDATE statements now always apply [column affinity]
     before computing [CHECK constraints].  This bug fix could, in
     theory, cause problems for legacy databases with unorthodox
     CHECK constraints the require the input type for an INSERT
     is different from the declared column type. See ticket
     [https://sqlite.org/src/info/86ba67afafded936|86ba67afafded936]
     for more information.



<li> Added the [sqlite3_create_filename()] and [sqlite3_free_filename()]
     interfaces to better support of [VFS shim] implementations.
<li> Increase the [SQLITE_MAX_VARIABLE_NUMBER|default upper bound]
     on the number of [parameters] from 999 to 32766.
<li> Added code for the [UINT collating sequence] as an optional
     [loadable extension].
<li> Enhancements to the [CLI]: