| bugs.core_0521_test | Permissions are checked case-insensitively |
| bugs.core_0696_test | User Account maintanance in SQL |
| bugs.core_0805_test | Privileges of dynamic statements in SP |
| bugs.core_0856_test | Unable to set FName, MName, LName fields in security to blank |
| bugs.core_0927_test | Grants don't work for procedures used inside views |
| bugs.core_1810_test | Usernames with '.' character |
| bugs.core_2022_test | "EXECUTE BLOCK" statement does not support "CREATE USER" |
| bugs.core_2729_test | Current connection may be used by EXECUTE STATEMENT instead of creation of new attachment |
| bugs.core_2861_test | Cannot remove user with dot in login |
| bugs.core_2929_test | "Invalid ESCAPE sequence" when connecting to the database |
| bugs.core_3100_test | Wait mode and lock timeout of external transaction of EXECUTE STATEMENT not matched to corresponding parameters of local transaction |
| bugs.core_3242_test | Recursive stored procedure shouldnt require execute right to call itself |
| bugs.core_3690_dialect_3_test | Wrong warning message for ambiguous query |
| bugs.core_3732_test | Segfault when closing attachment to database |
| bugs.core_3799_test | with caller privileges option do not work with autonomous transaction option |
| bugs.core_4054_test | role not passed on external execute stmt |
| bugs.core_4607_test | Add support for having more than one UserManager in firebird.conf and use them from SQL |
| bugs.core_4719_test | Message "Statement failed, SQLSTATE = 00000 + unknown ISC error 0" appears when issuing REVOKE ALL ON ALL FROM <existing_user> |
| bugs.core_4766_test | AV when trying to manage users list using EXECUTE STATEMENT on behalf of non-sysdba user which has RDB$ADMIN role |
| bugs.core_4831_test | Revoke all on all from role <R> -- failed with "SQL role <R> does not exist in security database" |
| bugs.core_4841_test | Make message about missing password being always displayed as reply on attempt to issue CREATE new login without PASSWORD clause |
| bugs.core_5060_test | Cannot CREATE VIEW that selects from a system table, despite having all grants |
| bugs.core_5082_test | Server does not validate correctness of user/password pair provided in EXECUTE STATEMENT operator |
| bugs.core_5155_test | [CREATE OR] ALTER USER statement: clause PASSWORD (if present) must be always specified just after USER |
| bugs.core_5162_test | SEC$ tables and tag/attributes |
| bugs.core_5275_test | Expression index may become inconsistent if CREATE INDEX was interrupted after b-tree creation but before commiting |
| bugs.core_5475_test | Provide ability to filter out info and warnings from trace log |
| bugs.core_5481_test | Available indices are not used in some cases if ORDER BY expression is a filtered one |
| bugs.core_5488_session_idle_test | Timeouts for running SQL statements and idle connections |
| bugs.core_5593_test | System function RDB$ROLE_IN_USE cannot take long role names |
| bugs.core_5747_test | User can grant usage privilege by himself |
| bugs.core_5754_test | ALTER TRIGGER check privilege for alter database instead of table |
| bugs.core_5756_addi_test | Regression: FB crashes when trying to recreate table that is in use by DML (3.0.3; 3.0.4; 4.0.0) |
| bugs.core_5770_test | User who is allowed to manage other users must have this ability WITHOUT need to grant him RDB$ADMIN role |
| bugs.core_5804_test | Multiple error in REVOKE operator |
| bugs.core_5840_test | Ignor of reference privilege |
| bugs.core_5841_test | No permission for SELECT access to BLOB field if a TABLE is accessed using VIEW |
| bugs.core_5852_test | There is no check of existance generator and exception when privileges are granted |
| bugs.core_5858_test | Command 'REVOKE ALL ON ALL FROM <anyname>' lead server to crash |
| bugs.core_5904_test | An attempt to create global mapping with long (greater than SQL identifier length) FROM field fails |
| bugs.core_5921_test | Provide information about Global Commit Number, Commit Number of currently used database snapshot (if any) and Commit Numbers assigned to the committed transactions |
| bugs.core_6095_test | Extend trace record for COMMIT/ROLLBACK RETAINING to allow chaining of transaction ids |
| bugs.core_6317_test | Server is crashing on long GRANT statement |
| bugs.core_6329_test | GBAK with service_mgr and WinSSPI authentication for Windows SYSTEM user producing error in clumplet API |
| bugs.gh_6732_test | Stored procedure isn't able to execute statement 'GRANT' |
| bugs.gh_6802_test | When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired |
| bugs.gh_6825_test | Correct error message for DROP VIEW |
| bugs.gh_6866_test | Some orphan records left at RDB$SECURITY_CLASSES and RDB$USER_PRIVILEGES after DROP PROCEDURE\FUNCTION |
| bugs.gh_6889_test | error no permision occurred while ALTER USER SET TAGS on snapshot build WI-V3.0.8.33482 |
| bugs.gh_6934_test | SQL SECURITY DEFINER does not affect the ownership of created DDL objects |
| bugs.gh_6935_test | SQL SECURITY DEFINER has inconsistent behaviour if the object owner is non-privileged |
| bugs.gh_6963_test | grant references not working |
| bugs.gh_6998_test | Problems with access to RDB$CONFIG table for non-privileged user when he has grant on execution of SP which has necessary access rights (created by SYSDBA with SQL DEFINER clause) |
| bugs.gh_7050_test | Add table MON$COMPILED_STATEMENTS and columns |
| bugs.gh_7398_test | Worst plan sort created to execute an indexed tables |
| bugs.gh_7426_test | Ensure the DDL trigger requests are cached |
| bugs.gh_7466_plans_tracking_test | Add COMPILE trace events - ability to see execution plan of every PSQL statement. |
| bugs.gh_7466_test | Add COMPILE trace events for procedures/functions/triggers |
| bugs.gh_7804_test | The partial index is not involved when filtering conditions through OR. |
| bugs.gh_7904_test | More realistic cardinality adjustments for unmatchable booleans // FB5 bad plan for query |
| bugs.gh_8077_test | Error "Too many recursion levels" does not stop execuition of code that uses ON DISCONNECT trigger (FB 4.x+) |
| bugs.gh_8161_test | Cardinality estimation should use primary record versions only |
| 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_8851_test | 'Internal error' when calling outer procedure after deleting unused result variable from inner procedure |
| functional.arno.optimizer.test_opt_inner_join_05 | INNER JOIN join order LIKE and STARTING WITH |
| functional.gtcs.test_returning_01 | Test of RETURNING clause: INSERT, UPDATE, MERGE. |
| functional.metacache.test_95996928 | Avoid infinite wait due to non-optimum plan & use of read committed no record version transaction for DML by ISQL |
| functional.replication.test_blob_characters_garbled_when_conn_charset_differs | Characters are garbled when replicating fields with type BLOB SUB_TYPE TEXT if the character set of the connection and the field are different |
| functional.replication.test_blob_not_found_in_rw_replica_if_target_row_exists | Error "BLOB is not found" while replication converts INSERT into UPDATE for a conflicting record |
| functional.replication.test_blob_segments_longer_32kb_are_not_replicated | Problem with replication of BLOB segments longer than 32KB |
| functional.replication.test_dblevel_triggers_must_not_fire_on_replica | Replica DB must not fire DB-level triggers but their activity on master must be eventually seen in replica |
| functional.replication.test_ddl_triggers_must_not_fire_on_replica | DDL-triggers must fire only on master DB |
| functional.replication.test_disallow_rdb_backup_history_replication | Disallow replication of RDB$BACKUP_HISTORY |
| functional.replication.test_duplicated_segment_numbers | Replicator could produce log segments with duplicated segment numbers |
| functional.replication.test_duplicates_in_rw_replica_after_conflicting_insert | Conflicting INSERT propagated into a read-write replica may cause duplicate records to appear |
| functional.replication.test_failed_ddl_commands_can_be_replicated | Failed DDL commands can be replicated |
| functional.replication.test_generator_could_not_be_transferred_to_replica | Generator values may not replicate after commit |
| functional.replication.test_invalid_msg_if_target_db_has_no_replica_flag | Invalid message in replication.log (and possibly crash in the case of synchronous replication) when the target DB has no its "replica" flag set |
| functional.replication.test_make_async_reinit_reliable | Make asynchronous replica re-initialization reliable #8324 |
| functional.replication.test_shutdown_during_applying_segments_leads_to_crash | Crash or hang while shutting down the replica database if segments are being applied |
| functional.replication.test_some_updates_crash_server_on_replica_side | Some updates can crash Firebird server on replica side |
| functional.replication.test_sync_replica_allow_spaces_in_username_or_password | Leading, trailing or inner space character specified in 'sync_replica' must not cause error |
| functional.replication.test_uk_violation_in_rw_repl_if_constraint_name_is_used | PK/UK violation error raises in RW replica if constraint name is used to check uniqueness instead of index name |
| functional.replication.test_updating_blob_with_empty_string_stops_replication | Replication gets stuck due to "Blob xxx.xx is not found for table xxx" error |
| 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.table.alter.test_05 | ALTER TABLE - ALTER - TO |
| 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.trigger.alter.test_alter_dml_basic | ALTER TRIGGER - basic checks for DML triggers |
| functional.trigger.database.test_transactioncommit_01 | Trigger on commit transaction. See also CORE-645 |