Make it possible to restore compressed .nbk files without explicitly decompressing them

Make it possible to restore compressed .nbk files without explicitly decompressing them

Segfault/AV on incorrect databases.conf starting with subconfig (without line alias=database_path)

Error in iTransaction.getInfo() on embedded connection

Regression in 6.x: query with "... where <field> in ( <scalar_value> | <scalar_func>, null )" returns empty rowset instead of existing record

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