0. Total results for each kind of outcome and server mode
1. ERRORS MAP: distribution of Firebird errors which occured during runs (43 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 (2 rows)
[CURRENT] 5. Has fails: tests with at least one fail for previous runs (122 rows)
6. Has runtime errors: tests with at least one runtime error for previous runs (26 rows)
7. FRESH PASSED: successful tests with previous outcome = FAIL/ERROR/SKIPPED or absent (0 rows)
8. All tests: outcomes (2363 rows)
9. All tests: durations (4560 rows)
A. Skipped: tests which was intentionally excluded from execution (5 rows)

Generated 25.05.2022 10:52
Tested: FB50.   Build: 5.0.0.501;   SS: 25.05.22 06:02:36 - 25.05.22 08:28:20;   CS: 25.05.22 08:31:17 - 25.05.22 10:49:39;
OS and hardware info:  Windows 2008ServerR2 6.1.7601 ; logical CPUs: 4 ; total memory: 8.0 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 5.0.0.501
2022-05-25
5.0.0.499
2022-05-24
5.0.0.498
2022-05-21
5.0.0.497
2022-05-20
5.0.0.496
2022-05-19
5.0.0.494
2022-05-14
5.0.0.493
2022-05-12
5.0.0.492
2022-05-07
5.0.0.491
2022-05-06
5.0.0.489
2022-05-01
5.0.0.488
2022-04-25
5.0.0.487
2022-04-24
5.0.0.482
2022-04-23
5.0.0.475
2022-04-16
5.0.0.472
2022-04-12
5.0.0.471
2022-04-10
5.0.0.469
2022-04-08
5.0.0.467
2022-04-07
5.0.0.459
2022-04-06
5.0.0.457
2022-04-04
5.0.0.455
2022-04-03
5.0.0.451
2022-04-02
5.0.0.448
2022-04-01
5.0.0.445
2022-03-31
5.0.0.442
2022-03-30
5.0.0.440
2022-03-28
5.0.0.439
2022-03-25
5.0.0.437
2022-03-24
5.0.0.426
2022-03-11
5.0.0.425
2022-03-08
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     F     P P P P P P P P
Left joining views with null fails
2 SS 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 P P P P P
Left joining views with null fails
3 CS 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 P P P P P
Count ( DISTINCT ... ) is too slow
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 P P P
Count ( DISTINCT ... ) is too slow
5 CS P P P P P P P P P P P     F         F     P P P P P P P P P P P P P P P P P
CHARACTER SET GBK is not installed
6 SS P P P P P P P P P P P     F         F     P P P P P P P P P P P P P P P P P
CHARACTER SET GBK is not installed
7 CS P 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 P P
Expression index based on computed fields
8 SS P 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 P P
Expression index based on computed fields
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     F     P P P P P P
Incorrect column values with outer joins and views
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     F     P P P P P P
Incorrect column values with outer joins and views
11 CS P P 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 P P P
Can't transliterate character set when look at procedure text in database just created from script (and thus in ODS 11.1)
12 SS P P 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 P P P
Can't transliterate character set when look at procedure text in database just created from script (and thus in ODS 11.1)
13 CS 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 P P P P P
CREATE COLLATION connection lost under Posix
14 SS 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 P P P P P
CREATE COLLATION connection lost under Posix
15 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 P     F     P P
"EXECUTE BLOCK" statement does not support "CREATE USER"
16 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 P     F     P P
"EXECUTE BLOCK" statement does not support "CREATE USER"
17 CS 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 P P P P P
BUGCHECK 284 (cannot restore singleton select data (284), file: rse.cpp ...)
18 SS 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 P P P P P
BUGCHECK 284 (cannot restore singleton select data (284), file: rse.cpp ...)
19 CS 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 P P P P P
The famous "cannot transliterate" error may be thrown when selecting data from the monitoring tables
20 SS 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 P P P P P
The famous "cannot transliterate" error may be thrown when selecting data from the monitoring tables
21 SS P P P P P P     F     P P     F     P P P P     F     P P P P P P P P P P P P P     F     P
Write note into log when automatic sweep is started
22 CS P P 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 P P P
Prohibit any improper mixture of explicit and implicit joins
23 SS P P 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 P P P
Prohibit any improper mixture of explicit and implicit joins
24 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 P P P P
Incorrect LEFT JOIN result using table and derived constant subquery
25 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 P P P P
Incorrect LEFT JOIN result using table and derived constant subquery
26 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 P     F     P P
page 0 is of wrong type (expected 6, found 1)
27 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 P     F     P P
page 0 is of wrong type (expected 6, found 1)
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 P P     F     P P
Ability to cancel waiting in lock manager
29 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 P P P
Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types
30 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 P P P
Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types
31 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 P     F     P P
AV in engine when preparing query against dropping table
32 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 P     F     P P
AV in engine when preparing query against dropping table
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 P P P
Usage of a NATURAL JOIN with a derived table crashes the server
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 P P P P
Usage of a NATURAL JOIN with a derived table crashes the server
35 CS 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 P P P P P
Check result when joined fields are created via row_number() function
36 SS 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 P P P P P
Check result when joined fields are created via row_number() function
37 CS 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 P P P P P
Regression: Can not run ALTER TABLE DROP CONSTRAINT <FK_name> after recent changes in svn
38 SS 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 P P P P P
Regression: Can not run ALTER TABLE DROP CONSTRAINT <FK_name> after recent changes in svn
39 CS 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 P P P P P
Can`t create two collations with different names if autoddl OFF in FB 2.5.3
40 SS 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 P P P P P
Can`t create two collations with different names if autoddl OFF in FB 2.5.3
41 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 P P P
OR/IN predicates for RDB$DBKEY lead to NATURAL plan
42 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 P P P
OR/IN predicates for RDB$DBKEY lead to NATURAL plan
43 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 P P P
Allow hash/merge joins for non-field (dbkey or derived expression) equalities
44 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 P P P
Allow hash/merge joins for non-field (dbkey or derived expression) equalities
45 CS P P 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 P P P
Select from mon$table_stats doesn`t work on SC and CS
46 SS P P 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 P P P
Select from mon$table_stats doesn`t work on SC and CS
47 CS P 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 P P
Computed index based on a computed column stores NULL for all its keys
48 SS P 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 P P
Computed index based on a computed column stores NULL for all its keys
49 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 P P P
HASH/MERGE JOIN is not used for more than two streams if they are joined via USING/NATURAL clauses and join is based on DBKEY concatenations
50 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 P P P
HASH/MERGE JOIN is not used for more than two streams if they are joined via USING/NATURAL clauses and join is based on DBKEY concatenations
51 CS P P 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 P P P
ISQL input command (or -i option) reads large (> 64K) lines incorrectly
52 SS P P 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 P P P
ISQL input command (or -i option) reads large (> 64K) lines incorrectly
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 P P     F     P P
Regression. Triger on DISCONNECT with dynamic SQL (ES 'insert into ...'): 1) does not work in 3.0; 2) leads FB to crash when it is recreated
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 P P     F     P P
Regression. Triger on DISCONNECT with dynamic SQL (ES 'insert into ...'): 1) does not work in 3.0; 2) leads FB to crash when it is recreated
55 CS P 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 P P
Indices on computed fields are broken after restore (all keys are NULL)
56 SS P 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 P P
Indices on computed fields are broken after restore (all keys are NULL)
57 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 P     F     P P
Improve consistency in GRANT syntax between roles and privileges according to SQL standard
58 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 P     F     P P
Improve consistency in GRANT syntax between roles and privileges according to SQL standard
59 CS     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         F         F         F         F         F    
Timeout for IDLE connection (SET SESSION IDLE TIMEOUT <N>)
60 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         F         F         F         F         F    
Timeout for IDLE connection (SET SESSION IDLE TIMEOUT <N>)
61 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 P P P
Error "block size exceeds implementation restriction" while inner joining large datasets with a long key using the HASH JOIN plan
62 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 P P P
Error "block size exceeds implementation restriction" while inner joining large datasets with a long key using the HASH JOIN plan
63 SS 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 P P P P
slow changes on domain
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 P P P     F         F    
Parse error when compiling a statement causes memory leak until attachment is disconnected
65 CS     F     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 P P P P
SIMILAR TO is substantially (500-700x) slower than LIKE on trivial pattern matches with VARCHAR data.
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 P P P
Sometime it is impossible to cancel\kill connection executing external query
67 CS 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 P P P P P
Multiple error in REVOKE operator
68 SS 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 P P P P P
Multiple error in REVOKE operator
69 CS 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 P P P P P
There is no check of existance generator and exception when privileges are granted
70 SS 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 P P P P P
There is no check of existance generator and exception when privileges are granted
71 CS 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 P P P P P
ISQL issues with increased identifier length
72 SS 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 P P P P P
ISQL issues with increased identifier length
73 CS P P 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 P P P
Creating of the large procedure crashes the server.
74 SS P P 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 P P P
Creating of the large procedure crashes the server.
75 CS P P P P P P P P P P P     F         F     P P P P P P P P P P P P P P P P P
Regression in FB 4.x: error "Implementation of text subtype <NNNN> not located" on attempt to use some collations defined in fbintl.conf
76 SS P P P P P P P P P P P     F         F     P P P P P P P P P P P P P P P P P
Regression in FB 4.x: error "Implementation of text subtype <NNNN> not located" on attempt to use some collations defined in fbintl.conf
77 CS P 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 P P
Ability to query Firebird configuration using SQL
78 SS P 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 P P
Ability to query Firebird configuration using SQL
79 SS P P P P P     F     P P P P P P P P P P P P P P P P P P P P P P P P
Regression: Cancel Query function no longer works
80 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     P P P
Slow performance when executing SQL scripts as non-SYSDBA user [CORE5966]
81 SS 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 P P P P P
Slow performance when executing SQL scripts as non-SYSDBA user [CORE5966]
82 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 P P P
Problem when restoring the database on FB 4.0 RC1 (gbak regression)
83 CS P P P P P P P P     F     P     F     P P P     F     P     F     P P P P P P P P P P     F         F         F    
When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired
84 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 P P P     F    
When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired
85 CS P P P P P     F     P P P P P P P P P P P P     F     P     F     P P P P     F     P P P P
Indexed STARTING WITH execution is very slow with UNICODE collation
86 SS 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 P P P P P
Indexed STARTING WITH execution is very slow with UNICODE collation
87 CS P P 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 P P P
INNER JOIN join merge and VIEWs
88 SS P P 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 P P P
INNER JOIN join merge and VIEWs
89 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 P P P
INNER JOIN join merge and SP
90 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 P P P
INNER JOIN join merge and SP
91 CS 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 P P P P P
LEFT OUTER JOIN with full match, but limited in ON clause
92 SS 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 P P P P P
LEFT OUTER JOIN with full match, but limited in ON clause
93 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 P P P
Mixed JOINS
94 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 P P P
Mixed JOINS
95 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 P P P
Mixed JOINS
96 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 P P P
Mixed JOINS
97 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 P P P
Mixed JOINS
98 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 P P P
Mixed JOINS
99 CS 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 P P P P P
Empty DB - RDB$COLLATIONS
100 SS 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 P P P P P
Empty DB - RDB$COLLATIONS
101 CS 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 P P P P P
SHOW SYSTEM parameters
102 SS 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 P P P P P
SHOW SYSTEM parameters
103 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 P P P P
Query for test multiple CTEs
104 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 P P P P
Query for test multiple CTEs
105 CS P P 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 P P P
Common SQL. Check correctness of the results
106 SS P P 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 P P P
Common SQL. Check correctness of the results
107 CS 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 P P P P P
Check ability of outer join simplification.
108 SS 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 P P P P P
Check ability of outer join simplification.
109 CS 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 P P P P P
Check ability of outer join simplification.
110 SS 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 P P P P P
Check ability of outer join simplification.
111 CS 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 P P P P P
Check ability of outer join simplification.
112 SS 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 P P P P P
Check ability of outer join simplification.
113 CS 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 P P P P P
Check ability of outer join simplification.
114 SS 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 P P P P P
Check ability of outer join simplification.
115 CS 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 P P P P P
Check ability of outer join simplification.
116 SS 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 P P P P P
Check ability of outer join simplification.
117 CS P P 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 P P P
Compiler check. Test ability to compile source code of OLTP-EMUL test.
118 SS P P 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 P P P
Compiler check. Test ability to compile source code of OLTP-EMUL test.
119 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 P P P P
Common SQL. Check correctness of the results
120 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 P P P P
Common SQL. Check correctness of the results
121 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         F     P P
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
122 SS P P 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     F     P P
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.

