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

Generated 14.05.2022 09:18
Tested: FB50.   Build: 5.0.0.494;   SS: 14.05.22 06:16:26 - 14.05.22 07:44:40;   CS: 14.05.22 07:47:50 - 14.05.22 09:13:55;
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 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.477
2022-04-22		 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-29		 5.0.0.439
2022-03-25		 5.0.0.437
2022-03-20		 5.0.0.429
2022-03-18		 5.0.0.426
2022-03-11		 5.0.0.425
2022-03-08		 5.0.0.423
2022-03-07		 5.0.0.422
2022-03-05		 5.0.0.419
2022-03-04
Test TITLE
1
bugs core 0149
tracker
 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
Left joining views with null fails
2
bugs core 0149
tracker
 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
Left joining views with null fails
3
bugs core 1167
tracker
 CS 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 P P P P
CHARACTER SET GBK is not installed
4
bugs core 1173
tracker
 CS P P P P P P P P P P P P P     F     P P P P P P P P P P P P P P P P
Expression index based on computed fields
5
bugs core 1173
tracker
 SS P P P P P P P P P P P P P     F     P P P P P P P P P P P P P P P P
Expression index based on computed fields
6
bugs core 1245
tracker
 CS 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 P
Incorrect column values with outer joins and views
7
bugs core 1245
tracker
 SS P P P P P P P P P P P P P P P P     E     P P     F     P P P P P P P P P P
Incorrect column values with outer joins and views
8
bugs core 1291
tracker
 CS P P P P P P P P P P P P P P P P     F     P P P P P P P P P P 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)
9
bugs core 1291
tracker
 SS 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 P
Can't transliterate character set when look at procedure text in database just created from script (and thus in ODS 11.1)
10
bugs core 1885
tracker
 CS 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 P P P P
CREATE COLLATION connection lost under Posix
11
bugs core 1885
tracker
 SS P P P P P P P     F         F     P P P P P P P     E     P P P P P P P P P P P P P
CREATE COLLATION connection lost under Posix
12
bugs core 2022
tracker
 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
"EXECUTE BLOCK" statement does not support "CREATE USER"
13
bugs core 2022
tracker
 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
"EXECUTE BLOCK" statement does not support "CREATE USER"
14
bugs core 2291
tracker
 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
BUGCHECK 284 (cannot restore singleton select data (284), file: rse.cpp ...)
15
bugs core 2291
tracker
 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
BUGCHECK 284 (cannot restore singleton select data (284), file: rse.cpp ...)
16
bugs core 2531
tracker
 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
The famous "cannot transliterate" error may be thrown when selecting data from the monitoring tables
17
bugs core 2531
tracker
 SS P P P P P P P P P P P P P P P P     E         F     P P P P     E     P P P P P P P
The famous "cannot transliterate" error may be thrown when selecting data from the monitoring tables
18
bugs core 2812
tracker
 CS P P P P P P P P P P P P P P P P     F     P P P P P P P P P P P P P
Prohibit any improper mixture of explicit and implicit joins
19
bugs core 3090
tracker
 CS 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 P
Incorrect LEFT JOIN result using table and derived constant subquery
20
bugs core 3090
tracker
 SS 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 P
Incorrect LEFT JOIN result using table and derived constant subquery
21
bugs core 3188
tracker
 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         F     P P P P P
page 0 is of wrong type (expected 6, found 1)
22
bugs core 3188
tracker
 SS P P P P P P P P P P P P P P P P     E     P P P P P     E         F         F     P P P P P
page 0 is of wrong type (expected 6, found 1)
23
bugs core 3553
tracker
 CS 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 P P P P
Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types
24
bugs core 3553
tracker
 SS 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 P P P P
Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types
25
bugs core 3557
tracker
 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
AV in engine when preparing query against dropping table
26
bugs core 3557
tracker
 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
AV in engine when preparing query against dropping table
27
bugs core 3834
tracker
 CS 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 P P P P
Usage of a NATURAL JOIN with a derived table crashes the server
28
bugs core 3834
tracker
 SS 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 P P P P
Usage of a NATURAL JOIN with a derived table crashes the server
29
bugs core 4261
tracker
 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
Check result when joined fields are created via row_number() function
30
bugs core 4261
tracker
 SS P P P P P P P     E     P P P P P P P P P     F     P P P P P P P P P P P P
Check result when joined fields are created via row_number() function
31
bugs core 4337
tracker
 CS P P P P P P P P P P P P P P P P P P P P P     F         E     P P P P P P P
gfix -sweep makes "reconnect" when it is removed from mon$attachments by delete command (issued in another window)
32
bugs core 4418
tracker
 CS 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 P P P P
Regression: Can not run ALTER TABLE DROP CONSTRAINT <FK_name> after recent changes in svn
33
bugs core 4418
tracker
 SS 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 P P P P
Regression: Can not run ALTER TABLE DROP CONSTRAINT <FK_name> after recent changes in svn
34
bugs core 4452
tracker
 CS 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 P P P P
Can`t create two collations with different names if autoddl OFF in FB 2.5.3
35
bugs core 4452
tracker
 SS P P P P P P P     F         F     P P P P P P P     E     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
36
bugs core 4492
tracker
 CS 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 P P P P
OR/IN predicates for RDB$DBKEY lead to NATURAL plan
37
bugs core 4492
tracker
 SS P P P P P P P     E         E     P P P P P P     F         F     P P P P P P P P P P P P P
OR/IN predicates for RDB$DBKEY lead to NATURAL plan
38
bugs core 4528
tracker
 CS 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 P P P P
Allow hash/merge joins for non-field (dbkey or derived expression) equalities
39
bugs core 4528
tracker
 SS P P P P P P P P P P P P P P P     F         E     P P P P P P P P P P P P P
Allow hash/merge joins for non-field (dbkey or derived expression) equalities
40
bugs core 4668
tracker
 CS P P P P P P P P P P P P P P P P     F     P P P P P P P P P P P P P
Select from mon$table_stats doesn`t work on SC and CS
41
bugs core 4673
tracker
 CS P P P P P P P P P P P P P     F     P P P P P P P P P P P P P P P P
