| 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.sqlancer.arch_2312_17510_example_01_test | PARTIAL INDICES. NATURAL RIGHT JOIN results in an unexpected "Unknown column" error |
| 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_15_test | Wrong evaluation of MIN when bitwise shift is applied to the source value |
| 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_01_test | Partial index must not use incorrect assumption that 'c0 IS NOT 1' implied 'c0 NOT NULL' |
| 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.sqlite.test_002caede89 | LEFT JOIN with OR terms in WHERE clause causes assertion fault |
| functional.sqlite.test_02a8e81d44 | LIMIT clause on sub-select in FROM clause of a SELECT in a UNION ALL interpreted incorrectly |
| functional.sqlite.test_05f43be8fd | Incorrect use of index with LIKE operators when the LHS is a blob |
| functional.sqlite.test_07d6a0453d | OFFSET ignored if there is no FROM clause |
| functional.sqlite.test_0899cf62f5 | Segfault when running query that uses LEAD()OVER() and GROUP BY |
| functional.sqlite.test_0911b5d161 | Assertion |
| functional.sqlite.test_123c9ba321 | Incorrect result when an index is used for an ordered join |
| functional.sqlite.test_16c9801ceb | Segfault on DELETE with WHERE containing OR and redundant index exists. |
| functional.sqlite.test_18458b1ad6 | COLLATE issue in a view |
| functional.sqlite.test_188f912b51 | Assertion |
| functional.sqlite.test_190c2507ee | Assertion fault on a query against a view |
| functional.sqlite.test_199df4168c | Different answer with and without index on IN operator with type mismatch |
| functional.sqlite.test_1b06916e01 | Assertion |
| functional.sqlite.test_1b266395d6 | INSERT OR REPLACE with a foreign key constraint leads to assertion fault |
| functional.sqlite.test_1b8d726456 | MAX yields unexpected result for UTF-16 |
| functional.sqlite.test_1c69be2daf | Incorrect GROUP BY when input and output columns have the same name |
| functional.sqlite.test_1d958d9059 | Incorrect result with NOT IN operator and partial index |
| functional.sqlite.test_1dcb4d4496 | Incorrect query result when redundant terms appears in WHERE clause |
| functional.sqlite.test_1e39b966ae | LEFT JOIN strength reduction optimization causes an error. |
| functional.sqlite.test_1f6f353b68 | Segfault when running query that uses SUM()OVER() |
| functional.sqlite.test_209d31e316 | Assertion fault when deleting a table out from under a SELECT |
| functional.sqlite.test_2326c258d0 | Incorrect result when a LEFT JOIN provides the qualifying constraint for a partial index |
| functional.sqlite.test_256741a16b | null pointer dereference caused by window functions in result-set of EXISTS(SELECT ...) |
| functional.sqlite.test_25e335f802 | Query "<A> left join <B> inner join <C> on <b_c_expr> on <a_b_expr>" caused left join behave like inner join. |
| functional.sqlite.test_2841e99d10 | Different rounding when converting TEXT to DOUBLE PRECISION |
| functional.sqlite.test_2d5a316356 | Segmentation fault in CROSS JOIN |
| functional.sqlite.test_2df0107bd2 | Incorrect result from LEFT JOIN with a subquery on the LHS |
| functional.sqlite.test_2ea3e9fe63 | Partial index causes assertion fault on UPDATE OR REPLACE |
| functional.sqlite.test_2f7170d73b | Error "misuse of aggregate" raising if aggregate column in FROM subquery presents in the correlated subquery |
| functional.sqlite.test_31338dca7e | OR operator in WHERE clause gives wrong answer when indexed |
| functional.sqlite.test_31a19d11b9 | Name resolution issue with compound SELECTs and Common Table Expressions |
| functional.sqlite.test_34a579141b | Incorrect results with OR terms in the ON clause of a LEFT JOIN |
| functional.sqlite.test_34cd55d68e | Database corruption following INSERT with a TRIGGER that does an affinity change |
| functional.sqlite.test_3557ad65a0 | Incorrect DISTINCT on an indexed query with IN |
| functional.sqlite.test_360c6073e1 | Aggregate MAX() function with COLLATE clause |
| functional.sqlite.test_38a97a87a6 | Inaccurate int/float comparison results in corrupt index |
| functional.sqlite.test_38cb5df375 | LIMIT ignored on compound query with subqueries |
| functional.sqlite.test_3998683a16 | Some valid floating-point literals are not recognized. |
| functional.sqlite.test_3b84b42943 | LEFT JOIN malfunctions with generated column |
| functional.sqlite.test_3be1295b26 | Inconsistent behavior of a partial unique index on a boolean expression. |
| functional.sqlite.test_3c27b97e31 | REAL rounding seems to depend on index presence |
| functional.sqlite.test_3dbdcdb14e | Assertion fault using indices with redundant columns |
| functional.sqlite.test_3ea1755124 | REINDEX causes "UNIQUE constraint failed" error for generated column |
| functional.sqlite.test_41866dc373 | MIN() malfunctions for UNIQUE column |
| functional.sqlite.test_43107840f1 | Assertion fault on UPDATE |
| functional.sqlite.test_4374860b29 | Segfault |
| functional.sqlite.test_4766f44486 | ORDER BY handling with indexes on expressions |
| functional.sqlite.test_47b2581aa9 | Infinite loop on UPDATE |
| functional.sqlite.test_490a4b7235 | Assertion when "WHERE 0" on the first element of a UNION present |
| functional.sqlite.test_4ba5abf65c | Index on expression leads to an incorrect LEFT JOIN |
| functional.sqlite.test_4baa464912 | NULL handling for indexes on expressions |
| functional.sqlite.test_4e8e4857d3 | Crash on query using an OR term in the WHERE clause |
| functional.sqlite.test_4ef7e3cfca | Name resolution problem in sub-selects within triggers |
| functional.sqlite.test_4feb3159c6 | Crash due to misuse of window functions. |
| functional.sqlite.test_510cde2777 | Endless loop on a query with window functions, ORDER BY, and LIMIT |
| functional.sqlite.test_54844eea3f | Incorrect caching of sub-query results in the FROM clause of a scalar sub-query. |
| functional.sqlite.test_57c47526c3 | Incorrect answer when flattening a UNION ALL compound |
| functional.sqlite.test_587791f926 | Wrong result of COUNT when using WHERE clause with POSITION() |
| functional.sqlite.test_5c4e7aa793 | Incorrect result for comparison with NULL |
| functional.sqlite.test_5c6955204c | Incorrect result on a table scan of a partial index |
| functional.sqlite.test_5e3c886796 | Correlated subquery on the RHS of an IN operator causes output of excessive rows |
| functional.sqlite.test_5eadca17c4 | Assertion |
| functional.sqlite.test_5ed1772895 | Incorrect ORDER BY on an indexed JOIN |
| functional.sqlite.test_623eff57e7 | LEFT JOIN in view malfunctions with partial index on table |
| functional.sqlite.test_65eb38f6e4 | Incorrect answer on LEFT JOIN when STAT4 is enabled |
| functional.sqlite.test_66e4b0e271 | Incorrect result for LEFT JOIN |
| functional.sqlite.test_6c1d3febc0 | PRIMARY KEY for REAL column datatype leads to a missing entry in the index. |
| functional.sqlite.test_6f2222d550 | Incorrect output on a LEFT JOIN |
| functional.sqlite.test_752e1646fc | Wrong result if DISTINCT used on subquery which uses ORDER BY. |
| functional.sqlite.test_767a8cbc6d | COLLATE NOCASE string comparison yields incorrect result when partial index presents |
| functional.sqlite.test_787fa716be | Assertion fault when multi-use subquery implemented by co-routine |
| functional.sqlite.test_7a31705a7e | Name resolution fails when table name is a prefix of another table |
| functional.sqlite.test_7a5279a25c | Segfault when running query that has WHERE expression with IN(...) containing LEAD()OVER() function |
| functional.sqlite.test_7e59041f9c | DISTINCT malfunctions for a VIEW |
| functional.sqlite.test_7f39060a24 | LEFT JOIN malfunctions with partial index (unexpected fetch 1 row). |
| functional.sqlite.test_7f7f8026ed | Segfault following heavy SAVEPOINT usage |
| functional.sqlite.test_7fa8049685 | Incorrect result on a LEFT JOIN when using an index |
| functional.sqlite.test_7fc8e5ff25 | INSERT into table with two triggers does not terminate |
| functional.sqlite.test_7fde638e94 | Assertion fault on a LEFT JOIN |
| functional.sqlite.test_8025674847 | Incorrect use of "WHERE x NOT NULL" partial index for query with a "WHERE x IS NOT ?" term |
| functional.sqlite.test_80369eddd5 | Incorrect case in the LIKE operator when comparing unicode characters belonging to "Other Letter" category |
| functional.sqlite.test_80ba201079 | Bug involving subqueries and the OR optimization |
| functional.sqlite.test_82b588d342 | Assertion |
| functional.sqlite.test_8454a207b9 | ALTER TABLE ADD COLUMN with negative DEFAULT value |
| functional.sqlite.test_868145d012 | Assertion fault on double LEFT JOIN (after added support for transitive constraints) |
| functional.sqlite.test_892fc34f17 | Incorrect query result when a LEFT JOIN subquery is flattened |
| functional.sqlite.test_9080b6227f | Constant expression in partial index results in row not being fetched |
| functional.sqlite.test_91e8695101 | Segfault in a table with generated columns |
| functional.sqlite.test_93fb9f89d6 | Index causes incorrect WHERE clause evaluation |
| functional.sqlite.test_96c1454cbf | Incorrect result with ORDER BY DESC and LIMIT |
| functional.sqlite.test_98825a79ce | Incorrect result from a DISTINCT + GROUP BY + ORDER BY query |
| functional.sqlite.test_98d973b8f5 | Partial index gives incorrect query result |
| functional.sqlite.test_99cd4807dc | Scalar subquery with "LIMIT 0" should return NULL |
| functional.sqlite.test_9cdc5c4662 | Incorrect result from second execution of correlated scalar sub-query that uses a partial sort |
| functional.sqlite.test_9d708e4742 | Assertion |
| functional.sqlite.test_9ece23d2ca | Default collation sequences lost when window function added to query |
| functional.sqlite.test_a179fe7465 | Incorrect output order on a join with an ORDER BY |
| functional.sqlite.test_a5c8ed66ca | Incorrect count(*) when partial indices exist |
| functional.sqlite.test_a696379c1f | Access violation error trying to insert into triggered view |
| functional.sqlite.test_a7debbe0ad | BETWEEN issue in a view |
| functional.sqlite.test_a8a4847a2d | Trigger inserts duplicate value in UNIQUE column |
| functional.sqlite.test_a976c487d1 | LEFT JOIN in view malfunctions |
| functional.sqlite.test_aa43786930 | Assertion |
| functional.sqlite.test_aa98619ad0 | Assertion fault on an IN operator using a computed-by index |
| functional.sqlite.test_ae3c5670b6 | Bug caused by factoring of constants in trigger programs |
| functional.sqlite.test_af4556bb5c | Segfault while trying to prepare a malformed window-function query |
| functional.sqlite.test_afdc5a29dc | Lossless conversion when casting a large TEXT number to NUMERIC is not performed |
| functional.sqlite.test_b148fa6105 | CAST takes implicit COLLATE of its operand |
| functional.sqlite.test_b1d8c79314 | LIKE malfunctions for INT PRIMARY KEY COLLATE NOCASE column |
| functional.sqlite.test_b2d4edaffd | Comparison on view malfunctions |
| functional.sqlite.test_b383b90278 | Assertion in UPDATE statement for textual column which has check constraint that involves numeric comparison |
| functional.sqlite.test_b50528af44 | "WHERE a=? AND b IN (?,?,...) AND c>?" query using the seekscan optimization sometimes returns extra rows. |
| functional.sqlite.test_b5ca442af9 | "Malformed database schema" when creating a failing index within a transaction |
| functional.sqlite.test_b65cb2c8d9 | Incorrect LIMIT on a UNION ALL query |
| functional.sqlite.test_b75a9ca6b0 | ORDER BY ignored if query has identical GROUP BY |
| functional.sqlite.test_b7c8682cc1 | Incorrect result from LEFT JOIN with OR in the WHERE clause |
| functional.sqlite.test_ba7cbfaedc | Wrong output order when a DESC index and GROUP BY and ORDER BY. |
| functional.sqlite.test_bc1aea7b72 | Incorrect result on LEFT JOIN with OR constraints and an ORDER BY clause |
| functional.sqlite.test_bc878246ea | Incorrect result from LEFT JOIN query |
| functional.sqlite.test_bc8d94f0fb | RENAME COLUMN fails on tables with redundant UNIQUE constraints |
| functional.sqlite.test_be31cf009c | Unexpected result for % and '1E1' |
| functional.sqlite.test_be84e357c0 | Segfault during query involving LEFT JOIN column in the ORDER BY clause |
| functional.sqlite.test_bfbf38e5e9 | Segfault on a nested join |
| functional.sqlite.test_c0aeea67d5 | Incorrect LIKE result |
| functional.sqlite.test_c2a19d8165 | Incorrect LEFT JOIN when FROM clause contains nested subqueries |
| functional.sqlite.test_c2ad16f997 | Segfault on query involving deeply nested aggregate views |
| functional.sqlite.test_c31034044b | LEFT JOIN in view malfunctions with NOTNULL |
| functional.sqlite.test_c51489c3b8 | Incorrect result from WITH RECURSIVE using DISTINCT |
| functional.sqlite.test_c5ea805691 | Inverted sort order when using DISTINCT and a descending index |
| functional.sqlite.test_c620261b5b | Incorrect result on query involving LEFT JOIN and transitive constraints |
| functional.sqlite.test_c62c5e5852 | Assertion |
| functional.sqlite.test_c88f3036a2 | ALTER TABLE DROP <column> may corrupt data |
| functional.sqlite.test_c94369cae9 | Wrong answer when use no-case collation due to the LIKE optimization |
| functional.sqlite.test_c997b11c4d | ORDER BY clause ignored in 3-way join query |
| functional.sqlite.test_ca0d20b6cd | COLLATE operator masked by function calls |
| functional.sqlite.test_cad1ab4cb7 | Segfault due to LEFT JOIN flattening optimization |
| functional.sqlite.test_cafeafe605 | UPDATE with causes error when its WHERE expression involves ROW_NUMBER()OVER() call |
| functional.sqlite.test_ce22a07731 | NULL WHERE condition unexpectedly results in row being fetched |
| functional.sqlite.test_ce7c133ea6 | Foreign key constraint fails when it should succeed. |
| functional.sqlite.test_ce82323194 | Duplicate CTE name gives incorrect result |
| functional.sqlite.test_ce8717f088 | LIKE malfunctions for UNIQUE COLLATE NOCASE column |
| functional.sqlite.test_d02e1406a5 | LEFT JOIN with an OR in the ON clause causes segfault |
| functional.sqlite.test_d06a25c844 | Incorrect result from a UNION with an ORDER BY |
| functional.sqlite.test_d0866b26f8 | Window function in correlated subquery causes assertion fault |
| functional.sqlite.test_d11a6e908f | Query planner fault on three-way nested join with compound inner SELECT |
| functional.sqlite.test_d3e7f2ba5b | Nested boolean formula with IN operator computes an incorrect result |
| functional.sqlite.test_d666d600a6 | COLLATE operator on lhs of BETWEEN expression is ignored. |
| functional.sqlite.test_d805526eae | Incorrect join result or assertion fault due to transitive constraints |
| functional.sqlite.test_d9ed4ebef1 | SELECT on window function FIRST_VALUE()OVER() causes a segfault |
| functional.sqlite.test_db4d96798d | LIMIT does not work with nested views containing UNION ALL |
| functional.sqlite.test_db87229497 | Incorrect result when RHS of IN operator contains DISTINCT and LIMIT |
| functional.sqlite.test_dc6ebeda93 | Incorrect DELETE due to the one-pass optimization |
| functional.sqlite.test_dd08e5a988 | Foreign key constraint fails to prevent consistency error. |
| functional.sqlite.test_de7db14784 | Subquery with limit clause fails as EXISTS operand |
| functional.sqlite.test_dfd66334cf | Assertion |
| functional.sqlite.test_e12a0ae526 | Assertion |
| functional.sqlite.test_e1e07ef202 | COLLATE in BETWEEN expression is ignored |
| functional.sqlite.test_e20dd54ab0 | COLLATE sequence for ORDER/GROUP BY ignored when using an index-on-expression |
| functional.sqlite.test_e5504e987e | Segfault when running query that uses NTILE()OVER() |
| functional.sqlite.test_eb703ba7b5 | Incorrect result using index on expression with collating function |
| functional.sqlite.test_ebdbadade5 | LEFT JOIN incorrect when ON clause does not reference right table. |
| functional.sqlite.test_ec32177c99 | Incorrect result with complex OR-connected WHERE |
| functional.sqlite.test_f00d096cae | Assertion when use 'IN()' with dense_rank()over() and lag()over() |
| functional.sqlite.test_f09fcd1781 | Assertion fault when window functions are used. |
| functional.sqlite.test_f2369304e4 | Incorrect results when OR is used in the ON clause of a LEFT JOIN |
| functional.sqlite.test_f617ea3125 | Incorrect ORDER BY with colliding input and output column names |
| functional.sqlite.test_f74beaabde | Problem with 3-way joins and the USING clause |
| functional.sqlite.test_f7d890858f | Segfault when running query that uses window functions |
| functional.sqlite.test_f7f8c97e97 | Valid query fails to compile due to WHERE clause optimization |
| functional.sqlite.test_f8a7060ece | Incorrect result for query that uses MIN() and a CAST on rowid |
| functional.sqlite.test_f8f472cbc7 | Partial index and BETWEEN issue |
| functional.sqlite.test_f97c463710 | Incorrect ordering with ORDER BY and LIMIT |
| functional.sqlite.test_fb8c538a8f | Incorrect sorting when a column uses BINARY collation in the ORDER BY, but is compared with a different collation in the WHERE clause |
| functional.sqlite.test_fba33c8b1d | Partial index causes row to not be fetched in BETWEEN expression |
| functional.sqlite.test_fc7bd6358f | Incorrect query result in a 3-way join due to affinity issues |
| functional.sqlite.test_fd1bda016d | Assertion in the query containing subquery in select section and exists() |
| 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 column |
| 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_1ba0086e | Add optional COLUMN to ALTER TABLE ... ADD and DROP |
| 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_35f56933 | Fixed cardinality mistake for invariant booleans |
| functional.tabloid.test_3b372197 | built-in functions UNICODE_CHAR and UNICODE_VAL |
| functional.tabloid.test_45b40b86 | Fix old problem triggered by schemas changes (related to tests/bugs/gh_8057_test.py) |
| functional.tabloid.test_525e5665 | Corrections after LTT changes |
| 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_721329f0 | Fix problem in gbak where a package name were being leaked to non-packaged routines. |
| 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_883200d1 | Do not re-prepare statements when execute DDL in ISQL |
| functional.tabloid.test_893488bb | (Simplified but still) cost-based choice between LOOP and HASH semi-joins |
| functional.tabloid.test_8f728e63 | Fix cardinality estimations for semi/anti joins |
| functional.tabloid.test_90129c6d | Scrollable cursors. Fixed isBof/isEof when the prefetch is active |
| functional.tabloid.test_95442bdf | Attempt to avoid hash joining for possible cardinality under-estimations |
| functional.tabloid.test_aae2ae32 | Better fix for #8252: incorrect subquery unnesting with complex dependencies, it re-allows converting nested IN/EXISTS into multiple semi-join |
| functional.tabloid.test_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_cc183f59 | Add key info to the merge join plan output |
| 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_db_owner_punct_chars_max_length | Allow to create DB with owner containing a character from string.punctuation set, with duplicating it up to max allowed length |
| 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_f8cb4a6e | Correct error message on non-positioned cursor |
| functional.tabloid.test_fd0fa8a3 | Let include file name into error message when creation of temp file failed. |
| functional.tabloid.test_fde5484d | Increase isql max password length |
| 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_hq_153b7f6e | Don't set rdb$relation_fields.rdb$collation_id if field uses explicit domain with the same charset and collation id |
| 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_alter_dml_basic | ALTER TRIGGER - basic checks for DML triggers |
| functional.trigger.create.test_create_dml_basic | CREATE TRIGGER - basic checks for DML triggers |
| 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.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_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 |