SQLite Bug Forum

Forum
Login
New Thread Timeline  Max:

Most recent threads

3.4 hours ago ALTER TABLE / VACUUM on a main table while a TEMP table of the same name exists: triggers are not rewritten3 posts spanning 4.0 daysResolved
7.0 hours ago abs() preserves negative zero, affecting subsequent atan2() resultsno repliesOpen
9.9 hours ago A valid trigger whose UPDATE … FROM has a JOIN … ON clause using a column name that UPDATE target also has makes ALTER failedno repliesOpen
13.9 hours ago sqlite3_carray_bind() with SQLITE_CARRAY_BLOB and SQLITE_TRANSIENT turns NULL elements into empty BLOBs2 posts spanning 13.3 hoursResolved
15.6 hours ago printf('%.2e', 33250.0) gives 3.32e+04: some exact rounding ties round toward zero (regression in 3.52.0)2 posts spanning 11.7 hoursOpen
15.9 hours ago tables_used() omits the btrees that a statement clears or destroys: "DELETE FROM t" (truncate) and "DROP TABLE t" report no t2 posts spanning 11.5 hoursResolved
27.4 hours ago generate_series(): a TEXT or BLOB operand in a constraint on "value" is converted to an integer, giving rows that the compari3 posts spanning 6.0 daysResolved
1.8 days ago ALTER TABLE temp.t1 RENAME TO fails when a TEMP trigger is defined on main.t12 posts spanning 4.0 daysResolved
1.9 days ago ALTER TABLE main.t1 RENAME TO also rewrites a TEMP trigger's INSERT INTO t1 that refers to temp.t12 posts spanning 3.9 daysResolved
2.0 days ago ALTER TABLE RENAME COLUMN fails when a trigger's UPDATE ... FROM names the column in a JOIN ... ON clause2 posts spanning 3.9 daysResolved
2.3 days ago ALTER TABLE ADD COLUMN fails with "incomplete input" when the column definition ends with a -- comment2 posts spanning 3.5 daysResolved
2.4 days ago ALTER TABLE ADD CHECK fails with "incomplete input" when the input ends inside an open /* comment after it2 posts spanning 3.4 daysResolved
2.5 days ago Recursive CTE as the right operand of a LEFT JOIN: unmatched rows are not NULL-extended2 posts spanning 4.6 daysResolved
2.6 days ago REGEXP: a leading "^" anchors every alternative ("^a|b" does not match "xb")2 posts spanning 3.7 daysResolved
2.8 days ago ALTER TABLE RENAME COLUMN rewrites only the first ON CONFLICT clause of an upsert inside a trigger2 posts spanning 3.0 daysResolved
2.8 days ago sum()/total()/avg() over a moving window frame are not reversible: spurious "integer overflow", or Inf for frames that no lon2 posts spanning 4.1 daysOpen
2.9 days ago RBU UPDATE or DELETE of a row written before ALTER TABLE ADD COLUMN ... DEFAULT stores NULL in the added columns and leaves s2 posts spanning 10.6 daysResolved
2.9 days ago Partial index not recognized as covering.2 posts spanning 3.7 hoursResolved
3.0 days ago A strange change in json_group_array output in 3.54.12 posts spanning 20.7 minutesNot A Bug
3.7 days ago .recover writes the rowid through the name _rowid_ even when an ordinary column has that name, so the column's values are rep2 posts spanning 9.9 daysResolved
3.7 days ago .recover treats an INTEGER PRIMARY KEY DESC column as a rowid alias and writes the rowid in place of the key2 posts spanning 9.8 daysResolved
3.8 days ago .expert (sqlite3expert) does not quote column names that start with a digit: it fails with "not an error" or recommends no in2 posts spanning 1.6 daysResolved
3.8 days ago next_char() (ext/misc/nextchar.c) loops forever under NOCASE when a next character is "Z"3 posts spanning 8.0 hoursResolved
3.8 days ago SQLite DEFENSIVE-mode shadow-table name check bypass via unloaded schema or TEMP name collision2 posts spanning 3.8 hoursResolved
4.0 days ago RENAME COLUMN fails on an INTEGER PRIMARY KEY column named in a UNIQUE table constraint2 posts spanning 6.5 daysResolved
↓ Older...