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: |
18e8d6c07706e40f4d904321dc6ce185 |
| 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
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]:
|