Positional SUBSTRING function

OFFSET ignored if there is no FROM clause

Assertion

Segfault on DELETE with WHERE containing OR and redundant index exists.

Assertion

Different answer with and without index on IN operator with type mismatch

INSERT OR REPLACE with a foreign key constraint leads to assertion fault

Incorrect GROUP BY when input and output columns have the same name

LEFT JOIN strength reduction optimization causes an error.

Assertion fault when deleting a table out from under a SELECT

Query "<A> left join <B> inner join <C> on <b_c_expr> on <a_b_expr>" caused left join behave like inner join.

Segmentation fault in CROSS JOIN

Error "misuse of aggregate" raising if aggregate column in FROM subquery presents in the correlated subquery

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

Inaccurate int/float comparison results in corrupt index

REAL rounding seems to depend on index presence

MIN() malfunctions for UNIQUE column

Segfault

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.

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 answer on LEFT JOIN when STAT4 is enabled

PRIMARY KEY for REAL column datatype leads to a missing entry in the index.

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

DISTINCT malfunctions for a VIEW

Incorrect result on a LEFT JOIN when using an index

Assertion fault on a LEFT JOIN

Incorrect query result when a LEFT JOIN subquery is flattened

Incorrect result with ORDER BY DESC and LIMIT

Scalar subquery with "LIMIT 0" should return NULL

Assertion

BETWEEN issue in a view

LEFT JOIN in view malfunctions

Segfault while trying to prepare a malformed window-function query

CAST takes implicit COLLATE of its operand

Comparison on view malfunctions

"Malformed database schema" when creating a failing index within a transaction

ORDER BY ignored if query has identical GROUP BY

Incorrect result from LEFT JOIN query

Unexpected result for % and '1E1'

Incorrect LIKE result

LEFT JOIN in view malfunctions with NOTNULL

Inverted sort order when using DISTINCT and a descending index

Assertion

Wrong answer when use no-case collation due to the LIKE optimization

Segfault due to LEFT JOIN flattening optimization

NULL WHERE condition unexpectedly results in row being fetched

LIKE malfunctions for UNIQUE COLLATE NOCASE column

Window function in correlated subquery causes assertion fault

Nested boolean formula with IN operator computes an incorrect result

SELECT on window function FIRST_VALUE()OVER() causes a segfault

Incorrect DELETE due to the one-pass optimization

Assertion

COLLATE in BETWEEN expression is ignored

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

Incorrect result with complex OR-connected WHERE

Assertion fault when window functions are used.

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

Positional SUBSTRING function

Positional SUBSTRING function

OFFSET ignored if there is no FROM clause

OFFSET ignored if there is no FROM clause

Assertion

Assertion

Segfault on DELETE with WHERE containing OR and redundant index exists.

Segfault on DELETE with WHERE containing OR and redundant index exists.

Assertion

Assertion

Different answer with and without index on IN operator with type mismatch

Different answer with and without index on IN operator with type mismatch

INSERT OR REPLACE with a foreign key constraint leads to assertion fault

INSERT OR REPLACE with a foreign key constraint leads to assertion fault

Incorrect GROUP BY when input and output columns have the same name

Incorrect GROUP BY when input and output columns have the same name

LEFT JOIN strength reduction optimization causes an error.

LEFT JOIN strength reduction optimization causes an error.

Assertion fault when deleting a table out from under a SELECT

Assertion fault when deleting a table out from under a SELECT