bugs.core_0203_test | CREATE VIEW ignores PLAN |
bugs.core_1725_test | Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan |
bugs.core_1802_test | Maximum key size using PXW_CSY collation |
bugs.core_1812_test | Index is not used for some date/time expressions in dialect 1 |
bugs.core_1815_test | Ability to grant role to another role |
bugs.core_1830_test | Possible index corruption with multiply updates of the same record in the same transaction and using of savepoints |
bugs.core_1841_test | Possible overflow in RDB$VIEW_RELATIONS.RDB$CONTEXT_NAME |
bugs.core_1846_test | Allow index walk (ORDER plan) when there is a composite index {A, B} and the query looks like WHERE A = ? ORDER BY B |
bugs.core_1891_test | SHOW VIEW shows non-sense information for view fields with expressions |
bugs.core_1894_test | Circular dependencies between computed fields crash the engine |
bugs.core_1930_test | Possible AV in engine if procedure was altered to have no outputs and dependent procedures was not recompiled |
bugs.core_1986_test | Altering domains name drops dependencies using the domain |
bugs.core_1997_test | Broken foreign key handling for multi-segmented index using unicode_ci collation |
bugs.core_2017_test | I/O statistics for stored procedures are not accounted in monitoring tables |
bugs.core_2053_test | Computed expressions may be optimized badly if used inside the RETURNING clause of the INSERT statement |
bugs.core_2073_test | Expression indexes bug: incorrect result for the inverted boolean |
bugs.core_2132_test | Indexed retrieval cannot be chosen if a stored procedure is used inside the comparison predicate |
bugs.core_2140_test | Error messages after parameters substitution contains '\n' characters instead of line break |
bugs.core_2155_test | Join of SP with view or table may fail with "No current record for fetch operation" |
bugs.core_2200_test | Extremely slow executing a cross join of 3 tables in Firebird 2.X |
bugs.core_2202_test | RDB$VIEW_RELATIONS is not cleaned when altering a view |
bugs.core_2216_test | Nbackup as online dump |
bugs.core_2230_test | Implement domain check of input parameters of execute block |
bugs.core_2289_test | Wrong (primary) constraint name is reported for the foreign key violation during FK creation |
bugs.core_2303_test | Include PLAN in mon$statements |
bugs.core_2374_test | ALTER TRIGGER / PROCEDURE wrong error message |
bugs.core_2386_test | ALTER VIEW could remove column used in stored procedure or trigger |
bugs.core_2424_test | Make CREATE VIEW infer column names for views involving a GROUP BY clause or derived table |
bugs.core_2430_test | Server adds "NOT" at the end of default value for the TIMESTAMP field |
bugs.core_2431_test | String values in error messages are not converted to connection charset |
bugs.core_2484_test | Success message when connecting to tiny trash database file |
bugs.core_2508_test | Tricky index names can defeat the parsing logic when generating a human readable plan |
bugs.core_2516_test | Wrong processing SP parameters with arrays |
bugs.core_2555_test | CI column does not group correctly with a second column |
bugs.core_2635_test | Unique index with a lot of NULL keys can be corrupted at level 1 |
bugs.core_2650_test | Improve sorting performance when long VARCHARs are involved |
bugs.core_2678_test | Full outer join cannot use available indices (very slow execution) |
bugs.core_2685_test | System triggers on view with check option are not removed |
bugs.core_2699_test | Common table expression context could be used with parameters |
bugs.core_2712_test | Do not print "invalid request BLR" for par.cpp errors with valid BLR |
bugs.core_2735_test | isql hangs when trying to show a view based on a procedure |
bugs.core_2741_test | Naive metadata extraction code in isql is defeated by "check" keyword typed in mixed case |
bugs.core_2765_test | Use of RDB$ADMIN role does not provide SYSDBA rights in GRANT/REVOKE |
bugs.core_2798_test | Incomplete plan output (lack of view names) when selecting from views containing procedures inside |
bugs.core_2806_test | Views based on procedures can't be created if the proc's output fields participate in an expression |
bugs.core_2812_test | Prohibit any improper mixture of explicit and implicit joins |
bugs.core_2826_test | Join condition fails for UTF-8 databases |
bugs.core_2835_test | Natural is used to select instead of primary key index |
bugs.core_2881_test | isql should show packaged procedures and functions categorized per package |
bugs.core_2910_test | PK index is not used for derived tables |
bugs.core_2912_test | Exception when upper casing string with 'ΓΏ' (lowercase y trema, code 0xFF in ISO8859_1) |
bugs.core_2916_test | Broken error handling in the case of a conversion error happened during index creation |
bugs.core_2930_test | DROP VIEW drops output parameters of used stored procedures |
bugs.core_2985_test | The new 2.5 feature to alter COMPUTED columns doesn't handle dependencies well |
bugs.core_3029_test | Bugcheck "Too many savepoints (287)" at rollback after exception at EXECUTE BLOCK with exception handler |
bugs.core_3055_test | Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used |
bugs.core_3056_test | Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued |
bugs.core_3064_test | Using both the procedure name and alias inside an explicit plan crashes the server |
bugs.core_3076_test | Better performance for (table.field = :param or :param = -1) in where clause |
bugs.core_3085_test | Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL |
bugs.core_3101_test | Cannot alter the domain after migrating from older versions |
bugs.core_3103_test | BAD PLAN with using LEFT OUTER JOIN in SUBSELECT |
bugs.core_3174_test | Expression index with TRIM may lead to incorrect indexed lookup |
bugs.core_3176_test | View with "subselect" column join table and not use index |
bugs.core_3180_test | ALTER VIEW with not matched columns in declaration and selection crashes the server |
bugs.core_3222_test | View with "WITH CHECK OPTION" doesn't like TRIM function in WHERE |
bugs.core_3239_test | UTF8 UNICODE_CI collate can not be used in compound index |
bugs.core_3283_test | BAD PLAN with using LEFT OUTER JOIN in SUBSELECT |
bugs.core_3305_test | "BLOB not found" error after creation/altering of the invalid trigger |
bugs.core_3311_test | Error "data type unknown" while preparing UPDATE/DELETE statements with the parameterized ROWS clause |
bugs.core_3312_test | Sub-optimal join plan when the slave table depends on the master via the "OR" predicate |
bugs.core_3338_test | Regression: Code changes disabled support for expression indexes with COALESCE, CASE and DECODE |
bugs.core_3353_test | Predicate 'blob_field LIKE ?' describes the parameter as VARCHAR(30) rather than as BLOB |
bugs.core_3357_test | Generators are set to 0 after restore |
bugs.core_3364_test | Blob filter to translate internal debug info into text representation |
bugs.core_3394_test | Failed attempt to violate unique constraint could leave unneeded "lock conflict" error in status-vector |
bugs.core_3419_test | Recurse leads to hangs/crash server |
bugs.core_3421_test | [FB3] AV with "UPDATE OR INSERT" |
bugs.core_3450_test | Inefficient optimization (regression) |
bugs.core_3474_test | Regression in joins on procedures |
bugs.core_3491_test | Altering of a TYPE OF COLUMN parameter affects the original column |
bugs.core_3502_test | DROP VIEW ignores the existing non-column dependencies |
bugs.core_3509_test | Alter procedure allows to add the parameter with the same name |
bugs.core_3530_test | BETWEEN operand/clause not supported for COMPUTED columns -- "feature is not supported" |
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_3545_test | Inconsistent domain's constraint validation in PSQL |
bugs.core_3547_test | Floating-point negative zero doesn't match positive zero in the index |
bugs.core_3549_test | Database corruption after end of session : page xxx is of wrong type expected 4 found 7 |
bugs.core_3553_test | Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types |
bugs.core_3569_test | CHAR(32767) present in XSQLVAR with length 32765 |
bugs.core_3594_test | Include expected and actual string lenght into error message for sqlcode -802 |
bugs.core_3598_test | TRACE: add statistics of actions that were after transaction finished |
bugs.core_3610_test | Can insert DUPLICATE keys in UNIQUE index |
bugs.core_3627_test | Server crashes with access violation when inserting row into table with unique index |
bugs.core_3672_test | computed index by substring function for long columns |
bugs.core_3690_dialect_1_test | Wrong warning message for ambiguous query |
bugs.core_3690_dialect_3_test | Wrong warning message for ambiguous query |
bugs.core_3691_test | Missing constraint name in foreign key error message in FB 2.1.4 |
bugs.core_3722_test | IS NOT DISTINCT FROM NULL doesn't use index |
bugs.core_3735_test | Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS |
bugs.core_3736_test | WITH LOCK clause is allowed for users with read-only rights on some table, thus blocking others from updating this table |
bugs.core_3761_test | Conversion error when using a blob as an argument for the EXCEPTION statement |
bugs.core_3834_test | Usage of a NATURAL JOIN with a derived table crashes the server |
bugs.core_3881_test | Extend the error reported for index/constraint violations to include the problematic key value |
bugs.core_3894_test | Wrong numbers in error message for decreasing char/varchar columns |
bugs.core_3902_test | Derived fields may not be optimized via an index |
bugs.core_3925_test | Creating self-referential FK crashes database (bug-check) whether constraint violation had place |
bugs.core_3947_test | Wrong results when the column with collation using option (NUMERIC-SORT=1) is in where clause |
bugs.core_3963_test | isql doesn't know the difference between UDF's and psql-functions |
bugs.core_3973_test | Original table name and column name and owner missing from SQLDA for aliased column in grouped query |
bugs.core_3997_test | Join using RDB$DB_KEY produce NATURAL plan |
bugs.core_4027_test | Creating table with computed fields containing "SELECT FIRST" produces corrupted result |
bugs.core_4038_test | Broken optimization for the stored dbkeys |
bugs.core_4070_test | NOT-NULL column can be used as primary key and filled with NULL-values |
bugs.core_4074_test | Computed by columns and position function |
bugs.core_4075_test | Server bugchecks or crashes on exception in calculated index |
bugs.core_4084_test | Regression: Group by fails if subselect-column is involved |
bugs.core_4102_test | Bad optimization of OR predicates applied to unions |
bugs.core_4117_test | COMPUTED BY field is evaluated as NULL if used as an exception parameter directly |
bugs.core_4118_test | Expression index may be not used for derived fields or view fields |
bugs.core_4119_test | Metadata source becomes wrong after twice transliteration to the metadata charset |
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_4156_test | RDB$GET_CONTEXT/RDB$SET_CONTEXT parameters incorrectly described as CHAR NOT NULL instead of VARCHAR NULLABLE |
bugs.core_4160_test | The parameterized exception does not accept not ASCII characters as parameter |
bugs.core_4164_test | Owner name is missing for generators/exceptions restored from a backup |
bugs.core_4165_test | Replace the hierarchical union execution with the plain one |
bugs.core_4203_test | Cannot create packaged routines with [VAR]CHAR parameters |
bugs.core_4205_test | ISQL -x does not output the START WITH clause of generators/sequences |
bugs.core_4210_test | Preserve comments for output parameters after altering procedures |
bugs.core_4214_test | GTT should not reference permanent relation |
bugs.core_4244_test | Problem with creation procedure which contain adding text in DOS864 charset |
bugs.core_4252_test | Add table name to text of validation contraint error message, to help identify error context |
bugs.core_4262_test | Context parsing error with derived tables and CASE functions |
bugs.core_4276_test | Error on create table with "CHARACTER SET DOS775" field |
bugs.core_4280_test | FB3: Stored function accepts duplicate input arguments |
bugs.core_4281_test | FB 3: TYPE OF arguments of stored functions will hang firebird engine if depending domain or column is changed |
bugs.core_4285_test | Choose the best matching index for navigation |
bugs.core_4304_test | Engine crashes when attempt to REcreate table with FK after syntax error before such recreating |
bugs.core_4315_test | Usage of field(s) alias in view WITH CHECK OPTION leads to incorrect compile error or incorrect internal triggers |
bugs.core_4318_test | Regression: Predicates involving PSQL variables/parameters are not pushed inside the aggregation |
bugs.core_4342_test | Non-privileged user can delete records from RDB$SECURITY_CLASSES table |
bugs.core_4350_test | Support the SQL Standard ALTER SEQUENCE .. RESTART (without WITH clause) |
bugs.core_4359_test | non-priviledged user can insert and update rdb$database |
bugs.core_4365_test | Equality predicate distribution does not work for some complex queries |
bugs.core_4371_test | Create function/sp which references to non-existent exception <...> |
bugs.core_4373_test | Duplicate names in package are not checked |
bugs.core_4376_test | Preparation of erroneous DDL statement does not show the main command failed |
bugs.core_4379_test | Poor performance of explicit cursors containing correlated subqueries in the select list |
bugs.core_4381_test | Incorrect line/column information in runtime errors |
bugs.core_4386_test | Report more details for "object in use" errors |
bugs.core_4403_test | Allow referencing cursors as record variables in PSQL |
bugs.core_4415_test | Useless extraction of generic DDL trigger |
bugs.core_4447_test | Positioned UPDATE statement prohibits index usage for the subsequent cursor field references |
bugs.core_4451_test | Allow output to trace explain plan form. |
bugs.core_4453_test | Regression: NOT NULL constraint, declared in domain, does not work |
bugs.core_4460_test | Expressions containing some built-in functions may be badly optimized |
bugs.core_4468_test | FB3: CREATE USER GRANT ADMIN ROLE does not work |
bugs.core_4470_test | gbak fails to restore database containing dependency between views and packaged functions |
bugs.core_4484_test | Description (COMMENT ON) for package procedures and functions, and its parameters |
bugs.core_4492_test | OR/IN predicates for RDB$DBKEY lead to NATURAL plan |
bugs.core_4498_test | FB 3.0 crashes when getting an explained plan for a DBKEY based retrieval |
bugs.core_4524_test | New gbak option to enable encryption during restore |
bugs.core_4528_test | Allow hash/merge joins for non-field (dbkey or derived expression) equalities |
bugs.core_4529_test | Allow to use index when GROUP BY on field which has DESCENDING index |
bugs.core_4530_test | DB_KEY based join of two tables may be ineffective |
bugs.core_4539_test | Server does not accept the right plan |
bugs.core_4555_test | DDL trigger remains active after dropped |
bugs.core_4557_test | FB 3.0 crashes on EXIT (or QUIT) command if use UTF8-collation + create domain based on it + issue SHOW DOMAIN |
bugs.core_4572_test | Incorrect error for PSQL function when the number of actual arguments does not match the number of formal arguments |
bugs.core_4585_test | Can't create column check constraint when the column is domain based |
bugs.core_4653_test | Crash on infinite mutual SP calls (instead of "Too many concurrent executions of the same request.") |
bugs.core_4665_test | Wrong result when use "where <field_C> STARTING WITH <:value> ORDER BY <field_N>" and field_C is leading part of compound index key: { field_C, field_N } |
bugs.core_4673_test | Regression: computed index based on a computed column stores NULL for all its keys |
bugs.core_4694_test | "Column unknown" error while preparing a recursive query if the recursive part contains ALIASED datasource in the join with anchor table |
bugs.core_4702_test | Regression: Join order in v3 is less optimal than in v2.x |
bugs.core_4707_test | Implement ability to validate tables and indices online (without exclusive access to database) |
bugs.core_4725_test | Inconsistencies with ALTER DOMAIN and ALTER TABLE with DROP NOT NULL and PRIMARY KEYs |
bugs.core_4733_test | Command "Alter table <T> alter TYPE <C> <DOMAIN_WITH_NOT_NULL" does not verifies data in column <C> and makes incorrect assignments in <C> to ZERO / JULIAN_DATE / ASCII(0) for types INT, TIMESTAMP and VARCHAR |
bugs.core_4735_test | Expression 'where bool_field IS true | false' should also use index as 'where bool_field = true | false' (if such index exists) |
bugs.core_4738_test | Command "Alter table <T> alter <C> type <domain_>" does not work: "BLR syntax error: expected valid BLR code at offset 15, encountered 255" |
bugs.core_4744_test | ALTER DATABASE SET DEFAULT CHARACTER SET: 1) take effect only for once for current attachment; 2) does not check that new char set exists untill it will be used |
bugs.core_4754_test | Bugcheck 167 (invalid SEND request) while working with GTT from several attachments (using EXECUTE STATEMENT ... ON EXTERNAL and different roles) |
bugs.core_4755_test | Parameterized exception: wrong output when number of arguments greater than 7 |
bugs.core_4766_test | AV when trying to manage users list using EXECUTE STATEMENT on behalf of non-sysdba user which has RDB$ADMIN role |
bugs.core_4774_test | Table aliasing is unnecessary required when doing UPDATE ... RETURNING RDB$ pseudo-columns |
bugs.core_4782_test | Command `SHOW TABLE` fails when the table contains field with unicode collationin its DDL |
bugs.core_4786_test | Problematic key value (when attempt to insert duplicate in PK/UK) is not shown where length of key >= 127 characters |
bugs.core_4802_test | Regression: GRANT UPDATE(<some_column>) on <T> acts like grant update on ALL columns of <T> |
bugs.core_4806_test | Regression: generators can be seen/modified by unprivileged users |
bugs.core_4807_test | Regression: List of aggregation is not checked properly |
bugs.core_4809_test | HASH/MERGE JOIN is not used for more than two streams if they are joined via USING/NATURAL clauses and join is based on DBKEY concatenations |
bugs.core_4811_test | Make user names behave according to SQL identifiers rules |
bugs.core_4819_test | EXECUTE PROCEDURE's RETURNING_VALUES and EXECUTE STATEMENT's INTO does not check validity of assignments targets leading to bugcheck |
bugs.core_4826_test | Make ISQL display character set when sqlda_display is on |
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_4846_test | Altering a trigger indicating other table than the original does not reflect the change |
bugs.core_4855_test | Online validation during DML activity in other connection leads to message "Error while trying to read from file" and "page in use during flush (210), file: cch.cpp line: 2672" |
bugs.core_4880_test | Better performance of creating packages containing many functions |
bugs.core_4884_test | Crash on pasring of script containing `execute block` with lot of nested begin..end statements |
bugs.core_4904_test | Index corruption when add data in long-key-indexed field |
bugs.core_4905_test | Invalid internal BLR filter conversion |
bugs.core_4917_test | ALTER DOMAIN ... TO <new_name> allows to specify <new_name> matching to 'RDB$[[:DIGIT:]]*' |
bugs.core_4921_test | Predicate IS [NOT] DISTINCT FROM is not pushed into unions/aggregates thus causing sub-optimal plans |
bugs.core_4927_test | IIF function prevents the condition from being pushed into the union for better optimization |
bugs.core_4940_test | Add label about deterministic flag for stored function in SHOW and extract commands |
bugs.core_4980_test | Operator REVOKE can modify rights granted to system tables at DB creation time |
bugs.core_4985_test | Non-privileged user can implicitly count records in a restricted table |
bugs.core_5020_test | Regression: ORDER BY clause on compound index may disable usage of other indices |
bugs.core_5049_test | Regression: incorrect calculation of byte-length for view columns |
bugs.core_5062_test | CHAR_TO_UUID on column with index throws expression evaluation not supported. Human readable UUID argument for CHAR_TO_UUID must be of exact length 36 |
bugs.core_5064_test | Add datatypes (VAR)BINARY(n) and BINARY VARYING(n) as alias for (VAR)CHAR(n) CHARACTER SET OCTETS |
bugs.core_5070_test | Compound index cannot be used for filtering in some ORDER/GROUP BY queries |
bugs.core_5074_test | Lost the charset ID in selection of array element |
bugs.core_5093_test | Alter computed field type does not work |
bugs.core_5118_test | Indices on computed fields are broken after restore (all keys are NULL) |
bugs.core_5122_test | Expression index may not be used by the optimizer if created and used in different connection charsets |
bugs.core_5130_test | Compiler issues message about "invalid request BLR" when attempt to compile wrong DDL of view with both subquery and "WITH CHECK OPTION" in its DDL |
bugs.core_5146_test | Suboptimal join order if one table has a selective predicate and MIN is calculated for the other one |
bugs.core_5161_test | Unique index could be created on non-unique data |
bugs.core_5166_test | Wrong error message with UNIQUE BOOLEAN field |
bugs.core_5194_test | Invalid computed by definition generated by isql -x |
bugs.core_5201_test | Return nonzero result code when restore fails on activating and creating deferred user index |
bugs.core_5207_test | ISQL -X may generate invalid GRANT USAGE statements for domains |
bugs.core_5216_test | Provide location context (line/column numbers) for runtime errors raised inside EXECUTE BLOCK |
bugs.core_5218_test | Explicitly defined names for NOT NULL constraints are not exported into script by ISQL -x |
bugs.core_5248_test | Improve consistency in GRANT syntax between roles and privileges according to SQL standard |
bugs.core_5275_test | Expression index may become inconsistent if CREATE INDEX was interrupted after b-tree creation but before commiting |
bugs.core_5313_test | Data type unknown error with LIST |
bugs.core_5325_test | Malformed string error when using cyrilic symbols and x'0d0a' in exception |
bugs.core_5367_test | Regression: (boolean) parameters as search condition no longer allowed |
bugs.core_5380_test | Allow subroutines to call others subroutines and themself recursively |
bugs.core_5383_test | Dependencies in Package not recognised |
bugs.core_5404_test | Inconsistent column/line references when PSQL definitions return errors |
bugs.core_5410_test | Dependencies are not stored when using some type of contructions in subroutines |
bugs.core_5421_test | Performance degradation in FB 3.0.2 compared to FB 2.5.7 |
bugs.core_5423_test | Regression: "Invalid usage of boolean expression" when use "BETWEEN" and "IS" operators |
bugs.core_5431_test | Support for DROP IDENTITY clause |
bugs.core_5435_test | Badly selective index could be used for extra filtering even if selective index is used for sorting |
bugs.core_5463_test | Support GENERATED ALWAYS identity columns and OVERRIDE clause |
bugs.core_5475_test | Provide ability to filter out info and warnings from trace log |
bugs.core_5481_test | Available indices are not used in some cases if ORDER BY expression is a filtered one |
bugs.core_5489_test | Bad performance for NULLs filtering inside a navigational index scan |
bugs.core_5494_test | Creating a column of type BLOB SUB_TYPE BINARY fails with a Token unknown |
bugs.core_5536_test | Connections compressed and encrypted in MON$ATTACHMENTS table |
bugs.core_5567_test | Direct system table modifications are not completely prohibited |
bugs.core_5576_test | Bugcheck on queries containing WITH LOCK clause |
bugs.core_5580_test | Signature of packaged functions is not checked for mismatch with [NOT] DETERMINISTIC attribute |
bugs.core_5598_test | Error "block size exceeds implementation restriction" while inner joining large datasets with a long key using the HASH JOIN plan |
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_5673_test | Unique constraint not working in encrypted database on first command |
bugs.core_5674_test | Allow unused Common Table Expressions |
bugs.core_5676_test | Consider equivalence classes for index navigation |
bugs.core_5685_test | Sometime it is impossible to cancel/kill connection executing external query |
bugs.core_5737_test | Invalid parameters of gds transaction in ISQL |
bugs.core_5743_test | Conversion error when both GROUP/ORDER BY expressions and WHERE expressions contain literals |
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_6040_test | Metadata script extracted using ISQL is invalid/incorrect when table has COMPUTED BY field |
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_6071_test | Restore of encrypted backup of database with SQL dialect 1 fails |
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_6208_test | CREATE DATABASE grant is lost in security.db after backup/restore cycle |
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.core_6527_test | Regression: inline comment of SP parameter with closing parenthesis leads to incorrect SQL when trying to extract metadata |
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_7786_test | Regression: ISQL extracts metadata with non-compilable 'COLLATE' clause if table has column with charset that differ from DB charset |
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_misplaced_collation_in_extracted_metadata | Misplaced collation when extracting metadata with isql |
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 |