[pkgsrc/trunk]: pkgsrc/databases/sqlite3 Update to 3.4.0:

[wiz <wiz%pkgsrc.org@localhost>]

details:   https://anonhg.NetBSD.org/pkgsrc/rev/1e79f0326499
branches:  trunk
changeset: 530661:1e79f0326499
user:      wiz <wiz%pkgsrc.org@localhost>
date:      Tue Jul 03 17:29:57 2007 +0000

description:
Update to 3.4.0:

2007 June 18 (3.4.0)

* Fix a bug that can lead to database corruption if an SQLITE_BUSY
error occurs in the middle of an explicit transaction and that
transaction is later committed. Ticket #2409. See the
CorruptionFollowingBusyError wiki page for details.
* Fix a bug that can lead to database corruption if autovacuum mode
is on and a malloc() failure follows a CREATE TABLE or CREATE INDEX
statement which itself follows a cache overflow inside a transaction.
See ticket #2418.
* Added explicit upper bounds on the sizes and quantities of things
SQLite can process. This change might cause compatibility problems
for applications that use SQLite in the extreme, which is why the
current release is 3.4.0 instead of 3.3.18.
* Added support for Incremental BLOB I/O.
* Added the zeroblob API and the zeroblob() SQL function.
* Added support for Incremental Vacuum.
* Added the SQLITE_MIXED_ENDIAN_64BIT_FLOAT compile-time option to
suppport ARM7 processors with goofy endianness.
* Removed all instances of sprintf() and strcpy() from the core
library.
* Added support for International Components for Unicode (ICU) to
the full-text search extensions.

* In the windows OS driver, reacquire a SHARED lock if an attempt
to acquire an EXCLUSIVE lock fails. Ticket #2354
* Fix the REPLACE() function so that it returns NULL if the second
argument is an empty string. Ticket #2324.
* Document the hazards of type coversions in sqlite3_column_blob()
and related APIs. Fix unnecessary type conversions. Ticket #2321.
* Internationalization of the TRIM() function. Ticket #2323
* Use memmove() instead of memcpy() when moving between memory
regions that might overlap. Ticket #2334
* Fix an optimizer bug involving subqueries in a compound SELECT
that has both an ORDER BY and a LIMIT clause. Ticket #2339.
* Make sure the sqlite3_snprintf() interface does not zero-terminate
the buffer if the buffer size is less than 1. Ticket #2341
* Fix the built-in printf logic so that it prints "NaN" not "Inf"
for floating-point NaNs. Ticket #2345
* When converting BLOB to TEXT, use the text encoding of the main
database. Ticket #2349
* Keep the full precision of integers (if possible) when casting
to NUMERIC. Ticket #2364
* Fix a bug in the handling of UTF16 codepoint 0xE000
* Consider explicit collate clauses when matching WHERE constraints
to indices in the query optimizer. Ticket #2391
* Fix the query optimizer to correctly handle constant expressions
in the ON clause of a LEFT JOIN. Ticket #2403
* Fix the query optimizer to handle rowid comparisions to NULL
correctly. Ticket #2404
* Fix many potental segfaults that could be caused by malicious
SQL statements.

diffstat:

 databases/sqlite3/Makefile.common |  4 ++--
 databases/sqlite3/distinfo        |  8 ++++----
 2 files changed, 6 insertions(+), 6 deletions(-)

diffs (26 lines):

diff -r fbcdb83359e4 -r 1e79f0326499 databases/sqlite3/Makefile.common
--- a/databases/sqlite3/Makefile.common Tue Jul 03 17:25:22 2007 +0000
+++ b/databases/sqlite3/Makefile.common Tue Jul 03 17:29:57 2007 +0000
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile.common,v 1.12 2007/06/07 19:49:10 wiz Exp $
+# $NetBSD: Makefile.common,v 1.13 2007/07/03 17:29:57 wiz Exp $
 
-DISTNAME=      sqlite-3.3.17
+DISTNAME=      sqlite-3.4.0
 PKGNAME=       ${DISTNAME:S/-/3-/}
 CATEGORIES=    databases
 MASTER_SITES=  http://www.hwaci.com/sw/sqlite/ \
diff -r fbcdb83359e4 -r 1e79f0326499 databases/sqlite3/distinfo
--- a/databases/sqlite3/distinfo        Tue Jul 03 17:25:22 2007 +0000
+++ b/databases/sqlite3/distinfo        Tue Jul 03 17:29:57 2007 +0000
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.11 2007/06/07 19:49:10 wiz Exp $
+$NetBSD: distinfo,v 1.12 2007/07/03 17:29:57 wiz Exp $
 
-SHA1 (sqlite-3.3.17.tar.gz) = 6c968e3c608be4ab137577411869abdeffb0c3f7
-RMD160 (sqlite-3.3.17.tar.gz) = a948306fc45f7baa8cb241a6cf7e4a57c9c6468c
-Size (sqlite-3.3.17.tar.gz) = 2111281 bytes
+SHA1 (sqlite-3.4.0.tar.gz) = e3b4711a619a5af1ccb1232c76eb7534d25ab431
+RMD160 (sqlite-3.4.0.tar.gz) = ecd2406449a6817f5c42c45e39e8dacba1299bf7
+Size (sqlite-3.4.0.tar.gz) = 2214061 bytes
 SHA1 (patch-aa) = 0f6b1cd63810ce06874c781dfda2d3b1531d91da