Catch possible stack overflow when preparing and compiling user statements

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)

Best match index selection (multi segment)

SELECTIVITY - CREATE INDEX

Unique index selection (single segment)

Best match index selection (single segment)

Best match index selection (single segment) ASC and DESC

Best match index selection (single segment)

Best match index selection (single segment) OR

Best match index selection (single segment)

ORDER BY DESC using index (unique)

ORDER BY DESC using index (non-unique)

MAX() and ASC index (non-unique)

MIN() and DESC index (non-unique)

ORDER BY ASC using index (multi)

ORDER BY ASC, DESC using index (multi)

ORDER BY ASC NULLS FIRST using index

ORDER BY DESC NULLS FIRST using index

ORDER BY ASC using index (single) and WHERE clause

Check output of "HELP" and "HELP SET" commands

ISQL - SHOW SYSTEM TABLES

ISQL should be able to process single statement with length up to 10*1024*1024 chars

Alter database: adding secondary file with alternate keyword

Verify ability to create database with different values of PAGE_SIZE

Create database: non sysdba user

Create database: Multi file DB

Create database: Default char set NONE

Test ability for DECFLOAT values to be represented as other data types using LEGACY keyword.

Check BOUNDARY values that are defined for DECFLOAT datatype

Check ability to create table with 16 fields of type decfloat(34), plus create indices and add data

Test exception trapping for result of DECFLOAT operations

Literal length currently is limited with 1024 characters (including decimal separator and minus sign if any)

List of all values starting from 1.0 divided by 2, until previous and current become equal

Test ordering of decfloat values

Check validity of different ROUNDING modes that are defined for DECFLOAT datatype

Check result of EXP() which can be represented only by one ("last") significant bit

Dummy test

Basic test for binary functions against INT128 datatype

Test ability for DECFLOAT values to be represented as other data types using LEGACY keyword.

Recursive CTEs

DELETE with WHERE

INSERT with Defaults