Elapsed time, milliseconds:
NN Test name mode median_ms 5.0.0.501
2022-05-25
5.0.0.499
2022-05-24
5.0.0.498
2022-05-21
5.0.0.497
2022-05-20
5.0.0.496
2022-05-19
5.0.0.494
2022-05-14
5.0.0.493
2022-05-12
5.0.0.492
2022-05-07
5.0.0.491
2022-05-06
5.0.0.489
2022-05-01
5.0.0.488
2022-04-25
5.0.0.487
2022-04-24
5.0.0.482
2022-04-23
5.0.0.475
2022-04-16
5.0.0.472
2022-04-12
5.0.0.471
2022-04-10
5.0.0.469
2022-04-08
5.0.0.467
2022-04-07
5.0.0.459
2022-04-06
5.0.0.457
2022-04-04
5.0.0.455
2022-04-03
5.0.0.451
2022-04-02
5.0.0.448
2022-04-01
5.0.0.445
2022-03-31
5.0.0.442
2022-03-30
5.0.0.440
2022-03-28
5.0.0.439
2022-03-25
5.0.0.437
2022-03-24
5.0.0.426
2022-03-11
5.0.0.425
2022-03-08
Test TITLE
1 CS 1845 1840 1900 1870 1850 1840 1840 1870 1890 1950 2170 1660 890 1510 1670 1620 1880 1630 1630 960 1730 2000 1950 1890 1770 1980 1870 1980 1940 1730 1730
Left joining views with null fails
2 SS 1965 1940 2340 2390 2000 1950 2010 2430 1990 2440 1980 1900 1080 1170 2570 1900 1950 1990 1950 1090 1960 2040 1970 2030 1950 1960 2260 1930 1950 1900 1970
Left joining views with null fails
3 CS 6250 6240 6260 6270 6210 6240 6280 6390 6260 6230 6580 7550 5540 5640 6540 6180 6230 6060 6170 5730 6310 6000 6840 6540 6340 6430 6300 6190 6210 6160 7120
Count ( DISTINCT ... ) is too slow
4 SS 6210 7440 7780 6300 6240 6120 6100 6900 6890 7680 6210 5930 4890 5880 7830 6410 6160 6640 6380 5040 6190 6200 6000 7410 7240 6210 11480 6140 6130 6160 6100
Count ( DISTINCT ... ) is too slow
5 CS 1720 1720 1810 1740 1710 1740 1730 1740 1700 1720 1840 1580 2840 1590 1600 1530 2240 1520 1530 1040 1700 2320 1720 1740 1720 1840 1710 1720 1710 1720 1720
CHARACTER SET GBK is not installed
6 SS 1920 1850 1850 1890 1900 1970 2000 9910 2370 2000 1960 1840 4440 4000 1890 1920 1920 1920 1930 1000 1840 2440 1880 1840 1840 1950 2040 1900 1900 1840 1920
CHARACTER SET GBK is not installed
7 CS 1730 1840 1800 1850 1720 1840 1980 1740 1880 1000 1730 1690 900 1060 1660 1610 2180 1590 1630 950 1730 1920 1880 1720 1730 2110 1710 1820 1920 1720 2070
Expression index based on computed fields
8 SS 1985 1950 1980 1920 2030 2070 4740 15180 2030 2050 2090 1920 1070 1190 1980 1980 1980 2030 2030 1090 1930 2040 1930 1970 1990 2010 2220 2020 2010 1880 1970
Expression index based on computed fields
9 CS 2195 2210 2160 2200 2200 2180 2170 2490 2220 2220 2180 3390 1030 1380 2190 1980 1960 2010 1960 1320 2190 2200 2310 2810 2170 2310 2310 2240 2300 2140 2240
Incorrect column values with outer joins and views
10 SS 2400 2400 2400 2400 2380 2390 4130 2870 2900 2430 2840 2340 1360 1320 2430 2380 2400 2840 2420 1280 2400 2390 2390 2400 2440 2390 2850 2390 2400 2370 2450
Incorrect column values with outer joins and views
11 CS 1355 1400 1290 1410 1440 1290 1350 1760 1000 1540 1420 1520 640 780 1340 1210 800 1260 820 690 1360 2700 1420 1540 1310 1450 1470 1420 1490 840 1310
Can't transliterate character set when look at procedure text in database just created from script (and thus in ODS 11.1)
12 SS 1090 1060 1100 1080 1070 1080 2450 1470 5260 1110 1600 1030 770 890 1230 1340 1080 1220 1040 800 1060 10700 1080 1280 1310 1370 1260 1080 1280 1070 1000
Can't transliterate character set when look at procedure text in database just created from script (and thus in ODS 11.1)
13 CS 1665 1650 1670 1650 1650 1700 1710 1710 2000 1910 1720 1580 680 1060 1000 1570 1520 1000 1590 1370 1710 1730 1670 1800 1730 1660 1810 2220 2290 1640 1000
CREATE COLLATION connection lost under Posix
14 SS 1950 1920 1930 1950 1980 1950 3570 1950 2000 2030 2020 1870 980 1120 1920 1950 2470 1970 2210 1030 1920 1930 1980 1990 1980 1960 2230 1950 1950 1860 2290
CREATE COLLATION connection lost under Posix
15 CS 1700 1700 1730 1680 1700 1700 1710 1780 1870 1730 1730 1600 790 1440 1610 1540 1570 1550 1560 980 1810 1720 1720 1700 1730 1730 3640 1810 1700 1690 1680
"EXECUTE BLOCK" statement does not support "CREATE USER"
16 SS 1860 1810 1870 1830 1840 1840 3660 1890 1900 1860 1930 1840 1000 1140 1870 1840 1990 1860 1860 1040 1880 1850 1840 1860 1890 1860 2400 1880 1840 1910 1920
"EXECUTE BLOCK" statement does not support "CREATE USER"
17 CS 2150 2160 2130 2150 2210 2160 2140 2180 2170 2150 2200 2100 950 1200 2030 2070 2150 3220 2070 1140 2160 2180 2300 2180 2270 2220 2990 2120 2140 2120 2150
BUGCHECK 284 (cannot restore singleton select data (284), file: rse.cpp ...)
18 SS 2395 2390 2370 2390 2370 2370 2390 2440 2400 2420 2830 2420 1290 1410 2440 2710 2430 2880 2430 1290 2370 2390 2510 2370 2440 2380 2860 2370 2390 2400 2440
BUGCHECK 284 (cannot restore singleton select data (284), file: rse.cpp ...)
19 CS 5865 5790 5770 5810 5830 5860 9410 6470 6580 6330 6600 5760 3760 3840 5600 6190 5690 5520 6100 3800 5670 5890 6450 6670 5870 5790 6630 6410 6420 5590 6430
The famous "cannot transliterate" error may be thrown when selecting data from the monitoring tables
20 SS 6330 5960 5930 5990 8920 8000 9130 8850 8970 9000 9110 5000 3610 4720 8310 8780 5880 8930 5770 3810 5880 6320 6340 5950 6410 6410 7600 7190 6000 5920 5840
The famous "cannot transliterate" error may be thrown when selecting data from the monitoring tables
21 SS 11425 11420 11410 11370 11350 11420 11530 11970 11840 11590 11420 11410 9190 10590 11450 11330 11530 11470 11680 10590 11420 11450 11430 11540 11510 11450 14390 11400 11420 11370 11570
Write note into log when automatic sweep is started
22 CS 2200 2190 2200 2200 2200 2200 2200 2180 2180 2180 2790 2060 1030 1330 2270 2510 2200 2390 1980 1870 2280 5460 2170 2170 2200 2170 5440 2200 2180 2280 2170
Prohibit any improper mixture of explicit and implicit joins
23 SS 2450 2450 2470 2470 2440 2450 2520 2460 2440 2430 2830 2450 1290 1330 2460 2420 2450 2480 2460 1340 2420 3320 2420 2410 2560 2430 2870 2420 2420 2480 2480
Prohibit any improper mixture of explicit and implicit joins
24 CS 2190 2170 2260 2200 2150 2360 2140 2160 2200 2190 2200 2020 930 1080 2080 2330 1900 1960 1920 1160 2200 3890 2140 2190 2190 2260 2710 2290 2140 2270 2190
Incorrect LEFT JOIN result using table and derived constant subquery
25 SS 2390 2350 2380 2370 2370 2400 2430 2390 2400 2490 2880 2400 1260 1380 2380 3000 2380 2390 2400 1890 2370 2350 2390 2360 2460 2400 2950 2370 2370 2410 2410
Incorrect LEFT JOIN result using table and derived constant subquery
26 CS 3185 3070 3080 3090 3290 3000 3190 3400 3220 3130 3290 4030 1220 2590 2970 2900 3040 3370 3680 1590 3180 3140 3420 3590 3270 3460 4050 3200 3200 3100 3100
page 0 is of wrong type (expected 6, found 1)
27 SS 2640 2520 2560 2560 2530 2590 2730 2620 2640 2890 2640 2590 1440 1590 2850 2700 3080 2580 3340 1530 2630 2900 2870 2840 2700 2920 3980 2610 2740 2600 2690
page 0 is of wrong type (expected 6, found 1)
28 CS 5465 5460 5350 5620 5230 5360 6130 5630 6220 5890 6380 4910 1980 2870 5490 5510 6260 5000 5470 3400 5070 5430 5370 5340 5630 6080 6000 5600 6990 5150 5450
Ability to cancel waiting in lock manager
29 CS 1640 1630 1640 1640 1640 1640 1670 1650 1640 1650 1680 1550 790 1000 1560 1510 1520 1000 1000 950 1690 1810 1640 1660 1000 1650 2880 1660 1640 1780 1650
Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types
30 SS 1830 1840 1830 1830 1840 1840 1830 1830 1860 1830 1870 1780 1060 1770 1840 1820 1890 2260 1920 1010 1810 1840 1810 1830 2130 1880 2140 1810 1830 1820 1870
Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types
31 CS 2585 2620 2590 2550 2540 2580 2620 2630 2560 2630 2650 2490 1390 1340 2490 2370 2320 2330 2320 1230 2590 3230 2530 2590 2680 2580 5430 2610 2640 3050 3100
AV in engine when preparing query against dropping table
32 SS 2920 2890 2880 2920 2900 2910 3020 2940 2950 3030 3000 2880 1590 2640 2900 2950 2930 3350 3030 1580 2870 2900 2880 2920 3370 2960 3430 2880 2920 3050 3150
AV in engine when preparing query against dropping table
33 CS 3105 3040 3090 3040 3080 3160 3140 3170 3170 3260 3210 2510 1170 1540 4070 2960 3310 2820 3370 1640 3040 3130 3040 3120 3300 3070 4700 3070 3660 2640 3140
Usage of a NATURAL JOIN with a derived table crashes the server
34 SS 2985 2950 2930 2950 2960 2950 3020 3070 3040 3020 3080 2980 1600 1700 3000 2990 2980 3010 3020 2180 2940 3070 2970 2930 3080 2960 3450 3290 2940 3030 3060
Usage of a NATURAL JOIN with a derived table crashes the server
35 CS 2230 2230 2220 2000 2210 2230 2240 2270 2240 2440 2760 2200 1100 1330 2230 2130 2110 2090 2200 1290 2290 2410 2230 2230 3150 2000 3860 2320 2320 2360 2370
Check result when joined fields are created via row_number() function
36 SS 2555 2560 2530 2520 2530 2550 2540 2560 2560 2540 2600 2530 1340 1000 2510 2830 2570 3030 2570 1960 2510 2520 2540 2510 2640 2660 3300 2680 2630 2670 2700
Check result when joined fields are created via row_number() function
37 CS 2310 2300 2340 2320 2330 2340 2340 2390 2590 2520 2350 2240 1230 1310 2340 2110 2040 2410 2040 1730 2180 2180 2300 2330 2190 2180 3460 2180 2480 2190 2360
Regression: Can not run ALTER TABLE DROP CONSTRAINT <FK_name> after recent changes in svn
38 SS 2530 2530 2560 2590 2490 2510 2540 2850 2870 2980 3010 2520 1380 1400 2550 2550 2540 2480 2530 1360 2000 2560 2530 2590 2480 2000 3180 2480 2480 2520 2530
Regression: Can not run ALTER TABLE DROP CONSTRAINT <FK_name> after recent changes in svn
39 CS 2220 2230 2350 2340 2360 2230 2200 2230 2000 2230 2480 2080 920 1070 2000 1980 2740 1980 2110 1610 2180 2220 2140 2160 2350 2240 3510 2220 2170 2220 2220
Can`t create two collations with different names if autoddl OFF in FB 2.5.3
40 SS 2490 2420 2000 2470 2430 2450 2000 2490 2510 2530 2780 2460 1290 1450 2490 2530 2440 2900 2540 1280 2520 2590 2540 2480 2930 2570 3040 2540 2470 2460 2530
Can`t create two collations with different names if autoddl OFF in FB 2.5.3
41 CS 2165 2190 2200 2170 2150 2340 2150 2190 2180 2190 2390 2030 970 1330 2060 1940 1980 1890 1920 1060 2200 2170 2160 2170 2340 2180 3650 2000 2190 2160 2140
OR/IN predicates for RDB$DBKEY lead to NATURAL plan
42 SS 2420 2370 2450 2390 2390 2420 2400 2460 2450 2420 2510 3030 1000 1460 2420 2420 2460 2410 2430 1760 2370 2390 2370 2790 2390 2450 3260 2370 2680 2430 2800
OR/IN predicates for RDB$DBKEY lead to NATURAL plan
43 CS 2165 2190 2200 2190 2160 2180 2150 2190 2170 2160 2200 2030 890 1140 2060 1940 2020 1990 1940 1090 2210 3420 2140 2220 2290 2170 3710 2180 2150 2150 2230
Allow hash/merge joins for non-field (dbkey or derived expression) equalities
44 SS 2415 2390 2400 2410 2400 2380 2420 2450 2450 2420 2460 2910 1260 1310 2390 2420 2410 2430 2420 1810 2410 3000 2420 2410 2420 2410 3080 2400 2400 2520 2470
Allow hash/merge joins for non-field (dbkey or derived expression) equalities
45 CS 2895 2870 2860 2960 2900 2870 2880 2900 2930 3040 2980 2790 1780 2370 3010 3490 3040 2850 2870 2060 3000 3290 2860 2960 2900 2960 4370 2890 2840 2890 2870
Select from mon$table_stats doesn`t work on SC and CS
46 SS 2700 2650 2000 2690 2680 2710 2660 3060 3130 3100 2820 2700 1620 1710 2730 2000 2760 2690 2680 1630 2670 3510 2740 2700 2740 2760 3610 2700 2660 2730 2780
Select from mon$table_stats doesn`t work on SC and CS
47 CS 2155 2150 2170 2140 2170 2170 2190 2170 2150 2150 2180 2040 1030 1060 2090 2670 1970 1970 2060 1290 2170 2160 2130 2190 2140 2170 3630 2170 2150 2170 2210
Computed index based on a computed column stores NULL for all its keys
48 SS 2485 2460 2550 2490 2470 2530 2550 2840 2850 2850 2480 2420 1300 1440 2580 2510 2450 2510 2570 1340 2460 2490 2560 2000 2460 2650 2920 2480 2470 2420 2000
Computed index based on a computed column stores NULL for all its keys
49 CS 2470 2510 2520 2530 2450 2000 2480 2430 2460 2560 2590 2310 1310 1640 2700 2260 2330 2230 2000 1560 2490 3150 2440 2450 2580 2590 4680 2590 2480 2380 2480
HASH/MERGE JOIN is not used for more than two streams if they are joined via USING/NATURAL clauses and join is based on DBKEY concatenations
50 SS 2805 2790 2000 2820 2730 2790 2730 2810 2820 2800 2810 2700 1600 2630 3070 2700 3120 2810 3440 1730 2880 3600 2800 2820 3190 3210 3220 2780 2770 2810 2780
HASH/MERGE JOIN is not used for more than two streams if they are joined via USING/NATURAL clauses and join is based on DBKEY concatenations
51 CS 5160 5040 5160 5160 5060 5110 5220 6400 5160 5180 5550 4760 4260 3820 4830 5940 4000 4540 4910 3700 5300 5070 5850 6800 5240 5680 6900 5380 5330 4630 5240
ISQL input command (or -i option) reads large (> 64K) lines incorrectly
52 SS 5295 5160 5180 5350 5260 5390 5350 5320 5740 5300 5480 4960 4030 4070 5430 5330 5260 5290 5460 5490 5270 5460 5240 5220 5350 5290 7360 5270 5210 5100 5680
ISQL input command (or -i option) reads large (> 64K) lines incorrectly
53 CS 8155 8160 8010 8160 8320 8400 8060 8180 8160 8190 8000 8180 5360 5430 8230 8270 7930 8110 8000 5350 8070 8200 8420 8050 9140 8110 11480 8690 8150 7810 7990
Regression. Triger on DISCONNECT with dynamic SQL (ES 'insert into ...'): 1) does not work in 3.0; 2) leads FB to crash when it is recreated
54 SS 8100 8110 8060 8050 8030 8080 7960 8050 8130 8160 8170 9120 4890 5330 8030 8340 8000 8180 8110 5190 7930 8090 8110 7940 8190 8120 10450 8030 8190 8110 8170
Regression. Triger on DISCONNECT with dynamic SQL (ES 'insert into ...'): 1) does not work in 3.0; 2) leads FB to crash when it is recreated
55 CS 5740 6120 5640 5770 5740 5740 5740 5000 5960 5780 5780 5620 3670 4400 5630 5270 5370 5670 6170 3290 5990 6270 5560 5760 6100 5820 7880 5720 5770 5880 5690
Indices on computed fields are broken after restore (all keys are NULL)
56 SS 5960 5900 5910 5960 5900 5940 5960 6000 6640 6680 6770 5870 3510 5180 5970 5960 6020 5940 6000 3650 5890 5900 6000 5870 5980 5980 7340 6510 5920 6010 5940
Indices on computed fields are broken after restore (all keys are NULL)
57 CS 6585 6600 6600 6520 6560 6660 6710 6600 7100 6850 6000 7400 2410 3530 6830 6740 6270 6490 8000 2920 6540 6770 6320 6570 7150 6530 8740 6550 6530 6160 6900
Improve consistency in GRANT syntax between roles and privileges according to SQL standard
58 SS 8085 8100 8130 8080 8130 8120 7890 8000 8090 8080 8280 8020 3820 3970 8070 8190 8150 9150 8190 3820 7890 8160 8080 7900 8120 8190 9090 7890 7940 8080 8130
Improve consistency in GRANT syntax between roles and privileges according to SQL standard
59 CS 8875 8890 8880 8800 8890 8920 8880 9000 9000 9220 8900 8670 6550 6970 8720 8600 8630 8600 8730 6860 8720 8940 9010 8860 8880 8870 10700 8900 8830 8830 9190
Timeout for IDLE connection (SET SESSION IDLE TIMEOUT <N>)
60 SS 8525 8430 8470 8620 8520 8580 10940 9070 8590 8580 8530 8410 6600 7410 8450 8600 9000 9020 9310 6800 8600 8620 8490 8490 8000 8490 10050 8570 8470 8490 8510
Timeout for IDLE connection (SET SESSION IDLE TIMEOUT <N>)
61 CS 15405 15840 15000 16180 15620 15650 15300 15400 15070 15290 15740 15860 13680 16010 16230 15000 14970 17630 14920 14100 15100 15300 15890 16030 16300 15410 25980 15260 14970 15020 15440
Error "block size exceeds implementation restriction" while inner joining large datasets with a long key using the HASH JOIN plan
62 SS 14565 14870 14740 14740 14590 15400 31760 14490 14320 14920 14540 15160 12720 15560 14380 14190 14850 14520 14470 12580 14350 14630 14540 14760 14540 14310 20950 14320 15820 14270 14860
Error "block size exceeds implementation restriction" while inner joining large datasets with a long key using the HASH JOIN plan
63 SS 3455 3420 3400 3430 3460 3470 6170 3460 3450 3540 3560 3420 2000 2570 3430 3620 3490 3510 3440 2380 3470 3000 3470 3400 3520 3400 4960 3450 3000 3460 3490
slow changes on domain
64 SS 2840 2780 2000 2840 2820 2890 4120 3180 2850 2870 2890 2830 1760 1710 2800 3610 2850 2870 2840 1700 2830 2880 2840 2820 2850 2810 3930 2790 2960 2830 2880
Parse error when compiling a statement causes memory leak until attachment is disconnected
65 CS 15825 15950 15660 15800 15850 15690 15710 15720 15870 15770 16130 15830 14740 16490 15830 15680 15580 15630 15740 15650 16000 16280 15000 15840 15860 15820 25070 15730 15930 15900 15830
SIMILAR TO is substantially (500-700x) slower than LIKE on trivial pattern matches with VARCHAR data.
66 CS 26725 26870 26850 26630 26720 26760 26830 27080 26770 26630 26970 26520 23560 23860 26580 26550 26490 26530 26550 24830 26630 26990 26730 26950 26940 27090 29180 26640 26800 26580 26770
Sometime it is impossible to cancel\kill connection executing external query
67 CS 2285 2280 2310 2000 2310 2240 2420 2300 2280 2270 2440 2120 1400 1670 2140 2280 2150 2450 2360 1470 2310 2300 2310 2360 2370 2290 3560 2530 2260 2260 2240
Multiple error in REVOKE operator
68 SS 2370 2320 2360 2390 2360 2340 4850 2540 2370 2400 2410 2350 1450 1520 2340 2450 2420 2370 2400 1550 2380 2340 2370 2350 2350 2390 3290 2410 2680 2340 2340
Multiple error in REVOKE operator
69 CS 2180 2190 2180 2150 2170 2170 2200 2460 2000 2140 2340 2090 950 1700 2110 1990 2320 2050 1990 1200 2340 2180 2000 2330 2310 2220 4000 2190 2180 2240 2200
There is no check of existance generator and exception when privileges are granted
70 SS 2460 2420 2400 2440 2400 2470 3990 2850 2480 2990 2790 2510 1260 1330 2420 2760 2460 2470 2470 1290 2460 2430 2460 2440 2460 2450 3230 2470 2340 2450 2470
There is no check of existance generator and exception when privileges are granted
71 CS 2180 2200 2180 2170 2150 2230 2150 2300 2210 2140 2230 2120 950 1350 2090 1980 2000 2000 2000 1810 2200 2190 2180 2220 2290 2180 4040 2440 2360 2200 2180
ISQL issues with increased identifier length
72 SS 2465 2460 2510 2420 2420 2440 4000 2460 2450 2460 2480 3120 1320 1450 2730 2470 2490 2440 2510 1760 2430 2960 2740 2790 2510 2790 2950 2400 2430 2450 2840
ISQL issues with increased identifier length
73 CS 2330 2320 2330 2320 2370 2360 2350 2340 2330 2290 2420 2160 1060 1360 2220 2650 2090 2360 2570 1650 2320 3850 2330 2340 2660 2370 3330 2270 2450 2280 2290
Creating of the large procedure crashes the server.
74 SS 2560 2510 2560 2510 2520 2530 4590 2540 2580 2560 2590 2510 1410 1470 2540 2650 2580 2580 2600 1530 2520 3390 2560 2490 2640 2590 2940 2510 2850 2540 2620
Creating of the large procedure crashes the server.
75 CS 87155 85800 86000 86030 85660 85460 85160 87450 86940 89680 93770 98530 101430 87810 91790 88630 86850 86270 92140 59930 86910 87390 86940 87280 87670 87030 125360 88690 88830 82780 87000
Regression in FB 4.x: error "Implementation of text subtype <NNNN> not located" on attempt to use some collations defined in fbintl.conf
76 SS 106405 105610 105600 105000 105740 105650 195430 105930 106860 105690 107160 115570 71420 96100 109920 105950 110820 108600 112940 54770 105880 109690 109450 109980 109640 110280 139610 105560 105490 105210 108940
Regression in FB 4.x: error "Implementation of text subtype <NNNN> not located" on attempt to use some collations defined in fbintl.conf
77 CS 8020 7830 7890 8010 7820 9270 10110 8040 8110 8030 8130 8390 5010 5660 7990 7880 8000 7870 8050 6150 8080 7710 7830 8320 8160 8440 8550 8110 8160 7970 7680
Ability to query Firebird configuration using SQL
78 SS 7665 7470 7640 7930 7990 7720 9870 7490 7760 7440 7670 7690 5410 5520 7930 8170 7630 7930 7590 5540 7660 7440 7660 7670 7850 7550 9580 7570 7800 7580 7950
Ability to query Firebird configuration using SQL
79 SS 4740 4710 4000 4720 4730 4740 20380 4740 4760 4770 4790 4740 3420 3480 4710 5100 4740 4930 5150 3480 4770 4790 4730 4770 4880 4740 6610 4680 4780 4740 4760
Regression: Cancel Query function no longer works
80 CS 21450 21370 21420 21360 21340 21200 21000 21790 21450 21360 22150 31620 21590 23190 21790 21510 21350 21390 28950 21140 21450 21420 21610 21450 21930 21340 33550 26890 21560 21280 21640
Slow performance when executing SQL scripts as non-SYSDBA user [CORE5966]
81 SS 21840 21520 21530 21710 21560 21430 21630 21840 21620 21000 22260 31920 22360 24580 24260 21880 21760 21920 21840 29470 21590 27200 24180 32010 21720 21680 32950 21690 21850 21370 27140
Slow performance when executing SQL scripts as non-SYSDBA user [CORE5966]
82 SS 202420 194060 195120 196110 197150 196110 242180 203440 206400 205400 211510 208370 208910 251760 200200 207390 199600 209100 208050 203280 197000 197310 197140 196220 203000 196130 309390 202630 200370 202210 201180
Problem when restoring the database on FB 4.0 RC1 (gbak regression)
83 CS 23150 23120 23130 23150 23170 23110 23440 23200 23170 23200 23370 23940 21770 21980 23000 22920 22930 22930 23150 22070 23050 23150 23150 23160 23150 23120 23810 23170 23170 23120 23200
When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired
84 SS 22940 22910 22930 22930 22920 22920 22930 22940 22930 22880 22960 23340 22010 22180 22950 22970 23090 22940 22950 22070 22930 23040 23010 23130 23290 23240 23130 22990 22920 22940 23010
When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired
85 CS 15390 14960 14980 15020 15040 14820 15660 15340 15490 15240 15430 16540 15860 15990 15160 15100 15740 15710 15000 14710 15740 15650 16490 15100 16890 15350 22980 15730 15460 14680 14870
Indexed STARTING WITH execution is very slow with UNICODE collation
86 SS 15085 14510 14680 14800 14560 14540 15270 15150 15220 15020 15000 16170 14910 23810 14970 15180 15570 15440 14780 18600 15310 15290 15590 14710 15000 14760 28840 15290 15920 14470 14630
Indexed STARTING WITH execution is very slow with UNICODE collation
87 CS 2175 2160 3090 2180 2150 2160 2200 2210 2270 2360 2350 2180 1140 1370 1980 2060 2020 2050 2050 1180 2170 3710 2180 2150 2370 2280 2560 2310 2430 2140 2160
INNER JOIN join merge and VIEWs
88 SS 2450 2440 2000 2470 2440 2450 2440 2000 2450 2510 2000 2450 1370 2580 2430 2860 2490 2490 2000 1430 2430 3530 2000 2440 2510 2450 2480 2490 2510 2460 2560
INNER JOIN join merge and VIEWs
89 CS 2170 2160 2770 2170 2160 2170 2170 2190 2170 2130 2370 2160 1080 1330 1960 2120 1980 1980 1980 1210 2200 2460 2200 2170 2280 2200 2700 2170 2000 2130 2240
INNER JOIN join merge and SP
90 SS 2440 2420 2430 2440 2380 2430 2420 2470 2430 2470 2450 2450 1280 2360 2510 2780 2000 2450 2510 1360 2420 2460 2480 2400 2430 2420 2450 2450 2480 2450 2440
INNER JOIN join merge and SP
91 CS 2170 2150 2150 2180 2150 2170 2190 2180 2290 2240 2200 2180 910 1140 1960 2080 1970 2000 1970 1180 2260 2170 2170 2150 2420 2200 2970 2270 2350 2170 2170
LEFT OUTER JOIN with full match, but limited in ON clause
92 SS 2420 2410 2400 2420 2400 2410 2420 2440 2420 2460 2000 2400 1420 2130 2450 2840 2480 2450 2530 1350 2400 2440 2450 2420 2540 2420 2410 2470 2470 2440 2570
LEFT OUTER JOIN with full match, but limited in ON clause
93 CS 2190 2190 2180 2180 2150 2310 2370 2190 2180 2260 2430 2470 1020 1190 2010 2020 2070 2000 2230 1240 2200 2420 2170 2200 2430 2370 2310 2540 2190 2140 2170
Mixed JOINS
94 SS 2460 2450 2480 2440 2430 2450 2470 2000 2460 2510 2510 2470 1560 2150 2430 2530 2530 2810 2870 1390 2460 2460 2510 2440 2530 2450 2000 2490 2540 2000 2530
Mixed JOINS
95 CS 2325 2320 2340 2310 2140 2340 2370 2330 2310 2340 2490 2350 1150 1230 2190 2060 2080 2060 2090 1220 2420 3210 2350 2340 2430 2310 2770 2490 2330 2260 2310
Mixed JOINS
96 SS 2545 2480 2520 2540 2480 2530 2540 2560 2570 2560 2630 2460 1510 2210 2550 2600 2570 2900 3040 1430 2550 2530 2540 2600 2610 2560 2490 2540 2550 2540 2580
Mixed JOINS
97 CS 2345 2410 2440 2430 2390 2310 2310 2400 2420 2270 2300 2480 1050 1350 2530 2070 2020 2130 2080 1000 2390 4930 2430 2400 2360 2290 2630 2450 2330 2200 2330
Mixed JOINS
98 SS 2535 2490 2490 2590 2490 2520 2510 2510 2600 2510 2550 2000 1360 2200 2540 2550 2550 2900 3130 1410 2510 3450 2540 2590 2570 2510 2000 2590 2630 2530 2560
Mixed JOINS
99 CS 1815 1720 1810 1720 1000 1830 2310 1740 2260 1870 2000 2880 860 1210 1600 1940 1530 1560 2030 1300 1820 1900 1780 1860 1840 1710 2690 1940 1900 1730 1720
Empty DB - RDB$COLLATIONS
100 SS 1910 1900 1910 1910 1950 1910 1920 1920 1910 1910 2200 1880 1060 1180 1890 2020 1930 1910 1910 1070 1900 1910 1910 2220 1900 1920 1920 1940 1890 1990 1890
Empty DB - RDB$COLLATIONS
101 CS 1700 1700 1710 1700 1890 1710 1710 1710 1700 1710 1740 1580 810 1030 1570 1000 1000 1540 1000 1220 1700 1710 1730 1700 1760 1710 1950 1720 1730 1700 1690
SHOW SYSTEM parameters
102 SS 1885 1860 1910 1880 1890 1890 1900 1880 1860 1880 2230 1910 1110 1120 2170 1940 1890 1870 1880 1050 1810 2120 2150 2180 1890 1900 1880 1880 1870 1870 1970
SHOW SYSTEM parameters
103 CS 3790 3790 3870 3760 3780 3880 4020 3790 3920 3960 3000 3260 2050 2530 3460 3590 3170 3180 3620 3130 3820 3970 3460 3000 4100 4450 5170 4470 4430 3800 4310
Query for test multiple CTEs
104 SS 3820 3810 3790 3730 3760 3760 3820 3870 3770 4380 3810 3730 2340 2700 3800 3870 3820 3880 3870 2420 3000 3920 3840 3810 4020 4340 4490 4000 4340 4310 4370
Query for test multiple CTEs
105 CS 2680 2670 2700 3090 2680 2710 3130 2920 3600 2680 3530 2540 1200 1980 2620 2870 2410 2460 2470 1710 2690 5290 2670 2670 2680 2730 5180 2000 2790 2570 2760
Common SQL. Check correctness of the results
106 SS 3100 3120 3090 3150 3100 3100 3070 3120 3260 3070 3130 3040 1620 1830 3070 3730 3110 3070 3090 1690 3150 3980 3010 3020 3110 3080 2990 3130 3210 3130 3100
Common SQL. Check correctness of the results
107 CS 2445 2450 2420 2440 2550 2550 2570 2420 3090 2420 2660 2300 1000 1670 2370 2170 3430 2690 2200 1600 2450 2480 2540 2440 2410 2480 3180 2510 2400 2360 2470
Check ability of outer join simplification.
108 SS 2770 2770 2770 2760 2770 2000 2780 2770 2870 2780 2810 2840 1660 1890 2810 2770 2800 3240 3260 1700 2790 2000 2000 2700 2810 2790 2710 2000 2700 2840 2870
Check ability of outer join simplification.
109 CS 2465 2400 2480 2410 2430 2430 2480 2540 2660 2510 2690 2280 1330 1620 2340 2150 2950 2520 2170 1420 2410 2650 2510 2540 2530 2490 3120 2410 2480 2370 2450
Check ability of outer join simplification.
110 SS 2760 2770 2740 2810 2780 2740 2000 2740 2000 2760 3030 2800 1670 1620 2730 2760 2800 3300 3310 1640 2760 2740 2740 2730 2780 2810 2680 2760 2700 2870 2810
Check ability of outer join simplification.
111 CS 2445 2400 2510 2410 2400 2490 2510 2510 2550 2420 2730 2280 1340 1720 2300 2000 3180 2450 2320 1390 2440 2420 2530 2420 2480 2480 2870 2460 2460 2430 2480
Check ability of outer join simplification.
112 SS 2760 2730 2780 2780 2740 2780 2770 2760 2790 2730 2840 3130 1710 1670 2000 2770 2000 3460 2790 1640 2000 2720 2730 2730 2760 2790 2900 2760 2710 2790 2850
Check ability of outer join simplification.
113 CS 2510 2560 2520 2530 2510 2530 2420 2000 2560 2420 3800 2280 1340 2090 2370 2170 2680 2000 2420 1510 2510 2510 2680 2510 2510 2670 2690 2430 2510 2450 2540
Check ability of outer join simplification.
114 SS 2815 2790 2780 2800 2820 2790 2820 2870 2780 2840 2820 2840 1650 1840 2780 2780 3220 2840 2870 1670 2890 2810 2760 2000 3240 2880 2950 2760 2800 2920 2930
Check ability of outer join simplification.
115 CS 2585 2630 2600 2570 2580 2510 2620 2570 2580 2610 4630 2590 1310 2000 2480 2290 3430 2400 2370 1510 2610 2570 2960 2590 2670 2700 3060 2610 2000 2560 2730
Check ability of outer join simplification.
116 SS 2930 2900 2970 2890 2890 2840 3120 2940 2980 2920 3120 3510 1890 2030 2890 2900 3410 2900 2890 1810 2950 2900 3040 2850 3470 2900 3010 2950 2980 2980 2960
Check ability of outer join simplification.
117 CS 4300 4290 4340 4310 4260 4320 4740 4210 4370 4350 6330 4210 3610 3920 4180 4180 4130 4150 4140 3000 4310 3690 5050 5260 4350 4310 5070 4280 4320 4000 4370
Compiler check. Test ability to compile source code of OLTP-EMUL test.
118 SS 4660 4650 4680 4660 4600 4620 4650 4610 4610 4680 4770 6630 3760 4100 4710 4700 4000 4730 4680 3830 4650 4060 4570 4660 4780 5320 7930 4680 4600 4730 4700
Compiler check. Test ability to compile source code of OLTP-EMUL test.
119 CS 3295 3330 3320 3350 3300 3400 3450 3290 3330 3590 3510 2830 1450 2310 3200 3130 2680 3030 3300 1540 3390 3340 3040 2940 3380 3340 3180 3290 3290 2880 3380
Common SQL. Check correctness of the results
120 SS 3330 3350 3330 3330 3290 3320 3370 3320 3300 3370 3350 3290 1790 3140 3630 3340 3300 3320 3330 1900 3360 3810 3650 3230 3260 3720 3370 3300 3340 3340 3730
Common SQL. Check correctness of the results
121 CS 64335 63590 63610 62180 62720 64900 63740 62790 61790 61870 64380 68320 40740 50550 62850 66190 66160 64290 63670 44620 65110 64930 66880 63760 67680 64690 70850 69630 65300 65800 67400
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
122 SS 58370 58540 57650 57150 58240 58000 57000 61400 60770 61920 59790 58590 40730 44390 58610 57890 58600 58280 57110 46540 58480 56620 57990 57290 59520 58970 57990 58870 59240 58910 58460
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.

