Documentation Source Text

    to the [sqlite3_db_status()] interface.
<li>Removed support for [SQLITE_ENABLE_STAT2], replacing it with the much
    more capable [SQLITE_ENABLE_STAT3] option.
<li>Enhancements to the sqlite3_analyzer utility program, including the
    --pageinfo and --stats options and support for multiplexed databases.
<li>Enhance the [sqlite3_data_count()] interface so that it can be used to
    determine if SQLITE_DONE has been seen on the prepared statement.
<li>Added the SQLITE_FCNTL_OVERWRITE file-control by which the SQLite core
    indicates to the VFS that the current transaction will overwrite the
    entire database file.
<li>Increase the default [lookaside memory allocator] allocation size from
    100 to 128 bytes.
<li>Enhanced the query planner so that it can factor terms in and out of
    OR expressions in the WHERE clause in an effort to find better indices.
<li>Added the SQLITE_DIRECT_OVERFLOW_READ compile-time option, causing overflow
    pages to be read directly from the database file, bypassing the page cache.

<li>Remove limits on the magnitude of precision and width value in the
    format specifiers of the [sqlite3_mprintf()] family of string rendering
    routines.
<li>Fix a bug that prevent [ALTER TABLE | ALTER TABLE ... RENAME] from working
    on some virtual tables in a database with a UTF16 encoding.
<li>Fix a bug in ASCII-to-float conversion that causes slow performance and
    incorrect results when converting numbers with ridiculously large exponents.

    to the [sqlite3_db_status()] interface.
<li>Removed support for [SQLITE_ENABLE_STAT2], replacing it with the much
    more capable [SQLITE_ENABLE_STAT3] option.
<li>Enhancements to the sqlite3_analyzer utility program, including the
    --pageinfo and --stats options and support for multiplexed databases.
<li>Enhance the [sqlite3_data_count()] interface so that it can be used to
    determine if SQLITE_DONE has been seen on the prepared statement.
<li>Added the [SQLITE_FCNTL_OVERWRITE] file-control by which the SQLite core
    indicates to the VFS that the current transaction will overwrite the
    entire database file.
<li>Increase the default [lookaside memory allocator] allocation size from
    100 to 128 bytes.
<li>Enhanced the query planner so that it can factor terms in and out of
    OR expressions in the WHERE clause in an effort to find better indices.
<li>Added the [SQLITE_DIRECT_OVERFLOW_READ] compile-time option, causing
    [overflow pages] to be read directly from the database file, 
    bypassing the [page cache].
<li>Remove limits on the magnitude of precision and width value in the
    format specifiers of the [sqlite3_mprintf()] family of string rendering
    routines.
<li>Fix a bug that prevent [ALTER TABLE | ALTER TABLE ... RENAME] from working
    on some virtual tables in a database with a UTF16 encoding.
<li>Fix a bug in ASCII-to-float conversion that causes slow performance and
    incorrect results when converting numbers with ridiculously large exponents.

}

COMPILE_OPTION {SQLITE_CASE_SENSITIVE_LIKE} {
  If this option is present, then the built-in [LIKE] operator will be
  case sensitive.  This same effect can be achieved at run-time using
  the [case_sensitive_like pragma].
}









COMPILE_OPTION {SQLITE_HAVE_ISNAN} {
  If this option is present, then SQLite will use the isnan() function from
  the system math library.  Without this option (the default behavior)
  SQLite uses its own internal implementation of isnan().  SQLite uses
  its own internal isnan() implementation by default because of past
  problems with system isnan() functions.

}

COMPILE_OPTION {SQLITE_CASE_SENSITIVE_LIKE} {
  If this option is present, then the built-in [LIKE] operator will be
  case sensitive.  This same effect can be achieved at run-time using
  the [case_sensitive_like pragma].
}

COMPILE_OPTION {SQLITE_DIRECT_OVERFLOW_READ} {
  When this option is present, content contained in
  [overflow pages] of the database file is read directly from disk,
  bypassing the [page cache], during read transactions.  In applications
  that do a lot of reads of large BLOBs, this option might improve read
  performance.
}

COMPILE_OPTION {SQLITE_HAVE_ISNAN} {
  If this option is present, then SQLite will use the isnan() function from
  the system math library.  Without this option (the default behavior)
  SQLite uses its own internal implementation of isnan().  SQLite uses
  its own internal isnan() implementation by default because of past
  problems with system isnan() functions.

is on the b-tree page that the record header can usually be accessed
without consulting an overflow page.  In hindsight, the designers of
the SQLite b-tree logic realize that these thresholds could have been
made much simpler.  However, the computations cannot be changed
without resulting in an incompatible file format.  And the current computations
work well, even if they are a little complex.</p>


<h3>1.6 Cell Payload Overflow Pages</h3>

<p>^When the payload of a b-tree cell is too large for the b-tree page,
the surplus is spilled onto overflow pages.  ^Overflow pages form a linked
list.  ^The first four bytes of each overflow page are a big-endian
integer which is the page number of the next page in the chain, or zero
for the final page in the chain.  ^The fifth byte through the last usable

is on the b-tree page that the record header can usually be accessed
without consulting an overflow page.  In hindsight, the designers of
the SQLite b-tree logic realize that these thresholds could have been
made much simpler.  However, the computations cannot be changed
without resulting in an incompatible file format.  And the current computations
work well, even if they are a little complex.</p>

<tcl>hd_fragment ovflpgs {overflow page} {overflow pages}</tcl>
<h3>1.6 Cell Payload Overflow Pages</h3>

<p>^When the payload of a b-tree cell is too large for the b-tree page,
the surplus is spilled onto overflow pages.  ^Overflow pages form a linked
list.  ^The first four bytes of each overflow page are a big-endian
integer which is the page number of the next page in the chain, or zero
for the final page in the chain.  ^The fifth byte through the last usable