0. Total results for each kind of outcome and server mode
1. ERRORS MAP: distribution of Firebird errors which occured during runs (0 rows)
2. FRESH FAILS: tests which failed for LAST execution only (1 rows)
3. FRESH ERRORS: tests which raised run-time error for LAST execution only (0 rows)
4. STILL FAILS: tests which fail for at least two last runs (1 rows)
[CURRENT] 5. Has fails: tests with at least one fail for previous runs (149 rows)
6. Has runtime errors: tests with at least one runtime error for previous runs (379 rows)
7. FRESH PASSED: successful tests with previous outcome = FAIL/ERROR/SKIPPED or absent (0 rows)
8. All tests: outcomes (2225 rows)
9. All tests: durations (3844 rows)
A. Skipped: tests which was intentionally excluded from execution (7 rows)

Generated 30.06.2022 17:37
Tested: HQ30.   Build: 3.0.10.33601;   SS: 30.06.22 15:19:44 - 30.06.22 16:18:57;   CS: 30.06.22 16:21:46 - 30.06.22 17:29:29;
OS and hardware info:  Linux 4.19.0-5-amd64 #1 SMP Debian 4.19.37-5 (2019-06-19) ; logical CPUs: 2 ; total memory: 7.6 Gb 
Loading data. Please wait...

Test with at least one result = "FAIL" for last 30 runs:

Jump to LIST of unique test names from this report

