Compress Data over the Network

TRANSACTION_ROLLBACK missing in the trace log when appropriate DB-level trigger fires

LEFT JOIN with OR terms in WHERE clause causes assertion fault

OFFSET ignored if there is no FROM clause

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()

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

Incorrect result from LEFT JOIN with a subquery on the LHS

Name resolution issue with compound SELECTs and Common Table Expressions

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

LEFT JOIN malfunctions with generated column

MIN() malfunctions for UNIQUE column

Segfault

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

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.

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 fault on double LEFT JOIN (after added support for transitive constraints)

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

Trigger inserts duplicate value in UNIQUE column

Assertion

CAST takes implicit COLLATE of its operand

Comparison on view malfunctions

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

LIKE malfunctions for UNIQUE COLLATE NOCASE column

Incorrect result from a UNION with an ORDER BY

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

Assertion

COLLATE in BETWEEN expression is ignored

Incorrect result using index on expression with collating function

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

Incorrect results when OR is used in the ON clause of a LEFT JOIN

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()

CREATE TRIGGER - basic checks for DML triggers

Compress Data over the Network

TRANSACTION_ROLLBACK missing in the trace log when appropriate DB-level trigger fires

TRANSACTION_ROLLBACK missing in the trace log when appropriate DB-level trigger fires

LEFT JOIN with OR terms in WHERE clause causes assertion fault

LEFT JOIN with OR terms in WHERE clause causes assertion fault

OFFSET ignored if there is no FROM clause

OFFSET ignored if there is no FROM clause

Incorrect result when an index is used for an ordered join

Incorrect result when an index is used for an ordered join

COLLATE issue in a view

COLLATE issue in a view

Assertion fault on a query against a view

Assertion fault on a query against a view