Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Update the change log with recent bug fixes. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: | eba1c4fd8155c9348ec06e1aafea5eaa3b7d9545ed110ce632fb980ca937cc52 |
| User & Date: | drh 2018-09-10 14:56:02 |
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
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
|