Documentation Source Text

Check-in [9654c88db8]
Login

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

Overview
Comment:New updates to the change log for the 3.21.0 release.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 9654c88db80c5cf01672d199c288a6ca4fc397e30c28945e9122603fbf13fbd7
User & Date: drh 2017-10-21 20:59:53
Context
2017-10-24
12:47
Deprecate the SQLITE_RTREE_INT_ONLY compile-time option. check-in: c0722042ac user: drh tags: trunk
2017-10-21
20:59
New updates to the change log for the 3.21.0 release. check-in: 9654c88db8 user: drh tags: trunk
2017-10-18
16:08
Add new fts5vocab virtual table type - "instance" - to the changelog for 3.21. check-in: c325f3aaed user: dan tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to main.mk.

143
144
145
146
147
148
149

150
151
152
153
154
155
156
#-------------------------------------------------------------------------

# Source files for the [tclsqlite3.search] executable. 
#
SSRC = $(DOC)/search/searchc.c \
	    $(DOC)/search/parsehtml.c \
	    $(DOC)/search/fts5ext.c \

	    $(BLD)/tclsqlite3.c

# Flags to build [tclsqlite3.search] with.
#
SFLAGS = $(TCLINC) -DSQLITE_THREADSAFE=0 -DSQLITE_ENABLE_FTS5 -DSQLITE_TCLMD5 -DTCLSH -Dmain=xmain

$(TCLSH): $(SSRC)







>







143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
#-------------------------------------------------------------------------

# Source files for the [tclsqlite3.search] executable. 
#
SSRC = $(DOC)/search/searchc.c \
	    $(DOC)/search/parsehtml.c \
	    $(DOC)/search/fts5ext.c \
	    $(SRC)/src/test_md5.c \
	    $(BLD)/tclsqlite3.c

# Flags to build [tclsqlite3.search] with.
#
SFLAGS = $(TCLINC) -DSQLITE_THREADSAFE=0 -DSQLITE_ENABLE_FTS5 -DSQLITE_TCLMD5 -DTCLSH -Dmain=xmain

$(TCLSH): $(SSRC)

Changes to pages/changes.in.

51
52
53
54
55
56
57


58





59
60
61
62
63
64
65
66
67
68
69
..
81
82
83
84
85
86
87






88
89
90
91
92
93
94
<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 that large memory allocations should be avoided when possible.


<li> Added the swarm virtual table to the existing union virtual table extension.





<li> Add a new type of fts5vocab virtual table - "instance" - that provides
     direct access to an FTS5 full-text index at the lowest possible level.
<li> Remove a call to rand_s() in the Windows VFS since it was causing problems
     in Firefox on some laptops.