Computed index based on a computed column stores NULL for all its keys
42
bugs core 4673
tracker
 SS P P P P P P P P P P P P P     F     P P P P P P P P P P P P P P P P
Computed index based on a computed column stores NULL for all its keys
43
bugs core 4809
tracker
 CS 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 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
44
bugs core 4809
tracker
 SS P P P P P P P P P P P P P P P     F         E     P P P P 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
45
bugs core 4880
tracker
 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 P     F     P
Increase speed of creating package when number of its functions more than several hundreds
46
bugs core 4882
tracker
 CS P P P P P P P P P P P P P P P P     F     P P P P P P P P P P P P P
ISQL input command (or -i option) reads large (> 64K) lines incorrectly
47
bugs core 5075
tracker
 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         F     P P P 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
48
bugs core 5075
tracker
 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         F     P P P 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
49
bugs core 5118
tracker
 CS P P P P P P P P P P P P P     F     P P P P P P P P P P P P P P P P
Indices on computed fields are broken after restore (all keys are NULL)
50
bugs core 5118
tracker
 SS P P P P P P P P P P P P P     F     P P P P P P P P P P P P P P P P
Indices on computed fields are broken after restore (all keys are NULL)
51
bugs core 5248
tracker
 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
Improve consistency in GRANT syntax between roles and privileges according to SQL standard
52
bugs core 5248
tracker
 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
Improve consistency in GRANT syntax between roles and privileges according to SQL standard
53
bugs core 5488 session idle
tracker
 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>)
54
bugs core 5488 session idle
tracker
 SS     F         F         F         F         F         F         F         E         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>)
55
bugs core 5598
tracker
 CS 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 P P P P
Error "block size exceeds implementation restriction" while inner joining large datasets with a long key using the HASH JOIN plan
56
bugs core 5598
tracker
 SS 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 P P P P
Error "block size exceeds implementation restriction" while inner joining large datasets with a long key using the HASH JOIN plan
57
bugs core 5646
tracker
 SS P P P P P P P P P P P P P P P P P P P P P P P P     F         F         F         F         F         F    
Parse error when compiling a statement causes memory leak until attachment is disconnected
58
bugs core 5804
tracker
 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
Multiple error in REVOKE operator
59
bugs core 5804
tracker
 SS P P P P P P P     E         E     P P P P P P P P     F     P P P P P P P P P P P P
Multiple error in REVOKE operator
60
bugs core 5852
tracker
 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
There is no check of existance generator and exception when privileges are granted
61
bugs core 5852
tracker
 SS P P P P P P P P P P P P P P P P     E         F     P P P P P P P P P P P P
There is no check of existance generator and exception when privileges are granted
62
bugs core 6044
tracker
 CS 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 P P P P
ISQL issues with increased identifier length
63
bugs core 6044
tracker
 SS 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 P P P P
ISQL issues with increased identifier length
64
bugs core 6086
tracker
 CS P P P P P P P P P P P P P P P P     F     P P P P P P P P P P P P P
Creating of the large procedure crashes the server.
65
bugs core 6237
tracker
 SS 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 P P
Performance problem when using SRP plugin
66
bugs core 6336
tracker
 CS 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 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
67
bugs core 6336
tracker
 SS P P P P P P P     E         F     P P P P 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
68
bugs core 6444
tracker
 CS P P P P P P P P P P P P P     F     P     F         F         F         F         F         F         F         F         F     P P P P P P
Ability to query Firebird configuration using SQL
69
bugs core 6444
tracker
 SS P P P P P P P P P P P P P     F     P     F         F         F         F         F         F         F         F         F     P P P P P P
Ability to query Firebird configuration using SQL
70
bugs gh 6802
tracker
 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    
When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired
71
bugs gh 6802
tracker
 SS     F         F         F         F         F         F         F         F         E         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F    
When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired
72
optimizer opt inner join merge 05
 CS P P P P P P P P P P P P P P P P     F     P P P P P P P P P P P P P
INNER JOIN join merge and VIEWs
73
optimizer opt inner join merge 06
 CS 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 P P P P
INNER JOIN join merge and SP
74
optimizer opt inner join merge 06
 SS 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 P P P P
INNER JOIN join merge and SP
75
optimizer opt left join 06
 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
LEFT OUTER JOIN with full match, but limited in ON clause
76
optimizer opt left join 06
 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
LEFT OUTER JOIN with full match, but limited in ON clause
77
optimizer opt mixed joins 02
 CS 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 P P P P
Mixed JOINS
78
optimizer opt mixed joins 02
 SS P P P P P P P P P P P P P P P     F         E     P P P P P P P P P P P P P
Mixed JOINS
79
optimizer opt mixed joins 05
 CS 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 P P P P
Mixed JOINS
80
optimizer opt mixed joins 05
 SS 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 P P P P
Mixed JOINS
81
optimizer opt mixed joins 06
 CS 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 P P P P
Mixed JOINS
82
optimizer opt mixed joins 06
 SS P P P P P P P P P P P P P P P     F         E     P P P P P P P P P P P P P
Mixed JOINS
83
db db 03
 CS 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 P P P P
Empty DB - RDB$COLLATIONS
84
db db 03
 SS 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 P P P P
Empty DB - RDB$COLLATIONS
85
db db 23
 CS P P P P P P P P P P P P P P P P P P P P P P P     F     P P P P P P
Empty DB - RDB$RELATIONS
86
db db 23
 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
Empty DB - RDB$RELATIONS
87
db db 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
Empty DB - RDB$RELATION_FIELDS
88
db db 24
 SS P P P P P P P P P P P P P P P P P P P P P P P     F     P P P P P P
Empty DB - RDB$RELATION_FIELDS
89
db db 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
Empty DB - RDB$SECURITY_CLASSES
90
db db 26
 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
Empty DB - RDB$SECURITY_CLASSES
91
isql isql 03
 CS 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 P P P P
SHOW SYSTEM parameters
92
isql isql 03
 SS 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 P P P P
SHOW SYSTEM parameters
93
tabloid dbp 0951 multiple nested cte
 CS 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 P
