← All database systems

SQLite is supported by SQLancer — the main repository ships a testing implementation for it. SQLancer is credited with 222 bugs in it, reported between 2019-05-01 and 2026-03-20. Its source is at sqlite/sqlite.

A further 19 reports were filed and rejected by the developers as invalid or duplicate. Those are kept in the dataset for transparency and are excluded from every count here.

How the bugs break down

By year reported

2019
167
2020
11
2022
22
2023
6
2025
12
2026
4

Who found them

Found by the SQLancer project
222

By status

Fixed
210
Fixed in documentation
11
Confirmed
1

By symptom

Logic bug
90
Unexpected error
44
Crash
42
Hang
2
Unclassified
44

By technique

Technique not recorded
132
Pivoted Query Synthesis (PQS)
48
Non-optimizing Reference Engine Construction (NoREC)
38
Ternary Logic Partitioning (TLP)
4

Why each bug counts

The report names a SQLancer oracle
90
Listed in the project's own bug repository
88
The reproducer carries SQLancer's generated schema
44

Who reported them (5)

Manuel Rigger
178
bajinsheng
22
Zhaokun Xiang
12
Chi Zhang
6
Axel Teo
4

Every bug on record (241)

One row per report, newest first, each linking to the report itself. Rejected reports are marked and are not part of any count above.

