Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | More typo fixes and enhancements to the 3.18 change log. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
fc711f28f5af7f1166fe0395b73e6eb0 |
| User & Date: | drh 2017-03-06 21:03:22 |
Context
|
2017-03-06
| ||
| 23:14 | Fix typo in the pragma optimize documentation. check-in: f61736804d user: drh tags: trunk | |
| 21:03 | More typo fixes and enhancements to the 3.18 change log. check-in: fc711f28f5 user: drh tags: trunk | |
| 20:54 | Fix a typo in the 3.18 change log. check-in: 82f55fbab0 user: drh tags: trunk | |
Changes
Changes to pages/changes.in.
27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 |
the left-hand side as long as the LIKE pattern on the right-hand side does not
begin with a digit or minus sign.
<li>Added the [sqlite3_set_last_insert_rowid()] interface and use that new interface in
the [FTS3], [FTS4], and [FTS5] extensions to ensure that the [sqlite3_last_insert_rowid()]
interface always returns reasonable values.
<li>Enhance [PRAGMA integrity_check] and [PRAGMA quick_check] so that they verify
[CHECK constraints].
<li>Enhance the query plans for joins to detect empty tables early
halt without doing unnecessary work.
<li>Various performance improvements.
<p><b>Bug Fixes:</b>
<li>Ensure that indexed expressions with collating sequences are handled correctly.
Fix for ticket [https://www.sqlite.org/src/info/eb703ba7b50c1a5|eb703ba7b50c1a5].
<li>Fix a bug in the 'start of ...' modifiers for the [date and time functions].
Ticket [https://www.sqlite.org/src/info/6097cb92745327a1|6097cb92745327a1]
}
chng {2017-02-13 (3.17.0)} {
<li>Approximately 25% better performance from the [R-Tree extension].
<ul>
<li> Uses compiler built-ins (ex: __builtin_bswap32() or _byteswap_ulong())
for byteswapping when available.
|
| > > > > > |
27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 |
the left-hand side as long as the LIKE pattern on the right-hand side does not
begin with a digit or minus sign.
<li>Added the [sqlite3_set_last_insert_rowid()] interface and use that new interface in
the [FTS3], [FTS4], and [FTS5] extensions to ensure that the [sqlite3_last_insert_rowid()]
interface always returns reasonable values.
<li>Enhance [PRAGMA integrity_check] and [PRAGMA quick_check] so that they verify
[CHECK constraints].
<li>Enhance the query plans for joins to detect empty tables early and
halt without doing unnecessary work.
<li>Enhance the [sqlite3_mprintf()] family of interfaces and the [printf SQL function]
to put comma separators at the thousands marks for integers, if the "," format modifier
is used in between the "%" and the "d" (example: "%,d").
<li>Various performance improvements.
<p><b>Bug Fixes:</b>
<li>Ensure that indexed expressions with collating sequences are handled correctly.
Fix for ticket [https://www.sqlite.org/src/info/eb703ba7b50c1a5|eb703ba7b50c1a5].
<li>Fix a bug in the 'start of ...' modifiers for the [date and time functions].
Ticket [https://www.sqlite.org/src/info/6097cb92745327a1|6097cb92745327a1]
<li>In the [RBU extension], add extra sync operations to avoid the possibility of
corruption following a power failure.
}
chng {2017-02-13 (3.17.0)} {
<li>Approximately 25% better performance from the [R-Tree extension].
<ul>
<li> Uses compiler built-ins (ex: __builtin_bswap32() or _byteswap_ulong())
for byteswapping when available.
|