dev-db/sqlite: remove unused patches

Signed-off-by: Michael Mair-Keimberger <mmk@levelnine.at>
Signed-off-by: Conrad Kostecki <conikost@gentoo.org>

2 files changed, 0 insertions, 312 deletions

diff --git a/dev-db/sqlite/files/sqlite-3.44.2-fts-regression.patch b/dev-db/sqlite/files/sqlite-3.44.2-fts-regression.patch
deleted file mode 100644
index 369732f81b38..000000000000
--- a/dev-db/sqlite/files/sqlite-3.44.2-fts-regression.patch
+++ /dev/null
@@ -1,125 +0,0 @@
-https://bugs.gentoo.org/921490
-https://www.sqlite.org/forum/forumpost/d16aeb397d
-
-https://github.com/kovidgoyal/calibre/commit/0a23fabd5b4bff152047ba0cffbc2b67592645d1
-https://github.com/kovidgoyal/calibre/commit/3349979551db05ec0c8754d7ea5a4e57a97f8a0a
-https://github.com/kovidgoyal/calibre/commit/da82b673f09efbe9cdcc1e0900f0a9f04d8de052
---- a/ext/fts5/fts5_aux.c
-+++ b/ext/fts5/fts5_aux.c
-@@ -209,10 +209,18 @@
-       rc = fts5CInstIterNext(&p->iter);
-     }
-   }
- 
-   if( iPos==p->iRangeEnd ){
-+    if( p->bOpen ){
-+      if( p->iter.iStart>=0 && iPos>=p->iter.iStart ){
-+        fts5HighlightAppend(&rc, p, &p->zIn[p->iOff], iEndOff - p->iOff);
-+        p->iOff = iEndOff;
-+      }
-+      fts5HighlightAppend(&rc, p, p->zClose, -1);
-+      p->bOpen = 0;
-+    }
-     fts5HighlightAppend(&rc, p, &p->zIn[p->iOff], iEndOff - p->iOff);
-     p->iOff = iEndOff;
-   }
- 
-   return rc;
-
-ADDED   ext/fts5/test/fts5tokenizer2.test
-Index: ext/fts5/test/fts5tokenizer2.test
-==================================================================
---- /dev/null
-+++ b/ext/fts5/test/fts5tokenizer2.test
-@@ -0,0 +1,89 @@
-+# 2023 Nov 03
-+#
-+# 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.
-+#    May you find forgiveness for yourself and forgive others.
-+#    May you share freely, never taking more than you give.
-+#
-+#***********************************************************************
-+#
-+# Tests focusing on the built-in fts5 tokenizers. 
-+#
-+
-+source [file join [file dirname [info script]] fts5_common.tcl]
-+set testprefix fts5tokenizer2
-+
-+# If SQLITE_ENABLE_FTS5 is defined, omit this file.
-+ifcapable !fts5 {
-+  finish_test
-+  return
-+}
-+
-+sqlite3_fts5_create_tokenizer db tst get_tst_tokenizer
-+proc get_tst_tokenizer {args} {
-+  return "tst_tokenizer"
-+}
-+proc tst_tokenizer {flags txt} {
-+  set token ""
-+  set lTok [list]
-+
-+  foreach c [split $txt {}] {
-+    if {$token==""} {
-+      append token $c
-+    } else {
-+      set t1 [string is upper $token]
-+      set t2 [string is upper $c]
-+
-+      if {$t1!=$t2} {
-+        lappend lTok $token
-+        set token ""
-+      }
-+      append token $c
-+    }
-+  }
-+  if {$token!=""} { lappend lTok $token }
-+
-+  set iOff 0
-+  foreach t $lTok {
-+    set n [string length $t]
-+    sqlite3_fts5_token $t $iOff [expr $iOff+$n]
-+    incr iOff $n
-+  }
-+}
-+
-+do_execsql_test 1.0 {
-+  CREATE VIRTUAL TABLE t1 USING fts5(t, tokenize=tst);
-+}
-+
-+do_execsql_test 1.1 {
-+  INSERT INTO t1 VALUES('AAdontBBmess');
-+}
-+
-+do_execsql_test 1.2 {
-+  SELECT snippet(t1, 0, '>', '<', '...', 4) FROM t1('BB');
-+} {AAdont>BB<mess}
-+
-+do_execsql_test 1.3 {
-+  SELECT highlight(t1, 0, '>', '<') FROM t1('BB');
-+} {AAdont>BB<mess}
-+
-+do_execsql_test 1.4 {
-+  SELECT highlight(t1, 0, '>', '<') FROM t1('AA');
-+} {>AA<dontBBmess}
-+
-+do_execsql_test 1.5 {
-+  SELECT highlight(t1, 0, '>', '<') FROM t1('dont');
-+} {AA>dont<BBmess}
-+
-+do_execsql_test 1.6 {
-+  SELECT highlight(t1, 0, '>', '<') FROM t1('mess');
-+} {AAdontBB>mess<}
-+
-+do_execsql_test 1.7 {
-+  SELECT highlight(t1, 0, '>', '<') FROM t1('BB mess');
-+} {AAdont>BBmess<}
-+
-+
-+finish_test
-
-
diff --git a/dev-db/sqlite/files/sqlite-3.44.2-tracker-regression.patch b/dev-db/sqlite/files/sqlite-3.44.2-tracker-regression.patch
deleted file mode 100644
index b03848a19147..000000000000
--- a/dev-db/sqlite/files/sqlite-3.44.2-tracker-regression.patch
+++ /dev/null
@@ -1,187 +0,0 @@
-https://sqlite.org/forum/forumpost/cb59d962fd
-https://sqlite.org/src/vinfo/d8c6b246
-https://sqlite.org/src/info/67da596d82ec0ed3 (backport)
-
---- a/ext/fts5/fts5_index.c
-+++ b/ext/fts5/fts5_index.c
-@@ -355,10 +355,11 @@
-   int nContentlessDelete;         /* Number of contentless delete ops */
-   int nPendingRow;                /* Number of INSERT in hash table */
- 
-   /* Error state. */
-   int rc;                         /* Current error code */
-+  int flushRc;
- 
-   /* State used by the fts5DataXXX() functions. */
-   sqlite3_blob *pReader;          /* RO incr-blob open on %_data table */
-   sqlite3_stmt *pWriter;          /* "INSERT ... %_data VALUES(?,?)" */
-   sqlite3_stmt *pDeleter;         /* "DELETE FROM %_data ... id>=? AND id<=?" */
-@@ -4000,10 +4001,11 @@
-   assert( p->pHash || p->nPendingData==0 );
-   if( p->pHash ){
-     sqlite3Fts5HashClear(p->pHash);
-     p->nPendingData = 0;
-     p->nPendingRow = 0;
-+    p->flushRc = SQLITE_OK;
-   }
-   p->nContentlessDelete = 0;
- }
- 
- /*
-@@ -5582,18 +5584,24 @@
- /*
- ** Flush any data stored in the in-memory hash tables to the database.
- */
- static void fts5IndexFlush(Fts5Index *p){
-   /* Unless it is empty, flush the hash table to disk */
-+  if( p->flushRc ){
-+    p->rc = p->flushRc;
-+    return;
-+  }
-   if( p->nPendingData || p->nContentlessDelete ){
-     assert( p->pHash );
-     fts5FlushOneHash(p);
-     if( p->rc==SQLITE_OK ){
-       sqlite3Fts5HashClear(p->pHash);
-       p->nPendingData = 0;
-       p->nPendingRow = 0;
-       p->nContentlessDelete = 0;
-+    }else if( p->nPendingData || p->nContentlessDelete ){
-+      p->flushRc = p->rc;
-     }
-   }
- }
- 
- static Fts5Structure *fts5IndexOptimizeStruct(
-
---- a/ext/fts5/fts5_main.c
-+++ b/ext/fts5/fts5_main.c
-@@ -116,11 +116,11 @@
-   Fts5Table p;                    /* Public class members from fts5Int.h */
-   Fts5Storage *pStorage;          /* Document store */
-   Fts5Global *pGlobal;            /* Global (connection wide) data */
-   Fts5Cursor *pSortCsr;           /* Sort data from this cursor */
-   int iSavepoint;                 /* Successful xSavepoint()+1 */
--  int bInSavepoint;
-+  
- #ifdef SQLITE_DEBUG
-   struct Fts5TransactionState ts;
- #endif
- };
- 
-@@ -2613,13 +2613,11 @@
-   sqlite3_vtab *pVtab,            /* Virtual table handle */
-   const char *zName               /* New name of table */
- ){
-   int rc;
-   Fts5FullTable *pTab = (Fts5FullTable*)pVtab;
--  pTab->bInSavepoint = 1;
-   rc = sqlite3Fts5StorageRename(pTab->pStorage, zName);
--  pTab->bInSavepoint = 0;
-   return rc;
- }
- 
- int sqlite3Fts5FlushToDisk(Fts5Table *pTab){
-   fts5TripCursors((Fts5FullTable*)pTab);
-@@ -2632,30 +2630,16 @@
- ** Flush the contents of the pending-terms table to disk.
- */
- static int fts5SavepointMethod(sqlite3_vtab *pVtab, int iSavepoint){
-   Fts5FullTable *pTab = (Fts5FullTable*)pVtab;
-   int rc = SQLITE_OK;
--  char *zSql = 0;
-+
-   fts5CheckTransactionState(pTab, FTS5_SAVEPOINT, iSavepoint);
--
--  if( pTab->bInSavepoint==0 ){
--    zSql = sqlite3_mprintf("INSERT INTO %Q.%Q(%Q) VALUES('flush')",
--        pTab->p.pConfig->zDb, pTab->p.pConfig->zName, pTab->p.pConfig->zName
--    );
--    if( zSql ){
--      pTab->bInSavepoint = 1;
--      rc = sqlite3_exec(pTab->p.pConfig->db, zSql, 0, 0, 0);
--      pTab->bInSavepoint = 0;
--      sqlite3_free(zSql);
--    }else{
--      rc = SQLITE_NOMEM;
--    }
--    if( rc==SQLITE_OK ){
--      pTab->iSavepoint = iSavepoint+1;
--    }
--  }
--
-+  rc = sqlite3Fts5FlushToDisk((Fts5Table*)pVtab);
-+  if( rc==SQLITE_OK ){
-+    pTab->iSavepoint = iSavepoint+1;
-+  }
-   return rc;
- }
- 
- /*
- ** The xRelease() method.
-@@ -2912,11 +2896,11 @@
- /*
- ** Run an integrity check on the FTS5 data structures.  Return a string
- ** if anything is found amiss.  Return a NULL pointer if everything is
- ** OK.
- */
--static int fts5Integrity(
-+static int fts5IntegrityMethod(
-   sqlite3_vtab *pVtab,    /* the FTS5 virtual table to check */
-   const char *zSchema,    /* Name of schema in which this table lives */
-   const char *zTabname,   /* Name of the table itself */
-   int isQuick,            /* True if this is a quick-check */
-   char **pzErr            /* Write error message here */
-@@ -2970,11 +2954,11 @@
-     /* xRename       */ fts5RenameMethod,
-     /* xSavepoint    */ fts5SavepointMethod,
-     /* xRelease      */ fts5ReleaseMethod,
-     /* xRollbackTo   */ fts5RollbackToMethod,
-     /* xShadowName   */ fts5ShadowName,
--    /* xIntegrity    */ fts5Integrity
-+    /* xIntegrity    */ fts5IntegrityMethod
-   };
- 
-   int rc;
-   Fts5Global *pGlobal = 0;
- 
-
---- a/ext/fts5/test/fts5misc.test
-+++ b/ext/fts5/test/fts5misc.test
-@@ -89,11 +89,10 @@
-   CREATE VIRTUAL TABLE vt0 USING fts5(c0);
-   BEGIN TRANSACTION;
-   INSERT INTO vt0(c0) VALUES ('xyz');
- }
- 
--breakpoint
- do_execsql_test 2.2.2 {
-   ALTER TABLE t0 RENAME TO t1;
- }
- do_execsql_test 2.2.3 {
-   INSERT INTO vt0(vt0) VALUES('integrity-check');
-@@ -498,8 +497,23 @@
- } {assertionfaultproblem}
- do_execsql_test 17.5 {
-   SELECT c0 FROM t0 WHERE c0 GLOB '*faul*';
- } {assertionfaultproblem}
- 
-+#-------------------------------------------------------------------------
-+reset_db
-+do_execsql_test 18.0 {
-+  BEGIN;
-+    CREATE VIRTUAL TABLE t1 USING fts5(text);
-+    ALTER TABLE t1 RENAME TO t2;
-+}
-+
-+do_execsql_test 18.1 {
-+    DROP TABLE t2;
-+}
-+
-+do_execsql_test 18.2 {
-+  COMMIT;
-+}
- 
- finish_test
- 
-