Documentation Source Text

Check-in [12d0f93647]
Login

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.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 12d0f93647d9ee61a1d5823ca1e9fa3f2492cbd66ae10a8bdf6da893fef7e74d
User & Date: drh 2017-09-13 04:08:51.811
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
Unified Diff Ignore Whitespace Patch
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.