Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Add the infinite-loop UPDATE problem to the bugfix list for 3.22.0. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA3-256: |
bb5411e37101f01352c16611eeb8609e |
User & Date: | drh 2018-01-16 13:55:36.809 |
Context
2018-01-16
| ||
17:07 | Fix typo in the CSV documentation. (check-in: a1a35a2b71 user: drh tags: trunk) | |
13:55 | Add the infinite-loop UPDATE problem to the bugfix list for 3.22.0. (check-in: bb5411e371 user: drh tags: trunk) | |
2018-01-15
| ||
18:55 | Update zipfile docs to remove the capability to insert compressed data. (check-in: 424270babe user: dan tags: trunk) | |
Changes
Changes to pages/changes.in.
︙ | ︙ | |||
93 94 95 96 97 98 99 | </ol> <li> Enhance the [SQLITE_ENABLE_UPDATE_DELETE_LIMIT] compile-time option so that it works for [WITHOUT ROWID] tables. <li> Provide the [sqlite_offset(X)] SQL function that returns the byte offset into the database file to the beginning of the record holding value X, when compiling with [-DSQLITE_ENABLE_OFFSET_SQL_FUNC]. <li> Bug fixes: | | > > > > | 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 | </ol> <li> Enhance the [SQLITE_ENABLE_UPDATE_DELETE_LIMIT] compile-time option so that it works for [WITHOUT ROWID] tables. <li> Provide the [sqlite_offset(X)] SQL function that returns the byte offset into the database file to the beginning of the record holding value X, when compiling with [-DSQLITE_ENABLE_OFFSET_SQL_FUNC]. <li> Bug fixes: <ol type='a'> <li> Infinite loop on an UPDATE that uses an OR operator in the WHERE clause. Problem introduced with 3.17.0 and reported on the mailing list about one year later. Ticket [https://www.sqlite.org/src/info/47b2581aa9bfecec|47b2581aa9bfecec]. <li> Incorrect query results when the skip-ahead-distinct optimization is used. Ticket [https://sqlite.org/src/info/ef9318757b152e3a|ef9318757b152e3a]. <li> Incorrect query results on a join with a ORDER BY DESC. Ticket [https://sqlite.org/src/info/123c9ba32130a6c9|123c9ba32130a6c9]. <li> Inconsistent result set column names between CREATE TABLE AS and a simple SELECT. Ticket |
︙ | ︙ |