commit:     47ae30c1ae0a6d5c9790f348dca36afed8589714
Author:     Arfrever Frehtes Taifersar Arahesis <Arfrever <AT> Apache <DOT> Org>
AuthorDate: Mon Jul 27 00:00:00 2020 +0000
Commit:     Mike Gilbert <floppym <AT> gentoo <DOT> org>
CommitDate: Wed Jul 29 18:46:04 2020 +0000
URL:        https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=47ae30c1

dev-db/sqlite: Delete old version (3.31.1).

Signed-off-by: Arfrever Frehtes Taifersar Arahesis <Arfrever <AT> Apache.Org>
Signed-off-by: Mike Gilbert <floppym <AT> gentoo.org>

 dev-db/sqlite/Manifest                             |   3 -
 .../sqlite-3.25.0-nonfull_archive-build.patch      |  14 -
 .../files/sqlite-3.31.0-full_archive-build.patch   | 466 ---------------------
 .../sqlite-3.31.1-full_archive-architectures.patch |  72 ----
 ...sqlite-3.31.1-full_archive-security_fixes.patch | 163 -------
 ...lite-3.31.1-nonfull_archive-architectures.patch |  20 -
 ...ite-3.31.1-nonfull_archive-security_fixes.patch | 112 -----
 dev-db/sqlite/sqlite-3.31.1.ebuild                 | 392 -----------------
 8 files changed, 1242 deletions(-)

diff --git a/dev-db/sqlite/Manifest b/dev-db/sqlite/Manifest
index f1c2a7767c1..fa0381a6cca 100644
--- a/dev-db/sqlite/Manifest
+++ b/dev-db/sqlite/Manifest
@@ -1,5 +1,2 @@
-DIST sqlite-autoconf-3310100.tar.gz 2887243 BLAKE2B 
ef5d40b6e6c59a51ae95368eb9f6a938188813f89d5328ea1c1180ef35f124c14b3e83b0832ae5c2fa24cc2df352f1b0ea5f20b64d0762d50a700d9895f9a12e
 SHA512 
d85250ba5f78f0c918880f663741709aba662192f04888b2324a0df17affdf5b8540e8428c6c7315119806e7adad758ea281c9b403c0ad94ac6a9bd1b93fd617
-DIST sqlite-doc-3310100.zip 9600405 BLAKE2B 
324fb7a0a38bc56476e41504c14996e9d5d83ac659403991515413d49f5ee3aad064ccece25f52b6041ef26bf23f320a9be1b6b02c5fbe96c36372107f54fc2e
 SHA512 
5572e2c2dac30c014ef9cd60a620b7a7bb610f91a47e2890c0641540d39b9d5ce0e914ee697583130317633918b7827e2612a7cbc024f5bd6aa22ad28a78b56b
 DIST sqlite-doc-3320300.zip 9772933 BLAKE2B 
efd72c18d0398c103e3f9c4cfeb03e7794fd69691b1bcea95b74a0c5d8af22aa13abc84ce8dc5864b5f4cb79be239433933b4daca34d1adfcc6f31ce2cde66bf
 SHA512 
af9dca970b4c03c058d7d1cd55a3d11fa4b112dccac942b8660d82a7e9ba2956963fcb429eedfdc85915637c102e1f904ace98c8e0455c4120422bbd9f2f3cd0
-DIST sqlite-src-3310100.zip 12510166 BLAKE2B 
a856695e8552b8b4dcb28452fdbd48305fdb9072f9d6587f4b1f4445daf386e920eb936dcb50fdfe41a49f84b26a7c5fedcffea5acf3ba3fa935c36695d4b8ee
 SHA512 
af92a00877bcd90372d6f83a27fea12b4fe8d1155b223a6bccbccc31bb8e3d2269cd9e68f329bc55f70d1068ccbf220ff5abccea6f593fd7a3a4bdd732d1cdbe
 DIST sqlite-src-3320300.zip 12461750 BLAKE2B 
59cce74d284191cfc69ac09b6014701ddd2b7b3d7ebaad5da4ad71cc200e70285b3b201ff174819aa8dde5f610589d7947f547450334f0f17149014078316185
 SHA512 
7e027c7163a760fb9b6dbfd2e4ccffb39d4972280583fb0d7f8390017101dfed3b12a36653b3130a548ae4d04c6abb11c0a1921b6f09c54c6ae1e72fbdcb2fd4

diff --git a/dev-db/sqlite/files/sqlite-3.25.0-nonfull_archive-build.patch 
b/dev-db/sqlite/files/sqlite-3.25.0-nonfull_archive-build.patch
deleted file mode 100644
index be0a7e30dde..00000000000
--- a/dev-db/sqlite/files/sqlite-3.25.0-nonfull_archive-build.patch
+++ /dev/null
@@ -1,14 +0,0 @@
-Fix building with dlopen() not available.
-
---- /configure.ac
-+++ /configure.ac
-@@ -102,6 +102,9 @@
-   [], [enable_dynamic_extensions=yes])
- if test x"$enable_dynamic_extensions" != "xno"; then
-   AC_SEARCH_LIBS(dlopen, dl)
-+  if test "${ac_cv_search_dlopen}" = "no"; then
-+    BUILD_CFLAGS="$BUILD_CFLAGS -DSQLITE_OMIT_LOAD_EXTENSION=1"
-+  fi
- else
-   BUILD_CFLAGS="$BUILD_CFLAGS -DSQLITE_OMIT_LOAD_EXTENSION=1"
- fi