Query for test multiple CTEs
94
tabloid dbp 0951 multiple nested cte
 SS P P P P P P P P P P P P P P P P     E     P P     F     P P P P P P P P P P
Query for test multiple CTEs
95
tabloid dbp 2146 distinct not in
 CS P P P P P P P P P P P P P P P P     F     P P P P P P P P P P P P P
Common SQL. Check correctness of the results
96
tabloid join transformation 002
 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
Check ability of outer join simplification.
97
tabloid join transformation 002
 SS P P P P P P P P P P P P P P P P     E         F     P P P P P P P P P P P P
Check ability of outer join simplification.
98
tabloid join transformation 003
 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
Check ability of outer join simplification.
99
tabloid join transformation 003
 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
Check ability of outer join simplification.
100
tabloid join transformation 004
 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
Check ability of outer join simplification.
101
tabloid join transformation 004
 SS P P P P P P P P P P P P P P P P     E         F     P P P P P P P P P P P P
Check ability of outer join simplification.
102
tabloid join transformation 008
 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
Check ability of outer join simplification.
103
tabloid join transformation 008
 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
Check ability of outer join simplification.
104
tabloid join transformation 009
 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
Check ability of outer join simplification.
105
tabloid join transformation 009
 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
Check ability of outer join simplification.
106
tabloid oltp emul 30 compiler check
 CS P P P P P P P P P P P P P P P P     F     P P P P P P P P P P P P P
Compiler check. Test ability to compile source code of OLTP-EMUL test.
107
tabloid snd 7795 20120706 1249
 CS 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 P
Common SQL. Check correctness of the results
108
tabloid snd 7795 20120706 1249
 SS P P P P P P P P P P P P P P P P     E     P P     F     P P P P P P P P P P
Common SQL. Check correctness of the results

Elapsed time, milliseconds:
NN Test name mode median_ms 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.477
2022-04-22		 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-29		 5.0.0.439
2022-03-25		 5.0.0.437
2022-03-20		 5.0.0.429
2022-03-18		 5.0.0.426
2022-03-11		 5.0.0.425
2022-03-08		 5.0.0.423
2022-03-07		 5.0.0.422
2022-03-05		 5.0.0.419
2022-03-04
Test TITLE
1
bugs core 0149
tracker
 CS 1630 1590 1660 1670 1570 1640 1620 1590 1670 1590 1480 1530 1680 1530 1000 1630 1600 1630 1650 1520 1590 1620 1520 2260 1790 1810 1740 1690 1810 1900 1900
Left joining views with null fails
2
bugs core 0149
tracker
 SS 1595 1680 1630 1560 1580 1700 1570 1590 1540 1560 1490 1660 1660 1570 1000 1530 1550 1520 1550 1540 1540 1600 1920 2100 1810 1740 1670 1770 1650 1760 1630
Left joining views with null fails
3
bugs core 1167
tracker
 CS 940 960 900 920 940 890 870 840 820 790 890 900 880 920 1000 960 990 1000 890 940 930 980 880 1310 1010 980 1060 1090 1100 1030 1080
CHARACTER SET GBK is not installed
4
bugs core 1173
tracker
 CS 1530 1470 1510 1510 1530 1530 1410 1550 1410 1430 1460 1470 1520 1570 1540 1480 1000 1580 1530 1470 1540 1530 1530 1950 1810 1830 1690 1760 1830 1720 1770
Expression index based on computed fields
5
bugs core 1173
tracker
 SS 1515 1430 1530 1490 1550 1470 1560 1530 1480 1550 1000 1450 1400 1520 1440 1490 1440 1490 1000 1510 1510 1470 1730 1970 1610 1580 1640 1700 1630 1680 1540
Expression index based on computed fields
6
bugs core 1245
tracker
 CS 1340 1320 1340 1300 1240 1340 1260 1000 1300 1230 1230 1280 1260 1310 1230 1340 1350 1410 1340 1270 1440 1350 1310 1820 1360 1400 1480 1490 1370 1480 1520
Incorrect column values with outer joins and views
7
bugs core 1245
tracker
 SS 1330 1370 1340 1390 1350 1310 1310 1410 1290 1410 1330 1310 1280 1350 1310 1260 1300 0 1260 1270 1310 1310 1520 1710 1390 1330 1370 1390 1350 1400 1310
Incorrect column values with outer joins and views
8
bugs core 1291
tracker
 CS 1920 1930 1840 1870 1820 1820 1820 1880 1910 1860 1910 2000 1850 1960 1870 1930 1940 1470 1980 2030 1860 1910 1880 2740 2090 2170 2240 2130 2320 2000 2280
Can't transliterate character set when look at procedure text in database just created from script (and thus in ODS 11.1)
9
bugs core 1291
tracker
 SS 1990 2050 1940 1900 1980 2000 1910 1940 1940 2170 1890 1980 1950 2020 1970 1890 2020 1720 1970 1970 2020 1950 2370 2700 2290 2190 2230 2450 2480 2240 2110
Can't transliterate character set when look at procedure text in database just created from script (and thus in ODS 11.1)
10
bugs core 1885
tracker
 CS 800 820 780 870 760 800 0 740 760 770 0 770 770 780 0 720 770 780 840 780 800 800 830 1020 830 800 770 820 810 910 830
CREATE COLLATION connection lost under Posix
11
bugs core 1885
tracker
 SS 790 790 790 0 760 790 860 0 790 0 720 800 770 800 0 770 0 0 0 0 730 740 830 1000 790 720 740 0 800 800 720
CREATE COLLATION connection lost under Posix
12
bugs core 2022
tracker
 CS 740 760 740 0 740 780 670 720 700 780 700 710 670 710 700 0 740 0 730 690 800 770 710 1030 850 810 720 770 860 760 810
"EXECUTE BLOCK" statement does not support "CREATE USER"
13
bugs core 2022
tracker
 SS 690 720 0 760 720 680 760 690 0 670 680 690 680 690 720 670 680 690 680 700 720 710 810 940 730 670 680 690 720 740 670
