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 (3 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 (116 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 (0 rows)
8. All tests: outcomes (2124 rows)
9. All tests: durations (3832 rows)
A. Skipped: tests which was intentionally excluded from execution (4 rows)

Generated 17.09.2021 18:35
Tested: HQ30.   Build: 3.0.8.33490;   CS: 17.09.21 17:14:46 - 17.09.21 18:29:56;   SS: 17.09.21 16:07:50 - 17.09.21 17:11:56;
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.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 X
Test TITLE
1 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
Containing not working correctly
2 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
Containing not working correctly
3 CS 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 X
Domain names and charset issues
4 SS 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 X
Domain names and charset issues
5 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
LIKE doesn't work correctly with collations using SPECIALS-FIRST=1
6 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
LIKE doesn't work correctly with collations using SPECIALS-FIRST=1
7 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
Greek characters in cp1251 vs uppercasing
8 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
Greek characters in cp1251 vs uppercasing
9 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
select * from rdb$triggers where rdb$trigger_source like 'CHECK%'
10 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
select * from rdb$triggers where rdb$trigger_source like 'CHECK%'
11 CS     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 X
CREATE COLLATION connection lost under Posix
12 SS     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 X
CREATE COLLATION connection lost under Posix
13 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
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     F     X 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     F     X 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     F     X 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     F     P P P X 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     F     P P P X 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     F     X 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     F     X 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     F     X 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     F     X 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     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 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     F         F     P P P P P X 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     F         F     P P P P P X 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     F     X 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     F     X 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     F     X 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     F     X 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     F     X 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     F     X 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     F     X 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     F     X 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     F     X 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     F     X 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     F         F     P P P P     E     X 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     F         F     P P P P     E     X 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     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 X
Performance regression when bulk inserting into table with indices
39 SS     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 X
Performance regression when bulk inserting into table with indices
40 CS 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 X
Bad optimization of some operations with views containing subqueries
41 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
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     F     X 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     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 X
slow changes on domain
44 SS     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 X
Wrong transaction can be passed to external engine
45 CS 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 X
Increase number of formats/versions of views from 255 to 32K
46 SS 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 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     F     X 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     F     X 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     F         F     X 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     F         F     X 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     F     X 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     F     X 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     F     X 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     F     X 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     F     X 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     F     X 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     F     X 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     F     X 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     F     X 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     F     X 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     F     X 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     F     X 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     F     X 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     F     X 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     F     X 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     F     X 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     F     X 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     F     X 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     F     X 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     F     X 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     F     X 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     F     X 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     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 X
Many indexed reads in a compound index with NULLs [CORE2709]
74 SS 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 X
Many indexed reads in a compound index with NULLs [CORE2709]
75 CS 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 X
Getting "records fetched" for functions/procedures in trace
76 SS 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 X
Getting "records fetched" for functions/procedures in trace
77 CS 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 X
Command switch "-fetch_password <passwordfile>" does not work with gfix
78 SS 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 X
Command switch "-fetch_password <passwordfile>" does not work with gfix
79 CS 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 X
Some orphan records left at RDB$SECURITY_CLASSES and RDB$USER_PRIVILEGES after DROP PROCEDURE\FUNCTION
80 SS 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 X
Some orphan records left at RDB$SECURITY_CLASSES and RDB$USER_PRIVILEGES after DROP PROCEDURE\FUNCTION
81 CS 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 X
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
82 SS 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 X
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
83 CS 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 X
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
84 SS 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 X
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
85 CS 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 X
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
86 SS 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 X
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
87 CS     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 X
INNER JOIN join order
88 SS     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 X
INNER JOIN join order
89 CS     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 X
LEFT OUTER JOIN with full match, but limited in ON clause
90 SS     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 X
LEFT OUTER JOIN with full match, but limited in ON clause
91 CS     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 X
LEFT OUTER JOIN with STARTING WITH in WHERE clause
92 SS     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 X
LEFT OUTER JOIN with STARTING WITH in WHERE clause
93 CS 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 X
Empty DB - RDB$ROLES
94 SS 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 X
Empty DB - RDB$ROLES
95 CS 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 X
Empty DB - RDB$SECURITY_CLASSES
96 SS 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 X
Empty DB - RDB$SECURITY_CLASSES
97 CS 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 X
Empty DB - RDB$USER_PRIVILEGES
98 SS 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 X
Empty DB - RDB$USER_PRIVILEGES
99 CS     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 X
ISQL - SHOW DATABASE
100 SS     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 X
ISQL - SHOW DATABASE
101 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
GTCS/tests/external-file-06-d. Test for external table with field of DOUBLE PRECISION datatype
102 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
GTCS/tests/external-file-06-d. Test for external table with field of DOUBLE PRECISION datatype
103 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
test for LPAD function, including non-ascii characters.
104 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
test for LPAD function, including non-ascii characters.
105 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
test for RPAD function, including non-ascii characters.
106 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
test for RPAD function, including non-ascii characters.
107 CS 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 X
CREATE ROLE
108 SS 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 X
CREATE ROLE
109 CS 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 X
Common SQL. Check correctness of the results
110 SS 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 X
Common SQL. Check correctness of the results
111 CS 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 X
Common SQL. Check correctness of the results
112 SS 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 X
Common SQL. Check correctness of the results
113 CS 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 X
Check ability to run complex query
114 SS 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 X
Check ability to run complex query
115 CS 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 X
Common SQL. Check correctness of the results
116 SS 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 X
Common SQL. Check correctness of the results

Elapsed time, milliseconds:
NN Test name mode median_ms 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 X
Test TITLE
1 CS 1719 1670 1799 1720 1680 1710 1659 1730 2299 1719 2230 1940 1269
Containing not working correctly
2 SS 1180 1130 1179 1190 1180 1129 1120 1220 1559 1180 1220 1269 940
Containing not working correctly
3 CS 1639 1639 1559 1610 1610 1509 1669 1650 2029 1840 1830 730
Domain names and charset issues
4 SS 1179 1189 1159 1160 1130 1179 1140 1320 1659 1230 1210 449
Domain names and charset issues
5 CS 1549 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 1074 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 1514 1519 1569 1480 1509 1000 1000 1599 2069 1590 1450 1539 1299
Greek characters in cp1251 vs uppercasing
8 SS 1079 1159 1170 1009 1090 990 1099 1029 1490 1119 1069 1059 869
Greek characters in cp1251 vs uppercasing
9 CS 1624 1849 1570 1700 1539 1710 1789 1550 2460 1650 1549 1599 1210
select * from rdb$triggers where rdb$trigger_source like 'CHECK%'
10 SS 1194 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 980 869 869 839 730 839 869 1080 919 859 910 889
CREATE COLLATION connection lost under Posix
12 SS 559 579 550 539 629 560 590 529 850 580 549 519 559
CREATE COLLATION connection lost under Posix
13 CS 3740 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 3155 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 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 1205 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 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 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 1450 1759 1429 1579 1440 1329 1530 1000 1870 1470 1389 1460 1130
Inserting K?se into a CHARACTER SET ASCII column succeeds
20 SS 1074 1200 1109 1099 1009 1209 1029 1059 1339 1079 1049 1069 829
Inserting K?se into a CHARACTER SET ASCII column succeeds
21 CS 1364 1360 1430 1490 1339 1220 1369 1289 1660 1400 1370 1329 870
Blob transliteration may not happen inside the union
22 SS 929 929 1000 919 909 920 929 960 1210 919 969 890 0
Blob transliteration may not happen inside the union
23 CS 1225 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 1554 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 1264 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 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 924 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 6159 6240 5909 6000 5620 6070 6980 7120 7509 6490 6220 6099 6000
EXECUTE BLOCK execution cause server crash
29 SS 6000 5849 6080 5740 5889 7139 6059 5860 7019 6000 6000 6240 5549
EXECUTE BLOCK execution cause server crash
30 CS 1234 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 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 1074 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 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 1440 1410 1520 1400 1470 1630 1319 1400 1920 1769 1420 1460 869
Error on create table with "CHARACTER SET DOS775" field
35 SS 1004 1019 1009 990 1059 1000 1009 980 1270 1009 980 970 529
Error on create table with "CHARACTER SET DOS775" field
36 CS 16154 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 14134 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 15869 15649 17190 15460 15259 13909 15450 16200 18420 17109 15930 15809 16019
Performance regression when bulk inserting into table with indices
39 SS 15665 15909 15819 14559 15279 15519 15279 22789 18589 15710 15620 15000 15960
Performance regression when bulk inserting into table with indices
40 CS 2654 2649 2529 2640 2549 2289 2759 2740 3450 2820 2799 2390 2659
Bad optimization of some operations with views containing subqueries
41 CS 1389 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 894 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 1710 1799 1700 1000 1670 1639 1960 1730 2519 1809 1720 1620 1000
slow changes on domain
44 SS 3074 3039 3159 2970 3140 3089 3220 3079 3590 3029 2940 3069 1509
Wrong transaction can be passed to external engine
45 CS 16839 17019 16659 16339 16410 18269 19719 17959 4859
Increase number of formats/versions of views from 255 to 32K
46 SS 16539 17620 16089 16259 16100 18230 21550 16819 4000
Increase number of formats/versions of views from 255 to 32K
47 CS 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 779 599 660 599 629 619 720 940 660 769 669 549
Field name max length check wrongly if national characters specified
49 CS 1154 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 730 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 1200 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 830 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 4414 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 6895 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 1109 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 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 779 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 450 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 1705 1799 1660 1679 1689 1580 1710 1700 2200 1819 1779
User without ALTER ANY ROLE privilege can use COMMENT ON ROLE
60 SS 1120 1240 1200 1100 1079 1059 1099 1089 1480 1140 1160
User without ALTER ANY ROLE privilege can use COMMENT ON ROLE
61 CS 769 759 759 779 740 870 829 710 960 769
Inconsistent translation "string->timestamp->string->timestamp" in dialect 1
62 SS 460 470 420 430 460 410 490 490 600 420
Inconsistent translation "string->timestamp->string->timestamp" in dialect 1
63 CS 730 769 730 779 730 639 729 710 970 779
CAST of Infinity values to FLOAT doesn't work
64 SS 420 430 420 450 420 379 410 410 639 440
CAST of Infinity values to FLOAT doesn't work
65 CS 4130 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 3660 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 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 1080 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 1289 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 980 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 1119 1369 1159 1049 1000 1059 1119 1079 1489 3009
Implementation of SUBSTRING for UTF8 character set is inefficient
72 SS 759 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 5965 5649 5629 6210 5720 5339 8659 8640 9329
Getting "records fetched" for functions/procedures in trace
76 SS 5234 5090 5049 5069 5379 4810 8159 7769 8000
Getting "records fetched" for functions/procedures in trace
77 CS 2430 2470 2389 2440 2430 1849
Command switch "-fetch_password <passwordfile>" does not work with gfix
78 SS 1940 1960 1940 1960 1930 1549
Command switch "-fetch_password <passwordfile>" does not work with gfix
79 CS 3780 3780 3950 3320 3840 3259
Some orphan records left at RDB$SECURITY_CLASSES and RDB$USER_PRIVILEGES after DROP PROCEDURE\FUNCTION
80 SS 3040 3230 3810 2910 3040 2789
Some orphan records left at RDB$SECURITY_CLASSES and RDB$USER_PRIVILEGES after DROP PROCEDURE\FUNCTION
81 CS 1775 1740 1720 1810 1720 1580 2109 1880 2160 1849 1649 1690 1859
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
82 SS 1465 1400 1509 1450 1000 1480 1589 1420 1639 1370 1360 1549 1629
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
83 CS 1809 1929 1759 1759 1629 1690 2180 2009 2170 2059 1710 1700 1859
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
84 SS 1385 1410 1420 1329 1390 1209 1379 1000 1769 1370 1380 1399 1440
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
85 CS 1940 2060 1859 1940 1879 1649 1919 2009 2619 1940 1889 2099 2069
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
86 SS 1660 1679 1629 1490 1700 1670 1519 1569 1920 1740 1000 1650 1710
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
87 CS 4384 4379 4389 4150 4299 3889 4909 4650 5529 4649 4309 4590 4370
INNER JOIN join order
88 SS 4004 3940 4009 3939 4000 3779 4170 3940 5009 4199 4139 4120 4000
INNER JOIN join order
89 CS 1725 1690 1740 1920 1690 1650 1809 1769 2200 1830 1669 1710 1700
LEFT OUTER JOIN with full match, but limited in ON clause
90 SS 1425 1490 1359 1299 1349 1000 1460 1489 1779 1480 1390 1350 1740
LEFT OUTER JOIN with full match, but limited in ON clause
91 CS 1810 1810 1839 1769 1859 1670 1909 1890 2210 1799 1700 1759 1810
LEFT OUTER JOIN with STARTING WITH in WHERE clause
92 SS 1454 1380 1569 1419 1460 1449 1000 1349 1859 1419 1490 1460 1490
LEFT OUTER JOIN with STARTING WITH in WHERE clause
93 CS 759 730 830 849 759 689 850 0 990 740 730 759 0
Empty DB - RDB$ROLES
94 SS 425 430 419 430 470 410 420 430 630 470 420 409 420
Empty DB - RDB$ROLES
95 CS 895 909 940 799 860 809 1029 890 1129 900 1240 860 889
Empty DB - RDB$SECURITY_CLASSES
96 SS 564 640 539 509 549 529 600 570 870 569 879 539 560
Empty DB - RDB$SECURITY_CLASSES
97 CS 884 870 910 949 849 779 829 839 1129 950 990 899 840
Empty DB - RDB$USER_PRIVILEGES
98 SS 539 579 509 519 589 519 579 530 820 539 549 470 0
Empty DB - RDB$USER_PRIVILEGES
99 CS 774 769 740 790 0 689 0 779 1019 779 769 830 759
ISQL - SHOW DATABASE
100 SS 454 490 430 460 430 399 459 450 669 460 440 400 460
ISQL - SHOW DATABASE
101 CS 2429 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
102 SS 1925 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
103 CS 5059 5030 5009 4940 5000 5349 5419 5099 5759 5009 5110 5089 720
test for LPAD function, including non-ascii characters.
104 SS 4869 4820 4970 4890 4630 5240 5150 4859 6539 4670 4660 4880 399
test for LPAD function, including non-ascii characters.
105 CS 5039 5319 4880 4859 5049 5200 5000 5180 6819 5029 5269 5009 960
test for RPAD function, including non-ascii characters.
106 SS 4759 4830 4730 4509 4650 5149 5129 4670 6039 4619 4789 4950 509
test for RPAD function, including non-ascii characters.
107 CS 814 859 920 779 759 779 779 839 1049 820 809 880 809
CREATE ROLE
108 SS 490 490 570 469 480 480 569 579 700 0 470 460 519
CREATE ROLE
109 CS 1349 1469 1400 1339 1000 1280 1320 1299 1799 1409 1360 1370 1279
Common SQL. Check correctness of the results
110 SS 1019 1120 1019 1009 1019 1000 1019 1019 1460 1079 1019 970 1050
Common SQL. Check correctness of the results
111 CS 1980 2150 1990 1879 1950 2279 1980 2009 2769 1950 1950 1900 1980
Common SQL. Check correctness of the results
112 SS 1625 1779 1600 1610 1610 1769 1680 1529 2330 1609 1620 1690 1630
Common SQL. Check correctness of the results
113 CS 8900 8890 8670 8650 8619 10330 10400 9690 12369 8870 9440 8910 8639
Check ability to run complex query
114 SS 8929 8840 8220 8199 8529 9210 10089 9390 12000 8269 8630 9359 9019
Check ability to run complex query
115 CS 1430 1620 1440 1420 1480 1339 1329 1200 2069 1000 1469 2129 1399
Common SQL. Check correctness of the results
116 SS 1069 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/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

=== end of list ===