Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Refinements to the change log for 3.18.0. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
967d54a0f67bb1fb6b744b62674283d9 |
| User & Date: | drh 2017-03-20 12:10:59 |
Context
|
2017-03-20
| ||
| 12:26 | Merge changes from the 3.17.0 release. check-in: 3ff90dd03b user: drh tags: trunk | |
| 12:10 | Refinements to the change log for 3.18.0. check-in: 967d54a0f6 user: drh tags: trunk | |
|
2017-03-17
| ||
| 23:06 | The change log addition of the previous check-in went into the wrong release. This check-in fixes the problem. check-in: 71622aac82 user: drh tags: trunk | |
Changes
Changes to pages/changes.in.
22 23 24 25 26 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 |
}
chng {2017-04-00 (3.18.0)} {
<li>Added the [PRAGMA optimize] command
<li>Enhance the [LIKE optimization] so that it works for arbitrary expressions on
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>Added the -D[SQLITE_MAX_MEMORY]=<i>N</i> compile-time option.
<li>Added the [.sha3sum dot-command] and the [.selftest dot-command]
to the [command-line shell]
<li>Begin enforcing [SQLITE_LIMIT_VDBE_OP]. The documentation has always
warned that this limit might be enforced in the future. That day has
now come.
<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
|
| | | | |
22 23 24 25 26 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 |
}
chng {2017-04-00 (3.18.0)} {
<li>Added the [PRAGMA optimize] command
<li>Enhance the [LIKE optimization] so that it works for arbitrary expressions on
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 the 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>Added the -D[SQLITE_MAX_MEMORY]=<i>N</i> compile-time option.
<li>Added the [.sha3sum dot-command] and the [.selftest dot-command]
to the [command-line shell]
<li>Begin enforcing [SQLITE_LIMIT_VDBE_OP]. This can be used, for example, to prevent
excessively large prepared statements in systems that accept SQL queries from
untrusted users.
<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
|