CREATE VIEW ignores PLAN

CREATE VIEW ignores PLAN

Tricky role defeats basic SQL security

Tricky role defeats basic SQL security

Compress Data over the Network

New value of column is accessable before update

New value of column is accessable before update

DISTINCT vs NULLS LAST clause: wrong order of NULLs

DISTINCT vs NULLS LAST clause: wrong order of NULLs

Estonian collation in UTF8 charset

Estonian collation in UTF8 charset

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

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

LIST() function seems not work if used twice or more in a query

LIST() function seems not work if used twice or more in a query

Incorrect column values with outer joins and derived tables

Incorrect column values with outer joins and derived tables

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

DATEADD wrong work with NULL arguments

DATEADD wrong work with NULL arguments

POSITION(string_exp1, string_exp2 [, start])

POSITION(string_exp1, string_exp2 [, start])

ABS() rounds NUMERIC values

ABS() rounds NUMERIC values

AV when recursive query used MERGE JOIN in execution plan

AV when recursive query used MERGE JOIN in execution plan

Floor & ceiling functions give wrong results with exact numeric arguments

Floor & ceiling functions give wrong results with exact numeric arguments

Error with EXECUTE PROCEDURE inside EXECUTE STATEMENT

Error with EXECUTE PROCEDURE inside EXECUTE STATEMENT

DEFAULT values are unnecessary evaluated

DEFAULT values are unnecessary evaluated

I/O statistics for stored procedures are not accounted in monitoring tables

I/O statistics for stored procedures are not accounted in monitoring tables

update or insert with gen_id() with wrong generator value

update or insert with gen_id() with wrong generator value

GROUP by and RDB$DB_KEY problems

GROUP by and RDB$DB_KEY problems

Grouping by function doesn't work properly

Grouping by function doesn't work properly

Success message when connecting to tiny trash database file

Success message when connecting to tiny trash database file

AV using recursive query as subquery in SELECT list and ORDER'ing by them

AV using recursive query as subquery in SELECT list and ORDER'ing by them

Wrong field position after ALTER POSITION

Wrong field position after ALTER POSITION

"conversion error from string" after change of field type from BIGINT to VARCHAR(21)

"conversion error from string" after change of field type from BIGINT to VARCHAR(21)

Incorrect LEFT JOIN result using table and derived constant subquery

Incorrect LEFT JOIN result using table and derived constant subquery

There is no need to undo changes made in GTT created with ON COMMIT DELETE ROWS option when transaction is rolled back

There is no need to undo changes made in GTT created with ON COMMIT DELETE ROWS option when transaction is rolled back

Allow the use of multiple WHEN MATCHED / NOT MATCHED clauses in MERGE, as per the SQL 2008 specification

Allow the use of multiple WHEN MATCHED / NOT MATCHED clauses in MERGE, as per the SQL 2008 specification

Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS

Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS

Metadata export with isql (option -ex) does not export functions properly

Metadata export with isql (option -ex) does not export functions properly

EXECUTE BLOCK's TYPE OF parameters with NONE charset may have be transformed to the connection charset

EXECUTE BLOCK's TYPE OF parameters with NONE charset may have be transformed to the connection charset

New permission types are not displayed by ISQL

New permission types are not displayed by ISQL

In PSQL modules with declared cursors engine could assign value to the wrong variable

In PSQL modules with declared cursors engine could assign value to the wrong variable

Parametrized queries using RDB$DB_KEY do not work

Parametrized queries using RDB$DB_KEY do not work

Usage of field(s) alias in view WITH CHECK OPTION leads to incorrect compile error or incorrect internal triggers

Usage of field(s) alias in view WITH CHECK OPTION leads to incorrect compile error or incorrect internal triggers

Duplicate tags for CREATE/ALTER USER not handled correctly

Duplicate tags for CREATE/ALTER USER not handled correctly

Wrong results of FOR SELECT <L> FROM <T> AS CURSOR <C> and table <T> is modified inside cursor's begin...end block

Wrong results of FOR SELECT <L> FROM <T> AS CURSOR <C> and table <T> is modified inside cursor's begin...end block