Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Another bullet on the 3.12.0 change log. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
1b4e717575ff9a2e0c8644aab4844815 |
| User & Date: | drh 2016-03-09 16:03:43 |
Context
|
2016-03-09
| ||
| 20:54 | Update the fts5 documentation for the 'usermerge' option and 'merge' command. check-in: 9ed173645f user: dan tags: trunk | |
| 16:03 | Another bullet on the 3.12.0 change log. check-in: 1b4e717575 user: drh tags: trunk | |
| 15:56 | Updates to the change log for 3.12.0. check-in: 92353888aa user: drh tags: trunk | |
Changes
Changes to pages/changes.in.
40 41 42 43 44 45 46 47 48 49 50 51 52 53 |
<li>The query planner is able to optimize IN operators on [virtual tables]
even if the [xBestIndex] method does not set the
sqlite3_index_constraint_usage.omit flag of the
virtual table column to the left of the IN operator.
<li>The query planner now does a better job of optimizing [virtual table]
accesses in a 3-way or higher join where constraints on the virtual
table are split across two or more other terms of the join.
<p><b>New Features:</b>
<li>Added the [SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER] option to [sqlite3_db_config()]
which allows the two-argument version of the [fts3_tokenizer()] SQL function to
be enabled or disabled at run-time.
<li>The [PRAGMA defer_foreign_keys=ON] statement now also disables
[foreign key actions|RESTRICT actions] on foreign key.
<li>Added the [SQLITE_DEFAULT_SYNCHRONOUS] and [SQLITE_DEFAULT_WAL_SYNCHRONOUS]
|
> |
40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 |
<li>The query planner is able to optimize IN operators on [virtual tables]
even if the [xBestIndex] method does not set the
sqlite3_index_constraint_usage.omit flag of the
virtual table column to the left of the IN operator.
<li>The query planner now does a better job of optimizing [virtual table]
accesses in a 3-way or higher join where constraints on the virtual
table are split across two or more other terms of the join.
<li>Reduce the amount of memory needed to hold the schema.
<p><b>New Features:</b>
<li>Added the [SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER] option to [sqlite3_db_config()]
which allows the two-argument version of the [fts3_tokenizer()] SQL function to
be enabled or disabled at run-time.
<li>The [PRAGMA defer_foreign_keys=ON] statement now also disables
[foreign key actions|RESTRICT actions] on foreign key.
<li>Added the [SQLITE_DEFAULT_SYNCHRONOUS] and [SQLITE_DEFAULT_WAL_SYNCHRONOUS]
|