Problematic tests list (759 rows):
bugs.gh_8194_test  Internal consistency check (page in use during flush) with small number of DefaultDbCachePages
bugs.gh_8203_test  MAKE_DBKEY can raise 'malformed string' for some table names
bugs.gh_8211_test  DATEADD truncates milliseconds for month and year deltas.
bugs.gh_8213_test  WHEN NOT MATCHED BY SOURCE - does not work with a direct table as source
bugs.gh_8214_test  Incorrect result of index list scan for a composite index, the second segment of which is a text field with COLLATE UNICODE_CI
bugs.gh_8219_test  Database creation in 3.0.12, 4.0.5 and 5.0.1 slower than in previous releases
bugs.gh_8221_test  Crash when MAKE_DBKEY() is called with 0 or 1 arguments
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_8241_test  gbak may lose NULLs in restore
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_8255_test  Catch possible stack overflow when preparing and compiling user statements
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_8278_test  Avoid index lookup for a NULL key if the condition is known to always be FALSE in this case
bugs.gh_8290_test  "Unique scan" is incorrectly reported in the explained plan for unique index and IS NULL predicate
bugs.gh_8291_test  NULLs should be skipped during index navigation when there's no lower bound and matched conditions are known to ignore NULLs
bugs.gh_8304_test  wrong results using minvalue/maxvalue in join condition
bugs.gh_8310_test  Collect network statistics and make it available for the user applications
bugs.gh_8318_test  Send blob contents in the same data stream as main resultset
bugs.gh_8323_test  Add AUTO RELEASE TEMP BLOBID transaction option
bugs.gh_8353_test  Report unique usernames for isc_info_user_names
bugs.gh_8356_test  Make Trace use HEX representation for parameter values of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY
bugs.gh_8386_test  Crash when creating index on table that uses UDR and ParallelWorkers > 1
bugs.gh_8394_test  Make Trace use HEX representation for parameter values of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY
bugs.gh_8421_test  Add pointers tree to TempSpace class
bugs.gh_8429_test  Segfault when already destroyed callback interface is used
bugs.gh_8462_test  A user with "GRANT_REVOKE_ON_ANY_OBJECT" privilege can't revoke a role from himself if he is not a grantor
bugs.gh_8477_test  Inheritance of WINDOW does not work
bugs.gh_8508_test  Conversion Error with old.field in UPDATE OR INSERT
bugs.gh_8513_test  Makes MON$COMPILED_STATEMENTS and MON$STATEMENTS share blobs with text and plan content of the same statement
bugs.gh_8520_test  Error in iTransaction.getInfo() on embedded connection
functional.arno.derived_tables.test_01  Simple derived table
functional.arno.derived_tables.test_02  Unnamed (no relation alias) derived table
functional.arno.derived_tables.test_03  Explicit column names for derived table
functional.arno.derived_tables.test_04  Derived table column names must be unique
functional.arno.derived_tables.test_05  Derived table column names must be unique
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_10  Outer reference to upper scope-level is allowed
functional.arno.derived_tables.test_11  Outer reference to upper scope-level is allowed
functional.arno.derived_tables.test_12  Outer reference to upper scope-level is allowed
functional.arno.derived_tables.test_13  DISTINCT inside derived table
functional.arno.derived_tables.test_14  FIRST / SKIP inside derived table
functional.arno.derived_tables.test_15  UNION inside derived table
functional.arno.derived_tables.test_16  Simple derived table with aggregate inside
functional.arno.derived_tables.test_17  Aggregate inside derived table
functional.arno.derived_tables.test_18  Aggregate inside derived table
functional.arno.derived_tables.test_19  Sub-select inside derived table
functional.arno.derived_tables.test_20  Sub-select inside derived table
functional.arno.derived_tables.test_21  Implicit derived table by IN predicate
functional.arno.derived_tables.test_22  Derived table outer reference (triggers)
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.derived_tables.test_26  Derived table with column that is specified several times
functional.arno.derived_tables.test_27  Derived table with same alias for several columns
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_starting_with_01  STARTING WITH charset NONE
functional.arno.indices.test_starting_with_02  STARTING WITH charset ISO8859_1
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.indices.test_upper_lower_bounds_01  Upper and lower bounds
functional.arno.indices.test_upper_lower_bounds_02  Upper and lower bounds
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_03  LEFT OUTER JOIN with full match and reference 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_06  LEFT OUTER JOIN with full match, but limited in ON clause
functional.arno.optimizer.test_opt_left_join_07  4 JOINed tables with 1 LEFT OUTER JOIN
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_11  LEFT OUTER JOIN with STARTING WITH 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_selectivity_01  SELECTIVITY - SET STATISTICS
functional.arno.optimizer.test_opt_selectivity_02  SELECTIVITY - CREATE INDEX
functional.arno.optimizer.test_opt_selectivity_03  SELECTIVITY - INDEX INACTIVE / ACTIVE
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_00  Check output of "HELP" and "HELP SET" commands
functional.basic.isql.test_01  ISQL - SHOW DATABASE
functional.basic.isql.test_02  ISQL - SHOW SYSTEM TABLES
functional.basic.isql.test_03  ISQL - SHOW SYSTEM parameters
functional.basic.isql.test_05  ISQL should be able to process single statement with length up to 10*1024*1024 chars
functional.basic.isql.test_06  Let ISQL show per-table run-time statistics.
functional.blob.test_rdb_blob_util_basic  Basic test of RDB$BLOB_UTIL package functionality
functional.blob.test_read_blob_in_multiple_cursors  Ability to read same blob_id using multiple cursors
functional.blob.test_small_blob_caching  Operations with inline streamed blobs when boundary values are used for seek() and read() methods.
functional.database.alter.test_01  Alter database: adding a secondary file
functional.database.alter.test_02  Alter database: adding secondary file with alternate keyword
functional.database.alter.test_03  Alter database: add file with name of this database or previously added files must fail
functional.database.create.test_00  Verify ability to create database with different values of PAGE_SIZE
functional.database.create.test_01  Create database: set names and default character set
functional.database.create.test_02  Create database: non sysdba user
functional.database.create.test_08  Create database: Multi file DB
functional.database.create.test_09  Create database: Multi file DB
functional.database.create.test_10  Create database: Multi file DB - starting
functional.database.create.test_11  Create database: Default char set NONE
functional.database.create.test_13  Create database: check that actual FW setting is ON for just created database.
functional.datatypes.test_decfloat_binding_to_legacy  Test ability for DECFLOAT values to be represented as other data types using LEGACY keyword.
functional.datatypes.test_decfloat_binding_to_other_types  Test ability for DECFLOAT values to be represented as other data types (char, double, bigint).
functional.datatypes.test_decfloat_boundary_values  Check BOUNDARY values that are defined for DECFLOAT datatype
functional.datatypes.test_decfloat_columns_handlng  Check ability of misc. actions against table column for DECFLOAT datatype
functional.datatypes.test_decfloat_ddl_indices  Check ability to create table with 16 fields of type decfloat(34), plus create indices and add data
functional.datatypes.test_decfloat_df16_alignment  Check proper alignment of decfloat(16) value if it is shown in ISQL when SET LIST ON
functional.datatypes.test_decfloat_exceptions_trapping  Test exception trapping for result of DECFLOAT operations
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.datatypes.test_decfloat_loose_accuracy  Test for preseving accuracy when evaluate sum of values with huge difference in magnitude
functional.datatypes.test_decfloat_min_distinguish  List of all values starting from 1.0 divided by 2, until previous and current become equal
functional.datatypes.test_decfloat_nan_and_infinity_comparison  DECFLOAT should not throw exceptions when +/-NaN, +/-sNaN and +/-Infinity is used in comparisons
functional.datatypes.test_decfloat_ordering_rules  Test ordering of decfloat values
functional.datatypes.test_decfloat_parsing_scaled_integers_and_bigint_max_min  Interpretation of DECFLOAT values as BIGINT
functional.datatypes.test_decfloat_round_modes  Check validity of different ROUNDING modes that are defined for DECFLOAT datatype
functional.datatypes.test_decfloat_scalar_functions  Test common math functions that should work with DECFLOAT datatype
functional.datatypes.test_decfloat_single_bit_in_representation  Check result of EXP() which can be represented only by one ("last") significant bit
functional.datatypes.test_decfloat_special_functions  Test functions that are designed specially for DECFLOAT handling
functional.datatypes.test_decimal_declared_scale  Dummy test
functional.datatypes.test_double_min_distinguish  List of all values starting from 1.0 divided by 2, until previous and current become equal
functional.datatypes.test_int128_agregate_functions  Basic test for aggregation functions against INT128 datatype
functional.datatypes.test_int128_binary_operations  Basic test for binary functions against INT128 datatype
functional.datatypes.test_int128_math_functions  Basic test for math functions against INT128 datatype
functional.datatypes.test_miscelan_binding  Test ability for DECFLOAT values to be represented as other data types using LEGACY keyword.
functional.dml.cte.test_01  Non-Recursive CTEs
functional.dml.cte.test_02  Recursive CTEs
functional.dml.delete.test_01  DELETE
functional.dml.delete.test_02  DELETE with WHERE
functional.dml.delete.test_03  DELETE from VIEW
functional.dml.insert.test_01  INSERT with Defaults
functional.dml.join.test_01  NAMED COLUMNS join
functional.dml.join.test_02  NATURAL join
functional.dml.merge.test_01  MERGE statement
functional.dml.merge.test_02  MERGE statement can have only one RETURNING which must be after all WHEN sub-statements
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_01  UPDATE OR INSERT
functional.dml.update_or_insert.test_02  UPDATE OR INSERT
functional.dml.update_or_insert.test_03  UPDATE OR INSERT
functional.domain.alter.test_01  ALTER DOMAIN - SET DEFAULT
functional.domain.alter.test_02  ALTER DOMAIN - DROP DEFAULT
functional.domain.alter.test_03  ALTER DOMAIN - ADD CONSTRAINT
functional.domain.alter.test_04  ALTER DOMAIN - DROP CONSTRAINT
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_15  CREATE DOMAIN - CHAR
functional.domain.create.test_16  CREATE DOMAIN using 'CHARACTER' keyword
functional.domain.create.test_17  CREATE DOMAIN using 'CHARACTER VARYING' keyword
functional.domain.create.test_18  CREATE DOMAIN using 'VARCHAR' keyword
functional.domain.create.test_19  CREATE DOMAIN - VARCHAR 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_26  CREATE DOMAIN - BLOB
functional.domain.create.test_27  CREATE DOMAIN. Specifying BLOB SUB_TYPE <N>, where N = 0 or 1.
functional.domain.create.test_28  CREATE DOMAIN. Specifying BLOB SUB_TYPE <A>, where A = 'binary' or 'text'.
functional.domain.create.test_29  CREATE DOMAIN - BLOB SEGMENT SIZE
functional.domain.create.test_31  CREATE DOMAIN. Check ability to declare using syntax BLOB(seglen, num_subtype)
functional.domain.create.test_32  CREATE DOMAIN - DEFAULT literal
functional.domain.create.test_33  CREATE DOMAIN - DEFAULT NULL
functional.domain.create.test_34  CREATE DOMAIN - DEFAULT USER
functional.domain.create.test_36  CREATE DOMAIN - DEFAULT CURRENT_ROLE
functional.domain.create.test_37  CREATE DOMAIN - NOT NULL
functional.domain.create.test_38  CREATE DOMAIN - CHECK
functional.domain.create.test_40  CREATE DOMAIN - all options
functional.domain.create.test_41  CREATE DOMAIN - create two domain with same name
functional.domain.create.test_42  CREATE DOMAIN - domain name equal to existing datatype
functional.domain.create.test_54  Use of domains for Trigger/SP variable definition
functional.domain.drop.test_01  DROP DOMAIN
functional.domain.drop.test_02  DROP DOMAIN - in use
functional.domain.drop.test_03  DROP DOMAIN - that doesn't exists
functional.exception.alter.test_01  ALTER EXCEPTION
functional.exception.create.test_01  CREATE EXCEPTION
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_01  DROP EXCEPTION
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_01  Check correct work fix with foreign key
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_05  Check correct work fix with foreign key
functional.fkey.primary.test_insert_pk_06  Check correct work fix with foreign key
functional.fkey.primary.test_insert_pk_07  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_10  Check correct work fix with foreign key
functional.fkey.primary.test_insert_pk_11  Check correct work fix with foreign key
functional.fkey.primary.test_insert_pk_12  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.primary.test_insert_pk_16  Check correct work fix with foreign key
functional.fkey.primary.test_insert_pk_17  Check correct work fix with foreign key
functional.fkey.primary.test_insert_pk_18  Check correct work fix with foreign key
functional.fkey.primary.test_insert_pk_19  Check correct work fix with foreign key
functional.fkey.primary.test_select_pk_01  Check correct work fix with foreign key
functional.fkey.primary.test_select_pk_02  Check correct work fix with foreign key
functional.fkey.primary.test_upd_pk_01  Check correct work fix with foreign key
functional.fkey.primary.test_upd_pk_02  Check correct work fix with foreign key
functional.fkey.unique.test_insert_01  Check correct work fix with foreign key
functional.fkey.unique.test_insert_02  Check correct work fix with foreign key
functional.fkey.unique.test_insert_03  Check correct work fix with foreign key
functional.fkey.unique.test_insert_04  Check correct work fix with foreign key
functional.fkey.unique.test_insert_05  Check correct work fix with foreign key
functional.fkey.unique.test_insert_06  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_08  Check correct work fix with foreign key
functional.fkey.unique.test_insert_09  Check correct work fix with foreign key
functional.fkey.unique.test_insert_11  Check correct work fix with foreign key
functional.fkey.unique.test_insert_12  Check correct work fix with foreign key
functional.fkey.unique.test_insert_13  Check correct work fix with foreign key
functional.fkey.unique.test_insert_14  Check correct work fix with foreign key
functional.fkey.unique.test_select_uf_01  Check correct work fix with foreign key
functional.fkey.unique.test_select_uf_02  Check correct work fix with foreign key
functional.fkey.unique.test_upd_01  Check correct work fix with foreign key
functional.fkey.unique.test_upd_02  Check correct work fix with foreign key
functional.generator.alter.test_01  ALTER SEQUENCE
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_01  DROP GENERATOR
functional.generator.drop.test_02  DROP GENERATOR - in use
functional.generator.drop.test_03  DROP GENERATOR - generator does not exists
functional.gtcs.test_cast_datatypes  Check result or CAST() for misc agruments // from GTCS.
functional.gtcs.test_computed_fields_01  Computed fields
functional.gtcs.test_computed_fields_02  Computed fields
functional.gtcs.test_computed_fields_03  Computed fields
functional.gtcs.test_computed_fields_04  Computed fields
functional.gtcs.test_computed_fields_05  Computed fields
functional.gtcs.test_computed_fields_06  Computed fields
functional.gtcs.test_computed_fields_07  Computed fields
functional.gtcs.test_computed_fields_08  Computed fields
functional.gtcs.test_computed_fields_09  Computed fields
functional.gtcs.test_computed_fields_10  Computed fields
functional.gtcs.test_computed_fields_11  Computed fields
functional.gtcs.test_computed_fields_12  Computed fields
functional.gtcs.test_computed_fields_13  Computed fields
functional.gtcs.test_computed_fields_14  Computed fields
functional.gtcs.test_computed_fields_15  Computed fields
functional.gtcs.test_computed_fields_16  Computed fields
functional.gtcs.test_computed_fields_17  Computed fields
functional.gtcs.test_conversion_error_from_string  Script issues conversion error from string
functional.gtcs.test_crash_of_group_by_varchar_4000  Crash on attempt to GROUP BY on table with varchar(4000) field
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_01  Test the level 0 syntax for SQL create domain defining only the datatype
functional.gtcs.test_dsql_domain_02  Test the level 0 syntax for SQL "CREATE DOMAIN" statement using datatype and DEFAULT clauses
functional.gtcs.test_dsql_domain_03  Test the level 0 syntax for SQL "CREATE DOMAIN" statement using datatype and NOT NULL constraint
functional.gtcs.test_dsql_domain_04  Test the level 0 syntax for SQL "CREATE DOMAIN" statement using datatype and CHECK constraint clause
functional.gtcs.test_dsql_domain_06  Test the level 0 syntax for SQL "CREATE DOMAIN" statement using datatype and CHECK constraint clause.
functional.gtcs.test_dsql_domain_07  Test CREATE / ALTER domain statement with ADD/DROP CONSTRAINT clauses, together and separately.
functional.gtcs.test_dsql_domain_12  Verify result of INSERT DEFAULT VALUES into a table with domain fields when domains are defined with DEFAULT value.
functional.gtcs.test_dsql_domain_13  Verify result of INSERT DEFAULT for domain-based fields which have their own default values
functional.gtcs.test_dsql_domain_15  Verify result of INSERT DEFAULT for domain-based fields which are declared as NOT NULL and have their own default values
functional.gtcs.test_dsql_domain_20  Verify result of ALTER DOMAIN SET/DROP DEFAULT when a table exists with field based on this domain
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_dsql_domain_22  Verify result of ALTER DOMAIN with changing NOT NULL flag and CHECK constraints when a table exists with field based on this domain
functional.gtcs.test_execute_statement_within_procedure  EXECUTE STATEMENT within a stored procedure could lead to a problems
functional.gtcs.test_external_file_03_d  Test for external table with field of SMALLINT datatype
functional.gtcs.test_external_file_04_d  est for external table with field of INTEGER datatype
functional.gtcs.test_external_file_04_d_bigint  Test for external table with field of BIGINT datatype
functional.gtcs.test_external_file_04_d_int128  Test for external table with field of INT128 datatype
functional.gtcs.test_external_file_06_d  Test for external table with field of DOUBLE PRECISION datatype
functional.gtcs.test_external_file_09_d  Test for external table with field of DATE datatype
functional.gtcs.test_gtcs_proc_isql_01  gtcs-proc-isql-01
functional.gtcs.test_gtcs_proc_isql_02  gtcs-proc-isql-02
functional.gtcs.test_gtcs_proc_isql_03  gtcs-proc-isql-03
functional.gtcs.test_gtcs_proc_isql_04  gtcs-proc-isql-04
functional.gtcs.test_gtcs_proc_isql_05  gtcs-proc-isql-05
functional.gtcs.test_gtcs_proc_isql_06  gtcs-proc-isql-06
functional.gtcs.test_gtcs_proc_isql_07  gtcs-proc-isql-07
functional.gtcs.test_gtcs_proc_isql_08  gtcs-proc-isql-08
functional.gtcs.test_gtcs_proc_isql_10  gtcs-proc-isql-10
functional.gtcs.test_gtcs_proc_isql_11  gtcs-proc-isql-11
functional.gtcs.test_gtcs_proc_isql_12  gtcs-proc-isql-12
functional.gtcs.test_gtcs_proc_isql_13  gtcs-proc-isql-13
functional.gtcs.test_gtcs_proc_isql_15  gtcs-proc-isql-15
functional.gtcs.test_gtcs_proc_isql_16  gtcs-proc-isql-16
functional.gtcs.test_gtcs_proc_isql_17  gtcs-proc-isql-17
functional.gtcs.test_gtcs_proc_isql_18  gtcs-proc-isql-18
functional.gtcs.test_gtcs_proc_isql_19  gtcs-proc-isql-19
functional.gtcs.test_gtcs_proc_isql_20  gtcs-proc-isql-20
functional.gtcs.test_gtcs_select_delete_isql  Test for select from SP that deletes record after its output
functional.gtcs.test_invalid_stream_when_use_trim  Statement with TRIM raises "bad BLR -- invalid stream"
functional.gtcs.test_isql_one_line_comments_01  bug #781610 problems with one line comments (--)
functional.gtcs.test_isql_show_command_ambiguity  SHOW TABLE / VIEW: ambiguity between tables and views
functional.gtcs.test_minimum_grant_test  Minimum grant test
functional.gtcs.test_misplaced_collation_in_extracted_metadata  Misplaced collation when extracting metadata with isql
functional.gtcs.test_parser_comments_in_sql  Check for problems with comments (single-line and multi-line)
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_fk_then_pk  Outcome must be SUCCESS if first we drop FK and after this PK constraint
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_regexp_similar_to  Statements with SIMILAR TO - miscelaneous tests.
functional.gtcs.test_regexp_substring_similar_to  SUBSTRING - miscelaneous tests of <str> SIMILAR TO <pattern>
functional.gtcs.test_sql_join_03  Ability to run query: ( A LEFT JOIN B ) INER JOIN C, plus ORDER BY with fields not from SELECT list
functional.gtcs.test_sql_join_04  Ability to run query: ( A LEFT JOIN B ) , C. Then add ORDER BY with fields not from SELECT list
functional.gtcs.test_time_zone  Miscelaneous time zone tests
functional.gtcs.test_transactions_autocommit_1  AUTO COMMIT must preserve changes that were made by all DML even if ROLLBACK is issued
functional.gtcs.test_transactions_autocommit_2  Changes within AUTO COMMIT must be cancelled when exception raises in some TRIGGER
functional.gtcs.test_transactions_autocommit_3  Changes within AUTO COMMIT must be cancelled when exception raises in some PROCEDURE
functional.gtcs.test_trigger_variable_assignment  Variable in the AFTER-trigger must be allowed for assignment OLD value in it
functional.gtcs.test_window_func_01  Set of miscelaneous tests for verification of windowed functions
functional.gtcs.test_window_func_02  Set of miscelaneous tests for verification of windowed functions
functional.gtcs.test_window_func_03  Set of miscelaneous tests for verification of windowed functions
functional.gtcs.test_window_func_04  Set of miscelaneous tests for verification of windowed functions
functional.gtcs.test_window_func_05  Set of miscelaneous tests for verification of windowed functions
functional.index.alter.test_01  ALTER INDEX - INACTIVE
functional.index.alter.test_02  ALTER INDEX
functional.index.alter.test_03  ALTER INDEX - INACTIVE UNIQUE INDEX
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.index.create.test_12  CREATE UNIQUE INDEX - Null value in table
functional.intfunc.avg.test_01  AVG from single integer row
functional.intfunc.avg.test_02  AVG - Test for INTEGER
functional.intfunc.avg.test_03  AVG - Test for INTEGER
functional.intfunc.avg.test_04  AVG - Test for INTEGER
functional.intfunc.avg.test_05  AVG - DISTINCT
functional.intfunc.avg.test_06  AVG - Integer OverFlow
functional.intfunc.avg.test_07  AVG - Integer with NULL
functional.intfunc.avg.test_08  AVG - NULL test
functional.intfunc.avg.test_09  AVG - DOUBLE PRECISION
functional.intfunc.binary.test_and_01  New Built-in Functions, Firebird 2.1 : BIN_AND( <number> [, <number> ...] )
functional.intfunc.binary.test_or_01  New Built-in Functions, Firebird 2.1 : BIN_OR( <number> [, <number> ...] )
functional.intfunc.binary.test_shl_01  New Built-in Functions, Firebird 2.1 : BIN_SHL( <number>, <number> )
functional.intfunc.binary.test_shr_01  New Built-in Functions, Firebird 2.1 : BIN_SHR( <number>, <number> )
functional.intfunc.binary.test_xor_01  New Built-in Functions, Firebird 2.1 : BIN_XOR( <number> [, <number> ...] )
functional.intfunc.cast.test_01  CAST Numeric -> CHAR
functional.intfunc.cast.test_02  CAST Numeric -> VARCHAR
functional.intfunc.cast.test_03  CAST Numeric -> DATE
functional.intfunc.cast.test_04  CAST Numeric -> Numeric (Round down)
functional.intfunc.cast.test_05  CAST Numeric -> Numeric (Round up)
functional.intfunc.cast.test_06  CAST CHAR -> INTEGER (Round down)
functional.intfunc.cast.test_07  CAST CHAR -> INTEGER
functional.intfunc.cast.test_08  CAST CHAR -> DATE
functional.intfunc.cast.test_09  CAST CHAR -> DATE
functional.intfunc.cast.test_10  CAST CHAR -> TIME
functional.intfunc.cast.test_11  CAST CHAR -> TIME
functional.intfunc.cast.test_12  CAST CHAR -> TIME
functional.intfunc.cast.test_13  CAST CHAR -> TIMESTAM
functional.intfunc.cast.test_14  CAST CHAR -> TIMESTAMP
functional.intfunc.cast.test_15  CAST DATE -> CHAR
functional.intfunc.cast.test_16  CAST DATE -> VARCHAR
functional.intfunc.cast.test_17  CAST DATE -> TIMESTAMP
functional.intfunc.cast.test_18  CAST TIME -> CHAR
functional.intfunc.cast.test_19  CAST TIME -> VARCHAR
functional.intfunc.cast.test_20  CAST TIMESTAMP -> CHAR
functional.intfunc.cast.test_21  CAST TIMESTAMP -> VARCHAR
functional.intfunc.cast.test_22  CAST TIMESTAMP -> DATE
functional.intfunc.cast.test_23  CAST TIMESTAMP -> TIME
functional.intfunc.count.test_01  COUNT - Select from empty table
functional.intfunc.count.test_02  COUNT
functional.intfunc.date.test_dateadd_01  DATEADD
functional.intfunc.date.test_dateadd_02  DATEADD function for MONTH
functional.intfunc.date.test_dateadd_03  DATEADD
functional.intfunc.date.test_dateadd_04  DATEADD
functional.intfunc.date.test_dateadd_05  DATEADD
functional.intfunc.date.test_dateadd_06  DATEADD
functional.intfunc.date.test_dateadd_07  DATEADD
functional.intfunc.date.test_dateadd_08  Dateadd milliseconds
functional.intfunc.date.test_datediff_01  DATEDIFF
functional.intfunc.date.test_datediff_02  DATEDIFF
functional.intfunc.date.test_datediff_03  DATEDIFF
functional.intfunc.date.test_datediff_04  DATEDIFF
functional.intfunc.date.test_datediff_05  DATEDIFF
functional.intfunc.date.test_datediff_06  DATEDIFF
functional.intfunc.date.test_datediff_07  DATEDIFF
functional.intfunc.date.test_extract_01  EXTRACT(WEEK FROM DATE)
functional.intfunc.date.test_extract_02  EXTRACT - MILLISECONDS
functional.intfunc.encryption.test_block_cipher_basic  ENCRYPT/DECRYPT built-in functions
functional.intfunc.encryption.test_block_cipher_special  ENCRYPT/DECRYPT built-in functions
functional.intfunc.encryption.test_rsa_family  Basic test for RSA-family: rsa_private(), rsa_public(), rsa_encrypt(), rsa_decrypt(), rsa_sign_hash() and rsa_verify_hash()
functional.intfunc.encryption.test_rsa_family_pkcs_1_5  RSA-family function, attitional test: verify ability to use PKCS_1_5 keyword
functional.intfunc.encryption.test_sha3  SHA3 support for the built-in function CRYPT_HASH()
functional.intfunc.list.test_01  List with default options
functional.intfunc.list.test_02  List function with delimiter specified
functional.intfunc.list.test_03  List function with distinct option
functional.intfunc.math.test_abs_01  ABS( <number> )
functional.intfunc.math.test_acos_01  ACOS( <number> )
functional.intfunc.math.test_asin_01  ASIN( <number> )
functional.intfunc.math.test_atan2_01  ATAN2( <number>, <number> )
functional.intfunc.math.test_atan_01  ATAN( <number> )
functional.intfunc.math.test_ceil_01  CEIL( <number>)
functional.intfunc.math.test_cos_01  COS( <number>)
functional.intfunc.math.test_cosh_01  COSH( <number>)
functional.intfunc.math.test_cot_01  COT( <number> )
functional.intfunc.math.test_exp_01  EXP( <number> )
functional.intfunc.math.test_floor_01  FLOOR( <number> )
functional.intfunc.math.test_ln_01  LN( <number> )
functional.intfunc.math.test_log10_01  LOG10( <number> )
functional.intfunc.math.test_log_01  LOG( <number>, <number> )
functional.intfunc.math.test_maxvalue_01  MAXVALUE( <value> [, <value> ...] )
functional.intfunc.math.test_minvalue_01  MINVALUE( <value> [, <value> ... )
functional.intfunc.math.test_mod_01  MOD( <number>, <number> )
functional.intfunc.math.test_pi_01  PI()
functional.intfunc.math.test_power_01  POWER( <number>, <number> )
functional.intfunc.math.test_rand_01  RAND()
functional.intfunc.math.test_round_01  ROUND( <number>, <number> )
functional.intfunc.math.test_sign_01  SIGN( <number> )
functional.intfunc.math.test_sin_01  SIN( <number> )
functional.intfunc.math.test_sinh_01  SINH( <number> )
functional.intfunc.math.test_sqrt_01  SQRT( <number> )
functional.intfunc.math.test_tan_01  TAN( <number> )
functional.intfunc.math.test_tanh_01  TANH( <number> )
functional.intfunc.math.test_trunc_01  TRUNC( <number> [, <number> ] )
functional.intfunc.misc.test_decode_01  DECODE()
functional.intfunc.misc.test_gen_uuid_01  GEN_UUID()
functional.intfunc.misc.test_hash_01  HASH( <value> )
functional.intfunc.string.test_ascii_01  ASCII_CHAR( <number> )
functional.intfunc.string.test_ascii_val_01  ASCII_VAL( <string> )
functional.intfunc.string.test_left_01  LEFT function
functional.intfunc.string.test_lpad_01  LPAD function, including non-ascii characters
functional.intfunc.string.test_overlay_01  OVERLAY function
functional.intfunc.string.test_position_01  POSITION( <string> IN <string> )
functional.intfunc.string.test_replace_01  REPLACE( <stringtosearch>, <findstring>, <replstring> )
functional.intfunc.string.test_reverse_01  REVERSE( <value> )
functional.intfunc.string.test_right_01  RIGHT( <string>, <number> )
functional.intfunc.string.test_rpad_01  RPAD function, including non-ascii characters
functional.intfunc.string.test_trunc_01  Test for TRUNC function
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_01  Get isolation level of the current transaction
functional.monitoring.test_02  Get data about active statements from current attachment (WHERE-filter: mon$statements.mon$state=1).
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.monitoring.test_04  SYSDBA must see all attachments and their transactions, non-privileged user - only those which was of his login.
functional.procedure.alter.test_01  ALTER PROCEDURE - Simple ALTER
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.procedure.create.test_08  CREATE PROCEDURE - COMMIT in SP is not alowed
functional.procedure.create.test_16  Type Flag for Stored Procedures
functional.replication.test_blob_access_when_no_grant_for_select  Replicator must have access to the table with blob regardless SELECT grant on this table to the user who created blob.
functional.replication.test_grantor_not_changes_in_replica_if_owner_not_sysdba  DDL-Changes in replication does not set the correct grantor
functional.replication.test_permission_error_on_ddl_issued_by_non_sysdba  Permission error with replication
functional.role.create.test_01  CREATE ROLE
functional.role.create.test_02  CREATE ROLE - try create role with same name
functional.services.test_role_in_service_attachment  Check that trace plugin shows ROLE used in service attachment. Format: USER[:ROLE]
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.session.test_alter_session_reset_allow_2pc_prepared  ALTER SESSION RESET: do NOT raise error if prepared 2PC transactions present
functional.session.test_alter_session_reset_clear_gtt  ALTER SESSION RESET: clear contents of all used GTT ON COMMIT PRESERVE ROWS
functional.session.test_alter_session_reset_clear_timeouts  ALTER SESSION RESET: reset session and statement timeouts to zero
functional.session.test_alter_session_reset_decfloat  ALTER SESSION RESET: DECFLOAT parameters must be returned to default values
functional.session.test_alter_session_reset_raise_if_open_tx  ALTER SESSION RESET: throw error (isc_ses_reset_err) if any open transaction exist in current connection
functional.session.test_alter_session_reset_remove_context_vars  ALTER SESSION RESET: remove all context variables in 'USER_SESSION' namespace
functional.session.test_alter_session_reset_restore_role  ALTER SESSION RESET: restore ROLE which was passed with DPB and clear all cached security classes (if role was changed)
functional.session.test_alter_session_reset_rollback  ALTER SESSION RESET: ROLLBACK current user transaction (if present) and issue warning if that transaction changes any table before reset
functional.session.test_alter_session_reset_start_new_tx  ALTER SESSION RESET: START new transaction with the same properties as transaction that was rolled back (if transaction was present before reset)
functional.session.test_ext_conn_pool_01  External Connections Pool, functionality test 01
functional.shadow.test_create_01  CREATE SHADOW: check basic usage
functional.shadow.test_create_02  CREATE SHADOW: check usage with presense of 'FILE <...>' clause.
functional.syspriv.test_access_any_object  Check ability to query, modify and deleting data plus add/drop constraints on any table
functional.syspriv.test_access_shutdown_database  Check ability to access to database in shutdown single mode as non-sysdba
functional.syspriv.test_change_header_settings  Check ability to change some database header attributes by non-sysdba user who is granted with necessary system privileges
functional.syspriv.test_change_mapping_rules  Check ability to manage auth mappings
functional.syspriv.test_change_shutdown_mode  Check ability to change database shutdown mode by non-sysdba user who is granted with necessary system privileges
functional.syspriv.test_create_database  Check ability to CREATE database by non-sysdba user who is granted with necessary system privilege
functional.syspriv.test_create_privileged_roles  Check ability of non-sysdba user to CREATE privileged role (but NOT use it)
functional.syspriv.test_create_user_types  Check ability to update content of RDB$TYPES
functional.syspriv.test_drop_database  Check ability to DROP database by non-sysdba user who is granted with necessary system privileges
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_ignore_db_triggers  Check ability of non-sysdba and non-owner to ignore DB triggers
functional.syspriv.test_modify_ext_conn_pool  Check ability to manage external connections pool
functional.syspriv.test_monitor_any_attachment  Check ability to monitor any attachment
functional.syspriv.test_read_raw_pages  Check ability to get binary content of DB page by non-sysdba user who is granted with necessary system privilege
functional.syspriv.test_trace_any_attachment  Check ability to trace any attachment by non-sysdba user who is granted with necessary system privileges
functional.syspriv.test_use_gbak_utility  Check ability to to make database backup
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_use_gstat_utility  Check ability to obtain database statistics
functional.syspriv.test_use_nbackup_utility  Check ability to use nbackup
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_01  ALTER TABLE - ADD column
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_07  ALTER TABLE. Alter position of columns.
functional.table.alter.test_08  ALTER TABLE - DROP
functional.table.alter.test_09  ALTER TABLE - DROP (with data)
functional.table.alter.test_10  ALTER TABLE - DROP CONSTRAINT - PRIMARY KEY
functional.table.alter.test_11  ALTER TABLE - DROP CONSTRAINT - UNIQUE
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_01  CREATE TABLE - types
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.core_3611_aux_test  Wrong data while retrieving from CTEs (or derived tables) with same column names
functional.tabloid.test_3123a5a0  Check ability to reuse internal connection by EXECUTE STATEMENT.
functional.tabloid.test_333be4bf  Change error by warning in the case when isc_dpb_parallel_workers value is not at valid range
functional.tabloid.test_3b372197  built-in functions UNICODE_CHAR and UNICODE_VAL
functional.tabloid.test_657d86fe  RemoteAuxPort is per-database
functional.tabloid.test_6cfc9b5d  Scrollable cursors. Automated test with randomly generated mission for positioning.
functional.tabloid.test_80fd0682  Fixed bug with index names patterns in online validation service
functional.tabloid.test_8816d5c8  Fixed crash when IN predicate is delivered into aggregates/unions
functional.tabloid.test_90129c6d  Scrollable cursors. Fixed isBof/isEof when the prefetch is active
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_arithmetic_cast_float_to_int_as_round  Result of CAST for numbers is implementation defined
functional.tabloid.test_arithmetic_numexpr_eval_dialect_1  Check result of integer division on dialect 1.
functional.tabloid.test_arithmetic_numexpr_eval_dialect_3  Check result of integer division on dialect 3.
functional.tabloid.test_bus_3103_windowed_funcs  Query for test MAX()OVER().
functional.tabloid.test_c8849946  Scrollable cursors. Inconsistent cursor repositioning
functional.tabloid.test_comment_in_object_names  All DB objects types must allow name COMMENT. Also, COMMENT ON ... must allow occurence of "comment" in it.
functional.tabloid.test_crash_when_too_long_username_for_auth  crash on assert or memory corruption when too long username is used for authentication
functional.tabloid.test_dbp_0951_multiple_nested_cte  Query for test multiple CTEs
functional.tabloid.test_dbp_1697_windowed_funcs  Query for test SUM()OVER() and COUNT()OVER().
functional.tabloid.test_dbp_1940_20040130_1740  Common SQL. Check correctness of the results
functional.tabloid.test_dbp_1940_20061108_2141  Common SQL. Check correctness of the results
functional.tabloid.test_dbp_1940_20080912_1005  Common SQL. Check correctness of the results
functional.tabloid.test_dbp_1940_20090521_1520  Common SQL. Check correctness of the results
functional.tabloid.test_dbp_1940_20110426_1906  Common SQL. Check correctness of the results
functional.tabloid.test_dbp_1940_20110725_1159  Common SQL. Check correctness of the results
functional.tabloid.test_dbp_1940_20130412_1008  Common SQL. Check correctness of the results
functional.tabloid.test_dbp_1940_20130831_2039  Common SQL. Check correctness of the results
functional.tabloid.test_dbp_1940_20130912_1908  Common SQL. Check correctness of the results
functional.tabloid.test_dbp_2146_distinct_not_in  Common SQL. Check correctness of the results
functional.tabloid.test_dbp_4137_combo_full_join_and_windowed_funcs  Common SQL. Check correctness of the results
functional.tabloid.test_dbp_4391_combo_full_join_and_windowed_funcs  Common SQL. Check correctness of the results
functional.tabloid.test_dbp_4391_combo_full_join_and_windowed_funcs2  Common SQL. Check correctness of the results
functional.tabloid.test_dbp_5125_windowed_funcs  Common SQL. Check correctness of the results
functional.tabloid.test_dbp_7029_heavy_test_for_windowed_funcs  Common SQL. Check correctness of the results
functional.tabloid.test_dbp_7114_windowed_funcs  Common SQL. Check correctness of the results
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_dsqlrequests  DROP TABLE fails if executing in ES and DML at the same execute block is performed in autonomous transaction
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_141347  Check correctness of LEFT JOIN result when right source has two FK and one of fields from FK present both in ON and WHERE clauses.
functional.tabloid.test_eqc_160757  Check correctness of LEFT JOIN result when left source is table with several -vs- single rows and right source is SP.
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_eqc_200762  Check results of CONTAINING when search pattern can span on one or several blob segments
functional.tabloid.test_eqc_306263  Check ability to run complex query
functional.tabloid.test_eqc_343715  Checking PK index is used when table is joined as driven (right) source in LEFT OUTER join from VIEW
functional.tabloid.test_eqc_344124  Check ability to run selectable SP with input parameter which inserts into GTT (on commit DELETE rows) and then does suspend
functional.tabloid.test_fd0fa8a3  Let include file name into error message when creation of temp file failed.
functional.tabloid.test_full_join_push_where_predicate  WHERE-filter must be applied after FULL JOIN result
functional.tabloid.test_gtcs_proc_isql_14  gtcs-proc-isql-14
functional.tabloid.test_join_on_position_function_result  Records with NULLs could be lost from resultset.
functional.tabloid.test_join_transformation_001  Check ability of outer join simplification.
functional.tabloid.test_join_transformation_002  Check ability of outer join simplification.
functional.tabloid.test_join_transformation_003  Check ability of outer join simplification.
functional.tabloid.test_join_transformation_004  Check ability of outer join simplification.
functional.tabloid.test_join_transformation_005  Check ability of outer join simplification.
functional.tabloid.test_join_transformation_006  Check ability of outer join simplification.
functional.tabloid.test_join_transformation_007  Check ability of outer join simplification.
functional.tabloid.test_join_transformation_008  Check ability of outer join simplification.
functional.tabloid.test_loose_record_when_relief_where_expr  Uncomment of one part of OR'ed expression led to loose of record from resultset.
functional.tabloid.test_no_dups_in_call_stack  Avoid info duplication when statements in call stack attached to different transactions (for example: monitoring snapshot is created in autonomous transaction)
functional.tabloid.test_oltp_emul_30_compiler_check  Compiler check. Test ability to compile source code of OLTP-EMUL test.
functional.tabloid.test_optimizer_index_navigation  Check that optimizer takes in account presense of index and does navigation instead of external sort.
functional.tabloid.test_ora_4475843  Wrong (empty) result of query in Oracle 19
functional.tabloid.test_pg_13918  Some _TRIVIAL_ queries allow to specify HAVING without group by, and for such case one may to get record from EMPTY source rowset(!)
functional.tabloid.test_pg_14105  Check ability to compile query with combination of full and right join. Taken from PG bug library.
functional.tabloid.test_pg_14421  UPDATE/DETERE RETURNING should issue only one row when applying to table with self-referencing FK
functional.tabloid.test_request_of_expr_index  request of expression index could run outside of main request's snapshot.
functional.tabloid.test_snd_7795_20120706_1249  Common SQL. Check correctness of the results
functional.transactions.test_read_consist_statement_delete_undone_01  READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-01
functional.transactions.test_read_consist_statement_delete_undone_02  READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-02
functional.transactions.test_read_consist_sttm_merge_deny_multiple_matches  READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart.
functional.transactions.test_read_consist_sttm_restart_max_limit  READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
functional.transactions.test_read_consist_sttm_restart_on_delete_01  READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-01.
functional.transactions.test_read_consist_sttm_restart_on_delete_02  READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-02.
functional.transactions.test_read_consist_sttm_restart_on_delete_03  READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-03.
functional.transactions.test_read_consist_sttm_restart_on_delete_04  READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04.
functional.transactions.test_read_consist_sttm_restart_on_merge_01  READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-01.
functional.transactions.test_read_consist_sttm_restart_on_merge_02  READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-02.
functional.transactions.test_read_consist_sttm_restart_on_merge_03  READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-03.
functional.transactions.test_read_consist_sttm_restart_on_merge_04  READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.
functional.transactions.test_read_consist_sttm_restart_on_update_01  READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01.
functional.transactions.test_read_consist_sttm_restart_on_update_02  READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02.
functional.transactions.test_read_consist_sttm_restart_on_update_03  READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-03.
functional.transactions.test_read_consist_sttm_restart_on_update_04  READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04.
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_09  ALTER TRIGGER - POSITION
functional.trigger.alter.test_10  ALTER TRIGGER - AS
functional.trigger.alter.test_11  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_01  Trigger on database connect. See also CORE-745
functional.trigger.database.test_connect_02  Error handling in trigger on database connect
functional.trigger.database.test_connect_03  Multiple triggers 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_disconnect_02  ON DISCONNECT trigger must fire during database shutdown (gfix -shut full -force 0).
functional.trigger.database.test_disconnect_03  ON DISCONNECT trigger must fire if attachment is deleted from MON$ATTACHMENTS by another attachment.
functional.trigger.database.test_disconnect_04  ON DISCONNECT trigger must fire if attachment is closed by IDLE timeout.
functional.trigger.database.test_disconnect_05  ON DISCONNECT trigger and OnDisconnectTriggerTimeout expiration
functional.trigger.database.test_disconnect_06  ON DISCONNECT trigger: print exceptions (including cancelling) to trace if log_errors = true
functional.trigger.database.test_transaction_start_multiple_with_normal_finish  Multiple triggers on start transaction
functional.trigger.database.test_transactioncommit_01  Trigger on commit transaction. See also CORE-645
functional.trigger.database.test_transactionrollback_01  Trigger on rollback transaction
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_09  ALTER TRIGGER - POSITION
functional.trigger.table.test_alter_10  ALTER TRIGGER - AS
functional.trigger.table.test_alter_11  ALTER TRIGGER - AS
functional.trigger.table.test_alter_12  ALTER TRIGGER - AS
functional.trigger.table.test_alter_13  ALTER TRIGGER - AS
functional.util.test_gbak_zip  gbak utility: check ability to use -ZIP command switch when create backup
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_05  CREATE VIEW
functional.view.create.test_06  CREATE VIEW - updateable
functional.view.create.test_07  CREATE VIEW - updateable WITH CHECK OPTION
functional.view.create.test_08  CREATE VIEW - updateable WITH CHECK OPTION

This list is the same for:
5.0.3.1649 2025.04.21 5b2d0dcc  SS
5.0.3.1650 2025.04.28 4cbff060  SS
5.0.3.1650 2025.04.30 6253fe18  SS
5.0.3.1651 2025.04.30 141ef4cc  SS
5.0.3.1651 2025.05.04 3d914a81  SS
5.0.3.1651 2025.05.08 ee9d24e1  SS