| 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_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_5750_test | Date-time parsing is very weak |
| bugs.core_5753_test | Parser should not allow to use GRANT OPTION for FUNCTION and PACKAGE |
| bugs.core_5754_test | ALTER TRIGGER check privilege for alter database instead of table |
| bugs.core_5755_test | No error if the GRANT target object does not exist |
| bugs.core_5756_addi_test | Regression: FB crashes when trying to recreate table that is in use by DML (3.0.3; 3.0.4; 4.0.0) |
| bugs.core_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_5768_test | Implement FILTER-clause for aggregate functions (introduced in SQL:2003). This syntax allows for filtering before aggregation. |
| bugs.core_5770_test | User who is allowed to manage other users must have this ability WITHOUT need to grant him RDB$ADMIN role |
| bugs.core_5771_test | Restore (without replace) when database already exists crashes gbak or Firebird (when run through service manager) |
| bugs.core_5773_test | PSQL cursor doesn't see inserted record |
| bugs.core_5776_test | "Input parameter mismatch" error after altering external function into PSQL function |
| bugs.core_5783_test | execute statement ignores the text of the SQL-query after a comment of the form "-" |
| bugs.core_5790_test | User with DROP DATABASE privilege can't drop database |
| bugs.core_5793_test | Error returned from DbCryptPlugin::setKey() is not shown |
| bugs.core_5794_test | Wrong behavour FOR <select_stmt> [AS CURSOR cursorname] with next update and delete |
| bugs.core_5796_test | gstat may produce faulty report about presence of some none-encrypted pages in database |
| bugs.core_5802_test | Field name max length check wrongly if national characters specified |
| bugs.core_5804_test | Multiple error in REVOKE operator |
| bugs.core_5808_test | Support backup of encrypted databases |
| bugs.core_5823_test | No permission for SELECT access to blob field in stored procedure |
| bugs.core_5827_test | ALTER CURRENT USER fails with "no permission for <...> TABLE PLG$SRP" if current user: 1) has NO admin role and 2) wants to modify his own TAGS list |
| bugs.core_5831_test | Not user friendly output of gstat at encrypted database |
| bugs.core_5833_test | DDL triggers for some object types (views, exceptions, roles, indexes, domains) are lost in backup-restore process |
| bugs.core_5837_test | Inconsistent results when working with GLOBAL TEMPORARY TABLE ON COMMIT PRESERVE ROWS |
| bugs.core_5840_test | Ignor of reference privilege |
| bugs.core_5841_test | No permission for SELECT access to BLOB field if a TABLE is accessed using VIEW |
| bugs.core_5843_test | Wrong handling of failures of TRANSACTION START trigger |
| bugs.core_5845_test | ORDER BY on index can cause suboptimal index choices |
| bugs.core_5846_test | CREATE VIEW issues "Implementation of text subtype 512 not located" |
| bugs.core_5847_test | "Malformed string" instead of key value in PK violation error message |
| 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_5854_test | Very poor "similar to" performance |
| bugs.core_5855_test | Latest builds of Firebird 4.0 cannot backup DB with generators which contains space in the names |
| bugs.core_5857_test | Varchar computed column length stores incorrect and invalid values for field |
| bugs.core_5858_test | Command 'REVOKE ALL ON ALL FROM <anyname>' lead server to crash |
| bugs.core_5861_test | GRANT OPTION is not checked for new object |
| bugs.core_5862_test | Varchar computed column without explicit type does not populate RDB$CHARACTER_LENGTH |
| bugs.core_5871_test | Incorrect caching of the subquery result (procedure call) in independent queries |
| 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_5884_test | Initial global mapping from srp plugin does not work |
| bugs.core_5887_test | Allow the use of management statements in PSQL blocks |
| bugs.core_5887_trusted_role_test | Allow the use of management statements in PSQL blocks |
| bugs.core_5892_test | SQL SECURITY DEFINER context is not properly evaluated for monitoring tables |
| bugs.core_5896_test | NOT NULL constraint is not synchronized after rename column |
| bugs.core_5898_test | ROLE not passed in EXECUTE STATEMENT ... ON EXTERNAL |
| bugs.core_5904_test | An attempt to create global mapping with long (greater than SQL identifier length) FROM field fails |
| bugs.core_5905_test | Inconsistencies with PSQL FUNCTION vs UDF |
| bugs.core_5907_test | Regression: can not launch trace if its 'database' section contains regexp pattern with curvy brackets to enclose quantifier |
| bugs.core_5908_test | Enhance dynamic libraries loading related error messages |
| bugs.core_5913_test | Add context variables with compression and encryption status of current connection |
| bugs.core_5921_test | Provide information about Global Commit Number, Commit Number of currently used database snapshot (if any) and Commit Numbers assigned to the committed transactions |
| bugs.core_5926_test | Attempt to create mapping with non-ascii user name which is encoded in SINGLE-BYTE codepage leads to '-Malformed string' |
| bugs.core_5931_test | SIMILAR TO does not return result when invalid pattern is used (with two adjacent special characters that should be escaped but aren't) |
| bugs.core_5935_test | Bugcheck 165 (cannot find tip page) |
| bugs.core_5936_test | Firebird server segfaults in the end of database backup |
| bugs.core_5939_test | Crash for "gbak -se -b database nul" |
| bugs.core_5943_test | Server crashes preparing a query with both DISTINCT/ORDER BY and non-field expression in the select list |
| bugs.core_5948_test | Make WIN_SSPI plugin produce keys for wirecrypt plugin |
| bugs.core_5949_test | Bugcheck could happen when read-only database with non-zero linger is set to read-write mode |
| bugs.core_5953_test | Statement level read consistency in read-committed transactions |
| bugs.core_5957_test | Bug in SIMILAR TO when adding numeric quantifier as bound for repetetion of expression leads to empty resultset |
| 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_5973_test | Handling FP overflow in double precision value when converting from decfloat |
| bugs.core_5974_test | Wrong result of select distinct with decfload/timezone/collated column |
| bugs.core_5980_test | Firebird crashes due to concurrent operations with expression indices |
| bugs.core_5982_test | error read permission for BLOB field, when it is input/output procedure`s parametr |
| bugs.core_5985_test | Regression: ROLE does not passed in ES/EDS (specifying it in the statement is ignored) |
| bugs.core_5986_test | Incorrect evaluation of NULL IS [NOT] {FALSE | TRUE} |
| bugs.core_5990_test | Pool of external connections |
| bugs.core_5991_test | Trace could not work correctly with quoted file names in trace configurations |
| bugs.core_5995_test | Creator user name is empty in user trace sessions |
| bugs.core_6000_test | gbak issues "Your user name and password are not defined" when command switch "-fe(tch_password) ..." is specified when run as service |
| bugs.core_6003_test | RDB$GET_TRANSACTION_CN works different in Super and Classic |
| bugs.core_6015_test | Segfault when using expression index with complex expression |
| bugs.core_6018_test | Make it possible to start multiple transactions (possibly in different attachments) using the same initial transaction snapshot |
| bugs.core_6023_test | FB4 unable to overwrite older ods database |
| 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_6033_test | SUBSTRING(CURRENT_TIMESTAMP) does not work |
| bugs.core_6034_test | The original time zone should be set to the current time zone at routine invocation |
| bugs.core_6038_test | Srp user manager sporadically creates users which can not attach |
| 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_6048_test | Provide ability to see current state of DB encryption |
| 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_6058_test | Change behavior of skipped and repeated wall times within time zones |
| bugs.core_6068_test | Server hangs when compiling big package with error |
| 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_6083_test | USING PLUGIN clause does not work in RECREATE USER |
| bugs.core_6084_test | CREATE SEQUENCE START WITH has wrong initial value |
| bugs.core_6086_test | Creating of the large procedure crashes the server |
| bugs.core_6087_test | Problem with casting within UNION |
| bugs.core_6088_test | "SIMILAR TO" hangs when processing parenthesis |
| bugs.core_6089_test | BLOBs are unnecessarily copied during UPDATE after a table format change |
| bugs.core_6090_test | BLOB fields may be suddenly set to NULLs during UPDATE after a table format change |
| bugs.core_6095_test | Extend trace record for COMMIT/ROLLBACK RETAINING to allow chaining of transaction ids |
| bugs.core_6097_test | Connection does not see itself in the MON$ATTACHMENTS when Domain/Username (using SSPI) is 31 bytes long |
| bugs.core_6108_test | Regression: FB3 throws "Datatypes are not comparable in expression" in procedure parameters |
| bugs.core_6109_test | Changing FLOAT to a SQL standard compliant FLOAT datatype |
| bugs.core_6116_test | The Metadata script extracted using ISQL of a database restored from a Firebird 2.5.9 Backup is invalid/incorrect when table has COMPUTED BY field |
| bugs.core_6134_test | Win_Sspi in the list of auth plugins leads message about failed login to be changed (from 'Your user name and password are not defined...' to 'Missing security context ...') |
| bugs.core_6137_test | Server crashes when it run SQL |
| bugs.core_6138_test | Inconsistent behavior regarding visibility of master record on detail inserts |
| bugs.core_6142_test | Error "connection lost to database" could happen when application creates few local attachments (using XNET) simultaneously |
| bugs.core_6143_test | Error 'Multiple maps found for ...' is raised in not appropriate case |
| bugs.core_6144_test | Inconsistent behaviour of the NEW context variable in AFTER UPDATE OR DELETE triggers |
| bugs.core_6145_test | Wrong result in "similar to" with non latin characters |
| bugs.core_6147_test | PLG$SRP table, PLG$SRP_VIEW View instructions are strangely added in the metadata script extracted when Windows trusted authentication is enabled |
| bugs.core_6158_test | substring similar - extra characters in the result for non latin characters |
| bugs.core_6159_test | SUBSTRING SIMILAR is described with wrong data type in DSQL |
| bugs.core_6160_test | SUBSTRING of non-text/-blob is described to return NONE character set in DSQL |
| bugs.core_6163_test | Generator pages are not encrypted |
| 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_6181_test | Operations when using "SET DECFLOAT BIND BIGINT,n" with result of 11+ digits, fail with "Decimal float invalid operation" |
| bugs.core_6182_test | Firebird's internal timer incorrectly resets existing timer entries |
| bugs.core_6185_test | Some (wrong ?) parameters of ENCRYPT() leads FB to crash |
| bugs.core_6186_test | Original content of column which is involved into ENCRYPT() is displayed as distorted view after this call |
| bugs.core_6205_test | Generate proper error for UNION DISTINCT with more than 255 columns |
| bugs.core_6206_test | VARCHAR of insufficient length used for set bind of decfloat to varchar |
| bugs.core_6208_test | CREATE DATABASE grant is lost in security.db after backup/restore cycle |
| bugs.core_6211_test | Command "ISQL -X" can not extract ROLE name when use multi-byte charset for connection (4.x only is affected) |
| bugs.core_6216_test | request size limit exceeded when selecting from a table with large number of indicies |
| bugs.core_6218_test | COUNT(DISTINCT <DECFLOAT_FIELD>) leads FB to crash when there are duplicate values of this field |
| bugs.core_6219_test | Add support for special (inf/nan) values when sorting DECFLOAT values |
| bugs.core_6227_test | isc_info_svc_user_dbpath always returns alias of main security database |
| bugs.core_6233_test | Wrong dependencies of stored function on view after backup and restore |
| bugs.core_6236_test | RDB$TIME_ZONE_UTIL package has wrong privilege for PUBLIC |
| bugs.core_6237_test | Performance problem when using SRP plugin |
| bugs.core_6238_test | DECFLOAT: subtraction Num1 - Num2 leads to "Decimal float overflow" if Num2 is specified in scientific notation and less than max double ( 1.7976931348623157e308 ) |
| bugs.core_6239_test | Procedures and EXECUTE BLOCK without RETURNS should not be allowed to use SUSPEND |
| bugs.core_6241_test | Values greater than number of days between 01.01.0001 and 31.12.9999 (=3652058) can be added or subtracted from DATE |
| bugs.core_6246_test | Problem with too many number of columns in resultset |
| bugs.core_6248_test | A number of errors when database name is longer than 255 symbols |
| bugs.core_6250_test | Signature mismatch when creating package body on identical packaged procedure header |
| bugs.core_6251_test | Regression: crash when built-in function LEFT() or RIGHT() missed 2nd argument (number of characters to be taken) |
| bugs.core_6252_test | UNIQUE / PRIMARY KEY constraint can be violated when AUTODDL = OFF and mixing commands for DDL and DML |
| bugs.core_6254_test | AV in engine when using SET TRANSACTION and ON TRANSACTION START trigger uses EXECUTE STATEMENT against current transaction |
| bugs.core_6262_test | SHOW DOMAIN/TABLE does not display character set of system objects |
| bugs.core_6264_test | gbak with PIPE to stdout: invalid content if user '-se <host>:service_mgr' command switch |
| bugs.core_6265_test | mapping rules destroyed by backup / restore |
| bugs.core_6266_test | Deleting records from MON$ATTACHMENTS using ORDER BY clause doesn't close the corresponding attachments |
| bugs.core_6272_test | Failed attach to database not traced |
| bugs.core_6278_test | Efficient table scans for DBKEY-based range conditions |
| bugs.core_6279_test | Put options in user management statements in any order |
| bugs.core_6280_test | MERGE statement loses parameters in WHEN (NOT) MATCHED clause that will never be matched, crashes server in some situations |
| bugs.core_6281_test | Invalid timestamp errors with RDB$TIME_ZONE_UTIL.TRANSITIONS |
| bugs.core_6282_test | Change type of MON$ATTACHMENTS.MON$IDLE_TIMER and MON$STATEMENTS.MON$STATEMENT_TIMER to TIMESTAMP WITH TIME ZONE |
| bugs.core_6285_test | SQL-level replication management |
| bugs.core_6286_test | Make usage of TIMESTAMP/TIME WITH TIME ZONE convenient for users when appropriate ICU library is not installed on the client side |
| bugs.core_6290_test | Hex number used at end of statement (e.g. CREATE DOMAIN ... DEFAULT) may read invalid memory and produce wrong values or exceptions |
| bugs.core_6291_test | Statement "CREATE DOMAIN [dm_name] as BIGINT" raises "numeric value is out of range" if its default value is -9223372036854775808 |
| bugs.core_6294_test | Negative 128-bit integer constants are not accepted in DEFAULT clause |
| bugs.core_6300_test | Next attachment id, next statement id and some other additions [CORE-6300] |
| bugs.core_6310_test | Varchar length limit is not enforced when assigning string with trailing spaces in MBCS |
| bugs.core_6314_test | Assigning RDB$DB_KEY to MBCS CHAR/VARCHAR does not enforce the target limit |
| bugs.core_6316_test | Unable to specify new 32k page size |
| bugs.core_6317_test | Server is crashing on long GRANT statement |
| bugs.core_6318_test | CAST('NOW' as TIME) raises exception |
| bugs.core_6319_test | NBACKUP locks db file on error |
| bugs.core_6324_test | Alter domain operation for domain with collation specified revert its collation to database default |
| bugs.core_6328_test | FB4 Beta 2 may still be using the current date for TIME WITH TIME ZONE and extended wire protocol |
| bugs.core_6329_test | GBAK with service_mgr and WinSSPI authentication for Windows SYSTEM user producing error in clumplet API |
| 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 [CORE6336] |
| bugs.core_6337_test | SubType information is lost when calculating arithmetic expressions |
| bugs.core_6340_test | Alternate quoting does not work on some particular cases |
| bugs.core_6342_test | Make explicit basic type for high precision numerics - INT128 |
| bugs.core_6343_test | Rolled back transaction produces unexpected results leading to duplicate values in PRIMARY KEY field |
| bugs.core_6345_test | Server crashes on overflow of division result |
| bugs.core_6348_test | Wire compression causes freezes |
| bugs.core_6351_test | Computed field could be wrongly evaluated as NULL |
| bugs.core_6353_test | INT128 has problems with some PSQL objects |
| bugs.core_6355_test | TRUNC() does not accept second argument = -128 (but shows it as required boundary in error message) |
| bugs.core_6356_test | ROUND() does not allow second argument >=1 when its first argument is more than MAX_BIGINT / 10 |
| bugs.core_6357_test | LEAD() and LAG() do not allow to specify 3rd argument ("DEFAULT" value when pointer is out of scope) of INT128 datatype. |
| bugs.core_6358_test | Adding NOT NULL column with DEFAULT value may cause default values to update when selecting or have the wrong charset |
| bugs.core_6362_test | Better diagnostic when 'Missing security context' |
| bugs.core_6377_test | Unable to restore database with tables using GENERATED ALWAYS AS IDENTITY columns (ERROR:OVERRIDING SYSTEM VALUE should be used) |
| bugs.core_6379_test | Bugcheck 179 |
| bugs.core_6382_test | Triggers accessing a table prevent concurrent DDL command from dropping that table |
| bugs.core_6385_test | Wrong line and column information after IF statement |
| bugs.core_6389_test | Using binary string literal to assign to user-defined blob sub-types yield conversion error "filter not found to convert type 1 to type -13" |
| bugs.core_6392_test | Space in database path prevent working gbak -se ... -b "pat to/database" backup |
| bugs.core_6397_test | Message length error with COALESCE and TIME/TIMESTAMP WITHOUT TIME ZONE and WITH TIME ZONE |
| bugs.core_6398_test | Error converting string with hex representation of integer to smallint |
| bugs.core_6403_test | Some PSQL statements may lead to exceptions report wrong line/column |
| bugs.core_6408_test | RETURNING clause in MERGE cannot reference column in aliased target table using qualified reference (alias.column) if DELETE action present |
| bugs.core_6412_test | Firebird is freezing when trying to manage users via triggers |
| bugs.core_6414_test | Error message "expected length N, actual M" contains wrong value of M when charset UTF8 is used in the field declaration of a table |
| bugs.core_6419_test | Truncation of strings to put in MON$ tables do not work correctly |
| bugs.core_6421_test | Parameter in offset expression in LAG, LEAD, NTH_VALUE window functions requires explicit cast to BIGINT or INTEGER |
| bugs.core_6427_test | Whitespace as date separator causes conversion error |
| bugs.core_6429_test | Timezone offset in timestamp/time literal, CAST, SET TIME ZONE and AT TIME ZONE should follow SQL standard syntax only |
| bugs.core_6437_test | gfix cannot set big value for buffers |
| bugs.core_6438_test | ISQL: bad headers when text columns has >= 80 characters |
| bugs.core_6440_test | Expression indexes containing COALESCE inside cannot be matched by the optimizer |
| bugs.core_6441_test | Srp plugin keeps connection after database has been removed for ~10 seconds (SS and SC) |
| bugs.core_6444_test | Ability to query Firebird configuration using SQL |
| bugs.core_6447_test | Unexpectedly different text of message for parameterized expression starting from second run |
| bugs.core_6452_test | SIMILAR TO leads to an infinite loop |
| bugs.core_6453_test | EXECUTE STATEMENT fails on FB 4.x if containing time/timestamp with time zone parameters |
| bugs.core_6458_test | Regression: Cancel Query function no longer works |
| bugs.core_6460_test | Incorrect query result when using named window |
| bugs.core_6466_test | Comments before the first line of code are removed (when extract metadata) |
| bugs.core_6469_test | Provide ability to see in the trace log actions related to session management (e.g. ALTER SESSION RESET) |
| bugs.core_6474_test | Report replica mode through isc_database_info, MON$DATABASE and SYSTEM context |
| bugs.core_6479_test | COMMENT ON USER can only apply comment on user defined by the default usermanager plugin |
| bugs.core_6486_test | FETCH RELATIVE has an off by one error for the first row |
| 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_6494_test | Inconsistent translation "string->timestamp->string->timestamp" in dialect 1 |
| bugs.core_6496_test | string_to_datetime and '\0' symbol |
| bugs.core_6504_test | Provide same results for date arithmetics when date is changed by values near +/-max(bigint) |
| bugs.core_6517_test | Regression: CREATE DATABASE fails with 'Token unknown' error when DB name is enclosed in double quotes and 'DEFAULT CHARACTER SET' is specified after DB name |
| bugs.core_6521_test | CAST of Infinity values to FLOAT doesn't work |
| bugs.core_6526_test | AV in engine when StatementTimeout is active for user statement and some internal DSQL statement was executed as part of overall execution process |
| bugs.core_6527_test | Regression: inline comment of SP parameter with closing parenthesis leads to incorrect SQL when trying to extract metadata |
| bugs.core_6529_test | Error "no current record for fetch operation" when sorting by a international string |
| bugs.core_6531_test | COMPUTED BY column looses charset and collate of source field <F> when <F> is either of type BLOB or VARCHAR casted to BLOB |
| bugs.core_6532_test | Results of concatenation with blob has no info about collation of source columns (which are declared with such info) |
| bugs.core_6534_test | Hash join cannot match records using some TIME ZONE / DECFLOAT keys |
| bugs.core_6542_test | More efficient implementation of SUBSTRING for UTF8 character set |
| bugs.core_6987_test | DATEDIFF does not support fractional value for MILLISECOND |
| bugs.gh_0310_test | System table with keywords |
| bugs.gh_0731_test | coalesce fails with data type varchar and a non ascii value [CORE388] |
| bugs.gh_1665_test | TempDirectories parameter in firebird.conf ignored by global temporary tables |
| bugs.gh_1708_test | Avoid data retrieval if the WHERE clause always evaluates to FALSE [CORE1287] |
| bugs.gh_2292_test | Isql's extracted script is unusable with interdependent selectable procedures in FB 2.1 [CORE1862] |
| bugs.gh_3106_test | Indexed reads in a compound index with NULLs present even if record does not exist |
| 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_3886_test | recreate table T with PK or UK is impossible after duplicate typing w/o commit when ISQL is launched in AUTODDL=OFF mode |
| bugs.gh_4203_test | DROP [IF EXISTS] |
| bugs.gh_4314_test | Sub-optimal predicate checking while selecting from a view [CORE3981] |
| bugs.gh_4723_all_nulls_test | Optimize the record-level RLE algorithm for a denser compression of shorter-than-declared strings and sets of subsequent NULLs [CORE4401] |
| bugs.gh_4723_incompressible_test | Optimize the record-level RLE algorithm for a denser compression of shorter-than-declared strings and sets of subsequent NULLs [CORE4401] |
| bugs.gh_4729_test | Grant and Revoke update (field) [CORE4407] |
| bugs.gh_4769_test | Allow sub-routines to access variables/parameters defined at the outer/parent level [CORE4449] |
| 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_5082_test | Exception "too few key columns found for index" raises when attempt to create table with PK and immediatelly drop this PK within the same transaction [CORE4783] |
| bugs.gh_5173_test | Compound ALTER TABLE statement with ADD and DROP the same constraint failed if this constraint involves index creation (PK/UNQ/FK) |
| bugs.gh_5534_test | String truncation exception on UPPER/LOWER functions, UTF8 database and some multibyte characters |
| bugs.gh_5537_test | Non US-ASCII field names treated as unicode, although charset non-unicode, lowering max field length [CORE5258] |
| bugs.gh_5588_test | Support full SQL standard binary string literal syntax [CORE5311] |
| bugs.gh_5589_test | Support full SQL standard character string literal syntax [CORE5312] |
| bugs.gh_5740_test | Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued |
| bugs.gh_5749_test | Token unknown error on formfeed in query [CORE5479] |
| bugs.gh_5867_test | Add details on compression and crypt status of connection (fb_info_conn_flags) to getInfo() API call [CORE5601] |
| bugs.gh_5959_test | Add support for QUARTER to EXTRACT, FIRST_DAY and LAST_DAY [CORE5693] |
| bugs.gh_5978_test | Access to the name of DB encryption key [CORE5712] |
| bugs.gh_5995_test | Connection to server may hang when working with encrypted databases over non-TCP protocol |
| bugs.gh_6120_test | Support auth_plugin_list dpb/spb item from application to client [CORE5860] |
| bugs.gh_6220_test | Slow performance when executing SQL scripts as non-SYSDBA user |
| bugs.gh_6267_test | Add transaction info fb_info_tra_snapshot_number [CORE6017] |
| bugs.gh_6282_test | Add DPB properties for time zone bind and decfloat configuration [CORE6032] |
| bugs.gh_6413_test | Data pages of newly gbak restored databases should be marked as "swept" |
| bugs.gh_6416_test | Engine cant determine datatype in SQL: Unknown SQL Data type (32752) [CORE6168] |
| bugs.gh_6545_test | Error writing to TIMESTAMP/TIME WITH TIME ZONE array |
| bugs.gh_6609_test | Memory leak at server, when client select computed field, which used COALESCE or CAST [CORE6370] |
| bugs.gh_6681_test | Support for WHEN NOT MATCHED BY SOURCE for MERGE statement |
| bugs.gh_6706_test | Memory leak when running EXECUTE STATEMENT with named parameters [CORE6475] |
| bugs.gh_6709_test | gbak discards replica mode |
| bugs.gh_6732_test | Stored procedure isn't able to execute statement 'GRANT' |
| bugs.gh_6740_test | Allow parenthesized query expression for standard-compliance |
| bugs.gh_6778_test | Inconsistent cursor-driven deletion |
| bugs.gh_6782_test | Getting "records fetched" for functions/procedures in trace |
| bugs.gh_6785_test | Problem when restoring the database on FB 4.0 RC1 (gbak regression) |
| bugs.gh_6786_test | Add session time zone to system context |
| bugs.gh_6788_test | Extend EXTRACT to extract time zone strings |
| bugs.gh_6790_test | MON$ATTACHMENTS.MON$TIMESTAMP is incorrect when DefaultTimeZone is configured with time zone different from the server's default |
| bugs.gh_6797_test | Functions DECRYPT and RSA_DECRYPT return VARCHAR CHARACTER SET NONE instead of VARBINARY (VARCHAR) CHARACTER SET OCTETS |
| bugs.gh_6798_test | Add built-in functions UNICODE_CHAR and UNICODE_VAL to convert between Unicode code point and character |
| bugs.gh_6801_test | Error recompiling a package with some combination of nested functions |
| bugs.gh_6802_test | When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired |
| bugs.gh_6804_test | assertion in tomcrypt when key length for rc4 too small |
| bugs.gh_6807_test | Regression in FB 4.x : "Unexpected end of command" with incorrect line/column info |
| bugs.gh_6808_test | Segfault in encrypt/decrypt functions when their first argument is NULL |
| bugs.gh_6809_test | Integer hex-literals: support for INT128 |
| bugs.gh_6810_test | Use precise limit of salt length when signing messages and verifying the sign |
| bugs.gh_6812_test | BASE64_ENCODE and HEX_ENCODE can exceed maximum widths for VARCHAR |
| bugs.gh_6815_test | Support multiple rows for DML RETURNING |
| bugs.gh_6816_test | Illegal output length in base64/hex_encode/decode functions |
| bugs.gh_6817_test | Command switch "-fetch_password <passwordfile>" does not work with gfix |
| bugs.gh_6825_test | Correct error message for DROP VIEW |
| bugs.gh_6832_test | Segfault using "commit retaining" with GTT |
| bugs.gh_6838_test | Deleting multiple rows from a view with triggers may cause triggers to fire just once |
| bugs.gh_6845_test | Result type of AVG over BIGINT column results in type INT128 |
| bugs.gh_6854_test | Crash occurs when use SIMILAR TO ... |
| bugs.gh_6858_test | RSA_DECRYPT() can not decrypt data if it relates to BLOB type |
| bugs.gh_6860_test | Create user statement fails with SQLSTATE = HY000 when using DataTypeCompatibility |
| bugs.gh_6866_test | Some orphan records left at RDB$SECURITY_CLASSES and RDB$USER_PRIVILEGES after DROP PROCEDURE\FUNCTION |
| bugs.gh_6869_test | Domain CHECK-expression can be ignored when we DROP objects that are involved in it |
| bugs.gh_6872_test | Indexed STARTING WITH execution is very slow with UNICODE collation |
| bugs.gh_6873_test | SIMILAR TO does not use index when pattern starts with non-wildcard character (in contrary to LIKE) |
| bugs.gh_6874_test | Literal 65536 (interpreted as int) can not be multiplied by itself w/o cast if result more than 2^63-1 |
| bugs.gh_6875_test | Significant performance regression of SIMILAR TO and SUBSTRING(SIMILAR) when pattern is taken from variable (rather than directly specified) |
| bugs.gh_6886_test | Differerent interfaces behaviour depending upon source of interface |
| bugs.gh_6887_test | Invalid SIMILAR TO patterns may lead memory read beyond string limits |
| bugs.gh_6889_test | error no permision occurred while ALTER USER SET TAGS on snapshot build WI-V3.0.8.33482 |
| bugs.gh_6903_test | Unable to create ICU-based collation with locale keywords |
| bugs.gh_6910_test | Add way to retrieve statement BLR with Statement::getInfo and ISQL's SET EXEC_PATH_DISPLAY BLR |
| bugs.gh_6915_cs_cz_test | Performance effect of applying 'DISABLE-COMPRESSIONS=1' in UNICODE collation for LOCALE=cs_CZ |
| bugs.gh_6915_hu_hu_test | Performance effect of applying 'DISABLE-COMPRESSIONS=1' in UNICODE collation for LOCALE=hu_HU |
| bugs.gh_6915_test | Allow attribute DISABLE-COMPRESSIONS in UNICODE collations |
| bugs.gh_6930_test | Segfault when calling crypto functions |
| bugs.gh_6932_test | GTT's pages are not released while dropping it |
| bugs.gh_6934_test | SQL SECURITY DEFINER does not affect the ownership of created DDL objects |
| bugs.gh_6935_test | SQL SECURITY DEFINER has inconsistent behaviour if the object owner is non-privileged |
| bugs.gh_6941_test | Dummy (always true) conditions may change the join order |
| bugs.gh_6942_test | Incorrect singleton error with MERGE and RETURNING |
| bugs.gh_6954_test | Add fb_info_protocol_version information request to Attachment::getInfo(). |
| bugs.gh_6963_test | grant references not working |
| bugs.gh_6976_test | Lack of proper clean up after failure to initialize shared memory |
| bugs.gh_6987_test | DATEDIFF does not support fractional value for MILLISECOND |
| bugs.gh_6992_test | Transform OUTER joins into INNER ones if the WHERE condition violates the outer join rules |
| bugs.gh_6998_test | Problems with access to RDB$CONFIG table for non-privileged user when he has grant on execution of SP which has necessary access rights (created by SYSDBA with SQL DEFINER clause) |
| bugs.gh_7018_test | Problems with windows frames |
| bugs.gh_7025_test | Results of negation must be the same for each datatype (smallint / int /bigint / int128) when argument is least possible value for this type |
| bugs.gh_7031_test | gbak -b failed with "invalid transaction handle (expecting explicit transaction start)" |
| bugs.gh_7034_test | Server crashes while fetching from a scrollable cursor in PSQL |
| bugs.gh_7038_test | Improve performance of STARTING WITH with insensitive collations |
| bugs.gh_7045_test | International characters in table or alias names causes queries of MON$STATEMENTS to fail |
| bugs.gh_7046_test | Make ability to add comment to mapping ('COMMENT ON MAPPING ... IS ...') |
| bugs.gh_7048_test | Incorrect releasing of user savepoint (older savepoints become inaccessible) |
| bugs.gh_7050_test | Add table MON$COMPILED_STATEMENTS and columns |
| bugs.gh_7056_test | Fetching from a scrollable cursor may overwrite user-specified buffer and corrupt memory |
| bugs.gh_7057_test | Client-side positioned updates work wrongly with scrollable cursors |
| bugs.gh_7062_test | Creation of expression index does not release its statement correctly |
| bugs.gh_7064_test | Linear regression functions aren't implemented correctly |
| bugs.gh_7086_test | PSQL and SQL profiler |
| bugs.gh_7090_test | Performance degradation with CURRENT_DATE, LOCALTIME and LOCALTIMESTAMP |
| bugs.gh_7092_test | Improve performance of CURRENT_TIME |
| bugs.gh_7093_test | Improve indexed lookup speed of strings when the last keys characters are part of collated contractions |
| 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_7108_test | Firebird does not find an record when adding a foreign key |
| 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_7124_test | Inconsistent RDB$USER_PRIVILEGES after dropping identity |
| bugs.gh_7128_test | Incorrect error message with isc_sql_interprete() |
| bugs.gh_7129_test | Cannot alter SQL SECURITY on package |
| bugs.gh_7133_test | Order by for big (>34 digits) int128 values is broken when index on that field is used. |
| bugs.gh_7137_test | Optimizer regression: bad plan (HASH instead of JOIN) is chosen for some inner joins |
| bugs.gh_7139_test | With multiple trace sessions user may receive trace events related to engine's requests |
| bugs.gh_7140_test | Wrong select result in case of special sort character |
| bugs.gh_7141_test | Services manager breaks long lines into 1023 bytes portions when using isc_info_svc_line in Service::query() |
| bugs.gh_7164_test | Multi-way hash/merge joins are impossible for expression-based keys |
| bugs.gh_7165_test | Provide ability to see in the trace log events related to missing security context |
| 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_7176_test | Incorrect error "Invalid token. Malformed string." with union + blob + non utf8 varchar |
| bugs.gh_7178_test | DEFAULTed grants to PUBLIC must act as DEFAULTed to every user |
| bugs.gh_7179_test | Wrong error message - "string right truncation. expected length NN, actual NN." |
| bugs.gh_7183_test | Regression when derived table has column evaluated as result of subquery with IN(), ANY() or ALL() predicate: "invalid BLR at offset ... / context already in use" |
| bugs.gh_7186_test | Nbackup RDB$BACKUP_HISTORY cleanup |
| bugs.gh_7188_test | Memory leak in GDS32.DLL(FBClient.DLL), when multi-database transaction has done |
| bugs.gh_7208_test | Trace: provide performance statistics for DDL statements |
| bugs.gh_7217_test | user with DROP ANY PACKAGE privilege can not execute DROP PACKAGE BODY |
| bugs.gh_7220_test | Dependencies of subroutines are not preserved after backup restore |
| bugs.gh_7222_test | Dependencies of packaged functions are not tracked |
| bugs.gh_7227_test | Dependencies of subroutines are not preserved after backup restore |
| bugs.gh_7237_test | Starting operator become unstable on indexed varchar fields |
| bugs.gh_7239_test | Connect using XNET protocol shows different exception if DB is in shutdown state (comparing to INET) |
| bugs.gh_7243_test | Some UNICODE characters can lead to wrong CONTAINING evaluation when lower/upper uses different number of bytes in its encoding |
| 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_7276_test | Firebird 4 literal containing crashes server |
| bugs.gh_7304_test | Events in system attachments (like garbage collector) are not traced |
| bugs.gh_7331_test | Cost-based choice between nested loop join and hash join |
| bugs.gh_7332_test | Remove/increase the record size limit |
| bugs.gh_7350_test | SKIP LOCKED clause for SELECT WITH LOCK, UPDATE and DELETE |
| bugs.gh_7379_test | BLOB_APPEND with existing blob accepts malformed string |
| bugs.gh_7380_test | Aliased blob variable with less restrictions makes text blob accept malformed string through BLOB_APPEND |
| bugs.gh_7382_test | Performance improvement for BLOB copying |
| bugs.gh_7388_test | Different invariants optimization between views and CTEs |
| bugs.gh_7391_test | AV when compiling stored procedure |
| 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_7434_test | Crash or error in SUBSTRING()'s regexp parser with UTF-8 encoding |
| bugs.gh_7436_test | Backup error for wide table |
| bugs.gh_7446_check_regression_test | Attempt to use data in destroyed transaction pool |
| bugs.gh_7456_test | Impossible drop function in package with name of PSQL-function |
| bugs.gh_7461_test | Differences in field metadata descriptions between Firebird 2.5 and Firebird 4 |
| bugs.gh_7464_test | Crash on repeating update in 5.0 |
| 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_7467_test | Simple SQL crashes firebird: select cast(rdb$db_key as integer) from rdb$database |
| bugs.gh_7474_test | Incorrect condition evaluation - FB 5.0 |
| bugs.gh_7476_test | Improvement on procedures/triggers to recognize changes in a domain used in COALESCE |
| bugs.gh_7482_test | Result of blob_append(null, null) (literal '<null>') is not shown |
| bugs.gh_7484_test | External engine SYSTEM not found |
| bugs.gh_7488_test | Invalid real to string cast. |
| bugs.gh_7493_test | Firebird 5.0 snapshot blob not found error after first commit / rollback |
| bugs.gh_7494_test | Firebird performance issue - non necessary index reads |
| bugs.gh_7499_test | Problem with restore when backup has procedure which contains explicit PLAN clause with inappropriate indices. |
| bugs.gh_7501_test | Precision of standalone unit may differ from packaged one in SQL dialect 1 |
| 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_7536_test | Add ability to query current value of parallel workers for an attachment |
| bugs.gh_7537_test | Wrong name in error message when unknown namespace is passed into RDB$SET_CONTEXT() |
| bugs.gh_7548_test | SET BIND OF TIMESTAMP WITH TIME ZONE TO CHAR is not working with UTF8 connection charset |
| bugs.gh_7553_test | Firebird 5 profiler error with subselects |
| bugs.gh_7554_test | Firebird 5 partial index creation causes server hang up |
| bugs.gh_7558_test | AV in engine when attaching to the non-existing database and non-SYSDBA trace session is running |
| bugs.gh_7566_test | Allow DEFAULT keyword in argument list |
| bugs.gh_7568_test | Equivalence of boolean condition in partial index |
| bugs.gh_7569_test | Multi-level order by and offset/fetch ignored on parenthesized query expressions |
| bugs.gh_7574_test | Derived table syntax allows dangling "AS" |
| bugs.gh_7576_test | Allow nested parenthesized joined table |
| bugs.gh_7586_test | Named arguments for function call, EXECUTE PROCEDURE and procedure record source |
| bugs.gh_7587_test | CALL statement |
| bugs.gh_7590_test | Improve DECLARE VARIABLE to accept complete value expressions |
| bugs.gh_7591_test | RELEASE SAVEPOINT ONLY works incorrectly |
| bugs.gh_7598_test | Wrong detection of must-be-delimited user names |
| bugs.gh_7599_test | Conversion of text with '#x00' to DECFLOAT without errors. |
| bugs.gh_7600_test | CASE statement different result compared to FB 2.5.9 |
| 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_7627_test | The size of the database with big records becomes bigger after backup/restore |
| bugs.gh_7638_test | OVERRIDING USER VALUE should be allowed for GENERATED ALWAYS AS IDENTITY |
| bugs.gh_7642_test | Getting the current DECFLOAT ROUND/TRAPS settings |
| bugs.gh_7647_test | Regression: Error in isc_array_lookup_bounds |
| bugs.gh_7651_test | Unable to find savepoint in insert with nested query and returning clause in FB4 |
| bugs.gh_7652_test | Make the profiler store aggregated requests by default, with option for detailed store |
| bugs.gh_7664_test | DROP TABLE executed for a table with big records may lead to "wrong page type" or "end of file" error |
| bugs.gh_7665_test | Wrong result ordering in LEFT JOIN query |
| 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_7683_test | rdb$time_zone_util.transitions returns an infinite resultset |
| bugs.gh_7687_test | Add LEVEL column to PLG$PROF_RECORD_SOURCES and PLG$PROF_RECORD_SOURCE_STATS_VIEW |
| bugs.gh_7691_test | 'with caller privileges' has no effect in triggers |
| bugs.gh_7698_test | The legacy plan with window functions is broken |
| bugs.gh_7710_test | Expression index - more than one null value cause attempt to store duplicate value error |
| bugs.gh_7713_test | Stability of implicit cursor could be broken, if cursor's select expression is based on view with sub-query in select list, or on table with sub-query in computed field. |
| bugs.gh_7715_test | Alternative String Literals and multibyte (UTF8) alternatives |
| bugs.gh_7718_test | Allow to create database with different owner |
| bugs.gh_7723_test | Wrong error message on login if the user doesn't exists and WireCrypt is disabled |
| bugs.gh_7727_test | Index for integer column cannot be used when INT128/DECFLOAT value is being searched |
| bugs.gh_7729_test | "SET BIND OF TS WITH TZ TO VARCHAR(128)" uses the date format of dialect 1 |
| bugs.gh_7730_test | Server ignores the size of VARCHAR when performing SET BIND ... TO VARCHAR(N) |
| bugs.gh_7731_test | Display length of timestamp with timezone is wrong in dialect 1 |
| bugs.gh_7744_test | Provide ability to run "ALTER SQL SECURITY DEFINER / INVOKER" without specifying further part of proc/func/package |
| bugs.gh_7747_test | garbage collection in indexes and blobs is not performed in VIO_backout |
| bugs.gh_7748_test | Allow collation to be a part of data type |
| 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_7758_test | Added the ability to change function DETERMINISTIC option without recompile the entire function body |
| bugs.gh_7759_test | Routine calling overhead increased by factor 6 |
| bugs.gh_7760_test | Parameters inside the IN list may cause a string truncation error |
| bugs.gh_7761_test | Regression when displaying line number of errors in ISQL scripts |
| bugs.gh_7767_test | Slow drop trigger command execution under FB5.0 |
| bugs.gh_7772_test | Blob corruption in FB4.0.3 (embedded) |
| 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_7795_test | NOT IN <list> returns incorrect result if NULLs are present inside the value list |
| bugs.gh_7800_test | Default publication status is not preserved after backup/restore |
| bugs.gh_7804_test | The partial index is not involved when filtering conditions through OR. |
| bugs.gh_7810_test | Improve SKIP LOCKED implementation |
| bugs.gh_7818_test | Extend rdb$get_context('SYSTEM', '***') with client-related info |
| bugs.gh_7823_test | ISQL command SHOW DATABASE crashes in absence of firebird.msg |
| bugs.gh_7832_test | Firebird 5 and 6 crash on "... RETURNING * " without INTO in PSQL |
| bugs.gh_7839_test | Potential bug in BETWEEN Operator |
| bugs.gh_7844_test | Removing first column with SET WIDTH crashes ISQL |
| bugs.gh_7846_test | FB4 can't backup/restore int128-array |
| bugs.gh_7853_test | Do not consider non-deterministic expressions as invariants in pre-filters |
| bugs.gh_7854_test | Performance issue with time zones |
| bugs.gh_7860_test | Crash potentially caused by BETWEEN Operator |
| 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_7865_test | Consider the return value of deterministic functions to be invariant if all its arguments are invariant |
| bugs.gh_7879_test | Unexpected Results when Using Natural Right Join |
| bugs.gh_7886_test | ISQL sets return code to 1 for script that is called via IN command even if this script completes OK. Problem caused by presence of tail comments in the callee |
| bugs.gh_7888_test | The ability to retrieve the total number of pages in the database |
| bugs.gh_7899_test | Inconsistent state of master-detail occurs after RE-connect + 'SET AUTODDL OFF' + 'drop <FK>' which is ROLLED BACK |
| bugs.gh_7903_test | Unexpected Results when Using CASE-WHEN with LEFT JOIN |
| bugs.gh_7904_test | More realistic cardinality adjustments for unmatchable booleans // FB5 bad plan for query |
| bugs.gh_7908_test | Unexpected results when the join condition contains the OR predicate |
| bugs.gh_7916_test | Query issue conversion error from string |
| bugs.gh_7917_test | Hang in a case of error when sweep thread is attaching to database |
| 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_7927_test | Some default values is set incorrectly for SC/CS architectures |
| bugs.gh_7931_test | Incorrect variable usage using UPDATE OR INSERT |
| bugs.gh_7937_test | Inner join raises error "no current record for fetch operation" if a stored procedure depends on some table via input parameter and also has an indexed relationship with another table |
| bugs.gh_7962_test | System procedure/function inconsistency between ISQL SHOW FUNCTIONS and SHOW PROCEDURES |
| bugs.gh_7976_test | False validation error for short unpacked records |
| bugs.gh_7979_test | Hang when database with disconnect trigger using MON$ tables is shutting down |
| bugs.gh_7980_test | Option for GEN_UUID to generate v7 UUID |
| bugs.gh_7989_test | Improve performance of external (UDR) functions |
| bugs.gh_7992_test | Assertion (space > 0) failure during restore |
| bugs.gh_7993_test | Unexpected results when using CASE WHEN with RIGHT JOIN |
| bugs.gh_7995_test | Unexpected results after creating partial index |
| bugs.gh_7997_test | Unexpected results when comparing integer with string containing value out of range of that integer datatype |
| bugs.gh_7998_test | Crash during partial index checking if the condition raises a conversion error |
| bugs.gh_8015_test | Add multi-character TRIM function |
| bugs.gh_8020_test | AV when both function and dependent table are dropped in the same transaction |
| bugs.gh_8033_test | Invalid result when string compared with indexed numeric(x,y) field where x > 18 and y != 0 |
| bugs.gh_8036_test | "no current record for fetch operation" error with select stored procedures |
| bugs.gh_8056_addi_test | "Too many temporary blobs" - additional test for issuecomment-2032627160 |
| bugs.gh_8056_test | "Too many temporary blobs" with blob_append when select a stored procedue using rows-clause |
| bugs.gh_8057_test | Let optimizer automatically update empty index statistics for relatively small system tables |
| 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_8062_test | CREATE [IF NOT EXISTS] |
| bugs.gh_8063_test | (var)char variables/parameters assignments fail in Stored Procedures with subroutines |
| bugs.gh_8066_test | Make protocol schemes case-insensitive |
| 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_8078_test | SIMILAR TO with constant pattern using '|', '*', '?' or '{0,N}' doesn't work as expected |
| bugs.gh_8084_test | Partial index uniqueness violation (changes in columns participating in index filtering expression are not properly tracked). |
| bugs.gh_8085_test | Memory leak when executing a lot of different queries and StatementTimeout > 0 |
| bugs.gh_8086_test | IN predicate with string-type elements is evaluated wrongly against a numeric field |
| bugs.gh_8087_test | AV when preparing a query with IN list that contains both literals and sub-query |
| 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_8104_test | Inefficient evaluation of expressions like rdb$db_key <= ? after mass delete |
| bugs.gh_8108_test | Engine returns empty string when unable to translate Unicode symbol into ICU-codepage. |
| bugs.gh_8109_test | Plan/Performance regression when using special construct for IN in FB5.x compared to FB3.x |
| bugs.gh_8112_test | Error isc_read_only_trans (335544361) should report SQLSTATE 25006. |
| bugs.gh_8113_postfix_test | Postfix for #8113: UNION ALL optimization with constant false condition. |
| bugs.gh_8113_test | UNION ALL optimization with constant false condition |
| bugs.gh_8115_test | Avoid reading/hashing the inner stream(s) if the leader stream is empty |
| bugs.gh_8120_test | Cast dies with numeric value is out of range error |
| bugs.gh_8123_test | Procedure manipulation can lead to wrong dependencies removal |
| bugs.gh_8136_test | Server crashes with IN (dbkey1, dbkey2, ...) condition |
| bugs.gh_8161_test | Cardinality estimation should use primary record versions only |
| bugs.gh_8168_test | MAKE_DBKEY bug after backup/restore |
| bugs.gh_8176_test | Firebird hangs after starting remote profiling session |
| bugs.gh_8178_addi_test | Check result of conversion to string in COALESCE that involves all families of data types. |
| bugs.gh_8178_test | Problem with boolean conversion to string inside DataTypeUtil::makeFromList() |
| bugs.gh_8182_test | IN predicate incorrectly handles single parenthesized subquery as IN-list, instead of table subquery |
| bugs.gh_8185_test | SIGSEGV in Firebird 5.0.0.1306 embedded during update on cursor |
| bugs.gh_8187_test | Performance regression in generating of UUID values after introducing GUID-v7 |
| bugs.gh_8194_test | Internal consistency check (page in use during flush) with small number of DefaultDbCachePages |
| bugs.gh_8203_test | MAKE_DBKEY can raise 'malformed string' for some table names |
| bugs.gh_8211_test | DATEADD truncates milliseconds for month and year deltas. |
| bugs.gh_8213_test | WHEN NOT MATCHED BY SOURCE - does not work with a direct table as source |
| bugs.gh_8214_test | Incorrect result of index list scan for a composite index, the second segment of which is a text field with COLLATE UNICODE_CI |
| bugs.gh_8219_test | Database creation in 3.0.12, 4.0.5 and 5.0.1 slower than in previous releases |
| bugs.gh_8221_test | Crash when MAKE_DBKEY() is called with 0 or 1 arguments |
| 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_8230_test | Ability to obtain PID of server process for current connection without querying mon$ tables |
| 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_8241_test | gbak may lose NULLs in restore |
| 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_8253_test | Incorrect handling of non-ASCII object names in CREATE MAPPING statement |
| bugs.gh_8255_test | Catch possible stack overflow when preparing and compiling user statements |
| 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_8278_test | Avoid index lookup for a NULL key if the condition is known to always be FALSE in this case |
| bugs.gh_8290_test | "Unique scan" is incorrectly reported in the explained plan for unique index and IS NULL predicate |
| bugs.gh_8291_test | NULLs should be skipped during index navigation when there's no lower bound and matched conditions are known to ignore NULLs |
| bugs.gh_8304_test | wrong results using minvalue/maxvalue in join condition |
| bugs.gh_8309_test | Add ALTER PACKAGE BODY and CRAETE OR ALTER PACKAGE BODY parse rules |
| bugs.gh_8310_test | Collect network statistics and make it available for the user applications |
| bugs.gh_8318_test | Send blob contents in the same data stream as main resultset |
| bugs.gh_8323_test | Add AUTO RELEASE TEMP BLOBID transaction option |
| bugs.gh_8353_test | Report unique usernames for isc_info_user_names |
| bugs.gh_8356_test | Make Trace use HEX representation for parameter values of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY |
| bugs.gh_8379_test | Incorrect cardinality estimation for retrievals with multiple compound indices having common set of fields |
| bugs.gh_8386_test | Crash when creating index on table that uses UDR and ParallelWorkers > 1 |
| bugs.gh_8394_test | Make Trace use HEX representation for parameter values of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY |
| bugs.gh_8409_test | Error message "SQL -104 / Unexpected end of command" appears in a trace log when 'SET AUTOTERM ON;' is used |
| bugs.gh_8421_test | Add pointers tree to TempSpace class |
| bugs.gh_8427_test | Allow specifying exactly what type of database string is expected in the database section for trace configuration |
| bugs.gh_8429_test | Segfault when already destroyed callback interface is used |
| bugs.gh_8434_test | Fix implicitly used collations after ALTER DOMAIN |
| bugs.gh_8435_test | Error "Can not transliterate character" with text concatention utf8 + win1250 |
| bugs.gh_8437_test | Segmentation fault when running query with partition by and subquery |
| bugs.gh_8444_test | GBAK: GDS error batch_big_seg2 when restoring a table with many BLOBs |
| bugs.gh_8450_test | Slightly better checking for a valid database file |
| bugs.gh_8452_test | Disallow creation of object names with only spaces |
| bugs.gh_8454_test | incorrect behavior of FF1...FF4 patterns in CAST FORMAT for string to datetime conversion |
| bugs.gh_8462_test | A user with "GRANT_REVOKE_ON_ANY_OBJECT" privilege can't revoke a role from himself if he is not a grantor |
| bugs.gh_8469_test | Throw exception for non-existing date in string to datetime conversion |
| bugs.gh_8475_test | Wrong message about invalid time zone in CAST FORMAT |
| bugs.gh_8477_test | Inheritance of WINDOW does not work |
| bugs.gh_8488_test | MIN/MAX aggregates may badly affect the join order in queries with mixed INNER/LEFT joins |
| bugs.gh_8491_test | Fix reset of db guid in fixup |
| bugs.gh_8494_test | Fix issues with longish concatenated context aliases |
| bugs.gh_8498_test | Range-based FOR statement |
| bugs.gh_8501_test | fix(cast-format): Throw exception when value cannot be found for specific pattern in string to datetime conversion |
| bugs.gh_8508_test | Conversion Error with old.field in UPDATE OR INSERT |
| bugs.gh_8513_test | Makes MON$COMPILED_STATEMENTS and MON$STATEMENTS share blobs with text and plan content of the same statement |
| bugs.gh_8520_test | Error in iTransaction.getInfo() on embedded connection |
| bugs.gh_8532_test | GREATEST and LEAST (SQL:2023 - T054) |
| bugs.gh_8553_test | Get the modification time of a config file with a higher precision to fix cases when it's not reloaded after modification/replacement |
| bugs.gh_8554_test | Firebird XDR Message Parsing NULL Pointer Dereference Denial-of-Service Vulnerability |
| bugs.gh_8579_test | Add sub routines info in the BLR debug blob filter |
| bugs.gh_8589_test | PERCENT_RANK may return NaN instead of 0 |
| bugs.gh_8592_test | Presence of 'ROWS <n_limit>' causes garbage in error message when string conversion problem raises |
| bugs.gh_8595_test | Unable to restore database to Firebird 6.0 (with schemas) from ODS 13.1 if database contains views with system tables used in subqueries |
| bugs.gh_8597_test | Unable to restore database to Firebird 6.0 (with schemas) from ODS 13.1 if database contains views with system tables used in subqueries |
| bugs.gh_8598_test | Don't fire referential integrity triggers if primary or unique keys haven't changed |
| bugs.gh_8601_test | Charset and collation are not found in the search path when altering a table (FB 6.0 SQL schemas) |
| bugs.gh_8618_test | Extra quotes in plan when using UNLIST function |
| bugs.gh_8619_test | Regression in 6.0.0.653 ("Stack overflow. ... requirements of the runtime stack have exceeded the memory"). |
| bugs.gh_8625_test | Range based FOR is broken with a DO SUSPEND without BEGIN...END |
| bugs.gh_8628_test | Incorrect join order for JOIN LATERAL with UNION referencing the outer stream(s) via its select list |
| bugs.gh_8649_test | AV when ON CONNECT triggers uses EXECUTE STATEMENT ON EXTERNAL |
| bugs.gh_8653_test | TRANSACTION_ROLLBACK missing in the trace log when appropriate DB-level trigger fires |
| bugs.gh_8661_test | Strange output from SHOW DEPENDENCIES command on 6.0 |
| bugs.gh_8663_test | Problem with restore time when DB has many indices (possible regression in 6.x) |
| bugs.gh_8665_test | SHOW DEPENDENCIES command terminates unexpectedly if there are packages in the dependencies |
| bugs.gh_8666_test | Crash after calling incorrectly parametrized request |
| bugs.gh_8673_test | Error unable to allocate memory from operating system |
| bugs.gh_8681_test | Regression in 6.x: COALESCE(<non_empty_arg_1>, <non_empty_arg_2>) can return empty string |
| bugs.gh_8690_test | Check diagnostic message and errorlevel when ISQL is launched with "< nul" |
| bugs.gh_8701_test | Unable to select from a view which was created using 'CREATE VIEW (<column_name>)' if connection charset = utf8 and query returns [var]char |
| bugs.gh_8710_test | Filters do not have schemas |
| bugs.gh_8711_test | Regression in FB 6.x for plan in legacy form: excessive comma (",") between items of <schema.index> list |
| bugs.gh_8718_test | Incorrect result using UNLIST and 2 CTE |
| bugs.gh_8722_test | The "IF NOT EXISTS" clause is missing for DECLARE FILTER |
| bugs.gh_8732_test | Add support of the IN <list> predicate to the equality distribution logic |
| bugs.gh_8737_test | "Statement 0, <unknown, bug?>" in trace |
| bugs.gh_8739_test | Wrong SQLSTATE in case of table alias conflict |
| bugs.gh_8746_test | Allow isc_tpb_read_consistency to imply read committed |
| bugs.gh_8749_addi_test | RDB$RECORD_VERSION has wrong value when is used in BEFORRE trigger and RETURNING INTO. |
| bugs.gh_8749_test | Computed index on RDB$RECORD_VERSION don't work as expected |
| bugs.gh_8768_test | Support bitwise aggregate functions (BIN_AND_AGG, BIN_OR_AGG, BIN_XOR_AGG) |
| bugs.gh_8773_test | Gstat output of tables does not include schema name |
| bugs.gh_8774_test | Gstat -table will only report one matching table |
| bugs.gh_8794_test | Called procedure parameter changes during execution without assignment when deleting from updatable view |
| bugs.gh_8799_test | BUGCHECK "decompression overran buffer (179)" when WITH LOCK clause is used |
| bugs.gh_8805_test | Regression in 6.x: query with "... where <field> in ( <scalar_value> | <scalar_func>, null )" returns empty rowset instead of existing record. |
| bugs.gh_8806_test | Missing privilege checks for the COMMENT ON PARAMETER command on functions in packages |
| bugs.gh_8815_test | Restore the broken record layout optimization by gbak and extend it to the new datatypes |
| bugs.gh_8820_test | Missing a column name for boolean expression |
| bugs.gh_8821_test | REGRESSION: natural plan instead of primary/unique index |
| bugs.gh_8822_test | Some procedures containing LIST aggregate function are not restored in Firebird 6.0 if backup was made in 5.0 |
| bugs.gh_8836_test | Regression: Aggregate function ANY_VALUE always returns NULL |
| bugs.gh_8842_test | GTT accept weird syntax and has unnecessary syntax conflicts. |
| bugs.gh_8851_test | 'Internal error' when calling outer procedure after deleting unused result variable from inner procedure |
| bugs.gh_8871_test | Fix locking error if IN/EXISTS is converted into a semi-join |
| bugs.gh_8881_test | Large amount of unnecessary privileges in RDB$USER_PRIVILEGES for SYSDBA |
| bugs.gh_8885_test | AV when lock manager settings is misconfigured |
| bugs.gh_8890_test | WITH TIME ZONE types store non-zero garbage for padding instead of 0x00. |
| bugs.gh_8891_test | Regression. Result of cross join of two procedures + unioned with common datasource (e.g. rdb$database) is wrong |
| bugs.gh_8902_test | FULL OUTER JOIN does not use indexes with the derived table |
| bugs.gh_8911_test | Wrong result in case of SubQueryConversion = true |
| bugs.gh_8914_test | SELECT with multiple EXISTS sub-queries fails in case of SubQueryConversion = true |
| bugs.gh_8920_test | Can not ALTER VIEW if it was created using function in its query and name of column changed |
| bugs.gh_8926_test | Indexes may not be used for multiple ORed conditions containing both field and non-field references |
| bugs.gh_8933_test | Isql SHOW PROCEDURE/FUNCTION doesn't show NOT NULL status for parameters |
| bugs.gh_8945_test | ALTER COLUMN <BOOL_COL> TYPE [VAR]CHAR must be allowed |
| functional.arno.derived_tables.test_01 | Simple derived table |
| functional.arno.derived_tables.test_02 | Unnamed (no relation alias) derived table |
| functional.arno.derived_tables.test_03 | Explicit column names for derived table |
| functional.arno.derived_tables.test_04 | Derived table column names must be unique |
| functional.arno.derived_tables.test_05 | Derived table column names must be unique |
| functional.arno.derived_tables.test_06 | Outer reference inside derived table to other relations in from clause is not allowed |
| functional.arno.derived_tables.test_07 | Outer reference inside derived table to other relations in from clause is not allowed |
| functional.arno.derived_tables.test_08 | Outer reference inside derived table to other relations in from clause is not allowed |
| functional.arno.derived_tables.test_09 | Outer reference inside derived table to other relations in from clause is not allowed |
| functional.arno.derived_tables.test_10 | Outer reference to upper scope-level is allowed |
| functional.arno.derived_tables.test_11 | Outer reference to upper scope-level is allowed |
| functional.arno.derived_tables.test_12 | Outer reference to upper scope-level is allowed |
| functional.arno.derived_tables.test_13 | DISTINCT inside derived table |
| functional.arno.derived_tables.test_14 | FIRST / SKIP inside derived table |
| functional.arno.derived_tables.test_15 | UNION inside derived table |
| functional.arno.derived_tables.test_16 | Simple derived table with aggregate inside |
| functional.arno.derived_tables.test_17 | Aggregate inside derived table |
| functional.arno.derived_tables.test_18 | Aggregate inside derived table |
| functional.arno.derived_tables.test_19 | Sub-select inside derived table |
| functional.arno.derived_tables.test_20 | Sub-select inside derived table |
| functional.arno.derived_tables.test_21 | Implicit derived table by IN predicate |
| functional.arno.derived_tables.test_22 | Derived table outer reference (triggers) |
| functional.arno.derived_tables.test_23 | Derived table with outer reference from JOIN. |
| functional.arno.derived_tables.test_24 | Derived table with outer reference from LEFT JOIN. |
| functional.arno.derived_tables.test_25 | Derived table with outer reference from FULL JOIN. |
| functional.arno.derived_tables.test_26 | Derived table with column that is specified several times |
| functional.arno.derived_tables.test_27 | Derived table with same alias for several columns |
| functional.arno.indices.test_lower_bound_asc_02_segments_01 | ASC 2-segment index lower bound |
| functional.arno.indices.test_lower_bound_desc_02_segments_01 | DESC 2-segment index lower bound |
| functional.arno.indices.test_starting_with_01 | STARTING WITH charset NONE |
| functional.arno.indices.test_starting_with_02 | STARTING WITH charset ISO8859_1 |
| functional.arno.indices.test_timestamps_01 | TIMESTAMP in index with values below julian date |
| functional.arno.indices.test_upper_bound_asc_01_segments_01 | ASC single segment index upper bound |
| functional.arno.indices.test_upper_bound_asc_01_segments_02 | ASC single segment index upper bound |
| functional.arno.indices.test_upper_bound_asc_01_segments_03 | ASC single segment index upper bound |
| functional.arno.indices.test_upper_bound_asc_01_segments_04 | ASC single segment index upper bound |
| functional.arno.indices.test_upper_bound_asc_02_segments_01 | ASC 2-segment index upper bound |
| functional.arno.indices.test_upper_bound_desc_01_segments_01 | DESC single segment index upper bound |
| functional.arno.indices.test_upper_bound_desc_01_segments_02 | DESC single segment index upper bound |
| functional.arno.indices.test_upper_bound_desc_02_segments_01 | DESC 2-segment index upper bound |
| functional.arno.indices.test_upper_lower_bounds_01 | Upper and lower bounds |
| functional.arno.indices.test_upper_lower_bounds_02 | Upper and lower bounds |
| functional.arno.optimizer.test_opt_aggregate_distribution_01 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
| functional.arno.optimizer.test_opt_aggregate_distribution_02 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
| functional.arno.optimizer.test_opt_aggregate_distribution_03 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
| functional.arno.optimizer.test_opt_aggregate_distribution_04 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
| functional.arno.optimizer.test_opt_aggregate_distribution_05 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
| functional.arno.optimizer.test_opt_aggregate_distribution_06 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
| functional.arno.optimizer.test_opt_aggregate_distribution_07 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
| functional.arno.optimizer.test_opt_aggregate_distribution_08 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
| functional.arno.optimizer.test_opt_aggregate_distribution_09 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
| functional.arno.optimizer.test_opt_aggregate_distribution_10 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
| functional.arno.optimizer.test_opt_aggregate_distribution_11 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
| functional.arno.optimizer.test_opt_aggregate_distribution_12 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
| functional.arno.optimizer.test_opt_aggregate_distribution_13 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
| functional.arno.optimizer.test_opt_aggregate_distribution_14 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
| functional.arno.optimizer.test_opt_avoid_index_usage | AVOID index usage in WHERE <indexed_varchar_field> = <integer_value> |
| functional.arno.optimizer.test_opt_full_join_01 | FULL OUTER JOIN, list all values |
| functional.arno.optimizer.test_opt_full_join_02 | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
| functional.arno.optimizer.test_opt_full_join_03 | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
| functional.arno.optimizer.test_opt_full_join_04 | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
| functional.arno.optimizer.test_opt_inner_join_01 | INNER JOIN join order |
| functional.arno.optimizer.test_opt_inner_join_02 | INNER JOIN join order |
| functional.arno.optimizer.test_opt_inner_join_03 | INNER JOIN join order |
| functional.arno.optimizer.test_opt_inner_join_04 | INNER JOIN join order LIKE and IS NULL |
| functional.arno.optimizer.test_opt_inner_join_05 | INNER JOIN join order LIKE and STARTING WITH |
| functional.arno.optimizer.test_opt_inner_join_06 | INNER JOIN join order and VIEW |
| functional.arno.optimizer.test_opt_inner_join_07 | INNER JOIN join order and VIEW |
| functional.arno.optimizer.test_opt_inner_join_08 | INNER JOIN join order and VIEW |
| functional.arno.optimizer.test_opt_inner_join_09 | INNER JOIN join order and distribution |
| functional.arno.optimizer.test_opt_inner_join_10 | INNER JOIN join order |
| functional.arno.optimizer.test_opt_inner_join_merge_01 | INNER JOIN join merge |
| functional.arno.optimizer.test_opt_inner_join_merge_02 | INNER JOIN join merge |
| functional.arno.optimizer.test_opt_inner_join_merge_03 | INNER JOIN join merge |
| functional.arno.optimizer.test_opt_inner_join_merge_04 | INNER JOIN join merge and NULLs |
| functional.arno.optimizer.test_opt_inner_join_merge_05 | INNER JOIN join merge and VIEWs |
| functional.arno.optimizer.test_opt_inner_join_merge_06 | INNER JOIN join merge and SP |
| functional.arno.optimizer.test_opt_left_join_01 | LEFT OUTER JOIN with no match at all |
| functional.arno.optimizer.test_opt_left_join_02 | LEFT OUTER JOIN with no match and IS NULL in WHERE clause |
| functional.arno.optimizer.test_opt_left_join_03 | LEFT OUTER JOIN with full match and reference in WHERE clause |
| functional.arno.optimizer.test_opt_left_join_04 | LEFT OUTER JOIN with full match |
| functional.arno.optimizer.test_opt_left_join_05 | LEFT OUTER JOIN with full match, but limited in ON clause |
| functional.arno.optimizer.test_opt_left_join_06 | LEFT OUTER JOIN with full match, but limited in ON clause |
| functional.arno.optimizer.test_opt_left_join_07 | 4 JOINed tables with 1 LEFT OUTER JOIN |
| functional.arno.optimizer.test_opt_left_join_08 | LEFT OUTER JOIN with full match, but limited in ON and WHERE clause |
| functional.arno.optimizer.test_opt_left_join_09 | LEFT OUTER JOIN with full match, but limited in ON and WHERE clause |
| functional.arno.optimizer.test_opt_left_join_10 | LEFT OUTER JOIN with IS NULL burried in WHERE clause |
| functional.arno.optimizer.test_opt_left_join_11 | LEFT OUTER JOIN with STARTING WITH in WHERE clause |
| functional.arno.optimizer.test_opt_left_join_12 | LEFT OUTER JOIN with distribution CASE |
| functional.arno.optimizer.test_opt_left_join_13 | LEFT OUTER JOIN VIEW with full match |
| functional.arno.optimizer.test_opt_mixed_joins_01 | Mixed JOINS |
| functional.arno.optimizer.test_opt_mixed_joins_02 | Mixed JOINS |
| functional.arno.optimizer.test_opt_mixed_joins_03 | Mixed JOINS |
| functional.arno.optimizer.test_opt_mixed_joins_04 | Mixed JOINS |
| functional.arno.optimizer.test_opt_mixed_joins_05 | Mixed JOINS |
| functional.arno.optimizer.test_opt_mixed_joins_06 | Mixed JOINS |
| functional.arno.optimizer.test_opt_multi_index_selection_01 | Unique index selection (multi segment) |
| functional.arno.optimizer.test_opt_multi_index_selection_02 | Best match index selection (multi segment) |
| functional.arno.optimizer.test_opt_multi_index_selection_03 | Best match index selection (multi segment) |
| functional.arno.optimizer.test_opt_multi_index_selection_04 | Best match index selection (multi segment) |
| functional.arno.optimizer.test_opt_multi_index_selection_05 | Best match index selection (multi segment) |
| functional.arno.optimizer.test_opt_multi_index_selection_06 | Best match index selection (multi segment) |
| functional.arno.optimizer.test_opt_multi_index_selection_07 | Best match index selection (multi segment) |
| functional.arno.optimizer.test_opt_multi_index_selection_08 | Best match index selection (multi segment) |
| functional.arno.optimizer.test_opt_selectivity_01 | SELECTIVITY - SET STATISTICS |
| functional.arno.optimizer.test_opt_selectivity_02 | SELECTIVITY - CREATE INDEX |
| functional.arno.optimizer.test_opt_selectivity_03 | SELECTIVITY - INDEX INACTIVE / ACTIVE |
| functional.arno.optimizer.test_opt_single_index_selection_01 | Unique index selection (single segment) |
| functional.arno.optimizer.test_opt_single_index_selection_02 | Best match index selection (single segment) |
| functional.arno.optimizer.test_opt_single_index_selection_03 | Best match index selection (single segment) |
| functional.arno.optimizer.test_opt_single_index_selection_04 | Best match index selection (single segment) |
| functional.arno.optimizer.test_opt_single_index_selection_05 | Best match index selection (single segment) ASC and DESC |
| functional.arno.optimizer.test_opt_single_index_selection_06 | Best match index selection (single segment) |
| functional.arno.optimizer.test_opt_single_index_selection_07 | Best match index selection (single segment) |
| functional.arno.optimizer.test_opt_single_index_selection_08 | Best match index selection (single segment) |
| functional.arno.optimizer.test_opt_single_index_selection_09 | Best match index selection (single segment) OR |
| functional.arno.optimizer.test_opt_single_index_selection_10 | Best match index selection (single segment) OR |
| functional.arno.optimizer.test_opt_single_index_selection_11 | Best match index selection (single segment) |
| functional.arno.optimizer.test_opt_sort_by_index_01 | ORDER BY ASC using index (unique) |
| functional.arno.optimizer.test_opt_sort_by_index_02 | ORDER BY DESC using index (unique) |
| functional.arno.optimizer.test_opt_sort_by_index_03 | ORDER BY ASC using index (non-unique) |
| functional.arno.optimizer.test_opt_sort_by_index_04 | ORDER BY DESC using index (non-unique) |
| functional.arno.optimizer.test_opt_sort_by_index_05 | MAX() and DESC index (non-unique) |
| functional.arno.optimizer.test_opt_sort_by_index_06 | MAX() and ASC index (non-unique) |
| functional.arno.optimizer.test_opt_sort_by_index_07 | MIN() and ASC index (non-unique) |
| functional.arno.optimizer.test_opt_sort_by_index_08 | MIN() and DESC index (non-unique) |
| functional.arno.optimizer.test_opt_sort_by_index_09 | ORDER BY ASC using index (non-unique) |
| functional.arno.optimizer.test_opt_sort_by_index_10 | ORDER BY ASC using index (multi) |
| functional.arno.optimizer.test_opt_sort_by_index_11 | ORDER BY ASC using index (multi) |
| functional.arno.optimizer.test_opt_sort_by_index_12 | ORDER BY ASC, DESC using index (multi) |
| functional.arno.optimizer.test_opt_sort_by_index_13 | ORDER BY ASC using index (multi) |
| functional.arno.optimizer.test_opt_sort_by_index_14 | ORDER BY ASC NULLS FIRST using index |
| functional.arno.optimizer.test_opt_sort_by_index_15 | ORDER BY ASC NULLS LAST using index |
| functional.arno.optimizer.test_opt_sort_by_index_16 | ORDER BY DESC NULLS FIRST using index |
| functional.arno.optimizer.test_opt_sort_by_index_17 | ORDER BY DESC NULLS LAST using index |
| functional.arno.optimizer.test_opt_sort_by_index_18 | ORDER BY ASC using index (single) and WHERE clause |
| functional.arno.optimizer.test_opt_sort_by_index_19 | ORDER BY ASC using index (multi) and WHERE clause |
| functional.basic.isql.test_00 | Check output of "HELP" and "HELP SET" commands |
| functional.basic.isql.test_01 | ISQL: check output of 'SHOW DATABASE' and 'SHOW DB' |
| functional.basic.isql.test_02 | ISQL - SHOW SYSTEM TABLES |
| functional.basic.isql.test_03 | ISQL - SHOW SYSTEM parameters |
| functional.basic.isql.test_05 | ISQL should be able to process single statement with length up to 10*1024*1024 chars |
| functional.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_02 | SET AUTOTERM ON/OFF. Ability to handle long DDL in one line without 'set term'. |
| functional.basic.isql.test_autoterm_03 | SET AUTOTERM ON/OFF. Additional tests. |
| functional.blob.test_blob_over_4gb | Check ability to operate with blob with size greater than 4Gb |
| functional.blob.test_rdb_blob_util_basic | Basic test of RDB$BLOB_UTIL package functionality |
| functional.blob.test_read_blob_in_multiple_cursors | Ability to read same blob_id using multiple cursors |
| functional.blob.test_small_blob_caching | Operations with inline streamed blobs when boundary values are used for seek() and read() methods. |
| functional.database.create.test_00 | Verify ability to create database with different values of PAGE_SIZE |
| functional.database.create.test_01 | Create database: set names and default character set |
| functional.database.create.test_02 | Create database: non sysdba user |
| functional.database.create.test_11 | Create database: Default char set NONE |
| functional.database.create.test_13 | Create database: check that actual FW setting is ON for just created database. |
| functional.datatypes.test_decfloat_binding_to_legacy | Test ability for DECFLOAT values to be represented as other data types using LEGACY keyword. |
| functional.datatypes.test_decfloat_binding_to_other_types | Test ability for DECFLOAT values to be represented as other data types (char, double, bigint). |
| functional.datatypes.test_decfloat_boundary_values | Check BOUNDARY values that are defined for DECFLOAT datatype |
| functional.datatypes.test_decfloat_columns_handlng | Check ability of misc. actions against table column for DECFLOAT datatype |
| functional.datatypes.test_decfloat_ddl_indices | Check ability to create table with 16 fields of type decfloat(34), plus create indices and add data |
| functional.datatypes.test_decfloat_df16_alignment | Check proper alignment of decfloat(16) value if it is shown in ISQL when SET LIST ON |
| functional.datatypes.test_decfloat_exceptions_trapping | Test exception trapping for result of DECFLOAT operations |
| functional.datatypes.test_decfloat_literal_interpr | Test interpretation of numeric literals |
| functional.datatypes.test_decfloat_literal_length | Literal length currently is limited with 1024 characters (including decimal separator and minus sign if any) |
| functional.datatypes.test_decfloat_loose_accuracy | Test for preseving accuracy when evaluate sum of values with huge difference in magnitude |
| functional.datatypes.test_decfloat_min_distinguish | List of all values starting from 1.0 divided by 2, until previous and current become equal |
| functional.datatypes.test_decfloat_nan_and_infinity_comparison | DECFLOAT should not throw exceptions when +/-NaN, +/-sNaN and +/-Infinity is used in comparisons |
| functional.datatypes.test_decfloat_ordering_rules | Test ordering of decfloat values |
| functional.datatypes.test_decfloat_parsing_scaled_integers_and_bigint_max_min | Interpretation of DECFLOAT values as BIGINT |
| functional.datatypes.test_decfloat_round_modes | Check validity of different ROUNDING modes that are defined for DECFLOAT datatype |
| functional.datatypes.test_decfloat_scalar_functions | Test common math functions that should work with DECFLOAT datatype |
| functional.datatypes.test_decfloat_single_bit_in_representation | Check result of EXP() which can be represented only by one ("last") significant bit |
| functional.datatypes.test_decfloat_special_functions | Test functions that are designed specially for DECFLOAT handling |
| functional.datatypes.test_decimal_declared_scale | Dummy test |
| functional.datatypes.test_double_min_distinguish | List of all values starting from 1.0 divided by 2, until previous and current become equal |
| functional.datatypes.test_int128_agregate_functions | Basic test for aggregation functions against INT128 datatype |
| functional.datatypes.test_int128_binary_operations | Basic test for binary functions against INT128 datatype |
| functional.datatypes.test_int128_math_functions | Basic test for math functions against INT128 datatype |
| functional.datatypes.test_miscelan_binding | Test ability for DECFLOAT values to be represented as other data types using LEGACY keyword. |
| functional.datatypes.test_varchar_with_default_length | Check ability to specify 'varchar' data type WITHOUT length and create DB objects with referencing to such types. |
| functional.dml.cte.test_01 | Non-Recursive CTEs |
| functional.dml.cte.test_02 | Recursive CTEs |
| functional.dml.delete.test_01 | DELETE |
| functional.dml.delete.test_02 | DELETE with WHERE |
| functional.dml.delete.test_03 | DELETE from VIEW |
| functional.dml.insert.test_01 | INSERT with Defaults |
| functional.dml.join.test_01 | NAMED COLUMNS join |
| functional.dml.join.test_02 | NATURAL join |
| functional.dml.merge.test_01 | MERGE statement |
| functional.dml.merge.test_02 | MERGE statement can have only one RETURNING which must be after all WHEN sub-statements |
| functional.dml.merge.test_03 | MERGE ... RETURNING must refer either ALIAS of the table (if it is defined) or context variables OLD and NEW |
| functional.dml.skip_locked.test_skip_locked_basic | Basic check of SKIP LOCKED |
| functional.dml.update_or_insert.test_01 | UPDATE OR INSERT |
| functional.dml.update_or_insert.test_02 | UPDATE OR INSERT |
| functional.dml.update_or_insert.test_03 | UPDATE OR INSERT |
| functional.domain.alter.test_01 | ALTER DOMAIN - SET DEFAULT |
| functional.domain.alter.test_02 | ALTER DOMAIN - DROP DEFAULT |
| functional.domain.alter.test_03 | ALTER DOMAIN - ADD CONSTRAINT |
| functional.domain.alter.test_04 | ALTER DOMAIN - DROP CONSTRAINT |
| functional.domain.alter.test_05 | ALTER DOMAIN - Alter domain that doesn't exists |
| functional.domain.create.test_41 | CREATE DOMAIN - create two domain with same name |
| functional.domain.create.test_42 | CREATE DOMAIN - domain name equal to existing datatype |
| functional.domain.create.test_54 | Use of domains for Trigger/SP variable definition |
| functional.domain.create.test_all_datatypes_basic | CREATE DOMAIN - basic checks |
| functional.domain.drop.test_01 | DROP DOMAIN |
| functional.domain.drop.test_02 | DROP DOMAIN - in use |
| functional.domain.drop.test_03 | DROP DOMAIN - that doesn't exists |
| functional.exception.alter.test_01 | ALTER EXCEPTION |
| functional.exception.create.test_01 | CREATE EXCEPTION |
| functional.exception.create.test_02 | CREATE EXCEPTION - try create Exception with the same name |
| functional.exception.create.test_03 | CREATE EXCEPTION - too long message |
| functional.exception.drop.test_01 | DROP EXCEPTION |
| functional.exception.drop.test_02 | DROP EXCEPTION |
| functional.exception.drop.test_03 | DROP EXCEPTION - that doesn't exists |
| functional.exception.test_handling_name_and_message | Context variables EXCEPTION and ERROR_MESSAGE for ability to log exception info (including call stack!) on server side |
| functional.fkey.cascade.test_cascade_recursive_actions | Cyclic references between PK and FK (declared with 'ON ... CASCADE') must not cause infinite loop when records are deleted or updated in any of involved tables. |
| functional.fkey.cascade.test_master_pk_delete_if_no_cascade | Attempt to delete record in master must fail if there is FK record in detail and FK was declared without CASCADE option |
| functional.fkey.cascade.test_master_pk_on_delete_cascade | Deleting record in master must cause deletions in appropriate detail if FK references to PK and 'ON DELETE CASCADE' option is used. |
| functional.fkey.cascade.test_master_pk_on_update_cascade | Updating PK column(s) in master must cause changes in appropriate detail column(s) if FK references to PK and 'ON UPDATE CASCADE' option is used |
| functional.fkey.cascade.test_master_pk_update_if_no_cascade | Attempt to update PK column(s) in master must fail if there is FK record in detail and FK was declared without CASCADE option |
| functional.fkey.cascade.test_master_uk_delete_if_no_cascade | Attempt to delete record in master with UK must fail if there is FK record in detail and FK was declared without CASCADE option |
| functional.fkey.cascade.test_master_uk_on_update_cascade | Updating PK column(s) in master must cause changes in appropriate detail column(s) if 'ON UPDATE CASCADE' option is used |
| functional.fkey.cascade.test_master_uk_update_if_no_cascade | Attempt to update UK column(s) in master must fail if there is FK record in detail and FK was declared without CASCADE option |
| functional.fkey.common.test_dml_in_detail_if_no_parent_exists | FK-columns columns in the child table must either all be equal to appropriate columns in the parent or some/all of them must be null |
| functional.fkey.common.test_non_priv_user_access_to_child_for_cascade | Child table must be updated even if current user has no privileges on it but 'CASCADE' present in FK declaration. |
| functional.fkey.common.test_non_priv_user_access_to_child_for_set_default | Child table must be updated even if current user has no privileges on it but 'SET DEFAULT' present in FK declaration. |
| functional.fkey.common.test_non_priv_user_access_to_child_for_set_null | Child table must be updated even if current user has no privileges on it but 'SET NULL' present in FK declaration. |
| functional.fkey.common.test_prohibit_change_of_key_column_types | Attempt to change type of any column involved in PK/FK constraints must fail. |
| functional.fkey.common.test_restrictions_for_default_fk_fields | FK definition: SET DEFAULT clause should not lead FK-columns to have their default values if parent record not yet exists or was removed |
| functional.fkey.common.test_restrictions_for_diff_table_types | Tables involved in referential integrity have to meet restrictions when their types differ (persistent vs GTT; connection-bound vs transaction-bound). |
| functional.fkey.common.test_restrictions_for_not_null_fk_fields | FK definition: SET NULL clause should not lead FK-columns to have NULLs. |
| functional.fkey.primary.test_insert_pk_01 | Check correct work fix with foreign key |
| functional.fkey.primary.test_insert_pk_02 | Check correct work fix with foreign key |
| functional.fkey.primary.test_insert_pk_03 | Check correct work fix with foreign key |
| functional.fkey.primary.test_insert_pk_04 | Check correct work fix with foreign key |
| functional.fkey.primary.test_insert_pk_05 | Detail Tx should be able to insert data that matches to newly added PK if master Tx has committed. |
| functional.fkey.primary.test_insert_pk_06 | Check correct work fix with foreign key |
| functional.fkey.primary.test_insert_pk_07 | Check correct work fix with foreign key |
| functional.fkey.primary.test_insert_pk_08 | Check correct work fix with foreign key |
| functional.fkey.primary.test_insert_pk_09 | Check correct work fix with foreign key |
| functional.fkey.primary.test_insert_pk_10 | Check correct work fix with foreign key |
| functional.fkey.primary.test_insert_pk_11 | Check correct work fix with foreign key |
| functional.fkey.primary.test_insert_pk_12 | Check correct work fix with foreign key |
| functional.fkey.primary.test_insert_pk_13 | Check correct work fix with foreign key |
| functional.fkey.primary.test_insert_pk_14 | Check correct work fix with foreign key |
| functional.fkey.primary.test_insert_pk_15 | Check correct work fix with foreign key |
| functional.fkey.primary.test_insert_pk_16 | Check correct work fix with foreign key |
| functional.fkey.primary.test_insert_pk_17 | Check correct work fix with foreign key |
| functional.fkey.primary.test_insert_pk_18 | Check correct work fix with foreign key |
| functional.fkey.primary.test_insert_pk_19 | Check correct work fix with foreign key |
| functional.fkey.primary.test_select_pk_01 | Check correct work fix with foreign key |
| functional.fkey.primary.test_select_pk_02 | Check correct work fix with foreign key |
| functional.fkey.primary.test_upd_pk_01 | Check correct work fix with foreign key |
| functional.fkey.primary.test_upd_pk_02 | Check correct work fix with foreign key |
| functional.fkey.unique.test_insert_01 | Check correct work fix with foreign key |
| functional.fkey.unique.test_insert_02 | Check correct work fix with foreign key |
| functional.fkey.unique.test_insert_03 | Check correct work fix with foreign key |
| functional.fkey.unique.test_insert_04 | Check correct work fix with foreign key |
| functional.fkey.unique.test_insert_05 | Check correct work fix with foreign key |
| functional.fkey.unique.test_insert_06 | Check correct work fix with foreign key |
| functional.fkey.unique.test_insert_07 | Check correct work fix with foreign key |
| functional.fkey.unique.test_insert_08 | Check correct work fix with foreign key |
| functional.fkey.unique.test_insert_09 | Check correct work fix with foreign key |
| functional.fkey.unique.test_insert_11 | Check correct work fix with foreign key |
| functional.fkey.unique.test_insert_12 | Check correct work fix with foreign key |
| functional.fkey.unique.test_insert_13 | Check correct work fix with foreign key |
| functional.fkey.unique.test_insert_14 | Check correct work fix with foreign key |
| functional.fkey.unique.test_select_uf_01 | Check correct work fix with foreign key |
| functional.fkey.unique.test_select_uf_02 | Check correct work fix with foreign key |
| functional.fkey.unique.test_upd_01 | Check correct work fix with foreign key |
| functional.fkey.unique.test_upd_02 | Check correct work fix with foreign key |
| functional.generator.alter.test_01 | ALTER SEQUENCE |
| functional.generator.create.test_01 | CREATE GENERATOR and query related data from RDB$GENERATORS |
| functional.generator.create.test_02 | CREATE GENERATOR - try create gen with same name |
| functional.generator.drop.test_01 | DROP GENERATOR |
| functional.generator.drop.test_02 | DROP GENERATOR - in use |
| functional.generator.drop.test_03 | DROP GENERATOR - generator does not exists |
| functional.gtcs.test_cast_datatypes | Check result or CAST() for misc agruments // from GTCS. |
| functional.gtcs.test_computed_fields_01 | Computed fields |
| functional.gtcs.test_computed_fields_02 | Computed fields |
| functional.gtcs.test_computed_fields_03 | Computed fields |
| functional.gtcs.test_computed_fields_04 | Computed fields |
| functional.gtcs.test_computed_fields_05 | Computed fields |
| functional.gtcs.test_computed_fields_06 | Computed fields |
| functional.gtcs.test_computed_fields_07 | Computed fields |
| functional.gtcs.test_computed_fields_08 | Computed fields |
| functional.gtcs.test_computed_fields_09 | Computed fields |
| functional.gtcs.test_computed_fields_10 | Computed fields |
| functional.gtcs.test_computed_fields_11 | Computed fields |
| functional.gtcs.test_computed_fields_12 | Computed fields |
| functional.gtcs.test_computed_fields_13 | Computed fields |
| functional.gtcs.test_computed_fields_14 | Computed fields |
| functional.gtcs.test_computed_fields_15 | Computed fields |
| functional.gtcs.test_computed_fields_16 | Computed fields |
| functional.gtcs.test_computed_fields_17 | Computed fields |
| functional.gtcs.test_conversion_error_from_string | Script issues conversion error from string |
| functional.gtcs.test_crash_of_group_by_varchar_4000 | Crash on attempt to GROUP BY on table with varchar(4000) field |
| functional.gtcs.test_cursors | Test of CURSOR functionality |
| functional.gtcs.test_division_by_zero_corrupts_db | Zero divide in SP can crash database when call this SP several times |
| functional.gtcs.test_dsql_domain_01 | Test the level 0 syntax for SQL create domain defining only the datatype |
| functional.gtcs.test_dsql_domain_02 | Test the level 0 syntax for SQL "CREATE DOMAIN" statement using datatype and DEFAULT clauses |
| functional.gtcs.test_dsql_domain_03 | Test the level 0 syntax for SQL "CREATE DOMAIN" statement using datatype and NOT NULL constraint |
| functional.gtcs.test_dsql_domain_04 | Test the level 0 syntax for SQL "CREATE DOMAIN" statement using datatype and CHECK constraint clause |
| functional.gtcs.test_dsql_domain_06 | Test the level 0 syntax for SQL "CREATE DOMAIN" statement using datatype and CHECK constraint clause. |
| functional.gtcs.test_dsql_domain_07 | Test CREATE / ALTER domain statement with ADD/DROP CONSTRAINT clauses, together and separately. |
| functional.gtcs.test_dsql_domain_12 | Verify result of INSERT DEFAULT VALUES into a table with domain fields when domains are defined with DEFAULT value. |
| functional.gtcs.test_dsql_domain_13 | Verify result of INSERT DEFAULT for domain-based fields which have their own default values |
| functional.gtcs.test_dsql_domain_15 | Verify result of INSERT DEFAULT for domain-based fields which are declared as NOT NULL and have their own default values |
| functional.gtcs.test_dsql_domain_20 | Verify result of ALTER DOMAIN SET/DROP DEFAULT when a table exists with field based on this domain |
| functional.gtcs.test_dsql_domain_21 | Verify result of ALTER DOMAIN with changing DEFAULT values and DROP constraints when a table exists with field based on this domain |
| functional.gtcs.test_dsql_domain_22 | Verify result of ALTER DOMAIN with changing NOT NULL flag and CHECK constraints when a table exists with field based on this domain |
| functional.gtcs.test_execute_statement_within_procedure | EXECUTE STATEMENT within a stored procedure could lead to a problems |
| functional.gtcs.test_external_file_03_d | Test for external table with field of SMALLINT datatype |
| functional.gtcs.test_external_file_04_d | est for external table with field of INTEGER datatype |
| functional.gtcs.test_external_file_04_d_bigint | Test for external table with field of BIGINT datatype |
| functional.gtcs.test_external_file_04_d_int128 | Test for external table with field of INT128 datatype |
| functional.gtcs.test_external_file_06_d | Test for external table with field of DOUBLE PRECISION datatype |
| functional.gtcs.test_external_file_09_d | Test for external table with field of DATE datatype |
| functional.gtcs.test_fb_sql_for_range | Range-based FOR statement. |
| functional.gtcs.test_gtcs_proc_isql_01 | gtcs-proc-isql-01 |
| functional.gtcs.test_gtcs_proc_isql_02 | gtcs-proc-isql-02 |
| functional.gtcs.test_gtcs_proc_isql_03 | gtcs-proc-isql-03 |
| functional.gtcs.test_gtcs_proc_isql_04 | gtcs-proc-isql-04 |
| functional.gtcs.test_gtcs_proc_isql_05 | gtcs-proc-isql-05 |
| functional.gtcs.test_gtcs_proc_isql_06 | gtcs-proc-isql-06 |
| functional.gtcs.test_gtcs_proc_isql_07 | gtcs-proc-isql-07 |
| functional.gtcs.test_gtcs_proc_isql_08 | gtcs-proc-isql-08 |
| functional.gtcs.test_gtcs_proc_isql_10 | gtcs-proc-isql-10 |
| functional.gtcs.test_gtcs_proc_isql_11 | gtcs-proc-isql-11 |
| functional.gtcs.test_gtcs_proc_isql_12 | gtcs-proc-isql-12 |
| functional.gtcs.test_gtcs_proc_isql_13 | gtcs-proc-isql-13 |
| functional.gtcs.test_gtcs_proc_isql_15 | gtcs-proc-isql-15 |
| functional.gtcs.test_gtcs_proc_isql_16 | gtcs-proc-isql-16 |
| functional.gtcs.test_gtcs_proc_isql_17 | gtcs-proc-isql-17 |
| functional.gtcs.test_gtcs_proc_isql_18 | gtcs-proc-isql-18 |
| functional.gtcs.test_gtcs_proc_isql_19 | gtcs-proc-isql-19 |
| functional.gtcs.test_gtcs_proc_isql_20 | gtcs-proc-isql-20 |
| functional.gtcs.test_gtcs_select_delete_isql | Test for select from SP that deletes record after its output |
| functional.gtcs.test_invalid_stream_when_use_trim | Statement with TRIM raises "bad BLR -- invalid stream" |
| functional.gtcs.test_isql_one_line_comments_01 | bug #781610 problems with one line comments (--) |
| functional.gtcs.test_isql_show_command_ambiguity | SHOW TABLE / VIEW: ambiguity between tables and views |
| functional.gtcs.test_minimum_grant_test | Minimum grant test |
| functional.gtcs.test_misplaced_collation_in_extracted_metadata | Misplaced collation when extracting metadata with isql |
| functional.gtcs.test_name_resolution_01 | SQL schemas. Name resolution. Usage of scope specifier (`%`). |
| functional.gtcs.test_name_resolution_02 | SQL schemas. Name resolution. Usage of scope specifier (`%`). |
| functional.gtcs.test_nested_func_01 | Test of NESTED FUNCTIONS functionality |
| functional.gtcs.test_nested_proc_01 | Test of NESTED PROCEDURES functionality |
| functional.gtcs.test_packages_name_resolution_01 | Test of packages names resolution - usage of scope specifier '%package' |
| functional.gtcs.test_parser_comments_in_sql | Check for problems with comments (single-line and multi-line) |
| functional.gtcs.test_psql_for_range_loops | Check PSQL range-based loops. |
| functional.gtcs.test_ref_integ_drop_fk_index | Index that is used for FK should not be avail for DROP |
| functional.gtcs.test_ref_integ_drop_fk_then_pk | Outcome must be SUCCESS if first we drop FK and after this PK constraint |
| functional.gtcs.test_ref_integ_drop_pk_constraint | Constraint of PRIMARY KEY should not be avail for DROP if there is FK that depends on it |
| functional.gtcs.test_ref_integ_drop_pk_index | Index that is used for PRIMARY KEY should not be avail for DROP |
| functional.gtcs.test_ref_integ_inactive_fk_index | Index that is used for FK should not be avail for INACTIVE |
| functional.gtcs.test_ref_integ_inactive_pk_index | Index that is used for PRIMARY KEY should not be avail for INACTIVE |
| functional.gtcs.test_ref_integ_inactive_pk_index_2 | Index that is used for PRIMARY KEY should not be avail for INACTIVE |
| functional.gtcs.test_regexp_similar_to | Statements with SIMILAR TO - miscelaneous tests. |
| functional.gtcs.test_regexp_substring_similar_to | SUBSTRING - miscelaneous tests of <str> SIMILAR TO <pattern> |
| functional.gtcs.test_returning_01 | Test of RETURNING clause: INSERT, UPDATE, MERGE. |
| functional.gtcs.test_returning_02 | Test of RETURNING clause: UPDATE; UPDATE OR INSERT; DELETE. |
| functional.gtcs.test_select_delete | |
| functional.gtcs.test_sql_join_03 | Ability to run query: ( A LEFT JOIN B ) INER JOIN C, plus ORDER BY with fields not from SELECT list |
| functional.gtcs.test_sql_join_04 | Ability to run query: ( A LEFT JOIN B ) , C. Then add ORDER BY with fields not from SELECT list |
| functional.gtcs.test_sql_predicates_00 | Support for SINGULAR <subquery> |
| functional.gtcs.test_sql_predicates_01 | Support for NOT SINGULAR <subquery> |
| functional.gtcs.test_sql_predicates_02 | Support for SINGULAR when subquery refers to another table |
| functional.gtcs.test_sql_predicates_03 | Support for NOT SINGULAR when subquery refers to another table |
| functional.gtcs.test_sql_predicates_04 | Support for NOT SINGULAR when subquery refers to another table |
| functional.gtcs.test_sql_predicates_05 | Support to SINGULAR in nested subqueries |
| functional.gtcs.test_sql_predicates_06 | Support to multiple SINGULAR subqueries |
| functional.gtcs.test_sql_predicates_07 | SINGULAR subquery applied to result of join |
| functional.gtcs.test_sql_predicates_08 | SINGULAR subquery applied to result of join |
| functional.gtcs.test_sql_predicates_09 | Applying SINGULAR to result of query with aggregate function |
| functional.gtcs.test_sql_predicates_10 | Check result of DISTINCT when applying SINGULAR to result of query with aggregate function |
| functional.gtcs.test_sql_predicates_11 | Check result of GROUP BY + ORDER BY when applying SINGULAR to result of query with aggregate function |
| functional.gtcs.test_sql_predicates_16 | Check of applying SINGULAR to result produced by a VIEW |
| functional.gtcs.test_sql_predicates_17 | Check of applying SINGULAR to result produced by a JOIN of two views |
| functional.gtcs.test_sql_predicates_18 | GROUP BY of result of SINGULAR which is applied to result of JOIN |
| functional.gtcs.test_sql_predicates_19 | GROUP BY of result of SINGULAR which is applied to result of VIEWS JOIN |
| functional.gtcs.test_sql_predicates_21 | SINGULAR - Subquery returning exactly one row. |
| functional.gtcs.test_sql_predicates_22 | SINGULAR - subquery uses CONTAINING |
| functional.gtcs.test_time_zone | Miscelaneous time zone tests |
| functional.gtcs.test_transactions_autocommit_1 | AUTO COMMIT must preserve changes that were made by all DML even if ROLLBACK is issued |
| functional.gtcs.test_transactions_autocommit_2 | Changes within AUTO COMMIT must be cancelled when exception raises in some TRIGGER |
| functional.gtcs.test_transactions_autocommit_3 | Changes within AUTO COMMIT must be cancelled when exception raises in some PROCEDURE |
| functional.gtcs.test_trigger_variable_assignment | Variable in the AFTER-trigger must be allowed for assignment OLD value in it |
| functional.gtcs.test_window_func_01 | Set of miscelaneous tests for verification of windowed functions |
| functional.gtcs.test_window_func_02 | Set of miscelaneous tests for verification of windowed functions |
| functional.gtcs.test_window_func_03 | Set of miscelaneous tests for verification of windowed functions |
| functional.gtcs.test_window_func_04 | Set of miscelaneous tests for verification of windowed functions |
| functional.gtcs.test_window_func_05 | Set of miscelaneous tests for verification of windowed functions |
| functional.index.alter.test_01 | ALTER INDEX - INACTIVE |
| functional.index.alter.test_02 | ALTER INDEX |
| functional.index.alter.test_03 | ALTER INDEX - INACTIVE UNIQUE INDEX |
| functional.index.alter.test_04 | ALTER INDEX - INACTIVE PRIMARY KEY |
| functional.index.alter.test_05 | ALTER INDEX - INACTIVE FOREIGN KEY |
| functional.index.create.test_all_cases_basic | CREATE INDEX: check all cases |
| functional.intfunc.avg.test_01 | AVG from single integer row |
| functional.intfunc.avg.test_02 | AVG - Test for INTEGER |
| functional.intfunc.avg.test_03 | AVG - Test for INTEGER |
| functional.intfunc.avg.test_04 | AVG - Test for INTEGER |
| functional.intfunc.avg.test_05 | AVG - DISTINCT |
| functional.intfunc.avg.test_06 | AVG - Integer OverFlow |
| functional.intfunc.avg.test_07 | AVG - Integer with NULL |
| functional.intfunc.avg.test_08 | AVG - NULL test |
| functional.intfunc.avg.test_09 | AVG - DOUBLE PRECISION |
| functional.intfunc.binary.test_and_01 | New Built-in Functions, Firebird 2.1 : BIN_AND( <number> [, <number> ...] ) |
| functional.intfunc.binary.test_or_01 | New Built-in Functions, Firebird 2.1 : BIN_OR( <number> [, <number> ...] ) |
| functional.intfunc.binary.test_shl_01 | New Built-in Functions, Firebird 2.1 : BIN_SHL( <number>, <number> ) |
| functional.intfunc.binary.test_shr_01 | New Built-in Functions, Firebird 2.1 : BIN_SHR( <number>, <number> ) |
| functional.intfunc.binary.test_xor_01 | New Built-in Functions, Firebird 2.1 : BIN_XOR( <number> [, <number> ...] ) |
| functional.intfunc.cast.test_01 | CAST Numeric -> CHAR |
| functional.intfunc.cast.test_02 | CAST Numeric -> VARCHAR |
| functional.intfunc.cast.test_03 | CAST Numeric -> DATE |
| functional.intfunc.cast.test_04 | CAST Numeric -> Numeric (Round down) |
| functional.intfunc.cast.test_05 | CAST Numeric -> Numeric (Round up) |
| functional.intfunc.cast.test_06 | CAST CHAR -> INTEGER (Round down) |
| functional.intfunc.cast.test_07 | CAST CHAR -> INTEGER |
| functional.intfunc.cast.test_08 | CAST CHAR -> DATE |
| functional.intfunc.cast.test_09 | CAST CHAR -> DATE |
| functional.intfunc.cast.test_10 | CAST CHAR -> TIME |
| functional.intfunc.cast.test_11 | CAST CHAR -> TIME |
| functional.intfunc.cast.test_12 | CAST CHAR -> TIME |
| functional.intfunc.cast.test_13 | CAST CHAR -> TIMESTAM |
| functional.intfunc.cast.test_14 | CAST CHAR -> TIMESTAMP |
| functional.intfunc.cast.test_15 | CAST DATE -> CHAR |
| functional.intfunc.cast.test_16 | CAST DATE -> VARCHAR |
| functional.intfunc.cast.test_17 | CAST DATE -> TIMESTAMP |
| functional.intfunc.cast.test_18 | CAST TIME -> CHAR |
| functional.intfunc.cast.test_19 | CAST TIME -> VARCHAR |
| functional.intfunc.cast.test_20 | CAST TIMESTAMP -> CHAR |
| functional.intfunc.cast.test_21 | CAST TIMESTAMP -> VARCHAR |
| functional.intfunc.cast.test_22 | CAST TIMESTAMP -> DATE |
| functional.intfunc.cast.test_23 | CAST TIMESTAMP -> TIME |
| functional.intfunc.count.test_01 | COUNT - Select from empty table |
| functional.intfunc.count.test_02 | COUNT |
| functional.intfunc.date.test_dateadd_01 | DATEADD |
| functional.intfunc.date.test_dateadd_02 | DATEADD function for MONTH |
| functional.intfunc.date.test_dateadd_03 | DATEADD |
| functional.intfunc.date.test_dateadd_04 | DATEADD |
| functional.intfunc.date.test_dateadd_05 | DATEADD |
| functional.intfunc.date.test_dateadd_06 | DATEADD |
| functional.intfunc.date.test_dateadd_07 | DATEADD |
| functional.intfunc.date.test_dateadd_08 | Dateadd milliseconds |
| functional.intfunc.date.test_datediff_01 | DATEDIFF |
| functional.intfunc.date.test_datediff_02 | DATEDIFF |
| functional.intfunc.date.test_datediff_03 | DATEDIFF |
| functional.intfunc.date.test_datediff_04 | DATEDIFF |
| functional.intfunc.date.test_datediff_05 | DATEDIFF |
| functional.intfunc.date.test_datediff_06 | DATEDIFF |
| functional.intfunc.date.test_datediff_07 | DATEDIFF |
| functional.intfunc.date.test_extract_01 | EXTRACT(WEEK FROM DATE) |
| functional.intfunc.date.test_extract_02 | EXTRACT - MILLISECONDS |
| functional.intfunc.encryption.test_block_cipher_basic | ENCRYPT/DECRYPT built-in functions |
| functional.intfunc.encryption.test_block_cipher_special | ENCRYPT/DECRYPT built-in functions |
| functional.intfunc.encryption.test_rsa_family | Basic test for RSA-family: rsa_private(), rsa_public(), rsa_encrypt(), rsa_decrypt(), rsa_sign_hash() and rsa_verify_hash() |
| functional.intfunc.encryption.test_rsa_family_pkcs_1_5 | RSA-family function, attitional test: verify ability to use PKCS_1_5 keyword |
| functional.intfunc.encryption.test_sha3 | SHA3 support for the built-in function CRYPT_HASH() |
| functional.intfunc.generate_series.test_01 | GENERATE_SERIES function - basic test |
| functional.intfunc.generate_series.test_02 | GENERATE_SERIES function - advanced tests |
| functional.intfunc.list.test_01 | List with default options |
| functional.intfunc.list.test_02 | List function with delimiter specified |
| functional.intfunc.list.test_03 | List function with distinct option |
| functional.intfunc.listagg.test_01 | LISTAGG function - basic test |
| functional.intfunc.listagg.test_02 | LISTAGG function: DISTINCT does not remove duplicates for BLOB datatype |
| functional.intfunc.listagg.test_03 | LISTAGG(DISTINCT <char>): must remove duplicated characters if they are not distinguish in CI/AI comparison. |
| functional.intfunc.math.test_abs_01 | ABS( <number> ) |
| functional.intfunc.math.test_acos_01 | ACOS( <number> ) |
| functional.intfunc.math.test_asin_01 | ASIN( <number> ) |
| functional.intfunc.math.test_atan2_01 | ATAN2( <number>, <number> ) |
| functional.intfunc.math.test_atan_01 | ATAN( <number> ) |
| functional.intfunc.math.test_ceil_01 | CEIL( <number>) |
| functional.intfunc.math.test_cos_01 | COS( <number>) |
| functional.intfunc.math.test_cosh_01 | COSH( <number>) |
| functional.intfunc.math.test_cot_01 | COT( <number> ) |
| functional.intfunc.math.test_exp_01 | EXP( <number> ) |
| functional.intfunc.math.test_floor_01 | FLOOR( <number> ) |
| functional.intfunc.math.test_ln_01 | LN( <number> ) |
| functional.intfunc.math.test_log10_01 | LOG10( <number> ) |
| functional.intfunc.math.test_log_01 | LOG( <number>, <number> ) |
| functional.intfunc.math.test_maxvalue_01 | MAXVALUE( <value> [, <value> ...] ) |
| functional.intfunc.math.test_minvalue_01 | MINVALUE( <value> [, <value> ... ) |
| functional.intfunc.math.test_mod_01 | MOD( <number>, <number> ) |
| functional.intfunc.math.test_pi_01 | PI() |
| functional.intfunc.math.test_power_01 | POWER( <number>, <number> ) |
| functional.intfunc.math.test_rand_01 | Result of cast(RAND() as <textual_type>) must not loss fractional part |
| functional.intfunc.math.test_round_01 | ROUND( <number>, <number> ) |
| functional.intfunc.math.test_sign_01 | SIGN( <number> ) |
| functional.intfunc.math.test_sin_01 | SIN( <number> ) |
| functional.intfunc.math.test_sinh_01 | SINH( <number> ) |
| functional.intfunc.math.test_sqrt_01 | SQRT( <number> ) |
| functional.intfunc.math.test_tan_01 | TAN( <number> ) |
| functional.intfunc.math.test_tanh_01 | TANH( <number> ) |
| functional.intfunc.math.test_trunc_01 | TRUNC( <number> [, <number> ] ) |
| functional.intfunc.misc.test_decode_01 | DECODE() |
| functional.intfunc.misc.test_gen_uuid_01 | GEN_UUID() |
| functional.intfunc.misc.test_hash_01 | HASH( <value> ) |
| functional.intfunc.string.test_ascii_01 | ASCII_CHAR( <number> ) |
| functional.intfunc.string.test_ascii_val_01 | ASCII_VAL( <string> ) |
| functional.intfunc.string.test_left_01 | LEFT function |
| functional.intfunc.string.test_lpad_01 | LPAD function, including non-ascii characters |
| functional.intfunc.string.test_overlay_01 | OVERLAY function |
| functional.intfunc.string.test_position_01 | POSITION( <string> IN <string> ) |
| functional.intfunc.string.test_replace_01 | REPLACE( <stringtosearch>, <findstring>, <replstring> ) |
| functional.intfunc.string.test_reverse_01 | REVERSE( <value> ) |
| functional.intfunc.string.test_right_01 | RIGHT( <string>, <number> ) |
| functional.intfunc.string.test_rpad_01 | RPAD function, including non-ascii characters |
| functional.intfunc.string.test_substring_01 | Positional SUBSTRING function |
| functional.intfunc.string.test_trunc_01 | Test for TRUNC function |
| functional.intfunc.unlist.unlist_ascii_char_0_test | UNLIST function. Check ability to use ascii_char(0) as delimiter. |
| functional.intfunc.unlist.unlist_basic_test | UNLIST function. Basic examples. |
| functional.intfunc.unlist.unlist_for_db_objects_test | UNLIST function. Check interacting with various DB objects. |
| functional.intfunc.unlist.unlist_for_expressions_test | UNLIST function. Check output when <input> and/or <separator> are evaluated in SELECT expression or passed as parameter, with [optional] RETURNING clause. |
| functional.intfunc.unlist.unlist_output_value_has_separator_test | Character <S> must NOT occur in any value generated by UNLIST which gets this <S> as separator |
| functional.intfunc.unlist.unlist_returning_types_test | UNLIST function. Check output for different returning types |
| functional.intfunc.unlist.unlist_separators_ascii_literals_test | UNLIST function. Check work with separator that is specified as one ASCII literal. |
| functional.intfunc.unlist.unlist_separators_at_eol_test | UNLIST function. Check work with separator that is specified as one ASCII literal. |
| functional.intfunc.unlist.unlist_simplified_form_test | Short syntax for UNLIST with IN operator |
| 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.ltt.test_ltt_datatypes | LOCAL TEMPORARY TABLE - basic test for datatypes. |
| functional.ltt.test_ltt_get_table_stat | LOCAL TEMPORARY TABLE - get table access statistics using API |
| functional.ltt.test_ltt_index_usage | Presense of DML between 'CREATE <LTT>' and 'CREATE INDEX' (for <LTT>) blocks usage of index |
| functional.ltt.test_ltt_object_in_use | Checks for 'object in use' when doing DDL changes in LTTs. |
| functional.ltt.test_ltt_restrictions | LOCAL TEMPORARY TABLE - verify restrictions. |
| functional.ltt.test_ltt_savepoints | Check support of SAVEPOINTS in local temporary tables. |
| functional.ltt.test_ltt_use_in_read_only_db | LOCAL TEMPORARY TABLE - must be avaliable for usage in read-only database |
| functional.monitoring.test_01 | Get isolation level of the current transaction |
| functional.monitoring.test_02 | Get data about active statements from current attachment (WHERE-filter: mon$statements.mon$state=1). |
| functional.monitoring.test_03 | table MON$COMPILED_STATEMENTS and columns MON$STATEMENTS.MON$COMPILED_STATEMENT_ID and MON$CALL_STACK.MON$COMPILED_STATEMENT_ID |
| functional.monitoring.test_04 | SYSDBA must see all attachments and their transactions, non-privileged user - only those which was of his login. |
| functional.procedure.alter.test_01 | ALTER PROCEDURE - Simple ALTER |
| functional.procedure.alter.test_02 | ALTER PROCEDURE - Alter non exists procedure |
| functional.procedure.create.test_01 | CREATE PROCEDURE |
| functional.procedure.create.test_02 | CREATE PROCEDURE - Input parameters |
| functional.procedure.create.test_03 | CREATE PROCEDURE - Output paramaters |
| functional.procedure.create.test_04 | CREATE PROCEDURE - Output paramaters |
| functional.procedure.create.test_05 | CREATE PROCEDURE - PSQL Stataments |
| functional.procedure.create.test_08 | CREATE PROCEDURE - COMMIT in SP is not alowed |
| functional.procedure.create.test_16 | Type Flag for Stored Procedures |
| functional.replication.test_blob_access_when_no_grant_for_select | Replicator must have access to the table with blob regardless SELECT grant on this table to the user who created blob. |
| functional.replication.test_grantor_not_changes_in_replica_if_owner_not_sysdba | DDL-Changes in replication does not set the correct grantor |
| functional.replication.test_permission_error_on_ddl_issued_by_non_sysdba | Permission error with replication |
| functional.role.create.test_01 | CREATE ROLE |
| functional.role.create.test_02 | CREATE ROLE - try create role with same name |
| functional.services.test_role_in_service_attachment | Check that trace plugin shows ROLE used in service attachment. Format: USER[:ROLE] |
| functional.services.test_user_management | Check ability to make connect to FB services and add/drop user |
| functional.session.test_alter_session_reset | Test results of ALTER SESSION RESET |
| functional.session.test_alter_session_reset_allow_2pc_prepared | ALTER SESSION RESET: do NOT raise error if prepared 2PC transactions present |
| functional.session.test_alter_session_reset_clear_gtt | ALTER SESSION RESET: clear contents of all used GTT ON COMMIT PRESERVE ROWS |
| functional.session.test_alter_session_reset_clear_timeouts | ALTER SESSION RESET: reset session and statement timeouts to zero |
| functional.session.test_alter_session_reset_decfloat | ALTER SESSION RESET: DECFLOAT parameters must be returned to default values |
| functional.session.test_alter_session_reset_raise_if_open_tx | ALTER SESSION RESET: throw error (isc_ses_reset_err) if any open transaction exist in current connection |
| functional.session.test_alter_session_reset_remove_context_vars | ALTER SESSION RESET: remove all context variables in 'USER_SESSION' namespace |
| functional.session.test_alter_session_reset_restore_role | ALTER SESSION RESET: restore ROLE which was passed with DPB and clear all cached security classes (if role was changed) |
| functional.session.test_alter_session_reset_rollback | ALTER SESSION RESET: ROLLBACK current user transaction (if present) and issue warning if that transaction changes any table before reset |
| functional.session.test_alter_session_reset_start_new_tx | ALTER SESSION RESET: START new transaction with the same properties as transaction that was rolled back (if transaction was present before reset) |
| functional.session.test_ext_conn_pool_01 | External Connections Pool, functionality test 01 |
| functional.shadow.test_create_01 | CREATE SHADOW: check basic usage |
| functional.sqlancer.arch_2312_17510_example_01_test | PARTIAL INDICES. NATURAL RIGHT JOIN results in an unexpected "Unknown column" error |
| functional.sqlancer.arch_2312_17510_example_02_test | Bug in RIGHT JOIN |
| functional.sqlancer.doi_10_1145_3428279_example_01_test | predicate 0 = -0 to incorrectly evaluate to FALSE. |
| functional.sqlancer.doi_10_1145_3428279_example_02_test | Wrong result of UNION DISTINCT |
| functional.sqlancer.doi_10_1145_3428279_example_04_test | Wrong result of AVG evaluation as result of SUM / COUNT |
| functional.sqlancer.doi_10_1145_3428279_example_06_test | Failed to fetch a row from a view. |
| functional.sqlancer.doi_10_1145_3428279_example_09_test | GROUP BY ignores COLLATE with case insensitive attribute |
| functional.sqlancer.doi_10_1145_3428279_example_10_test | Unnexpectedly optimized VARIANCE(0) to FALSE |
| functional.sqlancer.doi_10_1145_3428279_example_11_test | Non-deterministic output when using MAX() function |
| functional.sqlancer.doi_10_1145_3428279_example_15_test | Wrong evaluation of MIN when bitwise shift is applied to the source value |
| functional.sqlancer.doi_10_1145_3428279_example_17_test | Conversion of character string to boolean value |
| functional.sqlancer.doi_10_1145_3428279_example_18_test | Comparison of string and numeric literals |
| functional.sqlancer.osdi20_rigger_example_01_test | Partial index must not use incorrect assumption that 'c0 IS NOT 1' implied 'c0 NOT NULL' |
| functional.sqlancer.osdi20_rigger_example_05_test | Incorrect result of LIKE. |
| functional.sqlancer.osdi20_rigger_example_12_test | Unexpected null value when index is used |
| functional.sqlancer.stonedb_misc_examples_test | Bugs Found in StoneDB by SQLancer |
| functional.sqlancer.tidb_15844_test | NATURAL RIGHT JOIN results in an unexpected "Unknown column" error |
| functional.sqlancer.tidb_16028_test | Incorrect result when comparing a FLOAT/DOUBLE UNSIGNED with a negative number |
| functional.sqlancer.tidb_35522_test | incorrect unresolved column when using natural join |
| functional.sqlancer.tidb_challenge_19_test | Incorrect result for LEFT JOIN and CASE operator |
| functional.sqlancer.tidb_challenge_48_test | UNIQUE constraint on DECIMAL/floating-point columns causes incorrect result for NULL in AND |
| functional.sqlite.test_002caede89 | LEFT JOIN with OR terms in WHERE clause causes assertion fault |
| functional.sqlite.test_02a8e81d44 | LIMIT clause on sub-select in FROM clause of a SELECT in a UNION ALL interpreted incorrectly |
| functional.sqlite.test_05f43be8fd | Incorrect use of index with LIKE operators when the LHS is a blob |
| functional.sqlite.test_07d6a0453d | OFFSET ignored if there is no FROM clause |
| functional.sqlite.test_0899cf62f5 | Segfault when running query that uses LEAD()OVER() and GROUP BY |
| functional.sqlite.test_0911b5d161 | Assertion |
| functional.sqlite.test_123c9ba321 | Incorrect result when an index is used for an ordered join |
| functional.sqlite.test_16c9801ceb | Segfault on DELETE with WHERE containing OR and redundant index exists. |
| functional.sqlite.test_18458b1ad6 | COLLATE issue in a view |
| functional.sqlite.test_188f912b51 | Assertion |
| functional.sqlite.test_190c2507ee | Assertion fault on a query against a view |
| functional.sqlite.test_199df4168c | Different answer with and without index on IN operator with type mismatch |
| functional.sqlite.test_1b06916e01 | Assertion |
| functional.sqlite.test_1b266395d6 | INSERT OR REPLACE with a foreign key constraint leads to assertion fault |
| functional.sqlite.test_1b8d726456 | MAX yields unexpected result for UTF-16 |
| functional.sqlite.test_1c69be2daf | Incorrect GROUP BY when input and output columns have the same name |
| functional.sqlite.test_1d958d9059 | Incorrect result with NOT IN operator and partial index |
| functional.sqlite.test_1dcb4d4496 | Incorrect query result when redundant terms appears in WHERE clause |
| functional.sqlite.test_1e39b966ae | LEFT JOIN strength reduction optimization causes an error. |
| functional.sqlite.test_1f6f353b68 | Segfault when running query that uses SUM()OVER() |
| functional.sqlite.test_209d31e316 | Assertion fault when deleting a table out from under a SELECT |
| functional.sqlite.test_2326c258d0 | Incorrect result when a LEFT JOIN provides the qualifying constraint for a partial index |
| functional.sqlite.test_256741a16b | null pointer dereference caused by window functions in result-set of EXISTS(SELECT ...) |
| functional.sqlite.test_25e335f802 | Query "<A> left join <B> inner join <C> on <b_c_expr> on <a_b_expr>" caused left join behave like inner join. |
| functional.sqlite.test_2841e99d10 | Different rounding when converting TEXT to DOUBLE PRECISION |
| functional.sqlite.test_2d5a316356 | Segmentation fault in CROSS JOIN |
| functional.sqlite.test_2df0107bd2 | Incorrect result from LEFT JOIN with a subquery on the LHS |
| functional.sqlite.test_2ea3e9fe63 | Partial index causes assertion fault on UPDATE OR REPLACE |
| functional.sqlite.test_2f7170d73b | Error "misuse of aggregate" raising if aggregate column in FROM subquery presents in the correlated subquery |
| functional.sqlite.test_31338dca7e | OR operator in WHERE clause gives wrong answer when indexed |
| functional.sqlite.test_31a19d11b9 | Name resolution issue with compound SELECTs and Common Table Expressions |
| functional.sqlite.test_34a579141b | Incorrect results with OR terms in the ON clause of a LEFT JOIN |
| functional.sqlite.test_34cd55d68e | Database corruption following INSERT with a TRIGGER that does an affinity change |
| functional.sqlite.test_3557ad65a0 | Incorrect DISTINCT on an indexed query with IN |
| functional.sqlite.test_360c6073e1 | Aggregate MAX() function with COLLATE clause |
| functional.sqlite.test_38a97a87a6 | Inaccurate int/float comparison results in corrupt index |
| functional.sqlite.test_38cb5df375 | LIMIT ignored on compound query with subqueries |
| functional.sqlite.test_3998683a16 | Some valid floating-point literals are not recognized. |
| functional.sqlite.test_3b84b42943 | LEFT JOIN malfunctions with generated column |
| functional.sqlite.test_3be1295b26 | Inconsistent behavior of a partial unique index on a boolean expression. |
| functional.sqlite.test_3c27b97e31 | REAL rounding seems to depend on index presence |
| functional.sqlite.test_3dbdcdb14e | Assertion fault using indices with redundant columns |
| functional.sqlite.test_3ea1755124 | REINDEX causes "UNIQUE constraint failed" error for generated column |
| functional.sqlite.test_41866dc373 | MIN() malfunctions for UNIQUE column |
| functional.sqlite.test_43107840f1 | Assertion fault on UPDATE |
| functional.sqlite.test_4374860b29 | Segfault |
| functional.sqlite.test_4766f44486 | ORDER BY handling with indexes on expressions |
| functional.sqlite.test_47b2581aa9 | Infinite loop on UPDATE |
| functional.sqlite.test_490a4b7235 | Assertion when "WHERE 0" on the first element of a UNION present |
| functional.sqlite.test_4ba5abf65c | Index on expression leads to an incorrect LEFT JOIN |
| functional.sqlite.test_4baa464912 | NULL handling for indexes on expressions |
| functional.sqlite.test_4e8e4857d3 | Crash on query using an OR term in the WHERE clause |
| functional.sqlite.test_4ef7e3cfca | Name resolution problem in sub-selects within triggers |
| functional.sqlite.test_4feb3159c6 | Crash due to misuse of window functions. |
| functional.sqlite.test_510cde2777 | Endless loop on a query with window functions, ORDER BY, and LIMIT |
| functional.sqlite.test_54844eea3f | Incorrect caching of sub-query results in the FROM clause of a scalar sub-query. |
| functional.sqlite.test_57c47526c3 | Incorrect answer when flattening a UNION ALL compound |
| functional.sqlite.test_587791f926 | Wrong result of COUNT when using WHERE clause with POSITION() |
| functional.sqlite.test_5c4e7aa793 | Incorrect result for comparison with NULL |
| functional.sqlite.test_5c6955204c | Incorrect result on a table scan of a partial index |
| functional.sqlite.test_5e3c886796 | Correlated subquery on the RHS of an IN operator causes output of excessive rows |
| functional.sqlite.test_5eadca17c4 | Assertion |
| functional.sqlite.test_5ed1772895 | Incorrect ORDER BY on an indexed JOIN |
| functional.sqlite.test_623eff57e7 | LEFT JOIN in view malfunctions with partial index on table |
| functional.sqlite.test_65eb38f6e4 | Incorrect answer on LEFT JOIN when STAT4 is enabled |
| functional.sqlite.test_66e4b0e271 | Incorrect result for LEFT JOIN |
| functional.sqlite.test_6c1d3febc0 | PRIMARY KEY for REAL column datatype leads to a missing entry in the index. |
| functional.sqlite.test_6f2222d550 | Incorrect output on a LEFT JOIN |
| functional.sqlite.test_752e1646fc | Wrong result if DISTINCT used on subquery which uses ORDER BY. |
| functional.sqlite.test_767a8cbc6d | COLLATE NOCASE string comparison yields incorrect result when partial index presents |
| functional.sqlite.test_787fa716be | Assertion fault when multi-use subquery implemented by co-routine |
| functional.sqlite.test_7a31705a7e | Name resolution fails when table name is a prefix of another table |
| functional.sqlite.test_7a5279a25c | Segfault when running query that has WHERE expression with IN(...) containing LEAD()OVER() function |
| functional.sqlite.test_7e59041f9c | DISTINCT malfunctions for a VIEW |
| functional.sqlite.test_7f39060a24 | LEFT JOIN malfunctions with partial index (unexpected fetch 1 row). |
| functional.sqlite.test_7f7f8026ed | Segfault following heavy SAVEPOINT usage |
| functional.sqlite.test_7fa8049685 | Incorrect result on a LEFT JOIN when using an index |
| functional.sqlite.test_7fc8e5ff25 | INSERT into table with two triggers does not terminate |
| functional.sqlite.test_7fde638e94 | Assertion fault on a LEFT JOIN |
| functional.sqlite.test_8025674847 | Incorrect use of "WHERE x NOT NULL" partial index for query with a "WHERE x IS NOT ?" term |
| functional.sqlite.test_80369eddd5 | Incorrect case in the LIKE operator when comparing unicode characters belonging to "Other Letter" category |
| functional.sqlite.test_80ba201079 | Bug involving subqueries and the OR optimization |
| functional.sqlite.test_82b588d342 | Assertion |
| functional.sqlite.test_8454a207b9 | ALTER TABLE ADD COLUMN with negative DEFAULT value |
| functional.sqlite.test_868145d012 | Assertion fault on double LEFT JOIN (after added support for transitive constraints) |
| functional.sqlite.test_892fc34f17 | Incorrect query result when a LEFT JOIN subquery is flattened |
| functional.sqlite.test_9080b6227f | Constant expression in partial index results in row not being fetched |
| functional.sqlite.test_91e8695101 | Segfault in a table with generated columns |
| functional.sqlite.test_93fb9f89d6 | Index causes incorrect WHERE clause evaluation |
| functional.sqlite.test_96c1454cbf | Incorrect result with ORDER BY DESC and LIMIT |
| functional.sqlite.test_98825a79ce | Incorrect result from a DISTINCT + GROUP BY + ORDER BY query |
| functional.sqlite.test_98d973b8f5 | Partial index gives incorrect query result |
| functional.sqlite.test_99cd4807dc | Scalar subquery with "LIMIT 0" should return NULL |
| functional.sqlite.test_9cdc5c4662 | Incorrect result from second execution of correlated scalar sub-query that uses a partial sort |
| functional.sqlite.test_9d708e4742 | Assertion |
| functional.sqlite.test_9ece23d2ca | Default collation sequences lost when window function added to query |
| functional.sqlite.test_a179fe7465 | Incorrect output order on a join with an ORDER BY |
| functional.sqlite.test_a5c8ed66ca | Incorrect count(*) when partial indices exist |
| functional.sqlite.test_a696379c1f | Access violation error trying to insert into triggered view |
| functional.sqlite.test_a7debbe0ad | BETWEEN issue in a view |
| functional.sqlite.test_a8a4847a2d | Trigger inserts duplicate value in UNIQUE column |
| functional.sqlite.test_a976c487d1 | LEFT JOIN in view malfunctions |
| functional.sqlite.test_aa43786930 | Assertion |
| functional.sqlite.test_aa98619ad0 | Assertion fault on an IN operator using a computed-by index |
| functional.sqlite.test_ae3c5670b6 | Bug caused by factoring of constants in trigger programs |
| functional.sqlite.test_af4556bb5c | Segfault while trying to prepare a malformed window-function query |
| functional.sqlite.test_afdc5a29dc | Lossless conversion when casting a large TEXT number to NUMERIC is not performed |
| functional.sqlite.test_b148fa6105 | CAST takes implicit COLLATE of its operand |
| functional.sqlite.test_b1d8c79314 | LIKE malfunctions for INT PRIMARY KEY COLLATE NOCASE column |
| functional.sqlite.test_b2d4edaffd | Comparison on view malfunctions |
| functional.sqlite.test_b383b90278 | Assertion in UPDATE statement for textual column which has check constraint that involves numeric comparison |
| functional.sqlite.test_b50528af44 | "WHERE a=? AND b IN (?,?,...) AND c>?" query using the seekscan optimization sometimes returns extra rows. |
| functional.sqlite.test_b5ca442af9 | "Malformed database schema" when creating a failing index within a transaction |
| functional.sqlite.test_b65cb2c8d9 | Incorrect LIMIT on a UNION ALL query |
| functional.sqlite.test_b75a9ca6b0 | ORDER BY ignored if query has identical GROUP BY |
| functional.sqlite.test_b7c8682cc1 | Incorrect result from LEFT JOIN with OR in the WHERE clause |
| functional.sqlite.test_ba7cbfaedc | Wrong output order when a DESC index and GROUP BY and ORDER BY. |
| functional.sqlite.test_bc1aea7b72 | Incorrect result on LEFT JOIN with OR constraints and an ORDER BY clause |
| functional.sqlite.test_bc878246ea | Incorrect result from LEFT JOIN query |
| functional.sqlite.test_bc8d94f0fb | RENAME COLUMN fails on tables with redundant UNIQUE constraints |
| functional.sqlite.test_be31cf009c | Unexpected result for % and '1E1' |
| functional.sqlite.test_be84e357c0 | Segfault during query involving LEFT JOIN column in the ORDER BY clause |
| functional.sqlite.test_bfbf38e5e9 | Segfault on a nested join |
| functional.sqlite.test_c0aeea67d5 | Incorrect LIKE result |
| functional.sqlite.test_c2a19d8165 | Incorrect LEFT JOIN when FROM clause contains nested subqueries |
| functional.sqlite.test_c2ad16f997 | Segfault on query involving deeply nested aggregate views |
| functional.sqlite.test_c31034044b | LEFT JOIN in view malfunctions with NOTNULL |
| functional.sqlite.test_c51489c3b8 | Incorrect result from WITH RECURSIVE using DISTINCT |
| functional.sqlite.test_c5ea805691 | Inverted sort order when using DISTINCT and a descending index |
| functional.sqlite.test_c620261b5b | Incorrect result on query involving LEFT JOIN and transitive constraints |
| functional.sqlite.test_c62c5e5852 | Assertion |
| functional.sqlite.test_c88f3036a2 | ALTER TABLE DROP <column> may corrupt data |
| functional.sqlite.test_c94369cae9 | Wrong answer when use no-case collation due to the LIKE optimization |
| functional.sqlite.test_c997b11c4d | ORDER BY clause ignored in 3-way join query |
| functional.sqlite.test_ca0d20b6cd | COLLATE operator masked by function calls |
| functional.sqlite.test_cad1ab4cb7 | Segfault due to LEFT JOIN flattening optimization |
| functional.sqlite.test_cafeafe605 | UPDATE with causes error when its WHERE expression involves ROW_NUMBER()OVER() call |
| functional.sqlite.test_ce22a07731 | NULL WHERE condition unexpectedly results in row being fetched |
| functional.sqlite.test_ce7c133ea6 | Foreign key constraint fails when it should succeed. |
| functional.sqlite.test_ce82323194 | Duplicate CTE name gives incorrect result |
| functional.sqlite.test_ce8717f088 | LIKE malfunctions for UNIQUE COLLATE NOCASE column |
| functional.sqlite.test_d02e1406a5 | LEFT JOIN with an OR in the ON clause causes segfault |
| functional.sqlite.test_d06a25c844 | Incorrect result from a UNION with an ORDER BY |
| functional.sqlite.test_d0866b26f8 | Window function in correlated subquery causes assertion fault |
| functional.sqlite.test_d11a6e908f | Query planner fault on three-way nested join with compound inner SELECT |
| functional.sqlite.test_d3e7f2ba5b | Nested boolean formula with IN operator computes an incorrect result |
| functional.sqlite.test_d666d600a6 | COLLATE operator on lhs of BETWEEN expression is ignored. |
| functional.sqlite.test_d805526eae | Incorrect join result or assertion fault due to transitive constraints |
| functional.sqlite.test_d9ed4ebef1 | SELECT on window function FIRST_VALUE()OVER() causes a segfault |
| functional.sqlite.test_db4d96798d | LIMIT does not work with nested views containing UNION ALL |
| functional.sqlite.test_db87229497 | Incorrect result when RHS of IN operator contains DISTINCT and LIMIT |
| functional.sqlite.test_dc6ebeda93 | Incorrect DELETE due to the one-pass optimization |
| functional.sqlite.test_dd08e5a988 | Foreign key constraint fails to prevent consistency error. |
| functional.sqlite.test_de7db14784 | Subquery with limit clause fails as EXISTS operand |
| functional.sqlite.test_dfd66334cf | Assertion |
| functional.sqlite.test_e12a0ae526 | Assertion |
| functional.sqlite.test_e1e07ef202 | COLLATE in BETWEEN expression is ignored |
| functional.sqlite.test_e20dd54ab0 | COLLATE sequence for ORDER/GROUP BY ignored when using an index-on-expression |
| functional.sqlite.test_e5504e987e | Segfault when running query that uses NTILE()OVER() |
| functional.sqlite.test_eb703ba7b5 | Incorrect result using index on expression with collating function |
| functional.sqlite.test_ebdbadade5 | LEFT JOIN incorrect when ON clause does not reference right table. |
| functional.sqlite.test_ec32177c99 | Incorrect result with complex OR-connected WHERE |
| functional.sqlite.test_f00d096cae | Assertion when use 'IN()' with dense_rank()over() and lag()over() |
| functional.sqlite.test_f09fcd1781 | Assertion fault when window functions are used. |
| functional.sqlite.test_f2369304e4 | Incorrect results when OR is used in the ON clause of a LEFT JOIN |
| functional.sqlite.test_f617ea3125 | Incorrect ORDER BY with colliding input and output column names |
| functional.sqlite.test_f74beaabde | Problem with 3-way joins and the USING clause |
| functional.sqlite.test_f7d890858f | Segfault when running query that uses window functions |
| functional.sqlite.test_f7f8c97e97 | Valid query fails to compile due to WHERE clause optimization |
| functional.sqlite.test_f8a7060ece | Incorrect result for query that uses MIN() and a CAST on rowid |
| functional.sqlite.test_f8f472cbc7 | Partial index and BETWEEN issue |
| functional.sqlite.test_f97c463710 | Incorrect ordering with ORDER BY and LIMIT |
| functional.sqlite.test_fb8c538a8f | Incorrect sorting when a column uses BINARY collation in the ORDER BY, but is compared with a different collation in the WHERE clause |
| functional.sqlite.test_fba33c8b1d | Partial index causes row to not be fetched in BETWEEN expression |
| functional.sqlite.test_fc7bd6358f | Incorrect query result in a 3-way join due to affinity issues |
| functional.sqlite.test_fd1bda016d | Assertion in the query containing subquery in select section and exists() |
| functional.syspriv.test_access_any_object | Check ability to query, modify and deleting data plus add/drop constraints on any table |
| functional.syspriv.test_access_shutdown_database | Check ability to access to database in shutdown single mode as non-sysdba |
| functional.syspriv.test_change_header_settings | Check ability to change some database header attributes by non-sysdba user who is granted with necessary system privileges |
| functional.syspriv.test_change_mapping_rules | Check ability to manage auth mappings |
| functional.syspriv.test_change_shutdown_mode | Check ability to change database shutdown mode by non-sysdba user who is granted with necessary system privileges |
| functional.syspriv.test_create_database | Check ability to CREATE database by non-sysdba user who is granted with necessary system privilege |
| functional.syspriv.test_create_privileged_roles | Check ability of non-sysdba user to CREATE privileged role (but NOT use it) |
| functional.syspriv.test_create_user_types | Check ability to update content of RDB$TYPES |
| functional.syspriv.test_drop_database | Check ability to DROP database by non-sysdba user who is granted with necessary system privileges |
| functional.syspriv.test_grant_revoke_any_ddl_right | Check ability to grant right for issuing CREATE/ALTER/DROP statements |
| functional.syspriv.test_grant_revoke_any_object | Check ability to query, modify and deleting data plus add/drop constraints on any table |
| functional.syspriv.test_ignore_db_triggers | Check ability of non-sysdba and non-owner to ignore DB triggers |
| functional.syspriv.test_modify_ext_conn_pool | Check ability to manage external connections pool |
| functional.syspriv.test_monitor_any_attachment | Check ability to monitor any attachment |
| functional.syspriv.test_read_raw_pages | Check ability to get binary content of DB page by non-sysdba user who is granted with necessary system privilege |
| functional.syspriv.test_trace_any_attachment | Check ability to trace any attachment by non-sysdba user who is granted with necessary system privileges |
| functional.syspriv.test_use_gbak_utility | Check ability to to make database backup |
| functional.syspriv.test_use_granted_by_clause | Check ability to query, modify and deleting data plus add/drop constraints on any table |
| functional.syspriv.test_use_gstat_utility | Check ability to obtain database statistics |
| functional.syspriv.test_use_nbackup_utility | Check ability to use nbackup |
| functional.syspriv.test_user_management_in_selfsec_db | Self-secutity DB: system privilege USER_MANAGEMENT must allow only to add/alter/drop user. No access to any user tables must be granted. |
| functional.table.alter.test_01 | ALTER TABLE - ADD column |
| functional.table.alter.test_02 | ALTER TABLE. Add column with DEFAULT expression, NOT NULL requirement and UNIQUE constraint that must be applied to its values. |
| functional.table.alter.test_03 | ALTER TABLE - ADD CONSTRAINT - PRIMARY KEY |
| functional.table.alter.test_04 | ALTER TABLE - ADD CONSTRAINT - UNIQUE |
| functional.table.alter.test_05 | ALTER TABLE - ALTER - TO |
| functional.table.alter.test_06 | ALTER TABLE. Alter type of some column. |
| functional.table.alter.test_07 | ALTER TABLE. Alter position of columns. |
| functional.table.alter.test_08 | ALTER TABLE - DROP column |
| functional.table.alter.test_09 | ALTER TABLE - DROP (with data) |
| functional.table.alter.test_10 | ALTER TABLE - DROP CONSTRAINT - PRIMARY KEY |
| functional.table.alter.test_11 | ALTER TABLE - DROP CONSTRAINT - UNIQUE |
| functional.table.alter.test_12 | Verify ability to create exactly 254 changes of format (increasing it by 1) after initial creating table |
| functional.table.create.test_01 | CREATE TABLE - types |
| functional.table.create.test_04 | CREATE TABLE - constraints |
| functional.table.create.test_05 | CREATE TABLE - create table with same name |
| functional.table.create.test_06 | CREATE TABLE - two column with same name |
| functional.table.create.test_07 | CREATE TABLE - unknown datatype (domain) |
| functional.tabloid.core_3611_aux_test | Wrong data while retrieving from CTEs (or derived tables) with same column names |
| functional.tabloid.test_1ba0086e | Add optional COLUMN to ALTER TABLE ... ADD and DROP |
| functional.tabloid.test_3123a5a0 | Check ability to reuse internal connection by EXECUTE STATEMENT. |
| functional.tabloid.test_333be4bf | Change error by warning in the case when isc_dpb_parallel_workers value is not at valid range |
| functional.tabloid.test_35f56933 | Fixed cardinality mistake for invariant booleans |
| functional.tabloid.test_3b372197 | built-in functions UNICODE_CHAR and UNICODE_VAL |
| functional.tabloid.test_45b40b86 | Fix old problem triggered by schemas changes (related to tests/bugs/gh_8057_test.py) |
| functional.tabloid.test_525e5665 | Corrections after LTT changes |
| functional.tabloid.test_657d86fe | RemoteAuxPort is per-database |
| functional.tabloid.test_6cfc9b5d | Scrollable cursors. Automated test with randomly generated mission for positioning. |
| functional.tabloid.test_721329f0 | Fix problem in gbak where a package name were being leaked to non-packaged routines. |
| functional.tabloid.test_80fd0682 | Fixed bug with index names patterns in online validation service |
| functional.tabloid.test_8816d5c8 | Fixed crash when IN predicate is delivered into aggregates/unions |
| functional.tabloid.test_883200d1 | Do not re-prepare statements when execute DDL in ISQL |
| functional.tabloid.test_893488bb | (Simplified but still) cost-based choice between LOOP and HASH semi-joins |
| functional.tabloid.test_8f728e63 | Fix cardinality estimations for semi/anti joins |
| functional.tabloid.test_90129c6d | Scrollable cursors. Fixed isBof/isEof when the prefetch is active |
| functional.tabloid.test_95442bdf | Attempt to avoid hash joining for possible cardinality under-estimations |
| functional.tabloid.test_aae2ae32 | Better fix for #8252: incorrect subquery unnesting with complex dependencies, it re-allows converting nested IN/EXISTS into multiple semi-join |
| functional.tabloid.test_arithmetic_cast_float_to_int_as_round | Result of CAST for numbers is implementation defined |
| functional.tabloid.test_arithmetic_numexpr_eval_dialect_1 | Check result of integer division on dialect 1. |
| functional.tabloid.test_arithmetic_numexpr_eval_dialect_3 | Check result of integer division on dialect 3. |
| functional.tabloid.test_bus_3103_windowed_funcs | Query for test MAX()OVER(). |
| functional.tabloid.test_c8849946 | Scrollable cursors. Inconsistent cursor repositioning |
| functional.tabloid.test_cc183f59 | Add key info to the merge join plan output |
| functional.tabloid.test_comment_in_object_names | All DB objects types must allow name COMMENT. Also, COMMENT ON ... must allow occurence of "comment" in it. |
| functional.tabloid.test_crash_when_too_long_username_for_auth | crash on assert or memory corruption when too long username is used for authentication |
| functional.tabloid.test_db_owner_punct_chars_max_length | Allow to create DB with owner containing a character from string.punctuation set, with duplicating it up to max allowed length |
| functional.tabloid.test_dbp_0951_multiple_nested_cte | Query for test multiple CTEs |
| functional.tabloid.test_dbp_1697_windowed_funcs | Query for test SUM()OVER() and COUNT()OVER(). |
| functional.tabloid.test_dbp_1940_20040130_1740 | Common SQL. Check correctness of the results |
| functional.tabloid.test_dbp_1940_20061108_2141 | Common SQL. Check correctness of the results |
| functional.tabloid.test_dbp_1940_20080912_1005 | Common SQL. Check correctness of the results |
| functional.tabloid.test_dbp_1940_20090521_1520 | Common SQL. Check correctness of the results |
| functional.tabloid.test_dbp_1940_20110426_1906 | Common SQL. Check correctness of the results |
| functional.tabloid.test_dbp_1940_20110725_1159 | Common SQL. Check correctness of the results |
| functional.tabloid.test_dbp_1940_20130412_1008 | Common SQL. Check correctness of the results |
| functional.tabloid.test_dbp_1940_20130831_2039 | Common SQL. Check correctness of the results |
| functional.tabloid.test_dbp_1940_20130912_1908 | Common SQL. Check correctness of the results |
| functional.tabloid.test_dbp_2146_distinct_not_in | Common SQL. Check correctness of the results |
| functional.tabloid.test_dbp_4137_combo_full_join_and_windowed_funcs | Common SQL. Check correctness of the results |
| functional.tabloid.test_dbp_4391_combo_full_join_and_windowed_funcs | Common SQL. Check correctness of the results |
| functional.tabloid.test_dbp_4391_combo_full_join_and_windowed_funcs2 | Common SQL. Check correctness of the results |
| functional.tabloid.test_dbp_5125_windowed_funcs | Common SQL. Check correctness of the results |
| functional.tabloid.test_dbp_7029_heavy_test_for_windowed_funcs | Common SQL. Check correctness of the results |
| functional.tabloid.test_dbp_7114_windowed_funcs | Common SQL. Check correctness of the results |
| functional.tabloid.test_dml_privileges_sufficiency | Verify sufficiency of privileges for performing DML actions. Verify that RETURNING clause can not be used without SELECT privilege. |
| functional.tabloid.test_dsqlrequests | DROP TABLE fails if executing in ES and DML at the same execute block is performed in autonomous transaction |
| functional.tabloid.test_e260ced8 | Allow computable but non-invariant lists to be used for index lookup |
| functional.tabloid.test_eqc_136030 | Check ability for preparing and then run query with parameters. Query should use ORDER-BY clause. |
| functional.tabloid.test_eqc_141347 | Check correctness of LEFT JOIN result when right source has two FK and one of fields from FK present both in ON and WHERE clauses. |
| functional.tabloid.test_eqc_160757 | Check correctness of LEFT JOIN result when left source is table with several -vs- single rows and right source is SP. |
| functional.tabloid.test_eqc_166663 | Index(es) should not become corrupted after two updates and raising exception in one Tx, doing inside SP |
| functional.tabloid.test_eqc_200762 | Check results of CONTAINING when search pattern can span on one or several blob segments |
| functional.tabloid.test_eqc_306263 | Check ability to run complex query |
| functional.tabloid.test_eqc_343715 | Checking PK index is used when table is joined as driven (right) source in LEFT OUTER join from VIEW |
| functional.tabloid.test_eqc_344124 | Check ability to run selectable SP with input parameter which inserts into GTT (on commit DELETE rows) and then does suspend |
| functional.tabloid.test_f8cb4a6e | Correct error message on non-positioned cursor |
| functional.tabloid.test_fd0fa8a3 | Let include file name into error message when creation of temp file failed. |
| functional.tabloid.test_fde5484d | Increase isql max password length |
| functional.tabloid.test_full_join_push_where_predicate | WHERE-filter must be applied after FULL JOIN result |
| functional.tabloid.test_gtcs_proc_isql_14 | gtcs-proc-isql-14 |
| functional.tabloid.test_hq_153b7f6e | Don't set rdb$relation_fields.rdb$collation_id if field uses explicit domain with the same charset and collation id |
| functional.tabloid.test_ibp_124 | WHERE CURRENT OF <C> within block that has savepoint: statement #2 must see changes produced by statement #1 |
| functional.tabloid.test_join_on_position_function_result | Records with NULLs could be lost from resultset. |
| functional.tabloid.test_join_transformation_001 | Check ability of outer join simplification. |
| functional.tabloid.test_join_transformation_002 | Check ability of outer join simplification. |
| functional.tabloid.test_join_transformation_003 | Check ability of outer join simplification. |
| functional.tabloid.test_join_transformation_004 | Check ability of outer join simplification. |
| functional.tabloid.test_join_transformation_005 | Check ability of outer join simplification. |
| functional.tabloid.test_join_transformation_006 | Check ability of outer join simplification. |
| functional.tabloid.test_join_transformation_007 | Check ability of outer join simplification. |
| functional.tabloid.test_join_transformation_008 | Check ability of outer join simplification. |
| functional.tabloid.test_loose_record_when_relief_where_expr | Uncomment of one part of OR'ed expression led to loose of record from resultset. |
| functional.tabloid.test_no_dups_in_call_stack | Avoid info duplication when statements in call stack attached to different transactions (for example: monitoring snapshot is created in autonomous transaction) |
| functional.tabloid.test_oltp_emul_30_compiler_check | Compiler check. Test ability to compile source code of OLTP-EMUL test. |
| functional.tabloid.test_optimizer_index_navigation | Check that optimizer takes in account presense of index and does navigation instead of external sort. |
| functional.tabloid.test_ora_4475843 | Wrong (empty) result of query in Oracle 19 |
| functional.tabloid.test_pg_13918 | Some _TRIVIAL_ queries allow to specify HAVING without group by, and for such case one may to get record from EMPTY source rowset(!) |
| functional.tabloid.test_pg_14105 | Check ability to compile query with combination of full and right join. Taken from PG bug library. |
| functional.tabloid.test_pg_14421 | UPDATE/DETERE RETURNING should issue only one row when applying to table with self-referencing FK |
| functional.tabloid.test_request_of_expr_index | request of expression index could run outside of main request's snapshot. |
| functional.tabloid.test_snd_7795_20120706_1249 | Common SQL. Check correctness of the results |
| functional.transactions.test_read_consist_statement_delete_undone_01 | READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-01 |
| functional.transactions.test_read_consist_statement_delete_undone_02 | READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-02 |
| functional.transactions.test_read_consist_sttm_merge_deny_multiple_matches | READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart. |
| functional.transactions.test_read_consist_sttm_restart_max_limit | READ CONSISTENCY. Maximal number of statement-level restarts must be 10. |
| functional.transactions.test_read_consist_sttm_restart_on_delete_01 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-01. |
| functional.transactions.test_read_consist_sttm_restart_on_delete_02 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-02. |
| functional.transactions.test_read_consist_sttm_restart_on_delete_03 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-03. |
| functional.transactions.test_read_consist_sttm_restart_on_delete_04 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04. |
| functional.transactions.test_read_consist_sttm_restart_on_merge_01 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-01. |
| functional.transactions.test_read_consist_sttm_restart_on_merge_02 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-02. |
| functional.transactions.test_read_consist_sttm_restart_on_merge_03 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-03. |
| functional.transactions.test_read_consist_sttm_restart_on_merge_04 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04. |
| functional.transactions.test_read_consist_sttm_restart_on_update_01 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01. |
| functional.transactions.test_read_consist_sttm_restart_on_update_02 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02. |
| functional.transactions.test_read_consist_sttm_restart_on_update_03 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-03. |
| functional.transactions.test_read_consist_sttm_restart_on_update_04 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04. |
| functional.trigger.alter.test_alter_dml_basic | ALTER TRIGGER - basic checks for DML triggers |
| functional.trigger.create.test_create_dml_basic | CREATE TRIGGER - basic checks for DML triggers |
| functional.trigger.database.test_connect_01 | Trigger on database connect. See also CORE-745 |
| functional.trigger.database.test_connect_02 | Error handling in trigger on database connect |
| functional.trigger.database.test_connect_03 | Multiple triggers on database connect |
| functional.trigger.database.test_connect_04 | Error handling when multiple triggers on database connect exist |
| functional.trigger.database.test_disconnect_01 | Trigger on database disconnect: check that exception that raised when trigger fires is written to firebird.log |
| functional.trigger.database.test_disconnect_02 | ON DISCONNECT trigger must fire during database shutdown (gfix -shut full -force 0). |
| functional.trigger.database.test_disconnect_03 | ON DISCONNECT trigger must fire if attachment is deleted from MON$ATTACHMENTS by another attachment. |
| functional.trigger.database.test_disconnect_04 | ON DISCONNECT trigger must fire if attachment is closed by IDLE timeout. |
| functional.trigger.database.test_disconnect_05 | ON DISCONNECT trigger and OnDisconnectTriggerTimeout expiration |
| functional.trigger.database.test_disconnect_06 | ON DISCONNECT trigger: print exceptions (including cancelling) to trace if log_errors = true |
| functional.trigger.database.test_transaction_start_multiple_with_normal_finish | Multiple triggers on start transaction |
| functional.trigger.database.test_transactioncommit_01 | Trigger on commit transaction. See also CORE-645 |
| functional.trigger.database.test_transactionrollback_01 | Trigger on rollback transaction |
| functional.trigger.database.test_transactionstart_01 | Trigger on start tansaction |
| functional.util.test_gbak_zip | gbak utility: check ability to use -ZIP command switch when create backup |
| functional.view.create.test_01 | CREATE VIEW |
| functional.view.create.test_02 | CREATE VIEW |
| functional.view.create.test_03 | CREATE VIEW - bad number of columns |
| functional.view.create.test_05 | CREATE VIEW |
| functional.view.create.test_06 | CREATE VIEW - updateable |
| functional.view.create.test_07 | CREATE VIEW - updateable WITH CHECK OPTION |
| functional.view.create.test_08 | CREATE VIEW - updateable WITH CHECK OPTION |