Documentation Source Text

Check-in [eba1c4fd81]
Login

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

Overview
Comment:Update the change log with recent bug fixes.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: eba1c4fd8155c9348ec06e1aafea5eaa3b7d9545ed110ce632fb980ca937cc52
User & Date: drh 2018-09-10 14:56:02.097
Context
2018-09-11
18:17
Updates to the change log. (check-in: 5c91ca999e user: drh tags: trunk)
2018-09-10
14:56
Update the change log with recent bug fixes. (check-in: eba1c4fd81 user: drh tags: trunk)
2018-09-06
21:37
Improvements to the RENAME COLUMN syntax diagram. (check-in: c951c8c482 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
50
51
52
53
54
55
56






57
58
59
60
61
62
63






64
65
66
67
68
69
70
     a single mutex shared among them all, for slightly better concurrency
     in multi-threaded environments.
<li> Enhance the [PRAGMA integrity_check] command for improved detection
     of problems on the page freelist.
<li> Output infinity as 1e999 in the ".dump" command of the
     [command-line shell].
<p><b>Bug fixes:</b>






<li> On an UPSERT when the order of constraint checks is rearranged,
     ensure that the affinity transformations on the inserted content
     occur before any of the constraint checks. Fix for ticket
     [https://www.sqlite.org/src/info/79cad5e4b2e219dd197242e9e|79cad5e4b2e219dd197242e9e].
<li> Avoid using a prepared statement for ".stats on" command of the
     [CLI] after it has been closed by the ".eqp full" logicc. Fix for ticket
     [https://www.sqlite.org/src/info/7be932dfa60a8a6b3b26bcf76|7be932dfa60a8a6b3b26bcf76].






}

chng {2018-06-04 (3.24.0)} {
<li> Add support for PostgreSQL-style [UPSERT].
<li> Add support for [auxiliary columns in r-tree tables].
<li> Add C-language APIs for discovering SQL keywords used by
     SQLite: [sqlite3_keyword_count()], [sqlite3_keyword_name()], and







>
>
>
>
>
>







>
>
>
>
>
>







50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
     a single mutex shared among them all, for slightly better concurrency
     in multi-threaded environments.
<li> Enhance the [PRAGMA integrity_check] command for improved detection
     of problems on the page freelist.
<li> Output infinity as 1e999 in the ".dump" command of the
     [command-line shell].
<p><b>Bug fixes:</b>
<li> The ORDER BY LIMIT optimization might have caused an infinite loop
     in the byte code of the prepared statement under very obscure
     circumstances,
     due to a confluence of minor defects in the query optimizer.
     Fix for ticket
     [https://www.sqlite.org/src/info/9936b2fa443fec03ff25|9936b2fa443fec03ff25]
<li> On an UPSERT when the order of constraint checks is rearranged,
     ensure that the affinity transformations on the inserted content
     occur before any of the constraint checks. Fix for ticket
     [https://www.sqlite.org/src/info/79cad5e4b2e219dd197242e9e|79cad5e4b2e219dd197242e9e].
<li> Avoid using a prepared statement for ".stats on" command of the
     [CLI] after it has been closed by the ".eqp full" logicc. Fix for ticket
     [https://www.sqlite.org/src/info/7be932dfa60a8a6b3b26bcf76|7be932dfa60a8a6b3b26bcf76].
<li> The LIKE optimization was generating incorrect byte-code and hence
     getting the wrong answer
     if the left-hand operand has numeric affinity and the right-hand-side
     pattern is '/%' or if the pattern begins with the ESCAPE character.
     Fix for ticket
     [https://www.sqlite.org/src/info/c94369cae9b561b1f996d0054b|c94369cae9b561b1f996d0054b]
}

chng {2018-06-04 (3.24.0)} {
<li> Add support for PostgreSQL-style [UPSERT].
<li> Add support for [auxiliary columns in r-tree tables].
<li> Add C-language APIs for discovering SQL keywords used by
     SQLite: [sqlite3_keyword_count()], [sqlite3_keyword_name()], and