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 (4 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 (10 rows)
[CURRENT] 5. Has fails: tests with at least one fail for previous runs (120 rows)
6. Has runtime errors: tests with at least one runtime error for previous runs (293 rows)
7. FRESH PASSED: successful tests with previous outcome = FAIL/ERROR/SKIPPED or absent (3 rows)
8. All tests: outcomes (2127 rows)
9. All tests: durations (3834 rows)
A. Skipped: tests which was intentionally excluded from execution (4 rows)

Generated 15.10.2021 17:46
Tested: HQ30.   Build: 3.0.8.33501;   CS: 15.10.21 16:24:56 - 15.10.21 17:40:35;   SS: 15.10.21 15:17:54 - 15.10.21 16:22:08;
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.8.33501
2021-10-15
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
X X X X X X X X X X X X X X X X X
Test TITLE
1 CS 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 X X X X X
Containing not working correctly
2 SS 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 X X X X X
Containing not working correctly
3 CS P P P P P P P P P P P X     F     X X X X X X X X X X X X X X X X X
Domain names and charset issues
4 SS P P P P P P P P P P P X     F     X X X X X X X X X X X X X X X X X
Domain names and charset issues
5 CS 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 X X X X X
LIKE doesn't work correctly with collations using SPECIALS-FIRST=1
6 SS 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 X X X X X
LIKE doesn't work correctly with collations using SPECIALS-FIRST=1
7 CS 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 X X X X X
Greek characters in cp1251 vs uppercasing
8 SS 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 X X X X X
Greek characters in cp1251 vs uppercasing
9 CS 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 X X X X X
select * from rdb$triggers where rdb$trigger_source like 'CHECK%'
10 SS 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 X X X X X
select * from rdb$triggers where rdb$trigger_source like 'CHECK%'
11 CS     F         F         F         F         F         F         F         F         F         F         F         F         F     X X X X X X X X X X X X X X X X X
CREATE COLLATION connection lost under Posix
12 SS     F         F         F         F         F         F         F         F         F         F         F         F         F     X X X X X X X X X X X X X X X X X
CREATE COLLATION connection lost under Posix
13 CS 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 X X X X X
The famous "cannot transliterate" error may be thrown when selecting data from the monitoring tables
14 SS 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 X X X X X
The famous "cannot transliterate" error may be thrown when selecting data from the monitoring tables
15 CS 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 X X X X X
Exception when upper casing string with lowercase y trema (code 0xFF in ISO8859_1 )
16 SS 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 X X X X X
Exception when upper casing string with lowercase y trema (code 0xFF in ISO8859_1 )
17 CS P P P P P P P P P     F     P P P X X X X X X X X X X X X X X X X X
FB 2.1 incorrectly works with indexed fields of type DATE in OLD ODS (9.1)
18 SS P P P P P P P P P     F     P P P X X X X X X X X X X X X X X X X X
FB 2.1 incorrectly works with indexed fields of type DATE in OLD ODS (9.1)
19 CS 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 X X X X X
Inserting K?se into a CHARACTER SET ASCII column succeeds
20 SS 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 X X X X X
Inserting K?se into a CHARACTER SET ASCII column succeeds
21 CS 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 X X X X X
Blob transliteration may not happen inside the union
22 SS 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 X X X X X
Blob transliteration may not happen inside the union
23 CS P P P     F     P     F         F     P P P     F     P P X X X X X X X X X X X X X X X X X
Server crashes during prepare or throws incorrect parsing error if the remotely passed SQL query is empty
24 CS P P P P P P     F         F     P P P P P X X X X X X X X X X X X X X X X X
Cannot drop a NOT NULL constraint on a field participating in the UNIQUE constraint
25 SS P P P P P P     F         F     P P P P P X X X X X X X X X X X X X X X X X
Cannot drop a NOT NULL constraint on a field participating in the UNIQUE constraint
26 CS 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 X X X X X
Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS
27 SS 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 X X X X X
Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS
28 CS 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 X X X X X
EXECUTE BLOCK execution cause server crash
29 SS 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 X X X X X
EXECUTE BLOCK execution cause server crash
30 CS 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 X X X X X
Metadata source becomes wrong after twice transliteration to the metadata charset
31 SS 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 X X X X X
Metadata source becomes wrong after twice transliteration to the metadata charset
32 CS 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 X X X X X
Firebird crash when executing an stored procedure called by a trigger that converts string to upper
33 SS 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 X X X X X
Firebird crash when executing an stored procedure called by a trigger that converts string to upper
34 CS 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 X X X X X
Error on create table with "CHARACTER SET DOS775" field
35 SS 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 X X X X X
Error on create table with "CHARACTER SET DOS775" field
36 CS P P P P P P     F         F     P P P P     E     X X X X X X X X X X X X X X X X X
Prohibit an ability to issue DML or DDL statements on RDB$ tables
37 SS P P P P P P     F         F     P P P P     E     X X X X X X X X X X X X X X X X X
Prohibit an ability to issue DML or DDL statements on RDB$ tables
38 CS     F         F     P P P     F         F         F     P     F     P     F     P X X X X X X X X X X X X X X X X X
Performance regression when bulk inserting into table with indices
39 SS P     F         F     P     F     P     F         F         F     P     F         F         F     X X X X X X X X X X X X X X X X X
Performance regression when bulk inserting into table with indices
40 CS P P P P P     F     P P P P P P     F     X X X X X X X X X X X X X X X X X
Bad optimization of some operations with views containing subqueries
41 CS 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 X X X X X
Creating SRP SYSDBA with explicit admin (-admin yes in gsec or grant admin role in create user) creates two SYSDBA accounts
42 SS 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 X X X X X
Creating SRP SYSDBA with explicit admin (-admin yes in gsec or grant admin role in create user) creates two SYSDBA accounts
43 CS P P P     F     P P P P P P P P P X X X X X X X X X X X X X X X X X
slow changes on domain
44 SS     F         F         F         F         F         F         F         F         F         F         F         F         E     X X X X X X X X X X X X X X X X X
Wrong transaction can be passed to external engine
45 CS P P P P P P P P     F     X X X X X X X X X X X X X X X X X X X X X
Increase number of formats/versions of views from 255 to 32K
46 SS P P P P P P P P     F     X X X X X X X X X X X X X X X X X X X X X
Increase number of formats/versions of views from 255 to 32K
47 CS 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 X X X X X
Field name max length check wrongly if national characters specified
48 SS 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 X X X X X
Field name max length check wrongly if national characters specified
49 CS P P P P P P P P P P P     F         F     X X X X X X X X X X X X X X X X X
Provide name of udf function for "arithmetic exception, numeric overflow, or string truncation"
50 SS P P P P P P P P P P P     F         F     X X X X X X X X X X X X X X X X X
Provide name of udf function for "arithmetic exception, numeric overflow, or string truncation"
51 CS 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 X X X X X
Attempt to create mapping with non-ascii user name which is encoded in SINGLE-BYTE codepage leads to '-Malformed string'
52 SS 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 X X X X X
Attempt to create mapping with non-ascii user name which is encoded in SINGLE-BYTE codepage leads to '-Malformed string'
53 CS 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 X X X X X
Srp plugin keeps connection after database has been removed for ~10 seconds (SS and SC).
54 SS 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 X X X X X
Srp plugin keeps connection after database has been removed for ~10 seconds (SS and SC).
55 CS P P P P P P P P P P     F     X X X X X X X X X X X X X X X X X X X
COMMENT ON USER can only apply comment on user defined by the default usermanager plugin
56 SS P P P P P P P P P P     F     X X X X X X X X X X X X X X X X X X X
COMMENT ON USER can only apply comment on user defined by the default usermanager plugin
57 CS P P P P P P P P P P P     F     X X X X X X X X X X X X X X X X X X
FETCH ABSOLUTE and RELATIVE beyond bounds of cursor should always position immediately before-first or after-last
58 SS P P P P P P P P P P P     F     X X X X X X X X X X X X X X X X X X
FETCH ABSOLUTE and RELATIVE beyond bounds of cursor should always position immediately before-first or after-last
59 CS P P P P P P P P P P     F     X X X X X X X X X X X X X X X X X X X
User without ALTER ANY ROLE privilege can use COMMENT ON ROLE
60 SS P P P P P P P P P P     F     X X X X X X X X X X X X X X X X X X X
User without ALTER ANY ROLE privilege can use COMMENT ON ROLE
61 CS P P P P P P P P P     F     X X X X X X X X X X X X X X X X X X X X
Inconsistent translation "string->timestamp->string->timestamp" in dialect 1
62 SS P P P P P P P P P     F     X X X X X X X X X X X X X X X X X X X X
Inconsistent translation "string->timestamp->string->timestamp" in dialect 1
63 CS P P P P P P P P P     F     X X X X X X X X X X X X X X X X X X X X
CAST of Infinity values to FLOAT doesn't work
64 SS P P P P P P P P P     F     X X X X X X X X X X X X X X X X X X X X
CAST of Infinity values to FLOAT doesn't work
65 CS P P P P P P P P P     F     X X X X X X X X X X X X X X X X X X X X
Regression: inline comment of SP parameter with closing parenthesis leads to incorrect SQL when trying to extract metadata
66 SS P P P P P P P P P     F     X X X X X X X X X X X X X X X X X X X X
Regression: inline comment of SP parameter with closing parenthesis leads to incorrect SQL when trying to extract metadata
67 CS P P P P P P P P P     F     X X X X X X X X X X X X X X X X X 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
68 SS P P P P P P P P P     F     X X X X X X X X X X X X X X X X X 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
69 CS P P P P P P P P P     F     X X X X X X X X X X X X X X X X X X X X
Results of concatenation with blob has no info about collation of source columns (which are declared with such info)
70 SS P P P P P P P P P     F     X X X X X X X X X X X X X X X X X X X X
Results of concatenation with blob has no info about collation of source columns (which are declared with such info)
71 CS P P P P P P P P P     F     X X X X X X X X X X X X X X X X X X X X
Implementation of SUBSTRING for UTF8 character set is inefficient
72 SS P P P P P P P P P     F     X X X X X X X X X X X X X X X X X X X X
Implementation of SUBSTRING for UTF8 character set is inefficient
73 CS X X     F         F         F         F         F         F         F     X X X X X X X X X X X X X X X X X X X X X
Many indexed reads in a compound index with NULLs [CORE2709]
74 SS X X     F         F         F         F         F         F         F     X X X X X X X X X X X X X X X X X X X X X
Many indexed reads in a compound index with NULLs [CORE2709]
75 CS P P P P P P P P     F     X X X X X X X X X X X X X X X X X X X X X
Getting "records fetched" for functions/procedures in trace
76 SS P P P P P P P     F         F     X X X X X X X X X X X X X X X X X X X X X
Getting "records fetched" for functions/procedures in trace
77 CS P P P P P     F     X X X X X X X X X X X X X X X X X X X X X X X X
Command switch "-fetch_password <passwordfile>" does not work with gfix
78 SS P P P P P     F     X X X X X X X X X X X X X X X X X X X X X X X X
Command switch "-fetch_password <passwordfile>" does not work with gfix
79 CS P P P P P     F     X X X X X X X X X X X X X X X X X X X X X X X X
Some orphan records left at RDB$SECURITY_CLASSES and RDB$USER_PRIVILEGES after DROP PROCEDURE\FUNCTION
80 SS P P P P P     F     X X X X X X X X X X X X X X X X X X X X X X X X
Some orphan records left at RDB$SECURITY_CLASSES and RDB$USER_PRIVILEGES after DROP PROCEDURE\FUNCTION
81 CS     F     X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
DATEDIFF does not support fractional value for MILLISECOND
82 SS     F     X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
DATEDIFF does not support fractional value for MILLISECOND
83 CS P P P P P P     F         F     P P P P P X X X X X X X X X X X X X X X X X
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
84 SS P P P P P P     F         F     P P P P P X X X X X X X X X X X X X X X X X
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
85 CS P P P P P P     F         F     P P P P P X X X X X X X X X X X X X X X X X
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
86 SS P P P P P P     F         F     P P P P P X X X X X X X X X X X X X X X X X
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
87 CS P P P P P P     F         F     P P P P P X X X X X X X X X X X X X X X X X
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
88 SS P P P P P P     F         F     P P P P P X X X X X X X X X X X X X X X X X
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
89 CS     F         F         F         F         F         F         F         F         F         F         F         F         F     X X X X X X X X X X X X X X X X X
INNER JOIN join order
90 SS     F         F         F         F         F         F         F         F         F         F         F         F         F     X X X X X X X X X X X X X X X X X
INNER JOIN join order
91 CS     F         F         F         F         F         F         F         F     P P P P P X X X X X X X X X X X X X X X X X
LEFT OUTER JOIN with full match, but limited in ON clause
92 SS     F         F         F         F         F         F         F         F     P P P P P X X X X X X X X X X X X X X X X X
LEFT OUTER JOIN with full match, but limited in ON clause
93 CS     F         F         F         F         F         F         F         F     P P P P P X X X X X X X X X X X X X X X X X
LEFT OUTER JOIN with STARTING WITH in WHERE clause
94 SS     F         F         F         F         F         F         F         F     P P P P P X X X X X X X X X X X X X X X X X
LEFT OUTER JOIN with STARTING WITH in WHERE clause
95 CS P P P P P P P P P P     F     P P X X X X X X X X X X X X X X X X X
Empty DB - RDB$ROLES
96 SS P P P P P P P P P P     F     P P X X X X X X X X X X X X X X X X X
Empty DB - RDB$ROLES
97 CS P P P P P P P P P P     F     P P X X X X X X X X X X X X X X X X X
Empty DB - RDB$SECURITY_CLASSES
98 SS P P P P P P P P P P     F     P P X X X X X X X X X X X X X X X X X
Empty DB - RDB$SECURITY_CLASSES
99 CS P P P P P P P P P P     F     P P X X X X X X X X X X X X X X X X X
Empty DB - RDB$USER_PRIVILEGES
100 SS P P P P P P P P P P     F     P P X X X X X X X X X X X X X X X X X
Empty DB - RDB$USER_PRIVILEGES
101 CS P     F     P P P P P P P P P P P X X X X X X X X X X X X X X X X X
ISQL - SHOW DATABASE
102 SS P     F     P P P P P P P P P P P X X X X X X X X X X X X X X X X X
ISQL - SHOW DATABASE
103 CS 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 X X X X X
GTCS/tests/external-file-06-d. Test for external table with field of DOUBLE PRECISION datatype
104 SS 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 X X X X X
GTCS/tests/external-file-06-d. Test for external table with field of DOUBLE PRECISION datatype
105 CS     F     P P P P P P P P P P P P X X X X X X X X X X X X X X X X X
test de la fonction datediff pour avoir le resultat en minute
106 SS     F     P P P P P P P P P P P P X X X X X X X X X X X X X X X X X
test de la fonction datediff pour avoir le resultat en minute
107 CS 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 X X X X X
test for LPAD function, including non-ascii characters.
108 SS 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 X X X X X
test for LPAD function, including non-ascii characters.
109 CS 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 X X X X X
test for RPAD function, including non-ascii characters.
110 SS 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 X X X X X
test for RPAD function, including non-ascii characters.
111 CS P P P P P P P P P P     F     P P X X X X X X X X X X X X X X X X X
CREATE ROLE
112 SS P P P P P P P P P P     F     P P X X X X X X X X X X X X X X X X X
CREATE ROLE
113 CS P P P P P P     F         F     P P P P P X X X X X X X X X X X X X X X X X
Common SQL. Check correctness of the results
114 SS P P P P P P     F         F     P P P P P X X X X X X X X X X X X X X X X X
Common SQL. Check correctness of the results
115 CS P P P P P P     F         F     P P P P P X X X X X X X X X X X X X X X X X
Common SQL. Check correctness of the results
116 SS P P P P P P     F         F     P P P P P X X X X X X X X X X X X X X X X X
Common SQL. Check correctness of the results
117 CS P P P P P P     F         F     P P P P P X X X X X X X X X X X X X X X X X
Check ability to run complex query
118 SS P P P P P P     F         F     P P P P P X X X X X X X X X X X X X X X X X
Check ability to run complex query
119 CS P P P P P P     F         F     P P P P P X X X X X X X X X X X X X X X X X
Common SQL. Check correctness of the results
120 SS P P P P P P     F         F     P P P P P X X X X X X X X X X X X X X X X X
Common SQL. Check correctness of the results

Elapsed time, milliseconds:
NN Test name mode median_ms 3.0.8.33501
2021-10-15
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
X X X X X X X X X X X X X X X X X
Test TITLE
1 CS 1720 1770 1670 1799 1720 1680 1710 1659 1730 2299 1719 2230 1940 1269
Containing not working correctly
2 SS 1180 1420 1130 1179 1190 1180 1129 1120 1220 1559 1180 1220 1269 940
Containing not working correctly
3 CS 1644 1679 1639 1559 1610 1610 1509 1669 1650 2029 1840 1830 730
Domain names and charset issues
4 SS 1184 1190 1189 1159 1160 1130 1179 1140 1320 1659 1230 1210 449
Domain names and charset issues
5 CS 1559 1730 1680 1580 1559 1539 1480 1539 1660 2190 1569 1529 1480 1000
LIKE doesn't work correctly with collations using SPECIALS-FIRST=1
6 SS 1079 1429 1209 1079 1029 1109 1000 1090 1059 1450 1119 1069 1020 719
LIKE doesn't work correctly with collations using SPECIALS-FIRST=1
7 CS 1519 1599 1519 1569 1480 1509 1000 1000 1599 2069 1590 1450 1539 1299
Greek characters in cp1251 vs uppercasing
8 SS 1090 1140 1159 1170 1009 1090 990 1099 1029 1490 1119 1069 1059 869
Greek characters in cp1251 vs uppercasing
9 CS 1650 1700 1849 1570 1700 1539 1710 1789 1550 2460 1650 1549 1599 1210
select * from rdb$triggers where rdb$trigger_source like 'CHECK%'
10 SS 1210 1289 1309 1000 1170 1000 1109 1179 1210 1549 1269 1450 1220 910
select * from rdb$triggers where rdb$trigger_source like 'CHECK%'
11 CS 869 859 980 869 869 839 730 839 869 1080 919 859 910 889
CREATE COLLATION connection lost under Posix
12 SS 560 579 579 550 539 629 560 590 529 850 580 549 519 559
CREATE COLLATION connection lost under Posix
13 CS 3740 3819 3740 3720 3940 3609 3740 3889 3659 4000 3790 3779 3630 2639
The famous "cannot transliterate" error may be thrown when selecting data from the monitoring tables
14 SS 3150 3000 3160 3150 3170 3120 3140 3169 3170 3599 3200 3150 3090 2319
The famous "cannot transliterate" error may be thrown when selecting data from the monitoring tables
15 CS 1659 1589 1720 1799 1610 1570 1660 1900 1639 2120 1789 1659 1620 1539
Exception when upper casing string with lowercase y trema (code 0xFF in ISO8859_1 )
16 SS 1210 1319 1169 1230 1259 1189 1129 1200 1190 1569 1220 1240 1210 1170
Exception when upper casing string with lowercase y trema (code 0xFF in ISO8859_1 )
17 CS 1410 1340 1410 1429 1429 1420 1309 1350 1410 1620 1420 1350 1359 1359
FB 2.1 incorrectly works with indexed fields of type DATE in OLD ODS (9.1)
18 SS 1029 1259 1149 1029 980 1029 950 1000 960 1420 1029 1050 1019 1040
FB 2.1 incorrectly works with indexed fields of type DATE in OLD ODS (9.1)
19 CS 1460 1579 1759 1429 1579 1440 1329 1530 1000 1870 1470 1389 1460 1130
Inserting K?se into a CHARACTER SET ASCII column succeeds
20 SS 1079 1080 1200 1109 1099 1009 1209 1029 1059 1339 1079 1049 1069 829
Inserting K?se into a CHARACTER SET ASCII column succeeds
21 CS 1360 1330 1360 1430 1490 1339 1220 1369 1289 1660 1400 1370 1329 870
Blob transliteration may not happen inside the union
22 SS 924 919 929 1000 919 909 920 929 960 1210 919 969 890 0
Blob transliteration may not happen inside the union
23 CS 1230 1240 1269 1189 1230 1210 1170 1309 1159 1569 1259 1349 1220 1129
Server crashes during prepare or throws incorrect parsing error if the remotely passed SQL query is empty
24 CS 1539 1539 1599 1539 1599 1460 1440 1470 1460 1889 1700 1569 1640 1520
Cannot drop a NOT NULL constraint on a field participating in the UNIQUE constraint
25 SS 1269 1399 1309 1240 1269 1299 1100 1119 1240 1639 1360 1299 1220 1259
Cannot drop a NOT NULL constraint on a field participating in the UNIQUE constraint
26 CS 1440 1349 1529 1470 1440 1369 1340 1440 1440 1890 1579 1410 1420 1409
Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS
27 SS 930 1059 1050 919 849 930 890 970 829 1290 940 940 909 899
Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS
28 CS 6099 5669 6240 5909 6000 5620 6070 6980 7120 7509 6490 6220 6099 6000
EXECUTE BLOCK execution cause server crash
29 SS 6000 5740 5849 6080 5740 5889 7139 6059 5860 7019 6000 6000 6240 5549
EXECUTE BLOCK execution cause server crash
30 CS 1240 1340 1320 1180 1229 1269 1240 1000 1329 1620 1330 1159 1170 1159
Metadata source becomes wrong after twice transliteration to the metadata charset
31 SS 819 819 980 850 829 830 759 809 809 1089 789 879 730 710
Metadata source becomes wrong after twice transliteration to the metadata charset
32 CS 1089 1180 1180 1160 1000 1059 1030 1089 1099 1379 1169 1000 1060 899
Firebird crash when executing an stored procedure called by a trigger that converts string to upper
33 SS 669 660 849 659 690 630 669 660 630 900 700 670 690 540
Firebird crash when executing an stored procedure called by a trigger that converts string to upper
34 CS 1460 1490 1410 1520 1400 1470 1630 1319 1400 1920 1769 1420 1460 869
Error on create table with "CHARACTER SET DOS775" field
35 SS 1009 1140 1019 1009 990 1059 1000 1009 980 1270 1009 980 970 529
Error on create table with "CHARACTER SET DOS775" field
36 CS 16220 17090 16970 16460 16089 15519 16220 7670 8210 20490 16360 15769 16470 1029
Prohibit an ability to issue DML or DDL statements on RDB$ tables
37 SS 14160 15519 14730 14960 14039 14109 13289 6960 6670 19649 15210 14699 14160 540
Prohibit an ability to issue DML or DDL statements on RDB$ tables
38 CS 15809 15680 15649 17190 15460 15259 13909 15450 16200 18420 17109 15930 15809 16019
Performance regression when bulk inserting into table with indices
39 SS 15620 15009 15909 15819 14559 15279 15519 15279 22789 18589 15710 15620 15000 15960
Performance regression when bulk inserting into table with indices
40 CS 2649 2560 2649 2529 2640 2549 2289 2759 2740 3450 2820 2799 2390 2659
Bad optimization of some operations with views containing subqueries
41 CS 1409 1590 1420 1480 1409 1339 1279 1420 1370 1730 1490 1319 1309 959
Creating SRP SYSDBA with explicit admin (-admin yes in gsec or grant admin role in create user) creates two SYSDBA accounts
42 SS 889 869 1019 900 859 839 970 899 870 1160 939 889 790 549
Creating SRP SYSDBA with explicit admin (-admin yes in gsec or grant admin role in create user) creates two SYSDBA accounts
43 CS 1720 1869 1799 1700 1000 1670 1639 1960 1730 2519 1809 1720 1620 1000
slow changes on domain
44 SS 3069 2990 3039 3159 2970 3140 3089 3220 3079 3590 3029 2940 3069 1509
Wrong transaction can be passed to external engine
45 CS 17019 19340 17019 16659 16339 16410 18269 19719 17959 4859
Increase number of formats/versions of views from 255 to 32K
46 SS 16819 18510 17620 16089 16259 16100 18230 21550 16819 4000
Increase number of formats/versions of views from 255 to 32K
47 CS 1069 1069 1100 1120 1069 1019 1019 1150 1069 1460 1079 1060 1049 960
Field name max length check wrongly if national characters specified
48 SS 660 659 779 599 660 599 629 619 720 940 660 769 669 549
Field name max length check wrongly if national characters specified
49 CS 1159 1159 1240 1159 1129 1149 1049 1190 1159 1450 1129 1080 1069 1220
Provide name of udf function for "arithmetic exception, numeric overflow, or string truncation"
50 SS 735 849 789 730 710 700 650 789 0 1060 740 0 0 720
Provide name of udf function for "arithmetic exception, numeric overflow, or string truncation"
51 CS 1190 1150 1389 1140 1190 1220 1009 1210 1159 1569 1329 1160 1259 990
Attempt to create mapping with non-ascii user name which is encoded in SINGLE-BYTE codepage leads to '-Malformed string'
52 SS 819 809 840 0 830 769 850 839 779 1000 799 869 730 659
Attempt to create mapping with non-ascii user name which is encoded in SINGLE-BYTE codepage leads to '-Malformed string'
53 CS 4520 4850 4520 4269 4559 4240 4029 4590 4240 5470 4599 4830 4309 849
Srp plugin keeps connection after database has been removed for ~10 seconds (SS and SC).
54 SS 6920 6959 6920 7120 6690 6870 6480 7060 6940 7640 6980 6720 6509 589
Srp plugin keeps connection after database has been removed for ~10 seconds (SS and SC).
55 CS 1110 1130 1099 1139 1150 1080 1109 1110 1070 1610 1130 1039
COMMENT ON USER can only apply comment on user defined by the default usermanager plugin
56 SS 699 649 680 710 730 670 610 699 700 920 720 650
COMMENT ON USER can only apply comment on user defined by the default usermanager plugin
57 CS 769 740 859 889 779 740 0 799 0 980 759 740 730
FETCH ABSOLUTE and RELATIVE beyond bounds of cursor should always position immediately before-first or after-last
58 SS 445 440 439 419 460 430 450 409 450 569 430 450 450
FETCH ABSOLUTE and RELATIVE beyond bounds of cursor should always position immediately before-first or after-last
59 CS 1710 1880 1799 1660 1679 1689 1580 1710 1700 2200 1819 1779
User without ALTER ANY ROLE privilege can use COMMENT ON ROLE
60 SS 1140 1219 1240 1200 1100 1079 1059 1099 1089 1480 1140 1160
User without ALTER ANY ROLE privilege can use COMMENT ON ROLE
61 CS 774 779 759 759 779 740 870 829 710 960 769
Inconsistent translation "string->timestamp->string->timestamp" in dialect 1
62 SS 465 470 470 420 430 460 410 490 490 600 420
Inconsistent translation "string->timestamp->string->timestamp" in dialect 1
63 CS 749 839 769 730 779 730 639 729 710 970 779
CAST of Infinity values to FLOAT doesn't work
64 SS 425 740 430 420 450 420 379 410 410 639 440
CAST of Infinity values to FLOAT doesn't work
65 CS 4130 4339 4130 4130 3960 4000 3819 4190 4190 4880 3940
Regression: inline comment of SP parameter with closing parenthesis leads to incorrect SQL when trying to extract metadata
66 SS 3670 3759 3599 3739 3630 3680 3660 3800 3599 4610 3309
Regression: inline comment of SP parameter with closing parenthesis leads to incorrect SQL when trying to extract metadata
67 CS 1379 1389 1369 1379 1319 1350 1469 1369 1379 2029 1640
COMPUTED BY column looses charset and collate of source field <F> when <F> is either of type BLOB or VARCHAR casted to BLOB
68 SS 1110 1150 1080 980 990 1140 1029 1179 1190 1490 1019
COMPUTED BY column looses charset and collate of source field <F> when <F> is either of type BLOB or VARCHAR casted to BLOB
69 CS 1304 1550 1289 1359 1189 1230 1089 1259 1319 1769 1449
Results of concatenation with blob has no info about collation of source columns (which are declared with such info)
70 SS 994 1200 980 1099 970 970 869 930 1009 1219 1059
Results of concatenation with blob has no info about collation of source columns (which are declared with such info)
71 CS 1139 1209 1369 1159 1049 1000 1059 1119 1079 1489 3009
Implementation of SUBSTRING for UTF8 character set is inefficient
72 SS 779 789 740 730 689 0 779 809 690 980 2880
Implementation of SUBSTRING for UTF8 character set is inefficient
73 CS 5079 5159 5039 5049 4949 5160 5079 5740
Many indexed reads in a compound index with NULLs [CORE2709]
74 SS 4410 4410 4360 4400 4299 4549 4559 4769
Many indexed reads in a compound index with NULLs [CORE2709]
75 CS 5720 5620 5649 5629 6210 5720 5339 8659 8640 9329
Getting "records fetched" for functions/procedures in trace
76 SS 5090 5090 5090 5049 5069 5379 4810 8159 7769 8000
Getting "records fetched" for functions/procedures in trace
77 CS 2435 2470 2470 2389 2440 2430 1849
Command switch "-fetch_password <passwordfile>" does not work with gfix
78 SS 1935 1930 1960 1940 1960 1930 1549
Command switch "-fetch_password <passwordfile>" does not work with gfix
79 CS 3550 3290 3780 3950 3320 3840 3259
Some orphan records left at RDB$SECURITY_CLASSES and RDB$USER_PRIVILEGES after DROP PROCEDURE\FUNCTION
80 SS 3135 3410 3230 3810 2910 3040 2789
Some orphan records left at RDB$SECURITY_CLASSES and RDB$USER_PRIVILEGES after DROP PROCEDURE\FUNCTION
81 CS 789 789
DATEDIFF does not support fractional value for MILLISECOND
82 SS 559 559
DATEDIFF does not support fractional value for MILLISECOND
83 CS 1779 1779 1740 1720 1810 1720 1580 2109 1880 2160 1849 1649 1690 1859
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
84 SS 1480 1660 1400 1509 1450 1000 1480 1589 1420 1639 1370 1360 1549 1629
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
85 CS 1759 1000 1929 1759 1759 1629 1690 2180 2009 2170 2059 1710 1700 1859
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
86 SS 1390 1460 1410 1420 1329 1390 1209 1379 1000 1769 1370 1380 1399 1440
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
87 CS 1940 1880 2060 1859 1940 1879 1649 1919 2009 2619 1940 1889 2099 2069
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
88 SS 1670 1830 1679 1629 1490 1700 1670 1519 1569 1920 1740 1000 1650 1710
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
89 CS 4389 4400 4379 4389 4150 4299 3889 4909 4650 5529 4649 4309 4590 4370
INNER JOIN join order
90 SS 4009 4340 3940 4009 3939 4000 3779 4170 3940 5009 4199 4139 4120 4000
INNER JOIN join order
91 CS 1740 1779 1690 1740 1920 1690 1650 1809 1769 2200 1830 1669 1710 1700
LEFT OUTER JOIN with full match, but limited in ON clause
92 SS 1460 1460 1490 1359 1299 1349 1000 1460 1489 1779 1480 1390 1350 1740
LEFT OUTER JOIN with full match, but limited in ON clause
93 CS 1810 1839 1810 1839 1769 1859 1670 1909 1890 2210 1799 1700 1759 1810
LEFT OUTER JOIN with STARTING WITH in WHERE clause
94 SS 1460 1609 1380 1569 1419 1460 1449 1000 1349 1859 1419 1490 1460 1490
LEFT OUTER JOIN with STARTING WITH in WHERE clause
95 CS 759 789 730 830 849 759 689 850 0 990 740 730 759 0
Empty DB - RDB$ROLES
96 SS 430 450 430 419 430 470 410 420 430 630 470 420 409 420
Empty DB - RDB$ROLES
97 CS 900 900 909 940 799 860 809 1029 890 1129 900 1240 860 889
Empty DB - RDB$SECURITY_CLASSES
98 SS 560 559 640 539 509 549 529 600 570 870 569 879 539 560
Empty DB - RDB$SECURITY_CLASSES
99 CS 870 849 870 910 949 849 779 829 839 1129 950 990 899 840
Empty DB - RDB$USER_PRIVILEGES
100 SS 544 839 579 509 519 589 519 579 530 820 539 549 470 0
Empty DB - RDB$USER_PRIVILEGES
101 CS 769 759 769 740 790 0 689 0 779 1019 779 769 830 759
ISQL - SHOW DATABASE
102 SS 459 460 490 430 460 430 399 459 450 669 460 440 400 460
ISQL - SHOW DATABASE
103 CS 2439 2460 2420 2400 2440 2299 2519 2309 2380 2809 2469 2400 2690 2439
GTCS/tests/external-file-06-d. Test for external table with field of DOUBLE PRECISION datatype
104 SS 1910 1910 2210 1980 1879 1910 1940 1950 1900 2240 1950 1900 1909 1860
GTCS/tests/external-file-06-d. Test for external table with field of DOUBLE PRECISION datatype
105 CS 730 690 700 730 0 759 680 720 730 950 930 740 0 730
test de la fonction datediff pour avoir le resultat en minute
106 SS 460 420 490 410 470 440 409 519 480 589 420 440 460 490
test de la fonction datediff pour avoir le resultat en minute
107 CS 5089 5440 5030 5009 4940 5000 5349 5419 5099 5759 5009 5110 5089 720
test for LPAD function, including non-ascii characters.
108 SS 4880 5129 4820 4970 4890 4630 5240 5150 4859 6539 4670 4660 4880 399
test for LPAD function, including non-ascii characters.
109 CS 5049 5430 5319 4880 4859 5049 5200 5000 5180 6819 5029 5269 5009 960
test for RPAD function, including non-ascii characters.
110 SS 4789 5029 4830 4730 4509 4650 5149 5129 4670 6039 4619 4789 4950 509
test for RPAD function, including non-ascii characters.
111 CS 820 949 859 920 779 759 779 779 839 1049 820 809 880 809
CREATE ROLE
112 SS 504 590 490 570 469 480 480 569 579 700 0 470 460 519
CREATE ROLE
113 CS 1360 1369 1469 1400 1339 1000 1280 1320 1299 1799 1409 1360 1370 1279
Common SQL. Check correctness of the results
114 SS 1019 1059 1120 1019 1009 1019 1000 1019 1019 1460 1079 1019 970 1050
Common SQL. Check correctness of the results
115 CS 1980 2200 2150 1990 1879 1950 2279 1980 2009 2769 1950 1950 1900 1980
Common SQL. Check correctness of the results
116 SS 1630 1809 1779 1600 1610 1610 1769 1680 1529 2330 1609 1620 1690 1630
Common SQL. Check correctness of the results
117 CS 8910 10230 8890 8670 8650 8619 10330 10400 9690 12369 8870 9440 8910 8639
Check ability to run complex query
118 SS 9019 9330 8840 8220 8199 8529 9210 10089 9390 12000 8269 8630 9359 9019
Check ability to run complex query
119 CS 1440 1490 1620 1440 1420 1480 1339 1329 1200 2069 1000 1469 2129 1399
Common SQL. Check correctness of the results
120 SS 1089 1129 1119 1119 1000 1089 1049 930 870 1000 1109 1120 1029 1159
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-1539
http://tracker.firebirdsql.org/browse/core-1885
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-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-4731
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-6441
http://tracker.firebirdsql.org/browse/core-6479
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/6782
https://github.com/FirebirdSQL/firebird/issues/6817
https://github.com/FirebirdSQL/firebird/issues/6866
https://github.com/FirebirdSQL/firebird/issues/6987

=== end of list ===