Problematic tests list (207 rows):
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.sqlancer.arch_2312_17510_example_02_test  Bug in RIGHT JOIN
functional.sqlancer.doi_10_1145_3428279_example_01_test  predicate 0 = -0 to incorrectly evaluate to FALSE.
functional.sqlancer.doi_10_1145_3428279_example_02_test  Wrong result of UNION DISTINCT
functional.sqlancer.doi_10_1145_3428279_example_04_test  Wrong result of AVG evaluation as result of SUM / COUNT
functional.sqlancer.doi_10_1145_3428279_example_06_test  Failed to fetch a row from a view.
functional.sqlancer.doi_10_1145_3428279_example_09_test  GROUP BY ignores COLLATE with case insensitive attribute
functional.sqlancer.doi_10_1145_3428279_example_10_test  Unnexpectedly optimized VARIANCE(0) to FALSE
functional.sqlancer.doi_10_1145_3428279_example_11_test  Non-deterministic output when using MAX() function
functional.sqlancer.doi_10_1145_3428279_example_17_test  Conversion of character string to boolean value
functional.sqlancer.doi_10_1145_3428279_example_18_test  Comparison of string and numeric literals
functional.sqlancer.osdi20_rigger_example_05_test  Incorrect result of LIKE.
functional.sqlancer.osdi20_rigger_example_12_test  Unexpected null value when index is used
functional.sqlancer.stonedb_misc_examples_test  Bugs Found in StoneDB by SQLancer
functional.sqlancer.tidb_15844_test  NATURAL RIGHT JOIN results in an unexpected "Unknown column" error
functional.sqlancer.tidb_16028_test  Incorrect result when comparing a FLOAT/DOUBLE UNSIGNED with a negative number
functional.sqlancer.tidb_35522_test  incorrect unresolved column when using natural join
functional.sqlancer.tidb_challenge_19_test  Incorrect result for LEFT JOIN and CASE operator
functional.sqlancer.tidb_challenge_48_test  UNIQUE constraint on DECIMAL/floating-point columns causes incorrect result for NULL in AND
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_657d86fe  RemoteAuxPort is per-database
functional.tabloid.test_80fd0682  Fixed bug with index names patterns in online validation service
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_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_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_ibp_124  WHERE CURRENT OF <C> within block that has savepoint: statement #2 must see changes produced by statement #1
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_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:
4.0.6.3215 2025.06.25 6461d039  SS