Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add a line to the change log for the recent pragma integrity_check enhancement. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
12d0f93647d9ee61a1d5823ca1e9fa3f |
| User & Date: | drh 2017-09-13 04:08:51 |
Context
|
2017-09-15
| ||
| 20:34 | Update the change log. check-in: 506bc5fa56 user: drh tags: trunk | |
|
2017-09-13
| ||
| 04:08 | Add a line to the change log for the recent pragma integrity_check enhancement. check-in: 12d0f93647 user: drh tags: trunk | |
|
2017-09-12
| ||
| 00:44 | Update the virtual table documentation with information about the new operators passed into xBestIndex. check-in: bd399e9806 user: drh tags: trunk | |
Changes
Changes to pages/changes.in.
36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 |
been modified from what is checked into version control and if there are
modifications, the last four characters of the version hash are shown as
"alt1" or "alt2". This mechanism is easily subverted by a forger. The
goal is to detect accidental edits.
<li> Improved de-quoting of column names for [CREATE TABLE AS] statements with
an aggregate query on the right-hand side.
<li> Fewer "stat()" system calls issued by the unix VFS.
<li> Query planner enhancements:
<ol type="a">
<li> Enhanced the [LIKE optimization] so that it works with an ESCAPE clause.
</ol>
<li> Pass information about !=, IS, IS NOT, NOT NULL, and IS NULL constraints
into the [xBestIndex] method of virtual tables.
<li> Enhanced the [CSV virtual table] so that it accepts the last row of
input if the final new-line character is missing.
<li> Remove the rarely-used "scratch" memory allocator. Replace it with the
[SQLITE_CONFIG_SMALL_MALLOC] configuration setting that gives SQLite
a hint large memory allocations should be avoided when possible.
|
| | | | > |
36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 |
been modified from what is checked into version control and if there are
modifications, the last four characters of the version hash are shown as
"alt1" or "alt2". This mechanism is easily subverted by a forger. The
goal is to detect accidental edits.
<li> Improved de-quoting of column names for [CREATE TABLE AS] statements with
an aggregate query on the right-hand side.
<li> Fewer "stat()" system calls issued by the unix VFS.
<li> Enhanced the [LIKE optimization] so that it works with an ESCAPE clause.
<li> Enhance [PRAGMA integrity_check] and [PRAGMA quick_check] to detect obscure
row corruption that they were formerly missing. Also update both pragmas
so that they return error text rather than SQLITE_CORRUPT when encountering
low-level corruption.
<li> Pass information about !=, IS, IS NOT, NOT NULL, and IS NULL constraints
into the [xBestIndex] method of virtual tables.
<li> Enhanced the [CSV virtual table] so that it accepts the last row of
input if the final new-line character is missing.
<li> Remove the rarely-used "scratch" memory allocator. Replace it with the
[SQLITE_CONFIG_SMALL_MALLOC] configuration setting that gives SQLite
a hint large memory allocations should be avoided when possible.
|