bugs.gh_8255_test | Catch possible stack overflow when preparing and compiling user statements |
functional.arno.derived_tables.test_01 | Simple derived table |
functional.arno.derived_tables.test_02 | Unnamed (no relation alias) derived table |
functional.arno.derived_tables.test_03 | Explicit column names for derived table |
functional.arno.derived_tables.test_04 | Derived table column names must be unique |
functional.arno.derived_tables.test_05 | Derived table column names must be unique |
functional.arno.derived_tables.test_06 | Outer reference inside derived table to other relations in from clause is not allowed |
functional.arno.derived_tables.test_07 | Outer reference inside derived table to other relations in from clause is not allowed |
functional.arno.derived_tables.test_08 | Outer reference inside derived table to other relations in from clause is not allowed |
functional.arno.derived_tables.test_09 | Outer reference inside derived table to other relations in from clause is not allowed |
functional.arno.derived_tables.test_10 | Outer reference to upper scope-level is allowed |
functional.arno.derived_tables.test_11 | Outer reference to upper scope-level is allowed |
functional.arno.derived_tables.test_12 | Outer reference to upper scope-level is allowed |
functional.arno.derived_tables.test_13 | DISTINCT inside derived table |
functional.arno.derived_tables.test_14 | FIRST / SKIP inside derived table |
functional.arno.derived_tables.test_15 | UNION inside derived table |
functional.arno.derived_tables.test_16 | Simple derived table with aggregate inside |
functional.arno.derived_tables.test_17 | Aggregate inside derived table |
functional.arno.derived_tables.test_18 | Aggregate inside derived table |
functional.arno.derived_tables.test_19 | Sub-select inside derived table |
functional.arno.derived_tables.test_20 | Sub-select inside derived table |
functional.arno.derived_tables.test_21 | Implicit derived table by IN predicate |
functional.arno.derived_tables.test_22 | Derived table outer reference (triggers) |
functional.arno.derived_tables.test_23 | Derived table with outer reference from JOIN. |
functional.arno.derived_tables.test_24 | Derived table with outer reference from LEFT JOIN. |
functional.arno.derived_tables.test_25 | Derived table with outer reference from FULL JOIN. |
functional.arno.derived_tables.test_26 | Derived table with column that is specified several times |
functional.arno.derived_tables.test_27 | Derived table with same alias for several columns |
functional.arno.indices.test_lower_bound_asc_02_segments_01 | ASC 2-segment index lower bound |
functional.arno.indices.test_lower_bound_desc_02_segments_01 | DESC 2-segment index lower bound |
functional.arno.indices.test_starting_with_01 | STARTING WITH charset NONE |
functional.arno.indices.test_starting_with_02 | STARTING WITH charset ISO8859_1 |
functional.arno.indices.test_timestamps_01 | TIMESTAMP in index with values below julian date |
functional.arno.indices.test_upper_bound_asc_01_segments_01 | ASC single segment index upper bound |
functional.arno.indices.test_upper_bound_asc_01_segments_02 | ASC single segment index upper bound |
functional.arno.indices.test_upper_bound_asc_01_segments_03 | ASC single segment index upper bound |
functional.arno.indices.test_upper_bound_asc_01_segments_04 | ASC single segment index upper bound |
functional.arno.indices.test_upper_bound_asc_02_segments_01 | ASC 2-segment index upper bound |
functional.arno.indices.test_upper_bound_desc_01_segments_01 | DESC single segment index upper bound |
functional.arno.indices.test_upper_bound_desc_01_segments_02 | DESC single segment index upper bound |
functional.arno.indices.test_upper_bound_desc_02_segments_01 | DESC 2-segment index upper bound |
functional.arno.indices.test_upper_lower_bounds_01 | Upper and lower bounds |
functional.arno.indices.test_upper_lower_bounds_02 | Upper and lower bounds |
functional.arno.optimizer.test_opt_aggregate_distribution_01 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
functional.arno.optimizer.test_opt_aggregate_distribution_02 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
functional.arno.optimizer.test_opt_aggregate_distribution_03 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
functional.arno.optimizer.test_opt_aggregate_distribution_04 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
functional.arno.optimizer.test_opt_aggregate_distribution_05 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
functional.arno.optimizer.test_opt_aggregate_distribution_06 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
functional.arno.optimizer.test_opt_aggregate_distribution_07 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
functional.arno.optimizer.test_opt_aggregate_distribution_08 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
functional.arno.optimizer.test_opt_aggregate_distribution_09 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
functional.arno.optimizer.test_opt_aggregate_distribution_10 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
functional.arno.optimizer.test_opt_aggregate_distribution_11 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
functional.arno.optimizer.test_opt_aggregate_distribution_12 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
functional.arno.optimizer.test_opt_aggregate_distribution_13 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
functional.arno.optimizer.test_opt_aggregate_distribution_14 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
functional.arno.optimizer.test_opt_avoid_index_usage | AVOID index usage in WHERE <indexed_varchar_field> = <integer_value> |
functional.arno.optimizer.test_opt_full_join_01 | FULL OUTER JOIN, list all values |
functional.arno.optimizer.test_opt_full_join_02 | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
functional.arno.optimizer.test_opt_full_join_03 | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
functional.arno.optimizer.test_opt_full_join_04 | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
functional.arno.optimizer.test_opt_inner_join_01 | INNER JOIN join order |
functional.arno.optimizer.test_opt_inner_join_02 | INNER JOIN join order |
functional.arno.optimizer.test_opt_inner_join_03 | INNER JOIN join order |
functional.arno.optimizer.test_opt_inner_join_04 | INNER JOIN join order LIKE and IS NULL |
functional.arno.optimizer.test_opt_inner_join_05 | INNER JOIN join order LIKE and STARTING WITH |
functional.arno.optimizer.test_opt_inner_join_06 | INNER JOIN join order and VIEW |
functional.arno.optimizer.test_opt_inner_join_07 | INNER JOIN join order and VIEW |
functional.arno.optimizer.test_opt_inner_join_08 | INNER JOIN join order and VIEW |
functional.arno.optimizer.test_opt_inner_join_09 | INNER JOIN join order and distribution |
functional.arno.optimizer.test_opt_inner_join_10 | INNER JOIN join order |
functional.arno.optimizer.test_opt_inner_join_merge_01 | INNER JOIN join merge |
functional.arno.optimizer.test_opt_inner_join_merge_02 | INNER JOIN join merge |
functional.arno.optimizer.test_opt_inner_join_merge_03 | INNER JOIN join merge |
functional.arno.optimizer.test_opt_inner_join_merge_04 | INNER JOIN join merge and NULLs |
functional.arno.optimizer.test_opt_inner_join_merge_05 | INNER JOIN join merge and VIEWs |
functional.arno.optimizer.test_opt_inner_join_merge_06 | INNER JOIN join merge and SP |
functional.arno.optimizer.test_opt_left_join_01 | LEFT OUTER JOIN with no match at all |
functional.arno.optimizer.test_opt_left_join_02 | LEFT OUTER JOIN with no match and IS NULL in WHERE clause |
functional.arno.optimizer.test_opt_left_join_03 | LEFT OUTER JOIN with full match and reference in WHERE clause |
functional.arno.optimizer.test_opt_left_join_04 | LEFT OUTER JOIN with full match |
functional.arno.optimizer.test_opt_left_join_05 | LEFT OUTER JOIN with full match, but limited in ON clause |
functional.arno.optimizer.test_opt_left_join_06 | LEFT OUTER JOIN with full match, but limited in ON clause |
functional.arno.optimizer.test_opt_left_join_07 | 4 JOINed tables with 1 LEFT OUTER JOIN |
functional.arno.optimizer.test_opt_left_join_08 | LEFT OUTER JOIN with full match, but limited in ON and WHERE clause |
functional.arno.optimizer.test_opt_left_join_09 | LEFT OUTER JOIN with full match, but limited in ON and WHERE clause |
functional.arno.optimizer.test_opt_left_join_10 | LEFT OUTER JOIN with IS NULL burried in WHERE clause |
functional.arno.optimizer.test_opt_left_join_11 | LEFT OUTER JOIN with STARTING WITH in WHERE clause |
functional.arno.optimizer.test_opt_left_join_12 | LEFT OUTER JOIN with distribution CASE |
functional.arno.optimizer.test_opt_left_join_13 | LEFT OUTER JOIN VIEW with full match |
functional.arno.optimizer.test_opt_mixed_joins_01 | Mixed JOINS |
functional.arno.optimizer.test_opt_mixed_joins_02 | Mixed JOINS |
functional.arno.optimizer.test_opt_mixed_joins_03 | Mixed JOINS |
functional.arno.optimizer.test_opt_mixed_joins_04 | Mixed JOINS |
functional.arno.optimizer.test_opt_mixed_joins_05 | Mixed JOINS |
functional.arno.optimizer.test_opt_mixed_joins_06 | Mixed JOINS |
functional.arno.optimizer.test_opt_multi_index_selection_01 | Unique index selection (multi segment) |
functional.arno.optimizer.test_opt_multi_index_selection_02 | Best match index selection (multi segment) |
functional.arno.optimizer.test_opt_multi_index_selection_03 | Best match index selection (multi segment) |
functional.arno.optimizer.test_opt_multi_index_selection_04 | Best match index selection (multi segment) |
functional.arno.optimizer.test_opt_multi_index_selection_05 | Best match index selection (multi segment) |
functional.arno.optimizer.test_opt_multi_index_selection_06 | Best match index selection (multi segment) |
functional.arno.optimizer.test_opt_multi_index_selection_07 | Best match index selection (multi segment) |
functional.arno.optimizer.test_opt_multi_index_selection_08 | Best match index selection (multi segment) |
functional.arno.optimizer.test_opt_selectivity_01 | SELECTIVITY - SET STATISTICS |
functional.arno.optimizer.test_opt_selectivity_02 | SELECTIVITY - CREATE INDEX |
functional.arno.optimizer.test_opt_selectivity_03 | SELECTIVITY - INDEX INACTIVE / ACTIVE |
functional.arno.optimizer.test_opt_single_index_selection_01 | Unique index selection (single segment) |
functional.arno.optimizer.test_opt_single_index_selection_02 | Best match index selection (single segment) |
functional.arno.optimizer.test_opt_single_index_selection_03 | Best match index selection (single segment) |
functional.arno.optimizer.test_opt_single_index_selection_04 | Best match index selection (single segment) |
functional.arno.optimizer.test_opt_single_index_selection_05 | Best match index selection (single segment) ASC and DESC |
functional.arno.optimizer.test_opt_single_index_selection_06 | Best match index selection (single segment) |
functional.arno.optimizer.test_opt_single_index_selection_07 | Best match index selection (single segment) |
functional.arno.optimizer.test_opt_single_index_selection_08 | Best match index selection (single segment) |
functional.arno.optimizer.test_opt_single_index_selection_09 | Best match index selection (single segment) OR |
functional.arno.optimizer.test_opt_single_index_selection_10 | Best match index selection (single segment) OR |
functional.arno.optimizer.test_opt_single_index_selection_11 | Best match index selection (single segment) |
functional.arno.optimizer.test_opt_sort_by_index_01 | ORDER BY ASC using index (unique) |
functional.arno.optimizer.test_opt_sort_by_index_02 | ORDER BY DESC using index (unique) |
functional.arno.optimizer.test_opt_sort_by_index_03 | ORDER BY ASC using index (non-unique) |
functional.arno.optimizer.test_opt_sort_by_index_04 | ORDER BY DESC using index (non-unique) |
functional.arno.optimizer.test_opt_sort_by_index_05 | MAX() and DESC index (non-unique) |
functional.arno.optimizer.test_opt_sort_by_index_06 | MAX() and ASC index (non-unique) |
functional.arno.optimizer.test_opt_sort_by_index_07 | MIN() and ASC index (non-unique) |
functional.arno.optimizer.test_opt_sort_by_index_08 | MIN() and DESC index (non-unique) |
functional.arno.optimizer.test_opt_sort_by_index_09 | ORDER BY ASC using index (non-unique) |
functional.arno.optimizer.test_opt_sort_by_index_10 | ORDER BY ASC using index (multi) |
functional.arno.optimizer.test_opt_sort_by_index_11 | ORDER BY ASC using index (multi) |
functional.arno.optimizer.test_opt_sort_by_index_12 | ORDER BY ASC, DESC using index (multi) |
functional.arno.optimizer.test_opt_sort_by_index_13 | ORDER BY ASC using index (multi) |
functional.arno.optimizer.test_opt_sort_by_index_14 | ORDER BY ASC NULLS FIRST using index |
functional.arno.optimizer.test_opt_sort_by_index_15 | ORDER BY ASC NULLS LAST using index |
functional.arno.optimizer.test_opt_sort_by_index_16 | ORDER BY DESC NULLS FIRST using index |
functional.arno.optimizer.test_opt_sort_by_index_17 | ORDER BY DESC NULLS LAST using index |
functional.arno.optimizer.test_opt_sort_by_index_18 | ORDER BY ASC using index (single) and WHERE clause |
functional.arno.optimizer.test_opt_sort_by_index_19 | ORDER BY ASC using index (multi) and WHERE clause |
functional.basic.isql.test_00 | Check output of "HELP" and "HELP SET" commands |
functional.basic.isql.test_01 | ISQL - SHOW DATABASE |
functional.basic.isql.test_02 | ISQL - SHOW SYSTEM TABLES |
functional.basic.isql.test_03 | ISQL - SHOW SYSTEM parameters |
functional.basic.isql.test_05 | ISQL should be able to process single statement with length up to 10*1024*1024 chars |
functional.database.alter.test_01 | Alter database: adding a secondary file |
functional.database.alter.test_02 | Alter database: adding secondary file with alternate keyword |
functional.database.alter.test_03 | Alter database: add file with name of this database or previously added files must fail |
functional.database.create.test_00 | Verify ability to create database with different values of PAGE_SIZE |
functional.database.create.test_01 | Create database: set names and default character set |
functional.database.create.test_02 | Create database: non sysdba user |
functional.database.create.test_08 | Create database: Multi file DB |
functional.database.create.test_09 | Create database: Multi file DB |
functional.database.create.test_10 | Create database: Multi file DB - starting |
functional.database.create.test_11 | Create database: Default char set NONE |
functional.database.create.test_13 | Create database: check that actual FW setting is ON for just created database. |
functional.datatypes.test_decfloat_binding_to_legacy | Test ability for DECFLOAT values to be represented as other data types using LEGACY keyword. |
functional.datatypes.test_decfloat_binding_to_other_types | Test ability for DECFLOAT values to be represented as other data types (char, double, bigint). |
functional.datatypes.test_decfloat_boundary_values | Check BOUNDARY values that are defined for DECFLOAT datatype |
functional.datatypes.test_decfloat_columns_handlng | Check ability of misc. actions against table column for DECFLOAT datatype |
functional.datatypes.test_decfloat_ddl_indices | Check ability to create table with 16 fields of type decfloat(34), plus create indices and add data |
functional.datatypes.test_decfloat_df16_alignment | Check proper alignment of decfloat(16) value if it is shown in ISQL when SET LIST ON |
functional.datatypes.test_decfloat_exceptions_trapping | Test exception trapping for result of DECFLOAT operations |
functional.datatypes.test_decfloat_literal_interpr | Test interpretation of numeric literals |
functional.datatypes.test_decfloat_literal_length | Literal length currently is limited with 1024 characters (including decimal separator and minus sign if any) |
functional.datatypes.test_decfloat_loose_accuracy | Test for preseving accuracy when evaluate sum of values with huge difference in magnitude |
functional.datatypes.test_decfloat_min_distinguish | List of all values starting from 1.0 divided by 2, until previous and current become equal |
functional.datatypes.test_decfloat_nan_and_infinity_comparison | DECFLOAT should not throw exceptions when +/-NaN, +/-sNaN and +/-Infinity is used in comparisons |
functional.datatypes.test_decfloat_ordering_rules | Test ordering of decfloat values |
functional.datatypes.test_decfloat_parsing_scaled_integers_and_bigint_max_min | Interpretation of DECFLOAT values as BIGINT |
functional.datatypes.test_decfloat_round_modes | Check validity of different ROUNDING modes that are defined for DECFLOAT datatype |
functional.datatypes.test_decfloat_scalar_functions | Test common math functions that should work with DECFLOAT datatype |
functional.datatypes.test_decfloat_single_bit_in_representation | Check result of EXP() which can be represented only by one ("last") significant bit |
functional.datatypes.test_decfloat_special_functions | Test functions that are designed specially for DECFLOAT handling |
functional.datatypes.test_decimal_declared_scale | Dummy test |
functional.datatypes.test_int128_agregate_functions | Basic test for aggregation functions against INT128 datatype |
functional.datatypes.test_int128_binary_operations | Basic test for binary functions against INT128 datatype |
functional.datatypes.test_int128_math_functions | Basic test for math functions against INT128 datatype |
functional.datatypes.test_miscelan_binding | Test ability for DECFLOAT values to be represented as other data types using LEGACY keyword. |
functional.dml.cte.test_01 | Non-Recursive CTEs |
functional.dml.cte.test_02 | Recursive CTEs |
functional.dml.delete.test_01 | DELETE |
functional.dml.delete.test_02 | DELETE with WHERE |
functional.dml.delete.test_03 | DELETE from VIEW |
functional.dml.insert.test_01 | INSERT with Defaults |
functional.dml.join.test_01 | NAMED COLUMNS join |
functional.dml.join.test_02 | NATURAL join |
functional.dml.merge.test_01 | MERGE statement |
functional.dml.merge.test_02 | MERGE statement can have only one RETURNING which must be after all WHEN sub-statements |
functional.dml.merge.test_03 | MERGE ... RETURNING must refer either ALIAS of the table (if it is defined) or context variables OLD and NEW |
functional.dml.update_or_insert.test_01 | UPDATE OR INSERT |
functional.dml.update_or_insert.test_02 | UPDATE OR INSERT |
functional.dml.update_or_insert.test_03 | UPDATE OR INSERT |
functional.domain.alter.test_01 | ALTER DOMAIN - SET DEFAULT |
functional.domain.alter.test_02 | ALTER DOMAIN - DROP DEFAULT |
functional.domain.alter.test_03 | ALTER DOMAIN - ADD CONSTRAINT |
functional.domain.alter.test_04 | ALTER DOMAIN - DROP CONSTRAINT |
functional.domain.alter.test_05 | ALTER DOMAIN - Alter domain that doesn't exists |
functional.domain.create.test_01 | CREATE DOMAIN - SMALLINT |
functional.domain.create.test_02 | CREATE DOMAIN - INTEGER |
functional.domain.create.test_03 | CREATE DOMAIN - INT |
functional.domain.create.test_04 | CREATE DOMAIN - FLOAT |
functional.domain.create.test_05 | CREATE DOMAIN - DOUBLE PRECISION |
functional.domain.create.test_06 | CREATE DOMAIN - DOUBLE PRECISION - ARRAY |
functional.domain.create.test_07 | CREATE DOMAIN - DATE |
functional.domain.create.test_08 | CREATE DOMAIN - TIME |
functional.domain.create.test_09 | CREATE DOMAIN - TIMESTAMP |
functional.domain.create.test_10 | CREATE DOMAIN - TIMESTAMP ARRAY |
functional.domain.create.test_11 | CREATE DOMAIN - DECIMAL |
functional.domain.create.test_12 | CREATE DOMAIN - DECIMAL ARRAY |
functional.domain.create.test_13 | CREATE DOMAIN - NUMERIC |
functional.domain.create.test_14 | CREATE DOMAIN - NUMERIC ARRAY |
functional.domain.create.test_15 | CREATE DOMAIN - CHAR |
functional.domain.create.test_16 | CREATE DOMAIN using 'CHARACTER' keyword |
functional.domain.create.test_17 | CREATE DOMAIN using 'CHARACTER VARYING' keyword |
functional.domain.create.test_18 | CREATE DOMAIN using 'VARCHAR' keyword |
functional.domain.create.test_19 | CREATE DOMAIN - VARCHAR ARRAY |
functional.domain.create.test_20 | CREATE DOMAIN - VARCHAR CHARACTER SET |
functional.domain.create.test_21 | CREATE DOMAIN - NCHAR |
functional.domain.create.test_22 | CREATE DOMAIN - NATIONAL CHARACTER |
functional.domain.create.test_23 | CREATE DOMAIN - NATIONAL CHAR |
functional.domain.create.test_24 | CREATE DOMAIN - NATIONAL CHAR VARYING |
functional.domain.create.test_25 | CREATE DOMAIN - NATIONAL CHAR VARYING ARRAY |
functional.domain.create.test_26 | CREATE DOMAIN - BLOB |
functional.domain.create.test_27 | CREATE DOMAIN. Specifying BLOB SUB_TYPE <N>, where N = 0 or 1. |
functional.domain.create.test_28 | CREATE DOMAIN. Specifying BLOB SUB_TYPE <A>, where A = 'binary' or 'text'. |
functional.domain.create.test_29 | CREATE DOMAIN - BLOB SEGMENT SIZE |
functional.domain.create.test_31 | CREATE DOMAIN. Check ability to declare using syntax BLOB(seglen, num_subtype) |
functional.domain.create.test_32 | CREATE DOMAIN - DEFAULT literal |
functional.domain.create.test_33 | CREATE DOMAIN - DEFAULT NULL |
functional.domain.create.test_34 | CREATE DOMAIN - DEFAULT USER |
functional.domain.create.test_36 | CREATE DOMAIN - DEFAULT CURRENT_ROLE |
functional.domain.create.test_37 | CREATE DOMAIN - NOT NULL |
functional.domain.create.test_38 | CREATE DOMAIN - CHECK |
functional.domain.create.test_40 | CREATE DOMAIN - all options |
functional.domain.create.test_41 | CREATE DOMAIN - create two domain with same name |
functional.domain.create.test_42 | CREATE DOMAIN - domain name equal to existing datatype |
functional.domain.create.test_54 | Use of domains for Trigger/SP variable definition |
functional.domain.drop.test_01 | DROP DOMAIN |
functional.domain.drop.test_02 | DROP DOMAIN - in use |
functional.domain.drop.test_03 | DROP DOMAIN - that doesn't exists |
functional.exception.alter.test_01 | ALTER EXCEPTION |
functional.exception.create.test_01 | CREATE EXCEPTION |
functional.exception.create.test_02 | CREATE EXCEPTION - try create Exception with the same name |
functional.exception.create.test_03 | CREATE EXCEPTION - too long message |
functional.exception.drop.test_01 | DROP EXCEPTION |
functional.exception.drop.test_02 | DROP EXCEPTION |
functional.exception.drop.test_03 | DROP EXCEPTION - that doesn't exists |
functional.exception.test_handling_name_and_message | Context variables EXCEPTION and ERROR_MESSAGE for ability to log exception info (including call stack!) on server side |
functional.fkey.primary.test_insert_pk_01 | Check correct work fix with foreign key |
functional.fkey.primary.test_insert_pk_02 | Check correct work fix with foreign key |
functional.fkey.primary.test_insert_pk_03 | Check correct work fix with foreign key |
functional.fkey.primary.test_insert_pk_04 | Check correct work fix with foreign key |
functional.fkey.primary.test_insert_pk_05 | Check correct work fix with foreign key |
functional.fkey.primary.test_insert_pk_06 | Check correct work fix with foreign key |
functional.fkey.primary.test_insert_pk_07 | Check correct work fix with foreign key |
functional.fkey.primary.test_insert_pk_08 | Check correct work fix with foreign key |
functional.fkey.primary.test_insert_pk_09 | Check correct work fix with foreign key |
functional.fkey.primary.test_insert_pk_10 | Check correct work fix with foreign key |
functional.fkey.primary.test_insert_pk_11 | Check correct work fix with foreign key |
functional.fkey.primary.test_insert_pk_12 | Check correct work fix with foreign key |
functional.fkey.primary.test_insert_pk_13 | Check correct work fix with foreign key |
functional.fkey.primary.test_insert_pk_14 | Check correct work fix with foreign key |
functional.fkey.primary.test_insert_pk_15 | Check correct work fix with foreign key |
functional.fkey.primary.test_insert_pk_16 | Check correct work fix with foreign key |
functional.fkey.primary.test_insert_pk_17 | Check correct work fix with foreign key |
functional.fkey.primary.test_insert_pk_18 | Check correct work fix with foreign key |
functional.fkey.primary.test_insert_pk_19 | Check correct work fix with foreign key |
functional.fkey.primary.test_select_pk_01 | Check correct work fix with foreign key |
functional.fkey.primary.test_select_pk_02 | Check correct work fix with foreign key |
functional.fkey.primary.test_upd_pk_01 | Check correct work fix with foreign key |
functional.fkey.primary.test_upd_pk_02 | Check correct work fix with foreign key |
functional.fkey.unique.test_insert_01 | Check correct work fix with foreign key |
functional.fkey.unique.test_insert_02 | Check correct work fix with foreign key |
functional.fkey.unique.test_insert_03 | Check correct work fix with foreign key |
functional.fkey.unique.test_insert_04 | Check correct work fix with foreign key |
functional.fkey.unique.test_insert_05 | Check correct work fix with foreign key |
functional.fkey.unique.test_insert_06 | Check correct work fix with foreign key |
functional.fkey.unique.test_insert_07 | Check correct work fix with foreign key |
functional.fkey.unique.test_insert_08 | Check correct work fix with foreign key |
functional.fkey.unique.test_insert_09 | Check correct work fix with foreign key |
functional.fkey.unique.test_insert_11 | Check correct work fix with foreign key |
functional.fkey.unique.test_insert_12 | Check correct work fix with foreign key |
functional.fkey.unique.test_insert_13 | Check correct work fix with foreign key |
functional.fkey.unique.test_insert_14 | Check correct work fix with foreign key |
functional.fkey.unique.test_select_uf_01 | Check correct work fix with foreign key |
functional.fkey.unique.test_select_uf_02 | Check correct work fix with foreign key |
functional.fkey.unique.test_upd_01 | Check correct work fix with foreign key |
functional.fkey.unique.test_upd_02 | Check correct work fix with foreign key |
functional.generator.alter.test_01 | ALTER SEQUENCE |
functional.generator.create.test_01 | CREATE GENERATOR and query related data from RDB$GENERATORS |
functional.generator.create.test_02 | CREATE GENERATOR - try create gen with same name |
functional.generator.drop.test_01 | DROP GENERATOR |
functional.generator.drop.test_02 | DROP GENERATOR - in use |
functional.generator.drop.test_03 | DROP GENERATOR - generator does not exists |
functional.gtcs.test_cast_datatypes | Check result or CAST() for misc agruments // from GTCS. |
functional.gtcs.test_computed_fields_01 | Computed fields |
functional.gtcs.test_computed_fields_02 | Computed fields |
functional.gtcs.test_computed_fields_03 | Computed fields |
functional.gtcs.test_computed_fields_04 | Computed fields |
functional.gtcs.test_computed_fields_05 | Computed fields |
functional.gtcs.test_computed_fields_06 | Computed fields |
functional.gtcs.test_computed_fields_07 | Computed fields |
functional.gtcs.test_computed_fields_08 | Computed fields |
functional.gtcs.test_computed_fields_09 | Computed fields |
functional.gtcs.test_computed_fields_10 | Computed fields |
functional.gtcs.test_computed_fields_11 | Computed fields |
functional.gtcs.test_computed_fields_12 | Computed fields |
functional.gtcs.test_computed_fields_13 | Computed fields |
functional.gtcs.test_computed_fields_14 | Computed fields |
functional.gtcs.test_computed_fields_15 | Computed fields |
functional.gtcs.test_computed_fields_16 | Computed fields |
functional.gtcs.test_computed_fields_17 | Computed fields |
functional.gtcs.test_conversion_error_from_string | Script issues conversion error from string |
functional.gtcs.test_crash_of_group_by_varchar_4000 | Crash on attempt to GROUP BY on table with varchar(4000) field |
functional.gtcs.test_division_by_zero_corrupts_db | Zero divide in SP can crash database when call this SP several times |
functional.gtcs.test_dsql_domain_01 | Test the level 0 syntax for SQL create domain defining only the datatype |
functional.gtcs.test_dsql_domain_02 | Test the level 0 syntax for SQL "CREATE DOMAIN" statement using datatype and DEFAULT clauses |
functional.gtcs.test_dsql_domain_03 | Test the level 0 syntax for SQL "CREATE DOMAIN" statement using datatype and NOT NULL constraint |
functional.gtcs.test_dsql_domain_04 | Test the level 0 syntax for SQL "CREATE DOMAIN" statement using datatype and CHECK constraint clause |
functional.gtcs.test_dsql_domain_06 | Test the level 0 syntax for SQL "CREATE DOMAIN" statement using datatype and CHECK constraint clause. |
functional.gtcs.test_dsql_domain_07 | Test CREATE / ALTER domain statement with ADD/DROP CONSTRAINT clauses, together and separately. |
functional.gtcs.test_dsql_domain_12 | Verify result of INSERT DEFAULT VALUES into a table with domain fields when domains are defined with DEFAULT value. |
functional.gtcs.test_dsql_domain_13 | Verify result of INSERT DEFAULT for domain-based fields which have their own default values |
functional.gtcs.test_dsql_domain_15 | Verify result of INSERT DEFAULT for domain-based fields which are declared as NOT NULL and have their own default values |
functional.gtcs.test_dsql_domain_20 | Verify result of ALTER DOMAIN SET/DROP DEFAULT when a table exists with field based on this domain |
functional.gtcs.test_dsql_domain_21 | Verify result of ALTER DOMAIN with changing DEFAULT values and DROP constraints when a table exists with field based on this domain |
functional.gtcs.test_dsql_domain_22 | Verify result of ALTER DOMAIN with changing NOT NULL flag and CHECK constraints when a table exists with field based on this domain |
functional.gtcs.test_execute_statement_within_procedure | EXECUTE STATEMENT within a stored procedure could lead to a problems |
functional.gtcs.test_external_file_03_d | Test for external table with field of SMALLINT datatype |
functional.gtcs.test_external_file_04_d | est for external table with field of INTEGER datatype |
functional.gtcs.test_external_file_04_d_bigint | Test for external table with field of BIGINT datatype |
functional.gtcs.test_external_file_04_d_int128 | Test for external table with field of INT128 datatype |
functional.gtcs.test_external_file_06_d | Test for external table with field of DOUBLE PRECISION datatype |
functional.gtcs.test_external_file_09_d | Test for external table with field of DATE datatype |
functional.gtcs.test_gtcs_proc_cast_isql | PROC_CAST1_ISQL.script ... PROC_CAST10_ISQL.script |
functional.gtcs.test_gtcs_proc_isql_01 | gtcs-proc-isql-01 |
functional.gtcs.test_gtcs_proc_isql_02 | gtcs-proc-isql-02 |
functional.gtcs.test_gtcs_proc_isql_03 | gtcs-proc-isql-03 |
functional.gtcs.test_gtcs_proc_isql_04 | gtcs-proc-isql-04 |
functional.gtcs.test_gtcs_proc_isql_05 | gtcs-proc-isql-05 |
functional.gtcs.test_gtcs_proc_isql_06 | gtcs-proc-isql-06 |
functional.gtcs.test_gtcs_proc_isql_07 | gtcs-proc-isql-07 |
functional.gtcs.test_gtcs_proc_isql_08 | gtcs-proc-isql-08 |
functional.gtcs.test_gtcs_proc_isql_10 | gtcs-proc-isql-10 |
functional.gtcs.test_gtcs_proc_isql_11 | gtcs-proc-isql-11 |
functional.gtcs.test_gtcs_proc_isql_12 | gtcs-proc-isql-12 |
functional.gtcs.test_gtcs_proc_isql_13 | gtcs-proc-isql-13 |
functional.gtcs.test_gtcs_proc_isql_15 | gtcs-proc-isql-15 |
functional.gtcs.test_gtcs_proc_isql_16 | gtcs-proc-isql-16 |
functional.gtcs.test_gtcs_proc_isql_17 | gtcs-proc-isql-17 |
functional.gtcs.test_gtcs_proc_isql_18 | gtcs-proc-isql-18 |
functional.gtcs.test_gtcs_proc_isql_19 | gtcs-proc-isql-19 |
functional.gtcs.test_gtcs_proc_isql_20 | gtcs-proc-isql-20 |
functional.gtcs.test_gtcs_select_delete_isql | Test for select from SP that deletes record after its output |
functional.gtcs.test_invalid_stream_when_use_trim | Statement with TRIM raises "bad BLR -- invalid stream" |
functional.gtcs.test_isql_show_command_ambiguity | SHOW TABLE / VIEW: ambiguity between tables and views |
functional.gtcs.test_minimum_grant_test | Minimum grant test |
functional.gtcs.test_misplaced_collation_in_extracted_metadata | Misplaced collation when extracting metadata with isql |
functional.gtcs.test_parser_comments_in_sql | Check for problems with comments (single-line and multi-line) |
functional.gtcs.test_ref_integ_drop_fk_index | Index that is used for FK should not be avail for DROP |
functional.gtcs.test_ref_integ_drop_fk_then_pk | Outcome must be SUCCESS if first we drop FK and after this PK constraint |
functional.gtcs.test_ref_integ_drop_pk_constraint | Constraint of PRIMARY KEY should not be avail for DROP if there is FK that depends on it |
functional.gtcs.test_ref_integ_drop_pk_index | Index that is used for PRIMARY KEY should not be avail for DROP |
functional.gtcs.test_ref_integ_inactive_fk_index | Index that is used for FK should not be avail for INACTIVE |
functional.gtcs.test_ref_integ_inactive_pk_index | Index that is used for PRIMARY KEY should not be avail for INACTIVE |
functional.gtcs.test_ref_integ_inactive_pk_index_2 | Index that is used for PRIMARY KEY should not be avail for INACTIVE |
functional.gtcs.test_regexp_similar_to | Statements with SIMILAR TO - miscelaneous tests. |
functional.gtcs.test_regexp_substring_similar_to | SUBSTRING - miscelaneous tests of <str> SIMILAR TO <pattern> |
functional.gtcs.test_sql_join_03 | Ability to run query: ( A LEFT JOIN B ) INER JOIN C, plus ORDER BY with fields not from SELECT list |
functional.gtcs.test_sql_join_04 | Ability to run query: ( A LEFT JOIN B ) , C. Then add ORDER BY with fields not from SELECT list |
functional.gtcs.test_time_zone | Miscelaneous time zone tests |
functional.gtcs.test_transactions_autocommit_1 | AUTO COMMIT must preserve changes that were made by all DML even if ROLLBACK is issued |
functional.gtcs.test_transactions_autocommit_2 | Changes within AUTO COMMIT must be cancelled when exception raises in some TRIGGER |
functional.gtcs.test_transactions_autocommit_3 | Changes within AUTO COMMIT must be cancelled when exception raises in some PROCEDURE |
functional.gtcs.test_trigger_variable_assignment | Variable in the AFTER-trigger must be allowed for assignment OLD value in it |
functional.gtcs.test_window_func_01 | Set of miscelaneous tests for verification of windowed functions |
functional.gtcs.test_window_func_02 | Set of miscelaneous tests for verification of windowed functions |
functional.gtcs.test_window_func_03 | Set of miscelaneous tests for verification of windowed functions |
functional.gtcs.test_window_func_04 | Set of miscelaneous tests for verification of windowed functions |
functional.gtcs.test_window_func_05 | Set of miscelaneous tests for verification of windowed functions |
functional.index.alter.test_01 | ALTER INDEX - INACTIVE |
functional.index.alter.test_02 | ALTER INDEX |
functional.index.alter.test_03 | ALTER INDEX - INACTIVE UNIQUE INDEX |
functional.index.alter.test_04 | ALTER INDEX - INACTIVE PRIMARY KEY |
functional.index.alter.test_05 | ALTER INDEX - INACTIVE FOREIGN KEY |
functional.index.create.test_01 | CREATE INDEX |
functional.index.create.test_02 | CREATE UNIQUE INDEX |
functional.index.create.test_03 | CREATE ASC INDEX |
functional.index.create.test_04 | CREATE ASCENDING INDEX |
functional.index.create.test_05 | CREATE DESC INDEX |
functional.index.create.test_06 | CREATE DESCENDING INDEX |
functional.index.create.test_07 | CREATE INDEX - Multi column |
functional.index.create.test_08 | CREATE INDEX - Table with data |
functional.index.create.test_09 | CREATE UNIQUE INDEX - Table with data |
functional.index.create.test_10 | CREATE INDEX - try create index with same name |
functional.index.create.test_11 | CREATE UNIQUE INDEX - Non unique data in table |
functional.index.create.test_12 | CREATE UNIQUE INDEX - Null value in table |
functional.intfunc.avg.test_01 | AVG from single integer row |
functional.intfunc.avg.test_02 | AVG - Test for INTEGER |
functional.intfunc.avg.test_03 | AVG - Test for INTEGER |
functional.intfunc.avg.test_04 | AVG - Test for INTEGER |
functional.intfunc.avg.test_05 | AVG - DISTINCT |
functional.intfunc.avg.test_06 | AVG - Integer OverFlow |
functional.intfunc.avg.test_07 | AVG - Integer with NULL |
functional.intfunc.avg.test_08 | AVG - NULL test |
functional.intfunc.avg.test_09 | AVG - DOUBLE PRECISION |
functional.intfunc.binary.test_and_01 | New Built-in Functions, Firebird 2.1 : BIN_AND( <number> [, <number> ...] ) |
functional.intfunc.binary.test_or_01 | New Built-in Functions, Firebird 2.1 : BIN_OR( <number> [, <number> ...] ) |
functional.intfunc.binary.test_shl_01 | New Built-in Functions, Firebird 2.1 : BIN_SHL( <number>, <number> ) |
functional.intfunc.binary.test_shr_01 | New Built-in Functions, Firebird 2.1 : BIN_SHR( <number>, <number> ) |
functional.intfunc.binary.test_xor_01 | New Built-in Functions, Firebird 2.1 : BIN_XOR( <number> [, <number> ...] ) |
functional.intfunc.cast.test_01 | CAST Numeric -> CHAR |
functional.intfunc.cast.test_02 | CAST Numeric -> VARCHAR |
functional.intfunc.cast.test_03 | CAST Numeric -> DATE |
functional.intfunc.cast.test_04 | CAST Numeric -> Numeric (Round down) |
functional.intfunc.cast.test_05 | CAST Numeric -> Numeric (Round up) |
functional.intfunc.cast.test_06 | CAST CHAR -> INTEGER (Round down) |
functional.intfunc.cast.test_07 | CAST CHAR -> INTEGER |
functional.intfunc.cast.test_08 | CAST CHAR -> DATE |
functional.intfunc.cast.test_09 | CAST CHAR -> DATE |
functional.intfunc.cast.test_10 | CAST CHAR -> TIME |
functional.intfunc.cast.test_11 | CAST CHAR -> TIME |
functional.intfunc.cast.test_12 | CAST CHAR -> TIME |
functional.intfunc.cast.test_13 | CAST CHAR -> TIMESTAM |
functional.intfunc.cast.test_14 | CAST CHAR -> TIMESTAMP |
functional.intfunc.cast.test_15 | CAST DATE -> CHAR |
functional.intfunc.cast.test_16 | CAST DATE -> VARCHAR |
functional.intfunc.cast.test_17 | CAST DATE -> TIMESTAMP |
functional.intfunc.cast.test_18 | CAST TIME -> CHAR |
functional.intfunc.cast.test_19 | CAST TIME -> VARCHAR |
functional.intfunc.cast.test_20 | CAST TIMESTAMP -> CHAR |
functional.intfunc.cast.test_21 | CAST TIMESTAMP -> VARCHAR |
functional.intfunc.cast.test_22 | CAST TIMESTAMP -> DATE |
functional.intfunc.cast.test_23 | CAST TIMESTAMP -> TIME |
functional.intfunc.count.test_01 | COUNT - Select from empty table |
functional.intfunc.count.test_02 | COUNT |
functional.intfunc.date.test_dateadd_01 | DATEADD |
functional.intfunc.date.test_dateadd_02 | DATEADD function for MONTH |
functional.intfunc.date.test_dateadd_03 | DATEADD |
functional.intfunc.date.test_dateadd_04 | DATEADD |
functional.intfunc.date.test_dateadd_05 | DATEADD |
functional.intfunc.date.test_dateadd_06 | DATEADD |
functional.intfunc.date.test_dateadd_07 | DATEADD |
functional.intfunc.date.test_dateadd_08 | Dateadd milliseconds |
functional.intfunc.date.test_datediff_01 | DATEDIFF |
functional.intfunc.date.test_datediff_02 | DATEDIFF |
functional.intfunc.date.test_datediff_03 | DATEDIFF |
functional.intfunc.date.test_datediff_04 | DATEDIFF |
functional.intfunc.date.test_datediff_05 | DATEDIFF |
functional.intfunc.date.test_datediff_06 | DATEDIFF |
functional.intfunc.date.test_datediff_07 | DATEDIFF |
functional.intfunc.date.test_extract_01 | EXTRACT(WEEK FROM DATE) |
functional.intfunc.date.test_extract_02 | EXTRACT - MILLISECONDS |
functional.intfunc.encryption.test_block_cipher_basic | ENCRYPT/DECRYPT built-in functions |
functional.intfunc.encryption.test_block_cipher_special | ENCRYPT/DECRYPT built-in functions |
functional.intfunc.encryption.test_rsa_family | Basic test for RSA-family: rsa_private(), rsa_public(), rsa_encrypt(), rsa_decrypt(), rsa_sign_hash() and rsa_verify_hash() |
functional.intfunc.list.test_01 | List with default options |
functional.intfunc.list.test_02 | List function with delimiter specified |
functional.intfunc.list.test_03 | List function with distinct option |
functional.intfunc.math.test_abs_01 | ABS( <number> ) |
functional.intfunc.math.test_acos_01 | ACOS( <number> ) |
functional.intfunc.math.test_asin_01 | ASIN( <number> ) |
functional.intfunc.math.test_atan2_01 | ATAN2( <number>, <number> ) |
functional.intfunc.math.test_atan_01 | ATAN( <number> ) |
functional.intfunc.math.test_ceil_01 | CEIL( <number>) |
functional.intfunc.math.test_cos_01 | COS( <number>) |
functional.intfunc.math.test_cosh_01 | COSH( <number>) |
functional.intfunc.math.test_cot_01 | COT( <number> ) |
functional.intfunc.math.test_exp_01 | EXP( <number> ) |
functional.intfunc.math.test_floor_01 | FLOOR( <number> ) |
functional.intfunc.math.test_ln_01 | LN( <number> ) |
functional.intfunc.math.test_log10_01 | LOG10( <number> ) |
functional.intfunc.math.test_log_01 | LOG( <number>, <number> ) |
functional.intfunc.math.test_maxvalue_01 | MAXVALUE( <value> [, <value> ...] ) |
functional.intfunc.math.test_minvalue_01 | MINVALUE( <value> [, <value> ... ) |
functional.intfunc.math.test_mod_01 | MOD( <number>, <number> ) |
functional.intfunc.math.test_pi_01 | PI() |
functional.intfunc.math.test_power_01 | POWER( <number>, <number> ) |
functional.intfunc.math.test_rand_01 | RAND() |
functional.intfunc.math.test_round_01 | ROUND( <number>, <number> ) |
functional.intfunc.math.test_sign_01 | SIGN( <number> ) |
functional.intfunc.math.test_sin_01 | SIN( <number> ) |
functional.intfunc.math.test_sinh_01 | SINH( <number> ) |
functional.intfunc.math.test_sqrt_01 | SQRT( <number> ) |
functional.intfunc.math.test_tan_01 | TAN( <number> ) |
functional.intfunc.math.test_tanh_01 | TANH( <number> ) |
functional.intfunc.math.test_trunc_01 | TRUNC( <number> [, <number> ] ) |
functional.intfunc.misc.test_decode_01 | DECODE() |
functional.intfunc.misc.test_gen_uuid_01 | GEN_UUID() |
functional.intfunc.misc.test_hash_01 | HASH( <value> ) |
functional.intfunc.string.test_ascii_01 | ASCII_CHAR( <number> ) |
functional.intfunc.string.test_ascii_val_01 | ASCII_VAL( <string> ) |
functional.intfunc.string.test_left_01 | LEFT function |
functional.intfunc.string.test_lpad_01 | LPAD function, including non-ascii characters |
functional.intfunc.string.test_overlay_01 | OVERLAY function |
functional.intfunc.string.test_position_01 | POSITION( <string> IN <string> ) |
functional.intfunc.string.test_replace_01 | REPLACE( <stringtosearch>, <findstring>, <replstring> ) |
functional.intfunc.string.test_reverse_01 | REVERSE( <value> ) |
functional.intfunc.string.test_right_01 | RIGHT( <string>, <number> ) |
functional.intfunc.string.test_rpad_01 | RPAD function, including non-ascii characters |
functional.intfunc.string.test_trunc_01 | Test for TRUNC function |
functional.intl.test_non_ascii_firebird_and_trace_utf8 | Check ability to obtain non-ascii content from firebird.log and trace when use ON DISCONNECT trigger and exception with non-ascii names, charset = UTF8. |
functional.monitoring.test_01 | Get isolation level of the current transaction |
functional.monitoring.test_02 | Get data about active statements from current attachment (WHERE-filter: mon$statements.mon$state=1). |
functional.monitoring.test_04 | SYSDBA must see all attachments and their transactions, non-privileged user - only those which was of his login. |
functional.procedure.alter.test_01 | ALTER PROCEDURE - Simple ALTER |
functional.procedure.alter.test_02 | ALTER PROCEDURE - Alter non exists procedure |
functional.procedure.create.test_01 | CREATE PROCEDURE |
functional.procedure.create.test_02 | CREATE PROCEDURE - Input parameters |
functional.procedure.create.test_03 | CREATE PROCEDURE - Output paramaters |
functional.procedure.create.test_04 | CREATE PROCEDURE - Output paramaters |
functional.procedure.create.test_05 | CREATE PROCEDURE - PSQL Stataments |
functional.procedure.create.test_06 | CREATE PROCEDURE - PSQL Stataments - SUSPEND |
functional.procedure.create.test_07 | CREATE PROCEDURE - try create SP with same name |
functional.procedure.create.test_08 | CREATE PROCEDURE - COMMIT in SP is not alowed |
functional.procedure.create.test_16 | Type Flag for Stored Procedures |
functional.replication.test_blob_access_when_no_grant_for_select | Replicator must have access to the table with blob regardless SELECT grant on this table to the user who created blob. |
functional.replication.test_permission_error_on_ddl_issued_by_non_sysdba | Permission error with replication |
functional.role.create.test_01 | CREATE ROLE |
functional.role.create.test_02 | CREATE ROLE - try create role with same name |
functional.services.test_role_in_service_attachment | Check that trace plugin shows ROLE used in service attachment. Format: USER[:ROLE] |
functional.services.test_user_management | Check ability to make connect to FB services and add/drop user |
functional.session.test_alter_session_reset | Test results of ALTER SESSION RESET |
functional.session.test_alter_session_reset_allow_2pc_prepared | ALTER SESSION RESET: do NOT raise error if prepared 2PC transactions present |
functional.session.test_alter_session_reset_clear_gtt | ALTER SESSION RESET: clear contents of all used GTT ON COMMIT PRESERVE ROWS |
functional.session.test_alter_session_reset_clear_timeouts | ALTER SESSION RESET: reset session and statement timeouts to zero |
functional.session.test_alter_session_reset_decfloat | ALTER SESSION RESET: DECFLOAT parameters must be returned to default values |
functional.session.test_alter_session_reset_raise_if_open_tx | ALTER SESSION RESET: throw error (isc_ses_reset_err) if any open transaction exist in current connection |
functional.session.test_alter_session_reset_remove_context_vars | ALTER SESSION RESET: remove all context variables in 'USER_SESSION' namespace |
functional.session.test_alter_session_reset_restore_role | ALTER SESSION RESET: restore ROLE which was passed with DPB and clear all cached security classes (if role was changed) |
functional.session.test_alter_session_reset_rollback | ALTER SESSION RESET: ROLLBACK current user transaction (if present) and issue warning if that transaction changes any table before reset |
functional.session.test_alter_session_reset_start_new_tx | ALTER SESSION RESET: START new transaction with the same properties as transaction that was rolled back (if transaction was present before reset) |
functional.session.test_ext_conn_pool_01 | External Connections Pool, functionality test 01 |
functional.shadow.test_create_01 | CREATE SHADOW: check basic usage |
functional.shadow.test_create_02 | CREATE SHADOW: check usage with presense of 'FILE <...>' clause. |
functional.syspriv.test_access_any_object | Check ability to query, modify and deleting data plus add/drop constraints on any table |
functional.syspriv.test_access_shutdown_database | Check ability to access to database in shutdown single mode as non-sysdba |
functional.syspriv.test_change_header_settings | Check ability to change some database header attributes by non-sysdba user who is granted with necessary system privileges |
functional.syspriv.test_change_mapping_rules | Check ability to manage auth mappings |
functional.syspriv.test_change_shutdown_mode | Check ability to change database shutdown mode by non-sysdba user who is granted with necessary system privileges |
functional.syspriv.test_create_database | Check ability to CREATE database by non-sysdba user who is granted with necessary system privilege |
functional.syspriv.test_create_privileged_roles | Check ability of non-sysdba user to CREATE privileged role (but NOT use it) |
functional.syspriv.test_create_user_types | Check ability to update content of RDB$TYPES |
functional.syspriv.test_drop_database | Check ability to DROP database by non-sysdba user who is granted with necessary system privileges |
functional.syspriv.test_grant_revoke_any_ddl_right | Check ability to grant right for issuing CREATE/ALTER/DROP statements |
functional.syspriv.test_grant_revoke_any_object | Check ability to query, modify and deleting data plus add/drop constraints on any table |
functional.syspriv.test_ignore_db_triggers | Check ability of non-sysdba and non-owner to ignore DB triggers |
functional.syspriv.test_modify_ext_conn_pool | Check ability to manage external connections pool |
functional.syspriv.test_monitor_any_attachment | Check ability to monitor any attachment |
functional.syspriv.test_read_raw_pages | Check ability to get binary content of DB page by non-sysdba user who is granted with necessary system privilege |
functional.syspriv.test_trace_any_attachment | Check ability to trace any attachment by non-sysdba user who is granted with necessary system privileges |
functional.syspriv.test_use_gbak_utility | Check ability to to make database backup |
functional.syspriv.test_use_granted_by_clause | Check ability to query, modify and deleting data plus add/drop constraints on any table |
functional.syspriv.test_use_gstat_utility | Check ability to obtain database statistics |
functional.syspriv.test_use_nbackup_utility | Check ability to use nbackup |
functional.syspriv.test_user_management_in_selfsec_db | Self-secutity DB: system privilege USER_MANAGEMENT must allow only to add/alter/drop user. No access to any user tables must be granted. |
functional.table.alter.test_01 | ALTER TABLE - ADD column |
functional.table.alter.test_02 | ALTER TABLE. Add column with DEFAULT expression, NOT NULL requirement and UNIQUE constraint that must be applied to its values. |
functional.table.alter.test_03 | ALTER TABLE - ADD CONSTRAINT - PRIMARY KEY |
functional.table.alter.test_04 | ALTER TABLE - ADD CONSTRAINT - UNIQUE |
functional.table.alter.test_05 | ALTER TABLE - ALTER - TO |
functional.table.alter.test_06 | ALTER TABLE. Alter type of some column. |
functional.table.alter.test_07 | ALTER TABLE. Alter position of columns. |
functional.table.alter.test_08 | ALTER TABLE - DROP |
functional.table.alter.test_09 | ALTER TABLE - DROP (with data) |
functional.table.alter.test_10 | ALTER TABLE - DROP CONSTRAINT - PRIMARY KEY |
functional.table.alter.test_11 | ALTER TABLE - DROP CONSTRAINT - UNIQUE |
functional.table.alter.test_12 | Verify ability to create exactly 254 changes of format (increasing it by 1) after initial creating table |
functional.table.create.test_01 | CREATE TABLE - types |
functional.table.create.test_04 | CREATE TABLE - constraints |
functional.table.create.test_05 | CREATE TABLE - create table with same name |
functional.table.create.test_06 | CREATE TABLE - two column with same name |
functional.table.create.test_07 | CREATE TABLE - unknown datatype (domain) |
functional.tabloid.core_3611_aux_test | Wrong data while retrieving from CTEs (or derived tables) with same column names |
functional.tabloid.test_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_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 |