X-Recipient: archive-cygwin AT delorie DOT com X-SWARE-Spam-Status: No, hits=-2.4 required=5.0 tests=ALL_TRUSTED,AWL,BAYES_00 X-Spam-Check-By: sourceware.org X-SWARE-Spam-Status: No, hits=-0.8 required=5.0 tests=AWL,BAYES_40,T_RP_MATCHES_RCVD Message-Id: Date: Wed, 01 Dec 2010 12:15:49 -0700 From: Warren Young User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.2.12) Gecko/20101027 Thunderbird/3.1.6 MIME-Version: 1.0 To: cygwin AT cygwin DOT com Subject: [ANNOUNCEMENT] Updated: sqlite3-3.7.3-1 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Reply-To: cygwin AT cygwin DOT com X-IsSubscribed: yes Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm List-Id: List-Subscribe: List-Archive: List-Post: List-Help: , Sender: cygwin-owner AT cygwin DOT com Mail-Followup-To: cygwin AT cygwin DOT com Delivered-To: mailing list cygwin AT cygwin DOT com PACKAGE DESCRIPTION =================== Homepage: http://sqlite.org/ License : Public Domain (no, really!) SQLite is a C library providing local database storage with a SQL interface. Unlike most SQL database systems, SQLite does not accept connections from remote users. Access to the database requires access to the file system hosting it; SQLite thus relies on the operating system's file security for access control. In exchange for this limitation, you get a smaller, faster database engine that's easy to embed within a program. CHANGES SINCE LAST RELEASE ========================== Changes since previous, 3.6.21-3: 2010 October 08 (3.7.3) * Added the sqlite3_create_function_v2() interface that includes a destructor callback. * Added support for custom r-tree queries using application- supplied callback routines to define the boundary of the query region. * The default page cache strives more diligently to avoid using memory beyond what is allocated to it by SQLITE_CONFIG_PAGECACHE. Or if using page cache is allocating from the heap, it strives to avoid going over the sqlite3_soft_heap_limit64(), even if SQLITE_ENABLE_MEMORY_MANAGEMENT is not set. * Added the sqlite3_soft_heap_limit64() interface as a replacement for sqlite3_soft_heap_limit(). * The ANALYZE command now gathers statistics on tables even if they have no indices. * Tweaks to the query planner to help it do a better job of finding the most efficient query plan for each query. * Enhanced the internal text-to-numeric conversion routines so that they work with UTF8 or UTF16, thereby avoiding some UTF16-to-UTF8 text conversions. * Fix a problem that was causing excess memory usage with large WAL transactions in win32 systems. * The interface between the VDBE and B-Tree layer is enhanced such that the VDBE provides hints to the B-Tree layer letting the B-Tree layer know when it is safe to use hashing instead of B-Trees for transient tables. * Miscellaneous documentation enhancements. 2010 August 24 (3.7.2) * Fix an old and very obscure bug that can lead to corruption of the database free-page list when incremental_vacuum is used. 2010 August 23 (3.7.1) * Added new commands SQLITE_DBSTATUS_SCHEMA_USED and SQLITE_DBSTATUS_STMT_USED to the sqlite3_db_status() interface, in order to report out the amount of memory used to hold the schema and prepared statements of a connection. * Increase the maximum size of a database pages from 32KiB to 64KiB. * Use the LIKE optimization even if the right-hand side string contains no wildcards. * Added the SQLITE_FCNTL_CHUNK_SIZE verb to the sqlite3_file_control() interface for both unix and windows, to cause database files to grow in large chunks in order to reduce disk fragmentation. * Fixed a bug in the query planner that caused performance regressions relative to 3.6.23.1 on some complex joins. * Fixed a typo in the OS/2 backend. * Refactored the pager module. * The SQLITE_MAX_PAGE_SIZE compile-time option is now silently ignored. The maximum page size is hard-coded at 65536 bytes. 2010 August 04 (3.7.0.1) * Fix a potential database corruption bug that can occur if version 3.7.0 and version 3.6.23.1 alternately write to the same database file. Ticket [51ae9cad317a1] * Fix a performance regression related to the query planner enhancements of version 3.7.0. 2010 July 22 (3.7.0) * Added support for write-ahead logging. * Query planner enhancement - automatic transient indices are created when doing so reduces the estimated query time. * Query planner enhancement - the ORDER BY becomes a no-op if the query also contains a GROUP BY clause that forces the correct output order. * Add the SQLITE_DBSTATUS_CACHE_USED verb for sqlite3_db_status(). * The logical database size is now stored in the database header so that bytes can be appended to the end of the database file without corrupting it and so that SQLite will work correctly on systems that lack support for ftruncate(). 2010 March 30 (3.6.23.1) * Fix a bug in the offsets() function of FTS3 * Fix a missing "sync" that when omitted could lead to database corruption if a power failure or OS crash occurred just as a ROLLBACK operation was finishing. 2010 March 09 (3.6.23) * Added the secure_delete pragma. * Added the sqlite3_compileoption_used() and sqlite3_compileoption_get() interfaces as well as the compile_options pragma and the sqlite_compileoption_used() and sqlite_compileoption_get() SQL functions. * Added the sqlite3_log() interface together with the SQLITE_CONFIG_LOG verb to sqlite3_config(). The ".log" command is added to the Command Line Interface. * Improvements to FTS3. * Improvements and bug-fixes in support for SQLITE_OMIT_FLOATING_POINT. * The integrity_check pragma is enhanced to detect out-of-order rowids. * The ".genfkey" operator has been removed from the Command Line Interface. * Updates to the co-hosted Lemon LALR(1) parser generator. (These updates did not affect SQLite.) * Various minor bug fixes and performance enhancements. 2010 Jan 06 (3.6.22) * Fix bugs that can (rarely) lead to incorrect query results when the CAST or OR operators are used in the WHERE clause of a query. * Continuing enhancements and improvements to FTS3. * Other miscellaneous bug fixes. INSTALL OR UPGRADE NOTES ======================== Standard install. CYGWIN INSTALLATION INFORMATION =============================== To install this package, click on the "Install Cygwin now" link on the web page. This downloads setup.exe to your system. Then, run setup and answer all of the questions. You'll find the package listed in the "All" category. After installation, read the documentation at directories: /usr/share/doc//* /usr/share/doc/Cygwin/.README If you have questions or comments, please send them to the Cygwin mailing list. CYGWIN-ANNOUNCE UNSUBSCRIBE INFO ================================ This message has been sent to cygwin-announce list. If you want to unsubscribe from the mailing list, look at the "List-Unsubscribe: " tag in the email header of this message. Send email to the address specified there. It will be in the format: cygwin-announce-unsubscribe-you=yourdomain DOT com AT cygwin DOT com More information on unsubscribing can be found: http://sources.redhat.com/lists.html#unsubscribe-simple Please read *all* of the information on unsubscribing that is available starting at the above URL. -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple