SQLite Bug Forum

Forum
Login

Most recent threads

4.8 hours ago vec1 changes to compile with older compilers missing some C99 features2 posts spanning 9.1 hoursResolved
11.2 hours ago ManualVuln2 generate_series descending-LIMIT computes iTerm in wrong direction causing assertion abort2 posts spanning 2.7 hoursResolved
11.7 hours ago ManualVuln3 Memory Leak in idxCreateFromCons When 50 Index-Name Collisions Occur2 posts spanning 2.2 hoursResolved
12.0 hours ago ManualVuln4 NULL pointer dereference in qrfTitleLimit via HTML title encoding with empty column name2 posts spanning 1.8 hoursResolved
13.0 hours ago ManualVuln1 Heap buffer overflow in .mode --widths option due to missing sizeof(short int) in allocation2 posts spanning 52.2 minutesResolved
15.8 hours ago Explicit EXCLUDE NO OTHERS causes a substantial slowdown in a COUNT windowno repliesOpen
21.3 hours ago CONCAT produces extra trailing bytes for a BLOB argument in a UTF-16le database3 posts spanning 17.9 hoursResolved
21.3 hours ago Significant slowdown when combining an EXCLUDE GROUP window with a window returning a long stringno repliesOpen
21.3 hours ago Outer ORDER BY causes a substantial slowdown when returning the length of a window-generated stringno repliesOpen
21.3 hours ago DISTINCT causes a substantial slowdown when applied to the length of a window-generated stringno repliesOpen
25.1 hours ago Row-value IN in a join repeats rows: the inner loop iterates the full IN list, with duplicates, for one of its columnsno repliesOpen
25.1 hours ago Compound SELECT with ORDER BY ... COLLATE moves the last SELECT's GROUP BY, HAVING and DISTINCT to the whole compoundno repliesOpen
29.0 hours ago 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 withou2 posts spanning 3.7 daysResolved
29.5 hours ago group_concat() window over a moving frame drops separators and text after an empty string2 posts spanning 1.9 hoursResolved
33.8 hours ago Constant NOTNULL expression and an equivalent bound parameter produce different GROUP BY resultsno repliesOpen
34.3 hours ago GROUP BY constant ISNULL/NOTNULL expression errors, while an equivalent bound parameter succeedsno repliesOpen
1.6 days ago Adding a window function causes “misuse of aggregate” for MIN() referencing an outer queryno repliesOpen
2.1 days ago decimal_pow2(N), decimal(X,N), decimal_exp(X,N), dtostr(X,N) and sqlite_compileoption_get(N) read N with sqlite3_value_int(),2 posts spanning 17.2 hoursResolved
2.2 days ago "database disk image is malformed" or missing rows: ORDER BY an added column NULLS LAST on a WITHOUT ROWID table3 posts spanning 15.3 hoursResolved
2.2 days ago In a UTF-16 database, a blob DEFAULT from ALTER TABLE ADD COLUMN is converted to text as UTF-82 posts spanning 24.4 hoursResolved
2.3 days ago a IN (...) AND c GLOB 'A' with an index on (a,c): GROUP BY splits a group, DISTINCT repeats a row (BLOB in c)3 posts spanning 1.9 daysResolved
3.1 days ago x IN (SELECT y COLLATE NOCASE ...) misses rows when x has an index2 posts spanning 2.3 hoursResolved
3.2 days ago An index on a VIRTUAL generated column with no type returns an integral REAL as an INTEGER2 posts spanning 68.1 minutesResolved
3.4 days ago Assertion failure in sqlite3InitOne() involving FTS5, ZIPFILE, and a self-referencing generated column2 posts spanning 12.2 hoursResolved
3.5 days ago Assertion Failure in sqlite3VdbeExec() Triggered by Nested Aggregate Subqueries2 posts spanning 5.8 hoursResolved
↓ Older...