Problematic tests list (438 rows):

bugs.core_0203_test | CREATE VIEW ignores PLAN
bugs.core_0606_test | Tricky role defeats basic SQL security
bugs.core_2017_test | I/O statistics for stored procedures are not accounted in monitoring tables
bugs.core_2484_test | Success message when connecting to tiny trash database file
bugs.core_2685_test | System triggers on view with check option are not removed
bugs.core_3076_test | Better performance for (table.field = :param or :param = -1) in where clause
bugs.core_3537_test | There is no need to undo changes made in GTT created with ON COMMIT DELETE ROWS option when transaction is rolled back
bugs.core_3549_test | Database corruption after end of session : page xxx is of wrong type expected 4 found 7
bugs.core_3735_test | Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS
bugs.core_4122_test | Metadata export with isql (option -ex) does not export functions properly
bugs.core_4137_test | Wrong metadata output script generated by isql / CHARACTER SETISO8859_1 syntax error
bugs.core_4149_test | New permission types are not displayed by ISQL
bugs.core_4164_test | Owner name is missing for generators/exceptions restored from a backup
bugs.core_4460_test | Expressions containing some built-in functions may be badly optimized
bugs.core_4706_test | ISQL pads blob columns wrongly when the column alias has more than 17 characters
bugs.core_4802_test | Regression: GRANT UPDATE(<some_column>) on <T> acts like grant update on ALL columns of <T>
bugs.core_4836_test | Grant update(c) on t to U01 with grant option: user U01 will not be able to `revoke update(c) on t from <user | role>` if this `U01` do some DML before revoke
bugs.core_4839_test | SHOW GRANTS does not display info about exceptions which were granted to user
bugs.core_4880_test | Better performance of creating packages containing many functions
bugs.core_5606_test | Add expression index name to exception message if computation failed
bugs.core_5612_test | Gradual slowdown compilation (create, recreate or drop) of views
bugs.core_5637_test | string right truncation on restore of security db
bugs.core_5659_test | Bad PLAN generated for query on Firebird v3.0
bugs.core_5746_test | Remove the restriction on create/delete, enable/disable the user indexes in system tables
bugs.core_5747_test | User can grant usage privilege by himself
bugs.core_5755_test | No error if the GRANT target object does not exist
bugs.core_5756_test | Regression: FB crashes when trying to recreate table that is in use by DML (3.0.3; 3.0.4; 4.0.0)
bugs.core_5794_test | Wrong behavour FOR <select_stmt> [AS CURSOR cursorname] with next update and delete
bugs.core_5840_test | Ignor of reference privilege
bugs.core_5843_test | Wrong handling of failures of TRANSACTION START trigger
bugs.core_5852_test | There is no check of existance generator and exception when privileges are granted
bugs.core_5853_test | Forward-compatible expressions LOCALTIME and LOCALTIMESTAMP
bugs.core_5861_test | GRANT OPTION is not checked for new object
bugs.core_5874_test | Provide name of read-only column incorrectly referenced in UPDATE ... SET xxx
bugs.core_5876_test | Provide name of udf function for "arithmetic exception, numeric overflow, or string truncation"
bugs.core_5887_trusted_role_test | Allow the use of management statements in PSQL blocks
bugs.core_5905_test | Inconsistencies with PSQL FUNCTION vs UDF
bugs.core_5965_test | FB3 Optimiser chooses less efficient plan than FB2.5 optimiser
bugs.core_5970_test | Built-in cryptographic functions
bugs.core_5972_test | External engine trigger crashing server if table have computed field
bugs.core_6015_test | Segfault when using expression index with complex expression
bugs.core_6024_test | FB3.0.4.33063 vs FB3.0.5.33100 manual plan cause "index cannot be used in the specified plan"
bugs.core_6028_test | Trigger on system table restored in FB3 database and can't be deleted
bugs.core_6044_test | ISQL issues with increased identifier length
bugs.core_6049_test | Builtin functions converting binary string to hexadecimal representation and vice versa
bugs.core_6054_test | Random crash 64bit fb_inet_server. Possible collation issue
bugs.core_6078_test | Permissions for create or alter statements are not checked
bugs.core_6160_test | SUBSTRING of non-text/-blob is described to return NONE character set in DSQL
bugs.core_6166_test | Problems with long object names (> 255 bytes)
bugs.core_6171_test | "No current record for fetch operation" with queries with aggregated subselect
bugs.core_6218_test | COUNT(DISTINCT <DECFLOAT_FIELD>) leads FB to crash when there are duplicate values of this field
bugs.core_6239_test | Procedures and EXECUTE BLOCK without RETURNS should not be allowed to use SUSPEND
bugs.core_6252_test | UNIQUE / PRIMARY KEY constraint can be violated when AUTODDL = OFF and mixing commands for DDL and DML
bugs.core_6278_test | Efficient table scans for DBKEY-based range conditions
bugs.core_6285_test | SQL-level replication management
bugs.core_6300_test | Next attachment id, next statement id and some other additions [CORE-6300]
bugs.core_6316_test | Unable to specify new 32k page size
bugs.core_6336_test | Regression in FB 4.x: error "Implementation of text subtype <NNNN> not located" on attempt to use some collations defined in fbintl.conf
bugs.core_6343_test | Rolled back transaction produces unexpected results leading to duplicate values in PRIMARY KEY field
bugs.core_6353_test | INT128 has problems with some PSQL objects
bugs.core_6411_test | FB crashes on attempt to create table with number of fields greater than 5460
bugs.core_6440_test | Expression indexes containing COALESCE inside cannot be matched by the optimizer after migration from v2.5 to v3.0
bugs.core_6444_test | Ability to query Firebird configuration using SQL
bugs.core_6487_test | FETCH ABSOLUTE and RELATIVE beyond bounds of cursor should always position immediately before-first or after-last
bugs.core_6489_test | User without ALTER ANY ROLE privilege can use COMMENT ON ROLE
bugs.gh_0310_test | System table with keywords
bugs.gh_3106_test | Many indexed reads in a compound index with NULLs
bugs.gh_3218_test | Optimizer fails applying stream-local predicates before merging [CORE2832]
bugs.gh_3357_test | Bad execution plan if some stream depends on multiple streams via a function [CORE2975]
bugs.gh_3810_test | Wrong or missing IS NULL optimization (regression) [CORE3449]
bugs.gh_3812_test | Query with SP doesn't accept explicit plan [CORE3451]
bugs.gh_4314_test | Sub-optimal predicate checking while selecting from a view [CORE3981]
bugs.gh_4954_test | subselect losing the index when where clause includes coalesce() [CORE4640]
bugs.gh_5009_test | Index and blob garbage collection doesn't take into accout data in undo log [CORE4701]
bugs.gh_6778_test | Inconsistent cursor-driven deletion
bugs.gh_6782_test | Getting "records fetched" for functions/procedures in trace
bugs.gh_6797_test | Functions DECRYPT and RSA_DECRYPT return VARCHAR CHARACTER SET NONE instead of VARBINARY (VARCHAR) CHARACTER SET OCTETS
bugs.gh_6812_test | BASE64_ENCODE and HEX_ENCODE can exceed maximum widths for VARCHAR
bugs.gh_6816_test | Illegal output length in base64/hex_encode/decode functions
bugs.gh_6825_test | Correct error message for DROP VIEW
bugs.gh_6869_test | Domain CHECK-expression can be ignored when we DROP objects that are involved in it
bugs.gh_6873_test | SIMILAR TO does not use index when pattern starts with non-wildcard character (in contrary to LIKE)
bugs.gh_6903_test | Unable to create ICU-based collation with locale keywords
bugs.gh_6963_test | grant references not working
bugs.gh_6992_test | Transform OUTER joins into INNER ones if the WHERE condition violates the outer join rules
bugs.gh_7046_test | Make ability to add comment to mapping ('COMMENT ON MAPPING ... IS ...')
bugs.gh_7050_test | Add table MON$COMPILED_STATEMENTS and columns
bugs.gh_7062_test | Creation of expression index does not release its statement correctly
bugs.gh_7086_test | PSQL and SQL profiler
bugs.gh_7094_test | Incorrect indexed lookup of strings when the last keys characters are part of collated contractions and there is multi-segment insensitive descending index
bugs.gh_7118_test | Chained JOIN .. USING across the same column names may be optimized badly
bugs.gh_7123_test | ISQL does not extract "INCREMENT BY" for IDENTITY column
bugs.gh_7137_test | Optimizer regression: bad plan (HASH instead of JOIN) is chosen for some inner joins
bugs.gh_7164_test | Multi-way hash/merge joins are impossible for expression-based keys
bugs.gh_7167_test | Incorrect transliteration of field names in constraint violation errors
bugs.gh_7168_test | Ignore missing UDR libraries during restore
bugs.gh_7208_test | Trace: provide performance statistics for DDL statements
bugs.gh_7220_test | Dependencies of subroutines are not preserved after backup restore
bugs.gh_7256_test | Inconsistent conversion of non-TEXT blobs in BLOB_APPEND
bugs.gh_7257_misc_datatypes_test | Support for partial indices
bugs.gh_7257_test | Support for partial indices
bugs.gh_7269_test | Database restore must make every effort on activating deferred indexes
bugs.gh_7331_test | Cost-based choice between nested loop join and hash join
bugs.gh_7350_test | SKIP LOCKED clause for SELECT WITH LOCK, UPDATE and DELETE
bugs.gh_7398_test | Worst plan sort created to execute an indexed tables
bugs.gh_7413_test | Regression: bad plan in FB 3.0.9+ (correct in FB 3.0.8)
bugs.gh_7426_test | Ensure the DDL trigger requests are cached
bugs.gh_7461_test | Differences in field metadata descriptions between Firebird 2.5 and Firebird 4
bugs.gh_7466_plans_tracking_test | Add COMPILE trace events - ability to see execution plan of every PSQL statement.
bugs.gh_7466_test | Add COMPILE trace events for procedures/functions/triggers
bugs.gh_7499_test | Problem with restore when backup has procedure which contains explicit PLAN clause with inappropriate indices.
bugs.gh_7506_test | Reduce output of the SHOW GRANTS command
bugs.gh_7517_test | Successful compiling of procedure with wrong PLAN(s) used by some of its statement(s)
bugs.gh_7553_test | Firebird 5 profiler error with subselects
bugs.gh_7568_test | Equivalence of boolean condition in partial index
bugs.gh_7604_test | PSQL functions do not convert the output BLOB to the connection character set
bugs.gh_7610_test | Uninitialized/random value assigned to RDB$ROLES -> RDB$SYSTEM PRIVILEGES when restoring from FB3 backup
bugs.gh_7611_test | Can't backup/restore database from v3 to v4 with SEC$USER_NAME field longer than 10 characters.
bugs.gh_7647_test | Regression: Error in isc_array_lookup_bounds
bugs.gh_7652_test | Make the profiler store aggregated requests by default, with option for detailed store
bugs.gh_7670_test | Cursor name can duplicate parameter and variable names in procedures and functions
bugs.gh_7675_test | EXPLAIN statement and RDB$SQL package
bugs.gh_7676_test | Invalid message when violating unique constraint ("Attempt to evaluate index expression recursively")
bugs.gh_7687_test | Add LEVEL column to PLG$PROF_RECORD_SOURCES and PLG$PROF_RECORD_SOURCE_STATS_VIEW
bugs.gh_7698_test | The legacy plan with window functions is broken
bugs.gh_7727_test | Index for integer column cannot be used when INT128/DECFLOAT value is being searched
bugs.gh_7730_test | Server ignores the size of VARCHAR when performing SET BIND ... TO VARCHAR(N)
bugs.gh_7744_test | Provide ability to run "ALTER SQL SECURITY DEFINER / INVOKER" without specifying further part of proc/func/package
bugs.gh_7749_test | Fix character set and collation output
bugs.gh_7752_test | The access path information is truncated to 255 characters in the PLG$PROF_RECORD_SOURCES table
bugs.gh_7804_test | The partial index is not involved when filtering conditions through OR.
bugs.gh_7853_test | Do not consider non-deterministic expressions as invariants in pre-filters
bugs.gh_7863_test | Non-correlated sub-query is evaluated multiple times if it is based on a VIEW rathe than on appropriate derived table.
bugs.gh_7899_test | Inconsistent state of master-detail occurs after RE-connect + 'SET AUTODDL OFF' + 'drop <FK>' which is ROLLED BACK
bugs.gh_7904_test | More realistic cardinality adjustments for unmatchable booleans // FB5 bad plan for query
bugs.gh_7921_test | FB5 uses PK for ordered plan even if less count of fields matching index exists
bugs.gh_7924_1_test | ALTER TABLE ALTER COLUMN <textual_field> can not be changed properly in some cases
bugs.gh_7924_2_test | ALTER TABLE ALTER COLUMN <textual_field> can not be changed properly in some cases
bugs.gh_7962_test | System procedure/function inconsistency between ISQL SHOW FUNCTIONS and SHOW PROCEDURES
bugs.gh_7989_test | Improve performance of external (UDR) functions
bugs.gh_8020_test | AV when both function and dependent table are dropped in the same transaction
bugs.gh_8061_addi_test | UNNEST subqueries invalidation. Examples when unnesting can NOT be used.
bugs.gh_8061_test | Unnest IN/ANY/EXISTS subqueries and optimize them using semi-join algorithm
bugs.gh_8077_test | Error "Too many recursion levels" does not stop execuition of code that uses ON DISCONNECT trigger (FB 4.x+)
bugs.gh_8084_test | Partial index uniqueness violation (changes in columns participating in index filtering expression are not properly tracked).
bugs.gh_8091_test | Ability to create an inactive index
bugs.gh_8100_test | The isc_array_lookup_bounds function returns invalid values for low and high array bounds
bugs.gh_8109_test | Plan/Performance regression when using special construct for IN in FB5.x compared to FB3.x
bugs.gh_8115_test | Avoid reading/hashing the inner stream(s) if the leader stream is empty
bugs.gh_8123_test | Procedure manipulation can lead to wrong dependencies removal
bugs.gh_8161_test | Cardinality estimation should use primary record versions only
bugs.gh_8176_test | Firebird hangs after starting remote profiling session
bugs.gh_8203_test | MAKE_DBKEY can raise 'malformed string' for some table names
bugs.gh_8223_test | SubQueryConversion = true: error "no current record for fetch operation" with complex joins
bugs.gh_8225_test | Problematic queries when SubQueryConversion = true
bugs.gh_8231_test | SubQueryConversion = true causes "request size limit exceeded" / "... unavailable resource. Unable to allocate memory ..."
bugs.gh_8233_test | SubQueryConversion = true - multiple rows in singleton select
bugs.gh_8249_test | CAST() ignores collation of target data type
bugs.gh_8250_test | Bad performance on simple two joins query on tables with composed index
bugs.gh_8252_test | Incorrect subquery unnesting with complex dependencies (SubQueryConversion = true)
bugs.gh_8263_test | gbak on Classic with ParallelWorkers > 1 doesn't restore indices, giving a cryptic error message
bugs.gh_8265_test | Nested IN/EXISTS subqueries should not be converted into semi-joins if the outer context is a sub-query which wasn't unnested
bugs.gh_8290_test | "Unique scan" is incorrectly reported in the explained plan for unique index and IS NULL predicate
bugs.gh_8434_test | Fix implicitly used collations after ALTER DOMAIN
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_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.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_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.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_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_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_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_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_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_02 | ISQL - SHOW SYSTEM TABLES
functional.basic.isql.test_03 | ISQL - SHOW SYSTEM parameters
functional.basic.isql.test_06 | Let ISQL show per-table run-time statistics.
functional.basic.isql.test_autoterm_01 | SET AUTOTERM ON/OFF. Basic test.
functional.basic.isql.test_autoterm_03 | SET AUTOTERM ON/OFF. Additional tests.
functional.database.create.test_00 | Verify ability to create database with different values of PAGE_SIZE
functional.datatypes.test_decfloat_columns_handlng | Check ability of misc. actions against table column for DECFLOAT datatype
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.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.skip_locked.test_skip_locked_basic | Basic check of SKIP LOCKED
functional.dml.update_or_insert.test_03 | UPDATE OR INSERT
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_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_37 | CREATE DOMAIN - NOT NULL
functional.domain.create.test_41 | CREATE DOMAIN - create two domain with same name
functional.domain.create.test_54 | Use of domains for Trigger/SP variable definition
functional.domain.drop.test_02 | DROP DOMAIN - in use
functional.domain.drop.test_03 | DROP DOMAIN - that doesn't exists
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_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_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_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_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.unique.test_insert_07 | Check correct work fix with foreign key
functional.fkey.unique.test_insert_09 | Check correct work fix with foreign key
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_02 | DROP GENERATOR - in use
functional.generator.drop.test_03 | DROP GENERATOR - generator does not exists
functional.gtcs.test_computed_fields_11 | Computed fields
functional.gtcs.test_computed_fields_13 | Computed fields
functional.gtcs.test_computed_fields_14 | Computed fields
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_07 | Test CREATE / ALTER domain statement with ADD/DROP CONSTRAINT clauses, together and separately.
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_isql_show_command_ambiguity | SHOW TABLE / VIEW: ambiguity between tables and views
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_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_time_zone | Miscelaneous time zone tests
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.intfunc.unlist.unlist_basic_test | UNLIST function. Basic examples.
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_03 | table MON$COMPILED_STATEMENTS and columns MON$STATEMENTS.MON$COMPILED_STATEMENT_ID and MON$CALL_STACK.MON$COMPILED_STATEMENT_ID
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.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.syspriv.test_access_any_object | Check ability to query, modify and deleting data plus add/drop constraints on any table
functional.syspriv.test_change_mapping_rules | Check ability to manage auth mappings
functional.syspriv.test_create_user_types | Check ability to update content of RDB$TYPES
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_use_granted_by_clause | Check ability to query, modify and deleting data plus add/drop constraints on any table
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_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_08 | ALTER TABLE - DROP
functional.table.alter.test_10 | ALTER TABLE - DROP CONSTRAINT - PRIMARY KEY
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_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.test_35f56933 | Fixed cardinality mistake for invariant booleans
functional.tabloid.test_3b372197 | built-in functions UNICODE_CHAR and UNICODE_VAL
functional.tabloid.test_80fd0682 | Fixed bug with index names patterns in online validation service
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_cc183f59 | Add key info to the merge join plan output
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_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_166663 | Index(es) should not become corrupted after two updates and raising exception in one Tx, doing inside SP
functional.tabloid.test_optimizer_index_navigation | Check that optimizer takes in account presense of index and does navigation instead of external sort.
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_10 | 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_02 | Error handling in trigger 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_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_10 | ALTER TRIGGER - AS
functional.trigger.table.test_alter_12 | ALTER TRIGGER - AS
functional.trigger.table.test_alter_13 | ALTER TRIGGER - AS
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_08 | CREATE VIEW - updateable WITH CHECK OPTION

This list is the same for:

6.0.0.889 2025.07.02 4b4e67f1 | CS