<li>Bug fix: Generate correct column headers when a compound SELECT is used    as a subquery.</li><li>Added the sqlite_encode_binary() and sqlite_decode_binary() functions to    the source tree.  But they are not yet linked into the library.</li><li>Documentation updates.</li><li>Export the sqlite_changes() function from windows DLLs.</li><li>Bug fix: Do not attempt the subquery flattening optimization on queries    that lack a FROM clause.  To do so causes a segfault.</li>}chng {2002 Apr 21 (2.4.9)} {<li>Fix a bug that was causing the precompiled binary of SQLITE.EXE to    report "out of memory" under Windows 98.</li>}chng {2002 Apr 20 (2.4.8)} {<li>Make sure VIEWs are created after their corresponding TABLEs in the    output of the <b>.dump</b> command in the shell.</li><li>Speed improvements: Do not do synchronous updates on TEMP tables.</li><li>Many improvements and enhancements to the shell.</li><li>Make the GLOB and LIKE operators functions that can be overridden    by a programmer.  This allows, for example, the LIKE operator to    be changed to be case sensitive.</li>}chng {2002 Apr 06 (2.4.7)} {<li>Add the ability to put TABLE.* in the column list of a    SELECT statement.</li><li>Permit SELECT statements without a FROM clause.</li><li>Added the <b>last_insert_rowid()</b> SQL function.</li><li>Do not count rows where the IGNORE conflict resolution occurs in    the row count.</li><li>Make sure functions expressions in the VALUES clause of an INSERT    are correct.</li><li>Added the <b>sqlite_changes()</b> API function to return the number    of row that changed in the most recent operation.</li>}chng {2002 Apr 02 (2.4.6)} {<li>Bug fix: Correctly handle terms in the WHERE clause of a join that    do not contain a comparison operator.</li>}chng {2002 Apr 01 (2.4.5)} {<li>Bug fix: Correctly handle functions that appear in the WHERE clause    of a join.</li><li>When the PRAGMA vdbe_trace=ON is set, correctly print the P3 operand    value when it is a pointer to a structure rather than a pointer to    a string.</li><li>When inserting an explicit NULL into an INTEGER PRIMARY KEY, convert    the NULL value into a unique key automatically.</li>}chng {2002 Mar 24 (2.4.4)} {<li>Allow "VIEW" to be a column name</li><li>Added support for CASE expressions (patch from Dan Kennedy)</li><li>Added RPMS to the delivery (patches from Doug Henry)</li><li>Fix typos in the documentation</li><li>Cut over configuration management to a new CVS repository with    its own CVSTrac bug tracking system.</li>}chng {2002 Mar 22 (2.4.3)} {<li>Fix a bug in SELECT that occurs when a compound SELECT is used as a    subquery in the FROM of a SELECT.</li><li>The <b>sqlite_get_table()</b> function now returns an error if you    give it two or more SELECTs that return different numbers of columns.</li>}chng {2002 Mar 14 (2.4.2)} {<li>Bug fix: Fix an assertion failure that occurred when ROWID was a column    in a SELECT statement on a view.</li><li>Bug fix: Fix an uninitialized variable in the VDBE that would could an    assert failure.</li><li>Make the os.h header file more robust in detecting when the compile is    for windows and when it is for unix.</li>}chng {2002 Mar 13 (2.4.1)} {<li>Using an unnamed subquery in a FROM clause would cause a segfault.</li><li>The parser now insists on seeing a semicolon or the end of input before    executing a statement.  This avoids an accidental disaster if the    WHERE keyword is misspelled in an UPDATE or DELETE statement.</li>}chng {2002 Mar 10 (2.4.0)} {<li>Change the name of the sanity_check PRAGMA to <b>integrity_check</b>    and make it available in all compiles.</li><li>SELECT min() or max() of an indexed column with no WHERE or GROUP BY    clause is handled as a special case which avoids a complete table scan.</li><li>Automatically generated ROWIDs are now sequential.</li><li>Do not allow dot-commands of the command-line shell to occur in the    middle of a real SQL command.</li><li>Modifications to the "lemon" parser generator so that the parser tables    are 4 times smaller.</li><li>Added support for user-defined functions implemented in C.</li><li>Added support for new functions: <b>coalesce()</b>, <b>lower()</b>,    <b>upper()</b>, and <b>random()</b><li>Added support for VIEWs.</li><li>Added the subquery flattening optimizer.</li><li>Modified the B-Tree and Pager modules so that disk pages that do not    contain real data (free pages) are not journaled and are not    written from memory back to the disk when they change.  This does not     impact database integrity, since the    pages contain no real data, but it does make large INSERT operations    about 2.5 times faster and large DELETEs about 5 times faster.</li><li>Made the CACHE_SIZE pragma persistent</li><li>Added the SYNCHRONOUS pragma</li><li>Fixed a bug that was causing updates to fail inside of transactions when    the database contained a temporary table.</li>}chng {2002 Feb 18 (2.3.3)} {<li>Allow identifiers to be quoted in square brackets, for compatibility    with MS-Access.</li><li>Added support for sub-queries in the FROM clause of a SELECT.</li><li>More efficient implementation of sqliteFileExists() under Windows.    (by Joel Luscy)</li><li>The VALUES clause of an INSERT can now contain expressions, including    scalar SELECT clauses.</li><li>Added support for CREATE TABLE AS SELECT</li><li>Bug fix: Creating and dropping a table all within a single    transaction was not working.</li>}chng {2002 Feb 14 (2.3.2)} {<li>Bug fix: There was an incorrect assert() in pager.c.  The real code was    all correct (as far as is known) so everything should work OK if you    compile with -DNDEBUG=1.  When asserts are not disabled, there    could be a fault.</li>}chng {2002 Feb 13 (2.3.1)} {<li>Bug fix: An assertion was failing if "PRAGMA full_column_names=ON;" was    set and you did a query that used a rowid, like this:      "SELECT rowid, * FROM ...".</li>}chng {2002 Jan 30 (2.3.0)} {<li>Fix a serious bug in the INSERT command which was causing data to go    into the wrong columns if the data source was a SELECT and the INSERT    clauses specified its columns in some order other than the default.</li><li>Added the ability to resolve constraint conflicts is ways other than    an abort and rollback.  See the documentation on the "ON CONFLICT"    clause for details.</li><li>Temporary files are now automatically deleted by the operating system    when closed.  There are no more dangling temporary files on a program    crash.  (If the OS crashes, fsck will delete the file after reboot     under Unix.  I do not know what happens under Windows.)</li><li>NOT NULL constraints are honored.</li><li>The COPY command puts NULLs in columns whose data is '\N'.</li><li>In the COPY command, backslash can now be used to escape a newline.</li><li>Added the SANITY_CHECK pragma.</li>}chng {2002 Jan 28 (2.2.5)} {<li>Important bug fix: the IN operator was not working if either the    left-hand or right-hand side was derived from an INTEGER PRIMARY KEY.</li><li>Do not escape the backslash '\' character in the output of the    <b>sqlite</b> command-line access program.</li>}chng {2002 Jan 22 (2.2.4)} {<li>The label to the right of an AS in the column list of a SELECT can now    be used as part of an expression in the WHERE, ORDER BY, GROUP BY, and/or    HAVING clauses.</li><li>Fix a bug in the <b>-separator</b> command-line option to the <b>sqlite</b>    command.</li><li>Fix a problem with the sort order when comparing upper-case strings against    characters greater than 'Z' but less than 'a'.</li><li>Report an error if an ORDER BY or GROUP BY expression is constant.</li>}chng {2002 Jan 16 (2.2.3)} {<li>Fix warning messages in VC++ 7.0.  (Patches from nicolas352001)</li><li>Make the library thread-safe.  (The code is there and appears to work    but has not been stressed.)</li><li>Added the new <b>sqlite_last_insert_rowid()</b> API function.</li>}chng {2002 Jan 13 (2.2.2)} {<li>Bug fix: An assertion was failing when a temporary table with an index    had the same name as a permanent table created by a separate process.</li><li>Bug fix: Updates to tables containing an INTEGER PRIMARY KEY and an    index could fail.</li>}chng {2002 Jan 9 (2.2.1)} {<li>Bug fix: An attempt to delete a single row of a table with a WHERE    clause of "ROWID=x" when no such rowid exists was causing an error.</li><li>Bug fix: Passing in a NULL as the 3rd parameter to <b>sqlite_open()</b>    would sometimes cause a coredump.</li><li>Bug fix: DROP TABLE followed by a CREATE TABLE with the same name all    within a single transaction was causing a coredump.</li><li>Makefile updates from A. Rottmann</li>}chng {2001 Dec 22 (2.2.0)} {<li>Columns of type INTEGER PRIMARY KEY are actually used as the primary    key in underlying B-Tree representation of the table.</li><li>Several obscure, unrelated bugs were found and fixed while     implemented the integer primary key change of the previous bullet.</li><li>Added the ability to specify "*" as part of a larger column list in    the result section of a SELECT statement.  For example:    <nobr>"<b>SELECT rowid, * FROM table1;</b>"</nobr>.</li><li>Updates to comments and documentation.</li>}chng {2001 Dec 14 (2.1.7)} {<li>Fix a bug in <b>CREATE TEMPORARY TABLE</b> which was causing the    table to be initially allocated in the main database file instead    of in the separate temporary file.  This bug could cause the library    to suffer an assertion failure and it could cause "page leaks" in the    main database file.<li>Fix a bug in the b-tree subsystem that could sometimes cause the first    row of a table to be repeated during a database scan.</li>}chng {2001 Dec 14 (2.1.6)} {<li>Fix the locking mechanism yet again to prevent    <b>sqlite_exec()</b> from returning SQLITE_PROTOCOL    unnecessarily.  This time the bug was a race condition in    the locking code.  This change effects both POSIX and Windows users.</li>}chng {2001 Dec 6 (2.1.5)} {<li>Fix for another problem (unrelated to the one fixed in 2.1.4)     that sometimes causes <b>sqlite_exec()</b> to return SQLITE_PROTOCOL    unnecessarily.  This time the bug was    in the POSIX locking code and should not effect windows users.</li>}chng {2001 Dec 4 (2.1.4)} {<li>Sometimes <b>sqlite_exec()</b> would return SQLITE_PROTOCOL when it    should have returned SQLITE_BUSY.</li><li>The fix to the previous bug uncovered a deadlock which was also    fixed.</li><li>Add the ability to put a single .command in the second argument    of the sqlite shell</li><li>Updates to the FAQ</li>}chng {2001 Nov 23 (2.1.3)} {<li>Fix the behavior of comparison operators     (ex: "<b>&lt</b>", "<b>==</b>", etc.)    so that they are consistent with the order of entries in an index.</li><li>Correct handling of integers in SQL expressions that are larger than    what can be represented by the machine integer.</li>}chng {2001 Nov 22 (2.1.2)} {<li>Changes to support 64-bit architectures.</li><li>Fix a bug in the locking protocol.</li><li>Fix a bug that could (rarely) cause the database to become     unreadable after a DROP TABLE due to corruption to the SQLITE_MASTER    table.</li><li>Change the code so that version 2.1.1 databases that were rendered     unreadable by the above bug can be read by this version of    the library even though the SQLITE_MASTER table is (slightly)    corrupted.</li>}chng {2001 Nov 13 (2.1.1)} {<li>Bug fix: Sometimes arbitrary strings were passed to the callback    function when the actual value of a column was NULL.</li>}chng {2001 Nov 12 (2.1.0)} {<li>Change the format of data records so that records up to 16MB in size    can be stored.</li><li>Change the format of indices to allow for better query optimization.</li><li>Implement the "LIMIT ... OFFSET ..." clause on SELECT statements.</li>}chng {2001 Nov 3 (2.0.8)} {<li>Made selected parameters in API functions <b>const</b>. This should    be fully backwards compatible.</li><li>Documentation updates</li><li>Simplify the design of the VDBE by restricting the number of sorters    and lists to 1.    In practice, no more than one sorter and one list was ever used anyhow.    </li>}chng {2001 Oct 21 (2.0.7)} {<li>Any UTF-8 character or ISO8859 character can be used as part of    an identifier.</li><li>Patches from Christian Werner to improve ODBC compatibility and to    fix a bug in the round() function.</li><li>Plug some memory leaks that use to occur if malloc() failed.    We have been and continue to be memory leak free as long as    malloc() works.</li><li>Changes to some test scripts so that they work on Windows in    addition to Unix.</li>}chng {2001 Oct 19 (2.0.6)} {<li>Added the EMPTY_RESULT_CALLBACKS pragma</li><li>Support for UTF-8 and ISO8859 characters in column and table names.</li><li>Bug fix: Compute correct table names with the FULL_COLUMN_NAMES pragma    is turned on.</li>}chng {2001 Oct 14 (2.0.5)} {<li>Added the COUNT_CHANGES pragma.</li><li>Changes to the FULL_COLUMN_NAMES pragma to help out the ODBC driver.</li><li>Bug fix: "SELECT count(*)" was returning NULL for empty tables.    Now it returns 0.</li>}chng {2001 Oct 13 (2.0.4)} {<li>Bug fix: an obscure and relatively harmless bug was causing one of    the tests to fail when gcc optimizations are turned on.  This release    fixes the problem.</li>}chng {2001 Oct 13 (2.0.3)} {<li>Bug fix: the <b>sqlite_busy_timeout()</b> function was delaying 1000    times too long before failing.</li><li>Bug fix: an assertion was failing if the disk holding the database    file became full or stopped accepting writes for some other reason.    New tests were added to detect similar problems in the future.</li><li>Added new operators: <b>&amp;</b> (bitwise-and)    <b>|</b> (bitwise-or), <b>~</b> (ones-complement),    <b>&lt;&lt;</b> (shift left), <b>&gt;&gt;</b> (shift right).</li><li>Added new functions: <b>round()</b> and <b>abs()</b>.</li>}chng {2001 Oct 9 (2.0.2)} {<li>Fix two bugs in the locking protocol.  (One was masking the other.)</li><li>Removed some unused "#include <unistd.h>" that were causing problems    for VC++.</li><li>Fixed <b>sqlite.h</b> so that it is usable from C++</li><li>Added the FULL_COLUMN_NAMES pragma.  When set to "ON", the names of    columns are reported back as TABLE.COLUMN instead of just COLUMN.</li><li>Added the TABLE_INFO() and INDEX_INFO() pragmas to help support the    ODBC interface.</li><li>Added support for TEMPORARY tables and indices.</li>}chng {2001 Oct 2 (2.0.1)} {<li>Remove some C++ style comments from btree.c so that it will compile    using compilers other than gcc.</li><li>The ".dump" output from the shell does not work if there are embedded    newlines anywhere in the data.  This is an old bug that was carried    forward from version 1.0.  To fix it, the ".dump" output no longer    uses the COPY command.  It instead generates INSERT statements.</li><li>Extend the expression syntax to support "expr NOT NULL" (with a    space between the "NOT" and the "NULL") in addition to "expr NOTNULL"    (with no space).</li>}chng {2001 Sep 28 (2.0.0)} {<li>Automatically build binaries for Linux and Windows and put them on    the website.</li>}chng {2001 Sep 28 (2.0-alpha-4)} {<li>Incorporate makefile patches form A. Rottmann to use LIBTOOL</li>}chng {2001 Sep 27 (2.0-alpha-3)} {<li>SQLite now honors the UNIQUE keyword in CREATE UNIQUE INDEX.  Primary    keys are required to be unique.</li><li>File format changed back to what it was for alpha-1</li><li>Fixes to the rollback and locking behavior</li>}chng {2001 Sep 20 (2.0-alpha-2)} {<li>Initial release of version 2.0.  The idea of renaming the library    to "SQLus" was abandoned in favor of keeping the "SQLite" name and    bumping the major version number.</li><li>The pager and btree subsystems added back. They are now the only