Accepting request 236322 from home:AndreasStieger:branches:server:database

SQlite 3.8.5

OBS-URL: https://build.opensuse.org/request/show/236322
OBS-URL: https://build.opensuse.org/package/show/server:database/sqlite3?expand=0&rev=102

sqlite-autoconf-3080403.tar.gz

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

sqlite-autoconf-3080500.tar.gz

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

sqlite-doc-3080403.zip

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

sqlite-doc-3080500.zip

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

sqlite3.changes

@@ -1,3 +1,56 @@
+-------------------------------------------------------------------
+Wed Jun  4 20:00:01 UTC 2014 - andreas.stieger@gmx.de
+
+- SQlite 3.8.5
+- New and improved:
+  * Added support for partial sorting by index.
+  * Enhance the query planner so that it always prefers an index
+    that uses a superset of WHERE clause terms relative to some
+    other index.
+  * Improvements to the automerge command of FTS4 to better control
+    the index size for a full-text index that is subject to a large
+    number of updates.
+  * Added the sqlite3_rtree_query_callback() interface to R-Tree
+    extension
+  * Added new URI query parameters "nolock" and "immutable".
+  * Use less memory by not remembering CHECK constraints on
+    read-only database connections.
+  * Enable the OR optimization for WITHOUT ROWID tables.
+  * Render expressions of the form "x IN (?)" (with a single value
+    in the list on the right-hand side of the IN operator) as if
+    they where "x==?", Similarly optimize "x NOT IN (?)"
+  * Add the ".system" and ".once" commands to the command-line shell
+  * Added the SQLITE_IOCAP_IMMUTABLE bit to the set of bits that
+    can be returned by the xDeviceCharacteristics method of a VFS.
+  * Added the SQLITE_TESTCTRL_BYTEORDER test control.
+- Bug Fixes:
+  * OFFSET clause ignored on queries without a FROM clause.
+  * Assertion fault on queries involving expressions of the form
+    "x IN (?)".
+  * Incorrect column datatype reported.
+  * Duplicate row returned on a query against a table with more than
+    16 indices, each on a separate column, and all used via OR-
+    connected constraints.
+  * Partial index causes assertion fault on UPDATE OR REPLACE.
+  * Crash when calling undocumented SQL function 
+    sqlite_rename_parent() with NULL parameters.
+  * ORDER BY ignored if the query has an identical GROUP BY.
+  * The group_concat(x,'') SQL function returns NULL instead of an
+    empty string when all inputs are empty strings.
+  * Fix a bug in the VDBE code generator that caused crashes when
+    doing an INSERT INTO ... SELECT statement where the number of
+    columns being inserted is larger than the number of columns in
+    the destination table.
+  * Fix a problem in CSV import in the command-line shell where if
+    the leftmost field of the first row in the CSV file was both
+    zero bytes in size and unquoted no data would be imported.
+  * Fix a problem in FTS4 where the left-most column that contained
+    the notindexed column name as a prefix was not indexed rather
+    than the column whose name matched exactly.
+  * Fix the sqlite3_db_readonly() interface so that it returns
+    true if the database is read-only due to the file format write
+    version number being too large.
+
 -------------------------------------------------------------------
 Wed Apr 23 08:12:14 UTC 2014 - tittiatcoke@gmail.com
 

sqlite3.spec

@@ -21,9 +21,9 @@
 %define oname sqlite
 
 Name:           %pname
-Version:        3.8.4.3
+Version:        3.8.5
 Release:        0
-%define tarversion 3080403
+%define tarversion 3080500
 Summary:        Embeddable SQL Database Engine
 License:        SUSE-Public-Domain
 Group:          Productivity/Databases/Servers