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 |