Documentation Source Text

Check-in [baac09c5a2]
Login

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

Overview
Comment:Update the change log.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: baac09c5a2384a8fe1b2cd7aa5266a6f1f05dfe0014e23c108683dd6bc076ab5
User & Date: drh 2020-02-18 20:24:59
Context
2020-02-20
04:01
Workaround for older web browsers that may not always set the 'location.origin' DOM property. check-in: 5f54ffe04b user: mistachkin tags: trunk
2020-02-18
20:24
Update the change log. check-in: baac09c5a2 user: drh tags: trunk
20:11
Fix the multi-column list display so that it works with documents that have both main and aux outputs. check-in: 4e47b407a1 user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/changes.in.

25
26
27
28
29
30
31







32
33
34
35
36
37
38
<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.







}

chng {2020-01-27 (3.31.1)} {
<li> Revert the data layout for an internal-use-only SQLite data structure.
     Applications that use SQLite should never reference internal SQLite
     data structures, but some do anyhow, and a change to one such 
     data structure in 3.30.0 broke a popular and widely-deployed







>
>
>
>
>
>
>







25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
<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.
}

chng {2020-01-27 (3.31.1)} {
<li> Revert the data layout for an internal-use-only SQLite data structure.
     Applications that use SQLite should never reference internal SQLite
     data structures, but some do anyhow, and a change to one such 
     data structure in 3.30.0 broke a popular and widely-deployed