changes.html

SQLite is a software library that implements a self-contained, serverless, zero-configuration, trans

<li>Fix a bug in windows locking code so that locks work correctly
    when simultaneously accessed by Win95 and WinNT systems.</li>
<li>Add the ability for INSERT and UPDATE statements to refer to the
    "rowid" (or "_rowid_" or "oid") columns.</li>
<li>Other important bug fixes</li>
</ul></p>
<a name="version_2_8_2"></a>
<h3>2003 May 17 (2.8.2)</h3>
<p><ul>
<li>Fix a problem that will corrupt the database file if you drop a
    table from the main database that has a TEMP index.</li>
</ul></p>
<a name="version_2_8_1"></a>
<h3>2003 May 16 (2.8.1)</h3>
<p><ul>
<li>Reactivated the VACUUM command that reclaims unused disk space in 
    a database file.</li>
<li>Added the ATTACH and DETACH commands to allow interacting with multiple
    database files at the same time.</li>
<li>Added support for TEMP triggers and indices.</li>
<li>Added support for in-memory databases.</li>
<li>Removed the experimental sqlite_open_aux_file().  Its function is
    subsumed in the new ATTACH command.</li>
<li>The precedence order for ON CONFLICT clauses was changed so that
    ON CONFLICT clauses on BEGIN statements have a higher precedence than
    ON CONFLICT clauses on constraints.
<li>Many, many bug fixes and compatibility enhancements.</li>
</ul></p>
<a name="version_2_8_0"></a>
<h3>2003 Feb 16 (2.8.0)</h3>
<p><ul>
<li>Modified the journal file format to make it more resistant to corruption
    that can occur after an OS crash or power failure.</li>
<li>Added a new C/C++ API that does not use callback for returning data.</li>
</ul></p>
<a name="version_2_7_6"></a>
<h3>2003 Jan 25 (2.7.6)</h3>
<p><ul>
<li>Performance improvements.  The library is now much faster.</li>
<li>Added the <b>sqlite_set_authorizer()</b> API.  Formal documentation has
    not been written - see the source code comments for instructions on
    how to use this function.</li>
<li>Fix a bug in the GLOB operator that was preventing it from working
    with upper-case letters.</li>
<li>Various minor bug fixes.</li>
</ul></p>
<a name="version_2_7_5"></a>
<h3>2002 Dec 27 (2.7.5)</h3>
<p><ul>
<li>Fix an uninitialized variable in pager.c which could (with a probability
    of about 1 in 4 billion) result in a corrupted database.</li>
</ul></p>
<a name="version_2_7_4"></a>
<h3>2002 Dec 17 (2.7.4)</h3>
<p><ul>
<li>Database files can now grow to be up to 2^41 bytes.  The old limit
    was 2^31 bytes.</li>
<li>The optimizer will now scan tables in the reverse if doing so will
    satisfy an ORDER BY ... DESC clause.</li>
<li>The full pathname of the database file is now remembered even if
    a relative path is passed into sqlite_open().  This allows 
    the library to continue operating correctly after a chdir().</li>
<li>Speed improvements in the VDBE.</li>
<li>Lots of little bug fixes.</li>
</ul></p>
<a name="version_2_7_3"></a>
<h3>2002 Oct 30 (2.7.3)</h3>
<p><ul>
<li>Various compiler compatibility fixes.</li>
<li>Fix a bug in the "expr IN ()" operator.</li>
<li>Accept column names in parentheses.</li>
<li>Fix a problem with string memory management in the VDBE</li>
<li>Fix a bug in the "table_info" pragma"</li>
<li>Export the sqlite_function_type() API function in the Windows DLL</li>
<li>Fix locking behavior under windows</li>
<li>Fix a bug in LEFT OUTER JOIN</li>
</ul></p>
<a name="version_2_7_2"></a>
<h3>2002 Sep 25 (2.7.2)</h3>
<p><ul>
<li>Prevent journal file overflows on huge transactions.</li>
<li>Fix a memory leak that occurred when sqlite_open() failed.</li>
<li>Honor the ORDER BY and LIMIT clause of a SELECT even if the
    result set is used for an INSERT.</li>
