LEFT JOIN with OR terms in WHERE clause causes assertion fault

Incorrect use of index with LIKE operators when the LHS is a blob

Segfault when running query that uses LEAD()OVER() and GROUP BY

Incorrect result when an index is used for an ordered join

COLLATE issue in a view

Assertion fault on a query against a view

Assertion

MAX yields unexpected result for UTF-16

Incorrect query result when redundant terms appears in WHERE clause

Segfault when running query that uses SUM()OVER()

null pointer dereference caused by window functions in result-set of EXISTS(SELECT ...)

Different rounding when converting TEXT to DOUBLE PRECISION

Incorrect result from LEFT JOIN with a subquery on the LHS

OR operator in WHERE clause gives wrong answer when indexed

Incorrect results with OR terms in the ON clause of a LEFT JOIN

Incorrect DISTINCT on an indexed query with IN

Inaccurate int/float comparison results in corrupt index

Some valid floating-point literals are not recognized.

REAL rounding seems to depend on index presence

REINDEX causes "UNIQUE constraint failed" error for generated column

Assertion fault on UPDATE

ORDER BY handling with indexes on expressions

Index on expression leads to an incorrect LEFT JOIN

Crash on query using an OR term in the WHERE clause

Crash due to misuse of window functions.

Incorrect caching of sub-query results in the FROM clause of a scalar sub-query.

Wrong result of COUNT when using WHERE clause with POSITION()

Correlated subquery on the RHS of an IN operator causes output of excessive rows

Incorrect ORDER BY on an indexed JOIN

Incorrect result for LEFT JOIN

Incorrect output on a LEFT JOIN

Assertion fault when multi-use subquery implemented by co-routine

Segfault when running query that has WHERE expression with IN(...) containing LEAD()OVER() function

Segfault following heavy SAVEPOINT usage

INSERT into table with two triggers does not terminate

Bug involving subqueries and the OR optimization

ALTER TABLE ADD COLUMN with negative DEFAULT value

Incorrect query result when a LEFT JOIN subquery is flattened

Index causes incorrect WHERE clause evaluation

Incorrect result from a DISTINCT + GROUP BY + ORDER BY query

Incorrect result from second execution of correlated scalar sub-query that uses a partial sort

Default collation sequences lost when window function added to query

Access violation error trying to insert into triggered view

Trigger inserts duplicate value in UNIQUE column

Assertion

Segfault while trying to prepare a malformed window-function query

CAST takes implicit COLLATE of its operand

Comparison on view malfunctions

"WHERE a=? AND b IN (?,?,...) AND c>?" query using the seekscan optimization sometimes returns extra rows.

Incorrect LIMIT on a UNION ALL query

Incorrect result from LEFT JOIN with OR in the WHERE clause

Incorrect result on LEFT JOIN with OR constraints and an ORDER BY clause

RENAME COLUMN fails on tables with redundant UNIQUE constraints

Segfault during query involving LEFT JOIN column in the ORDER BY clause

Incorrect LIKE result

Segfault on query involving deeply nested aggregate views

Incorrect result from WITH RECURSIVE using DISTINCT

Incorrect result on query involving LEFT JOIN and transitive constraints

ALTER TABLE DROP <column> may corrupt data

ORDER BY clause ignored in 3-way join query

Segfault due to LEFT JOIN flattening optimization

NULL WHERE condition unexpectedly results in row being fetched

Duplicate CTE name gives incorrect result

LEFT JOIN with an OR in the ON clause causes segfault

Window function in correlated subquery causes assertion fault

Nested boolean formula with IN operator computes an incorrect result

Incorrect join result or assertion fault due to transitive constraints

LIMIT does not work with nested views containing UNION ALL

Incorrect DELETE due to the one-pass optimization

Subquery with limit clause fails as EXISTS operand

Assertion

COLLATE sequence for ORDER/GROUP BY ignored when using an index-on-expression

Incorrect result using index on expression with collating function

Incorrect result with complex OR-connected WHERE

Assertion fault when window functions are used.

Incorrect ORDER BY with colliding input and output column names

Segfault when running query that uses window functions

Incorrect result for query that uses MIN() and a CAST on rowid

Incorrect sorting when a column uses BINARY collation in the ORDER BY, but is compared with a different collation in the WHERE clause

Assertion in the query containing subquery in select section and exists()

LEFT JOIN with OR terms in WHERE clause causes assertion fault