"EXECUTE BLOCK" statement does not support "CREATE USER"
14
bugs core 2291
tracker
 CS 1155 1160 1210 1120 1130 1050 1130 1100 1170 1060 1120 1080 1120 1150 1170 1160 1170 1150 1170 1260 1090 1180 1120 1650 1200 1000 1180 1320 1000 1220 1300
BUGCHECK 284 (cannot restore singleton select data (284), file: rse.cpp ...)
15
bugs core 2291
tracker
 SS 1160 1170 1200 1210 1180 1180 1160 1100 1150 1180 1090 1160 1150 1110 1120 1110 1170 1110 1120 1120 1130 1150 1220 1760 1170 1220 1120 1270 1160 1180 1280
BUGCHECK 284 (cannot restore singleton select data (284), file: rse.cpp ...)
16
bugs core 2531
tracker
 CS 3480 3480 3530 3390 3490 3410 3400 3480 3430 3550 3440 3480 3480 3440 3470 3410 3530 3480 3490 3440 3470 3440 3470 4020 3540 3560 3570 3470 3490 3000 3600
The famous "cannot transliterate" error may be thrown when selecting data from the monitoring tables
17
bugs core 2531
tracker
 SS 3420 3420 3630 3430 3380 3470 3410 3600 3460 3350 3380 3380 3510 3330 3410 3330 3420 0 3400 3350 3490 3360 3590 10 3490 3430 3440 3410 3420 3440 3520
The famous "cannot transliterate" error may be thrown when selecting data from the monitoring tables
18
bugs core 2812
tracker
 CS 1545 1640 1000 1540 1600 1560 1510 1460 1000 1550 1430 1430 1550 1480 1460 1550 1600 1660 1480 1510 1510 1510 1450 2270 1610 1760 1740 1610 1610 1000 1660
Prohibit any improper mixture of explicit and implicit joins
19
bugs core 3090
tracker
 CS 1075 1060 1060 1080 1150 1020 1110 1030 1040 1020 1040 1060 1080 1080 980 1040 1100 1080 1030 1040 1070 1080 1020 1480 1230 1200 1160 1270 1070 1150 1150
Incorrect LEFT JOIN result using table and derived constant subquery
20
bugs core 3090
tracker
 SS 1080 1080 1060 1100 1050 1190 1130 1140 1110 1040 1090 1080 1080 1040 1070 1010 1050 1040 1060 980 1120 1080 1480 1400 1200 1060 1090 1070 1080 1140 1070
Incorrect LEFT JOIN result using table and derived constant subquery
21
bugs core 3188
tracker
 CS 1525 1580 1480 1550 1490 1520 1490 1530 1580 1460 1470 1540 1460 1470 1520 1490 1520 1480 1510 1580 1440 1490 1650 2230 1730 1670 1690 1570 1700 1680 1670
page 0 is of wrong type (expected 6, found 1)
22
bugs core 3188
tracker
 SS 1320 1300 1320 1330 1270 1350 1390 1330 1340 1200 1300 1280 1280 1310 1330 1280 1260 10 1330 1400 1320 1280 1440 20 1460 1400 1310 1290 1350 1380 1350
page 0 is of wrong type (expected 6, found 1)
23
bugs core 3553
tracker
 CS 670 670 610 640 680 680 680 620 650 650 600 590 660 640 680 660 670 700 660 690 700 690 680 890 670 770 650 610 700 900 690
Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types
24
bugs core 3553
tracker
 SS 650 680 710 680 650 760 690 680 760 610 640 650 680 640 680 600 660 610 590 610 640 610 740 920 640 610 650 630 700 610 610
Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types
25
bugs core 3557
tracker
 CS 1355 1360 1390 1430 1390 1300 1370 1350 1330 1380 1350 1350 1350 1370 1370 1410 1300 1420 1360 1380 1330 1380 1420 1960 1160 1300 1150 1170 1260 1000 1310
AV in engine when preparing query against dropping table
26
bugs core 3557
tracker
 SS 1390 1410 1450 1450 1430 1440 1450 1480 1430 1360 1380 1410 1400 1360 1360 1380 1380 1410 1470 1390 1390 1390 2030 1790 1190 1190 1230 1230 1220 1180 1170
AV in engine when preparing query against dropping table
27
bugs core 3834
tracker
 CS 1030 1050 1030 1000 970 990 1020 1030 1060 960 960 1010 1070 940 1050 1080 1120 1000 1060 1030 1010 1030 980 1390 1070 1060 1050 1030 1080 1050 1040
Usage of a NATURAL JOIN with a derived table crashes the server
28
bugs core 3834
tracker
 SS 1105 1110 1170 1120 1200 1160 1120 1150 1110 1140 1210 1080 1070 1100 1040 1080 1090 1140 1120 1090 990 1060 1290 1530 1090 1070 1030 1110 1090 1030 1080
Usage of a NATURAL JOIN with a derived table crashes the server
29
bugs core 4261
tracker
 CS 1715 1650 1660 1780 1780 1560 1610 1650 1670 1660 1640 1630 1630 1730 1630 1690 1720 1710 1670 1640 1770 1810 1940 2560 1950 1940 2000 1980 1980 2320 1980
Check result when joined fields are created via row_number() function
30
bugs core 4261
tracker
 SS 1715 1740 1740 1670 1650 1710 1870 1660 10 1680 1660 1650 1690 1000 1720 1670 1710 1700 1680 1640 1780 1760 1930 2380 1860 2040 1940 1860 1870 1890 1840
Check result when joined fields are created via row_number() function
31
bugs core 4337
tracker
 CS 14360 14940 14330 16070 14990 13920 14550 13460 13820 14740 13710 13450 14000 13510 13730 13680 14080 13350 14280 13550 13960 15850 2778950 2617090 14390 15700 14860 15050 14520 16130 15710
gfix -sweep makes "reconnect" when it is removed from mon$attachments by delete command (issued in another window)
32
bugs core 4418
tracker
 CS 1885 2020 1920 2040 1970 1870 1930 1890 1840 1830 1710 1810 1760 1810 1820 1770 1890 1810 1820 1800 1780 1900 1870 2620 2060 2200 5540 2130 1880 2050 2000
