| sum(b ORDER BY a) FROM t1, t2 sums a instead of b: an aggregate's ORDER BY term replaces its argument |
fixed |
link |
| In a UTF-16 database, a blob DEFAULT from ALTER TABLE ADD COLUMN is converted to text as UTF-8 |
fixed |
link |
| UNION of four or more SELECTs drops rows: the balanced merge removes the right half's duplicates under that half's collation |
fixed |
link |
| A join on an INTEGER PRIMARY KEY misses the REAL key -9223372036854775808.0 when the plan has a Bloom filter |
fixed |
link |
| Compound SELECT with ORDER BY ... COLLATE moves the last SELECT's GROUP BY, HAVING and DISTINCT to the whole compound |
fixed |
link |
| concat() and concat_ws() of a BLOB in a UTF-16 database copy the BLOB's size, not the text's: a NUL and stale bytes in the result |
reported by others |
link |
| DELETE reports "database disk image is malformed" on a database that passes integrity_check (WITHOUT ROWID, tiny key) |
fixed |
link |
| "database disk image is malformed" from a write after a one-pass DELETE in the same statement (WITHOUT ROWID): the delete cursor keeps the deleted cell's CellInfo |
fixed |
link |
| ALTER TABLE DROP CONSTRAINT on a foreign key with SET DEFAULT, NOT DEFERRABLE or MATCH fails or leaves part of the constraint behind |
fixed |
link |
| ALTER COLUMN DROP NOT NULL removes NOT DEFERRABLE instead of NOT NULL, or removes a DEFERRABLE clause that follows NOT NULL |
fixed |
link |
Join drops rows, or adds some, when a table has an index on an expression and a col = constant WHERE term |
fixed |
link |
| A UNION ALL subquery in FROM with a RIGHT JOIN after its first SELECT loses WHERE terms when flattened |
fixed |
link |
| FTS5: wrong instances for phrases below a non-matching AND, and on the right of a NOT whose left side matches no row |
fixed |
link |
| FTS5: DROP TABLE and ALTER TABLE RENAME skip the %_content table of a contentless_unindexed=1 table |
fixed |
link |
| FTS5: with detail=none, secure-delete of a rowid that was replaced while secure-delete was off corrupts the index |
fixed |
link |
FTS5: "no such cursor: 0" from an auxiliary function in WHERE with the tbl = 'query' form (constant propagation) |
fixed |
link |
| With SQLITE_LIMIT_LENGTH below an FTS5 leaf size, fts5DataWrite ignores SQLITE_TOOBIG and stores NULL: persistent corruption |
fixed |
link |
| FTS5: INSERT into a locale=1, contentless_unindexed=1 table with an UNINDEXED column fails with "database disk image is malformed" |
fixed |
link |
FTS5: MATCH with rowid = <non-integer value> returns every match (regression after 3.51) |
fixed |
link |
| FTS5: phrases of a NEAR group that does not match a row report instances for that row, some left over from an earlier row |
fixed |
link |
| FTS5: the right operand of a NOT reports instances when the left operand matches no row |
fixed |
link |
| FTS5: ROLLBACK frees the index structure under an open MATCH query in another statement |
fixed |
link |
| FTS5: after secure-delete removes the last rowids of a long doclist, a query with a rowid lower bound returns rows of the next term |
fixed upstream before we reported it |
|
| FTS5: with secure-delete on, a merge can drop a delete marker, and a later secure delete makes an old entry for the rowid match again |
fixed |
link |
| FTS5 tokendata=1: a query for an absent term fails with "fts5: corruption found reading blob" after a long doclist |
fixed |
link |
| FTS5 tokendata=1: a prefix query followed by a term query in an open transaction reads freed memory |
fixed |
link |
| FTS5 trigram: a LIKE pushed down to FTS5 makes sqlite3Fts5ExprPattern() read one byte past the end of the pattern |
fixed |
link |
| FTS5 trigram: LIKE and GLOB on an UNINDEXED column return no rows |
open |
link |
| FTS5 detail=none/column: snippet() fails with "database disk image is malformed", highlight() and bm25() see matches in UNINDEXED columns |
fixed |
link |
FTS5: fts5vocab rowids restart in every scan, so term = ? OR term < ? and RIGHT JOIN return wrong rows |
fixed |
link |
FTS5: in a UTF-16 database, fts5vocab applies term < / > and ORDER BY term in UTF-8 order |
open |
link |
| fts5vocab: col IS NULL returns no rows since the WITHOUT ROWID schema change (reply in d29f636f37) |
fixed |
link |
| FULL JOIN USING column reads back as REAL through a subquery that is not flattened |
open |
link |
| An index on a VIRTUAL generated column with no type returns an integral REAL as an INTEGER |
fixed |
link |
Geopoly: rowid = <non-integer value> finds the row of its integer part |
fixed |
link |
| Geopoly: an UPDATE that changes the rowid but not _shape fails with "_shape does not contain a valid polygon" |
fixed |
link |
| GLOB 'é*' on an indexed untyped column misses an over-length UTF-8 blob that a scan finds (invalid UTF-8, garbage in, garbage out) |
not a bug |
|
| group_concat() window over a moving frame drops separators and text after an empty string |
fixed |
link |
x IN (SELECT …) in HAVING converts the GROUP BY term x by the IN's affinity for the whole query (regression in 3.15.0) |
reported by others |
SQLite, reported by someone else 2026-07-29; fixed by check-in b9ecd9caf7 |
| Rows out of order despite ORDER BY x DESC in a query with GROUP BY x over a subquery sorted by x ASC |
fixed |
link |
| x IN (SELECT y COLLATE NOCASE ...) misses rows when x has an index |
fixed |
link |
| Rows missing when a UNION ALL subquery or CTE is joined with an inner join followed by a RIGHT or FULL JOIN |
fixed |
link |
| A correlated subquery over a three-way join counts 0 for later outer rows (JoinMiss deletes automatic-index entries) |
fixed |
link |
| json_valid() returns 0 for valid JSON text based on json_set call |
fixed |
link |
LEFT JOIN with x = NULL AND y IN (…) on a two-column index returns a matched row as well as the NULL-extended one (regression in 3.43.0) |
fixed |
link |
| An OR in a LEFT JOIN's ON clause drives a loop on the left table: wrong rows, or a segfault when the joined table is omitted |
fixed |
link |
| LIKE optimization reads an uninitialized counter under a LEFT JOIN (reply in 74bf8db543) |
fixed |
link |
| a IN (...) AND c GLOB 'A' with an index on (a,c): GROUP BY splits a group, DISTINCT repeats a row (BLOB in c) |
fixed |
link |
| NOT INDEXED is ignored on WITHOUT ROWID tables: the planner still uses secondary and UNIQUE indexes |
fixed |
link |
| An OR term that uses a partial index WHERE a=5 and also tests a fails with "internal query planner error" |
fixed |
link |
| In a UTF-16 database, a blob over 4000 bytes read from a table's overflow pages is converted as UTF-8 |
fixed |
link |
| In a UTF-16 database, text over 4000 bytes read from a table loses a leading U+FEFF, and an UPDATE then writes it back without it |
fixed |
link |
| A partial index WHERE col = makes col read back as the constant: a TEXT '5.0' comes back as '5' |
partly fixed |
link |
| HAVING-to-WHERE and window push-down drop rows when a group holds both 1 and 1.0 |
open |
link |
| WHERE b = -9223372036854775808.0 AND typeof(b) = 'integer' misses a row whose INT column b holds that integer |
fixed |
link |
| RENAME COLUMN fails on an INTEGER PRIMARY KEY column named in a UNIQUE table constraint |
fixed |
link |
| A function result with both a number and its text keeps the old text after REAL affinity |
fixed |
link |
SELECT * over a USING join left of a RIGHT or FULL JOIN is "ambiguous column name" when a later table has that column |
open |
link |
| A WHERE-clause OR on a table left of a RIGHT JOIN drives a MULTI-INDEX OR and is never tested (extra rows) |
not reported upstream |
|
| Row-value IN in a join repeats rows: the inner loop iterates the full IN list, with duplicates, for one of its columns |
fixed |
link |
| With SQLITE_LIMIT_LENGTH below an R-Tree node size, nodeWrite ignores SQLITE_TOOBIG and stores NULL: persistent corruption (R-Tree, Geopoly) |
fixed |
link |
R-Tree: UPDATE ... SET rowid = N and INSERT INTO ...(rowid, ...) ignore the new rowid |
fixed |
link |
| ROLLBACK TO of a savepoint that dropped a table commits a stale root page in an incremental-vacuum database |
fixed |
link |
| OP_SeekRowid converts a key that has both a number and its text from the text |
fixed |
link |
| A statement that gets SQLITE_BUSY from an attached database keeps its statement transaction open |
open |
link |
| Statements holding statement transactions finished oldest-first close them out of LIFO order (debug assert; lost/kept updates in release after OOM); regression in 3.35.0 |
open |
link |
| ALTER TABLE RENAME COLUMN of a TEMP table fails when a TEMP trigger or view uses the column |
fixed |
link |
| UPDATE changes REAL -9223372036854775808.0 in a column it does not assign to INTEGER, but not in the index |
not reported upstream |
|
| "SQL logic error" on the next SAVEPOINT or COMMIT, and the transaction is lost, after ROLLBACK TO undoes a CREATE VIRTUAL TABLE (fts5, fts4) |
fixed |
link |
| FTS5, FTS3/4, R-Tree, Geopoly: a failed single-row write inside a transaction keeps partial shadow-table writes |
open |
link |
| With a window function, a correlated LEFT JOIN whose ON clause has a bare outer column as an AND term filters the left rows |
fixed |
link |
| "database disk image is malformed" or missing rows: ORDER BY an added column NULLS LAST on a WITHOUT ROWID table |
fixed |
link |
| "database disk image is malformed" or wrong answer: row-value IN (SELECT ...) over an added column of a WITHOUT ROWID table |
open |
link |
| Multi-index OR on a WITHOUT ROWID table misses rows when an OR-term uses OP_SeekScan |
fixed |
link |
| "database disk image is malformed" or missing rows: row-value range over an added column of a WITHOUT ROWID table |
open |
link |
| In a UTF-16 database, a zeroblob() result used as text is converted from UTF-8, so CAST(zeroblob(4) AS TEXT) has 8 bytes and the result depends on the query plan |
fixed |
link |