FIRST 1 vs ORDER DESC vs explicit plan (ODS11)

FIRST 1 vs ORDER DESC vs explicit plan (ODS11)

Expression index regression since 2.0a3

Expression index regression since 2.0a3

Dropping and recreating a table in the same txn disables PK

Dropping and recreating a table in the same txn disables PK

BLOBs in external tables

BLOBs in external tables

SYSDBA can grant non existent roles

SYSDBA can grant non existent roles

CHECK constraints fire twice

CHECK constraints fire twice

DOMAINs don't register their dependency on other objects

DOMAINs don't register their dependency on other objects

Any user can drop procedures, generators, exceptions

Any user can drop procedures, generators, exceptions

Optimization problem with COALESCE

Optimization problem with COALESCE

Before triggers are firing after checks

Before triggers are firing after checks

ORDER BY on a VIEW turns values in fields into NULL

ORDER BY on a VIEW turns values in fields into NULL

Grouping on derived fields processing NULL data kills IB

Grouping on derived fields processing NULL data kills IB

Computed field can't be changed to non-computed using 'alter table alter column type xy'

Computed field can't be changed to non-computed using 'alter table alter column type xy'

Field can be used multiple times in multi-segment index definition

Field can be used multiple times in multi-segment index definition

Removing a NOT NULL constraint is not visible until reconnect

Removing a NOT NULL constraint is not visible until reconnect

Column involved in the constraint (e.g. PK) could NOT be dropped if constraint has user-defined name

Column involved in the constraint (e.g. PK) could NOT be dropped if constraint has user-defined name

The built-in BLR printer doesn't support all FB2 features

The built-in BLR printer doesn't support all FB2 features

Ability to query a stored procedur from view.

Ability to query a stored procedur from view.

New value of column is accessable before update

New value of column is accessable before update

Garbage in plan output of complex statement

Garbage in plan output of complex statement

select with FIRST and LEFT JOIN needs excess SORT in plan

select with FIRST and LEFT JOIN needs excess SORT in plan

DISTINCT vs NULLS LAST clause: wrong order of NULLs

DISTINCT vs NULLS LAST clause: wrong order of NULLs

Server crashes at runtime when an explicit MERGE plan is specified over a few JOIN ones

Server crashes at runtime when an explicit MERGE plan is specified over a few JOIN ones

Bad plan in outer joins with IS NULL clauses (dependent on order of predicates)

Bad plan in outer joins with IS NULL clauses (dependent on order of predicates)

A query could produce different results, depending on the presence of an index

A query could produce different results, depending on the presence of an index

ALTER DOMAIN and ALTER TABLE don't allow to change character set and/or collation

ALTER DOMAIN and ALTER TABLE don't allow to change character set and/or collation

FK-definition. Make error message more relevant when parent table has no appropriate PK/UK constraint.

FK-definition. Make error message more relevant when parent table has no appropriate PK/UK constraint.

Bad optimization -- <procedure> left join <subquery> (or <view>)

Bad optimization -- <procedure> left join <subquery> (or <view>)

Activating index change "STARTING" working as "LIKE" in join condition

Activating index change "STARTING" working as "LIKE" in join condition

WHEN <list of exceptions> tracks only the dependency on the first exception in PSQL

WHEN <list of exceptions> tracks only the dependency on the first exception in PSQL

"CH" and "LL" are not separate spanish alphabet letters since 1994

"CH" and "LL" are not separate spanish alphabet letters since 1994

Wrong SELECT query results using index to evaluate >= condition

Wrong SELECT query results using index to evaluate >= condition

Incorrect column values with outer joins and views

Incorrect column values with outer joins and views

Ceation of invalid procedures/triggers allowed

Ceation of invalid procedures/triggers allowed

Can't transliterate character set when look at procedure text in database just created from script

Can't transliterate character set when look at procedure text in database just created from script

Indices not used for views

Indices not used for views

Joins with NULL RDB$DB_KEY crash the server

Joins with NULL RDB$DB_KEY crash the server

Incorrect result of recursive CTE query when recursive member's SELECT list contains expression using self-referenced fields

Incorrect result of recursive CTE query when recursive member's SELECT list contains expression using self-referenced fields

Generated columns

Generated columns