Source-Changes archive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index][Old Index]

CVS import: src/external/public-domain/sqlite/dist



Module Name:    src
Committed By:   christos
Date:           Wed Dec 19 19:57:09 UTC 2018

Update of /cvsroot/src/external/public-domain/sqlite/dist
In directory ivanova.netbsd.org:/tmp/cvs-serv22533

Log Message:
SQLite Release 3.26.0 On 2018-12-01

 1. Optimization: When doing an UPDATE on a table with indexes on
    expressions, do not update the expression indexes if they do not
    refer to any of the columns of the table being updated.

 2. Allow the xBestIndex() method of virtual table implementations to
    return SQLITE_CONSTRAINT to indicate that the proposed query plan
    is unusable and should not be given further consideration.

 3. Added the SQLITE_DBCONFIG_DEFENSIVE option which disables the
    ability to create corrupt database files using ordinary SQL.

 4. Added support for read-only shadow tables when the
    SQLITE_DBCONFIG_DEFENSIVE option is enabled.

 5. Added the PRAGMA legacy_alter_table command, which if enabled
    causes the ALTER TABLE command to behave like older version of
    SQLite (prior to version 3.25.0) for compatibility.

 6. Added PRAGMA table_xinfo that works just like PRAGMA table_info
    except that it also shows hidden columns in virtual tables.

 7. Added the explain virtual table as a run-time loadable extension.

 8. Add a limit counter to the query planner to prevent excessive
    sqlite3_prepare() times for certain pathological SQL inputs.

 9. Added support for the sqlite3_normalized_sql() interface, when
    compiling with SQLITE_ENABLE_NORMALIZE.

10. Enhanced triggers so that they can use table-valued functions
    that exist in schemas other than the schema where the trigger is
    defined.

11. Enhancements to the CLI:
    a. Improvements to the ".help" command.
    b. The SQLITE_HISTORY environment variable, if it exists,
       specifies the name of the command-line editing history file
    c. The --deserialize option associated with opening a new
       database cause the database file to be read into memory and
       accessed using the sqlite3_deserialize() API. This simplifies
       running tests on a database without modifying the file on disk.

12. Enhancements to the geopoly extension:
    a. Always stores polygons using the binary format, which is
       faster and uses less space.
    b. Added the geopoly_regular() function.
    c. Added the geopoly_ccw() function.

13. Enhancements to the session extension:
    a. Added the SQLITE_CHANGESETAPPLY_INVERT flag
    b. Added the sqlite3changeset_start_v2() interface and the
       SQLITE_CHANGESETSTART_INVERT flag.
    c. Added the changesetfuzz.c test-case generator utility.

Status:

Vendor Tag:     SQLITE
Release Tags:   sqlite-3-26-0
                
U src/external/public-domain/sqlite/dist/sqlite3ext.h
C src/external/public-domain/sqlite/dist/sqlite3.c
U src/external/public-domain/sqlite/dist/sqlite3.h
C src/external/public-domain/sqlite/dist/shell.c

2 conflicts created by this import.
Use the following command to help the merge:

        cvs checkout -jSQLITE:yesterday -jSQLITE src/external/public-domain/sqlite/dist




Home | Main Index | Thread Index | Old Index