Documentation Source Text

Check-in [506bc5fa56]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Update the change log.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 506bc5fa569a34dfeb52343a8353a0bf7d580f4d61355b559f05b0f0ec0676ea
User & Date: drh 2017-09-15 20:34:31.091
Context
2017-09-15
21:15
Minor documentation updates. (check-in: 0896528c21 user: drh tags: trunk)
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)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
31
32
33
34
35
36
37
38

39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55


56
57
58
59
60
61
62
     contains exactly one column.
<li> The "fsync()" that occurs after the header is written in a WAL reset
     now uses the sync settings for checkpoints.  This means it will use a
     "fullfsync" on macs if [PRAGMA checkpoint_fullfsync] set on.
<li> The [sqlite3_sourceid()] function tries to detect if the source code has
     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.
<li> Added the swarm virtual table to the existing union virtual table extension.


<li> Miscellaneous [microoptimizations] reduce CPU usage by about 2.0%.
<li> Bug fixes:
<ol type="a">
<li> Fix a faulty assert() statement discovered by OSSFuzz.
     Ticket [https://sqlite.org/src/info/cb91bf4290c211d|cb91bf4290c211d]
<li> Fix an obscure memory leak in [sqlite3_result_pointer()].
     Ticket [https://sqlite.org/src/info/7486aa54b968e9b|7486aa54b968e9b]







|
>




|



|








>
>







31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
     contains exactly one column.
<li> The "fsync()" that occurs after the header is written in a WAL reset
     now uses the sync settings for checkpoints.  This means it will use a
     "fullfsync" on macs if [PRAGMA checkpoint_fullfsync] set on.
<li> The [sqlite3_sourceid()] function tries to detect if the source code has
     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".  The objective is to detect accidental and/or careless
     edits.  A forger can subverted this feature.
     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
     corruption in [record format|records].
<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.
<li> Added the swarm virtual table to the existing union virtual table extension.
<li> Remove a call to rand_s() in the Windows VFS since it was causing problems
     in Firefox on some laptops.
<li> Miscellaneous [microoptimizations] reduce CPU usage by about 2.0%.
<li> Bug fixes:
<ol type="a">
<li> Fix a faulty assert() statement discovered by OSSFuzz.
     Ticket [https://sqlite.org/src/info/cb91bf4290c211d|cb91bf4290c211d]
<li> Fix an obscure memory leak in [sqlite3_result_pointer()].
     Ticket [https://sqlite.org/src/info/7486aa54b968e9b|7486aa54b968e9b]