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: |
eba1c4fd8155c9348ec06e1aafea5eaa |
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
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 |
︙ | ︙ |