head 1.5; access; symbols pkgsrc-2013Q2:1.5.0.50 pkgsrc-2013Q2-base:1.5 pkgsrc-2012Q4:1.5.0.48 pkgsrc-2012Q4-base:1.5 pkgsrc-2011Q4:1.5.0.46 pkgsrc-2011Q4-base:1.5 pkgsrc-2011Q2:1.5.0.44 pkgsrc-2011Q2-base:1.5 pkgsrc-2009Q4:1.5.0.42 pkgsrc-2009Q4-base:1.5 pkgsrc-2008Q4:1.5.0.40 pkgsrc-2008Q4-base:1.5 pkgsrc-2008Q3:1.5.0.38 pkgsrc-2008Q3-base:1.5 cube-native-xorg:1.5.0.36 cube-native-xorg-base:1.5 pkgsrc-2008Q2:1.5.0.34 pkgsrc-2008Q2-base:1.5 pkgsrc-2008Q1:1.5.0.32 pkgsrc-2008Q1-base:1.5 pkgsrc-2007Q4:1.5.0.30 pkgsrc-2007Q4-base:1.5 pkgsrc-2007Q3:1.5.0.28 pkgsrc-2007Q3-base:1.5 pkgsrc-2007Q2:1.5.0.26 pkgsrc-2007Q2-base:1.5 pkgsrc-2007Q1:1.5.0.24 pkgsrc-2007Q1-base:1.5 pkgsrc-2006Q4:1.5.0.22 pkgsrc-2006Q4-base:1.5 pkgsrc-2006Q3:1.5.0.20 pkgsrc-2006Q3-base:1.5 pkgsrc-2006Q2:1.5.0.18 pkgsrc-2006Q2-base:1.5 pkgsrc-2006Q1:1.5.0.16 pkgsrc-2006Q1-base:1.5 pkgsrc-2005Q4:1.5.0.14 pkgsrc-2005Q4-base:1.5 pkgsrc-2005Q3:1.5.0.12 pkgsrc-2005Q3-base:1.5 pkgsrc-2005Q2:1.5.0.10 pkgsrc-2005Q2-base:1.5 pkgsrc-2005Q1:1.5.0.8 pkgsrc-2005Q1-base:1.5 pkgsrc-2004Q4:1.5.0.6 pkgsrc-2004Q4-base:1.5 pkgsrc-2004Q3:1.5.0.4 pkgsrc-2004Q3-base:1.5 pkgsrc-2004Q2:1.5.0.2 pkgsrc-2004Q2-base:1.5 pkgsrc-2004Q1:1.4.0.2 pkgsrc-2004Q1-base:1.4 pkgsrc-2003Q4:1.2.0.2 pkgsrc-2003Q4-base:1.2 buildlink2-base:1.2; locks; strict; comment @# @; 1.5 date 2004.03.31.05.50.17; author snj; state dead; branches; next 1.4; 1.4 date 2003.12.30.14.41.09; author cjep; state Exp; branches; next 1.3; 1.3 date 2003.12.29.20.03.31; author cjep; state Exp; branches; next 1.2; 1.2 date 2001.12.05.02.04.06; author reinoud; state dead; branches; next 1.1; 1.1 date 2001.10.20.18.52.38; author reinoud; state Exp; branches; next ; desc @@ 1.5 log @Update to sqlite-2.8.13. Closes PR pkg/24660. FreeBSD 4 portability hint from Michal Pasternak. Some of the changes since 2.8.5 include: * Refactor parts of the code in order to make the code footprint smaller. The code is now also a little bit faster. * The built-in min() and max() functions now honor the difference between NUMERIC and TEXT datatypes. * New HH:MM:SS modifier to the built-in date/time functions. * Add function prototypes for the database encryption API. * Fix a bug that might corrupt the rollback journal if a power failure or external program halt occurs in the middle of a COMMIT. * Reduce the size and increase the speed of various modules. * Fix a potential database corruption problem on Unix. * Fix a 32-bit integer overflow problem that could result in corrupt indices in a database if large negative numbers (less than -2147483648) were inserted into a indexed numeric column. * Fix a locking problem on multi-threaded Linux implementations. * Fix a critical bug introduced in 2.8.0 which could cause database corruption. * The VACUUM command now works with the non-callback API * If the name of the database is an empty string, open a new database in a temporary file that is automatically deleted when the database is closed. * Performance enhancements in the lemon-generated parser * Documentation updates and typo fixes * Removed support for the Oracle8 outer join syntax. * Allow GLOB and LIKE operators to work as functions. * Make sure the journal file directory entry is committed to disk before writing the database file. @ text @$NetBSD: patch-ad,v 1.4 2003/12/30 14:41:09 cjep Exp $ --- ../sqlite/src/btree_rb.c.orig 2003-06-29 19:29:48.000000000 +0100 +++ ../sqlite/src/btree_rb.c @@@@ -16,6 +16,7 @@@@ ** ** It was contributed to SQLite by anonymous on 2003-Feb-04 23:24:49 UTC. */ +#include "os.h" #include "btree.h" #include "sqliteInt.h" #include @ 1.4 log @Further changes for FreeBSD support from Michal Pasternak @ text @d1 1 a1 1 $NetBSD$ @ 1.3 log @Add #include's necessary for this to build on FreeBSD. From Michal Pasternak in PR#23828. @ text @@ 1.2 log @Update sqlite package to version 2.1.4 (2001-12-04) incorporating lockup bugs removal, fixing the behaviour of comparison operators so that they are consistent with the order of entries in an index, correct handling of integers in SQL expressions that are larger than what can be represented by the machine integer and locking protocol fixes. The author also incorporated my suggestions after the messy LP64 patches I made; its now a lot more clean allthough there are still a few warnings but they are checked and OK. @ text @d1 1 a1 1 $NetBSD: patch-ad,v 1.1 2001/10/20 18:52:38 reinoud Exp $ d3 5 a7 4 --- ../sqlite/src/hash.c.orig Fri Oct 12 19:30:05 2001 +++ ../sqlite/src/hash.c @@@@ -68,11 +68,11 @@@@ ** Hash and comparison functions when the mode is SQLITE_HASH_POINTER d9 4 a12 11 static int ptrHash(const void *pKey, int nKey){ - nKey = (int)pKey; + nKey = (int)pKey; /* XXX LP64 violation but since its a hash it might be ok XXX */ return nKey ^ (nKey<<8) ^ (nKey>>8); } static int ptrCompare(const void *pKey1, int n1, const void *pKey2, int n2){ - return ((int)pKey2) - (int)pKey1; + return ((char *)pKey2) - (char *)pKey1; } /* @ 1.1 log @Hmm... shouldn't have forgotten to ad the patches themselves.... (AHUM) @ text @d1 1 a1 1 $NetBSD$ @