List of tests in this report:


http://tracker.firebirdsql.org/browse/core-1167
http://tracker.firebirdsql.org/browse/core-1173
http://tracker.firebirdsql.org/browse/core-1245
http://tracker.firebirdsql.org/browse/core-1291
http://tracker.firebirdsql.org/browse/core-149
http://tracker.firebirdsql.org/browse/core-1885
http://tracker.firebirdsql.org/browse/core-2022
http://tracker.firebirdsql.org/browse/core-214
http://tracker.firebirdsql.org/browse/core-2291
http://tracker.firebirdsql.org/browse/core-2531
http://tracker.firebirdsql.org/browse/core-2668
http://tracker.firebirdsql.org/browse/core-2812
http://tracker.firebirdsql.org/browse/core-3090
http://tracker.firebirdsql.org/browse/core-3188
http://tracker.firebirdsql.org/browse/core-3323
http://tracker.firebirdsql.org/browse/core-3553
http://tracker.firebirdsql.org/browse/core-3557
http://tracker.firebirdsql.org/browse/core-3834
http://tracker.firebirdsql.org/browse/core-4261
http://tracker.firebirdsql.org/browse/core-4418
http://tracker.firebirdsql.org/browse/core-4452
http://tracker.firebirdsql.org/browse/core-4492
http://tracker.firebirdsql.org/browse/core-4528
http://tracker.firebirdsql.org/browse/core-4668
http://tracker.firebirdsql.org/browse/core-4673
http://tracker.firebirdsql.org/browse/core-4809
http://tracker.firebirdsql.org/browse/core-4882
http://tracker.firebirdsql.org/browse/core-5075
http://tracker.firebirdsql.org/browse/core-5118
http://tracker.firebirdsql.org/browse/core-5248
http://tracker.firebirdsql.org/browse/core-5488
http://tracker.firebirdsql.org/browse/core-5598
http://tracker.firebirdsql.org/browse/core-5602
http://tracker.firebirdsql.org/browse/core-5646
http://tracker.firebirdsql.org/browse/core-5664
http://tracker.firebirdsql.org/browse/core-5685
http://tracker.firebirdsql.org/browse/core-5804
http://tracker.firebirdsql.org/browse/core-5852
http://tracker.firebirdsql.org/browse/core-6044
http://tracker.firebirdsql.org/browse/core-6086
http://tracker.firebirdsql.org/browse/core-6336
http://tracker.firebirdsql.org/browse/core-6444
http://tracker.firebirdsql.org/browse/core-6458
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/arno/optimizer/opt_inner_join_merge_05.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/arno/optimizer/opt_inner_join_merge_06.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_mixed_joins_02.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/arno/optimizer/opt_mixed_joins_05.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/arno/optimizer/opt_mixed_joins_06.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/basic/db/db_03.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/basic/isql/isql_03.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/dbp-0951-multiple-nested-cte.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/dbp-2146-distinct-not-in.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/join-transformation-002.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/join-transformation-003.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/join-transformation-004.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/join-transformation-008.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/join-transformation-009.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/oltp-emul_30-compiler-check.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/snd-7795_20120706_1249.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/transactions/read-consist-sttm-restart-max-limit.fbt
https://github.com/FirebirdSQL/firebird/issues/6220
https://github.com/FirebirdSQL/firebird/issues/6785
https://github.com/FirebirdSQL/firebird/issues/6802
https://github.com/FirebirdSQL/firebird/issues/6872

=== end of list ===