NN Test name mode 3.0.10.33601
2022-06-30
3.0.10.33587
2022-06-01
3.0.10.33580
2022-04-30
3.0.10.33577
2022-04-24
3.0.10.33570
2022-04-16
3.0.10.33569
2022-02-25
3.0.9.33561
2022-02-22
3.0.9.33560
2022-02-11
3.0.9.33556
2022-02-09
3.0.9.33548
2022-01-07
3.0.8.33540
2021-12-20
3.0.8.33533
2021-12-01
3.0.8.33528
2021-11-08
3.0.8.33501
2021-11-06
3.0.8.33490
2021-09-17
3.0.8.33489
2021-08-10
3.0.8.33488
2021-08-07
3.0.8.33487
2021-07-31
3.0.8.33471
2021-07-26
3.0.8.33470
2021-06-02
3.0.8.33468
2021-05-29
3.0.8.33452
2021-05-06
3.0.8.33430
2021-04-21
3.0.8.33423
2021-03-30
3.0.8.33415
2021-03-04
3.0.8.33403
2021-02-08
3.0.8.33392
2022-06-21
X X X
Test TITLE
1 CS P P P P P P P P P P P P P P P P P P P P P P P P P P     F     X X X
ANY user can drop procedures, generators, exceptions.
2 SS P P P P P P P P P P P P P P P P P P P P P P P P P P     F     X X X
ANY user can drop procedures, generators, exceptions.
3 CS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Containing not working correctly
4 SS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Containing not working correctly
5 CS P P P P P P P P P P P P P P P P P P P P P P P P X     F     P X X X
Domain names and charset issues
6 SS P P P P P P P P P P P P P P P P P P P P P P P P X     F     P X X X
Domain names and charset issues
7 CS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
LIKE doesn't work correctly with collations using SPECIALS-FIRST=1
8 SS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
LIKE doesn't work correctly with collations using SPECIALS-FIRST=1
9 CS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Greek characters in cp1251 vs uppercasing
10 SS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Greek characters in cp1251 vs uppercasing
11 CS P P P P P P P P P P P     F     P P P P P P P P P P P P P P     F     X X X
Server crash with isc_dsql_execute_immediate and zero length string
12 SS P P P P P P P P P P P     F     P     E     P P P P P P P P P P P P     E     X X X
Server crash with isc_dsql_execute_immediate and zero length string
13 CS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
select * from rdb$triggers where rdb$trigger_source like 'CHECK%'
14 SS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
select * from rdb$triggers where rdb$trigger_source like 'CHECK%'
15 CS P P P P P     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F     P X X X
CREATE COLLATION connection lost under Posix
16 SS P P P P P     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F     P X X X
CREATE COLLATION connection lost under Posix
17 CS P P P P P P P P P P P P P P P P P P P P P P P P P X     F     X X X
Stored procedure recursively called by calculated field fails after reconnect
18 SS P P P P P P P P P P P P P P P P P P P P P P P P P X     F     X X X
Stored procedure recursively called by calculated field fails after reconnect
19 CS P P P P P P P P P P P P P P P P P P P P P P P P P P     F     X X X
Success message when connecting to tiny trash database file
20 SS P P P P P P P P P P P P P P P P P P P P P P P P P P     F     X X X
Success message when connecting to tiny trash database file
21 CS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
The famous "cannot transliterate" error may be thrown when selecting data from the monitoring tables
22 SS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
The famous "cannot transliterate" error may be thrown when selecting data from the monitoring tables
23 CS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Exception when upper casing string with lowercase y trema (code 0xFF in ISO8859_1 )
24 SS P P P P P P P P P P P P P P P P P P P P P P P P P     F         E     X X X
Exception when upper casing string with lowercase y trema (code 0xFF in ISO8859_1 )
25 CS P P P P P P P P P P P P P P P P P P P P P P     F     P P P     F     X X X
FB 2.1 incorrectly works with indexed fields of type DATE in OLD ODS (9.1)
26 SS P P P P P P P P P P P P P P P P P P P P P P     F     P P P     F     X X X
FB 2.1 incorrectly works with indexed fields of type DATE in OLD ODS (9.1)
27 CS P P P P P P P     F     P P P P P P P P P P P P P P P P P     E     P X X X
Ability to cancel waiting in lock manager
28 CS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Inserting K?se into a CHARACTER SET ASCII column succeeds
29 SS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Inserting K?se into a CHARACTER SET ASCII column succeeds
30 CS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Blob transliteration may not happen inside the union
31 SS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Blob transliteration may not happen inside the union
32 CS P P P P P P P P P P P     F     P P P P     F     P     F         F     P P P     F     P P P X X X
Server crashes during prepare or throws incorrect parsing error if the remotely passed SQL query is empty
33 CS P P P P P P P P P P P P P P P P P P P     F         F     P P P P P P X X X
Cannot drop a NOT NULL constraint on a field participating in the UNIQUE constraint
34 SS P P P P P P P P P P P P P P P P P P P     F         F     P P P P P     E     X X X
Cannot drop a NOT NULL constraint on a field participating in the UNIQUE constraint
35 CS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS
36 SS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS
37 CS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
EXECUTE BLOCK execution cause server crash
38 SS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
EXECUTE BLOCK execution cause server crash
39 CS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Metadata source becomes wrong after twice transliteration to the metadata charset
40 SS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Metadata source becomes wrong after twice transliteration to the metadata charset
41 CS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Firebird crash when executing an stored procedure called by a trigger that converts string to upper
42 SS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Firebird crash when executing an stored procedure called by a trigger that converts string to upper
43 CS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Error on create table with "CHARACTER SET DOS775" field
44 SS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Error on create table with "CHARACTER SET DOS775" field
45 CS     F     P P P     F     P     F     P P P P P P P P P P P P P P P P P P     E     P X X X
gfix -sweep makes "reconnect" when it is removed from mon$attachments by delete command (issued in another window)
46 CS P P P P P P P P P P P P P P P P P P P     F         F     P P P P     E     P X X X
Prohibit an ability to issue DML or DDL statements on RDB$ tables
47 SS P P P P P P P P P P P P P P P P P P P     F         F     P P P P     E     P X X X
Prohibit an ability to issue DML or DDL statements on RDB$ tables
48 SS P P P P P P P P P P P P P P P P P P P P P P P X X X     F     X X X
Increase speed of creating package when number of its functions more than several hundreds
49 SS P P P P P     F         F         F         F     P P P P P P P P P P P P P P P P P P X X X
It is not possible to save the connection information in the ON CONNECT trigger, if the connection is created by the gbak
50 CS P P P P P P P P P P P P P P     F     P P P     F         F         F     P     F     P     F     P P X X X
Performance regression when bulk inserting into table with indices
51 SS P P P P P P P P P P P P     F     P     F         F     P     F     P     F         F         F     P     F         F         F     P X X X
Performance regression when bulk inserting into table with indices
52 CS P P P P P P P P P P P P P P P P P P     F     P P P P P P     F     P X X X
Bad optimization of some operations with views containing subqueries
53 CS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Creating SRP SYSDBA with explicit admin (-admin yes in gsec or grant admin role in create user) creates two SYSDBA accounts
54 SS P P P P P P P P P P P P P P P P P P P P P P P P P     F         E     X X X
Creating SRP SYSDBA with explicit admin (-admin yes in gsec or grant admin role in create user) creates two SYSDBA accounts
55 CS P P P P P P P P P P P P P P P P     F     P P P P P P P P P P X X X
slow changes on domain
56 SS     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         E         F     X X X
Wrong transaction can be passed to external engine
57 CS P P P P P P P P P P P P P P P P P P P P P     F     X X X X     F     X X X
Increase number of formats/versions of views from 255 to 32K
58 SS P P P P P P P P P P P P P P P P P P P P P     F     X X X X     F     X X X
Increase number of formats/versions of views from 255 to 32K
59 CS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Field name max length check wrongly if national characters specified
60 SS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Field name max length check wrongly if national characters specified
61 CS P P P P P P P P P P P P P P P P P P P P P P P P     F         F     P X X X
Provide name of udf function for "arithmetic exception, numeric overflow, or string truncation"
62 SS P P P P P P P P P P P P P P P P P P P P P P P P     F         F     P X X X
Provide name of udf function for "arithmetic exception, numeric overflow, or string truncation"
63 CS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Attempt to create mapping with non-ascii user name which is encoded in SINGLE-BYTE codepage leads to '-Malformed string'
64 SS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Attempt to create mapping with non-ascii user name which is encoded in SINGLE-BYTE codepage leads to '-Malformed string'
65 CS P P P P P P P P P P P P P P P P P P P P P P X X X X     F     X X X
Segfault when using expression index with complex expression
66 CS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Srp plugin keeps connection after database has been removed for ~10 seconds (SS and SC).
67 SS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Srp plugin keeps connection after database has been removed for ~10 seconds (SS and SC).
68 CS P P P P P P P P P P P P P P P P P P P P P P P P P X     F     X X X
Comments before the first line of code are removed (when extract metadata)
69 SS P P P P P P P P P P P P P P P P P P P P P P P P P X     F     X X X
Comments before the first line of code are removed (when extract metadata)
70 CS P P P P P P P P P P P P P P P P P P P P P P P     F     X X     F     X X X
COMMENT ON USER can only apply comment on user defined by the default usermanager plugin
71 SS P P P P P P P P P P P P P     E     P P P P P P P P P     F     X X     E     X X X
COMMENT ON USER can only apply comment on user defined by the default usermanager plugin
72 CS P P P P P P P P P P P P P P P P P P P P P P P P X X     F     X X X
FETCH RELATIVE has an off by one error for the first row
73 SS P P P P P P P P P P P P P P P P P P P P P P P P X X     F     X X X
FETCH RELATIVE has an off by one error for the first row
74 CS P P P P P P P P P P P P P P P P P P P P P P P P     F     X     F     X X X
FETCH ABSOLUTE and RELATIVE beyond bounds of cursor should always position immediately before-first or after-last
75 SS P P P P P P P P P P P P P P P P P P P P P P P P     F     X     F     X X X
FETCH ABSOLUTE and RELATIVE beyond bounds of cursor should always position immediately before-first or after-last
76 CS P P P P P P P P P P P P P P P P P P P P P P P     F     X X     F     X X X
User without ALTER ANY ROLE privilege can use COMMENT ON ROLE
77 SS P P P P P P P P P P P P P     E     P P P P P P P P P     F     X X     F     X X X
User without ALTER ANY ROLE privilege can use COMMENT ON ROLE
78 CS P P P P P P P P P P P P P P P P P P P P P P     F     X X X     F     X X X
Inconsistent translation "string->timestamp->string->timestamp" in dialect 1
79 SS P P P P P P P P P P P P P P P P P P P P P P     F     X X X     F     X X X
Inconsistent translation "string->timestamp->string->timestamp" in dialect 1
80 CS P P P P P P P P P P P P P P P P P P P P P P     F     X X X     F     X X X
CAST of Infinity values to FLOAT doesn't work
81 SS P P P P P P P P P P P P P P P P P P P P P P     F     X X X     F     X X X
CAST of Infinity values to FLOAT doesn't work
82 CS P P P P P P P P P P P P P P P P P P P P P P     F     X X X P X X X
Regression: inline comment of SP parameter with closing parenthesis leads to incorrect SQL when trying to extract metadata
83 SS P P P P P P P P P P P P P P P P P P P P P P     F     X X X P X X X
Regression: inline comment of SP parameter with closing parenthesis leads to incorrect SQL when trying to extract metadata
84 CS P P P P P P P P P P P P P P P P P P P P P P     F     X X X     F     X X X
COMPUTED BY column looses charset and collate of source field <F> when <F> is either of type BLOB or VARCHAR casted to BLOB
85 SS P P P P P P P P P P P P P P P P P P P P P P     F     X X X     F     X X X
COMPUTED BY column looses charset and collate of source field <F> when <F> is either of type BLOB or VARCHAR casted to BLOB
86 CS P P P P P P P P P P P P P P P P P P P P P P     F     X X X     F     X X X
Results of concatenation with blob has no info about collation of source columns (which are declared with such info)
87 SS P P P P P P P P P P P P P P P P P P P P P P     F     X X X     F     X X X
Results of concatenation with blob has no info about collation of source columns (which are declared with such info)
88 CS P P P P P P P P P P P P P P P P P P P P P P     F     X X X     F     X X X
Implementation of SUBSTRING for UTF8 character set is inefficient
89 SS P P P P P P P P P P P P P P P P P P P P P P     F     X X X     F     X X X
Implementation of SUBSTRING for UTF8 character set is inefficient
90 CS X X X X X X X X X X X X X X X     F         F         F         F         F         F         F     X X X X X X X X
Many indexed reads in a compound index with NULLs [CORE2709]
91 SS X X X X X X X X X X X X X X X     F         F         F         F         F         F         F     X X X X X X X X
Many indexed reads in a compound index with NULLs [CORE2709]
92 CS P P P P P P P P P P P P P     F     X X X X X X X X X X X X     F     X X X
recreate table T with PK or UK is impossible after duplicate typing w/o commit when ISQL is launched in AUTODDL=OFF mode [CORE3529]
93 SS P P P P P P P P P P P P P     F     X X X X X X X X X X X X     F     X X X
recreate table T with PK or UK is impossible after duplicate typing w/o commit when ISQL is launched in AUTODDL=OFF mode [CORE3529]
94 CS P P P P P P P P P P P P P     F     X X X X X X X X X X X X     F     X X X
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]
95 SS P P P P P P P P P P P P P     F     X X X X X X X X X X X X     F     X X X
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]
96 CS P P P P P P P P P P P P P     F     X X X X X X X X X X X X     F     X X X
Compound ALTER TABLE statement with ADD and DROP the same constraint failed if this constraint involves index creation (PK/UNQ/FK) [CORE4878]
97 SS P P P P P P P P P P P P P     F     X X X X X X X X X X X X     F     X X X
Compound ALTER TABLE statement with ADD and DROP the same constraint failed if this constraint involves index creation (PK/UNQ/FK) [CORE4878]
98 CS P P P P P P P P P P P P P P P P P P X X X X X X X X     F     X X X
Slow performance when executing SQL scripts as non-SYSDBA user [CORE5966]
99 SS P P P P P P P P P P P P P P P P P P X X X X X X X X     F     X X X
Slow performance when executing SQL scripts as non-SYSDBA user [CORE5966]
100 CS P P P P P P P P P P P P P P P P P P P P P     F     X X X X     F     X X X
Getting "records fetched" for functions/procedures in trace
101 SS P P P P P P P P P P P P P P P P P P P P     F         F     X X X X     F     X X X
Getting "records fetched" for functions/procedures in trace
102 CS P P P P P P P P P P P P P P P P P P     F     X X X X X X X     F     X X X
Command switch "-fetch_password <passwordfile>" does not work with gfix
103 SS P P P P P P P P P P P P P P P P P P     F     X X X X X X X     F     X X X
Command switch "-fetch_password <passwordfile>" does not work with gfix
104 CS P P P P P P P P P P P P P P P P P P P P X X X X X X     F     X X X
Correct error message for DROP VIEW
105 SS P P P P P P P P P P P P P P P P P P P P X X X X X X     F     X X X
Correct error message for DROP VIEW
106 CS P P P P P P P P P P P P P P P P P P     F     X X X X X X X     F     X X X
Some orphan records left at RDB$SECURITY_CLASSES and RDB$USER_PRIVILEGES after DROP PROCEDURE\FUNCTION
107 SS P P P P P P P P P P P P P P P P P P     F     X X X X X X X     F     X X X
Some orphan records left at RDB$SECURITY_CLASSES and RDB$USER_PRIVILEGES after DROP PROCEDURE\FUNCTION
108 CS P P P P P P P P P P P P P     F     X X X X X X X X X X X X     F     X X X
DATEDIFF does not support fractional value for MILLISECOND
109 SS P P P P P P P P P P P P P     F     X X X X X X X X X X X X     F     X X X
DATEDIFF does not support fractional value for MILLISECOND
110 CS P P P P P P P P P P P P P     F     X X X X X X X X X X X X     F     X X X
gbak -b failed with "invalid transaction handle (expecting explicit transaction start)"
111 CS P P P P P P P P P P P P P     F     X X X X X X X X X X X X     F     X X X
Scroll cursor server crash
112 CS P P P P P P P P P P P P P P P P P P P     F         F     P P P P P P X X X
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
113 SS P P P P P P P P P P P P P P P P P P P     F         F     P P P P P P X X X
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
114 CS P P P P P P P P P P P P P P P P P P P     F         F     P P P P P P X X X
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
115 SS P P P P P P P P P P P P P P P P P P P     F         F     P P P P P P X X X
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
116 CS P P P P P P P P P P P P P P P P P P P     F         F     P P P P P P X X X
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
117 SS P P P P P P P P P P P P P P P P P P P     F         F     P P P P P P X X X
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
118 CS S S S S S S S S S S S     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F     S X X X
INNER JOIN join order
119 SS S S S S S S S S S S S     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F     S X X X
INNER JOIN join order
120 CS P P P P P P P P     F         F         F         F         F         F         F         F         F         F         F         F         F     P P P P P P X X X
LEFT OUTER JOIN with full match, but limited in ON clause
121 SS P P P P P P P P     F         F         F         F         F         F         F         F         F         F         F         F         F     P P P P P P X X X
LEFT OUTER JOIN with full match, but limited in ON clause
122 CS P P P P P P P P     F         F         F         F         F         F         F         F         F         F         F         F         F     P P P P P P X X X
LEFT OUTER JOIN with STARTING WITH in WHERE clause
123 SS P P P P P P P P     F         F         F         F         F         F         F         F         F         F         F         F         F     P P P P P P X X X
LEFT OUTER JOIN with STARTING WITH in WHERE clause
124 CS P P P P P P P P P P P P P P P P P P P P P P P     F     P P     F     X X X
Empty DB - RDB$ROLES
125 SS P P P P P P P P P P P P P P P P P P P P P P P     F     P P     F     X X X
Empty DB - RDB$ROLES
126 CS P P P P P P P P P P P P P P P P P P P P P P P     F     P P     F     X X X
Empty DB - RDB$SECURITY_CLASSES
127 SS P P P P P P P P P P P P P P P P P P P P P P P     F     P P     F     X X X
Empty DB - RDB$SECURITY_CLASSES
128 CS P P P P P P P P P P P P P P P P P P P P P P P     F     P P     F     X X X
Empty DB - RDB$USER_PRIVILEGES
129 SS P P P P P P P P P P P P P P P P P P P P P P P     F     P P     F     X X X
Empty DB - RDB$USER_PRIVILEGES
130 CS P P P P P P P P P P P P P P     F     P P P P P P P P P P P     F     X X X
ISQL - SHOW DATABASE
131 SS P P P P P P P P P P P P P P     F     P P P P P P P P P P P     F     X X X
ISQL - SHOW DATABASE
132 CS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
GTCS/tests/external-file-06-d. Test for external table with field of DOUBLE PRECISION datatype
133 SS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
GTCS/tests/external-file-06-d. Test for external table with field of DOUBLE PRECISION datatype
134 CS P P P P P P P P P P P P P     F     P P P P P P P P P P P P     F     X X X
test de la fonction datediff pour avoir le resultat en minute
135 SS P P P P P P P P P P P P P     F     P P P P P P P P P P P P     F     X X X
test de la fonction datediff pour avoir le resultat en minute
136 CS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
test for LPAD function, including non-ascii characters.
137 SS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
test for LPAD function, including non-ascii characters.
138 CS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
test for RPAD function, including non-ascii characters.
139 SS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
test for RPAD function, including non-ascii characters.
140 CS P P P P P P P P P P P P P P P P P P P P P P P     F     P P     F     X X X
CREATE ROLE
141 SS P P P P P P P P P P P P P P P P P P P P P P P     F     P P     F     X X X
CREATE ROLE
142 CS P P P P P P P P P P P P P P P P P P P     F         F     P P P P P P X X X
Common SQL. Check correctness of the results
143 SS P P P P P P P P P P P P P P P P P P P     F         F     P P P P P P X X X
Common SQL. Check correctness of the results
144 CS P P P P P P P P P P P P P P P P P P P     F         F     P P P P P P X X X
Common SQL. Check correctness of the results
145 SS P P P P P P P P P P P P P P P P P P P     F         F     P P P P P P X X X
Common SQL. Check correctness of the results
146 CS P P P P P P P P P P P P P P P P P P P     F         F     P P P P P P X X X
Check ability to run complex query
147 SS P P P P P P P P P P P P P P P P P P P     F         F     P P P P P P X X X
Check ability to run complex query
148 CS P P P P P P P P P P P P P P P P P P P     F         F     P P P P P P X X X
Common SQL. Check correctness of the results
149 SS P P P P P P P P P P P P P P P P P P P     F         F     P P P P P P X X X
Common SQL. Check correctness of the results

