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 |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
fc711f28f5af7f1166fe0395b73e6eb0 |
User & Date: | drh 2017-03-06 21:03:22.855 |
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 | 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]. | | > > > > > | 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. |
︙ | ︙ |