Documentation Source Text

#-------------------------------------------------------------------------

# 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)

<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>

  <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