Regression: Can not run ALTER TABLE DROP CONSTRAINT <FK_name> after recent changes in svn
33
bugs core 4418
tracker
 SS 1865 2060 1980 2000 2000 2060 1970 2030 1780 1840 1680 1710 1800 1730 1710 1000 1800 1000 1830 1780 1870 1780 2010 2310 2050 2080 1900 1850 1860 1940 1870
Regression: Can not run ALTER TABLE DROP CONSTRAINT <FK_name> after recent changes in svn
34
bugs core 4452
tracker
 CS 1110 1340 1320 1380 1000 1380 1240 1000 1160 1070 1110 1100 1110 1070 1070 1130 1090 1090 1050 1050 1070 1090 1080 1000 1200 1180 1110 1150 1190 1220 1240
Can`t create two collations with different names if autoddl OFF in FB 2.5.3
35
bugs core 4452
tracker
 SS 1110 1380 1330 1350 1340 1300 1330 1320 1100 1100 1110 1030 1060 1080 1130 1120 1130 0 1120 1010 1070 1080 1230 1390 1110 1080 1100 1070 1110 1120 1050
Can`t create two collations with different names if autoddl OFF in FB 2.5.3
36
bugs core 4492
tracker
 CS 1120 1100 1050 1110 1060 1110 1080 1130 1130 1050 1080 1050 1070 1130 1100 1180 1140 1290 1100 1080 1130 1090 1120 1580 1200 1160 1140 1120 1230 1190 1200
OR/IN predicates for RDB$DBKEY lead to NATURAL plan
37
bugs core 4492
tracker
 SS 1120 1120 1130 1110 1070 1180 1140 1140 10 0 1120 1110 1060 1130 1150 1090 1100 1090 1090 1110 1080 1130 1260 1520 1190 1120 1150 1150 1110 1170 1100
OR/IN predicates for RDB$DBKEY lead to NATURAL plan
38
bugs core 4528
tracker
 CS 1240 1390 1000 1240 1240 1000 1000 1110 1180 1210 1160 1000 1000 1160 1340 1200 1310 1390 1240 1200 1150 1200 1260 1850 1310 1350 1360 1360 1300 1340 1340
Allow hash/merge joins for non-field (dbkey or derived expression) equalities
39
bugs core 4528
tracker
 SS 1275 1280 1240 1220 1310 1300 1270 1290 1270 1350 1200 1340 1290 1340 1220 1210 1200 1150 1220 1000 1270 1230 1770 1630 1480 1230 1380 1350 1420 1380 1220
Allow hash/merge joins for non-field (dbkey or derived expression) equalities
40
bugs core 4668
tracker
 CS 2830 2730 2920 2980 2990 2780 2720 2800 2710 2930 2800 2800 2790 2720 2770 2770 2860 2230 2850 2810 2860 2810 2790 3960 3070 3100 3130 3090 3090 2940 3290