<li>Do not put write locks on the file used to hold TEMP tables.</li>
<li>Added documentation on SELECT DISTINCT and on how SQLite handles NULLs.</li>
<li>Fix a problem that was causing poor performance when many thousands
    of SQL statements were executed by a single sqlite_exec() call.</li>
</ul></p>
<a name="version_2_7_1"></a>
<h3>2002 Aug 31 (2.7.1)</h3>
<p><ul>
<li>Fix a bug in the ORDER BY logic that was introduced in version 2.7.0</li>
<li>C-style comments are now accepted by the tokenizer.</li>
<li>INSERT runs a little faster when the source is a SELECT statement.</li>
</ul></p>
<a name="version_2_7_0"></a>
<h3>2002 Aug 25 (2.7.0)</h3>
<p><ul>
<li>Make a distinction between numeric and text values when sorting.
    Text values sort according to memcmp().  Numeric values sort in
    numeric order.</li>
<li>Allow multiple simultaneous readers under windows by simulating
    the reader/writers locks that are missing from Win95/98/ME.</li>
<li>An error is now returned when trying to start a transaction if
    another transaction is already active.</li>
</ul></p>
<a name="version_2_6_3"></a>
<h3>2002 Aug 12 (2.6.3)</h3>
<p><ul>
<li>Add the ability to read both little-endian and big-endian databases.
    So database created under SunOS or MacOSX can be read and written
    under Linux or Windows and vice versa.</li>
<li>Convert to the new website: http://www.sqlite.org/</li>
<li>Allow transactions to span Linux Threads</li>
<li>Bug fix in the processing of the ORDER BY clause for GROUP BY queries</li>
</ul></p>
<a name="version_2_6_2"></a>
<h3>2002 Jly 30 (2.6.2)</h3>
<p><ul>
<li>Text files read by the COPY command can now have line terminators
    of LF,  CRLF, or CR.</li>
<li>SQLITE_BUSY is handled correctly if encountered during database
    initialization.</li>
<li>Fix to UPDATE triggers on TEMP tables.</li>
<li>Documentation updates.</li>
</ul></p>
<a name="version_2_6_1"></a>
<h3>2002 Jly 19 (2.6.1)</h3>
<p><ul>
<li>Include a static string in the library that responds to the RCS
    "ident" command and which contains the library version number.</li>
<li>Fix an assertion failure that occurred when deleting all rows of
    a table with the "count_changes" pragma turned on.</li>
<li>Better error reporting when problems occur during the automatic
    2.5.6 to 2.6.0 database format upgrade.</li>
</ul></p>
<a name="version_2_6_0"></a>
<h3>2002 Jly 17 (2.6.0)</h3>
<p><ul>
<li>Change the format of indices to correct a design flaw the originated
    with version 2.1.0.  <font color="red">*** This is an incompatible
    file format change ***</font>  When version 2.6.0 or later of the
    library attempts to open a database file created by version 2.5.6 or
    earlier, it will automatically and irreversibly convert the file format.
    <b>Make backup copies of older database files before opening them with
    version 2.6.0 of the library.</b>
    </li>
</ul></p>
<a name="version_2_5_6"></a>
<h3>2002 Jly 7 (2.5.6)</h3>
<p><ul>
<li>Fix more problems with rollback.  Enhance the test suite to exercise
    the rollback logic extensively in order to prevent any future problems.
    </li>
</ul></p>
<a name="version_2_5_5"></a>
<h3>2002 Jly 6 (2.5.5)</h3>
<p><ul>
<li>Fix a bug which could cause database corruption during a rollback.
    This bugs was introduced in version 2.4.0 by the freelist
    optimization of checkin &#91;410&#93;.</li>
<li>Fix a bug in aggregate functions for VIEWs.</li>
<li>Other minor changes and enhancements.</li>
</ul></p>
<a name="version_2_5_4"></a>
<h3>2002 Jly 1 (2.5.4)</h3>
<p><ul>
<li>Make the "AS" keyword optional again.</li>
<li>The datatype of columns now appear in the 4th argument to the
    callback.</li>
