Changeset 2363ba8

Timestamp:

05/17/2023 05:54:24 AM (12 months ago)

Author:

Xi Ruoyao <xry111@…>

Branches:

12.0, 12.1, kea, ken/TL2024, ken/tuningfonts, lazarus, lxqt, plabs/newcss, python3.11, rahul/power-profiles-daemon, renodr/vulkan-addition, trunk, xry111/llvm18, xry111/xf86-video-removal

Children:

1db852a

Parents:

8055e91

Message:

sqlite: Update to sqlite-3.42.0 and clean up CPPFLAGS

Files:

• packages.ent (modified) (1 diff)
• server/databases/sqlite.xml (modified) (3 diffs)

packages.ent

@@ -746 +746 @@
 <!ENTITY mariadb-version              "10.6.12">
 <!ENTITY postgresql-version           "15.3">
-<!ENTITY sqlite-version               "3.41.2">
+<!ENTITY sqlite-version               "3.42.0">
 <!ENTITY sqlite-year                  "2023">
-<!ENTITY sqlite-dl-version            "3410200">
-<!ENTITY sqlite-doc-version           "3410200">
+<!ENTITY sqlite-dl-version            "3420000">
+<!ENTITY sqlite-doc-version           "3420000">
 
 <!-- Chapter 23 -->

server/databases/sqlite.xml

@@ -13 +13 @@
   <!ENTITY sqlite-download-http "https://sqlite.org/&sqlite-year;/sqlite-autoconf-&sqlite-dl-version;.tar.gz">
   <!ENTITY sqlite-download-ftp  " ">
-  <!ENTITY sqlite-md5sum        "862075fd1c38324878ef809eda39edfe">
-  <!ENTITY sqlite-size          "3.0 MB">
+  <!ENTITY sqlite-md5sum        "0c5a92bc51cf07cae45b4a1e94653dea">
+  <!ENTITY sqlite-size          "3.1 MB">
   <!ENTITY sqlite-buildsize     "76 MB">
   <!ENTITY sqlite-time          "0.3 SBU (Using parallelism=4)">
 
   <!ENTITY sqlite-docs-download "https://sqlite.org/&sqlite-year;/sqlite-doc-&sqlite-doc-version;.zip">
-  <!ENTITY sqlite-docs-md5sum   "7af3b899bb9475ad1b04026bf15ec1e4">
+  <!ENTITY sqlite-docs-md5sum   "f3cb6b67a82bc586a096459085616e4f">
   <!ENTITY sqlite-docs-size     "11 MB">
 ]>
@@ -128 +128 @@
 <screen><userinput>./configure --prefix=/usr     \
             --disable-static  \
-            --enable-fts5     \
-            CPPFLAGS="-DSQLITE_ENABLE_FTS3=1            \
-                      -DSQLITE_ENABLE_FTS4=1            \
-                      -DSQLITE_ENABLE_COLUMN_METADATA=1 \
+            --enable-fts{4,5} \
+            CPPFLAGS="-DSQLITE_ENABLE_COLUMN_METADATA=1 \
                       -DSQLITE_ENABLE_UNLOCK_NOTIFY=1   \
                       -DSQLITE_ENABLE_DBSTAT_VTAB=1     \
@@ -165 +163 @@
 
     <para>
-      <parameter>--enable-fts5</parameter>: This switch enables support for
-      version 5 of the full text search extension.
-    </para>
-
-    <para>
-      <parameter>CPPFLAGS="-DSQLITE_ENABLE_FTS3=1
-      -DSQLITE_ENABLE_FTS3_TOKENIZER=1
-      -DSQLITE_ENABLE_FTS4=1
-      -DSQLITE_ENABLE_COLUMN_METADATA=1
-      -DSQLITE_SECURE_DELETE
+      <parameter>--enable-fts{4,5}</parameter>: These switches enables
+      support for version 3, 4 and 5 of the full text search (FTS)
+      extension.  Note that the <option>--enable-fts4</option> switch
+      enables support for both FTS version 4 and FTS version 3.
+    </para>
+
+    <para>
+      <parameter>CPPFLAGS="-DSQLITE_ENABLE_COLUMN_METADATA=1
       -DSQLITE_ENABLE_UNLOCK_NOTIFY=1
-      -DSQLITE_ENABLE_DBSTAT_VTAB=1"</parameter>: Applications such as
+      -DSQLITE_ENABLE_DBSTAT_VTAB=1
+      -DSQLITE_SECURE_DELETE=1
+      -DSQLITE_ENABLE_FTS3_TOKENIZER=1"</parameter>: Applications such as
       <application>SeaMonkey</application> require these options
       to be turned on.