Documentation Source Text

  all entries in a table (in other words, an optimization that helps
  "SELECT count(*) FROM table" run faster) is omitted.
}

COMPILE_OPTION {SQLITE_OMIT_BUILTIN_TEST} {
  This compile-time option has been renamed to [SQLITE_UNTESTABLE].
}

COMPILE_OPTION {SQLITE_OMIT_CASE_SENSITIVE_LIKE_PRAGMA} {
  This compile-time option disables the [PRAGMA case_sensitive_like]
  command.
}

COMPILE_OPTION {SQLITE_OMIT_CAST} {
  This option causes SQLite to omit support for the CAST operator.
}

COMPILE_OPTION {SQLITE_OMIT_CHECK} {
  This option causes SQLite to omit support for CHECK constraints.

    on the value of the case_sensitive_like pragma.
    ^When case_sensitive_like is disabled, the default LIKE behavior is
    expressed.  ^(When case_sensitive_like is enabled, case becomes
    significant.  So, for example,
    <b>'a' LIKE 'A'</b> is false but <b>'a' LIKE 'a'</b> is still true.)^</p>

    <p>^This pragma uses [sqlite3_create_function()] to overload the
    LIKE functions, which may override previous implementations
    of LIKE registered by the application.  For example, if the application
    is compiled with the [SQLITE_ENABLE_ICU|ICU Extension] which substitutes its
    own LIKE operators that understand Unicode case folding, then invoking
    this pragma will cause LIKE to revert to its default behavior of only
    doing case folding for ASCII characters.

    <p>^(This pragma
    only changes the behavior of the SQL [LIKE] operator.  It does not
    change the behavior of the [sqlite3_strlike()] C-language interface,
    which is always case insensitive.)^  The GLOB operator is always
    case sensitive and is not affected by this PRAGMA.</p>

    <p>If the database schema contains LIKE operators, for example in CHECK
    constraints of table definitions or in the WHERE clause of a
    [partial index], then changing the meaning of the LIKE operator using
    this pragma might cause indexes to disagree with their corresponding
    tables or CHECK constraints to become invalid.  This can lead to
    errors from [PRAGMA integrity_check] and/or incorrect query results
    from queries that use the affected tables or indexes.  For that
    reason, the use of this pragma is discouraged.  This pragma continues
    to be supported for legacy compatibility.  Individual applications
    can disable this pragma at compile-time using the
    [-DSQLITE_OMIT_CASE_SENSITIVE_LIKE_PRAGMA] option.  Future versions
    of SQLite are likely to deprecate this pragma.
}

Pragma cell_size_check {
    <p>^(<b>PRAGMA cell_size_check
       <br>PRAGMA cell_size_check = </b><i>boolean</i><b>;</b></p>
    <p>The cell_size_check pragma enables or disables additional sanity
    checking on database b-tree pages as they are initially read from disk.)^