Elapsed time, milliseconds:
NN Test name mode median_ms 3.0.10.33601
2022-06-30
3.0.10.33587
2022-06-01
3.0.10.33580
2022-04-30
3.0.10.33577
2022-04-24
3.0.10.33570
2022-04-16
3.0.10.33569
2022-02-25
3.0.9.33561
2022-02-22
3.0.9.33560
2022-02-11
3.0.9.33556
2022-02-09
3.0.9.33548
2022-01-07
3.0.8.33540
2021-12-20
3.0.8.33533
2021-12-01
3.0.8.33528
2021-11-08
3.0.8.33501
2021-11-06
3.0.8.33490
2021-09-17
3.0.8.33489
2021-08-10
3.0.8.33488
2021-08-07
3.0.8.33487
2021-07-31
3.0.8.33471
2021-07-26
3.0.8.33470
2021-06-02
3.0.8.33468
2021-05-29
3.0.8.33452
2021-05-06
3.0.8.33430
2021-04-21
3.0.8.33423
2021-03-30
3.0.8.33415
2021-03-04
3.0.8.33403
2021-02-08
3.0.8.33392
2022-06-21
X X X
Test TITLE
1 CS 2790 2480 2400 2290 2380 2280 2680 2480 2860 2890 2790 2890 2830 2890 2720 2890 2960 2840 2650 2470 2720 2810 3450 3010 3490 2680 2960 2260
ANY user can drop procedures, generators, exceptions.
2 SS 2260 2030 1980 1970 1900 1960 2260 2210 2340 2260 2320 2270 2230 2310 2270 2610 2230 2090 2000 2380 2390 2200 2790 2450 2400 2260 2180 1820
ANY user can drop procedures, generators, exceptions.
3 CS 1710 1490 1550 1000 1000 1520 1590 1600 1000 1970 1820 1870 1710 1810 1730 1670 1800 1720 1680 1710 1660 1730 2300 1720 2230 1940 1270 1360
Containing not working correctly
4 SS 1180 1070 1190 1150 1060 1090 1230 1190 1000 1370 1060 1160 1000 1390 1220 1130 1180 1190 1180 1130 1120 1220 1560 1180 1220 1270 940 960
Containing not working correctly
5 CS 1610 1460 1510 1330 1370 1390 1660 1530 1710 1670 1490 1660 1740 1610 1630 1640 1560 1610 1610 1510 1670 1650 2030 1840 1830 730 1320
Domain names and charset issues
6 SS 1175 1090 1090 1110 1090 1130 1140 1170 1320 1270 1220 1280 1180 1630 1270 1190 1160 1160 1130 1180 1140 1320 1660 1230 1210 450 1040
Domain names and charset issues
7 CS 1530 1370 1330 1420 1370 1370 1560 1450 1600 1650 1600 1440 1520 1660 1510 1680 1580 1560 1540 1480 1540 1660 2190 1570 1530 1480 1000 1340
LIKE doesn't work correctly with collations using SPECIALS-FIRST=1
8 SS 1070 1100 1030 1030 940 950 1090 1110 1170 1000 1180 1020 1040 1140 1070 1210 1080 1030 1110 1000 1090 1060 1450 1120 1070 1020 720 970
LIKE doesn't work correctly with collations using SPECIALS-FIRST=1
9 CS 1480 1310 1450 1390 1360 1370 1480 1490 1560 1630 1620 1460 1460 1480 1610 1520 1570 1480 1510 1000 1000 1600 2070 1590 1450 1540 1300 1340
Greek characters in cp1251 vs uppercasing
10 SS 1060 1070 1100 990 1020 1030 1100 1060 1240 1150 1060 1030 1070 1030 1060 1160 1170 1010 1090 990 1100 1030 1490 1120 1070 1060 870 910
Greek characters in cp1251 vs uppercasing
11 CS 880 880 870 890 850 830 920 890 920 970 920 920 960 850 880 940 880 920 850 870 880 870 1120 950 850 840 880 780
Server crash with isc_dsql_execute_immediate and zero length string
12 SS 550 620 590 590 550 570 630 640 590 700 550 0 0 0 0 540 670 530 510 510 490 530 760 0 550 530 520 10
Server crash with isc_dsql_execute_immediate and zero length string
13 CS 1560 1450 1450 1410 1360 1410 1540 1630 1640 1760 1560 1710 1610 1520 1510 1850 1570 1700 1540 1710 1790 1550 2460 1650 1550 1600 1210 1410
select * from rdb$triggers where rdb$trigger_source like 'CHECK%'
14 SS 1190 1080 1130 1050 1160 1190 1220 1240 1290 1420 1140 1200 1110 1190 1260 1310 1000 1170 1000 1110 1180 1210 1550 1270 1450 1220 910 970
select * from rdb$triggers where rdb$trigger_source like 'CHECK%'
15 CS 870 830 860 810 810 870 840 880 870 1020 870 820 910 930 820 980 870 870 840 730 840 870 1080 920 860 910 890 760
CREATE COLLATION connection lost under Posix
16 SS 580 590 630 630 610 570 620 620 710 690 540 530 550 570 820 580 550 540 630 560 590 530 850 580 550 520 560 0
CREATE COLLATION connection lost under Posix
17 CS 1850 1550 1590 1710 1630 1610 1780 1730 1840 1860 1800 1870 1000 1860 1000 1910 2000 1910 1860 1990 2220 1940 2000 2080 1000 1860 1590
Stored procedure recursively called by calculated field fails after reconnect
18 SS 1475 1310 1280 1440 1320 1400 1430 1520 1660 1690 1530 1470 1000 1480 1380 1450 1600 1510 1450 1340 1550 1510 1950 1550 1540 1480 1260
Stored procedure recursively called by calculated field fails after reconnect
19 CS 2000 1910 1930 1960 2000 1980 1980 2060 2080 2130 2100 1980 2000 2020 2010 2100 2020 1990 2010 2060 2000 2030 2290 2110 1930 1900 740 1860
Success message when connecting to tiny trash database file
20 SS 1570 1630 1590 1610 1600 1620 1620 1670 1670 1680 1600 1520 1530 1550 1510 1540 1590 1550 1510 1510 1620 1570 1770 1560 1490 1490 460 1460
Success message when connecting to tiny trash database file
21 CS 3720 3620 3560 3530 3540 3540 3720 3650 3980 3980 3780 3830 3730 3640 3740 3740 3720 3940 3610 3740 3890 3660 4000 3790 3780 3630 2640 3580
The famous "cannot transliterate" error may be thrown when selecting data from the monitoring tables
22 SS 3150 3110 3150 3160 3150 3210 3220 3130 3280 3310 3280 3130 3210 3130 3120 3160 3150 3170 3120 3140 3170 3170 3600 3200 3150 3090 2320 2960
The famous "cannot transliterate" error may be thrown when selecting data from the monitoring tables
23 CS 1660 1480 1450 1480 1440 1440 1770 1570 1720 1830 1580 1690 1810 1680 1760 1720 1800 1610 1570 1660 1900 1640 2120 1790 1660 1620 1540 1380
Exception when upper casing string with lowercase y trema (code 0xFF in ISO8859_1 )
24 SS 1190 1110 1150 1060 1070 1050 1000 1190 1320 1240 1230 1100 1200 1390 1190 1170 1230 1260 1190 1130 1200 1190 1570 1220 1240 1210 1170 10
Exception when upper casing string with lowercase y trema (code 0xFF in ISO8859_1 )
25 CS 1360 1230 1260 1220 1180 1000 1270 1320 1390 1470 1340 1370 1390 1390 1390 1410 1430 1430 1420 1310 1350 1410 1620 1420 1350 1360 1360 1130
FB 2.1 incorrectly works with indexed fields of type DATE in OLD ODS (9.1)
26 SS 1010 940 990 960 930 960 1020 990 1140 1090 960 1000 1080 1080 1010 1150 1030 980 1030 950 1000 960 1420 1030 1050 1020 1040 900
FB 2.1 incorrectly works with indexed fields of type DATE in OLD ODS (9.1)
27 CS 2420 2220 2140 2190 2160 2310 2350 2520 2460 2610 2340 2380 2520 2490 2760 2590 2670 2590 2420 2270 2320 2530 3190 2640 2420 2610 1540 2220
Ability to cancel waiting in lock manager
28 CS 1460 1410 1360 1450 1330 1220 1480 1470 1590 1620 1620 1580 1550 1450 1620 1760 1430 1580 1440 1330 1530 1000 1870 1470 1390 1460 1130 1000
Inserting K?se into a CHARACTER SET ASCII column succeeds
29 SS 1060 1020 1020 990 1040 1030 1150 1170 1180 1140 1060 1040 970 1090 990 1200 1110 1100 1010 1210 1030 1060 1340 1080 1050 1070 830 890
Inserting K?se into a CHARACTER SET ASCII column succeeds
30 CS 1340 1240 1230 1280 1320 1190 1330 1320 1470 1490 1430 1400 1370 1340 1320 1360 1430 1490 1340 1220 1370 1290 1660 1400 1370 1330 870 1280
Blob transliteration may not happen inside the union
31 SS 945 970 940 950 920 910 970 970 1020 1130 1040 880 1010 970 900 930 1000 920 910 920 930 960 1210 920 970 890 0 830
Blob transliteration may not happen inside the union
32 CS 1200 1110 1110 1120 1200 1190 1200 1160 1280 1320 1190 1280 1310 1200 1180 1270 1190 1230 1210 1170 1310 1160 1570 1260 1350 1220 1130 1110
Server crashes during prepare or throws incorrect parsing error if the remotely passed SQL query is empty
33 CS 1520 1330 1450 1330 1420 1430 1590 1520 1520 1590 1000 1650 1740 1600 1420 1600 1540 1600 1460 1440 1470 1460 1890 1700 1570 1640 1520 1300
Cannot drop a NOT NULL constraint on a field participating in the UNIQUE constraint
34 SS 1240 1170 1080 1140 1160 1150 1240 1000 1270 1390 1000 1240 1540 1590 1240 1310 1240 1270 1300 1100 1120 1240 1640 1360 1300 1220 1260 10
Cannot drop a NOT NULL constraint on a field participating in the UNIQUE constraint
35 CS 1410 1300 1330 1370 1310 1270 1410 1470 1530 1550 1420 1390 1520 1270 1380 1530 1470 1440 1370 1340 1440 1440 1890 1580 1410 1420 1410 1270
Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS
36 SS 930 930 930 1000 920 930 970 980 1040 1110 940 860 870 860 920 1050 920 850 930 890 970 830 1290 940 940 910 900 840
Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS
37 CS 6050 5160 4790 4870 4610 4810 6050 5830 7030 6900 6280 5920 6050 6110 5910 6240 5910 6000 5620 6070 6980 7120 7510 6490 6220 6100 6000 4760
EXECUTE BLOCK execution cause server crash
38 SS 5610 4590 4660 4570 4440 4400 5330 5480 5580 5180 5220 5660 5350 5720 5610 5850 6080 5740 5890 7140 6060 5860 7020 6000 6000 6240 5550 4220
EXECUTE BLOCK execution cause server crash
39 CS 1190 1140 1180 1170 1110 1090 1190 1230 1350 1310 1300 1260 1270 1000 1000 1320 1180 1230 1270 1240 1000 1330 1620 1330 1160 1170 1160 1090
Metadata source becomes wrong after twice transliteration to the metadata charset
40 SS 830 790 860 830 830 860 840 840 930 980 800 800 820 810 870 980 850 830 830 760 810 810 1090 790 880 730 710 0
Metadata source becomes wrong after twice transliteration to the metadata charset
41 CS 1070 980 1140 1040 1070 990 1070 1100 1180 1300 1160 1070 1110 1060 1070 1180 1160 1000 1060 1030 1090 1100 1380 1170 1000 1060 900 1010
Firebird crash when executing an stored procedure called by a trigger that converts string to upper
42 SS 690 720 840 760 740 740 0 780 870 870 690 700 670 670 650 850 660 690 630 670 660 630 900 700 670 690 540 640
Firebird crash when executing an stored procedure called by a trigger that converts string to upper
43 CS 1410 1340 1390 1320 1280 1000 1470 1410 1580 1630 1460 1410 1430 1440 1400 1410 1520 1400 1470 1630 1320 1400 1920 1770 1420 1460 870 1220
Error on create table with "CHARACTER SET DOS775" field
44 SS 1000 980 970 1050 960 940 1040 1080 1150 1170 1000 990 1150 960 1060 1020 1010 990 1060 1000 1010 980 1270 1010 980 970 530 890
Error on create table with "CHARACTER SET DOS775" field
45 CS 16505 14450 14700 15170 14080 119550 15850 147200 15870 16000 15700 16970 16520 17620 17370 16490 16670 16910 16010 16190 18050 16760 18830 17140 17390 16130 0 14560
gfix -sweep makes "reconnect" when it is removed from mon$attachments by delete command (issued in another window)
46 CS 15600 14480 14330 14680 14110 14150 14830 14680 16520 16710 15420 16100 16140 16900 15600 16970 16460 16090 15520 16220 7670 8210 20490 16360 15770 16470 1030 13530
Prohibit an ability to issue DML or DDL statements on RDB$ tables
47 SS 13970 12810 12660 13430 13210 13090 13870 13730 14530 15630 13860 13970 14040 14040 14060 14730 14960 14040 14110 13290 6960 6670 19650 15210 14700 14160 540 12540
Prohibit an ability to issue DML or DDL statements on RDB$ tables
48 SS 54585 61730 63460 62860 63390 62120 60830 62520 64260 68110 57970 58530 58290 23460 23140 24450 22530 22180 22020 19440 20240 20550 25240 18260 51200
Increase speed of creating package when number of its functions more than several hundreds
49 SS 1920 1920 1880 1940 2030 1870 1990 1940 2130 2160 1820 1950 1820 1830 1780 1990 1920 1870 1930 2090 1820 1800 2480 1950 1830 1980 1830 1640
It is not possible to save the connection information in the ON CONNECT trigger, if the connection is created by the gbak
50 CS 18420 73400 72320 73160 70560 73050 84050 82000 95770 95300 88960 94680 95830 16790 16910 15650 17190 15460 15260 13910 15450 16200 18420 17110 15930 15810 16020 70980
Performance regression when bulk inserting into table with indices
51 SS 22790 74320 70760 70300 68570 71520 84820 82720 87150 98170 88510 92610 102860 16060 15220 15910 15820 14560 15280 15520 15280 22790 18590 15710 15620 15000 15960 68980
Performance regression when bulk inserting into table with indices
52 CS 3290 3330 3290 3350 3520 3400 3520 3570 3880 4120 3620 3720 3530 2710 2520 2650 2530 2640 2550 2290 2760 2740 3450 2820 2800 2390 2660 3400
Bad optimization of some operations with views containing subqueries
53 CS 1370 1260 1180 1200 1280 1260 1390 1390 1510 1490 1410 1400 1340 1220 1400 1420 1480 1410 1340 1280 1420 1370 1730 1490 1320 1310 960 1240
Creating SRP SYSDBA with explicit admin (-admin yes in gsec or grant admin role in create user) creates two SYSDBA accounts
54 SS 900 890 860 890 910 840 910 880 960 1010 940 900 960 990 820 1020 900 860 840 970 900 870 1160 940 890 790 550 0
Creating SRP SYSDBA with explicit admin (-admin yes in gsec or grant admin role in create user) creates two SYSDBA accounts
55 CS 1700 1550 1720 1740 1660 1660 1710 1650 1710 1840 1610 1740 1690 1720 1660 1800 1700 1000 1670 1640 1960 1730 2520 1810 1720 1620 1000 1620
slow changes on domain
56 SS 3030 2820 2730 2760 2910 2710 2990 3200 3030 3090 3270 2990 3030 3060 2900 3040 3160 2970 3140 3090 3220 3080 3590 3030 2940 3070 1510 2590
Wrong transaction can be passed to external engine
57 CS 17160 16960 18810 17980 18040 17210 15940 16150 17160 20230 16700 17390 17020 17600 17370 17020 16660 16340 16410 18270 19720 17960 4860 2660
Increase number of formats/versions of views from 255 to 32K
58 SS 16960 16730 17670 16960 17320 17180 17870 15650 16790 17620 16590 17910 17330 17060 16550 17620 16090 16260 16100 18230 21550 16820 4000 2300
Increase number of formats/versions of views from 255 to 32K
59 CS 1080 1050 990 980 1090 1030 1100 1080 1240 1200 1020 1140 1180 1080 1150 1100 1120 1070 1020 1020 1150 1070 1460 1080 1060 1050 960 980
Field name max length check wrongly if national characters specified
60 SS 680 710 730 700 730 670 720 720 740 780 680 660 740 660 620 780 600 660 600 630 620 720 940 660 770 670 550 570
Field name max length check wrongly if national characters specified
61 CS 1130 1050 1090 1020 1080 1070 1170 1060 1180 1160 1120 1140 1120 1130 1260 1240 1160 1130 1150 1050 1190 1160 1450 1130 1080 1070 1220 1000
Provide name of udf function for "arithmetic exception, numeric overflow, or string truncation"
62 SS 740 720 850 730 760 760 820 820 840 830 760 0 730 730 720 790 730 710 700 650 790 0 1060 740 0 0 720 670
Provide name of udf function for "arithmetic exception, numeric overflow, or string truncation"
63 CS 1160 1090 1140 990 1070 1100 1180 1130 1240 1300 1320 1180 1150 1190 1150 1390 1140 1190 1220 1010 1210 1160 1570 1330 1160 1260 990 1050
Attempt to create mapping with non-ascii user name which is encoded in SINGLE-BYTE codepage leads to '-Malformed string'
64 SS 825 810 870 830 830 870 820 880 930 930 780 780 780 780 790 840 0 830 770 850 840 780 1000 800 870 730 660 710
Attempt to create mapping with non-ascii user name which is encoded in SINGLE-BYTE codepage leads to '-Malformed string'
65 CS 2360 1990 2080 2080 1980 2060 2130 2160 2320 2450 2270 2540 2370 2360 2410 2360 2370 2470 2420 2160 2390 2490 3030 2140
Segfault when using expression index with complex expression
66 CS 4260 3640 3790 3810 3770 3700 4180 4220 4450 4560 4310 4510 4090 4340 4260 4520 4270 4560 4240 4030 4590 4240 5470 4600 4830 4310 850 3520
Srp plugin keeps connection after database has been removed for ~10 seconds (SS and SC).
67 SS 6630 6000 6310 6360 6110 6300 6560 6540 6730 7170 6630 6630 6600 6680 6630 6920 7120 6690 6870 6480 7060 6940 7640 6980 6720 6510 590 6090
Srp plugin keeps connection after database has been removed for ~10 seconds (SS and SC).
68 CS 1350 1260 1220 1210 1260 1300 1280 1420 1480 1460 1480 1370 1330 1340 1390 1350 1400 1490 1400 1290 1350 1350 1810 1390 1350 1340 1190
Comments before the first line of code are removed (when extract metadata)
69 SS 860 780 890 890 860 860 900 860 1010 1020 870 840 870 790 780 930 930 880 810 790 780 820 1090 860 810 840 790
Comments before the first line of code are removed (when extract metadata)
70 CS 1110 1090 1050 960 1040 1070 1110 1100 1300 1180 1130 1140 1110 1120 1110 1100 1140 1150 1080 1110 1110 1070 1610 1130 1040 1010
COMMENT ON USER can only apply comment on user defined by the default usermanager plugin
71 SS 710 730 710 0 740 710 0 740 800 800 660 680 690 770 10 680 710 730 670 610 700 700 920 720 650 0
COMMENT ON USER can only apply comment on user defined by the default usermanager plugin
72 CS 740 730 730 0 690 720 800 0 790 780 760 780 790 780 700 980 740 760 770 710 740 720 970 710 690 660
FETCH RELATIVE has an off by one error for the first row
73 SS 470 530 520 520 490 540 520 540 600 530 440 470 440 420 430 470 470 460 440 430 460 440 550 440 460 430
FETCH RELATIVE has an off by one error for the first row
74 CS 760 710 770 690 650 700 760 0 860 870 760 0 760 740 870 860 890 780 740 0 800 0 980 760 740 730 720
FETCH ABSOLUTE and RELATIVE beyond bounds of cursor should always position immediately before-first or after-last
75 SS 450 480 540 490 520 520 520 520 540 590 430 440 450 450 420 440 420 460 430 450 410 450 570 430 450 450 400
FETCH ABSOLUTE and RELATIVE beyond bounds of cursor should always position immediately before-first or after-last
76 CS 1710 1630 1580 1570 1680 1630 1720 1740 1730 1870 1790 1770 1690 1970 2000 1800 1660 1680 1690 1580 1710 1700 2200 1820 1780 1600
User without ALTER ANY ROLE privilege can use COMMENT ON ROLE
77 SS 1160 1100 1180 1190 1170 1180 1220 1130 1000 1370 1180 1190 1240 1140 10 1240 1200 1100 1080 1060 1100 1090 1480 1140 1160 1050
User without ALTER ANY ROLE privilege can use COMMENT ON ROLE
78 CS 760 760 650 680 740 740 0 810 0 810 780 700 780 720 780 760 760 780 740 870 830 710 960 770 650
Inconsistent translation "string->timestamp->string->timestamp" in dialect 1
79 SS 460 530 490 470 480 0 480 460 550 590 460 410 410 430 400 470 420 430 460 410 490 490 600 420 420
Inconsistent translation "string->timestamp->string->timestamp" in dialect 1
80 CS 730 730 720 760 720 730 710 800 740 870 760 770 0 700 640 770 730 780 730 640 730 710 970 780 670
CAST of Infinity values to FLOAT doesn't work
81 SS 455 480 550 0 0 560 510 470 550 610 460 450 460 430 460 430 420 450 420 380 410 410 640 440 410
CAST of Infinity values to FLOAT doesn't work
82 CS 4055 3630 3660 3590 3570 3610 4050 4030 4100 4120 4130 4180 4060 4170 4370 4130 4130 3960 4000 3820 4190 4190 4880 3940 3610
Regression: inline comment of SP parameter with closing parenthesis leads to incorrect SQL when trying to extract metadata
83 SS 3595 3310 3280 3360 3280 3000 3630 3510 3730 3880 3490 3510 3430 3590 3680 3600 3740 3630 3680 3660 3800 3600 4610 3310 3100
Regression: inline comment of SP parameter with closing parenthesis leads to incorrect SQL when trying to extract metadata
84 CS 1355 1160 1140 1160 1150 1150 1340 1280 1380 1460 1360 1310 1360 1370 1150 1370 1380 1320 1350 1470 1370 1380 2030 1640 1180
COMPUTED BY column looses charset and collate of source field <F> when <F> is either of type BLOB or VARCHAR casted to BLOB
85 SS 1025 950 970 1010 900 990 1040 1020 1050 1170 950 1030 1020 1170 1030 1080 980 990 1140 1030 1180 1190 1490 1020 840
COMPUTED BY column looses charset and collate of source field <F> when <F> is either of type BLOB or VARCHAR casted to BLOB
86 CS 1235 1100 1140 1130 1150 1110 1190 1240 1290 1400 1300 1000 1270 1220 1380 1290 1360 1190 1230 1090 1260 1320 1770 1450 1150
Results of concatenation with blob has no info about collation of source columns (which are declared with such info)
87 SS 965 890 920 950 960 890 1030 890 1050 990 990 950 960 960 1000 980 1100 970 970 870 930 1010 1220 1060 860
Results of concatenation with blob has no info about collation of source columns (which are declared with such info)
88 CS 4020 3990 4230 4220 4380 4280 4270 4180 4300 4310 4050 4110 4400 1030 1120 1370 1160 1050 1000 1060 1120 1080 1490 3010 32000
Implementation of SUBSTRING for UTF8 character set is inefficient
89 SS 3830 3910 4110 3910 3940 3870 4110 3910 4000 4380 3000 3830 3840 710 740 740 730 690 0 780 810 690 980 2880 31630
Implementation of SUBSTRING for UTF8 character set is inefficient
90 CS 5080 5160 5040 5050 4950 5160 5080 5740
Many indexed reads in a compound index with NULLs [CORE2709]
91 SS 4410 4410 4360 4400 4300 4550 4560 4770
Many indexed reads in a compound index with NULLs [CORE2709]
92 CS 1210 1120 1100 1070 1140 1080 1000 1210 1230 1310 1260 1310 1270 1300 1260 1180
recreate table T with PK or UK is impossible after duplicate typing w/o commit when ISQL is launched in AUTODDL=OFF mode [CORE3529]
93 SS 1050 980 840 1090 950 980 1080 1050 1150 1230 890 1050 1070 1130 1030 800
recreate table T with PK or UK is impossible after duplicate typing w/o commit when ISQL is launched in AUTODDL=OFF mode [CORE3529]
94 CS 1130 980 1040 1000 1050 990 1130 1150 1360 1230 1000 1160 1150 1150 1150 1020
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]
95 SS 820 810 830 820 790 810 950 900 940 1020 780 880 860 790 790 740
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]
96 CS 1270 1120 1140 1140 1130 1120 1270 1240 1430 1330 1300 1280 1460 1570 1370 1120
Compound ALTER TABLE statement with ADD and DROP the same constraint failed if this constraint involves index creation (PK/UNQ/FK) [CORE4878]
97 SS 970 840 970 920 960 930 970 1070 1100 1140 1060 910 1000 910 1010 880
Compound ALTER TABLE statement with ADD and DROP the same constraint failed if this constraint involves index creation (PK/UNQ/FK) [CORE4878]
98 CS 29650 29650 29970 30310 29410 30810 29290 29380 33630 35000 31000 33550 31340 18670 17740 18270 16000 18210 17880 45980
Slow performance when executing SQL scripts as non-SYSDBA user [CORE5966]
99 SS 29470 28980 29820 32950 29340 29470 29050 29870 30790 33940 30490 32350 33130 16100 20000 18210 18520 17090 16600 44760
Slow performance when executing SQL scripts as non-SYSDBA user [CORE5966]
100 CS 5490 5290 5380 5320 5160 5000 5480 5480 5610 5000 5540 5000 5490 5830 5540 5650 5630 6210 5720 5340 8660 8640 9330 5230
Getting "records fetched" for functions/procedures in trace
101 SS 5010 4800 4730 4870 4000 4780 4960 4930 5070 5060 4900 4910 5040 5010 5030 5090 5050 5070 5380 4810 8160 7770 8000 4700
Getting "records fetched" for functions/procedures in trace
102 CS 2415 2380 2440 2310 2370 2390 2470 2430 2590 2510 2350 2560 2440 2400 2380 2470 2390 2440 2430 1850 1860
Command switch "-fetch_password <passwordfile>" does not work with gfix
103 SS 1955 1950 2010 2030 1940 2010 2000 2000 2050 2100 1890 1840 1940 1940 1980 1960 1940 1960 1930 1550 1580
Command switch "-fetch_password <passwordfile>" does not work with gfix
104 CS 1440 1330 1450 1320 1330 1310 1400 1440 1650 1740 1450 1000 1480 1630 1550 1530 1570 1510 1000 1380 1440 1270
Correct error message for DROP VIEW
105 SS 1040 1030 1050 1060 990 980 990 1220 1130 1220 1000 1040 990 1060 970 1050 1060 1000 1110 970 1130 860
Correct error message for DROP VIEW
106 CS 3280 2620 2000 2580 2700 2710 2980 3000 3300 3410 3340 3420 3430 3440 3240 3780 3950 3320 3840 3260 2680
Some orphan records left at RDB$SECURITY_CLASSES and RDB$USER_PRIVILEGES after DROP PROCEDURE\FUNCTION
107 SS 2885 2510 2470 2570 2430 2440 2890 2600 2900 2880 2890 2830 3190 2960 3080 3230 3810 2910 3040 2790 2320
Some orphan records left at RDB$SECURITY_CLASSES and RDB$USER_PRIVILEGES after DROP PROCEDURE\FUNCTION
108 CS 760 700 760 700 710 690 820 810 860 860 800 760 740 0 810 690
DATEDIFF does not support fractional value for MILLISECOND
109 SS 510 530 0 540 0 510 510 560 600 540 530 410 450 440 470 390
DATEDIFF does not support fractional value for MILLISECOND
110 CS 1910 1830 1910 1930 1950 1890 1930 1980 2050 2120 1850 1840 1920 1900 1860 1810
gbak -b failed with "invalid transaction handle (expecting explicit transaction start)"
111 CS 1550 1390 1420 1370 1370 1350 1420 1550 1680 1680 1610 1570 1670 1860 1640 1400
Scroll cursor server crash
112 CS 1720 1570 1480 1490 1430 1470 1700 1730 1770 1740 2000 1700 1720 1820 1760 1740 1720 1810 1720 1580 2110 1880 2160 1850 1650 1690 1860 1420
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
113 SS 1370 1320 1300 1270 1220 1000 1390 1370 1460 1480 1460 1330 1360 1350 1310 1400 1510 1450 1000 1480 1590 1420 1640 1370 1360 1550 1630 1120
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
114 CS 1760 1560 1590 1580 1560 1680 1770 1720 1840 1860 1770 1770 1740 1930 1730 1930 1760 1760 1630 1690 2180 2010 2170 2060 1710 1700 1860 1470
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
115 SS 1380 1290 1260 1280 1220 1230 1340 1280 1470 1600 1260 1390 1480 1580 1570 1410 1420 1330 1390 1210 1380 1000 1770 1370 1380 1400 1440 1150
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
116 CS 1920 1690 1660 1790 1620 1630 1940 1880 1890 2030 1900 2010 2050 1940 2210 2060 1860 1940 1880 1650 1920 2010 2620 1940 1890 2100 2070 1600
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
117 SS 1520 1410 1460 1410 1380 1330 1580 1590 1000 1680 1510 1540 1520 1470 1460 1680 1630 1490 1700 1670 1520 1570 1920 1740 1000 1650 1710 1260
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
118 CS 4430 0 0 0 0 0 0 0 0 0 0 0 4550 4430 4620 4380 4390 4150 4300 3890 4910 4650 5530 4650 4310 4590 4370 0
INNER JOIN join order
119 SS 4000 0 0 0 0 0 0 0 0 0 0 0 3920 4210 3810 3940 4010 3940 4000 3780 4170 3940 5010 4200 4140 4120 4000 0
INNER JOIN join order
120 CS 1700 1550 1520 1590 1530 1520 1830 1640 1860 1770 1000 1670 1740 2090 1880 1690 1740 1920 1690 1650 1810 1770 2200 1830 1670 1710 1700 1450
LEFT OUTER JOIN with full match, but limited in ON clause
121 SS 1360 1000 1230 1260 1270 1140 1360 1300 1470 1620 1000 1300 1440 1400 1440 1490 1360 1300 1350 1000 1460 1490 1780 1480 1390 1350 1740 1090
LEFT OUTER JOIN with full match, but limited in ON clause
122 CS 1790 1560 1540 1600 1590 1570 1800 1780 1950 1810 1790 1780 1790 1870 1860 1810 1840 1770 1860 1670 1910 1890 2210 1800 1700 1760 1810 1330
LEFT OUTER JOIN with STARTING WITH in WHERE clause
123 SS 1420 1240 1240 1290 1280 1230 1460 1380 1620 1520 1340 1560 1460 1400 1440 1380 1570 1420 1460 1450 1000 1350 1860 1420 1490 1460 1490 1160
LEFT OUTER JOIN with STARTING WITH in WHERE clause
124 CS 760 710 0 710 720 710 760 800 760 810 1010 770 730 790 730 730 830 850 760 690 850 0 990 740 730 760 0 670
Empty DB - RDB$ROLES
125 SS 430 490 510 0 0 480 510 510 550 570 440 400 380 0 400 430 420 430 470 410 420 430 630 470 420 410 420 410
Empty DB - RDB$ROLES
126 CS 900 840 890 930 870 800 950 900 940 890 900 920 880 1070 840 910 940 800 860 810 1030 890 1130 900 1240 860 890 1130
Empty DB - RDB$SECURITY_CLASSES
127 SS 600 570 640 630 700 640 610 620 650 740 560 560 580 590 670 640 540 510 550 530 600 570 870 570 880 540 560 900
Empty DB - RDB$SECURITY_CLASSES
128 CS 870 810 880 830 810 910 860 880 940 930 890 870 840 840 810 870 910 950 850 780 830 840 1130 950 990 900 840 830
Empty DB - RDB$USER_PRIVILEGES
129 SS 580 600 670 590 640 590 620 630 670 660 0 540 530 520 550 580 510 520 590 520 580 530 820 540 550 470 0 540
Empty DB - RDB$USER_PRIVILEGES
130 CS 760 710 810 740 760 710 0 740 840 860 890 710 720 760 760 770 740 790 0 690 0 780 1020 780 770 830 760 660
ISQL - SHOW DATABASE
131 SS 460 530 620 540 530 530 0 510 540 550 470 430 480 440 430 490 430 460 430 400 460 450 670 460 440 400 460 430
ISQL - SHOW DATABASE
132 CS 2400 2310 2300 2300 2260 2000 2310 2470 2490 2480 2400 2370 2540 2360 2440 2420 2400 2440 2300 2520 2310 2380 2810 2470 2400 2690 2440 2210
GTCS/tests/external-file-06-d. Test for external table with field of DOUBLE PRECISION datatype
133 SS 1910 1860 1940 1880 1900 1890 1950 1930 2070 2110 1870 1860 1880 1910 1920 2210 1980 1880 1910 1940 1950 1900 2240 1950 1900 1910 1860 1830
GTCS/tests/external-file-06-d. Test for external table with field of DOUBLE PRECISION datatype
134 CS 730 740 720 720 700 0 740 740 850 810 800 0 730 850 730 700 730 0 760 680 720 730 950 930 740 0 730 690
test de la fonction datediff pour avoir le resultat en minute
135 SS 470 450 610 520 530 560 480 510 510 580 400 460 430 410 420 490 410 470 440 410 520 480 590 420 440 460 490 400
test de la fonction datediff pour avoir le resultat en minute
136 CS 5760 6630 6820 6860 6660 6680 6800 6990 7420 7310 6570 7170 6780 5300 5160 5030 5010 4940 5000 5350 5420 5100 5760 5010 5110 5090 720 6460
test for LPAD function, including non-ascii characters.
137 SS 6000 6000 6000 6410 7060 6470 6340 6510 6650 6970 6260 6870 6520 4580 4640 4820 4970 4890 4630 5240 5150 4860 6540 4670 4660 4880 400 6200
test for LPAD function, including non-ascii characters.
138 CS 6470 6670 6770 6970 6760 6700 6710 6820 6950 7310 6550 6900 6840 5130 4870 5320 4880 4860 5050 5200 5000 5180 6820 5030 5270 5010 960 6470
test for RPAD function, including non-ascii characters.
139 SS 6040 6230 6470 6370 7110 6630 6480 6460 6790 6840 6410 6530 6370 4540 4650 4830 4730 4510 4650 5150 5130 4670 6040 4620 4790 4950 510 6230
test for RPAD function, including non-ascii characters.
140 CS 820 730 820 760 790 760 860 880 960 960 870 830 850 840 820 860 920 780 760 780 780 840 1050 820 810 880 810 760
CREATE ROLE
141 SS 565 550 660 600 580 580 610 590 640 700 0 530 560 520 530 490 570 470 480 480 570 580 700 0 470 460 520 0
CREATE ROLE
142 CS 1350 1350 1360 1330 1410 1280 1400 1350 1450 1550 1390 1310 1310 1350 1260 1470 1400 1340 1000 1280 1320 1300 1800 1410 1360 1370 1280 1300
Common SQL. Check correctness of the results
143 SS 1080 1180 1370 1180 1220 1210 1120 1160 1240 1360 1010 1190 1000 1010 1060 1120 1020 1010 1020 1000 1020 1020 1460 1080 1020 970 1050 1120
Common SQL. Check correctness of the results
144 CS 1980 1890 2030 2010 1970 1940 1910 1890 2100 2230 2260 1950 2020 1980 1910 2150 1990 1880 1950 2280 1980 2010 2770 1950 1950 1900 1980 1900
Common SQL. Check correctness of the results
145 SS 1670 1730 1840 1820 1950 1780 1000 1670 1860 1880 1650 1640 1580 1660 1670 1780 1600 1610 1610 1770 1680 1530 2330 1610 1620 1690 1630 1650
Common SQL. Check correctness of the results
146 CS 8890 8790 9540 8660 8900 8640 8350 8100 9220 10440 8860 9820 8790 9280 9110 8890 8670 8650 8620 10330 10400 9690 12370 8870 9440 8910 8640 8670
Check ability to run complex query
147 SS 8760 8660 8960 9190 8890 8600 8410 8040 8760 9740 8620 8650 8370 9090 8670 8840 8220 8200 8530 9210 10090 9390 12000 8270 8630 9360 9020 8860
Check ability to run complex query
148 CS 1420 1330 1370 1420 1360 1410 1400 1390 1450 1480 1550 1470 1000 1580 1420 1620 1440 1420 1480 1340 1330 1200 2070 1000 1470 2130 1400 1310
Common SQL. Check correctness of the results
149 SS 1120 1210 1190 1220 1150 1210 1210 1140 1320 1280 1110 1040 1060 1120 1040 1120 1120 1000 1090 1050 930 870 1000 1110 1120 1030 1160 1060
Common SQL. Check correctness of the results