<li> The [https://sqlite.org/src/finfo?name=src/shell.c|src/shell.c] source code
     to the [command-line shell] is no longer under version control.  That file
     is now generated as part of the build process.
<li> Miscellaneous [microoptimizations] reduce CPU usage by about 2.1%.
<li> Bug fixes:
<ol type="a">
<li> Fix a faulty assert() statement discovered by OSSFuzz.
................................................................................
     Ticket [https://sqlite.org/src/info/aa98619ad08ddca|aa98619ad08ddca]
<li> Fix an assertion fault that could occur following
     [PRAGMA reverse_unordered_selects].
     Ticket [https://sqlite.org/src/info/cb91bf4290c211d|cb91bf4290c211d]
<li> Fix a segfault that can occur for queries that use table-valued functions
     in an IN or EXISTS subquery.
     Ticket [https://sqlite.org/src/info/b899b6042f97f5|b899b6042f97f5]






</ol>
}

chng {2017-08-24 (3.20.1)} {
<li> Fix a potential memory leak in the new [sqlite3_result_pointer()] interface.
     Ticket [https://sqlite.org/src/info/7486aa54b968e9b5|7486aa54b968e9b5].
<p><b>Hashes:</b>







>
>
|
>
>
>
>
>



|







 







>
>
>
>
>
>







51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
..
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
<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 that large memory allocations should be avoided when possible.
<li> Added the
     [https://sqlite.org/src/file/ext/misc/unionvtab.c|swarm virtual table]
     to the existing union virtual table extension.
<li> Added the 
     [https://sqlite.org/src/file/src/dbpage.c|sqlite_dbpage virtual table]
     for providing direct access to pages
     of the database file.  The source code is built into the [amalgamation] and
     is activated using the [-DSQLITE_ENABLE_DBPAGE_VTAB] compile-time option.
<li> Add a new type of fts5vocab virtual table - "instance" - that provides
     direct access to an FTS5 full-text index at the lowest possible level.
<li> Remove a call to rand_s() in the Windows VFS since it was causing problems
     in Firefox on some older laptops.
<li> The [https://sqlite.org/src/finfo?name=src/shell.c|src/shell.c] source code
     to the [command-line shell] is no longer under version control.  That file
     is now generated as part of the build process.
<li> Miscellaneous [microoptimizations] reduce CPU usage by about 2.1%.
<li> Bug fixes:
<ol type="a">
<li> Fix a faulty assert() statement discovered by OSSFuzz.
................................................................................
     Ticket [https://sqlite.org/src/info/aa98619ad08ddca|aa98619ad08ddca]
<li> Fix an assertion fault that could occur following
     [PRAGMA reverse_unordered_selects].
     Ticket [https://sqlite.org/src/info/cb91bf4290c211d|cb91bf4290c211d]
<li> Fix a segfault that can occur for queries that use table-valued functions
     in an IN or EXISTS subquery.
     Ticket [https://sqlite.org/src/info/b899b6042f97f5|b899b6042f97f5]
<li> Fix a potential integer overflow problem when compiling a particular
     horrendous common table expression.  This was another problem discovered
     by OSSFuzz.  Check-in [https://sqlite.org/src/info/6ee8cb6ae5|6ee8cb6ae5].
<li> Fix a potential out-of-bound read when querying a corrupt database file,
     a problem detected by Natalie Silvanovich of Google Project Zero.
     Check-in [https://sqlite.org/src/info/04925dee41a21f|04925dee41a21f].
</ol>
}

chng {2017-08-24 (3.20.1)} {
<li> Fix a potential memory leak in the new [sqlite3_result_pointer()] interface.
     Ticket [https://sqlite.org/src/info/7486aa54b968e9b5|7486aa54b968e9b5].
<p><b>Hashes:</b>

Changes to pages/compile.in.

805
806
807
808
809
810
811





812
813
814
815
816
817
818
  <li> [sqlite3_column_database_name16()] </li>
  <li> [sqlite3_column_table_name()] </li>
  <li> [sqlite3_column_table_name16()] </li>
  <li> [sqlite3_column_origin_name()] </li>
  <li> [sqlite3_column_origin_name16()] </li>
  </ul>
}






COMPILE_OPTION {SQLITE_ENABLE_DBSTAT_VTAB} {
  This option enables the [dbstat virtual table].
}

COMPILE_OPTION {SQLITE_ENABLE_EXPLAIN_COMMENTS} {
  This option adds extra logic to SQLite that inserts comment text into the







>
>
>
>
>







805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
  <li> [sqlite3_column_database_name16()] </li>
  <li> [sqlite3_column_table_name()] </li>
  <li> [sqlite3_column_table_name16()] </li>
  <li> [sqlite3_column_origin_name()] </li>
  <li> [sqlite3_column_origin_name16()] </li>
  </ul>
}

COMPILE_OPTION {SQLITE_ENABLE_DBPAGE_VTAB} {
  This option enables the 
  [https://sqlite.org/src/file/src/dbpage.c|sqlite_dbpage virtual table].
}

COMPILE_OPTION {SQLITE_ENABLE_DBSTAT_VTAB} {
  This option enables the [dbstat virtual table].
}

COMPILE_OPTION {SQLITE_ENABLE_EXPLAIN_COMMENTS} {
  This option adds extra logic to SQLite that inserts comment text into the