SQLite Bug Forum

Forum
Login
     

Most recent threads

24.9 minutes ago Cache bug with SQLITE_ENABLE_MEMORY_MANAGEMENT2 posts spanning 21.0 hoursNot Planned
37.2 minutes ago Partial index "WHERE x IS NOT NULL" on a NOT NULL column is unusable since 3.46: INDEXED BY gives "no query solution"2 posts spanning 7.1 hoursNot Planned
1.9 hours ago EXCEPT with an outer typeof() filter returns an unexpected row2 posts spanning 7.5 hoursResolved
2.7 hours ago SQL injection through comment breakout in the optional dbdump utilityno repliesOpen
2.7 hours ago CLI / ext/qrf: infinite loop under ".mode box --wrap 1" on double-wide UTF-8 charactersno repliesOpen
3.9 hours ago Database corruption: sqlite3_backup into a connection that has other read statements open writes a stale page count2 posts spanning 2.9 daysResolved
4.2 hours ago FTS5: heap over-read in fts5SegIterNext() from a stale iLeafOffset (read-only MATCH on a crafted database)no repliesOpen
5.3 hours ago FTS5 secure-delete: heap overflow writes in fts5DoSecureDelete() on a corrupt indexno repliesOpen
17.6 hours ago sqlite3_deserialize(): SQLITE_ENABLE_API_ARMOR does not reject M < Nno repliesOpen
17.6 hours ago URI mode=memory makes a database opened with SQLITE_OPEN_READONLY writableno repliesOpen
18.7 hours ago UPSERT: conflict target (b,c) is matched to a unique index on (b,b), so DO UPDATE fires for a constraint the target does not2 posts spanning 2.4 daysResolved
22.4 hours ago Tcl test suite cross-test failures: shared-memory leaks, stale callbacks, test-order failures, and path-dependent exclusions3 posts spanning 6.2 hoursResolved
22.4 hours ago Failed assertion in unixOpen for VACUUM INTO with URI and empty modeof2 posts spanning 50.7 minutesResolved
23.4 hours ago Multi-row UPSERT with a BEFORE UPDATE trigger that deletes the conflicting row leaves a rowid out of order3 posts spanning 13.9 daysResolved
23.9 hours ago Wrong result: new.c can be NULL in a BEFORE UPDATE trigger for generated column c AS (a+b) when only a is set3 posts spanning 14.7 daysResolved
25.7 hours ago FTS5: totals are cached as valid after a failed load of the averages record2 posts spanning 54.2 minutesResolved
25.9 hours ago A RANGE window frame and its exact mirror image return different results, and each is wrong on a different row2 posts spanning 8.4 hoursResolved
26.0 hours ago Clarification: floating-point rounding at a RANGE PRECEDING boundary3 posts spanning 11.5 daysNot A Bug
26.0 hours ago CLI: ".recover ''" (empty or "-" option) acts as --ignore-freelist2 posts spanning 32.5 minutesResolved
26.3 hours ago excluded.x lacks the column’s affinity and collation, so DO UPDATE ... WHERE may compare values differently and skip the upda2 posts spanning 8.0 hoursResolved
26.8 hours ago Wrong result: json_each() fullkey does not escape a double quote in a JSON5 single-quoted key3 posts spanning 15.6 daysResolved
28.4 hours ago Authorizer bypass via ALTER TABLE ADD COLUMN generated column exposes denied column values2 posts spanning 1.8 hoursNot Planned
29.0 hours ago URI mode=ro does not propagate read-only to ATTACHed databases2 posts spanning 74.5 minutesNot A Bug
29.5 hours ago WHERE-clause push-down into a compound subquery ignores the affinity of the subquery's own column, so rows are lost2 posts spanning 4.7 hoursNot A Bug
30.9 hours ago ALTER TABLE RENAME COLUMN fails when a view refers to the column through a "*" expanded in a subquery or CTE2 posts spanning 3.3 hoursNot Planned
↓ Older...