Problematic tests list (709 rows):
bugs.core_0203_test  CREATE VIEW ignores PLAN
bugs.core_0856_test  Unable to set FName, MName, LName fields in security to blank
bugs.core_0883_test  The built-in BLR printer doesn't support all FB2 features
bugs.core_1010_test  Local buffer overrun in DYN_error() that takes down the server
bugs.core_1271_test  Ceation of invalid procedures/triggers allowed
bugs.core_1401_test  Global temporary table instance may pick up not all indices
bugs.core_1482_test  Make optimizer to consider ORDER BY optimization when making decision about join order
bugs.core_1518_test  Adding a non-null restricted column to a populated table renders the table inconsistent
bugs.core_1525_test  Computed field + index not working in WHERE
bugs.core_1549_test  Subquery-based predicates are not evaluated early in the join order
bugs.core_1550_postfix_test  Unnecessary index scan happens when the same index is mapped to both WHERE and ORDER BY clauses
bugs.core_1550_test  Unnecessary index scan happens when the same index is mapped to both WHERE and ORDER BY clauses
bugs.core_1559_test  Dropping NOT NULL contranint doesn'have the desired effect
bugs.core_1592_test  Altering procedure parameters must be prohibited if there are dependent data in RDB$DEPENDENCIES
bugs.core_1607_test  Correlated subquery is optimized badly if it depends on the union stream
bugs.core_1620_test  Incorrect error message (column number) if the empty SQL string is prepared
bugs.core_1689_test  'There are <n> dependencies' error message shows the wrong count of dependent objects.
bugs.core_1690_test  Arithmetic exception, numeric overflow, or string truncation in utf8 tables
bugs.core_1694_test  Bug in create/alter Database trigger (with Russian comment)
bugs.core_1715_test  Incorrect "key size exceeds implementation restriction for index" error
bugs.core_1746_test  Expression index can be created while doing inserts into table
bugs.core_1760_test  Support hex numeric and string literals
bugs.core_1793_test  AV at prepare of query with unused parametrized CTE
bugs.core_1802_test  Maximum key size using PXW_CSY collation
bugs.core_1812_test  Index is not used for some date/time expressions in dialect 1
bugs.core_1815_test  Ability to grant role to another role
bugs.core_1830_test  Possible index corruption with multiply updates of the same record in the same transaction and using of savepoints
bugs.core_1841_test  Possible overflow in RDB$VIEW_RELATIONS.RDB$CONTEXT_NAME
bugs.core_1846_test  Allow index walk (ORDER plan) when there is a composite index {A, B} and the query looks like WHERE A = ? ORDER BY B
bugs.core_1891_test  SHOW VIEW shows non-sense information for view fields with expressions
bugs.core_1894_test  Circular dependencies between computed fields crash the engine
bugs.core_1930_test  Possible AV in engine if procedure was altered to have no outputs and dependent procedures was not recompiled
bugs.core_1986_test  Altering domains name drops dependencies using the domain
bugs.core_1997_test  Broken foreign key handling for multi-segmented index using unicode_ci collation
bugs.core_2017_test  I/O statistics for stored procedures are not accounted in monitoring tables
bugs.core_2053_test  Computed expressions may be optimized badly if used inside the RETURNING clause of the INSERT statement
bugs.core_2073_test  Expression indexes bug: incorrect result for the inverted boolean
bugs.core_2132_test  Indexed retrieval cannot be chosen if a stored procedure is used inside the comparison predicate
bugs.core_2140_test  Error messages after parameters substitution contains '\n' characters instead of line break
bugs.core_2155_test  Join of SP with view or table may fail with "No current record for fetch operation"
bugs.core_2200_test  Extremely slow executing a cross join of 3 tables in Firebird 2.X
bugs.core_2202_test  RDB$VIEW_RELATIONS is not cleaned when altering a view
bugs.core_2216_test  Nbackup as online dump
bugs.core_2230_test  Implement domain check of input parameters of execute block
bugs.core_2289_test  Wrong (primary) constraint name is reported for the foreign key violation during FK creation
bugs.core_2303_test  Include PLAN in mon$statements
bugs.core_2374_test  ALTER TRIGGER / PROCEDURE wrong error message
bugs.core_2386_test  ALTER VIEW could remove column used in stored procedure or trigger
bugs.core_2424_test  Make CREATE VIEW infer column names for views involving a GROUP BY clause or derived table
bugs.core_2430_test  Server adds "NOT" at the end of default value for the TIMESTAMP field
bugs.core_2431_test  String values in error messages are not converted to connection charset
bugs.core_2484_test  Success message when connecting to tiny trash database file
bugs.core_2508_test  Tricky index names can defeat the parsing logic when generating a human readable plan
bugs.core_2516_test  Wrong processing SP parameters with arrays
bugs.core_2555_test  CI column does not group correctly with a second column
bugs.core_2635_test  Unique index with a lot of NULL keys can be corrupted at level 1
bugs.core_2650_test  Improve sorting performance when long VARCHARs are involved
bugs.core_2678_test  Full outer join cannot use available indices (very slow execution)
bugs.core_2685_test  System triggers on view with check option are not removed
bugs.core_2699_test  Common table expression context could be used with parameters
bugs.core_2712_test  Do not print "invalid request BLR" for par.cpp errors with valid BLR
bugs.core_2735_test  isql hangs when trying to show a view based on a procedure
bugs.core_2741_test  Naive metadata extraction code in isql is defeated by "check" keyword typed in mixed case
bugs.core_2765_test  Use of RDB$ADMIN role does not provide SYSDBA rights in GRANT/REVOKE
bugs.core_2798_test  Incomplete plan output (lack of view names) when selecting from views containing procedures inside
bugs.core_2806_test  Views based on procedures can't be created if the proc's output fields participate in an expression
bugs.core_2812_test  Prohibit any improper mixture of explicit and implicit joins
bugs.core_2826_test  Join condition fails for UTF-8 databases
bugs.core_2835_test  Natural is used to select instead of primary key index
bugs.core_2881_test  isql should show packaged procedures and functions categorized per package
bugs.core_2910_test  PK index is not used for derived tables
bugs.core_2912_test  Exception when upper casing string with 'ΓΏ' (lowercase y trema, code 0xFF in ISO8859_1)
bugs.core_2916_test  Broken error handling in the case of a conversion error happened during index creation
bugs.core_2930_test  DROP VIEW drops output parameters of used stored procedures
bugs.core_2985_test  The new 2.5 feature to alter COMPUTED columns doesn't handle dependencies well
bugs.core_3029_test  Bugcheck "Too many savepoints (287)" at rollback after exception at EXECUTE BLOCK with exception handler
bugs.core_3055_test  Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used
bugs.core_3056_test  Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued
bugs.core_3064_test  Using both the procedure name and alias inside an explicit plan crashes the server
bugs.core_3076_test  Better performance for (table.field = :param or :param = -1) in where clause
bugs.core_3085_test  Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL
bugs.core_3101_test  Cannot alter the domain after migrating from older versions
bugs.core_3103_test  BAD PLAN with using LEFT OUTER JOIN in SUBSELECT
bugs.core_3174_test  Expression index with TRIM may lead to incorrect indexed lookup
bugs.core_3176_test  View with "subselect" column join table and not use index
bugs.core_3180_test  ALTER VIEW with not matched columns in declaration and selection crashs the server
bugs.core_3222_test  View with "WITH CHECK OPTION" doesn't like TRIM function in WHERE
bugs.core_3239_test  UTF8 UNICODE_CI collate can not be used in compound index
bugs.core_3283_test  BAD PLAN with using LEFT OUTER JOIN in SUBSELECT
bugs.core_3305_test  "BLOB not found" error after creation/altering of the invalid trigger
bugs.core_3311_test  Error "data type unknown" while preparing UPDATE/DELETE statements with the parameterized ROWS clause
bugs.core_3312_test  Sub-optimal join plan when the slave table depends on the master one via the OR predicate
bugs.core_3338_test  Regression: Code changes disabled support for expression indexes with COALESCE, CASE and DECODE
bugs.core_3353_test  Predicate 'blob_field LIKE ?' describes the parameter as VARCHAR(30) rather than as BLOB
bugs.core_3357_test  Generators are set to 0 after restore
bugs.core_3364_test  Blob filter to translate internal debug info into text representation
bugs.core_3394_test  Failed attempt to violate unique constraint could leave unneeded "lock conflict" error in status-vector
bugs.core_3419_test  Recurse leads to hangs/crash server
bugs.core_3421_test  [FB3] AV with "UPDATE OR INSERT"
bugs.core_3450_test  Inefficient optimization (regression)
bugs.core_3474_test  Regression in joins on procedures
bugs.core_3491_test  Altering of a TYPE OF COLUMN parameter affects the original column
bugs.core_3502_test  DROP VIEW ignores the existing non-column dependencies
bugs.core_3509_test  Alter procedure allows to add the parameter with the same name
bugs.core_3530_test  BETWEEN operand/clause not supported for COMPUTED columns -- "feature is not supported"
bugs.core_3537_test  There is no need to undo changes made in GTT created with ON COMMIT DELETE ROWS option when transaction is rolled back
bugs.core_3545_test  Inconsistent domain's constraint validation in PSQL
bugs.core_3547_test  Floating-point negative zero doesn't match positive zero in the index
bugs.core_3549_test  Database corruption after end of session : page xxx is of wrong type expected 4 found 7
bugs.core_3553_test  Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types
bugs.core_3569_test  CHAR(32767) present in XSQLVAR with length 32765
bugs.core_3594_test  Include expected and actual string lenght into error message for sqlcode -802
bugs.core_3598_test  TRACE: add statistics of actions that were after transaction finished
bugs.core_3610_test  Can insert DUPLICATE keys in UNIQUE index
bugs.core_3627_test  Server crashes with access violation when inserting row into table with unique index
bugs.core_3672_test  computed index by substring function for long columns
bugs.core_3690_dialect_1_test  Wrong warning message for ambiguous query
bugs.core_3690_dialect_3_test  Wrong warning message for ambiguous query
bugs.core_3691_test  Missing constraint name in foreign key error message in FB 2.1.4
bugs.core_3722_test  IS NOT DISTINCT FROM NULL doesn't use index
bugs.core_3735_test  Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS
bugs.core_3736_test  WITH LOCK clause is allowed for users with read-only rights on some table, thus blocking others from updating this table
bugs.core_3761_test  Conversion error when using a blob as an argument for the EXCEPTION statement
bugs.core_3834_test  Usage of a NATURAL JOIN with a derived table crashes the server
bugs.core_3881_test  Extend the error reported for index/constraint violations to include the problematic key value
bugs.core_3894_test  Wrong numbers in error message for decreasing char/varchar columns
bugs.core_3902_test  Derived fields may not be optimized via an index
bugs.core_3925_test  Creating self-referential FK crashes database (bug-check) whether constraint violation had place
bugs.core_3947_test  Wrong results when the column with collation using option (NUMERIC-SORT=1) is in where clause
bugs.core_3963_test  isql doesn't know the difference between UDF's and psql-functions
bugs.core_3973_test  Original table name and column name and owner missing from SQLDA for aliased column in grouped query
bugs.core_3997_test  Join using RDB$DB_KEY produce NATURAL plan
bugs.core_4027_test  Creating table with computed fields containing "SELECT FIRST" produces corrupted result
bugs.core_4038_test  Broken optimization for the stored dbkeys
bugs.core_4070_test  NOT-NULL-column can be used as primary key and filled with NULL-values
bugs.core_4074_test  Computed by columns and position function
bugs.core_4075_test  Server bugchecks or crashes on exception in calculated index
bugs.core_4084_test  Regression: Group by fails if subselect-column is involved
bugs.core_4102_test  Bad optimization of OR predicates applied to unions
bugs.core_4117_test  COMPUTED BY field is evaluated as NULL if used as an exception parameter directly
bugs.core_4118_test  Expression index may be not used for derived fields or view fields
bugs.core_4119_test  Metadata source becomes wrong after twice transliteration to the metadata charset
bugs.core_4122_test  Metadata export with isql (option -ex) does not export functions properly
bugs.core_4137_test  Wrong metadata output script generated by isql / CHARACTER SETISO8859_1 syntax error
bugs.core_4149_test  New permission types are not displayed by ISQL
bugs.core_4156_test  RDB$GET_CONTEXT/RDB$SET_CONTEXT parameters incorrectly described as CHAR NOT NULL instead of VARCHAR NULLABLE
bugs.core_4160_test  The parameterized exception does not accept not ASCII characters as parameter
bugs.core_4164_test  Owner name is missing for generators/exceptions restored from a backup
bugs.core_4165_test  Replace the hierarchical union execution with the plain one
bugs.core_4203_test  Cannot create packaged routines with [VAR]CHAR parameters
bugs.core_4205_test  ISQL -x does not output the START WITH clause of generators/sequences
bugs.core_4210_test  Preserve comments for output parameters after altering procedures
bugs.core_4214_test  GTT should not reference permanent relation
bugs.core_4244_test  Problem with creation procedure which contain adding text in DOS864 charset
bugs.core_4252_test  Add table name to text of validation contraint error message, to help identify error context
bugs.core_4262_test  Context parsing error with derived tables and CASE functions
bugs.core_4276_test  Error on create table with "CHARACTER SET DOS775" field
bugs.core_4280_test  FB3: Stored function accepts duplicate input arguments
bugs.core_4281_test  FB 3: TYPE OF arguments of stored functions will hang firebird engine if depending domain or column is changed
bugs.core_4285_test  Choose the best matching index for navigation
bugs.core_4304_test  Engine crashes when attempt to REcreate table with FK after syntax error before such recreating
bugs.core_4315_test  Usage of field(s) alias in view WITH CHECK OPTION leads to incorrect compile error or incorrect internal triggers
bugs.core_4318_test  Regression: Predicates involving PSQL variables/parameters are not pushed inside the aggregation
bugs.core_4342_test  Non-privileged user can delete records from RDB$SECURITY_CLASSES table
bugs.core_4350_test  Support the SQL Standard ALTER SEQUENCE .. RESTART (without WITH clause)
bugs.core_4359_test  non-priviledged user can insert and update rdb$database
bugs.core_4365_test  Equality predicate distribution does not work for some complex queries
bugs.core_4371_test  Create function/sp which references to non-existent exception <...>
bugs.core_4373_test  Duplicate names in package are not checked
bugs.core_4376_test  Preparation of erroneous DDL statement does not show the main command failed
bugs.core_4379_test  Poor performance of explicit cursors containing correlated subqueries in the select list
bugs.core_4381_test  Incorrect line/column information in runtime errors
bugs.core_4386_test  Report more details for "object in use" errors
bugs.core_4403_test  Allow referencing cursors as record variables in PSQL
bugs.core_4415_test  Useless extraction of generic DDL trigger
bugs.core_4447_test  Positioned UPDATE statement prohibits index usage for the subsequent cursor field references
bugs.core_4451_test  Allow output to trace explain plan form.
bugs.core_4453_test  Regression: NOT NULL constraint, declared in domain, does not work
bugs.core_4460_test  Expressions containing some built-in functions may be badly optimized
bugs.core_4468_test  FB3: CREATE USER GRANT ADMIN ROLE does not work
bugs.core_4470_test  gbak fails to restore database containing dependency between views and packaged functions
bugs.core_4484_test  Description (COMMENT ON) for package procedures and functions, and its parameters
bugs.core_4492_test  OR/IN predicates for RDB$DBKEY lead to NATURAL plan
bugs.core_4498_test  FB 3.0 crashes when getting an explained plan for a DBKEY based retrieval
bugs.core_4524_test  New gbak option to enable encryption during restore
bugs.core_4528_test  Allow hash/merge joins for non-field (dbkey or derived expression) equalities
bugs.core_4529_test  Allow to use index when GROUP BY on field which has DESCENDING index
bugs.core_4530_test  DB_KEY based join of two tables may be ineffective
bugs.core_4539_test  Server does not accept the right plan
bugs.core_4555_test  DDL trigger remains active after dropped
bugs.core_4557_test  FB 3.0 crashes on EXIT (or QUIT) command if use UTF8-collation + create domain based on it + issue SHOW DOMAIN
bugs.core_4572_test  Incorrect error for PSQL function when the number of actual arguments does not match the number of formal arguments
bugs.core_4585_test  Can't create column check constraint when the column is domain based
bugs.core_4653_test  Crash on infinite mutual SP calls (instead of "Too many concurrent executions of the same request.")
bugs.core_4665_test  Wrong result when use "where <field_C> STARTING WITH <:value> ORDER BY <field_N>" and field_C is leading part of compound index key: { field_C, field_N }
bugs.core_4673_test  Regression: computed index based on a computed column stores NULL for all its keys
bugs.core_4694_test  "Column unknown" error while preparing a recursive query if the recursive part contains ALIASED datasource in the join with anchor table
bugs.core_4702_test  Regression: Join order in v3 is less optimal than in v2.x
bugs.core_4707_test  Implement ability to validate tables and indices online (without exclusive access to database)
bugs.core_4725_test  Inconsistencies with ALTER DOMAIN and ALTER TABLE with DROP NOT NULL and PRIMARY KEYs
bugs.core_4733_test  Command "Alter table <T> alter TYPE <C> <DOMAIN_WITH_NOT_NULL" does not verifies data in column <C> and makes incorrect assignments in <C> to ZERO / JULIAN_DATE / ASCII(0) for types INT, TIMESTAMP and VARCHAR
bugs.core_4735_test  Expression 'where bool_field IS true | false' should also use index as 'where bool_field = true | false' (if such index exists)
bugs.core_4738_test  Command "Alter table <T> alter <C> type <domain_>" does not work: "BLR syntax error: expected valid BLR code at offset 15, encountered 255"
bugs.core_4744_test  ALTER DATABASE SET DEFAULT CHARACTER SET: 1) take effect only for once for current attachment; 2) does not check that new char set exists untill it will be used
bugs.core_4754_test  Bugcheck 167 (invalid SEND request) while working with GTT from several attachments (using EXECUTE STATEMENT ... ON EXTERNAL and different roles)
bugs.core_4755_test  Parameterized exception: wrong output when number of arguments greater than 7
bugs.core_4766_test  AV when trying to manage users list using EXECUTE STATEMENT on behalf of non-sysdba user which has RDB$ADMIN role
bugs.core_4774_test  Table aliasing is unnecessary required when doing UPDATE ... RETURNING RDB$ pseudo-columns
bugs.core_4782_test  Command `SHOW TABLE` fails when the table contains field with unicode collationin its DDL
bugs.core_4786_test  Problematic key value (when attempt to insert duplicate in PK/UK) is not shown where length of key >= 127 characters
bugs.core_4802_test  Regression: GRANT UPDATE(<some_column>) on <T> acts like grant update on ALL columns of <T>
bugs.core_4806_test  Regression: generators can be seen/modified by unprivileged users
bugs.core_4807_test  Regression: List of aggregation is not checked properly
bugs.core_4809_test  HASH/MERGE JOIN is not used for more than two streams if they are joined via USING/NATURAL clauses and join is based on DBKEY concatenations
bugs.core_4811_test  Make user names behave according to SQL identifiers rules
bugs.core_4819_test  EXECUTE PROCEDURE's RETURNING_VALUES and EXECUTE STATEMENT's INTO does not check validity of assignments targets leading to bugcheck
bugs.core_4826_test  Make ISQL display character set when sqlda_display is on
bugs.core_4836_test  Grant update(c) on t to U01 with grant option: user U01 will not be able to `revoke update(c) on t from <user | role>` if this `U01` do some DML before revoke
bugs.core_4839_test  SHOW GRANTS does not display info about exceptions which were granted to user
bugs.core_4846_test  Altering a trigger indicating other table than the original does not reflect the change
bugs.core_4855_test  Online validation during DML activity in other connection leads to message "Error while trying to read from file" and "page in use during flush (210), file: cch.cpp line: 2672"
bugs.core_4880_test  Better performance of creating packages containing many functions
bugs.core_4884_test  Crash on pasring of script containing `execute block` with lot of nested begin..end statements
bugs.core_4904_test  Index corruption when add data in long-key-indexed field
bugs.core_4905_test  Invalid internal BLR filter conversion
bugs.core_4917_test  ALTER DOMAIN ... TO <new_name> allows to specify <new_name> matching to 'RDB$[[:DIGIT:]]*'
bugs.core_4921_test  Predicate IS [NOT] DISTINCT FROM is not pushed into unions/aggregates thus causing sub-optimal plans
bugs.core_4927_test  IIF function prevents the condition from being pushed into the union for better optimization
bugs.core_4940_test  Add label about deterministic flag for stored function in SHOW and extract commands
bugs.core_4980_test  Operator REVOKE can modify rights granted to system tables at DB creation time
bugs.core_4985_test  Non-privileged user can implicitly count records in a restricted table
bugs.core_5020_test  Regression: ORDER BY clause on compound index may disable usage of other indices
bugs.core_5049_test  Regression: incorrect calculation of byte-length for view columns
bugs.core_5062_test  CHAR_TO_UUID on column with index throws expression evaluation not supported. Human readable UUID argument for CHAR_TO_UUID must be of exact length 36
bugs.core_5064_test  Add datatypes (VAR)BINARY(n) and BINARY VARYING(n) as alias for (VAR)CHAR(n) CHARACTER SET OCTETS
bugs.core_5070_test  Compound index cannot be used for filtering in some ORDER/GROUP BY queries
bugs.core_5074_test  Lost the charset ID in selection of array element
bugs.core_5093_test  Alter computed field type does not work
bugs.core_5118_test  Indices on computed fields are broken after restore (all keys are NULL)
bugs.core_5122_test  Expression index may not be used by the optimizer if created and used in different connection charsets
bugs.core_5130_test  Compiler issues message about "invalid request BLR" when attempt to compile wrong DDL of view with both subquery and "WITH CHECK OPTION" in its DDL
bugs.core_5146_test  Suboptimal join order if one table has a selective predicate and MIN is calculated for the other one
bugs.core_5161_test  Unique index could be created on non-unique data
bugs.core_5166_test  Wrong error message with UNIQUE BOOLEAN field
bugs.core_5194_test  Invalid computed by definition generated by isql -x
bugs.core_5201_test  Return nonzero result code when restore fails on activating and creating deferred user index
bugs.core_5207_test  ISQL -X may generate invalid GRANT USAGE statements for domains
bugs.core_5216_test  Provide location context (line/column numbers) for runtime errors raised inside EXECUTE BLOCK
bugs.core_5218_test  Explicitly defined names for NOT NULL constraints are not exported into script by ISQL -x
bugs.core_5248_test  Improve consistency in GRANT syntax between roles and privileges according to SQL standard
bugs.core_5313_test  Data type unknown error with LIST
bugs.core_5325_test  Malformed string error when using cyrilic symbols and x'0d0a' in exception
bugs.core_5367_test  Regression: (boolean) parameters as search condition no longer allowed
bugs.core_5380_test  Allow subroutines to call others subroutines and themself recursively
bugs.core_5383_test  Dependencies in Package not recognised
bugs.core_5404_test  Inconsistent column/line references when PSQL definitions return errors
bugs.core_5410_test  Dependencies are not stored when using some type of contructions in subroutines
bugs.core_5421_test  Performance degradation in FB 3.0.2 compared to FB 2.5.7
bugs.core_5423_test  Regression: "Invalid usage of boolean expression" when use "BETWEEN" and "IS" operators
bugs.core_5431_test  Support for DROP IDENTITY clause
bugs.core_5435_test  Badly selective index could be used for extra filtering even if selective index is used for sorting
bugs.core_5463_test  Support GENERATED ALWAYS identity columns and OVERRIDE clause
bugs.core_5475_test  Provide ability to filter out info and warnings from trace log
bugs.core_5481_test  Available indices are not used in some cases if ORDER BY expression is a filtered one
bugs.core_5489_test  Bad performance for NULLs filtering inside a navigational index scan
bugs.core_5494_test  Creating a column of type BLOB SUB_TYPE BINARY fails with a Token unknown
bugs.core_5536_test  Connections compressed and encrypted in MON$ATTACHMENTS table
bugs.core_5567_test  Direct system table modifications are not completely prohibited
bugs.core_5576_test  Bugcheck on queries containing WITH LOCK clause
bugs.core_5580_test  Signature of packaged functions is not checked for mismatch with [NOT] DETERMINISTIC attribute
bugs.core_5598_test  Error "block size exceeds implementation restriction" while inner joining large datasets with a long key using the HASH JOIN plan
bugs.core_5606_test  Add expression index name to exception message if computation failed
bugs.core_5612_test  Gradual slowdown compilation (create, recreate or drop) of views
bugs.core_5637_test  string right truncation on restore of security db
bugs.core_5659_test  Bad PLAN generated for query on Firebird v3.0
bugs.core_5673_test  Unique constraint not working in encrypted database on first command
bugs.core_5674_test  Allow unused Common Table Expressions
bugs.core_5676_test  Consider equivalence classes for index navigation
bugs.core_5737_test  Invalid parameters of gds transaction in ISQL
bugs.core_5743_test  Conversion error when both GROUP/ORDER BY expressions and WHERE expressions contain literals
bugs.core_5746_test  Remove the restriction on create/delete, enable/disable the user indexes in system tables
bugs.core_5747_test  User can grant usage privilege by himself
bugs.core_5755_test  No error if the GRANT target object does not exist
bugs.core_5756_test  Regression: FB crashes when trying to recreate table that is in use by DML (3.0.3; 3.0.4; 4.0.0)
bugs.core_5794_test  Wrong behavour FOR <select_stmt> [AS CURSOR cursorname] with next update and delete
bugs.core_5840_test  Ignor of reference privilege
bugs.core_5843_test  Wrong handling of failures of TRANSACTION START trigger
bugs.core_5845_test  ORDER BY on index can cause suboptimal index choices
bugs.core_5852_test  There is no check of existance generator and exception when privileges are granted
bugs.core_5853_test  Forward-compatible expressions LOCALTIME and LOCALTIMESTAMP
bugs.core_5861_test  GRANT OPTION is not checked for new object
bugs.core_5874_test  Provide name of read-only column incorrectly referenced in UPDATE ... SET xxx
bugs.core_5876_test  Provide name of udf function for "arithmetic exception, numeric overflow, or string truncation"
bugs.core_5884_test  Initial global mapping from srp plugin does not work
bugs.core_5904_test  An attempt to create global mapping with long (greater than SQL identifier length) FROM field fails
bugs.core_5905_test  Inconsistencies with PSQL FUNCTION vs UDF
bugs.core_5965_test  FB3 Optimiser chooses less efficient plan than FB2.5 optimiser
bugs.core_5970_test  Built-in cryptographic functions
bugs.core_5972_test  External engine trigger crashing server if table have computed field
bugs.core_6015_test  Segfault when using expression index with complex expression
bugs.core_6024_test  FB3.0.4.33063 vs FB3.0.5.33100 manual plan cause "index cannot be used in the specified plan"
bugs.core_6028_test  Trigger on system table restored in FB3 database and can't be deleted
bugs.core_6040_test  Metadata script extracted using ISQL is invalid/incorrect when table has COMPUTED BY field
bugs.core_6044_test  ISQL issues with increased identifier length
bugs.core_6049_test  Builtin functions converting binary string to hexadecimal representation and vice versa
bugs.core_6054_test  Random crash 64bit fb_inet_server. Possible collation issue
bugs.core_6078_test  Permissions for create or alter statements are not checked
bugs.core_6143_test  Error 'Multiple maps found for ...' is raised in not appropriate case
bugs.core_6147_test  PLG$SRP table, PLG$SRP_VIEW View instructions are strangely added in the metadata script extracted when Windows trusted authentication is enabled
bugs.core_6160_test  SUBSTRING of non-text/-blob is described to return NONE character set in DSQL
bugs.core_6166_test  Problems with long object names (> 255 bytes)
bugs.core_6171_test  "No current record for fetch operation" with queries with aggregated subselect
bugs.core_6208_test  CREATE DATABASE grant is lost in security.db after backup/restore cycle
bugs.core_6218_test  COUNT(DISTINCT <DECFLOAT_FIELD>) leads FB to crash when there are duplicate values of this field
bugs.core_6239_test  Procedures and EXECUTE BLOCK without RETURNS should not be allowed to use SUSPEND
bugs.core_6252_test  UNIQUE / PRIMARY KEY constraint can be violated when AUTODDL = OFF and mixing commands for DDL and DML
bugs.core_6265_test  mapping rules destroyed by backup / restore
bugs.core_6278_test  Efficient table scans for DBKEY-based range conditions
bugs.core_6285_test  SQL-level replication management
bugs.core_6300_test  Next attachment id, next statement id and some other additions [CORE-6300]
bugs.core_6316_test  Unable to specify new 32k page size
bugs.core_6336_test  Regression in FB 4.x: error "Implementation of text subtype <NNNN> not located" on attempt to use some collations defined in fbintl.conf
bugs.core_6343_test  Rolled back transaction produces unexpected results leading to duplicate values in PRIMARY KEY field
bugs.core_6353_test  INT128 has problems with some PSQL objects
bugs.core_6411_test  FB crashes on attempt to create table with number of fields greater than 5460
bugs.core_6440_test  Expression indexes containing COALESCE inside cannot be matched by the optimizer after migration from v2.5 to v3.0
bugs.core_6444_test  Ability to query Firebird configuration using SQL
bugs.core_6487_test  FETCH ABSOLUTE and RELATIVE beyond bounds of cursor should always position immediately before-first or after-last
bugs.core_6489_test  User without ALTER ANY ROLE privilege can use COMMENT ON ROLE
bugs.core_6527_test  Regression: inline comment of SP parameter with closing parenthesis leads to incorrect SQL when trying to extract metadata
bugs.gh_0310_test  System table with keywords
bugs.gh_3106_test  Many indexed reads in a compound index with NULLs
bugs.gh_3218_test  Optimizer fails applying stream-local predicates before merging [CORE2832]
bugs.gh_3357_test  Bad execution plan if some stream depends on multiple streams via a function [CORE2975]
bugs.gh_3810_test  Wrong or missing IS NULL optimization (regression) [CORE3449]
bugs.gh_3812_test  Query with SP doesn't accept explicit plan [CORE3451]
bugs.gh_4203_test  DROP [IF EXISTS]
bugs.gh_4314_test  Sub-optimal predicate checking while selecting from a view [CORE3981]
bugs.gh_4954_test  subselect losing the index when where clause includes coalesce() [CORE4640]
bugs.gh_5009_test  Index and blob garbage collection doesn't take into accout data in undo log [CORE4701]
bugs.gh_6778_test  Inconsistent cursor-driven deletion
bugs.gh_6782_test  Getting "records fetched" for functions/procedures in trace
bugs.gh_6797_test  Functions DECRYPT and RSA_DECRYPT return VARCHAR CHARACTER SET NONE instead of VARBINARY (VARCHAR) CHARACTER SET OCTETS
bugs.gh_6812_test  BASE64_ENCODE and HEX_ENCODE can exceed maximum widths for VARCHAR
bugs.gh_6816_test  Illegal output length in base64/hex_encode/decode functions
bugs.gh_6825_test  Correct error message for DROP VIEW
bugs.gh_6869_test  Domain CHECK-expression can be ignored when we DROP objects that are involved in it
bugs.gh_6873_test  SIMILAR TO does not use index when pattern starts with non-wildcard character (in contrary to LIKE)
bugs.gh_6903_test  Unable to create ICU-based collation with locale keywords
bugs.gh_6963_test  grant references not working
bugs.gh_6992_test  Transform OUTER joins into INNER ones if the WHERE condition violates the outer join rules
bugs.gh_7046_test  Make ability to add comment to mapping ('COMMENT ON MAPPING ... IS ...')
bugs.gh_7050_test  Add table MON$COMPILED_STATEMENTS and columns
bugs.gh_7062_test  Creation of expression index does not release its statement correctly
bugs.gh_7086_test  PSQL and SQL profiler
bugs.gh_7094_test  Incorrect indexed lookup of strings when the last keys characters are part of collated contractions and there is multi-segment insensitive descending index
bugs.gh_7118_test  Chained JOIN .. USING across the same column names may be optimized badly
bugs.gh_7123_test  ISQL does not extract "INCREMENT BY" for IDENTITY column
bugs.gh_7137_test  Optimizer regression: bad plan (HASH instead of JOIN) is chosen for some inner joins
bugs.gh_7164_test  Multi-way hash/merge joins are impossible for expression-based keys
bugs.gh_7167_test  Incorrect transliteration of field names in constraint violation errors
bugs.gh_7168_test  Ignore missing UDR libraries during restore
bugs.gh_7208_test  Trace: provide performance statistics for DDL statements
bugs.gh_7220_test  Dependencies of subroutines are not preserved after backup restore
bugs.gh_7256_test  Inconsistent conversion of non-TEXT blobs in BLOB_APPEND
bugs.gh_7257_misc_datatypes_test  Support for partial indices
bugs.gh_7257_test  Support for partial indices
bugs.gh_7269_test  Database restore must make every effort on activating deferred indexes
bugs.gh_7331_test  Cost-based choice between nested loop join and hash join
bugs.gh_7350_test  SKIP LOCKED clause for SELECT WITH LOCK, UPDATE and DELETE
bugs.gh_7398_test  Worst plan sort created to execute an indexed tables
bugs.gh_7413_test  Regression: bad plan in FB 3.0.9+ (correct in FB 3.0.8)
bugs.gh_7426_test  Ensure the DDL trigger requests are cached
bugs.gh_7461_test  Differences in field metadata descriptions between Firebird 2.5 and Firebird 4
bugs.gh_7466_plans_tracking_test  Add COMPILE trace events - ability to see execution plan of every PSQL statement.
bugs.gh_7466_test  Add COMPILE trace events for procedures/functions/triggers
bugs.gh_7494_test  Firebird performance issue - non necessary index reads
bugs.gh_7499_test  Problem with restore when backup has procedure which contains explicit PLAN clause with inappropriate indices.
bugs.gh_7506_test  Reduce output of the SHOW GRANTS command
bugs.gh_7517_test  Successful compiling of procedure with wrong PLAN(s) used by some of its statement(s)
bugs.gh_7553_test  Firebird 5 profiler error with subselects
bugs.gh_7568_test  Equivalence of boolean condition in partial index
bugs.gh_7604_test  PSQL functions do not convert the output BLOB to the connection character set
bugs.gh_7610_test  Uninitialized/random value assigned to RDB$ROLES -> RDB$SYSTEM PRIVILEGES when restoring from FB3 backup
bugs.gh_7611_test  Can't backup/restore database from v3 to v4 with SEC$USER_NAME field longer than 10 characters.
bugs.gh_7647_test  Regression: Error in isc_array_lookup_bounds
bugs.gh_7652_test  Make the profiler store aggregated requests by default, with option for detailed store
bugs.gh_7670_test  Cursor name can duplicate parameter and variable names in procedures and functions
bugs.gh_7675_test  EXPLAIN statement and RDB$SQL package
bugs.gh_7676_test  Invalid message when violating unique constraint ("Attempt to evaluate index expression recursively")
bugs.gh_7687_test  Add LEVEL column to PLG$PROF_RECORD_SOURCES and PLG$PROF_RECORD_SOURCE_STATS_VIEW
bugs.gh_7698_test  The legacy plan with window functions is broken
bugs.gh_7727_test  Index for integer column cannot be used when INT128/DECFLOAT value is being searched
bugs.gh_7730_test  Server ignores the size of VARCHAR when performing SET BIND ... TO VARCHAR(N)
bugs.gh_7744_test  Provide ability to run "ALTER SQL SECURITY DEFINER / INVOKER" without specifying further part of proc/func/package
bugs.gh_7749_test  Fix character set and collation output
bugs.gh_7752_test  The access path information is truncated to 255 characters in the PLG$PROF_RECORD_SOURCES table
bugs.gh_7786_test  Regression: ISQL extracts metadata with non-compilable 'COLLATE' clause if table has column with charset that differ from DB charset
bugs.gh_7804_test  The partial index is not involved when filtering conditions through OR.
bugs.gh_7853_test  Do not consider non-deterministic expressions as invariants in pre-filters
bugs.gh_7863_test  Non-correlated sub-query is evaluated multiple times if it is based on a VIEW rathe than on appropriate derived table.
bugs.gh_7899_test  Inconsistent state of master-detail occurs after RE-connect + 'SET AUTODDL OFF' + 'drop <FK>' which is ROLLED BACK
bugs.gh_7904_test  More realistic cardinality adjustments for unmatchable booleans // FB5 bad plan for query
bugs.gh_7921_test  FB5 uses PK for ordered plan even if less count of fields matching index exists
bugs.gh_7924_1_test  ALTER TABLE ALTER COLUMN <textual_field> can not be changed properly in some cases
bugs.gh_7924_2_test  ALTER TABLE ALTER COLUMN <textual_field> can not be changed properly in some cases
bugs.gh_7962_test  System procedure/function inconsistency between ISQL SHOW FUNCTIONS and SHOW PROCEDURES
bugs.gh_7989_test  Improve performance of external (UDR) functions
bugs.gh_8020_test  AV when both function and dependent table are dropped in the same transaction
bugs.gh_8061_addi_test  UNNEST subqueries invalidation. Examples when unnesting can NOT be used.
bugs.gh_8061_test  Unnest IN/ANY/EXISTS subqueries and optimize them using semi-join algorithm
bugs.gh_8062_test  CREATE [IF NOT EXISTS]
bugs.gh_8077_test  Error "Too many recursion levels" does not stop execuition of code that uses ON DISCONNECT trigger (FB 4.x+)
bugs.gh_8084_test  Partial index uniqueness violation (changes in columns participating in index filtering expression are not properly tracked).
bugs.gh_8091_test  Ability to create an inactive index
bugs.gh_8100_test  The isc_array_lookup_bounds function returns invalid values for low and high array bounds
bugs.gh_8109_test  Plan/Performance regression when using special construct for IN in FB5.x compared to FB3.x
bugs.gh_8115_test  Avoid reading/hashing the inner stream(s) if the leader stream is empty
bugs.gh_8123_test  Procedure manipulation can lead to wrong dependencies removal
bugs.gh_8161_test  Cardinality estimation should use primary record versions only
bugs.gh_8176_test  Firebird hangs after starting remote profiling session
bugs.gh_8203_test  MAKE_DBKEY can raise 'malformed string' for some table names
bugs.gh_8223_test  SubQueryConversion = true: error "no current record for fetch operation" with complex joins
bugs.gh_8225_test  Problematic queries when SubQueryConversion = true
bugs.gh_8231_test  SubQueryConversion = true causes "request size limit exceeded" / "... unavailable resource. Unable to allocate memory ..."
bugs.gh_8233_test  SubQueryConversion = true - multiple rows in singleton select
bugs.gh_8249_test  CAST() ignores collation of target data type
bugs.gh_8250_test  Bad performance on simple two joins query on tables with composed index
bugs.gh_8252_test  Incorrect subquery unnesting with complex dependencies (SubQueryConversion = true)
bugs.gh_8253_test  Incorrect handling of non-ASCII object names in CREATE MAPPING statement
bugs.gh_8263_test  gbak on Classic with ParallelWorkers > 1 doesn't restore indices, giving a cryptic error message
bugs.gh_8265_test  Nested IN/EXISTS subqueries should not be converted into semi-joins if the outer context is a sub-query which wasn't unnested
bugs.gh_8290_test  "Unique scan" is incorrectly reported in the explained plan for unique index and IS NULL predicate
bugs.gh_8434_test  Fix implicitly used collations after ALTER DOMAIN
functional.arno.derived_tables.test_06  Outer reference inside derived table to other relations in from clause is not allowed
functional.arno.derived_tables.test_07  Outer reference inside derived table to other relations in from clause is not allowed
functional.arno.derived_tables.test_08  Outer reference inside derived table to other relations in from clause is not allowed
functional.arno.derived_tables.test_09  Outer reference inside derived table to other relations in from clause is not allowed
functional.arno.derived_tables.test_23  Derived table with outer reference from JOIN.
functional.arno.derived_tables.test_24  Derived table with outer reference from LEFT JOIN.
functional.arno.derived_tables.test_25  Derived table with outer reference from FULL JOIN.
functional.arno.indices.test_lower_bound_asc_02_segments_01  ASC 2-segment index lower bound
functional.arno.indices.test_lower_bound_desc_02_segments_01  DESC 2-segment index lower bound
functional.arno.indices.test_timestamps_01  TIMESTAMP in index with values below julian date
functional.arno.indices.test_upper_bound_asc_01_segments_01  ASC single segment index upper bound
functional.arno.indices.test_upper_bound_asc_01_segments_02  ASC single segment index upper bound
functional.arno.indices.test_upper_bound_asc_01_segments_03  ASC single segment index upper bound
functional.arno.indices.test_upper_bound_asc_01_segments_04  ASC single segment index upper bound
functional.arno.indices.test_upper_bound_asc_02_segments_01  ASC 2-segment index upper bound
functional.arno.indices.test_upper_bound_desc_01_segments_01  DESC single segment index upper bound
functional.arno.indices.test_upper_bound_desc_01_segments_02  DESC single segment index upper bound
functional.arno.indices.test_upper_bound_desc_02_segments_01  DESC 2-segment index upper bound
functional.arno.optimizer.test_opt_aggregate_distribution_01  Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
functional.arno.optimizer.test_opt_aggregate_distribution_02  Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
functional.arno.optimizer.test_opt_aggregate_distribution_03  Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
functional.arno.optimizer.test_opt_aggregate_distribution_04  Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
functional.arno.optimizer.test_opt_aggregate_distribution_05  Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
functional.arno.optimizer.test_opt_aggregate_distribution_06  Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
functional.arno.optimizer.test_opt_aggregate_distribution_07  Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
functional.arno.optimizer.test_opt_aggregate_distribution_08  Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
functional.arno.optimizer.test_opt_aggregate_distribution_09  Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
functional.arno.optimizer.test_opt_aggregate_distribution_10  Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
functional.arno.optimizer.test_opt_aggregate_distribution_11  Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
functional.arno.optimizer.test_opt_aggregate_distribution_12  Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
functional.arno.optimizer.test_opt_aggregate_distribution_13  Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
functional.arno.optimizer.test_opt_aggregate_distribution_14  Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
functional.arno.optimizer.test_opt_avoid_index_usage  AVOID index usage in WHERE <indexed_varchar_field> = <integer_value>
functional.arno.optimizer.test_opt_full_join_01  FULL OUTER JOIN, list all values
functional.arno.optimizer.test_opt_full_join_02  FULL OUTER JOIN, list all values, but filtered in WHERE clause
functional.arno.optimizer.test_opt_full_join_03  FULL OUTER JOIN, list all values, but filtered in WHERE clause
functional.arno.optimizer.test_opt_full_join_04  FULL OUTER JOIN, list all values, but filtered in WHERE clause
functional.arno.optimizer.test_opt_inner_join_01  INNER JOIN join order
functional.arno.optimizer.test_opt_inner_join_02  INNER JOIN join order
functional.arno.optimizer.test_opt_inner_join_03  INNER JOIN join order
functional.arno.optimizer.test_opt_inner_join_04  INNER JOIN join order LIKE and IS NULL
functional.arno.optimizer.test_opt_inner_join_05  INNER JOIN join order LIKE and STARTING WITH
functional.arno.optimizer.test_opt_inner_join_06  INNER JOIN join order and VIEW
functional.arno.optimizer.test_opt_inner_join_07  INNER JOIN join order and VIEW
functional.arno.optimizer.test_opt_inner_join_08  INNER JOIN join order and VIEW
functional.arno.optimizer.test_opt_inner_join_09  INNER JOIN join order and distribution
functional.arno.optimizer.test_opt_inner_join_10  INNER JOIN join order
functional.arno.optimizer.test_opt_inner_join_merge_01  INNER JOIN join merge
functional.arno.optimizer.test_opt_inner_join_merge_02  INNER JOIN join merge
functional.arno.optimizer.test_opt_inner_join_merge_03  INNER JOIN join merge
functional.arno.optimizer.test_opt_inner_join_merge_04  INNER JOIN join merge and NULLs
functional.arno.optimizer.test_opt_inner_join_merge_05  INNER JOIN join merge and VIEWs
functional.arno.optimizer.test_opt_inner_join_merge_06  INNER JOIN join merge and SP
functional.arno.optimizer.test_opt_left_join_01  LEFT OUTER JOIN with no match at all
functional.arno.optimizer.test_opt_left_join_02  LEFT OUTER JOIN with no match and IS NULL in WHERE clause
functional.arno.optimizer.test_opt_left_join_04  LEFT OUTER JOIN with full match
functional.arno.optimizer.test_opt_left_join_05  LEFT OUTER JOIN with full match, but limited in ON clause
functional.arno.optimizer.test_opt_left_join_08  LEFT OUTER JOIN with full match, but limited in ON and WHERE clause
functional.arno.optimizer.test_opt_left_join_09  LEFT OUTER JOIN with full match, but limited in ON and WHERE clause
functional.arno.optimizer.test_opt_left_join_10  LEFT OUTER JOIN with IS NULL burried in WHERE clause
functional.arno.optimizer.test_opt_left_join_12  LEFT OUTER JOIN with distribution CASE
functional.arno.optimizer.test_opt_left_join_13  LEFT OUTER JOIN VIEW with full match
functional.arno.optimizer.test_opt_mixed_joins_01  Mixed JOINS
functional.arno.optimizer.test_opt_mixed_joins_02  Mixed JOINS
functional.arno.optimizer.test_opt_mixed_joins_03  Mixed JOINS
functional.arno.optimizer.test_opt_mixed_joins_04  Mixed JOINS
functional.arno.optimizer.test_opt_mixed_joins_05  Mixed JOINS
functional.arno.optimizer.test_opt_mixed_joins_06  Mixed JOINS
functional.arno.optimizer.test_opt_multi_index_selection_01  Unique index selection (multi segment)
functional.arno.optimizer.test_opt_multi_index_selection_02  Best match index selection (multi segment)
functional.arno.optimizer.test_opt_multi_index_selection_03  Best match index selection (multi segment)
functional.arno.optimizer.test_opt_multi_index_selection_04  Best match index selection (multi segment)
functional.arno.optimizer.test_opt_multi_index_selection_05  Best match index selection (multi segment)
functional.arno.optimizer.test_opt_multi_index_selection_07  Best match index selection (multi segment)
functional.arno.optimizer.test_opt_multi_index_selection_08  Best match index selection (multi segment)
functional.arno.optimizer.test_opt_single_index_selection_01  Unique index selection (single segment)
functional.arno.optimizer.test_opt_single_index_selection_02  Best match index selection (single segment)
functional.arno.optimizer.test_opt_single_index_selection_03  Best match index selection (single segment)
functional.arno.optimizer.test_opt_single_index_selection_04  Best match index selection (single segment)
functional.arno.optimizer.test_opt_single_index_selection_05  Best match index selection (single segment) ASC and DESC
functional.arno.optimizer.test_opt_single_index_selection_06  Best match index selection (single segment)
functional.arno.optimizer.test_opt_single_index_selection_07  Best match index selection (single segment)
functional.arno.optimizer.test_opt_single_index_selection_08  Best match index selection (single segment)
functional.arno.optimizer.test_opt_single_index_selection_09  Best match index selection (single segment) OR
functional.arno.optimizer.test_opt_single_index_selection_10  Best match index selection (single segment) OR
functional.arno.optimizer.test_opt_single_index_selection_11  Best match index selection (single segment)
functional.arno.optimizer.test_opt_sort_by_index_01  ORDER BY ASC using index (unique)
functional.arno.optimizer.test_opt_sort_by_index_02  ORDER BY DESC using index (unique)
functional.arno.optimizer.test_opt_sort_by_index_03  ORDER BY ASC using index (non-unique)
functional.arno.optimizer.test_opt_sort_by_index_04  ORDER BY DESC using index (non-unique)
functional.arno.optimizer.test_opt_sort_by_index_05  MAX() and DESC index (non-unique)
functional.arno.optimizer.test_opt_sort_by_index_06  MAX() and ASC index (non-unique)
functional.arno.optimizer.test_opt_sort_by_index_07  MIN() and ASC index (non-unique)
functional.arno.optimizer.test_opt_sort_by_index_08  MIN() and DESC index (non-unique)
functional.arno.optimizer.test_opt_sort_by_index_09  ORDER BY ASC using index (non-unique)
functional.arno.optimizer.test_opt_sort_by_index_10  ORDER BY ASC using index (multi)
functional.arno.optimizer.test_opt_sort_by_index_11  ORDER BY ASC using index (multi)
functional.arno.optimizer.test_opt_sort_by_index_12  ORDER BY ASC, DESC using index (multi)
functional.arno.optimizer.test_opt_sort_by_index_13  ORDER BY ASC using index (multi)
functional.arno.optimizer.test_opt_sort_by_index_14  ORDER BY ASC NULLS FIRST using index
functional.arno.optimizer.test_opt_sort_by_index_15  ORDER BY ASC NULLS LAST using index
functional.arno.optimizer.test_opt_sort_by_index_16  ORDER BY DESC NULLS FIRST using index
functional.arno.optimizer.test_opt_sort_by_index_17  ORDER BY DESC NULLS LAST using index
functional.arno.optimizer.test_opt_sort_by_index_18  ORDER BY ASC using index (single) and WHERE clause
functional.arno.optimizer.test_opt_sort_by_index_19  ORDER BY ASC using index (multi) and WHERE clause
functional.basic.isql.test_02  ISQL - SHOW SYSTEM TABLES
functional.basic.isql.test_03  ISQL - SHOW SYSTEM parameters
functional.basic.isql.test_06  Let ISQL show per-table run-time statistics.
functional.basic.isql.test_autoterm_01  SET AUTOTERM ON/OFF. Basic test.
functional.basic.isql.test_autoterm_03  SET AUTOTERM ON/OFF. Additional tests.
functional.database.create.test_00  Verify ability to create database with different values of PAGE_SIZE
functional.datatypes.test_decfloat_columns_handlng  Check ability of misc. actions against table column for DECFLOAT datatype
functional.datatypes.test_decfloat_literal_interpr  Test interpretation of numeric literals
functional.datatypes.test_decfloat_literal_length  Literal length currently is limited with 1024 characters (including decimal separator and minus sign if any)
functional.dml.merge.test_03  MERGE ... RETURNING must refer either ALIAS of the table (if it is defined) or context variables OLD and NEW
functional.dml.skip_locked.test_skip_locked_basic  Basic check of SKIP LOCKED
functional.dml.update_or_insert.test_03  UPDATE OR INSERT
functional.domain.alter.test_05  ALTER DOMAIN - Alter domain that doesn't exists
functional.domain.create.test_01  CREATE DOMAIN - SMALLINT
functional.domain.create.test_02  CREATE DOMAIN - INTEGER
functional.domain.create.test_03  CREATE DOMAIN - INT
functional.domain.create.test_04  CREATE DOMAIN - FLOAT
functional.domain.create.test_05  CREATE DOMAIN - DOUBLE PRECISION
functional.domain.create.test_06  CREATE DOMAIN - DOUBLE PRECISION - ARRAY
functional.domain.create.test_07  CREATE DOMAIN - DATE
functional.domain.create.test_08  CREATE DOMAIN - TIME
functional.domain.create.test_09  CREATE DOMAIN - TIMESTAMP
functional.domain.create.test_10  CREATE DOMAIN - TIMESTAMP ARRAY
functional.domain.create.test_11  CREATE DOMAIN - DECIMAL
functional.domain.create.test_12  CREATE DOMAIN - DECIMAL ARRAY
functional.domain.create.test_13  CREATE DOMAIN - NUMERIC
functional.domain.create.test_14  CREATE DOMAIN - NUMERIC ARRAY
functional.domain.create.test_20  CREATE DOMAIN - VARCHAR CHARACTER SET
functional.domain.create.test_21  CREATE DOMAIN - NCHAR
functional.domain.create.test_22  CREATE DOMAIN - NATIONAL CHARACTER
functional.domain.create.test_23  CREATE DOMAIN - NATIONAL CHAR
functional.domain.create.test_24  CREATE DOMAIN - NATIONAL CHAR VARYING
functional.domain.create.test_25  CREATE DOMAIN - NATIONAL CHAR VARYING ARRAY
functional.domain.create.test_37  CREATE DOMAIN - NOT NULL
functional.domain.create.test_41  CREATE DOMAIN - create two domain with same name
functional.domain.create.test_54  Use of domains for Trigger/SP variable definition
functional.domain.drop.test_02  DROP DOMAIN - in use
functional.domain.drop.test_03  DROP DOMAIN - that doesn't exists
functional.exception.create.test_02  CREATE EXCEPTION - try create Exception with the same name
functional.exception.create.test_03  CREATE EXCEPTION - too long message
functional.exception.drop.test_02  DROP EXCEPTION
functional.exception.drop.test_03  DROP EXCEPTION - that doesn't exists
functional.exception.test_handling_name_and_message  Context variables EXCEPTION and ERROR_MESSAGE for ability to log exception info (including call stack!) on server side
functional.fkey.primary.test_insert_pk_02  Check correct work fix with foreign key
functional.fkey.primary.test_insert_pk_03  Check correct work fix with foreign key
functional.fkey.primary.test_insert_pk_04  Check correct work fix with foreign key
functional.fkey.primary.test_insert_pk_08  Check correct work fix with foreign key
functional.fkey.primary.test_insert_pk_09  Check correct work fix with foreign key
functional.fkey.primary.test_insert_pk_13  Check correct work fix with foreign key
functional.fkey.primary.test_insert_pk_14  Check correct work fix with foreign key
functional.fkey.primary.test_insert_pk_15  Check correct work fix with foreign key
functional.fkey.unique.test_insert_07  Check correct work fix with foreign key
functional.fkey.unique.test_insert_09  Check correct work fix with foreign key
functional.generator.create.test_01  CREATE GENERATOR and query related data from RDB$GENERATORS
functional.generator.create.test_02  CREATE GENERATOR - try create gen with same name
functional.generator.drop.test_02  DROP GENERATOR - in use
functional.generator.drop.test_03  DROP GENERATOR - generator does not exists
functional.gtcs.test_computed_fields_11  Computed fields
functional.gtcs.test_computed_fields_13  Computed fields
functional.gtcs.test_computed_fields_14  Computed fields
functional.gtcs.test_division_by_zero_corrupts_db  Zero divide in SP can crash database when call this SP several times
functional.gtcs.test_dsql_domain_07  Test CREATE / ALTER domain statement with ADD/DROP CONSTRAINT clauses, together and separately.
functional.gtcs.test_dsql_domain_21  Verify result of ALTER DOMAIN with changing DEFAULT values and DROP constraints when a table exists with field based on this domain
functional.gtcs.test_isql_show_command_ambiguity  SHOW TABLE / VIEW: ambiguity between tables and views
functional.gtcs.test_misplaced_collation_in_extracted_metadata  Misplaced collation when extracting metadata with isql
functional.gtcs.test_ref_integ_drop_fk_index  Index that is used for FK should not be avail for DROP
functional.gtcs.test_ref_integ_drop_pk_constraint  Constraint of PRIMARY KEY should not be avail for DROP if there is FK that depends on it
functional.gtcs.test_ref_integ_drop_pk_index  Index that is used for PRIMARY KEY should not be avail for DROP
functional.gtcs.test_ref_integ_inactive_fk_index  Index that is used for FK should not be avail for INACTIVE
functional.gtcs.test_ref_integ_inactive_pk_index  Index that is used for PRIMARY KEY should not be avail for INACTIVE
functional.gtcs.test_ref_integ_inactive_pk_index_2  Index that is used for PRIMARY KEY should not be avail for INACTIVE
functional.gtcs.test_time_zone  Miscelaneous time zone tests
functional.index.alter.test_04  ALTER INDEX - INACTIVE PRIMARY KEY
functional.index.alter.test_05  ALTER INDEX - INACTIVE FOREIGN KEY
functional.index.create.test_01  CREATE INDEX
functional.index.create.test_02  CREATE UNIQUE INDEX
functional.index.create.test_03  CREATE ASC INDEX
functional.index.create.test_04  CREATE ASCENDING INDEX
functional.index.create.test_05  CREATE DESC INDEX
functional.index.create.test_06  CREATE DESCENDING INDEX
functional.index.create.test_07  CREATE INDEX - Multi column
functional.index.create.test_08  CREATE INDEX - Table with data
functional.index.create.test_09  CREATE UNIQUE INDEX - Table with data
functional.index.create.test_10  CREATE INDEX - try create index with same name
functional.index.create.test_11  CREATE UNIQUE INDEX - Non unique data in table
functional.intfunc.unlist.unlist_basic_test  UNLIST function. Basic examples.
functional.intl.test_non_ascii_firebird_and_trace_utf8  Check ability to obtain non-ascii content from firebird.log and trace when use ON DISCONNECT trigger and exception with non-ascii names, charset = UTF8.
functional.monitoring.test_03  table MON$COMPILED_STATEMENTS and columns MON$STATEMENTS.MON$COMPILED_STATEMENT_ID and MON$CALL_STACK.MON$COMPILED_STATEMENT_ID
functional.procedure.alter.test_02  ALTER PROCEDURE - Alter non exists procedure
functional.procedure.create.test_01  CREATE PROCEDURE
functional.procedure.create.test_02  CREATE PROCEDURE - Input parameters
functional.procedure.create.test_03  CREATE PROCEDURE - Output paramaters
functional.procedure.create.test_04  CREATE PROCEDURE - Output paramaters
functional.procedure.create.test_05  CREATE PROCEDURE - PSQL Stataments
functional.procedure.create.test_06  CREATE PROCEDURE - PSQL Stataments - SUSPEND
functional.procedure.create.test_07  CREATE PROCEDURE - try create SP with same name
functional.services.test_user_management  Check ability to make connect to FB services and add/drop user
functional.session.test_alter_session_reset  Test results of ALTER SESSION RESET
functional.syspriv.test_access_any_object  Check ability to query, modify and deleting data plus add/drop constraints on any table
functional.syspriv.test_change_mapping_rules  Check ability to manage auth mappings
functional.syspriv.test_create_user_types  Check ability to update content of RDB$TYPES
functional.syspriv.test_grant_revoke_any_ddl_right  Check ability to grant right for issuing CREATE/ALTER/DROP statements
functional.syspriv.test_grant_revoke_any_object  Check ability to query, modify and deleting data plus add/drop constraints on any table
functional.syspriv.test_use_granted_by_clause  Check ability to query, modify and deleting data plus add/drop constraints on any table
functional.syspriv.test_user_management_in_selfsec_db  Self-secutity DB: system privilege USER_MANAGEMENT must allow only to add/alter/drop user. No access to any user tables must be granted.
functional.table.alter.test_02  ALTER TABLE. Add column with DEFAULT expression, NOT NULL requirement and UNIQUE constraint that must be applied to its values.
functional.table.alter.test_03  ALTER TABLE - ADD CONSTRAINT - PRIMARY KEY
functional.table.alter.test_04  ALTER TABLE - ADD CONSTRAINT - UNIQUE
functional.table.alter.test_05  ALTER TABLE - ALTER - TO
functional.table.alter.test_06  ALTER TABLE. Alter type of some column.
functional.table.alter.test_08  ALTER TABLE - DROP
functional.table.alter.test_10  ALTER TABLE - DROP CONSTRAINT - PRIMARY KEY
functional.table.alter.test_12  Verify ability to create exactly 254 changes of format (increasing it by 1) after initial creating table
functional.table.create.test_04  CREATE TABLE - constraints
functional.table.create.test_05  CREATE TABLE - create table with same name
functional.table.create.test_06  CREATE TABLE - two column with same name
functional.table.create.test_07  CREATE TABLE - unknown datatype (domain)
functional.tabloid.test_35f56933  Fixed cardinality mistake for invariant booleans
functional.tabloid.test_3b372197  built-in functions UNICODE_CHAR and UNICODE_VAL
functional.tabloid.test_80fd0682  Fixed bug with index names patterns in online validation service
functional.tabloid.test_95442bdf  Attempt to avoid hash joining for possible cardinality under-estimations
functional.tabloid.test_aae2ae32  Better fix for #8252: incorrect subquery unnesting with complex dependencies, it re-allows converting nested IN/EXISTS into multiple semi-join
functional.tabloid.test_cc183f59  Add key info to the merge join plan output
functional.tabloid.test_dml_privileges_sufficiency  Verify sufficiency of privileges for performing DML actions. Verify that RETURNING clause can not be used without SELECT privilege.
functional.tabloid.test_e260ced8  Allow computable but non-invariant lists to be used for index lookup
functional.tabloid.test_eqc_136030  Check ability for preparing and then run query with parameters. Query should use ORDER-BY clause.
functional.tabloid.test_eqc_166663  Index(es) should not become corrupted after two updates and raising exception in one Tx, doing inside SP
functional.tabloid.test_optimizer_index_navigation  Check that optimizer takes in account presense of index and does navigation instead of external sort.
functional.trigger.alter.test_01  ALTER TRIGGER - ACTIVE
functional.trigger.alter.test_02  ALTER TRIGGER - INACTIVE
functional.trigger.alter.test_03  ALTER TRIGGER - BEFORE DELETE
functional.trigger.alter.test_04  ALTER TRIGGER - BEFORE INSERT
functional.trigger.alter.test_05  ALTER TRIGGER - BEFORE UPDATE
functional.trigger.alter.test_06  ALTER TRIGGER - AFTER DELETE
functional.trigger.alter.test_07  ALTER TRIGGER - AFTER INSERT
functional.trigger.alter.test_08  ALTER TRIGGER - POSITION
functional.trigger.alter.test_10  ALTER TRIGGER - AS
functional.trigger.alter.test_12  ALTER TRIGGER - AS
functional.trigger.alter.test_13  ALTER TRIGGER - AS
functional.trigger.create.test_01  CREATE TRIGGER
functional.trigger.create.test_02  CREATE TRIGGER AFTER INSERT
functional.trigger.create.test_03  CREATE TRIGGER BEFORE UPDATE
functional.trigger.create.test_04  CREATE TRIGGER AFTER UPDATE
functional.trigger.create.test_05  CREATE TRIGGER BEFORE DELETE
functional.trigger.create.test_06  CREATE TRIGGER AFTER DELETE
functional.trigger.create.test_07  CREATE TRIGGER INACTIVE AFTER DELETE
functional.trigger.create.test_08  CREATE TRIGGER AFTER DELETE POSITION 12
functional.trigger.create.test_09  CREATE TRIGGER BEFORE INSERT DECLARE VARIABLE
functional.trigger.create.test_10  CREATE TRIGGER BEFORE INSERT DECLARE VARIABLE, block stataments
functional.trigger.create.test_17  CREATE TRIGGER SQL2003
functional.trigger.database.test_connect_02  Error handling in trigger on database connect
functional.trigger.database.test_connect_04  Error handling when multiple triggers on database connect exist
functional.trigger.database.test_disconnect_01  Trigger on database disconnect: check that exception that raised when trigger fires is written to firebird.log
functional.trigger.database.test_transactionstart_01  Trigger on start tansaction
functional.trigger.table.test_alter_01  ALTER TRIGGER - ACTIVE
functional.trigger.table.test_alter_02  ALTER TRIGGER - INACTIVE
functional.trigger.table.test_alter_03  ALTER TRIGGER - BEFORE DELETE
functional.trigger.table.test_alter_04  ALTER TRIGGER - BEFORE INSERT
functional.trigger.table.test_alter_05  ALTER TRIGGER - BEFORE UPDATE
functional.trigger.table.test_alter_06  ALTER TRIGGER - AFTER DELETE
functional.trigger.table.test_alter_07  ALTER TRIGGER: attempt to use "new" in AFTER INSERT
functional.trigger.table.test_alter_08  ALTER TRIGGER - POSITION
functional.trigger.table.test_alter_10  ALTER TRIGGER - AS
functional.trigger.table.test_alter_12  ALTER TRIGGER - AS
functional.trigger.table.test_alter_13  ALTER TRIGGER - AS
functional.view.create.test_01  CREATE VIEW
functional.view.create.test_02  CREATE VIEW
functional.view.create.test_03  CREATE VIEW - bad number of columns
functional.view.create.test_04  CREATE VIEW - bad number of columns
functional.view.create.test_08  CREATE VIEW - updateable WITH CHECK OPTION

This list is the same for:
6.0.0.863 2025.06.24 c3c20114  CS