Reported Report Status Technique Reporter
2026-03-20 Incorrect use of collation sequences on non-PK columns of a WITHOUT ROWID table for row value comparison fixed Axel Teo
2026-03-05 Incorrect skip-ahead optimization after modification to internal statistics table fixed Axel Teo
2026-01-26 Wrong collation used as part of a row-value comparison between columns with different collation sequences. fixed Axel Teo
2026-01-16 Incorrect comparison optimization on collation sequences fixed Axel Teo
2025-10-30 Unexpected NATURAL FULL JOIN result fixed Zhaokun Xiang
2025-10-29 Unexpected execution result in LEFT JOIN with subquery fixed Zhaokun Xiang
2025-08-21 ON clause references tables to its right in INNER JOIN fixed Zhaokun Xiang
2025-07-23 Unexpected execution result in the new EXISTS-to-JOIN optimization fixed Zhaokun Xiang
2025-07-13 Unexpected ANTI JOIN result fixed Zhaokun Xiang
2025-06-16 Unexpected multiple JOIN result fixed Zhaokun Xiang
2025-06-09 Multiple JOIN involving subquery containing TOTAL function produces wrong result fixed Zhaokun Xiang
2025-06-01 Unexpected multiple JOIN involving subquery containing CAST fixed Zhaokun Xiang
2025-05-31 Wrong FULL JOIN result fixed Zhaokun Xiang
2025-05-30 Unexpected multiple JOIN result involving NATURAL JOIN fixed Zhaokun Xiang
2025-05-30 Unexpected multiple JOIN result involving FULL JOIN, INNER JOIN and LEFT JOIN fixed Zhaokun Xiang
2025-05-28 Unexpected multiple JOIN result involving FULL JOIN and INNER JOIN fixed Zhaokun Xiang
2023-05-01 Unexpected result of `JOIN` fixed Chi Zhang
2023-03-23 An assertion failure only triggers in JDBC driver with -DSQLITE_DEBUG=1 compile option fixed Chi Zhang
2023-03-04 Incorrect result might caused by INDEX fixed Chi Zhang
2023-03-03 Incorrect result for COUNT on view with window function fixed Chi Zhang
2023-03-01 Incorrect result that might be caused by json function fixed Chi Zhang
2023-02-28 Incorrect results with the latest trunk version fixed Chi Zhang
2022-07-15 Assertion `pRec->nField>0 && pRec->nField<=pIdx->nSampleCol' failed. unknown bajinsheng
2022-07-13 Unexpected Result by Union unknown bajinsheng
2022-06-25 Unexpected Assertion Error in valueFromFunction unknown bajinsheng
2022-06-24 Unexpected Assertion Error in whereRangeScanEst fixed bajinsheng
2022-06-21 Unexpected Parse Error fixed bajinsheng
2022-06-20 Unexpected Expression on ON clause fixed bajinsheng
2022-06-20 Unexpected Expression Result by FULL OUTER JOIN fixed bajinsheng
2022-06-17 Unexpected Result by FULL OUTER JOIN fixed bajinsheng
2022-06-13 Unexpected Result by Complicated JOINING Again fixed bajinsheng
2022-06-10 Unexpected Result by RIGHT JOIN Again fixed bajinsheng
2022-06-10 Unexpected Result by Complicated JOINING unknown bajinsheng
2022-06-10 Assertion `pCur->eCurType==CURTYPE_VTAB' failed fixed bajinsheng
2022-06-09 Unexpected Result by JSON fixed bajinsheng
2022-06-08 Unexpected Result by RIGHT JOIN with INDEX fixed bajinsheng
2022-06-07 Unexpected Result by ORDER BY fixed bajinsheng
2022-06-06 Unexpected Result by RIGHT JOIN fixed bajinsheng
2022-06-02 Unexpected Result by WHERE Again fixed bajinsheng
2022-06-01 Unexpected Result by RIGHT JOIN on RTree Tables fixed bajinsheng
2022-05-31 Unexpected Result by Joining fixed bajinsheng
2022-05-25 Unexpected Result by WHERE/RIGHT JOIN fixed bajinsheng
2022-05-24 Unexpected Result by WHERE when Joining Tables fixed bajinsheng
2022-05-23 Ambiguous Reference Error for Right Join verified bajinsheng
2022-05-17 Expression or Constant in GroupBy Clause fixed bajinsheng
2022-05-15 Null value returned by TOTAL closed not a bug bajinsheng
2022-05-14 Rows are Unexpectedly Filtered Out by DISTINCT in RIGHT JOIN fixed bajinsheng
2022-05-13 An Unexpected NULL Column Caused by Where Clause in RIGHT JOIN fixed bajinsheng
2022-05-11 An Inconsistent Result Depending on Parenthesization fixed bajinsheng
2020-08-27 Unexpected result for % and '1E1' fixed in documentation PQS Manuel Rigger
2020-08-24 Incorrect result for IN expression with right-hand IS TRUE sub-expression fixed PQS Manuel Rigger
2020-04-25 UNION operator malfunctions in LEFT JOIN on view fixed TLP Manuel Rigger
2020-03-10 GROUP BY causes unexpected conversion fixed TLP Manuel Rigger
2020-03-05 Unexpected result for MIN on string that contains a null character fixed in documentation TLP Manuel Rigger
2020-03-04 MAX yields unexpected result for UTF-16 fixed TLP Manuel Rigger
2020-01-08 Incorrect result for query with 0 >= t0.c0 AND t0.c0 = v0.c0 condition fixed NOREC Manuel Rigger
2020-01-08 Incorrect result for COUNT(), UTF16be encoding and SUBSTR fixed NOREC Manuel Rigger
2020-01-04 DBSTAT query computes incorrect result for stat.aggregate = 1 condition closed not a bug NOREC Manuel Rigger
2020-01-04 DBSTAT query computes incorrect result for name column fixed NOREC Manuel Rigger
2020-01-04 DBSTAT query computes incorrect result for aggregate column fixed NOREC Manuel Rigger
2020-01-02 FTS5 integrity-check results in "database disk image is malformed" for UTF-16 encoding and SUBSTR fixed Manuel Rigger
2019-12-31 Debug assertion sqlite3VdbeMemAboutToChange: Assertion `(mFlags&MEM_Real)==0 || pMem->u.r==pX->u.r' failed (2) fixed Manuel Rigger
2019-12-30 NATURAL JOIN on virtual table results in "parse error in rank function" fixed Manuel Rigger
2019-12-30 Inconsistent handling of subqueries in index expressions closed not a bug Manuel Rigger
2019-12-30 Debug assertion codeVectorCompare: Assertion `0' failed fixed Manuel Rigger
2019-12-29 Trigger on normal table causes the database disk image to become malformed fixed Manuel Rigger
2019-12-28 Debug assertion sqlite3VdbeMemAboutToChange: Assertion `(mFlags&MEM_Real)==0 || pMem->u.r==pX->u.r' failed fixed Manuel Rigger
2019-12-28 Debug assertion sqlite3VdbeExec: Assertion `memIsValid(pRec)' failed fixed Manuel Rigger
2019-12-28 Debug assertion sqlite3VdbeExec: Assertion `memIsValid(&aMem[pOp->p1])' failed. fixed Manuel Rigger
2019-12-28 Debug assertion exprSrcCount: Assertion `0' failed fixed Manuel Rigger
2019-12-27 FTS4 integrity-check results in "database disk image is malformed" for UTF-16 encoding fixed in documentation Manuel Rigger
2019-12-27 Debug assertion assert_pager_state: Assertion `pPager->changeCountDone==0 || pPager->eLock>=RESERVED_LOCK' ... fixed Manuel Rigger
2019-12-26 Debug assertion sqlite3FinishCoding: Assertion `!pParse->isMultiWrite || sqlite3VdbeAssertMayAbort(v, pPars... fixed Manuel Rigger
2019-12-26 Debug assertion sqlite3BtreeInsert: Assertion `pCur->curFlags & BTCF_ValidNKey' failed fixed Manuel Rigger
2019-12-25 Debug assertion sqlite3TableColumnAffinity: Assertion `iColnCol' failed. fixed Manuel Rigger
2019-12-25 Debug assertion fts5CheckTransactionState: Assertion `iSavepoint<=p->ts.iSavepoint' failed fixed Manuel Rigger
2019-12-24 FTS database disk image is malformed for UTF-16 encoding and integrity check fixed Manuel Rigger
2019-12-24 Debug assertion sqlite3Fts5HashScanNext: Assertion `!sqlite3Fts5HashScanEof(p)' failed fixed Manuel Rigger
2019-12-23 UPDATE with complex WHERE condition on rtree results in "database table is locked" error fixed in documentation Manuel Rigger
2019-12-23 FTS database disk image is malformed for special characters in table fixed Manuel Rigger
2019-12-23 Debug assertion sqlite3VdbeMemAboutToChange: Assertion `(mFlags&MEM_Str)==0 || (pMem->n==pX->n && pMem->z==... fixed Manuel Rigger
2019-12-23 Debug assertion sqlite3VdbeExec: Assertion `pIn1!=pIn3' failed (2) fixed Manuel Rigger
2019-12-23 Debug assertion sqlite3VdbeExec: Assertion `pC!=0' failed fixed Manuel Rigger
2019-12-23 Debug assertion sqlite3VdbeExec: Assertion `flags3==pIn3->flags' failed (2) fixed Manuel Rigger
2019-12-23 Debug assertion sqlite3MemCompare: Assertion `pMem1->enc==pMem2->enc || pMem1->db->mallocFailed' failed fixed Manuel Rigger
2019-12-23 Debug assertion rtreeRelease: Assertion `pRtree->nNodeRef==0 || pRtree->bCorrupt' failed fixed Manuel Rigger
2019-12-23 Debug assertion impliesNotNullRow: Assertion `pWalker->eCode==0' failed fixed Manuel Rigger
2019-12-22 SELECT on window function causes a segfault fixed Manuel Rigger
2019-12-22 Debug assertion sqlite3VdbeMemAboutToChange: Assertion `(mFlags&MEM_Str)==0 || (pMem->n==pX->n && pMem->z==... fixed Manuel Rigger
2019-12-22 Debug assertion sqlite3VdbeExec: Assertion `pIn1!=pIn3' failed fixed Manuel Rigger
2019-12-22 Debug assertion sqlite3VdbeExec: Assertion `memIsValid(pRec)' failed fixed Manuel Rigger
2019-12-22 Debug assertion sqlite3VdbeExec: Assertion `flags3==pIn3->flags' failed fixed Manuel Rigger
2019-12-22 Debug assertion sqlite3ExprSkipCollateAndLikely: Assertion `pExpr->op==TK_COLLATE' failed fixed Manuel Rigger
2019-12-22 Debug assertion fts5StructureRead: Assertion `p->iStructVersion!=0' failed fixed Manuel Rigger
2019-12-22 Debug assertion constructAutomaticIndex: Assertion `!ExprHasProperty(pExpr, EP_FromJoin) || pExpr->iRightJo... fixed Manuel Rigger
2019-12-21 FTS database disk image is malformed for update on languageid fixed Manuel Rigger
2019-12-20 Incorrect result for BETWEEN and generated column fixed NOREC Manuel Rigger
2019-12-20 FTS database disk image is malformed for UTF-16 encoding fixed Manuel Rigger
2019-12-20 FILTER clause in window function causes a segfault fixed Manuel Rigger
2019-12-19 UPDATE causes "database table is locked" for rtree table fixed Manuel Rigger
2019-12-16 LEFT JOIN malfunctions with generated column fixed NOREC Manuel Rigger
2019-12-14 REINDEX segfaults on table with generated columns fixed Manuel Rigger
2019-12-11 LEFT JOIN segfault on rtree table fixed Manuel Rigger
2019-12-11 FTS database disk image is malformed for UTF-16 encoding after update fixed Manuel Rigger
2019-12-10 REINDEX results in "UNIQUE constraint failed" for generated column fixed Manuel Rigger
2019-12-09 PRAGMA integrity_check does not terminate on table with generated column fixed Manuel Rigger
2019-12-08 Query on table without rows and generated column results in "out of memory" error fixed Manuel Rigger
2019-12-06 NOT NULL auxiliary column in rtree table malfunctions fixed in documentation NOREC Manuel Rigger
2019-12-06 Incorrect result for predicate on rtree table fixed NOREC Manuel Rigger
2019-12-06 Generated column and foreign key causes a segfault fixed Manuel Rigger
2019-12-06 Comparison on INT column in rtree table malfunctions fixed NOREC Manuel Rigger
2019-12-06 CREATE VIRTUAL TABLE causes segfault fixed Manuel Rigger
2019-12-05 column = NULL predicate evaluates to TRUE for rtree table fixed NOREC Manuel Rigger
2019-12-05 Row value comparison malfunctions with rtree table fixed NOREC Manuel Rigger
2019-12-05 Join on two rtree tables malfunctions fixed NOREC Manuel Rigger
2019-12-04 Incorrect result for TEXT comparison on rtree table fixed NOREC Manuel Rigger
2019-11-30 LEFT JOIN malfunctions with partial ISNULL index fixed NOREC Manuel Rigger
2019-11-07 VACUUM results in "database disk image is malformed" for PRIMARY KEY with duplicate column fixed Manuel Rigger
2019-11-07 UPDATE on table with two generated columns and CHECK clause results in segfault fixed Manuel Rigger
2019-11-07 DISTINCT malfunctions for VIEW with virtual table fixed NOREC Manuel Rigger
2019-11-06 Segfault when inserting into table with generated columns fixed Manuel Rigger
2019-11-06 REPLACE on table with generated NOT NULL column results in segfault fixed Manuel Rigger
2019-11-06 NULL WHERE condition unexpectedly results in row being fetched fixed NOREC Manuel Rigger
2019-11-05 UNLIKELY in query causes row to not be fetched closed not a bug NOREC Manuel Rigger
2019-11-04 Row value comparison malfunctions on view with left join fixed NOREC Manuel Rigger
2019-11-03 PRAGMA integrity_check fails due to CHECK constraint even without records fixed Manuel Rigger
2019-11-03 LEFT JOIN in view malfunctions with partial index on table fixed NOREC Manuel Rigger
2019-11-02 Incorrect result for GLOB operator fixed NOREC Manuel Rigger
2019-11-01 REPLACE causes segfault in table with generated column and foreign key fixed Manuel Rigger
2019-10-31 VACUUM on table with generated column that uses TYPEOF results in an error fixed Manuel Rigger
2019-10-31 Segfault in table with generated column and foreign key fixed Manuel Rigger
2019-10-29 VACUUM on table with generated column results in an error fixed Manuel Rigger
2019-10-29 VACUUM issue on table with generated column fixed Manuel Rigger
2019-10-29 Segfault when updating table with generated columns fixed Manuel Rigger
2019-10-27 Segfault in table with generated columns fixed Manuel Rigger
2019-10-26 REINDEX causes "UNIQUE constraint failed" error for generated column fixed Manuel Rigger
2019-10-25 Trigger causes query to compute incorrect result fixed NOREC Manuel Rigger
2019-10-24 FTS integrity-check malfunctions nondeterministically with tokenize="ascii" fixed Manuel Rigger
2019-10-24 Crash on REPLACE INTO of a table with an AFTER DELETE trigger fixed Manuel Rigger
2019-10-23 Comparison of row values with COLLATE NOCASE yields incorrect result fixed NOREC Manuel Rigger
2019-10-22 Row value comparison yields incorrect result fixed NOREC Manuel Rigger
2019-10-22 Comparison of row values results in incorrect result fixed NOREC Manuel Rigger
2019-10-21 INSERT into table with two triggers does not terminate closed not a bug Manuel Rigger
2019-10-17 FTS merge does not terminate fixed Manuel Rigger
2019-10-16 Trigger inserts duplicate value in UNIQUE column fixed Manuel Rigger
2019-10-11 FTS order=DESC results into integrity-check failing fixed Manuel Rigger
2019-10-11 FTS integrity_check fails when inserting x'00' fixed Manuel Rigger
2019-10-11 FTS integrity-check malfunctions for transaction and the prefix option fixed Manuel Rigger
2019-10-10 LEFT JOIN in view malfunctions with NOTNULL fixed NOREC Manuel Rigger
2019-10-09 LEFT JOIN in view malfunctions fixed NOREC Manuel Rigger
2019-10-09 FTS rebuild in combination with crisismerge results in error "database or disk is full" fixed Manuel Rigger
2019-10-09 FTS integrity-check indicates that the database disk image is malformed fixed Manuel Rigger
2019-10-07 FTS rebuild in transaction causes integrity-check to fail fixed Manuel Rigger
2019-10-07 FTS pgsz option results in "database disk image is malformed" error fixed Manuel Rigger
2019-10-07 FTS integrity-check malfunctions fixed Manuel Rigger
2019-10-07 Comparison on view malfunctions fixed NOREC Manuel Rigger
2019-09-17 Row is not fetched when using WHERE clause with INSTR() fixed NOREC Manuel Rigger
2019-09-16 GLOB unexpectedly does not match fixed NOREC Manuel Rigger
2019-09-11 COLLATE issue in view fixed NOREC Manuel Rigger
2019-09-10 DISTINCT malfunctions for VIEW closed not a bug NOREC Manuel Rigger
2019-09-09 BETWEEN issue in view fixed NOREC Manuel Rigger
2019-09-03 IS NULL unexpectedly evaluates to TRUE fixed NOREC Manuel Rigger
2019-09-03 COLLATE NOCASE string comparison yields incorrect result fixed NOREC Manuel Rigger
2019-09-02 Expression computed on row yields incorrect result fixed NOREC Manuel Rigger
2019-09-02 Different rounding when converting TEXT to REAL fixed NOREC Manuel Rigger
2019-08-30 REINDEX causes "UNIQUE constraint failed" error fixed Manuel Rigger
2019-08-30 Partial index causes row to not be fetched in BETWEEN expression fixed NOREC Manuel Rigger
2019-08-30 Partial index causes row to not be fetched fixed NOREC Manuel Rigger
2019-08-30 Partial index and BETWEEN issue fixed NOREC Manuel Rigger
2019-08-28 Short-circuit evaluation issue closed not a bug NOREC Manuel Rigger
2019-08-27 Unexpected affinity conversion is performed for the IN operator fixed NOREC Manuel Rigger
2019-08-22 Row with comparison on TEXT UNIQUE column is not fetched fixed PQS Manuel Rigger
2019-08-22 Row is not fetched in table with INTEGER PRIMARY KEY fixed PQS Manuel Rigger
2019-08-22 LIKELY() seems to cause unexpected affinity conversion for rowid fixed PQS Manuel Rigger
2019-08-21 DISTINCT malfunctions for IS NULL fixed PQS Manuel Rigger
2019-08-20 INDEXED BY results in row not being fetched fixed PQS Manuel Rigger
2019-08-17 WHERE clause erroneously influences value of fetched column from view fixed PQS Manuel Rigger
2019-08-17 LEFT JOIN fails to fetch row fixed PQS Manuel Rigger
2019-08-15 Null pointer dereference caused by window functions in result-set of EXISTS(SELECT ...) fixed Manuel Rigger
2019-08-14 Unexpected error in DELETE with existing trigger closed not a bug Manuel Rigger
2019-08-10 Constant expression in partial index results in row not being fetched fixed PQS Manuel Rigger
2019-08-07 Incorrect result for query that uses MIN() and a CAST on rowid fixed PQS Manuel Rigger
2019-08-06 Unexpected affinity conversion for view column in IN operator fixed PQS Manuel Rigger
2019-08-05 Unexpected affinity conversion in view fixed PQS Manuel Rigger
2019-08-05 Row is not fetched in SELECT from VIEW fixed PQS Manuel Rigger
2019-08-03 MIN() malfunctions for a query with ISNULL condition fixed PQS Manuel Rigger
2019-07-30 Query with DISTINCT does not fetch all distinct rows fixed PQS Manuel Rigger
2019-07-29 Query with ORDER BY results in "database disk image is malformed" error fixed Manuel Rigger
2019-07-29 Issue with DISTINCT and COLLATE closed not a bug PQS Manuel Rigger
2019-07-29 ANALYZE causes DISTINCT to malfunction in CROSS JOIN fixed PQS Manuel Rigger
2019-07-02 MIN() malfunctions for UNIQUE column fixed PQS Manuel Rigger
2019-06-16 COLLATE in BETWEEN expression is ignored fixed PQS Manuel Rigger
2019-06-14 LIKE malfunctions for UNIQUE COLLATE NOCASE column fixed PQS Manuel Rigger
2019-06-14 Built-in RTRIM collating sequence yields incorrect comparisons fixed PQS Manuel Rigger
2019-06-12 IS TRUE operator malfunctions with COLLATE and REAL value fixed PQS Manuel Rigger
2019-06-12 CAST('-0.0' AS NUMERIC) computes 0.0 rather than 0 fixed PQS Manuel Rigger
2019-06-12 CAST takes implicit COLLATE of its operand fixed in documentation PQS Manuel Rigger
2019-06-11 Lossless conversion when casting a large TEXT number to NUMERIC is not performed fixed in documentation PQS Manuel Rigger
2019-06-11 LIKELY(), UNLIKELY() and LIKELIHOOD() have affinities fixed PQS Manuel Rigger
2019-06-11 COLLATE expression in the right side of an IN operator results in an affinity conversion fixed PQS Manuel Rigger
2019-06-11 -'1.0' computes -1.0 rather than -1 fixed in documentation PQS Manuel Rigger
2019-06-10 TEXT value interpreted as column name in an index with empty list in an IN expression fixed Manuel Rigger
2019-06-10 LIKE malfunctions for INT PRIMARY KEY COLLATE NOCASE column fixed PQS Manuel Rigger
2019-06-10 Illegal argument to LIKELIHOOD() does not result in error when combined with "IN ()" fixed Manuel Rigger
2019-06-10 COLLATE expression has an affinity fixed in documentation PQS Manuel Rigger
2019-06-10 CAST('.' AS NUMERIC) computes 0.0 rather than 0 fixed PQS Manuel Rigger
2019-06-10 Another case of Illegal argument to LIKELIHOOD() does not result in error when combined with "IN ()" fixed Manuel Rigger
2019-06-08 CAST to NUMERIC no longer converts to INTEGER fixed PQS Manuel Rigger
2019-05-30 Unique index that uses GLOB does not detect duplicate due to REAL conversion fixed Manuel Rigger
2019-05-28 String interpreted as a column name when creating an index closed not a bug Manuel Rigger
2019-05-28 PRAGMA case_sensitive_like conflicts with LIKE operator when creating an index closed duplicate Manuel Rigger
2019-05-28 PRAGMA case_sensitive_like can corrupt some databases fixed Manuel Rigger
2019-05-28 COLLATE nocase index on a WITHOUT ROWID table malfunctions fixed PQS Manuel Rigger
2019-05-25 Incorrect result when subtracting a large integer number from a TEXT value fixed PQS Manuel Rigger
2019-05-25 CAST('-' AS NUMERIC) computes 0.0 fixed PQS Manuel Rigger
2019-05-21 "Malformed database schema" when creating a failing index within a transaction fixed Manuel Rigger
2019-05-19 Nested boolean formula with IN operator computes an incorrect result fixed PQS Manuel Rigger
2019-05-19 Index on non-existing column results in a fabricated value being fetched fixed PQS Manuel Rigger
2019-05-18 Query results in a SEGFAULT fixed Manuel Rigger
2019-05-16 REAL rounding seems to depend on FROM clause fixed PQS Manuel Rigger
2019-05-16 Malformed image when using no journal mode, zero cache size, and failing when creating an index fixed in documentation Manuel Rigger
2019-05-14 PRAGMA reverse_unordered_selects=true results in row not being fetched fixed PQS Manuel Rigger
2019-05-13 REINDEX causes rows not to be fetched in a WITHOUT ROWIDs table and PRIMARY KEY DESC fixed PQS Manuel Rigger
2019-05-13 Mixing main and temp databases in foreign keys is not supported closed not a bug Manuel Rigger
2019-05-11 Partial NOT NULL index malfunctions with IS NOT/!= fixed PQS Manuel Rigger
2019-05-10 Incorrect handling of Infinity by the ROUND function fixed PQS Manuel Rigger
2019-05-09 Row is not fetched with PRAGMA reverse_unordered_selects=true fixed PQS Manuel Rigger
2019-05-09 Malformed database image when using a REAL PRIMARY KEY fixed Manuel Rigger
2019-05-08 './' LIKE './' does not match fixed PQS Manuel Rigger
2019-05-07 Incorrect result for "<" and "<=" comparison of rowid and non-numeric text value fixed PQS Manuel Rigger
2019-05-07 INSERT OR FAIL inserts row although it violates a table constraint fixed PQS Manuel Rigger
2019-05-06 ALTER TABLE fails when renaming an INTEGER PRIMARY KEY column in a WITHOUT ROWID table fixed Manuel Rigger
2019-05-05 REAL PRIMARY KEY and floating point comparison does not work closed duplicate PQS Manuel Rigger
2019-05-04 Incorrect result on a table scan of a partial index fixed PQS Manuel Rigger
2019-05-03 Problem with REAL values and string functions used in indexes or on expressions fixed Manuel Rigger
2019-05-03 GLOB and minus in index and real column closed duplicate Manuel Rigger
2019-05-02 UPSERT documentation issue fixed in documentation Manuel Rigger
2019-05-02 TYPEOF index on REAL column malfunctions fixed Manuel Rigger
2019-05-02 Index on REAL column malfunctions when multiplying with a string closed duplicate Manuel Rigger
2019-05-01 Multi-row insert circumvents index check fixed Manuel Rigger
2019-05-01 COLLATE NOCASE index on REAL column malfunctions fixed PQS Manuel Rigger

Every figure on this page is computed from _data/impact/. The attribution policy explains what has to be true for a bug to be counted.