Accepting request 149874 from server:database

- New Version 3.7.15.2:
  * Added the sqlite3_errstr() interface.
  * Avoid invoking the sqlite3_trace() callback multiple times
    when a statement is automatically reprepared due to
    SQLITE_SCHEMA errors.
  * Enhance IN operator processing to make use of indices with
    numeric affinities.
  * Do full-table scans using covering indices when possible,
    under the theory that an index will be smaller and hence can
    be scanned with less I/O.
  * Enhance the query optimizer so that ORDER BY clauses are more
    aggressively optimized, especially in joins where various
    terms of the ORDER BY clause come from separate tables of the
    join.
  * Add the ability to implement FROM clause subqueries as
    coroutines rather that manifesting the subquery into a
    temporary table.
  * Several enhancements the command-line shell.
  * Added the busy_timeout pragma.
  * Added the instr() SQL function.
  * Added the SQLITE_FCNTL_BUSYHANDLER file control, used to allow
    VFS implementations to get access to the busy handler
    callback.
  * The xDelete method in the built-in VFSes now return
    SQLITE_IOERR_DELETE_NOENT if the file to be deleted does not
  * exist.
  * Bug fix: Avoid various concurrency problems in shared cache
    mode.
  * Bug fix: Avoid a deadlock or crash if the backup API, shared
    cache, and the SQLite Encryption Extension are all used at
    once.
  * Bug fix: SQL functions created using the TCL interface honor
    the "nullvalue" setting.
  * Bug fix: Fix a 32-bit overflow problem on CREATE INDEX for
    databases larger than 16GB.
  * Bug fix: Avoid segfault when using the COLLATE operator inside
    of a CHECK constraint or view in shared cache mode.
- Use %optflags for building
- Fix debuginfo in the Tcl bindings.

OBS-URL: https://build.opensuse.org/request/show/149874
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/sqlite3?expand=0&rev=49
This commit is contained in:
Stephan Kulow 2013-01-29 06:04:02 +00:00 committed by Git OBS Bridge
commit 5fbb9e4b83
4 changed files with 51 additions and 8 deletions

View File

@ -1,3 +0,0 @@
version https://git-lfs.github.com/spec/v1
oid sha256:d46d302a63b23d9c3b80e519be12cb7d6a8d3da57bd9c119341a0aa8b3b28692
size 1832051

View File

@ -0,0 +1,3 @@
version https://git-lfs.github.com/spec/v1
oid sha256:782d16b797f6ca879f6f679ba3fb6ceb54bcb0cab65feef332058bf04b36ba8c
size 1846778

View File

@ -1,3 +1,46 @@
-------------------------------------------------------------------
Thu Jan 24 14:19:25 UTC 2013 - max@suse.com
- New Version 3.7.15.2:
* Added the sqlite3_errstr() interface.
* Avoid invoking the sqlite3_trace() callback multiple times
when a statement is automatically reprepared due to
SQLITE_SCHEMA errors.
* Enhance IN operator processing to make use of indices with
numeric affinities.
* Do full-table scans using covering indices when possible,
under the theory that an index will be smaller and hence can
be scanned with less I/O.
* Enhance the query optimizer so that ORDER BY clauses are more
aggressively optimized, especially in joins where various
terms of the ORDER BY clause come from separate tables of the
join.
* Add the ability to implement FROM clause subqueries as
coroutines rather that manifesting the subquery into a
temporary table.
* Several enhancements the command-line shell.
* Added the busy_timeout pragma.
* Added the instr() SQL function.
* Added the SQLITE_FCNTL_BUSYHANDLER file control, used to allow
VFS implementations to get access to the busy handler
callback.
* The xDelete method in the built-in VFSes now return
SQLITE_IOERR_DELETE_NOENT if the file to be deleted does not
* exist.
* Bug fix: Avoid various concurrency problems in shared cache
mode.
* Bug fix: Avoid a deadlock or crash if the backup API, shared
cache, and the SQLite Encryption Extension are all used at
once.
* Bug fix: SQL functions created using the TCL interface honor
the "nullvalue" setting.
* Bug fix: Fix a 32-bit overflow problem on CREATE INDEX for
databases larger than 16GB.
* Bug fix: Avoid segfault when using the COLLATE operator inside
of a CHECK constraint or view in shared cache mode.
- Use %optflags for building
- Fix debuginfo in the Tcl bindings.
-------------------------------------------------------------------
Fri Oct 5 07:13:36 UTC 2012 - max@suse.com

View File

@ -1,7 +1,7 @@
#
# spec file for package sqlite3
#
# Copyright (c) 2012 SUSE LINUX Products GmbH, Nuernberg, Germany.
# Copyright (c) 2013 SUSE LINUX Products GmbH, Nuernberg, Germany.
#
# All modifications and additions to the file contributed by third parties
# remain the property of their copyright owners, unless otherwise agreed
@ -17,9 +17,9 @@
Name: sqlite3
Version: 3.7.14.1
Version: 3.7.15.2
Release: 0
%define tarversion 3071401
%define tarversion 3071502
Summary: Embeddable SQL Database Engine
License: SUSE-Public-Domain
Group: Productivity/Databases/Servers
@ -114,13 +114,13 @@ database access without running a separate RDBMS process.
%setup -q -n sqlite-autoconf-%tarversion
%build
export CFLAGS="-DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_ENABLE_FTS4"
export CFLAGS="%optflags -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_ENABLE_FTS4"
%configure --disable-static
make
cd tea
export CFLAGS=-I..
export LDFLAGS=-L../.libs
%configure --with-tcl=%_libdir --with-system-sqlite
%configure --with-tcl=%_libdir --enable-symbols --with-system-sqlite
%install
make install DESTDIR=%buildroot