Test of CURSOR functionality

Test of NESTED PROCEDURES functionality

Support for SINGULAR <subquery>

Support for SINGULAR when subquery refers to another table

Support for NOT SINGULAR when subquery refers to another table

Support to multiple SINGULAR subqueries

SINGULAR subquery applied to result of join

Check result of DISTINCT when applying SINGULAR to result of query with aggregate function

Check of applying SINGULAR to result produced by a VIEW

GROUP BY of result of SINGULAR which is applied to result of JOIN

SINGULAR - Subquery returning exactly one row.

Positional SUBSTRING function

LIMIT clause on sub-select in FROM clause of a SELECT in a UNION ALL interpreted incorrectly

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

Name resolution issue with compound SELECTs and Common Table Expressions

Database corruption following INSERT with a TRIGGER that does an affinity change

Aggregate MAX() function with COLLATE clause

LIMIT ignored on compound query with subqueries

LEFT JOIN malfunctions with generated column

Assertion fault using indices with redundant columns

MIN() malfunctions for UNIQUE column

Segfault

Assertion when "WHERE 0" on the first element of a UNION present

NULL handling for indexes on expressions

Name resolution problem in sub-selects within triggers

Endless loop on a query with window functions, ORDER BY, and LIMIT

Incorrect answer when flattening a UNION ALL compound

Incorrect result for comparison with NULL

Assertion

Incorrect answer on LEFT JOIN when STAT4 is enabled

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

Wrong result if DISTINCT used on subquery which uses ORDER BY.

Name resolution fails when table name is a prefix of another table

DISTINCT malfunctions for a VIEW

Incorrect result on a LEFT JOIN when using an index

Assertion fault on a LEFT JOIN

Assertion

Assertion fault on double LEFT JOIN (after added support for transitive constraints)

Segfault in a table with generated columns

Incorrect result with ORDER BY DESC and LIMIT

Scalar subquery with "LIMIT 0" should return NULL

Assertion

Incorrect output order on a join with an ORDER BY

BETWEEN issue in a view

LEFT JOIN in view malfunctions

Bug caused by factoring of constants in trigger programs

Lossless conversion when casting a large TEXT number to NUMERIC is not performed

LIKE malfunctions for INT PRIMARY KEY COLLATE NOCASE column

Assertion in UPDATE statement for textual column which has check constraint that involves numeric comparison

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

ORDER BY ignored if query has identical GROUP BY

Wrong output order when a DESC index and GROUP BY and ORDER BY.

Incorrect result from LEFT JOIN query

Unexpected result for % and '1E1'

Segfault on a nested join

Incorrect LEFT JOIN when FROM clause contains nested subqueries

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

COLLATE operator masked by function calls

UPDATE with causes error when its WHERE expression involves ROW_NUMBER()OVER() call

Foreign key constraint fails when it should succeed.

LIKE malfunctions for UNIQUE COLLATE NOCASE column

Incorrect result from a UNION with an ORDER BY

Query planner fault on three-way nested join with compound inner SELECT

COLLATE operator on lhs of BETWEEN expression is ignored.

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

Incorrect result when RHS of IN operator contains DISTINCT and LIMIT

Foreign key constraint fails to prevent consistency error.

Assertion

COLLATE in BETWEEN expression is ignored

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

LEFT JOIN incorrect when ON clause does not reference right table.

Assertion when use 'IN()' with dense_rank()over() and lag()over()