Documentation Source Text

Check-in [88de905c03]
Login

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

Overview
Comment:Update the change log and add SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION to the compile-time options documentation.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 88de905c031c51fabc7e88b163c4cd0613fcf62a
User & Date: drh 2016-08-04 14:08:03
Context
2016-08-08
13:41
Final changes for the 3.14 release. check-in: bc4407518b user: drh tags: trunk
2016-08-04
14:08
Update the change log and add SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION to the compile-time options documentation. check-in: 88de905c03 user: drh tags: trunk
2016-08-02
12:52
Update the documentation generator to keep track of historical requirement numbers and use that database to print the text of stale requirement numbers. check-in: ec99d82068 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/changes.in.

    53     53   <li>Allow [table-valued functions] to appear on the right-hand side of an [IN operator].
    54     54   <li>Created the [dbhash.exe] command-line utility.
    55     55   <li>Added two new C-language interfaces: [sqlite3_expanded_sql()] and
    56     56       [sqlite3_trace_v2()].  These new interfaces subsume the functions of
    57     57       [sqlite3_trace()] and [sqlite3_profile()] which are now deprecated.
    58     58   <li>Added the [json_quote()] SQL function to [the json1 extension].
    59     59   <li>Disable the [sqlite3_set_authorizer|authorizer callback] while reparsing the schema.
           60  +<li>Added the [SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION] compile-time option and turned that
           61  +    option on by default when building the [command-line shell].
    60     62   <p><b>Bug Fixes:</b>
    61     63   <li>Fix the [ALTER TABLE] command so that it does not corrupt [descending indexes]
    62     64       when adding a column to a [legacy_file_format|legacy file format] database.  Ticket
    63     65       [https://www.sqlite.org/src/info/f68bf68513a1c15f|f68bf68513a1c15f]
    64     66   <li>Fix a NULL-pointer dereference/crash that could occurs when a transitive WHERE
    65     67       clause references a non-existent collating sequence.  Ticket
    66     68       [https://www.sqlite.org/src/info/e8d439c77685eca6|e8d439c77685eca6].

Changes to pages/compile.in.

   903    903     <p>If this option is defined, then it must also be 
   904    904     defined when using the 'lemon' tool to generate a parse.c
   905    905     file. Because of this, this option may only be used when the library is built
   906    906     from source, not from the [amalgamation] or from the collection of
   907    907     pre-packaged C files provided for non-Unix like platforms on the website.
   908    908     </p>
   909    909   }
          910  +
          911  +COMPILE_OPTION {SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION} {
          912  +  When the SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION compile-time option is
          913  +  activated, SQLite will suppress "unknown function" errors when running
          914  +  an [EXPLAIN] or [EXPLAIN QUERY PLAN].  Instead of throwing an error,
          915  +  SQLite will insert a substitute no-op function named "unknown()".
          916  +  The substitution of "unknown()" in place of unrecognized functions
          917  +  only occurs on [EXPLAIN] and [EXPLAIN QUERY PLAN], not on ordinary
          918  +  statements.
          919  +  <p>
          920  +  When used in the [command-line shell], the
          921  +  SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION feature allows SQL text that contains
          922  +  application-defined functions to be pasted into the shell for 
          923  +  analysis and debugging without having to create and load an
          924  +  extension that implements the application-defined functions.
          925  +}
   910    926   
   911    927   COMPILE_OPTION {SQLITE_ENABLE_UNLOCK_NOTIFY} {
   912    928     This option enables the [sqlite3_unlock_notify()] interface and
   913    929     its associated functionality.  See the documentation titled
   914    930     [Using the SQLite Unlock Notification Feature] for additional
   915    931     information.
   916    932   }