Hello community, here is the log from the commit of package sqlite3 checked in at Thu Apr 10 18:44:04 CEST 2008. -------- --- sqlite3/sqlite3.changes 2008-04-10 13:00:38.000000000 +0200 +++ sqlite3/sqlite3.changes 2008-04-10 18:28:59.000000000 +0200 @@ -1,0 +2,22 @@ +Thu Apr 10 16:04:31 CEST 2008 - max@suse.de + +- update to version 3.5.7. Changes include: + * Fix a bug in the register allocation for compound selects. + * Do not apply the flattening optimization if the outer query + is an aggregate and the inner query contains ORDER BY. + * Accept "Z" as the zulu timezone at the end of date strings. + * Fix a bug in the LIKE optimizer that occurs when the last + character before the first wildcard is an upper-case "Z" + * Added the "bitvec" object for keeping track of which pages + have been journalled. Improves speed and reduces memory + consumption, especially for large database files. + * Add the new sqlite3_result_error_code() API. + * Convert the underlying virtual machine to be a register-based + machine rather than a stack-based machine. The only + user-visible change is in the output of EXPLAIN. +- Fix build for Tcl 8.5. +- Don't --enable-releasemode anymore, because it recently started + putting the package version into the library name + (libsqlite3-3.5.7.so.0.8.6) + +------------------------------------------------------------------- Old: ---- fix-64bit.diff sqlite-3.5.4.tar.bz2 sqlite-load-ext.diff New: ---- sqlite-3.5.7.tar.bz2 sqlite3-tcl85.diff ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Other differences: ------------------ ++++++ sqlite3.spec ++++++ --- /var/tmp/diff_new_pack.WJ9378/_old 2008-04-10 18:43:05.000000000 +0200 +++ /var/tmp/diff_new_pack.WJ9378/_new 2008-04-10 18:43:05.000000000 +0200 @@ -1,5 +1,5 @@ # -# spec file for package sqlite3 (Version 3.5.4) +# spec file for package sqlite3 (Version 3.5.7) # # Copyright (c) 2008 SUSE LINUX Products GmbH, Nuernberg, Germany. # This file and all modifications and additions to the pristine @@ -20,8 +20,8 @@ Group: Productivity/Databases/Servers Summary: Embeddable SQL Database Engine Url: http://www.sqlite.org/ -Version: 3.5.4 -Release: 26 +Version: 3.5.7 +Release: 1 Requires: libsqlite3-0 = %version Provides: sqlite = %version Obsoletes: sqlite < %version @@ -30,9 +30,8 @@ Source2: sqlite-check_fsync_dir.c Patch0: sqlite.diff Patch2: sqlite-test-notime.diff -Patch3: fix-64bit.diff -Patch7: sqlite-load-ext.diff Patch8: disable-check.diff +Patch9: sqlite3-tcl85.diff BuildRoot: %{_tmppath}/%{name}-%{version}-build %description @@ -130,11 +129,8 @@ %setup -q -n sqlite-%version %patch0 %patch2 -%ifarch x86_64 ppc64 s390x ia64 mips64 -%patch3 -%endif -%patch7 %patch8 +%patch9 # does not work due to our ulimits in our build system rm test/bigfile.test @@ -150,7 +146,7 @@ --libdir=%_libdir \ --mandir=%_mandir \ --enable-threadsafe \ - --enable-releasemode \ + --disable-releasemode \ --enable-tempstore=yes \ --sysconfdir=/etc/ make @@ -168,9 +164,9 @@ cd build make install \ DESTDIR="$RPM_BUILD_ROOT" \ - TCLLIBDIR=%_libdir/tcl + TCLLIBDIR=%tcl_archdir echo 'package ifneeded sqlite3 %version [list load $dir/libtclsqlite3.so sqlite3]' \ - > %buildroot%_libdir/tcl/sqlite3/pkgIndex.tcl + > %buildroot%tcl_archdir/sqlite3/pkgIndex.tcl install -d $RPM_BUILD_ROOT%_mandir/man1/ install -m 0644 ../sqlite3.1 $RPM_BUILD_ROOT%_mandir/man1/ @@ -192,7 +188,7 @@ %files tcl %defattr(-,root,root) -%_libdir/tcl +%tcl_archdir %files devel %defattr(-,root,root) @@ -203,6 +199,25 @@ %_libdir/pkgconfig/sqlite3.pc %changelog +* Thu Apr 10 2008 max@suse.de +- update to version 3.5.7. Changes include: + * Fix a bug in the register allocation for compound selects. + * Do not apply the flattening optimization if the outer query + is an aggregate and the inner query contains ORDER BY. + * Accept "Z" as the zulu timezone at the end of date strings. + * Fix a bug in the LIKE optimizer that occurs when the last + character before the first wildcard is an upper-case "Z" + * Added the "bitvec" object for keeping track of which pages + have been journalled. Improves speed and reduces memory + consumption, especially for large database files. + * Add the new sqlite3_result_error_code() API. + * Convert the underlying virtual machine to be a register-based + machine rather than a stack-based machine. The only + user-visible change is in the output of EXPLAIN. +- Fix build for Tcl 8.5. +- Don't --enable-releasemode anymore, because it recently started + putting the package version into the library name + (libsqlite3-3.5.7.so.0.8.6) * Thu Apr 10 2008 ro@suse.de - added baselibs.conf file to build xxbit packages for multilib support ++++++ sqlite-3.5.4.tar.bz2 -> sqlite-3.5.7.tar.bz2 ++++++ ++++ 80424 lines of diff (skipped) ++++++ sqlite3-tcl85.diff ++++++ --- test/bind.test +++ test/bind.test @@ -211,6 +211,7 @@ DELETE FROM t1; } } {} +if 0 { do_test bind-4.4 { sqlite3_bind_double $VM 1 NaN sqlite3_bind_double $VM 2 1e300 @@ -229,7 +230,7 @@ DELETE FROM t1; } } {} - +} # NULL do_test bind-5.1 { sqlite3_bind_null $VM 1 --- test/tclsqlite.test +++ test/tclsqlite.test @@ -77,7 +77,9 @@ } msg] regsub {:.*$} $msg {} msg lappend v $msg -} {1 {syntax error in expression "x*"}} +} {1 {invalid bareword "x" +in expression "x*"; +should be "$x" or "{x}" or "x(...)" or ...}} do_test tcl-1.7 { set v [catch {db} msg] lappend v $msg --- test/types3.test +++ test/types3.test @@ -18,6 +18,9 @@ set testdir [file dirname $argv0] source $testdir/tester.tcl +set V [expr {1+12345678012345}] +set wideInt [expr {[tcl_variable_type V] eq "wideInt" ? 1 : 0}] + # A variable with only a string representation comes in as TEXT do_test types3-1.1 { set V {} @@ -30,8 +33,8 @@ set V [expr {int(1+2)}] concat [tcl_variable_type V] [execsql {SELECT typeof(:V)}] } {int integer} -set V [expr {1+12345678012345}] -if {[tcl_variable_type V]=="wideInt"} { + +if {$wideInt} { do_test types3-1.3 { set V [expr {1+123456789012345}] concat [tcl_variable_type V] [execsql {SELECT typeof(:V)}] @@ -74,10 +77,17 @@ set V [db one {SELECT 123}] tcl_variable_type V } int -do_test types3-2.3 { - set V [db one {SELECT 1234567890123456}] - tcl_variable_type V -} wideInt +if {$wideInt} { + do_test types3-2.3 { + set V [db one {SELECT 1234567890123456}] + tcl_variable_type V + } wideInt +} { + do_test types3-2.3 { + set V [db one {SELECT 1234567890123456}] + tcl_variable_type V + } int +} do_test types3-2.4.1 { set V [db one {SELECT 1234567890123456.1}] tcl_variable_type V ++++++ sqlite.diff ++++++ --- /var/tmp/diff_new_pack.WJ9378/_old 2008-04-10 18:43:09.000000000 +0200 +++ /var/tmp/diff_new_pack.WJ9378/_new 2008-04-10 18:43:09.000000000 +0200 @@ -1,14 +1,3 @@ ---- Makefile.in -+++ Makefile.in 2007/11/06 10:21:21 -@@ -308,7 +309,7 @@ - - libsqlite3.la: $(LIBOBJ) - $(LTLINK) -o libsqlite3.la $(LIBOBJ) $(LIBPTHREAD) \ -- ${ALLOWRELEASE} -rpath $(libdir) -version-info "8:6:8" -+ -rpath $(libdir) -version-info "8:6:8" - - libtclsqlite3.la: tclsqlite.lo libsqlite3.la - $(LTLINK) -o libtclsqlite3.la tclsqlite.lo \ --- test/printf.test +++ test/printf.test 2007/11/06 10:21:21 @@ -163,12 +163,6 @@ @@ -24,3 +13,23 @@ do_test printf-8.3 { sqlite3_mprintf_int64 {%llu %llu %llu} 2147483647 2147483648 4294967296 } {2147483647 2147483648 4294967296} +--- Makefile.in.orig 2008-04-07 08:53:45.000000000 +0200 ++++ Makefile.in 2008-04-07 09:10:31.000000000 +0200 +@@ -427,7 +427,7 @@ + # Rule to build the amalgamation + # + sqlite3.lo: sqlite3.c +- $(LTCOMPILE) -c $(TOP)/sqlite3.c ++ $(LTCOMPILE) -c sqlite3.c + + # Rules to build individual files + # +@@ -643,7 +643,7 @@ + testfixture$(TEXE): $(TESTFIXTURE_SRC) + $(LTLINK) -DTCLSH=1 -DSQLITE_TEST=1 -DSQLITE_CRASH_TEST=1 \ + -DSQLITE_SERVER=1 -DSQLITE_PRIVATE="" -DSQLITE_CORE $(TEMP_STORE) \ +- -o $@ $(TESTFIXTURE_SRC) $(LIBTCL) ++ -o $@ $(TESTFIXTURE_SRC) $(LIBTCL) -lpthread + + + fulltest: testfixture$(TEXE) sqlite3$(TEXE) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Remember to have fun... --------------------------------------------------------------------- To unsubscribe, e-mail: opensuse-commit+unsubscribe@opensuse.org For additional commands, e-mail: opensuse-commit+help@opensuse.org