Documentation Source Text

Check-in [bb5411e371]
Login

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: bb5411e37101f01352c16611eeb8609e3a8bbae653913d72cffdd485557feeef
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
Unified Diff Ignore Whitespace Patch
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