Documentation Source Text

Check-in [0e0412e603]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Add bug fixes to the 3.22.0 change log
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 0e0412e603b6340a372fcecfb67985fd56e1ab15b6a27008b0c45f5751addb57
User & Date: drh 2018-01-09 16:41:11.041
Context
2018-01-09
19:15
Fix typo in the rtreecheck() documentation. (check-in: 68f1e1944c user: drh tags: trunk)
16:41
Add bug fixes to the 3.22.0 change log (check-in: 0e0412e603 user: drh tags: trunk)
16:04
Add mention of the fsdir() table-valued function to the change log. (check-in: a2b074857f user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
85
86
87
88
89
90
91



















92
93
94
95
96
97
98
       .open command.
</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].



















}

chng {2017-10-24 (3.21.0)} {
<li> Take advantage of the atomic-write capabilities in the 
     [https://en.wikipedia.org/wiki/F2FS|F2FS filesystem] when available, for
     greatly reduced transaction overhead.  This currently requires the
     [SQLITE_ENABLE_BATCH_ATOMIC_WRITE] compile-time option.







>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>







85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
       .open command.
</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
       [https://sqlite.org/src/info/3b4450072511e621|3b4450072511e621]
  <li> Assertion fault when doing REPLACE on an index on an expression.
       Ticket [https://sqlite.org/src/info/dc3f932f5a147771|dc3f932f5a147771]
  <li> Assertion fault when doing an IN operator on a constant index.
       Ticket [https://sqlite.org/src/info/aa98619ad08ddcab|aa98619ad08ddcab]
</ol>
<p><b>Hashes:</b>
<li>SQLITE_SOURCE_ID: <i>Pending</i>
<li>SHA3-256 for sqlite3.c: <i>Pending</i>

}

chng {2017-10-24 (3.21.0)} {
<li> Take advantage of the atomic-write capabilities in the 
     [https://en.wikipedia.org/wiki/F2FS|F2FS filesystem] when available, for
     greatly reduced transaction overhead.  This currently requires the
     [SQLITE_ENABLE_BATCH_ATOMIC_WRITE] compile-time option.