List of tests in this report:


http://tracker.firebirdsql.org/browse/core-1378
http://tracker.firebirdsql.org/browse/core-1384
http://tracker.firebirdsql.org/browse/core-1431
http://tracker.firebirdsql.org/browse/core-1506
http://tracker.firebirdsql.org/browse/core-1539
http://tracker.firebirdsql.org/browse/core-1885
http://tracker.firebirdsql.org/browse/core-2032
http://tracker.firebirdsql.org/browse/core-2484
http://tracker.firebirdsql.org/browse/core-2531
http://tracker.firebirdsql.org/browse/core-2912
http://tracker.firebirdsql.org/browse/core-2977
http://tracker.firebirdsql.org/browse/core-304
http://tracker.firebirdsql.org/browse/core-3323
http://tracker.firebirdsql.org/browse/core-3416
http://tracker.firebirdsql.org/browse/core-3489
http://tracker.firebirdsql.org/browse/core-3554
http://tracker.firebirdsql.org/browse/core-3692
http://tracker.firebirdsql.org/browse/core-3735
http://tracker.firebirdsql.org/browse/core-4115
http://tracker.firebirdsql.org/browse/core-4119
http://tracker.firebirdsql.org/browse/core-4123
http://tracker.firebirdsql.org/browse/core-4276
http://tracker.firebirdsql.org/browse/core-4337
http://tracker.firebirdsql.org/browse/core-4731
http://tracker.firebirdsql.org/browse/core-4880
http://tracker.firebirdsql.org/browse/core-4928
http://tracker.firebirdsql.org/browse/core-5302
http://tracker.firebirdsql.org/browse/core-5393
http://tracker.firebirdsql.org/browse/core-5496
http://tracker.firebirdsql.org/browse/core-5602
http://tracker.firebirdsql.org/browse/core-5645
http://tracker.firebirdsql.org/browse/core-5647
http://tracker.firebirdsql.org/browse/core-5802
http://tracker.firebirdsql.org/browse/core-5876
http://tracker.firebirdsql.org/browse/core-5926
http://tracker.firebirdsql.org/browse/core-6015
http://tracker.firebirdsql.org/browse/core-6441
http://tracker.firebirdsql.org/browse/core-6466
http://tracker.firebirdsql.org/browse/core-6479
http://tracker.firebirdsql.org/browse/core-6486
http://tracker.firebirdsql.org/browse/core-6487
http://tracker.firebirdsql.org/browse/core-6489
http://tracker.firebirdsql.org/browse/core-6494
http://tracker.firebirdsql.org/browse/core-6521
http://tracker.firebirdsql.org/browse/core-6527
http://tracker.firebirdsql.org/browse/core-6531
http://tracker.firebirdsql.org/browse/core-6532
http://tracker.firebirdsql.org/browse/core-6542
http://tracker.firebirdsql.org/browse/core-857
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/arno/optimizer/opt_aggregate_distribution_02.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/arno/optimizer/opt_aggregate_distribution_04.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/arno/optimizer/opt_aggregate_distribution_06.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/arno/optimizer/opt_inner_join_03.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/arno/optimizer/opt_left_join_06.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/arno/optimizer/opt_left_join_11.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/basic/db/db_25.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/basic/db/db_26.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/basic/db/db_31.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/basic/isql/isql_01.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/gtcs/external-file-06-d.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/intfunc/date/datediff_07.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/intfunc/string/lpad_01.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/intfunc/string/rpad_01.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/role/create_01.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/dbp-1940_20110725_1159.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/dbp-7029-heavy-test-for-windowed-funcs.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/eqc-306263.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/snd-7795_20120706_1249.fbt
https://github.com/FirebirdSQL/firebird/issues/3106
https://github.com/FirebirdSQL/firebird/issues/3886
https://github.com/FirebirdSQL/firebird/issues/5082
https://github.com/FirebirdSQL/firebird/issues/5173
https://github.com/FirebirdSQL/firebird/issues/6220
https://github.com/FirebirdSQL/firebird/issues/6782
https://github.com/FirebirdSQL/firebird/issues/6817
https://github.com/FirebirdSQL/firebird/issues/6825
https://github.com/FirebirdSQL/firebird/issues/6866
https://github.com/FirebirdSQL/firebird/issues/6987
https://github.com/FirebirdSQL/firebird/issues/7031
https://github.com/FirebirdSQL/firebird/issues/7034

=== end of list ===