Maximum key size using PXW_CSY collation

Maximum key size using PXW_CSY collation

AV when ON CONNECT triggers uses EXECUTE STATEMENT ON EXTERNAL

AV when ON CONNECT triggers uses EXECUTE STATEMENT ON EXTERNAL

Problem with restore time when DB has many indices (possible regression in 6.x)

Error unable to allocate memory from operating system

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 result with NOT IN operator and partial index

LEFT JOIN strength reduction optimization causes an error.

Assertion fault when deleting a table out from under a SELECT

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

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

Inconsistent behavior of a partial unique index on a boolean expression.

REINDEX causes "UNIQUE constraint failed" error for generated column

Assertion fault on UPDATE

ORDER BY handling with indexes on expressions

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 result for comparison with NULL

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

Incorrect ORDER BY on an indexed JOIN

Incorrect answer on LEFT JOIN when STAT4 is enabled

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

COLLATE NOCASE string comparison yields incorrect result when partial index presents

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

LEFT JOIN malfunctions with partial index (unexpected fetch 1 row).

Incorrect result on a LEFT JOIN when using an index

Assertion fault on a LEFT JOIN

Incorrect case in the LIKE operator when comparing unicode characters belonging to "Other Letter" category

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

Constant expression in partial index results in row not being fetched

Incorrect result with ORDER BY DESC and LIMIT

Partial index gives incorrect query result

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

Incorrect count(*) when partial indices exist

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

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

ORDER BY ignored if query has identical GROUP BY

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 LEFT JOIN when FROM clause contains nested subqueries

Incorrect result from WITH RECURSIVE using DISTINCT

Incorrect result on query involving LEFT JOIN and transitive constraints

ALTER TABLE DROP <column> may corrupt data

COLLATE operator masked by function calls

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

Duplicate CTE name gives incorrect result

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 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.

Incorrect ORDER BY with colliding input and output column names

Valid query fails to compile due to WHERE clause optimization

Partial index and BETWEEN issue

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

Incorrect query result in a 3-way join due to affinity issues

Maximum key size using PXW_CSY collation

Maximum key size using PXW_CSY collation