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. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: | bb5411e37101f01352c16611eeb8609e |
| User & Date: | drh 2018-01-16 13:55:36 |
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 100 101 102 103 104 105 106 107 |
</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>
<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
|
| > > > > |
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
|