Internal consistency check (page in use during flush) with small number of DefaultDbCachePages

DATEADD truncates milliseconds for month and year deltas.

Incorrect result of index list scan for a composite index, the second segment of which is a text field with COLLATE UNICODE_CI

Crash when MAKE_DBKEY() is called with 0 or 1 arguments

Problematic queries when SubQueryConversion = true

SubQueryConversion = true - multiple rows in singleton select

Incorrect subquery unnesting with complex dependencies (SubQueryConversion = true)

Catch possible stack overflow when preparing and compiling user statements

Nested IN/EXISTS subqueries should not be converted into semi-joins if the outer context is a sub-query which wasn't unnested

"Unique scan" is incorrectly reported in the explained plan for unique index and IS NULL predicate

wrong results using minvalue/maxvalue in join condition

Send blob contents in the same data stream as main resultset

Report unique usernames for isc_info_user_names

Crash when creating index on table that uses UDR and ParallelWorkers > 1

Add pointers tree to TempSpace class

Segmentation fault when running query with partition by and subquery

Inheritance of WINDOW does not work

Conversion Error with old.field in UPDATE OR INSERT

Error in iTransaction.getInfo() on embedded connection

Unnamed (no relation alias) derived table

Derived table column names must be unique

Outer reference inside derived table to other relations in from clause is not allowed

Outer reference inside derived table to other relations in from clause is not allowed

Outer reference to upper scope-level is allowed

Outer reference to upper scope-level is allowed

FIRST / SKIP inside derived table

Simple derived table with aggregate inside

Aggregate inside derived table

Sub-select inside derived table

Derived table outer reference (triggers)

Derived table with outer reference from LEFT JOIN.

Derived table with column that is specified several times

ASC 2-segment index lower bound

STARTING WITH charset NONE

TIMESTAMP in index with values below julian date

ASC single segment index upper bound

ASC single segment index upper bound

DESC single segment index upper bound

DESC 2-segment index upper bound

Upper and lower bounds

Try to deliver HAVING CLAUSE conjunctions to the WHERE clause

Try to deliver HAVING CLAUSE conjunctions to the WHERE clause

Try to deliver HAVING CLAUSE conjunctions to the WHERE clause

Try to deliver HAVING CLAUSE conjunctions to the WHERE clause

Try to deliver HAVING CLAUSE conjunctions to the WHERE clause

Try to deliver HAVING CLAUSE conjunctions to the WHERE clause

Try to deliver HAVING CLAUSE conjunctions to the WHERE clause

FULL OUTER JOIN, list all values

FULL OUTER JOIN, list all values, but filtered in WHERE clause

INNER JOIN join order

INNER JOIN join order

INNER JOIN join order LIKE and STARTING WITH

INNER JOIN join order and VIEW

INNER JOIN join order and distribution

INNER JOIN join merge

INNER JOIN join merge

INNER JOIN join merge and VIEWs

LEFT OUTER JOIN with no match at all

LEFT OUTER JOIN with full match and reference in WHERE clause

LEFT OUTER JOIN with full match, but limited in ON clause

4 JOINed tables with 1 LEFT OUTER JOIN

LEFT OUTER JOIN with full match, but limited in ON and WHERE clause

LEFT OUTER JOIN with STARTING WITH in WHERE clause

LEFT OUTER JOIN VIEW with full match

Mixed JOINS

Mixed JOINS

Mixed JOINS

Best match index selection (multi segment)

Best match index selection (multi segment)

Best match index selection (multi segment)

SELECTIVITY - SET STATISTICS

SELECTIVITY - INDEX INACTIVE / ACTIVE

Best match index selection (single segment)

Best match index selection (single segment)

Best match index selection (single segment)

Best match index selection (single segment)

Best match index selection (single segment) OR

ORDER BY ASC using index (unique)

ORDER BY ASC using index (non-unique)

MAX() and DESC index (non-unique)

MIN() and ASC index (non-unique)

ORDER BY ASC using index (non-unique)