diff --git a/dev-db/sqlite/files/sqlite-3.31.0-full_archive-build.patch 
b/dev-db/sqlite/files/sqlite-3.31.0-full_archive-build.patch
deleted file mode 100644
index 9ff44c0fe7c..00000000000
--- a/dev-db/sqlite/files/sqlite-3.31.0-full_archive-build.patch
+++ /dev/null
@@ -1,466 +0,0 @@
-Move some code to libsqlite3.so to avoid duplication.
-Link executables against libsqlite3.so.
-Increase timeout for fuzzcheck.
-Fix building with dlopen() not available.
-
---- /Makefile.in
-+++ /Makefile.in
-@@ -311,6 +311,9 @@
- # Source code for extensions
- #
- SRC += \
-+  $(TOP)/ext/expert/sqlite3expert.c \
-+  $(TOP)/ext/expert/sqlite3expert.h
-+SRC += \
-   $(TOP)/ext/fts1/fts1.c \
-   $(TOP)/ext/fts1/fts1.h \
-   $(TOP)/ext/fts1/fts1_hash.c \
-@@ -363,8 +366,12 @@
-   $(TOP)/ext/rbu/sqlite3rbu.h \
-   $(TOP)/ext/rbu/sqlite3rbu.c
- SRC += \
-+  $(TOP)/ext/misc/appendvfs.c \
-+  $(TOP)/ext/misc/dbdata.c \
-   $(TOP)/ext/misc/json1.c \
--  $(TOP)/ext/misc/stmt.c
-+  $(TOP)/ext/misc/sqlar.c \
-+  $(TOP)/ext/misc/stmt.c \
-+  $(TOP)/ext/misc/zipfile.c
- 
- # Generated source code files
- #
-@@ -435,7 +442,6 @@
- # Statically linked extensions
- #
- TESTSRC += \
--  $(TOP)/ext/expert/sqlite3expert.c \
-   $(TOP)/ext/expert/test_expert.c \
-   $(TOP)/ext/misc/amatch.c \
-   $(TOP)/ext/misc/carray.c \
-@@ -461,7 +467,6 @@
-   $(TOP)/ext/misc/totype.c \
-   $(TOP)/ext/misc/unionvtab.c \
-   $(TOP)/ext/misc/wholenumber.c \
--  $(TOP)/ext/misc/zipfile.c \
-   $(TOP)/ext/userauth/userauth.c
- 
- # Source code to the library files needed by the test fixture
-@@ -639,25 +644,25 @@
- 
- libtclsqlite3.la:     tclsqlite.lo libsqlite3.la
-       $(LTLINK) -no-undefined -o $@ tclsqlite.lo \
--              libsqlite3.la @TCL_STUB_LIB_SPEC@ $(TLIBS) \
-+              libsqlite3.la @TCL_STUB_LIB_SPEC@ \
-               -rpath "$(TCLLIBDIR)" \
-               -version-info "8:6:8" \
-               -avoid-version
- 
--sqlite3$(TEXE):       shell.c sqlite3.c
--      $(LTLINK) $(READLINE_FLAGS) $(SHELL_OPT) -o $@ \
--              shell.c sqlite3.c \
--              $(LIBREADLINE) $(TLIBS) -rpath "$(libdir)"
-+sqlite3$(TEXE):       shell.c libsqlite3.la
-+      $(LTLINK) $(READLINE_FLAGS) -o $@ \
-+              shell.c libsqlite3.la \
-+              $(LIBREADLINE)
- 
--sqldiff$(TEXE):       $(TOP)/tool/sqldiff.c sqlite3.lo sqlite3.h
--      $(LTLINK) -o $@ $(TOP)/tool/sqldiff.c sqlite3.lo $(TLIBS)
-+sqldiff$(TEXE):       $(TOP)/tool/sqldiff.c libsqlite3.la
-+      $(LTLINK) -o $@ $(TOP)/tool/sqldiff.c libsqlite3.la
- 
--dbhash$(TEXE):        $(TOP)/tool/dbhash.c sqlite3.lo sqlite3.h
--      $(LTLINK) -o $@ $(TOP)/tool/dbhash.c sqlite3.lo $(TLIBS)
-+dbhash$(TEXE):        $(TOP)/tool/dbhash.c libsqlite3.la
-+      $(LTLINK) -o $@ $(TOP)/tool/dbhash.c libsqlite3.la
- 
--scrub$(TEXE): $(TOP)/ext/misc/scrub.c sqlite3.lo
-+scrub$(TEXE): $(TOP)/ext/misc/scrub.c libsqlite3.la
-       $(LTLINK) -o $@ -I. -DSCRUB_STANDALONE \
--              $(TOP)/ext/misc/scrub.c sqlite3.lo $(TLIBS)
-+              $(TOP)/ext/misc/scrub.c libsqlite3.la
- 
- srcck1$(BEXE):        $(TOP)/tool/srcck1.c
-       $(BCC) -o srcck1$(BEXE) $(TOP)/tool/srcck1.c
-@@ -767,7 +772,7 @@
- # Rule to build the amalgamation
- #
- sqlite3.lo:   sqlite3.c
--      $(LTCOMPILE) $(TEMP_STORE) -c sqlite3.c
-+      $(LTCOMPILE) $(SHELL_OPT) $(TEMP_STORE) -c sqlite3.c
- 
- # Rules to build the LEMON compiler generator
- #
-@@ -1064,14 +1069,9 @@
- # Source files that go into making shell.c
- SHELL_SRC = \
-       $(TOP)/src/shell.c.in \
--        $(TOP)/ext/misc/appendvfs.c \
-       $(TOP)/ext/misc/shathree.c \
-       $(TOP)/ext/misc/fileio.c \
-       $(TOP)/ext/misc/completion.c \
--      $(TOP)/ext/misc/sqlar.c \
--      $(TOP)/ext/expert/sqlite3expert.c \
--      $(TOP)/ext/expert/sqlite3expert.h \
--      $(TOP)/ext/misc/zipfile.c \
-       $(TOP)/ext/misc/memtrace.c \
-         $(TOP)/src/test_windirent.c
- 
-@@ -1239,11 +1239,11 @@
- 
- # Fuzz testing
- fuzztest:     fuzzcheck$(TEXE) $(FUZZDATA) sessionfuzz$(TEXE) 
$(TOP)/test/sessionfuzz-data1.db
--      ./fuzzcheck$(TEXE) $(FUZZDATA)
-+      ./fuzzcheck$(TEXE) --timeout 3600 $(FUZZDATA)
-       ./sessionfuzz$(TEXE) run $(TOP)/test/sessionfuzz-data1.db
- 
- valgrindfuzz: fuzzcheck$(TEXT) $(FUZZDATA) sessionfuzz$(TEXE) 
$(TOP)/test/sessionfuzz-data1.db
--      valgrind ./fuzzcheck$(TEXE) --cell-size-check --limit-mem 10M --timeout 
600 $(FUZZDATA)
-+      valgrind ./fuzzcheck$(TEXE) --cell-size-check --limit-mem 10M --timeout 
3600 $(FUZZDATA)
-       valgrind ./sessionfuzz$(TEXE) run $(TOP)/test/sessionfuzz-data1.db
- 
- # The veryquick.test TCL tests.
-@@ -1274,24 +1274,23 @@
- smoketest:    $(TESTPROGS) fuzzcheck$(TEXE)
-       ./testfixture$(TEXE) $(TOP)/test/main.test $(TESTOPTS)
- 
--sqlite3_analyzer.c: sqlite3.c $(TOP)/src/tclsqlite.c 
$(TOP)/tool/spaceanal.tcl $(TOP)/tool/mkccode.tcl 
$(TOP)/tool/sqlite3_analyzer.c.in
-+sqlite3_analyzer.c:   $(TOP)/src/tclsqlite.c $(TOP)/tool/spaceanal.tcl 
$(TOP)/tool/mkccode.tcl $(TOP)/tool/sqlite3_analyzer.c.in
-       $(TCLSH_CMD) $(TOP)/tool/mkccode.tcl $(TOP)/tool/sqlite3_analyzer.c.in 
>sqlite3_analyzer.c
- 
--sqlite3_analyzer$(TEXE): sqlite3_analyzer.c
--      $(LTLINK) sqlite3_analyzer.c -o $@ $(LIBTCL) $(TLIBS)
-+sqlite3_analyzer$(TEXE):      sqlite3_analyzer.c libsqlite3.la
-+      $(LTLINK) sqlite3_analyzer.c -o $@ libsqlite3.la $(LIBTCL)
- 
--sqltclsh.c: sqlite3.c $(TOP)/src/tclsqlite.c $(TOP)/tool/sqltclsh.tcl 
$(TOP)/ext/misc/appendvfs.c $(TOP)/tool/mkccode.tcl $(TOP)/tool/sqltclsh.c.in
-+sqltclsh.c:   $(TOP)/src/tclsqlite.c $(TOP)/tool/sqltclsh.tcl 
$(TOP)/tool/mkccode.tcl $(TOP)/tool/sqltclsh.c.in
-       $(TCLSH_CMD) $(TOP)/tool/mkccode.tcl $(TOP)/tool/sqltclsh.c.in 
>sqltclsh.c
- 
--sqltclsh$(TEXE): sqltclsh.c
--      $(LTLINK) sqltclsh.c -o $@ $(LIBTCL) $(TLIBS)
-+sqltclsh$(TEXE):      sqltclsh.c libsqlite3.la
-+      $(LTLINK) sqltclsh.c -o $@ libsqlite3.la $(LIBTCL)
- 
--sqlite3_expert$(TEXE): $(TOP)/ext/expert/sqlite3expert.h 
$(TOP)/ext/expert/sqlite3expert.c $(TOP)/ext/expert/expert.c sqlite3.c
--      $(LTLINK)       $(TOP)/ext/expert/sqlite3expert.h 
$(TOP)/ext/expert/sqlite3expert.c $(TOP)/ext/expert/expert.c sqlite3.c -o 
sqlite3_expert $(TLIBS)
-+sqlite3_expert$(TEXE):        $(TOP)/ext/expert/sqlite3expert.h 
$(TOP)/ext/expert/expert.c libsqlite3.la
-+      $(LTLINK) $(TOP)/ext/expert/expert.c -o sqlite3_expert libsqlite3.la
- 
- CHECKER_DEPS =\
-   $(TOP)/tool/mkccode.tcl \
--  sqlite3.c \
-   $(TOP)/src/tclsqlite.c \
-   $(TOP)/ext/repair/sqlite3_checker.tcl \
-   $(TOP)/ext/repair/checkindex.c \
-@@ -1302,36 +1301,36 @@
- sqlite3_checker.c:    $(CHECKER_DEPS)
-       $(TCLSH_CMD) $(TOP)/tool/mkccode.tcl 
$(TOP)/ext/repair/sqlite3_checker.c.in >$@
- 
--sqlite3_checker$(TEXE):       sqlite3_checker.c
--      $(LTLINK) sqlite3_checker.c -o $@ $(LIBTCL) $(TLIBS)
-+sqlite3_checker$(TEXE):       sqlite3_checker.c libsqlite3.la
-+      $(LTLINK) sqlite3_checker.c -o $@ libsqlite3.la $(LIBTCL)
- 
--dbdump$(TEXE): $(TOP)/ext/misc/dbdump.c sqlite3.lo
-+dbdump$(TEXE):        $(TOP)/ext/misc/dbdump.c libsqlite3.la
-       $(LTLINK) -DDBDUMP_STANDALONE -o $@ \
--           $(TOP)/ext/misc/dbdump.c sqlite3.lo $(TLIBS)
-+           $(TOP)/ext/misc/dbdump.c libsqlite3.la
- 
--dbtotxt$(TEXE): $(TOP)/tool/dbtotxt.c
--      $(LTLINK)-o $@ $(TOP)/tool/dbtotxt.c
-+dbtotxt$(TEXE):       $(TOP)/tool/dbtotxt.c
-+      $(LTLINK) -o $@ $(TOP)/tool/dbtotxt.c
- 
--showdb$(TEXE):        $(TOP)/tool/showdb.c sqlite3.lo
--      $(LTLINK) -o $@ $(TOP)/tool/showdb.c sqlite3.lo $(TLIBS)
-+showdb$(TEXE):        $(TOP)/tool/showdb.c libsqlite3.la
-+      $(LTLINK) -o $@ $(TOP)/tool/showdb.c libsqlite3.la
- 
--showstat4$(TEXE):     $(TOP)/tool/showstat4.c sqlite3.lo
--      $(LTLINK) -o $@ $(TOP)/tool/showstat4.c sqlite3.lo $(TLIBS)
-+showstat4$(TEXE):     $(TOP)/tool/showstat4.c libsqlite3.la
-+      $(LTLINK) -o $@ $(TOP)/tool/showstat4.c libsqlite3.la
- 
--showjournal$(TEXE):   $(TOP)/tool/showjournal.c sqlite3.lo
--      $(LTLINK) -o $@ $(TOP)/tool/showjournal.c sqlite3.lo $(TLIBS)
-+showjournal$(TEXE):   $(TOP)/tool/showjournal.c
-+      $(LTLINK) -o $@ $(TOP)/tool/showjournal.c
- 
--showwal$(TEXE):       $(TOP)/tool/showwal.c sqlite3.lo
--      $(LTLINK) -o $@ $(TOP)/tool/showwal.c sqlite3.lo $(TLIBS)
-+showwal$(TEXE):       $(TOP)/tool/showwal.c
-+      $(LTLINK) -o $@ $(TOP)/tool/showwal.c
- 
- showshm$(TEXE):       $(TOP)/tool/showshm.c
-       $(LTLINK) -o $@ $(TOP)/tool/showshm.c
- 
--index_usage$(TEXE): $(TOP)/tool/index_usage.c sqlite3.lo
--      $(LTLINK) $(SHELL_OPT) -o $@ $(TOP)/tool/index_usage.c sqlite3.lo 
$(TLIBS)
-+index_usage$(TEXE):   $(TOP)/tool/index_usage.c libsqlite3.la
-+      $(LTLINK) -o $@ $(TOP)/tool/index_usage.c libsqlite3.la
- 
--changeset$(TEXE):     $(TOP)/ext/session/changeset.c sqlite3.lo
--      $(LTLINK) -o $@ $(TOP)/ext/session/changeset.c sqlite3.lo $(TLIBS)
-+changeset$(TEXE):     $(TOP)/ext/session/changeset.c libsqlite3.la
-+      $(LTLINK) -o $@ $(TOP)/ext/session/changeset.c libsqlite3.la
- 
- changesetfuzz$(TEXE): $(TOP)/ext/session/changesetfuzz.c sqlite3.lo
-       $(LTLINK) -o $@ $(TOP)/ext/session/changesetfuzz.c sqlite3.lo $(TLIBS)
-@@ -1356,11 +1355,11 @@
- kvtest$(TEXE):        $(TOP)/test/kvtest.c sqlite3.c
-       $(LTLINK) $(KV_OPT) -o $@ $(TOP)/test/kvtest.c sqlite3.c $(TLIBS)
- 
--rbu$(EXE): $(TOP)/ext/rbu/rbu.c $(TOP)/ext/rbu/sqlite3rbu.c sqlite3.lo
--      $(LTLINK) -I. -o $@ $(TOP)/ext/rbu/rbu.c sqlite3.lo $(TLIBS)
-+rbu$(EXE):    $(TOP)/ext/rbu/rbu.c libsqlite3.la
-+      $(LTLINK) -I. -o $@ $(TOP)/ext/rbu/rbu.c libsqlite3.la
- 
--loadfts$(EXE): $(TOP)/tool/loadfts.c libsqlite3.la
--      $(LTLINK) $(TOP)/tool/loadfts.c libsqlite3.la -o $@ $(TLIBS)
-+loadfts$(EXE):        $(TOP)/tool/loadfts.c libsqlite3.la
-+      $(LTLINK) $(TOP)/tool/loadfts.c libsqlite3.la -o $@
- 
- # This target will fail if the SQLite amalgamation contains any exported
- # symbols that do not begin with "sqlite3_". It is run as part of the
---- /configure.ac
-+++ /configure.ac
-@@ -587,6 +587,9 @@
- if test "${enable_load_extension}" = "yes" ; then
-   OPT_FEATURE_FLAGS=""
-   AC_SEARCH_LIBS(dlopen, dl)
-+  if test "${ac_cv_search_dlopen}" = "no" ; then
-+    OPT_FEATURE_FLAGS="-DSQLITE_OMIT_LOAD_EXTENSION=1"
-+  fi
- else
-   OPT_FEATURE_FLAGS="-DSQLITE_OMIT_LOAD_EXTENSION=1"
- fi
---- /ext/misc/sqlar.c
-+++ /ext/misc/sqlar.c
-@@ -14,6 +14,8 @@
- ** for working with sqlar archives and used by the shell tool's built-in
- ** sqlar support.
- */
-+#ifdef SQLITE_HAVE_ZLIB
-+
- #include "sqlite3ext.h"
- SQLITE_EXTENSION_INIT1
- #include <zlib.h>
-@@ -121,3 +123,5 @@
-   }
-   return rc;
- }
-+
-+#endif /* SQLITE_HAVE_ZLIB */
---- /ext/misc/zipfile.c
-+++ /ext/misc/zipfile.c
-@@ -24,6 +24,8 @@
- **    *  No support for zip64 extensions
- **    *  Only the "inflate/deflate" (zlib) compression method is supported
- */
-+#ifdef SQLITE_HAVE_ZLIB
-+
- #include "sqlite3ext.h"
- SQLITE_EXTENSION_INIT1
- #include <stdio.h>
-@@ -2186,3 +2188,5 @@
-   (void)pzErrMsg;  /* Unused parameter */
-   return zipfileRegister(db);
- }
-+
-+#endif /* SQLITE_HAVE_ZLIB */
---- /ext/repair/sqlite3_checker.c.in
-+++ /ext/repair/sqlite3_checker.c.in
-@@ -2,6 +2,7 @@
- ** Read an SQLite database file and analyze its space utilization.  Generate
- ** text on standard output.
- */
-+#define SQLITE_CORE 1
- #define TCLSH_INIT_PROC sqlite3_checker_init_proc
- #define SQLITE_ENABLE_DBPAGE_VTAB 1
- #define SQLITE_ENABLE_JSON1 1
-@@ -14,7 +15,7 @@
- #define SQLITE_OMIT_SHARED_CACHE 1
- #define SQLITE_DEFAULT_MEMSTATUS 0
- #define SQLITE_MAX_EXPR_DEPTH 0
--INCLUDE sqlite3.c
-+#include "sqlite3.h"
- INCLUDE $ROOT/src/tclsqlite.c
- INCLUDE $ROOT/ext/misc/btreeinfo.c
- INCLUDE $ROOT/ext/repair/checkindex.c
---- /src/shell.c.in
-+++ /src/shell.c.in
-@@ -61,6 +61,7 @@
- #include <stdio.h>
- #include <assert.h>
- #include "sqlite3.h"
-+#include "ext/expert/sqlite3expert.h"
- typedef sqlite3_int64 i64;
- typedef sqlite3_uint64 u64;
- typedef unsigned char u8;
-@@ -127,6 +128,10 @@
- # define SHELL_USE_LOCAL_GETLINE 1
- #endif
- 
-+#ifdef SQLITE_HAVE_ZLIB
-+#include <zlib.h>
-+#endif
-+
- 
- #if defined(_WIN32) || defined(WIN32)
- # include <io.h>
-@@ -939,18 +944,7 @@
- INCLUDE ../ext/misc/shathree.c
- INCLUDE ../ext/misc/fileio.c
- INCLUDE ../ext/misc/completion.c
--INCLUDE ../ext/misc/appendvfs.c
- INCLUDE ../ext/misc/memtrace.c
--#ifdef SQLITE_HAVE_ZLIB
--INCLUDE ../ext/misc/zipfile.c
--INCLUDE ../ext/misc/sqlar.c
--#endif
--INCLUDE ../ext/expert/sqlite3expert.h
--INCLUDE ../ext/expert/sqlite3expert.c
--
--#if !defined(SQLITE_OMIT_VIRTUALTABLE) && defined(SQLITE_ENABLE_DBPAGE_VTAB)
--INCLUDE ../ext/misc/dbdata.c
--#endif
- 
- #if defined(SQLITE_ENABLE_SESSION)
- /*
-@@ -4173,10 +4167,13 @@
-     sqlite3_shathree_init(p->db, 0, 0);
-     sqlite3_completion_init(p->db, 0, 0);
- #if !defined(SQLITE_OMIT_VIRTUALTABLE) && defined(SQLITE_ENABLE_DBPAGE_VTAB)
-+    extern int sqlite3_dbdata_init(sqlite3 *, char **, const 
sqlite3_api_routines *);
-     sqlite3_dbdata_init(p->db, 0, 0);
- #endif
- #ifdef SQLITE_HAVE_ZLIB
-+    extern int sqlite3_zipfile_init(sqlite3 *, char **, const 
sqlite3_api_routines *);
-     sqlite3_zipfile_init(p->db, 0, 0);
-+    extern int sqlite3_sqlar_init(sqlite3 *, char **, const 
sqlite3_api_routines *);
-     sqlite3_sqlar_init(p->db, 0, 0);
- #endif
-     sqlite3_create_function(p->db, "shell_add_schema", 3, SQLITE_UTF8, 0,
-@@ -6176,6 +6173,7 @@
-         goto end_ar_command;
-       }
-       sqlite3_fileio_init(cmd.db, 0, 0);
-+      extern int sqlite3_sqlar_init(sqlite3 *, char **, const 
sqlite3_api_routines *);
-       sqlite3_sqlar_init(cmd.db, 0, 0);
-       sqlite3_create_function(cmd.db, "shell_putsnl", 1, SQLITE_UTF8, cmd.p,
-                               shellPutsFunc, 0, 0);
-@@ -10354,6 +10352,7 @@
- #endif
-   }
-   data.out = stdout;
-+  extern int sqlite3_appendvfs_init(sqlite3 *, char **, const 
sqlite3_api_routines *);
-   sqlite3_appendvfs_init(0,0,0);
- 
-   /* Go ahead and open the database file if it already exists.  If the
---- /test/sessionfuzz.c
-+++ /test/sessionfuzz.c
-@@ -700,42 +700,6 @@
- #include <assert.h>
- #include "zlib.h"
- 
--/*
--** Implementation of the "sqlar_uncompress(X,SZ)" SQL function
--**
--** Parameter SZ is interpreted as an integer. If it is less than or
--** equal to zero, then this function returns a copy of X. Or, if
--** SZ is equal to the size of X when interpreted as a blob, also
--** return a copy of X. Otherwise, decompress blob X using zlib
--** utility function uncompress() and return the results (another
--** blob).
--*/
--static void sqlarUncompressFunc(
--  sqlite3_context *context,
--  int argc,
--  sqlite3_value **argv
--){
--  uLong nData;
--  uLongf sz;
--
--  assert( argc==2 );
--  sz = sqlite3_value_int(argv[1]);
--
--  if( sz<=0 || sz==(nData = sqlite3_value_bytes(argv[0])) ){
--    sqlite3_result_value(context, argv[0]);
--  }else{
--    const Bytef *pData= sqlite3_value_blob(argv[0]);
--    Bytef *pOut = sqlite3_malloc(sz);
--    if( Z_OK!=uncompress(pOut, &sz, pData, nData) ){
--      sqlite3_result_error(context, "error in uncompress()", -1);
--    }else{
--      sqlite3_result_blob(context, pOut, sz, SQLITE_TRANSIENT);
--    }
--    sqlite3_free(pOut);
--  }
--}
--
--
- /* Run a chunk of SQL.  If any errors happen, print an error message
- ** and exit.
- */
---- /tool/mksqlite3c.tcl
-+++ /tool/mksqlite3c.tcl
-@@ -117,6 +117,7 @@
-    rtree.h
-    sqlite3session.h
-    sqlite3.h
-+   sqlite3expert.h
-    sqlite3ext.h
-    sqlite3rbu.h
-    sqliteicu.h
-@@ -403,6 +404,11 @@
-    sqlite3session.c
-    fts5.c
-    stmt.c
-+   appendvfs.c
-+   dbdata.c
-+   sqlar.c
-+   sqlite3expert.c
-+   zipfile.c
- } {
-   copy_file tsrc/$file
- }
---- /tool/sqlite3_analyzer.c.in
-+++ /tool/sqlite3_analyzer.c.in
-@@ -14,9 +14,6 @@
- #define SQLITE_DEFAULT_MEMSTATUS 0
- #define SQLITE_MAX_EXPR_DEPTH 0
- #define SQLITE_OMIT_LOAD_EXTENSION 1
--#ifndef USE_EXTERNAL_SQLITE
--INCLUDE sqlite3.c
--#endif
- INCLUDE $ROOT/src/tclsqlite.c
- 
- const char *sqlite3_analyzer_init_proc(Tcl_Interp *interp){
---- /tool/sqltclsh.c.in
-+++ /tool/sqltclsh.c.in
-@@ -27,19 +27,17 @@
- #define SQLITE_OMIT_SHARED_CACHE 1
- #define SQLITE_DEFAULT_MEMSTATUS 0
- #define SQLITE_MAX_EXPR_DEPTH 0
--INCLUDE sqlite3.c
--INCLUDE $ROOT/ext/misc/appendvfs.c
--#ifdef SQLITE_HAVE_ZLIB
--INCLUDE $ROOT/ext/misc/zipfile.c
--INCLUDE $ROOT/ext/misc/sqlar.c
--#endif
-+#include "sqlite3.h"
- INCLUDE $ROOT/src/tclsqlite.c
- 
- const char *sqlite3_tclapp_init_proc(Tcl_Interp *interp){
-   (void)interp;
-+  extern int sqlite3_appendvfs_init(sqlite3 *,char **, const 
sqlite3_api_routines *);
-   sqlite3_appendvfs_init(0,0,0);
- #ifdef SQLITE_HAVE_ZLIB
-+  extern int sqlite3_sqlar_init(sqlite3 *, char **, const 
sqlite3_api_routines *);
-   sqlite3_auto_extension((void(*)(void))sqlite3_sqlar_init);
-+  extern int sqlite3_zipfile_init(sqlite3 *, char **, const 
sqlite3_api_routines *);
-   sqlite3_auto_extension((void(*)(void))sqlite3_zipfile_init);
- #endif
- 

diff --git a/dev-db/sqlite/files/sqlite-3.31.1-full_archive-architectures.patch 
b/dev-db/sqlite/files/sqlite-3.31.1-full_archive-architectures.patch
deleted file mode 100644
index a0cf7514d0f..00000000000
--- a/dev-db/sqlite/files/sqlite-3.31.1-full_archive-architectures.patch
+++ /dev/null
@@ -1,72 +0,0 @@
-https://sqlite.org/cgi/src/info/04885763c4cd00cb
-https://sqlite.org/cgi/src/info/b20503aaf5b6595a
-
---- /ext/fts5/test/fts5matchinfo.test
-+++ /ext/fts5/test/fts5matchinfo.test
-@@ -500,14 +500,18 @@
-   INSERT INTO t1 VALUES('c', 'd');
- }
- 
-+if {$tcl_platform(byteOrder)=="littleEndian"} {
-+  set res {X'02000000'}
-+} else {
-+  set res {X'00000002'}
-+}
- do_execsql_test 15.1 {
-   SELECT quote(matchinfo(t1, 'n')) FROM t1 LIMIT 1;
--} {X'02000000'}
--
-+} $res
- do_execsql_test 15.2 {
-   DELETE FROM t1_content WHERE rowid=1;
-   SELECT quote(matchinfo(t1, 'n')) FROM t1 LIMIT 1;
--} {X'02000000'}
-+} $res
- 
- fts5_aux_test_functions db
- do_execsql_test 15.3 {
-@@ -517,4 +521,3 @@
- }
- 
- finish_test
--
---- /src/insert.c
-+++ /src/insert.c
-@@ -2170,12 +2170,14 @@
-             x = *sqlite3VdbeGetOp(v, addrConflictCk);
-             if( x.opcode!=OP_IdxRowid ){
-               int p2;      /* New P2 value for copied conflict check opcode */
-+              const char *zP4;
-               if( sqlite3OpcodeProperty[x.opcode]&OPFLG_JUMP ){
-                 p2 = lblRecheckOk;
-               }else{
-                 p2 = x.p2;
-               }
--              sqlite3VdbeAddOp4(v, x.opcode, x.p1, p2, x.p3, x.p4.z, 
x.p4type);
-+              zP4 = x.p4type==P4_INT32 ? SQLITE_INT_TO_PTR(x.p4.i) : x.p4.z;
-+              sqlite3VdbeAddOp4(v, x.opcode, x.p1, p2, x.p3, zP4, x.p4type);
-               sqlite3VdbeChangeP5(v, x.p5);
-               VdbeCoverageIf(v, p2!=x.p2);
-             }
---- /test/fts4aa.test
-+++ /test/fts4aa.test
-@@ -229,13 +229,18 @@
- # 2019-11-18 https://bugs.chromium.org/p/chromium/issues/detail?id=1025467
- db close
- sqlite3 db :memory:
-+if {$tcl_platform(byteOrder)=="littleEndian"} {
-+  set res 
{X'0200000000000000000000000E0000000E00000001000000010000000100000001000000'}
-+} else {
-+  set res 
{X'0000000200000000000000000000000E0000000E00000001000000010000000100000001'}
-+}
- do_execsql_test fts4aa-6.10 {
-   CREATE VIRTUAL TABLE f USING fts4();
-   INSERT INTO f_segdir VALUES (77,91,0,0,'255 
77',x'0001308000004d5c4ddddddd4d4d7b4d4d4d614d8019ff4d05000001204d4d2e4d6e4d4d4d4b4d6c4d004d4d4d4d4d4d3d000000004d5d4d4d645d4d004d4d4d4d4d4d4d4d4d454d6910004d05ffff054d646c4d004d5d4d4d4d4d3d000000004d4d4d4d4d4d4d4d4d4d4d69624d4d4d04004d4d4d4d4d604d4ce1404d554d45');
-   INSERT INTO f_segdir VALUES (77,108,0,0,'255 
77',x'0001310000fa64004d4d4d3c5d4d654d4d4d614d8000ff4d05000001204d4d2e4d6e4d4d4dff4d4d4d4d4d4d00104d4d4d4d000000004d4d4d0400311d4d4d4d4d4d4d4d4d4d684d6910004d05ffff054d4d6c4d004d4d4d4d4d4d3d000000004d4d4d4d644d4d4d4d4d4d69624d4d4d03ed4d4d4d4d4d604d4ce1404d550080');
-   INSERT INTO f_stat VALUES 
(0,x'80808080100000000064004d4d4d3c4d4d654d4d4d614d8000ff4df6ff1a00204d4d2e4d6e4d4d4d104d4d4d4d4d4d00104d4d4d4d4d4d69574d4d4d000031044d4d4d3e4d4d4c4d05004d6910');
-   SELECT quote(matchinfo(f,'pnax')) from f where f match '0 1';
--} 
{X'0200000000000000000000000E0000000E00000001000000010000000100000001000000'}
-+} $res
- 
- # 2019-11-18 Detect infinite loop in fts3SelectLeaf()
- db close

diff --git 
a/dev-db/sqlite/files/sqlite-3.31.1-full_archive-security_fixes.patch 
b/dev-db/sqlite/files/sqlite-3.31.1-full_archive-security_fixes.patch
deleted file mode 100644
index c0bb7144a67..00000000000
--- a/dev-db/sqlite/files/sqlite-3.31.1-full_archive-security_fixes.patch
+++ /dev/null
@@ -1,163 +0,0 @@
-https://sqlite.org/cgi/src/info/9d0d4ab95dc0c56e
-https://sqlite.org/cgi/src/info/abc473fb8fb99900
-https://sqlite.org/cgi/src/info/5aeb5a2d295e10d5
-https://sqlite.org/cgi/src/info/a67cf5b7d37d5b14
-https://sqlite.org/cgi/src/info/14d14eb537075c6a
-https://sqlite.org/cgi/src/info/c431b3fd8fd0f6a6
-
---- /src/expr.c
-+++ /src/expr.c
-@@ -5463,19 +5463,25 @@
-     case TK_LT:
-     case TK_LE:
-     case TK_GT:
--    case TK_GE:
-+    case TK_GE: {
-+      Expr *pLeft = pExpr->pLeft;
-+      Expr *pRight = pExpr->pRight;
-       testcase( pExpr->op==TK_EQ );
-       testcase( pExpr->op==TK_NE );
-       testcase( pExpr->op==TK_LT );
-       testcase( pExpr->op==TK_LE );
-       testcase( pExpr->op==TK_GT );
-       testcase( pExpr->op==TK_GE );
--      if( (pExpr->pLeft->op==TK_COLUMN && IsVirtual(pExpr->pLeft->y.pTab))
--       || (pExpr->pRight->op==TK_COLUMN && IsVirtual(pExpr->pRight->y.pTab))
-+      /* The y.pTab=0 assignment in wherecode.c always happens after the
-+      ** impliesNotNullRow() test */
-+      if( (pLeft->op==TK_COLUMN && ALWAYS(pLeft->y.pTab!=0)
-+                               && IsVirtual(pLeft->y.pTab))
-+       || (pRight->op==TK_COLUMN && ALWAYS(pRight->y.pTab!=0)
-+                               && IsVirtual(pRight->y.pTab))
-       ){
--       return WRC_Prune;
-+        return WRC_Prune;
-       }
--
-+    }
-     default:
-       return WRC_Continue;
-   }
---- /src/resolve.c
-+++ /src/resolve.c
-@@ -1051,7 +1051,7 @@
-       assert( !ExprHasProperty(pExpr, EP_Reduced) );
-       /* Handle special cases of "x IS TRUE", "x IS FALSE", "x IS NOT TRUE",
-       ** and "x IS NOT FALSE". */
--      if( pRight->op==TK_ID ){
-+      if( pRight && pRight->op==TK_ID ){
-         int rc = resolveExprStep(pWalker, pRight);
-         if( rc==WRC_Abort ) return WRC_Abort;
-         if( pRight->op==TK_TRUEFALSE ){
---- /src/select.c
-+++ /src/select.c
-@@ -2806,6 +2806,7 @@
-         /* Generate code to take the intersection of the two temporary
-         ** tables.
-         */
-+        if( rc ) break;
-         assert( p->pEList );
-         iBreak = sqlite3VdbeMakeLabel(pParse);
-         iCont = sqlite3VdbeMakeLabel(pParse);
-@@ -5148,7 +5149,7 @@
-             pNew = sqlite3ExprListAppend(pParse, pNew, pExpr);
-             sqlite3TokenInit(&sColname, zColname);
-             sqlite3ExprListSetName(pParse, pNew, &sColname, 0);
--            if( pNew && (p->selFlags & SF_NestedFrom)!=0 ){
-+            if( pNew && (p->selFlags & SF_NestedFrom)!=0 && !IN_RENAME_OBJECT 
){
-               struct ExprList_item *pX = &pNew->a[pNew->nExpr-1];
-               sqlite3DbFree(db, pX->zEName);
-               if( pSub ){
---- /src/sqliteInt.h
-+++ /src/sqliteInt.h
-@@ -2153,8 +2153,11 @@
- */
- #ifndef SQLITE_OMIT_VIRTUALTABLE
- #  define IsVirtual(X)      ((X)->nModuleArg)
-+#  define ExprIsVtab(X)  \
-+              ((X)->op==TK_COLUMN && (X)->y.pTab!=0 && 
(X)->y.pTab->nModuleArg)
- #else
- #  define IsVirtual(X)      0
-+#  define ExprIsVtab(X)     0
- #endif
- 
- /*
---- /src/whereexpr.c
-+++ /src/whereexpr.c
-@@ -377,7 +377,8 @@
-     **       MATCH(expression,vtab_column)
-     */
-     pCol = pList->a[1].pExpr;
--    if( pCol->op==TK_COLUMN && IsVirtual(pCol->y.pTab) ){
-+    testcase( pCol->op==TK_COLUMN && pCol->y.pTab==0 );
-+    if( ExprIsVtab(pCol) ){
-       for(i=0; i<ArraySize(aOp); i++){
-         if( sqlite3StrICmp(pExpr->u.zToken, aOp[i].zOp)==0 ){
-           *peOp2 = aOp[i].eOp2;
-@@ -399,7 +400,8 @@
-     ** with function names in an arbitrary case.
-     */
-     pCol = pList->a[0].pExpr;
--    if( pCol->op==TK_COLUMN && IsVirtual(pCol->y.pTab) ){
-+    testcase( pCol->op==TK_COLUMN && pCol->y.pTab==0 );
-+    if( ExprIsVtab(pCol) ){
-       sqlite3_vtab *pVtab;
-       sqlite3_module *pMod;
-       void (*xNotUsed)(sqlite3_context*,int,sqlite3_value**);
-@@ -422,10 +424,12 @@
-     int res = 0;
-     Expr *pLeft = pExpr->pLeft;
-     Expr *pRight = pExpr->pRight;
--    if( pLeft->op==TK_COLUMN && IsVirtual(pLeft->y.pTab) ){
-+    testcase( pLeft->op==TK_COLUMN && pLeft->y.pTab==0 );
-+    if( ExprIsVtab(pLeft) ){
-       res++;
-     }
--    if( pRight && pRight->op==TK_COLUMN && IsVirtual(pRight->y.pTab) ){
-+    testcase( pRight && pRight->op==TK_COLUMN && pRight->y.pTab==0 );
-+    if( pRight && ExprIsVtab(pRight) ){
-       res++;
-       SWAP(Expr*, pLeft, pRight);
-     }
---- /test/altertab.test
-+++ /test/altertab.test
-@@ -613,4 +613,21 @@
-   SELECT sql FROM sqlite_master;
- } {{CREATE TABLE t0 (c1 INTEGER, PRIMARY KEY(c1))}}
- 
-+# 2020-02-23 ticket f50af3e8a565776b
-+reset_db
-+do_execsql_test 19.100 {
-+  CREATE TABLE t1(x);
-+  CREATE VIEW t2 AS SELECT 1 FROM t1, (t1 AS a0, t1);
-+  ALTER TABLE t1 RENAME TO t3;
-+  SELECT sql FROM sqlite_master;
-+} {{CREATE TABLE "t3"(x)} {CREATE VIEW t2 AS SELECT 1 FROM "t3", ("t3" AS a0, 
"t3")}}
-+do_execsql_test 19.110 {
-+  INSERT INTO t3(x) VALUES(123);
-+  SELECT * FROM t2;
-+} {1}
-+do_execsql_test 19.120 {
-+  INSERT INTO t3(x) VALUES('xyz');
-+  SELECT * FROM t2;
-+} {1 1 1 1 1 1 1 1}
-+
- finish_test
---- /test/windowfault.test
-+++ /test/windowfault.test
-@@ -263,4 +263,15 @@
-   faultsim_test_result {0 {}}
- }
- 
-+do_faultsim_test 11 -faults oom* -prep {
-+} -body {
-+  execsql {
-+    VALUES(false),(current_date collate binary) 
-+    intersect 
-+    values(count() not like group_concat(cast(cast(0e00 as text) as integer) 
<= NULL || 0.4e-0 || 0x8 & true ) over () collate rtrim);
-+  }
-+} -test {
-+  faultsim_test_result {0 {}}
-+}
-+
- finish_test

diff --git 
a/dev-db/sqlite/files/sqlite-3.31.1-nonfull_archive-architectures.patch 
b/dev-db/sqlite/files/sqlite-3.31.1-nonfull_archive-architectures.patch
deleted file mode 100644
index 79f6f07e0ef..00000000000
--- a/dev-db/sqlite/files/sqlite-3.31.1-nonfull_archive-architectures.patch
+++ /dev/null
@@ -1,20 +0,0 @@
-https://sqlite.org/cgi/src/info/04885763c4cd00cb
-
---- /sqlite3.c
-+++ /sqlite3.c
-@@ -121302,12 +121302,14 @@
-             x = *sqlite3VdbeGetOp(v, addrConflictCk);
-             if( x.opcode!=OP_IdxRowid ){
-               int p2;      /* New P2 value for copied conflict check opcode */
-+              const char *zP4;
-               if( sqlite3OpcodeProperty[x.opcode]&OPFLG_JUMP ){
-                 p2 = lblRecheckOk;
-               }else{
-                 p2 = x.p2;
-               }
--              sqlite3VdbeAddOp4(v, x.opcode, x.p1, p2, x.p3, x.p4.z, 
x.p4type);
-+              zP4 = x.p4type==P4_INT32 ? SQLITE_INT_TO_PTR(x.p4.i) : x.p4.z;
-+              sqlite3VdbeAddOp4(v, x.opcode, x.p1, p2, x.p3, zP4, x.p4type);
-               sqlite3VdbeChangeP5(v, x.p5);
-               VdbeCoverageIf(v, p2!=x.p2);
-             }

diff --git 
a/dev-db/sqlite/files/sqlite-3.31.1-nonfull_archive-security_fixes.patch 
b/dev-db/sqlite/files/sqlite-3.31.1-nonfull_archive-security_fixes.patch
deleted file mode 100644
index 3bbbbf7c8dd..00000000000
--- a/dev-db/sqlite/files/sqlite-3.31.1-nonfull_archive-security_fixes.patch
+++ /dev/null
@@ -1,112 +0,0 @@
-https://sqlite.org/cgi/src/info/9d0d4ab95dc0c56e
-https://sqlite.org/cgi/src/info/abc473fb8fb99900
-https://sqlite.org/cgi/src/info/5aeb5a2d295e10d5
-https://sqlite.org/cgi/src/info/a67cf5b7d37d5b14
-https://sqlite.org/cgi/src/info/c431b3fd8fd0f6a6
-
---- /sqlite3.c
-+++ /sqlite3.c
-@@ -17428,8 +17428,11 @@
- */
- #ifndef SQLITE_OMIT_VIRTUALTABLE
- #  define IsVirtual(X)      ((X)->nModuleArg)
-+#  define ExprIsVtab(X)  \
-+              ((X)->op==TK_COLUMN && (X)->y.pTab!=0 && 
(X)->y.pTab->nModuleArg)
- #else
- #  define IsVirtual(X)      0
-+#  define ExprIsVtab(X)     0
- #endif
- 
- /*
-@@ -97816,7 +97819,7 @@
-       assert( !ExprHasProperty(pExpr, EP_Reduced) );
-       /* Handle special cases of "x IS TRUE", "x IS FALSE", "x IS NOT TRUE",
-       ** and "x IS NOT FALSE". */
--      if( pRight->op==TK_ID ){
-+      if( pRight && pRight->op==TK_ID ){
-         int rc = resolveExprStep(pWalker, pRight);
-         if( rc==WRC_Abort ) return WRC_Abort;
-         if( pRight->op==TK_TRUEFALSE ){
-@@ -104133,19 +104136,25 @@
-     case TK_LT:
-     case TK_LE:
-     case TK_GT:
--    case TK_GE:
-+    case TK_GE: {
-+      Expr *pLeft = pExpr->pLeft;
-+      Expr *pRight = pExpr->pRight;
-       testcase( pExpr->op==TK_EQ );
-       testcase( pExpr->op==TK_NE );
-       testcase( pExpr->op==TK_LT );
-       testcase( pExpr->op==TK_LE );
-       testcase( pExpr->op==TK_GT );
-       testcase( pExpr->op==TK_GE );
--      if( (pExpr->pLeft->op==TK_COLUMN && IsVirtual(pExpr->pLeft->y.pTab))
--       || (pExpr->pRight->op==TK_COLUMN && IsVirtual(pExpr->pRight->y.pTab))
-+      /* The y.pTab=0 assignment in wherecode.c always happens after the
-+      ** impliesNotNullRow() test */
-+      if( (pLeft->op==TK_COLUMN && ALWAYS(pLeft->y.pTab!=0)
-+                               && IsVirtual(pLeft->y.pTab))
-+       || (pRight->op==TK_COLUMN && ALWAYS(pRight->y.pTab!=0)
-+                               && IsVirtual(pRight->y.pTab))
-       ){
--       return WRC_Prune;
-+        return WRC_Prune;
-       }
--
-+    }
-     default:
-       return WRC_Continue;
-   }
-@@ -130673,6 +130682,7 @@
-         /* Generate code to take the intersection of the two temporary
-         ** tables.
-         */
-+        if( rc ) break;
-         assert( p->pEList );
-         iBreak = sqlite3VdbeMakeLabel(pParse);
-         iCont = sqlite3VdbeMakeLabel(pParse);
-@@ -133015,7 +133025,7 @@
-             pNew = sqlite3ExprListAppend(pParse, pNew, pExpr);
-             sqlite3TokenInit(&sColname, zColname);
-             sqlite3ExprListSetName(pParse, pNew, &sColname, 0);
--            if( pNew && (p->selFlags & SF_NestedFrom)!=0 ){
-+            if( pNew && (p->selFlags & SF_NestedFrom)!=0 && !IN_RENAME_OBJECT 
){
-               struct ExprList_item *pX = &pNew->a[pNew->nExpr-1];
-               sqlite3DbFree(db, pX->zEName);
-               if( pSub ){
-@@ -142593,7 +142603,8 @@
-     **       MATCH(expression,vtab_column)
-     */
-     pCol = pList->a[1].pExpr;
--    if( pCol->op==TK_COLUMN && IsVirtual(pCol->y.pTab) ){
-+    testcase( pCol->op==TK_COLUMN && pCol->y.pTab==0 );
-+    if( ExprIsVtab(pCol) ){
-       for(i=0; i<ArraySize(aOp); i++){
-         if( sqlite3StrICmp(pExpr->u.zToken, aOp[i].zOp)==0 ){
-           *peOp2 = aOp[i].eOp2;
-@@ -142615,7 +142626,8 @@
-     ** with function names in an arbitrary case.
-     */
-     pCol = pList->a[0].pExpr;
--    if( pCol->op==TK_COLUMN && IsVirtual(pCol->y.pTab) ){
-+    testcase( pCol->op==TK_COLUMN && pCol->y.pTab==0 );
-+    if( ExprIsVtab(pCol) ){
-       sqlite3_vtab *pVtab;
-       sqlite3_module *pMod;
-       void (*xNotUsed)(sqlite3_context*,int,sqlite3_value**);
-@@ -142638,10 +142650,12 @@
-     int res = 0;
-     Expr *pLeft = pExpr->pLeft;
-     Expr *pRight = pExpr->pRight;
--    if( pLeft->op==TK_COLUMN && IsVirtual(pLeft->y.pTab) ){
-+    testcase( pLeft->op==TK_COLUMN && pLeft->y.pTab==0 );
-+    if( ExprIsVtab(pLeft) ){
-       res++;
-     }
--    if( pRight && pRight->op==TK_COLUMN && IsVirtual(pRight->y.pTab) ){
-+    testcase( pRight && pRight->op==TK_COLUMN && pRight->y.pTab==0 );
-+    if( pRight && ExprIsVtab(pRight) ){
-       res++;
-       SWAP(Expr*, pLeft, pRight);
-     }

diff --git a/dev-db/sqlite/sqlite-3.31.1.ebuild 
b/dev-db/sqlite/sqlite-3.31.1.ebuild
deleted file mode 100644
index 811d9e3152b..00000000000
--- a/dev-db/sqlite/sqlite-3.31.1.ebuild
+++ /dev/null
@@ -1,392 +0,0 @@
-# Copyright 1999-2020 Gentoo Authors
-# Distributed under the terms of the GNU General Public License v2
-
-EAPI="7"
-
-inherit autotools flag-o-matic multilib-minimal toolchain-funcs
-
-if [[ "${PV}" != "9999" ]]; then
-       SRC_PV="$(printf "%u%02u%02u%02u" $(ver_rs 1- " "))"
-       DOC_PV="${SRC_PV}"
-       # DOC_PV="$(printf "%u%02u%02u00" $(ver_rs 1-3 " "))"
-fi
-
-DESCRIPTION="SQL database engine"
-HOMEPAGE="https://sqlite.org/";
-if [[ "${PV}" == "9999" ]]; then
-       SRC_URI=""
-else
-       SRC_URI="doc? ( https://sqlite.org/2020/${PN}-doc-${DOC_PV}.zip )
-               tcl? ( https://sqlite.org/2020/${PN}-src-${SRC_PV}.zip )
-               test? ( https://sqlite.org/2020/${PN}-src-${SRC_PV}.zip )
-               tools? ( https://sqlite.org/2020/${PN}-src-${SRC_PV}.zip )
-               !tcl? ( !test? ( !tools? ( 
https://sqlite.org/2020/${PN}-autoconf-${SRC_PV}.tar.gz ) ) )"
-fi
-
-LICENSE="public-domain"
-SLOT="3"
-KEYWORDS="~alpha amd64 arm arm64 hppa ~ia64 ~m68k ~mips ppc ppc64 ~riscv s390 
sparc x86 ~ppc-aix ~x64-cygwin ~amd64-linux ~x86-linux ~ppc-macos ~x64-macos 
~x86-macos ~m68k-mint ~sparc-solaris ~sparc64-solaris ~x64-solaris ~x86-solaris"
-IUSE="debug doc icu +readline secure-delete static-libs tcl test tools"
-if [[ "${PV}" == "9999" ]]; then
-       PROPERTIES="live"
-fi
-RESTRICT="!test? ( test )"
-
-if [[ "${PV}" == "9999" ]]; then
-       BDEPEND=">=dev-lang/tcl-8.6:0
-               dev-vcs/fossil"
-else
-       BDEPEND="doc? ( app-arch/unzip )
-               tcl? (
-                       app-arch/unzip
-                       >=dev-lang/tcl-8.6:0
-               )
-               test? (
-                       app-arch/unzip
-                       >=dev-lang/tcl-8.6:0
-               )
-               tools? (
-                       app-arch/unzip
-                       >=dev-lang/tcl-8.6:0
-               )"
-fi
-RDEPEND="sys-libs/zlib:0=[${MULTILIB_USEDEP}]
-       icu? ( dev-libs/icu:0=[${MULTILIB_USEDEP}] )
-       readline? ( sys-libs/readline:0=[${MULTILIB_USEDEP}] )
-       tcl? ( dev-lang/tcl:0=[${MULTILIB_USEDEP}] )
-       tools? ( dev-lang/tcl:0=[${MULTILIB_USEDEP}] )"
-DEPEND="${RDEPEND}
-       test? ( >=dev-lang/tcl-8.6:0[${MULTILIB_USEDEP}] )"
-
-full_archive() {
-       [[ "${PV}" == "9999" ]] || use tcl || use test || use tools
-}
-
-pkg_setup() {
-       if [[ "${PV}" == "9999" ]]; then
-               S="${WORKDIR}/${PN}"
-       else
-               if full_archive; then
-                       S="${WORKDIR}/${PN}-src-${SRC_PV}"
-               else
-                       S="${WORKDIR}/${PN}-autoconf-${SRC_PV}"
-               fi
-       fi
-}
-
-src_unpack() {
-       if [[ "${PV}" == "9999" ]]; then
-               local distdir="${PORTAGE_ACTUAL_DISTDIR:-${DISTDIR}}"
-               addwrite "${distdir}"
-               mkdir -p "${distdir}/fossil-src/${PN}" || die
-
-               mkdir "${WORKDIR}/${PN}" || die
-               pushd "${WORKDIR}/${PN}" > /dev/null || die
-               if [[ ! -f "${distdir}/fossil-src/${PN}/sqlite.fossil" ]]; then
-                       einfo fossil clone --verbose https://sqlite.org/src 
sqlite.fossil
-                       fossil clone --verbose https://sqlite.org/src 
sqlite.fossil || die
-                       echo
-               else
-                       cp -p "${distdir}/fossil-src/${PN}/sqlite.fossil" . || 
die
-                       einfo fossil pull --repository sqlite.fossil --verbose 
https://sqlite.org/src
-                       fossil pull --repository sqlite.fossil --verbose 
https://sqlite.org/src || die
-                       echo
-               fi
-               cp -p sqlite.fossil "${distdir}/fossil-src/${PN}" || die
-               einfo fossil open --quiet sqlite.fossil
-               fossil open --quiet sqlite.fossil || die
-               echo
-               popd > /dev/null || die
-
-               if use doc; then
-                       mkdir "${WORKDIR}/${PN}-doc" || die
-                       pushd "${WORKDIR}/${PN}-doc" > /dev/null || die
-                       if [[ ! -f 
"${distdir}/fossil-src/${PN}/sqlite-doc.fossil" ]]; then
-                               einfo fossil clone --verbose 
https://sqlite.org/docsrc sqlite-doc.fossil
-                               fossil clone --verbose 
https://sqlite.org/docsrc sqlite-doc.fossil || die
-                               echo
-                       else
-                               cp -p 
"${distdir}/fossil-src/${PN}/sqlite-doc.fossil" . || die
-                               einfo fossil pull --repository 
sqlite-doc.fossil --verbose https://sqlite.org/docsrc
-                               fossil pull --repository sqlite-doc.fossil 
--verbose https://sqlite.org/docsrc || die
-                               echo
-                       fi
-                       cp -p sqlite-doc.fossil "${distdir}/fossil-src/${PN}" 
|| die
-                       einfo fossil open --quiet sqlite-doc.fossil
-                       fossil open --quiet sqlite-doc.fossil || die
-                       echo
-                       popd > /dev/null || die
-               fi
-       else
-               default
-       fi
-}
-
-src_prepare() {
-       if full_archive; then
-               eapply "${FILESDIR}/${PN}-3.31.0-full_archive-build.patch"
-               eapply 
"${FILESDIR}/${PN}-3.31.1-full_archive-architectures.patch"
-               eapply 
"${FILESDIR}/${PN}-3.31.1-full_archive-security_fixes.patch"
-
-               eapply_user
-
-               # Fix AC_CHECK_FUNCS.
-               # 
https://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-dev/2016-March/002762.html
-               sed -e "s/AC_CHECK_FUNCS(.*)/AC_CHECK_FUNCS([fdatasync 
fullfsync gmtime_r isnan localtime_r localtime_s malloc_usable_size 
posix_fallocate pread pread64 pwrite pwrite64 strchrnul usleep utime])/" -i 
configure.ac || die "sed failed"
-       else
-               eapply "${FILESDIR}/${PN}-3.25.0-nonfull_archive-build.patch"
-               eapply 
"${FILESDIR}/${PN}-3.31.1-nonfull_archive-architectures.patch"
-               eapply 
"${FILESDIR}/${PN}-3.31.1-nonfull_archive-security_fixes.patch"
-
-               eapply_user
-
-               # Fix AC_CHECK_FUNCS.
-               # 
https://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-dev/2016-March/002762.html
-               sed \
-                       -e 
"s/AC_CHECK_FUNCS(\[fdatasync.*/AC_CHECK_FUNCS([fdatasync fullfsync gmtime_r 
isnan localtime_r localtime_s malloc_usable_size posix_fallocate pread pread64 
pwrite pwrite64 strchrnul usleep utime])/" \
-                       -e "/AC_CHECK_FUNCS(posix_fallocate)/d" \
-                       -i configure.ac || die "sed failed"
-       fi
-
-       eautoreconf
-
-       multilib_copy_sources
-}
-
-multilib_src_configure() {
-       local -x CPPFLAGS="${CPPFLAGS}" CFLAGS="${CFLAGS}"
-       local options=()
-
-       options+=(
-               --enable-$(full_archive && echo load-extension || echo 
dynamic-extensions)
-               --enable-threadsafe
-       )
-       if ! full_archive; then
-               options+=(--disable-static-shell)
-       fi
-
-       # Support detection of misuse of SQLite API.
-       # https://sqlite.org/compile.html#enable_api_armor
-       append-cppflags -DSQLITE_ENABLE_API_ARMOR
-
-       # Support column metadata functions.
-       # https://sqlite.org/c3ref/column_database_name.html
-       append-cppflags -DSQLITE_ENABLE_COLUMN_METADATA
-
-       # Support sqlite_dbpage virtual table.
-       # https://sqlite.org/compile.html#enable_dbpage_vtab
-       append-cppflags -DSQLITE_ENABLE_DBPAGE_VTAB
-
-       # Support dbstat virtual table.
-       # https://sqlite.org/dbstat.html
-       append-cppflags -DSQLITE_ENABLE_DBSTAT_VTAB
-
-       # Support sqlite3_serialize() and sqlite3_deserialize() functions.
-       # https://sqlite.org/compile.html#enable_deserialize
-       # https://sqlite.org/c3ref/serialize.html
-       # https://sqlite.org/c3ref/deserialize.html
-       append-cppflags -DSQLITE_ENABLE_DESERIALIZE
-
-       # Support comments in output of EXPLAIN.
-       # https://sqlite.org/compile.html#enable_explain_comments
-       append-cppflags -DSQLITE_ENABLE_EXPLAIN_COMMENTS
-
-       # Support Full-Text Search versions 3, 4 and 5.
-       # https://sqlite.org/fts3.html
-       # https://sqlite.org/fts5.html
-       append-cppflags -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS 
-DSQLITE_ENABLE_FTS4
-       options+=(--enable-fts5)
-
-       # Support hidden columns.
-       append-cppflags -DSQLITE_ENABLE_HIDDEN_COLUMNS
-
-       # Support JSON1 extension.
-       # https://sqlite.org/json1.html
-       append-cppflags -DSQLITE_ENABLE_JSON1
-
-       # Support memsys5 memory allocator.
-       # https://sqlite.org/malloc.html#memsys5
-       append-cppflags -DSQLITE_ENABLE_MEMSYS5
-
-       # Support sqlite3_normalized_sql() function.
-       # https://sqlite.org/c3ref/expanded_sql.html
-       append-cppflags -DSQLITE_ENABLE_NORMALIZE
-
-       # Support sqlite_offset() function.
-       # https://sqlite.org/lang_corefunc.html#sqlite_offset
-       append-cppflags -DSQLITE_ENABLE_OFFSET_SQL_FUNC
-
-       # Support pre-update hook functions.
-       # https://sqlite.org/c3ref/preupdate_count.html
-       append-cppflags -DSQLITE_ENABLE_PREUPDATE_HOOK
-
-       # Support Resumable Bulk Update extension.
-       # https://sqlite.org/rbu.html
-       append-cppflags -DSQLITE_ENABLE_RBU
-
-       # Support R*Trees.
-       # https://sqlite.org/rtree.html
-       # https://sqlite.org/geopoly.html
-       append-cppflags -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_GEOPOLY
-
-       # Support scan status functions.
-       # https://sqlite.org/c3ref/stmt_scanstatus.html
-       # https://sqlite.org/c3ref/stmt_scanstatus_reset.html
-       append-cppflags -DSQLITE_ENABLE_STMT_SCANSTATUS
-
-       # Support sqlite_stmt virtual table.
-       # https://sqlite.org/stmt.html
-       append-cppflags -DSQLITE_ENABLE_STMTVTAB
-
-       # Support Session extension.
-       # https://sqlite.org/sessionintro.html
-       options+=(--enable-session)
-
-       # Support unknown() function.
-       # https://sqlite.org/compile.html#enable_unknown_sql_function
-       append-cppflags -DSQLITE_ENABLE_UNKNOWN_SQL_FUNCTION
-
-       # Support unlock notification.
-       # https://sqlite.org/unlock_notify.html
-       append-cppflags -DSQLITE_ENABLE_UNLOCK_NOTIFY
-
-       # Support LIMIT and ORDER BY clauses on DELETE and UPDATE statements.
-       # https://sqlite.org/compile.html#enable_update_delete_limit
-       append-cppflags -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT
-
-       # Support soundex() function.
-       # https://sqlite.org/lang_corefunc.html#soundex
-       append-cppflags -DSQLITE_SOUNDEX
-
-       # Support URI filenames.
-       # https://sqlite.org/uri.html
-       append-cppflags -DSQLITE_USE_URI
-
-       # debug USE flag.
-       if full_archive; then
-               options+=($(use_enable debug))
-       else
-               if use debug; then
-                       append-cppflags -DSQLITE_DEBUG
-               else
-                       append-cppflags -DNDEBUG
-               fi
-       fi
-
-       # icu USE flag.
-       if use icu; then
-               # Support ICU extension.
-               # https://sqlite.org/compile.html#enable_icu
-               append-cppflags -DSQLITE_ENABLE_ICU
-               if full_archive; then
-                       sed -e "s/^TLIBS = @LIBS@/& -licui18n -licuuc/" -i 
Makefile.in || die "sed failed"
-               else
-                       sed -e "s/^LIBS = @LIBS@/& -licui18n -licuuc/" -i 
Makefile.in || die "sed failed"
-               fi
-       fi
-
-       # readline USE flag.
-       options+=(
-               --disable-editline
-               $(use_enable readline)
-       )
-       if full_archive && use readline; then
-               
options+=(--with-readline-inc="-I${ESYSROOT}/usr/include/readline")
-       fi
-
-       # secure-delete USE flag.
-       if use secure-delete; then
-               # Enable secure_delete pragma by default.
-               # https://sqlite.org/pragma.html#pragma_secure_delete
-               append-cppflags -DSQLITE_SECURE_DELETE
-       fi
-
-       # static-libs USE flag.
-       options+=($(use_enable static-libs static))
-
-       # tcl, test, tools USE flags.
-       if full_archive; then
-               options+=(--enable-tcl)
-       fi
-
-       if [[ "${CHOST}" == *-mint* ]]; then
-               append-cppflags -DSQLITE_OMIT_WAL
-       fi
-
-       if [[ "${ABI}" == "x86" ]]; then
-               if $(tc-getCC) ${CPPFLAGS} ${CFLAGS} -E -P -dM - < /dev/null 2> 
/dev/null | grep -q "^#define __SSE__ 1$"; then
-                       append-cflags -mfpmath=sse
-               else
-                       append-cflags -ffloat-store
-               fi
-       fi
-
-       econf "${options[@]}"
-}
-
-multilib_src_compile() {
-       emake HAVE_TCL="$(usex tcl 1 "")" 
TCLLIBDIR="${EPREFIX}/usr/$(get_libdir)/${P}"
-
-       if use tools && multilib_is_native_abi; then
-               emake changeset dbdump dbhash dbtotxt index_usage rbu scrub 
showdb showjournal showshm showstat4 showwal sqldiff sqlite3_analyzer 
sqlite3_checker sqlite3_expert sqltclsh
-       fi
-}
-
-multilib_src_test() {
-       if [[ "${EUID}" -eq 0 ]]; then
-               ewarn "Skipping tests due to root permissions"
-               return
-       fi
-
-       local -x SQLITE_HISTORY="${T}/sqlite_history_${ABI}"
-
-       emake HAVE_TCL="$(usex tcl 1 "")" $(use debug && echo fulltest || echo 
test)
-}
-
-multilib_src_install() {
-       emake DESTDIR="${D}" HAVE_TCL="$(usex tcl 1 "")" 
TCLLIBDIR="${EPREFIX}/usr/$(get_libdir)/${P}" install
-
-       if use tools && multilib_is_native_abi; then
-               install_tool() {
-                       if [[ -f ".libs/${1}" ]]; then
-                               newbin ".libs/${1}" "${2}"
-                       else
-                               newbin "${1}" "${2}"
-                       fi
-               }
-
-               install_tool changeset sqlite3-changeset
-               install_tool dbdump sqlite3-db-dump
-               install_tool dbhash sqlite3-db-hash
-               install_tool dbtotxt sqlite3-db-to-txt
-               install_tool index_usage sqlite3-index-usage
-               install_tool rbu sqlite3-rbu
-               install_tool scrub sqlite3-scrub
-               install_tool showdb sqlite3-show-db
-               install_tool showjournal sqlite3-show-journal
-               install_tool showshm sqlite3-show-shm
-               install_tool showstat4 sqlite3-show-stat4
-               install_tool showwal sqlite3-show-wal
-               install_tool sqldiff sqlite3-diff
-               install_tool sqlite3_analyzer sqlite3-analyzer
-               install_tool sqlite3_checker sqlite3-checker
-               install_tool sqlite3_expert sqlite3-expert
-               install_tool sqltclsh sqlite3-tclsh
-
-               unset -f install_tool
-       fi
-}
-
-multilib_src_install_all() {
-       find "${D}" -name "*.la" -type f -delete || die
-
-       doman sqlite3.1
-
-       if use doc; then
-               rm "${WORKDIR}/${PN}-doc-${DOC_PV}/"*.{db,txt} || die
-               (
-                       docinto html
-                       dodoc -r "${WORKDIR}/${PN}-doc-${DOC_PV}/"*
-               )
-       fi
-}

Reply via email to