Accepting request 1176758 from server:database

- Update to release 3.46.0:
  * https://sqlite.org/releaselog/3_46_0.html
  * Enhance PRAGMA optimize in multiple ways.
  * Enhancements to the date and time functions.
  * Add support for underscore ("_") characters between digits in
    numeric literals.
  * Add the json_pretty() SQL function.
  * Query planner improvements.
  * Allocate additional memory from the heap for the SQL parser
    stack if that stack overflows, rather than reporting a "parser
    stack overflow" error.
  * Allow ASCII control characters within JSON5 string literals.
  * Fix the -> and ->> JSON operators so that when the right-hand
    side operand is a string that looks like an integer it is still
    treated as a string, because that is what PostgreSQL does.
  * Obsoletes sqlite3-float-i586.patch.

OBS-URL: https://build.opensuse.org/request/show/1176758
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/sqlite3?expand=0&rev=152

sqlite-doc-3450300.zip

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

sqlite-doc-3460000.zip

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

sqlite-src-3450300.zip

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

sqlite-src-3460000.zip

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

sqlite3-float-i586.patch

@@ -1,108 +0,0 @@
-Index: test/func4.test
-==================================================================
---- test/func4.test
-+++ test/func4.test
-@@ -1,6 +1,6 @@
--# 2013 March 10
-+# 2023-03-10
- #
- # The author disclaims copyright to this source code.  In place of
- # a legal notice, here is a blessing:
- #
- #    May you do good and not evil.
-@@ -7,11 +7,14 @@
- #    May you find forgiveness for yourself and forgive others.
- #    May you share freely, never taking more than you give.
- #
- #***********************************************************************
- # This file implements regression tests for SQLite library. The focus of
--# this file is testing the tointeger() and toreal() functions.
-+# this file is testing the tointeger() and toreal() functions that are
-+# part of the "totype.c" extension.  This file does not test the core
-+# SQLite library.  Failures of tests in this file are related to the
-+# ext/misc/totype.c extension.
- #
- # Several of the toreal() tests are disabled on platforms where floating
- # point precision is not high enough to represent their constant integer
- # expression arguments as double precision floating point values.
- #
-@@ -21,10 +24,24 @@
- set tcl_precision 0
- load_static_extension db totype
- 
- set highPrecision(1) [expr \
-     {[db eval {SELECT tointeger(9223372036854775807 + 1);}] eq {{}}}]
-+set highPrecision(2) [expr \
-+    {[db eval {SELECT toreal(-9223372036854775808 + 1);}] eq {{}}}]
-+
-+# highPrecision(3) is only known to be false on i586 with gcc-13 and -O2.
-+# It is true on the exact same platform with -O0.  Both results seem
-+# reasonable, so we'll just very the expectation accordingly.
-+#
-+set highPrecision(3) [expr \
-+    {[db eval {SELECT toreal(9007199254740992 + 1);}] eq {{}}}]
-+
-+if {!$highPrecision(1) || !$highPrecision(2) || !$highPrecision(3)} {
-+  puts "NOTICE: use_long_double: [use_long_double] \
-+        highPrecision: $highPrecision(1) $highPrecision(2) $highPrecision(3)"
-+}
- 
- do_execsql_test func4-1.1 {
-   SELECT tointeger(NULL);
- } {{}}
- do_execsql_test func4-1.2 {
-@@ -193,12 +210,10 @@
- do_execsql_test func4-1.55 {
-   SELECT tointeger(18446744073709551616 + 1);
- } {{}}
- 
- ifcapable floatingpoint {
--  set highPrecision(2) [expr \
--      {[db eval {SELECT toreal(-9223372036854775808 + 1);}] eq {{}}}]
- 
-   do_execsql_test func4-2.1 {
-     SELECT toreal(NULL);
-   } {{}}
-   do_execsql_test func4-2.2 {
-@@ -339,14 +354,18 @@
-     SELECT toreal(9007199254740992 - 1);
-   } {9007199254740991.0}
-   do_execsql_test func4-2.45 {
-     SELECT toreal(9007199254740992);
-   } {9007199254740992.0}
--  if {$highPrecision(2)} {
-+  if {$highPrecision(3)} {
-+    do_execsql_test func4-2.46 {
-+      SELECT toreal(9007199254740992 + 1);
-+    } {{}}
-+  } else {
-     do_execsql_test func4-2.46 {
-       SELECT toreal(9007199254740992 + 1);
--    } {{}}
-+    } {9007199254740992.0}
-   }
-   do_execsql_test func4-2.47 {
-     SELECT toreal(9007199254740992 + 2);
-   } {9007199254740994.0}
-   do_execsql_test func4-2.48 {
-@@ -624,14 +643,18 @@
-     SELECT tointeger(toreal(9007199254740992 - 1));
-   } {9007199254740991}
-   do_execsql_test func4-5.22 {
-     SELECT tointeger(toreal(9007199254740992));
-   } {9007199254740992}
--  if {$highPrecision(2)} {
-+  if {$highPrecision(3)} {
-     do_execsql_test func4-5.23 {
-       SELECT tointeger(toreal(9007199254740992 + 1));
-     } {{}}
-+  } else {
-+    do_execsql_test func4-5.23 {
-+      SELECT tointeger(toreal(9007199254740992 + 1));
-+    } {9007199254740992}
-   }
-   do_execsql_test func4-5.24 {
-     SELECT tointeger(toreal(9007199254740992 + 2));
-   } {9007199254740994}
-   if {$highPrecision(1)} {
-

sqlite3.changes

@@ -1,3 +1,23 @@
+-------------------------------------------------------------------
+Thu May 23 19:21:24 UTC 2024 - Reinhard Max <max@suse.com>
+
+- Update to release 3.46.0:
+  * https://sqlite.org/releaselog/3_46_0.html
+  * Enhance PRAGMA optimize in multiple ways.
+  * Enhancements to the date and time functions.
+  * Add support for underscore ("_") characters between digits in
+    numeric literals.
+  * Add the json_pretty() SQL function.
+  * Query planner improvements.
+  * Allocate additional memory from the heap for the SQL parser
+    stack if that stack overflows, rather than reporting a "parser
+    stack overflow" error.
+  * Allow ASCII control characters within JSON5 string literals.
+  * Fix the -> and ->> JSON operators so that when the right-hand
+    side operand is a string that looks like an integer it is still
+    treated as a string, because that is what PostgreSQL does.
+  * Obsoletes sqlite3-float-i586.patch.
+
 -------------------------------------------------------------------
 Wed Apr 17 08:50:51 UTC 2024 - Reinhard Max <max@suse.com>
 

sqlite3.spec

@@ -17,12 +17,12 @@
 
 
 %define oname sqlite
-%define tarversion 3450300
-%define docversion 3450300
+%define tarversion 3460000
+%define docversion 3460000
 %bcond_with icu
 %bcond_without check
 Name:           sqlite3
-Version:        3.45.3
+Version:        3.46.0
 Release:        0
 Summary:        Embeddable SQL Database Engine
 License:        SUSE-Public-Domain
@@ -31,7 +31,6 @@ URL:            https://www.sqlite.org/
 Source0:        https://www.sqlite.org/2023/sqlite-src-%{tarversion}.zip
 Source1:        baselibs.conf
 Source2:        https://www.sqlite.org/2023/sqlite-doc-%{docversion}.zip
-Patch0:         sqlite3-float-i586.patch
 BuildRequires:  automake
 BuildRequires:  libtool
 BuildRequires:  pkgconfig