<li>Added the <b>sqlite_open_aux_file()</b> API, though it is still
    mostly undocumented and untested.</li>
<li>Added additional test cases and fixed a few bugs that those
    test cases found.</li>
</ul></p>
<a name="version_2_5_3"></a>
<h3>2002 Jun 24 (2.5.3)</h3>
<p><ul>
<li>Bug fix:  Database corruption can occur due to the optimization
    that was introduced in version 2.4.0 (check-in &#91;410&#93;).  The problem
    should now be fixed.  The use of versions 2.4.0 through 2.5.2 is
    not recommended.</li>
</ul></p>
<a name="version_2_5_2"></a>
<h3>2002 Jun 24 (2.5.2)</h3>
<p><ul>
<li>Added the new <b>SQLITE_TEMP_MASTER</b> table which records the schema
    for temporary tables in the same way that <b>SQLITE_MASTER</b> does for
    persistent tables.</li>
<li>Added an optimization to UNION ALL</li>
<li>Fixed a bug in the processing of LEFT OUTER JOIN</li>
<li>The LIMIT clause now works on subselects</li>
<li>ORDER BY works on subselects</li>
<li>There is a new TypeOf() function used to determine if an expression
    is numeric or text.</li>
<li>Autoincrement now works for INSERT from a SELECT.</li>
</ul></p>
<a name="version_2_5_1"></a>
<h3>2002 Jun 19 (2.5.1)</h3>
<p><ul>
<li>The query optimizer now attempts to implement the ORDER BY clause
    using an index.  Sorting is still used if not suitable index is
    available.</li>
</ul></p>
<a name="version_2_5_0"></a>
<h3>2002 Jun 17 (2.5.0)</h3>
<p><ul>
<li>Added support for row triggers.</li>
<li>Added SQL-92 compliant handling of NULLs.</li>
<li>Add support for the full SQL-92 join syntax and LEFT OUTER JOINs.</li>
<li>Double-quoted strings interpreted as column names not text literals.</li>
<li>Parse (but do not implement) foreign keys.</li>
<li>Performance improvements in the parser, pager, and WHERE clause code
    generator.</li>
<li>Make the LIMIT clause work on subqueries.  (ORDER BY still does not
    work, though.)</li>
<li>Added the "%Q" expansion to sqlite_*_printf().</li>
<li>Bug fixes too numerous to mention (see the change log).</li>
</ul></p>
<a name="version_2_4_12"></a>
<h3>2002 May 09 (2.4.12)</h3>
<p><ul>
<li>Added logic to detect when the library API routines are called out
    of sequence.</li>
</ul></p>
<a name="version_2_4_11"></a>
<h3>2002 May 08 (2.4.11)</h3>
<p><ul>
<li>Bug fix: Column names in the result set were not being generated
    correctly for some (rather complex) VIEWs.  This could cause a
    segfault under certain circumstances.</li>
</ul></p>
<a name="version_2_4_10"></a>
<h3>2002 May 02 (2.4.10)</h3>
<p><ul>
<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>
</ul></p>
<a name="version_2_4_9"></a>
<h3>2002 Apr 21 (2.4.9)</h3>
<p><ul>
<li>Fix a bug that was causing the precompiled binary of SQLITE.EXE to
    report "out of memory" under Windows 98.</li>
</ul></p>
<a name="version_2_4_8"></a>
<h3>2002 Apr 20 (2.4.8)</h3>
<p><ul>
<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>
</ul></p>
<a name="version_2_4_7"></a>
<h3>2002 Apr 06 (2.4.7)</h3>
<p><ul>
<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>
</ul></p>
<a name="version_2_4_6"></a>
<h3>2002 Apr 02 (2.4.6)</h3>
<p><ul>
<li>Bug fix: Correctly handle terms in the WHERE clause of a join that
    do not contain a comparison operator.</li>
</ul></p>
<a name="version_2_4_5"></a>
<h3>2002 Apr 01 (2.4.5)</h3>
<p><ul>
<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>
</ul></p>
<a name="version_2_4_4"></a>
<h3>2002 Mar 24 (2.