FIRST 1 vs ORDER DESC vs explicit plan (ODS11)

FIRST 1 vs ORDER DESC vs explicit plan (ODS11)

Automatic not null in PK columns incomplete

Automatic not null in PK columns incomplete

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

ALTER TABLE altering to VARCHAR

ALTER TABLE altering to VARCHAR

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

Token unknown in simple SELECT with GROUP BY and ORDER BY

Token unknown in simple SELECT with GROUP BY and ORDER BY

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

Dependencies are not cleared when creation of expression index fails

Dependencies are not cleared when creation of expression index fails

It is impossible to take away rights on update of a column

It is impossible to take away rights on update of a column

Problems with explicit cursors in unwanted states

Problems with explicit cursors in unwanted states

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

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)

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

User (not SYSDBA) that have privileges with grant option, can't revoke privileges, granted by other user or SYSDBA

User (not SYSDBA) that have privileges with grant option, can't revoke privileges, granted by other user or SYSDBA

Support `BETWEEN` predicate for select expressions

Support `BETWEEN` predicate for select expressions

Server locks up while attempting to commit a deletion of an expression index

Server locks up while attempting to commit a deletion of an expression index

Problem altering numeric field type

Problem altering numeric field type

Expression index based on computed fields

Expression index based on computed fields

Ceation of invalid procedures/triggers allowed

Ceation of invalid procedures/triggers allowed

Bad optimization of queries with DB_KEY

Bad optimization of queries with DB_KEY

NOT NULL constraint for procedure parameters and variables

NOT NULL constraint for procedure parameters and variables

Generated columns

Generated columns

Global temporary table instance may pick up not all indices

Global temporary table instance may pick up not all indices

Adding a non-null restricted column to a populated table renders the table inconsistent

Adding a non-null restricted column to a populated table renders the table inconsistent

Subquery-based predicates are not evaluated early in the join order

Subquery-based predicates are not evaluated early in the join order

Unnecessary index scan happens when the same index is mapped to both WHERE and ORDER BY clauses

Unnecessary index scan happens when the same index is mapped to both WHERE and ORDER BY clauses

Altering procedure parameters must be prohibited if there are dependent data in RDB$DEPENDENCIES

Altering procedure parameters must be prohibited if there are dependent data in RDB$DEPENDENCIES

Incorrect error message (column number) if the empty SQL string is prepared

Incorrect error message (column number) if the empty SQL string is prepared

Arithmetic exception, numeric overflow, or string truncation in utf8 tables

Arithmetic exception, numeric overflow, or string truncation in utf8 tables

Incorrect "key size exceeds implementation restriction for index" error

Incorrect "key size exceeds implementation restriction for index" error