Select from mon$table_stats doesn`t work on SC and CS
41
bugs core 4673
tracker
 CS 1370 1380 1360 1350 1370 1410 1370 1300 1360 1340 1390 1280 1350 1420 1320 1370 1220 1330 1350 1390 1300 1320 1360 1950 1520 1550 1530 1430 1480 1530 1540
Computed index based on a computed column stores NULL for all its keys
42
bugs core 4673
tracker
 SS 1400 1430 1390 1400 1370 1440 1440 1460 1410 1290 1330 1330 1400 1430 1310 1390 1350 1300 1360 1370 1440 1330 1600 1730 1520 1400 1520 1650 1480 1460 1400
Computed index based on a computed column stores NULL for all its keys
43
bugs core 4809
tracker
 CS 2740 2700 2740 2710 2770 2720 2530 2570 2540 2710 2000 2700 2600 2690 2630 2870 2760 2920 2860 2740 2670 2820 2700 3820 3110 3070 3150 3220 3110 3240 3170
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
44
bugs core 4809
tracker
 SS 2770 2640 2690 2730 2840 2770 2670 2720 2630 2780 2630 2650 2730 2630 2710 2580 2790 0 2790 2610 2860 2710 3000 3480 3020 3000 2920 3090 3260 3020 3100
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
45
bugs core 4880
tracker
 CS 69605 70310 69820 70620 70650 69520 68710 68210 66970 69690 68570 68040 70630 69260 70410 69940 70000 70040 70720 70480 70090 70670 68350 97090 68100 67360 66950 66620 68260 67730 68100
Increase speed of creating package when number of its functions more than several hundreds
46
bugs core 4882
tracker
 CS 11370 11830 11680 11440 12090 11030 11390 11080 10900 11520 10890 11140 11340 10920 11210 11320 11350 9820 11260 11090 11340 11670 11180 16420 12000 12530 13000 13640 15040 12800 13000
ISQL input command (or -i option) reads large (> 64K) lines incorrectly
47
bugs core 5075
tracker
 CS 4910 4780 4940 4870 5040 4840 4910 4760 4740 4910 4740 4890 4870 4880 4840 5020 4840 4970 4880 5030 4820 4850 4980 6030 5410 5140 5200 4990 5070 5140 5170
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
48
bugs core 5075
tracker
 SS 5055 5130 5080 5140 5080 5160 4960 5060 4940 4880 5020 4940 5020 4940 4910 5050 4910 5070 4990 4940 4940 5050 5400 6030 5410 5000 5210 5270 5150 5210 5150
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
49
bugs core 5118
tracker
 CS 2820 2870 2840 2730 2830 2830 2760 2680 2840 2780 2820 2850 2000 2800 2770 2760 2790 2800 2680 2790 2880 2720 2820 3510 2890 2900 2800 2880 2960 3060 2970
Indices on computed fields are broken after restore (all keys are NULL)
50
bugs core 5118
tracker
 SS 3075 3150 3100 3090 3110 3290 3060 3200 3070 3170 3010 2940 3080 3060 3060 2970 3040 2970 3020 3030 3050 2990 3320 3840 3240 3030 3050 3090 3230 3110 3130
Indices on computed fields are broken after restore (all keys are NULL)
51
bugs core 5248
tracker
 CS 2850 2910 2910 2900 2850 2780 2870 2850 2730 2760 2710 2710 2920 2800 2730 2000 2820 2850 2790 2780 2760 2800 2800 3980 3050 3080 2970 2970 3100 3170 3000
Improve consistency in GRANT syntax between roles and privileges according to SQL standard
52
bugs core 5248
tracker
 SS 3055 3200 3180 3170 3040 3130 3130 3120 3050 2940 3000 3180 3160 3020 3030 2980 2960 3010 2970 2920 3060 2960 3280 3950 3270 3070 2990 3000 3140 3040 3170
Improve consistency in GRANT syntax between roles and privileges according to SQL standard
53
bugs core 5488 session idle
tracker
 CS 7355 7340 7380 7370 7390 7360 7230 7350 7340 7370 7260 7310 7380 7320 7240 7350 7300 7340 7320 7370 7300 7430 7280 7940 7410 7450 7400 7450 7340 7700 7450
Timeout for IDLE connection (SET SESSION IDLE TIMEOUT <N>)
54
bugs core 5488 session idle
tracker
 SS 7090 7090 7120 7020 7150 7110 7170 7090 0 7020 7070 7070 7110 7130 7080 7020 7080 7020 7060 7050 7080 7000 7140 7550 7100 7070 7110 7130 7090 7120 7060
Timeout for IDLE connection (SET SESSION IDLE TIMEOUT <N>)
55
bugs core 5598
tracker
 CS 9850 10330 9940 10000 10070 10310 10310 10480 10270 10460 9710 9600 10560 9640 9600 9660 9630 9890 9700 9720 9650 9930 10170 13060 9900 9450 9360 9340 9510 9520 9810
Error "block size exceeds implementation restriction" while inner joining large datasets with a long key using the HASH JOIN plan
56
bugs core 5598
tracker
 SS 9240 10040 9780 9620 9920 10020 9800 10280 9820 9420 9200 9120 9350 9060 9240 9240 9000 9240 9470 9190 9060 9260 9660 12090 9070 9010 9020 9120 9210 9080 8930
Error "block size exceeds implementation restriction" while inner joining large datasets with a long key using the HASH JOIN plan
57
bugs core 5646
tracker
 SS 3670 3680 3000 3710 3600 3570 3590 3000 3350 3620 3440 3460 3580 3550 3000 3490 3550 3660 3710 3680 3700 3730 4800 4720 4380 4130 4220 4030 4380 4040 3870
Parse error when compiling a statement causes memory leak until attachment is disconnected
58
bugs core 5804
tracker
 CS 4095 4080 4080 4270 3950 4110 4000 3990 4090 4100 4060 3940 4060 4020 4060 4120 4060 4090 4170 4020 4130 4090 4130 5270 5030 5420 4470 4450 5000 4590 4710
Multiple error in REVOKE operator
59
bugs core 5804
tracker
 SS 3705 3590 3650 3720 3000 3840 3460 3540 0 0 3420 3610 3450 3580 3690 3740 3790 3740 3620 3680 3670 3000 4700 5000 4290 4270 3890 4130 4470 3860 3960
Multiple error in REVOKE operator
60
bugs core 5852
tracker
 CS 1260 1240 1180 1260 1000 1260 1200 1000 1180 1190 1230 1170 1190 1200 1270 1240 1270 1230 1290 1210 1270 1290 1260 1830 1420 1430 1370 1370 1400 1350 1520
There is no check of existance generator and exception when privileges are granted
61
bugs core 5852
tracker
 SS 1220 1270 1230 1240 1150 1230 1290 1220 1220 1150 1170 1180 1200 1210 1220 1220 1190 0 1200 1140 1160 1170 1410 1660 1200 1280 1230 1230 1260 1000 1200
There is no check of existance generator and exception when privileges are granted
62
bugs core 6044
tracker
 CS 1415 1460 1480 1550 1440 1360 1390 1420 1380 1410 1360 1340 1380 1280 1410 1440 1390 1390 1340 1360 1430 1410 1000 2030 1560 1540 1510 1550 1600 1550 1620
ISQL issues with increased identifier length
63
bugs core 6044
tracker
 SS 1360 1480 1440 1370 1360 1360 1340 1400 1340 1340 1290 1310 1360 1330 1410 1310 1340 1000 1330 1300 1430 1310 1580 1840 1000 1390 1430 1450 1520 1450 1430
ISQL issues with increased identifier length
64
bugs core 6086
tracker
 CS 1685 1780 1740 1670 1720 1620 1540 1560 1630 1540 1620 1550 1610 1650 1630 1650 1730 1910 1690 1780 1650 1650 1680 2300 1800 2040 1820 2000 1850 1840 1840
Creating of the large procedure crashes the server.
65
bugs core 6237
tracker
 SS 14210 14860 14990 15070 15080 15070 15150 15210 15110 30280 14000 14240 15030 14010 14000 13980 13960 14170 14320 14070 14110 14200 15370 19060 14220 14000 14070 13880 14020 13790 13770
Performance problem when using SRP plugin
66
bugs core 6336
tracker
 CS 33975 33200 33970 34160 34200 33220 33350 33000 31610 32440 33140 33680 34220 34330 34240 34880 34740 34780 34410 33980 33860 33810 33820 49410 35790 33990 33300 32680 33410 34060 34140
Regression in FB 4.x: error "Implementation of text subtype <NNNN> not located" on attempt to use some collations defined in fbintl.conf
67
bugs core 6336
tracker
 SS 39430 39780 40700 40070 40780 40610 41020 40070 2090 2000 39000 39200 39630 38730 39660 39240 38940 39200 39560 39530 39640 39990 40740 51380 39330 37730 38350 38850 37760 38170 37900
Regression in FB 4.x: error "Implementation of text subtype <NNNN> not located" on attempt to use some collations defined in fbintl.conf
68
bugs core 6444
tracker
 CS 3370 3520 3190 3300 3380 3160 3260 3090 3200 3100 3390 3420 3340 3410 3390 3440 3280 3360 3140 3160 3530 3230 3200 3990 3640 3330 3790 3390 3510 3450 3440
Ability to query Firebird configuration using SQL
69
bugs core 6444
tracker
 SS 3180 3390 3220 3140 3000 3120 3160 3010 3070 3180 3290 3180 3430 3130 3150 3090 3110 3260 3120 3130 3140 3220 3450 3720 3000 3370 3320 3300 3270 3240 3220
Ability to query Firebird configuration using SQL
70
bugs gh 6802
tracker
 CS 22545 22220 22440 22570 22330 22920 22320 22980 22270 22330 22200 22680 23160 22300 23070 22520 22120 23320 22480 22000 22850 23100 22160 22790 22950 22490 23000 22710 23020 22290 23610
When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired
71
bugs gh 6802
tracker
 SS 22720 22570 22980 22300 22720 22990 22720 22760 22550 10 22400 22930 22960 22690 23000 22570 22720 22980 22270 22880 23920 22460 22570 23370 22680 22850 22810 22850 22410 22610 22160
When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired
72
optimizer opt inner join merge 05
 CS 1735 1690 1820 1780 1790 1620 1770 1660 1580 1680 1680 1670 1720 1000 1650 1670 1830 1730 1720 1700 1740 1720 1740 2380 1960 1870 2080 1940 2040 2010 1890
INNER JOIN join merge and VIEWs
73
optimizer opt inner join merge 06
 CS 1485 1560 1000 1440 1560 1400 1570 1380 1420 1420 1450 1460 1510 1460 1420 1490 1530 1450 1510 1460 1530 1480 1460 2070 1650 1720 1690 1670 1670 1000 1700
INNER JOIN join merge and SP
74
optimizer opt inner join merge 06
 SS 1530 1550 1450 1540 1510 1510 1530 1520 1430 1520 1430 1480 1440 1460 1540 1490 1490 1560 1530 1530 1510 1000 1620 1940 1650 1650 1560 1740 1650 1740 1670
INNER JOIN join merge and SP
75
optimizer opt left join 06
 CS 1415 1410 1450 1540 1410 1520 1440 1360 1410 1350 1310 1380 1400 1360 1430 1340 1410 1410 1380 1370 1430 1420 1390 2160 1600 1610 1580 1670 1610 1760 1520
LEFT OUTER JOIN with full match, but limited in ON clause
76
optimizer opt left join 06
 SS 1440 1480 1510 1480 1420 1490 1440 1430 1430 1620 1440 1370 1420 1410 1440 1390 1420 1420 1400 1350 1430 1440 1480 1830 1630 1560 1620 1590 1520 1650 1550
LEFT OUTER JOIN with full match, but limited in ON clause
77
optimizer opt mixed joins 02
 CS 1705 1640 1810 1620 1720 1810 1720 1640 1540 1620 1660 1610 1000 1690 1720 1690 1640 1690 1700 1670 1710 1760 1630 2520 1830 1950 1950 1770 1890 1850 1890
Mixed JOINS
78
optimizer opt mixed joins 02
 SS 1695 1000 1690 1000 1780 1710 1730 1650 1630 1800 1670 1660 1660 1640 1670 1700 1600 10 1770 1680 1650 1620 1720 2480 2000 1950 1880 1810 1840 2030 1830
Mixed JOINS
79
optimizer opt mixed joins 05
 CS 2215 2240 2380 2320 2070 2030 2220 2180 2000 2150 2070 2210 2220 2100 2170 2230 2170 2160 2210 2070 2240 2070 2090 3110 2260 2380 2580 2490 2440 2620 2440
Mixed JOINS
80
optimizer opt mixed joins 05
 SS 2195 2220 2220 2000 2200 2140 2120 2090 2120 2330 2130 2120 2180 2230 2000 2080 2190 2170 2280 2290 2120 2180 2000 2830 2530 2450 2360 2620 2480 2390 2310
Mixed JOINS
81
optimizer opt mixed joins 06
 CS 2160 2160 2180 2090 2230 2010 2260 2000 2000 2110 2050 2090 2030 2030 2080 2110 2240 2210 2180 2110 2140 2080 2160 3270 2410 2370 2540 2530 2370 2590 2410
Mixed JOINS
82
optimizer opt mixed joins 06
 SS 2140 2150 2170 2170 2100 2100 2060 2040 1990 2090 2080 2080 2100 2070 2150 2130 2110 2060 2100 2160 2090 2170 2170 2930 2360 2490 2370 2300 2430 2600 2440
Mixed JOINS
83
db db 03
 CS 710 690 800 740 740 710 720 760 670 700 680 700 630 710 680 700 700 690 0 690 710 690 710 990 740 720 720 780 770 680 700
Empty DB - RDB$COLLATIONS
84
db db 03
 SS 680 720 720 730 710 710 800 690 0 0 690 660 680 670 650 680 660 710 660 680 650 680 720 940 670 650 620 600 670 650 670
Empty DB - RDB$COLLATIONS
85
db db 23
 CS 690 700 650 710 650 650 740 670 650 650 630 630 660 680 680 690 670 730 660 690 620 700 720 1070 720 710 720 700 770 720 730
Empty DB - RDB$RELATIONS
86
db db 23
 SS 660 740 660 680 680 670 700 650 740 730 660 640 660 650 650 680 640 630 660 660 670 620 720 810 660 710 620 660 640 670 610
Empty DB - RDB$RELATIONS
87
db db 24
 CS 840 860 890 830 880 860 920 800 800 820 830 830 860 810 770 830 800 830 870 830 800 870 820 1190 890 870 820 890 860 910 850
Empty DB - RDB$RELATION_FIELDS
88
db db 24
 SS 815 810 880 850 860 860 900 890 900 970 770 770 820 820 810 780 820 780 800 850 770 790 870 1190 820 790 740 770 810 790 800
Empty DB - RDB$RELATION_FIELDS
89
db db 26
 CS 810 770 820 790 840 800 810 780 790 800 770 830 850 780 760 770 800 820 820 800 830 810 870 1160 810 810 810 0 840 810 780
Empty DB - RDB$SECURITY_CLASSES
90
db db 26
 SS 790 810 800 850 800 810 800 780 890 900 730 790 760 730 0 780 800 760 790 770 800 790 860 1100 760 780 710 800 0 0 770
Empty DB - RDB$SECURITY_CLASSES
91
isql isql 03
 CS 695 680 720 690 680 680 720 690 700 730 640 660 660 630 690 680 700 740 630 700 640 650 670 950 720 710 720 720 700 700 790
SHOW SYSTEM parameters
92
isql isql 03
 SS 670 680 700 720 670 670 710 760 710 720 660 670 670 640 660 670 660 650 620 670 630 700 730 860 660 660 610 650 620 640 680
SHOW SYSTEM parameters
93
tabloid dbp 0951 multiple nested cte
 CS 1620 1720 1590 1470 1430 1590 1570 1550 1580 1600 1580 1460 1650 1650 1460 1570 1640 1520 1590 1520 1770 1960 1910 2770 1960 1910 1880 1790 1880 1870 1840
Query for test multiple CTEs
94
tabloid dbp 0951 multiple nested cte
 SS 1665 1700 1610 1600 1600 1660 1650 1680 1720 1670 1600 1520 1650 1590 1560 1620 1490 20 1530 1610 1790 1950 1920 2800 1900 1850 2000 1860 1930 1890 1800
Query for test multiple CTEs
95
tabloid dbp 2146 distinct not in
 CS 1060 1110 1100 1030 1020 980 970 1050 1020 1060 1020 1040 1030 1000 1030 1000 1090 1160 1100 1010 1070 1040 1100 1510 1120 1100 1070 1060 1140 1090 1130
Common SQL. Check correctness of the results
96
tabloid join transformation 002
 CS 1580 1610 1630 1510 1580 1580 1560 1610 1550 1510 1530 1480 1520 1540 1560 1660 1560 1660 1000 1560 1580 1610 1670 2360 1690 1800 1000 1670 1810 1710 1760
Check ability of outer join simplification.
97
tabloid join transformation 002
 SS 1680 1740 1650 1640 1620 1680 1710 1640 1680 1760 1630 1630 1670 1610 1670 1620 1640 30 1740 1640 1620 1690 1970 2000 1790 1870 1830 1730 1850 1770 1780
Check ability of outer join simplification.
98
tabloid join transformation 003
 CS 1595 1620 1620 1590 1520 1000 1580 1560 1560 1590 1550 1520 1600 1560 1520 1570 1610 1620 1660 1540 1520 1640 1620 2300 1660 1780 1660 1760 1800 1000 1830
Check ability of outer join simplification.
99
tabloid join transformation 003
 SS 1700 1730 1720 1680 1630 1000 1770 1870 1670 1000 1670 1640 1630 1700 1700 1600 1600 1620 1620 1640 1770 1650 1870 2380 1810 1770 1810 1710 1730 1830 1880
Check ability of outer join simplification.
100
tabloid join transformation 004
 CS 1565 1610 1660 1570 1540 1540 1570 1550 1510 1440 1520 1550 1530 1560 1440 1470 1630 1560 1640 1590 1570 1560 1550 2290 1760 1900 1740 1000 1840 1760 1770
Check ability of outer join simplification.
101
tabloid join transformation 004
 SS 1690 1740 1690 1670 1660 1720 1710 1740 1720 1690 1630 1690 1690 1650 1690 1610 1620 30 1630 1610 1650 1690 1960 2370 1840 1830 1790 1720 1860 1770 1760
Check ability of outer join simplification.
102
tabloid join transformation 008
 CS 1660 1710 1620 1590 1640 1640 1570 1710 1720 1490 1620 1650 1550 1660 1620 1660 1600 1570 1690 1580 1740 1650 1690 2280 1840 1850 1800 1730 1920 1880 1860
Check ability of outer join simplification.
103
tabloid join transformation 008
 SS 1760 1790 1700 1770 1710 1760 1820 1740 1730 1790 1770 1740 1720 1630 1670 1650 1720 1770 1960 1640 1740 1630 1880 2390 1980 1950 1760 1780 1000 1830 1810
Check ability of outer join simplification.
104
tabloid join transformation 009
 CS 1715 1680 1720 1680 1820 1710 1660 1640 1720 1470 1660 1790 1660 1640 1580 1700 1790 1670 1810 1660 1690 1690 1790 2560 1850 1900 1860 1870 2040 1830 1950
Check ability of outer join simplification.
105
tabloid join transformation 009
 SS 1800 1760 1000 1800 1790 1000 1770 1850 1000 1860 1800 1730 1840 1650 1720 1770 1760 1000 1920 1670 1780 1910 2100 2410 1810 1900 1850 1850 1830 1890 2030
Check ability of outer join simplification.
106
tabloid oltp emul 30 compiler check
 CS 8030 8010 8420 8050 8120 7680 7590 7610 7690 7730 7840 7470 7890 7660 8190 8160 8000 4590 8260 7980 7960 8160 8200 11070 8000 8780 8590 8730 9430 9210 8790
Compiler check. Test ability to compile source code of OLTP-EMUL test.
107
tabloid snd 7795 20120706 1249
 CS 1230 1290 1280 1270 1270 1290 1220 1210 1210 1310 1220 1180 1000 1180 1200 1280 1190 1240 1230 1220 1190 1210 1230 1840 1240 1270 1310 1290 1230 1220 1230
Common SQL. Check correctness of the results
108
tabloid snd 7795 20120706 1249
 SS 1300 1350 1330 1330 1300 1400 1410 1330 1390 1320 1280 1300 1280 1380 1300 1240 1270 20 1000 1290 1340 1310 1000 1840 1300 1320 1340 1260 1220 1230 1290
Common SQL. Check correctness of the results

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-2291
http://tracker.firebirdsql.org/browse/core-2531
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-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-4337
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-4880
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-5646
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-6237
http://tracker.firebirdsql.org/browse/core-6336
http://tracker.firebirdsql.org/browse/core-6444
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/db/db_23.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/basic/db/db_24.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/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/firebird/issues/6802

=== end of list ===