Documentation Source Text

Check-in [717afb7f73]

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

Comment:Add the changes to SQLITE_SOURCE_ID to the change log.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 717afb7f73e200672d3e9961154667eaac35c4218fe038797eba7a929e535368
User & Date: drh 2017-03-20 13:05:36
Improved documentation for automatic analyze using PRAGMA optimize. check-in: 1bbfd06810 user: drh tags: trunk
Add the changes to SQLITE_SOURCE_ID to the change log. check-in: 717afb7f73 user: drh tags: trunk
Merge changes from the 3.17.0 release. check-in: 3ff90dd03b user: drh tags: trunk
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/

    19     19     set aChng($nChng) [list $date $desc $options]
    20     20     set xrefChng($date) $nChng
    21     21     incr nChng
    22     22   }
    23     23   
    24     24   chng {2017-04-00 (3.18.0)} {
    25     25   <li>Added the [PRAGMA optimize] command
           26  +<li>The SQLite version identifier returned by the [sqlite_source_id()] SQL function
           27  +    and the [sqlite3_sourceid()] C API and found in the [SQLITE_SOURCE_ID] macro is
           28  +    now a 64-digit SHA3-256 hash instead of a 40-digit SHA1 hash.
    26     29   <li>Enhance the [LIKE optimization] so that it works for arbitrary expressions on 
    27     30       the left-hand side as long as the LIKE pattern on the right-hand side does not
    28     31       begin with a digit or minus sign.
    29     32   <li>Added the [sqlite3_set_last_insert_rowid()] interface and use the new interface in 
    30     33       the [FTS3], [FTS4], and [FTS5] extensions to ensure that the [sqlite3_last_insert_rowid()]
    31     34       interface always returns reasonable values.
    32     35   <li>Enhance [PRAGMA integrity_check] and [PRAGMA quick_check] so that they verify