Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add bug fixes to the 3.22.0 change log |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
0e0412e603b6340a372fcecfb67985fd |
| User & Date: | drh 2018-01-09 16:41:11 |
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
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.
|