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

Generated 26.09.2021 20:11
Tested: FB50.   Build: 5.0.0.229;   SS: 26.09.21 15:47:36 - 26.09.21 18:02:57;   CS: 26.09.21 18:04:35 - 26.09.21 20:09:37;
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 = "ERROR" for last 30 runs:

Jump to LIST of unique test names from this report

NN Test name mode 5.0.0.229
2021-09-26		 5.0.0.228
2021-09-23		 5.0.0.220
2021-09-22		 5.0.0.219
2021-09-20		 5.0.0.218
2021-09-19		 5.0.0.215
2021-09-17		 5.0.0.212
2021-09-16		 5.0.0.208
2021-09-15		 5.0.0.202
2021-09-14		 5.0.0.198
2021-09-12		 5.0.0.197
2021-09-11		 5.0.0.196
2021-09-10		 5.0.0.193
2021-09-09		 5.0.0.192
2021-09-08		 5.0.0.187
2021-09-07		 5.0.0.186
2021-09-04		 5.0.0.181
2021-09-03		 5.0.0.176
2021-09-02		 5.0.0.172
2021-08-31		 5.0.0.169
2021-08-29		 5.0.0.168
2021-08-28		 5.0.0.163
2021-08-27		 5.0.0.161
2021-08-26		 5.0.0.158
2021-08-25		 5.0.0.157
2021-08-23		 5.0.0.149
2021-08-22		 5.0.0.143
2021-08-21		 5.0.0.142
2021-08-19		 5.0.0.141
2021-08-14		 5.0.0.140
2021-08-13
Test TITLE
1
bugs core 0086
tracker
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Index bug
2
bugs core 0086
tracker
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Index bug
3
bugs core 1006
tracker
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
AV at rollback and \ or garbage collection if updated table have expression index with SELECT in it
4
bugs core 1006
tracker
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
AV at rollback and \ or garbage collection if updated table have expression index with SELECT in it
5
bugs core 1063
tracker
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Server hangs eating CPU and performs huge I/O copying different codepage fields
6
bugs core 1063
tracker
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Server hangs eating CPU and performs huge I/O copying different codepage fields
7
bugs core 1331
tracker
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Charset transliterations don't work with EXECUTE STATEMENT
8
bugs core 1331
tracker
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Charset transliterations don't work with EXECUTE STATEMENT
9
bugs core 1642
tracker
 CS P P P P P P P P P P P P P P P P P P P P P X P P P P     E         E     P P
Non-privileged monitoring reports wrong attachment data
10
bugs core 1642
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 P P     E         E     P P
Non-privileged monitoring reports wrong attachment data
11
bugs core 1752
tracker
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Results of a join with different collations depend on the execution plan
12
bugs core 1752
tracker
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Results of a join with different collations depend on the execution plan
13
bugs core 2078
tracker
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P     F         F     P P
Suboptimal join plan if there are selective non-indexed predicates involved
14
bugs core 2078
tracker
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P     F         F     P P
Suboptimal join plan if there are selective non-indexed predicates involved
15
bugs core 2233
tracker
 CS P P P P P P P P P P P P P P P P P P P P P X P P P P     E         E     P P
Allow non-SYSDBA users to monitor not only their current attachment but other their attachments as well
16
bugs core 2233
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 P P     E         E     P P
Allow non-SYSDBA users to monitor not only their current attachment but other their attachments as well
17
bugs core 2721
tracker
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Issue with SIMILAR TO and UTF8 on 2.5 Beta 2 (and 1)
18
bugs core 2721
tracker
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Issue with SIMILAR TO and UTF8 on 2.5 Beta 2 (and 1)
19
bugs core 2890
tracker
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
SQLSTATE should also be available as a PSQL context variable like GDSCODE/SQLCODE
20
bugs core 2890
tracker
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
SQLSTATE should also be available as a PSQL context variable like GDSCODE/SQLCODE
21
bugs core 3076
tracker
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Better performance for (table.field = :param or :param = -1) in where clause
22
bugs core 3076
tracker
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Better performance for (table.field = :param or :param = -1) in where clause
23
bugs core 3210
tracker
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
The cursor identified in the UPDATE or DELETE statement is not positioned on a row. no current record for fetch operation in SELECT query
24
bugs core 3210
tracker
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
The cursor identified in the UPDATE or DELETE statement is not positioned on a row. no current record for fetch operation in SELECT query
25
bugs core 3277
tracker
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Wrong result for RIGHT(UTF8 varchar)
26
bugs core 3277
tracker
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Wrong result for RIGHT(UTF8 varchar)
27
bugs core 3282
tracker
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
EXECUTE STATEMENT parses the SQL text using wrong charset
28
bugs core 3282
tracker
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
EXECUTE STATEMENT parses the SQL text using wrong charset
29
bugs core 3310
tracker
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
RDB$GET_CONTEXT and between in view
30
bugs core 3310
tracker
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
RDB$GET_CONTEXT and between in view
31
bugs core 3435
tracker
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Lateral derived tables
32
bugs core 3435
tracker
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Lateral derived tables
33
bugs core 3474
tracker
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Regression in joins on procedures
34
bugs core 3474
tracker
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Regression in joins on procedures
35
bugs core 3557
tracker
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
AV in engine when preparing query against dropping table
36
bugs core 3557
tracker
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
AV in engine when preparing query against dropping table
37
bugs core 3675
tracker
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
CREATE INDEX considers NULL and empty string being the same in compound indices
38
bugs core 3675
tracker
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
CREATE INDEX considers NULL and empty string being the same in compound indices
39
bugs core 3697
tracker
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
String truncation error when selecting from a VIEW with UNION inside
40
bugs core 3697
tracker
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
String truncation error when selecting from a VIEW with UNION inside
41
bugs core 3829
tracker
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Bad alias table choice joining CTE
42
bugs core 3829
tracker
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Bad alias table choice joining CTE
43
bugs core 3919
tracker
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Improve SIMILAR TO performance
44
bugs core 3919
tracker
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Improve SIMILAR TO performance
45
bugs core 3965
tracker
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Creating a procedure containing "case when" expression leads to a server crash
46
bugs core 3965
tracker
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Creating a procedure containing "case when" expression leads to a server crash
47
bugs core 3966
tracker
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Creating a stored procedure with an "update or insert" statement with MATCHING fails
48
bugs core 3966
tracker
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Creating a stored procedure with an "update or insert" statement with MATCHING fails
49
bugs core 3967
tracker
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
subselect with reference to outer select fails
50
bugs core 3967
tracker
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
subselect with reference to outer select fails
51
bugs core 4200
tracker
 CS P P P P P P P P P P P P P P P P P P P P P X P P P P     E         E     P P
An uncommitted select of the pseudo table sec$users blocks new database connections
52
bugs core 4200
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 P P     E         E     P P
An uncommitted select of the pseudo table sec$users blocks new database connections
53
bugs core 4379
tracker
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Poor performance of explicit cursors containing correlated subqueries in the select list
54
bugs core 4379
tracker
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Poor performance of explicit cursors containing correlated subqueries in the select list
55
bugs core 4417
tracker
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
gbak: cannot commit index ; primary key with german umlaut
56
bugs core 4417
tracker
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
gbak: cannot commit index ; primary key with german umlaut
57
bugs core 4425
tracker
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
User-collations based on UNICODE are not upgrade to newer ICU version on restore
58
bugs core 4425
tracker
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
User-collations based on UNICODE are not upgrade to newer ICU version on restore
59
bugs core 4634
tracker
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Regression: ORDER BY via an index + WHERE clause: error "no current record for fetch operation"
60
bugs core 4634
tracker
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Regression: ORDER BY via an index + WHERE clause: error "no current record for fetch operation"
61
bugs core 4675
tracker
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Conditions like WHERE <field> = <cursor>.<field> do not use existing index
62
bugs core 4675
tracker
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Conditions like WHERE <field> = <cursor>.<field> do not use existing index
63
bugs core 4798
tracker
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Regression: MIN/MAX with a join ignores possible index navigation
64
bugs core 4798
tracker
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Regression: MIN/MAX with a join ignores possible index navigation
65
bugs core 5018
tracker
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Regression: Non-indexed predicates may not be applied immediately after retrieval when tables are being joined
66
bugs core 5018
tracker
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Regression: Non-indexed predicates may not be applied immediately after retrieval when tables are being joined
67
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 X P P P P     E         E     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
68
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 P P P     E         E     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
69
bugs core 5087
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 P P     E         E     P P
Database shutdown can cause server crash if multiple attachments run EXECUTE STATEMENT
70
bugs core 5295
tracker
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Validation could read after the end-of-file when handle multifile database
71
bugs core 5295
tracker
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Validation could read after the end-of-file when handle multifile database
72
bugs core 5309
tracker
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Backup created under FB2.5 can be restored in FB3.0.0.32419 but not under current snapshot (FB3.0.1.32556)
73
bugs core 5309
tracker
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Backup created under FB2.5 can be restored in FB3.0.0.32419 but not under current snapshot (FB3.0.1.32556)
74
bugs core 5329
tracker
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Database gets partially corrupted in the "no-reserve" mode
75
bugs core 5329
tracker
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Database gets partially corrupted in the "no-reserve" mode
76
bugs core 6440
tracker
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Expression indexes containing COALESCE inside cannot be matched by the optimizer after migration from v2.5 to v3.0
77
bugs core 6440
tracker
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Expression indexes containing COALESCE inside cannot be matched by the optimizer after migration from v2.5 to v3.0
78
gtcs gtcs proc isql 01
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
gtcs-proc-isql-01
79
gtcs gtcs proc isql 01
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
gtcs-proc-isql-01
80
gtcs gtcs proc isql 02
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
gtcs-proc-isql-02
81
gtcs gtcs proc isql 02
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
gtcs-proc-isql-02
82
gtcs gtcs proc isql 03
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
gtcs-proc-isql-03
83
gtcs gtcs proc isql 03
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
gtcs-proc-isql-03
84
gtcs gtcs proc isql 04
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
gtcs-proc-isql-04
85
gtcs gtcs proc isql 04
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
gtcs-proc-isql-04
86
gtcs gtcs proc isql 05
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
gtcs-proc-isql-05
87
gtcs gtcs proc isql 05
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
gtcs-proc-isql-05
88
gtcs gtcs proc isql 06
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
gtcs-proc-isql-06
89
gtcs gtcs proc isql 06
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
gtcs-proc-isql-06
90
gtcs gtcs proc isql 07
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
gtcs-proc-isql-07
91
gtcs gtcs proc isql 07
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
gtcs-proc-isql-07
92
gtcs gtcs proc isql 10
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
gtcs-proc-isql-10
93
gtcs gtcs proc isql 10
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
gtcs-proc-isql-10
94
gtcs gtcs proc isql 11
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
gtcs-proc-isql-11
95
gtcs gtcs proc isql 11
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
gtcs-proc-isql-11
96
gtcs gtcs proc isql 12
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
gtcs-proc-isql-12
97
gtcs gtcs proc isql 12
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
gtcs-proc-isql-12
98
gtcs gtcs proc isql 13
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
gtcs-proc-isql-13
99
gtcs gtcs proc isql 13
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
gtcs-proc-isql-13
100
gtcs gtcs proc isql 14
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
gtcs-proc-isql-14
101
gtcs gtcs proc isql 14
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
gtcs-proc-isql-14
102
gtcs gtcs proc isql 15
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
gtcs-proc-isql-15
103
gtcs gtcs proc isql 15
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
gtcs-proc-isql-15
104
gtcs gtcs proc isql 16
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
gtcs-proc-isql-16
105
gtcs gtcs proc isql 16
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
gtcs-proc-isql-16
106
gtcs gtcs proc isql 17
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
gtcs-proc-isql-17
107
gtcs gtcs proc isql 17
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
gtcs-proc-isql-17
108
gtcs gtcs proc isql 18
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
gtcs-proc-isql-18
109
gtcs gtcs proc isql 18
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
gtcs-proc-isql-18
110
gtcs gtcs proc isql 19
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
gtcs-proc-isql-19
111
gtcs gtcs proc isql 19
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
gtcs-proc-isql-19
112
gtcs gtcs proc isql 20
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
gtcs-proc-isql-20
113
gtcs gtcs proc isql 20
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
gtcs-proc-isql-20
114
gtcs gtcs select delete isql
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
GTCS/tests/SELECT_DELETE_ISQL. Test for select from SP that deletes record after its output.
115
gtcs gtcs select delete isql
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
GTCS/tests/SELECT_DELETE_ISQL. Test for select from SP that deletes record after its output.
116
gtcs sql join 03
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
GTCS/tests/C_SQL_JOIN_3. Ability to run query: ( A LEFT JOIN B ) INER JOIN C, plus ORDER BY with fields not from SELECT list.
117
gtcs sql join 03
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
GTCS/tests/C_SQL_JOIN_3. Ability to run query: ( A LEFT JOIN B ) INER JOIN C, plus ORDER BY with fields not from SELECT list.
118
gtcs sql join 04
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
GTCS/tests/C_SQL_JOIN_4. Ability to run query: ( A LEFT JOIN B ) , C. Then add ORDER BY with fields not from SELECT list.
119
gtcs sql join 04
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
GTCS/tests/C_SQL_JOIN_4. Ability to run query: ( A LEFT JOIN B ) , C. Then add ORDER BY with fields not from SELECT list.
120
tabloid bus 3103 windowed funcs
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Query for test MAX()OVER().
121
tabloid bus 3103 windowed funcs
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Query for test MAX()OVER().
122
tabloid dbp 0951 multiple nested cte
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Query for test multiple CTEs
123
tabloid dbp 0951 multiple nested cte
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Query for test multiple CTEs
124
tabloid dbp 1697 windowed funcs
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Query for test SUM()OVER() and COUNT()OVER().
125
tabloid dbp 1697 windowed funcs
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Query for test SUM()OVER() and COUNT()OVER().
126
tabloid dbp 1940 20040130 1740
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Common SQL. Check correctness of the results
127
tabloid dbp 1940 20040130 1740
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Common SQL. Check correctness of the results
128
tabloid dbp 1940 20061108 2141
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Common SQL. Check correctness of the results
129
tabloid dbp 1940 20061108 2141
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Common SQL. Check correctness of the results
130
tabloid dbp 1940 20080912 1005
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Common SQL. Check correctness of the results
131
tabloid dbp 1940 20080912 1005
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Common SQL. Check correctness of the results
132
tabloid dbp 1940 20090521 1520
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Common SQL. Check correctness of the results
133
tabloid dbp 1940 20090521 1520
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Common SQL. Check correctness of the results
134
tabloid dbp 1940 20110426 1906
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Common SQL. Check correctness of the results
135
tabloid dbp 1940 20110426 1906
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Common SQL. Check correctness of the results
136
tabloid dbp 1940 20110725 1159
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Common SQL. Check correctness of the results
137
tabloid dbp 1940 20110725 1159
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Common SQL. Check correctness of the results
138
tabloid dbp 1940 20130412 1008
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Common SQL. Check correctness of the results
139
tabloid dbp 1940 20130412 1008
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Common SQL. Check correctness of the results
140
tabloid dbp 1940 20130831 2039
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Common SQL. Check correctness of the results
141
tabloid dbp 1940 20130831 2039
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Common SQL. Check correctness of the results
142
tabloid dbp 1940 20130912 1908
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Common SQL. Check correctness of the results
143
tabloid dbp 1940 20130912 1908
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Common SQL. Check correctness of the results
144
tabloid dbp 2146 distinct not in
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Common SQL. Check correctness of the results
145
tabloid dbp 2146 distinct not in
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Common SQL. Check correctness of the results
146
tabloid dbp 4137 full join and windowed funcs
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Common SQL. Check correctness of the results
147
tabloid dbp 4137 full join and windowed funcs
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Common SQL. Check correctness of the results
148
tabloid dbp 4391 full join and windowed funcs
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Common SQL. Check correctness of the results
149
tabloid dbp 4391 full join and windowed funcs
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Common SQL. Check correctness of the results
150
tabloid dbp 4391 full join and windowed funcs2
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Common SQL. Check correctness of the results
151
tabloid dbp 4391 full join and windowed funcs2
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Common SQL. Check correctness of the results
152
tabloid dbp 5125 windowed funcs
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Common SQL. Check correctness of the results
153
tabloid dbp 5125 windowed funcs
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Common SQL. Check correctness of the results
154
tabloid dbp 7029 heavy test for windowed funcs
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Common SQL. Check correctness of the results
155
tabloid dbp 7029 heavy test for windowed funcs
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Common SQL. Check correctness of the results
156
tabloid dbp 7114 windowed funcs
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Common SQL. Check correctness of the results
157
tabloid dbp 7114 windowed funcs
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Common SQL. Check correctness of the results
158
tabloid eqc 343715
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Checking PK index is used when table is joined as driven (right) source in LEFT OUTER join from VIEW
159
tabloid eqc 343715
 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Checking PK index is used when table is joined as driven (right) source in LEFT OUTER join from VIEW
160
tabloid snd 7795 20120706 1249
 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P P P P P
Common SQL. Check correctness of the results
161
tabloid snd 7795 20120706 1249
 SS P P P P P P P P P     E         E     P P P P P P P P P 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.229
2021-09-26		 5.0.0.228
2021-09-23		 5.0.0.220
2021-09-22		 5.0.0.219
2021-09-20		 5.0.0.218
2021-09-19		 5.0.0.215
2021-09-17		 5.0.0.212
2021-09-16		 5.0.0.208
2021-09-15		 5.0.0.202
2021-09-14		 5.0.0.198
2021-09-12		 5.0.0.197
2021-09-11		 5.0.0.196
2021-09-10		 5.0.0.193
2021-09-09		 5.0.0.192
2021-09-08		 5.0.0.187
2021-09-07		 5.0.0.186
2021-09-04		 5.0.0.181
2021-09-03		 5.0.0.176
2021-09-02		 5.0.0.172
2021-08-31		 5.0.0.169
2021-08-29		 5.0.0.168
2021-08-28		 5.0.0.163
2021-08-27		 5.0.0.161
2021-08-26		 5.0.0.158
2021-08-25		 5.0.0.157
2021-08-23		 5.0.0.149
2021-08-22		 5.0.0.143
2021-08-21		 5.0.0.142
2021-08-19		 5.0.0.141
2021-08-14		 5.0.0.140
2021-08-13
Test TITLE
1
bugs core 0086
tracker
 CS 2190 2180 2659 2650 2670 2629 2680 2200 2150 2120 769 1220 2169 2150 2170 2180 2190 2209 2639 2570 2589 2589 2640 2170 2190 2120 2620 2649 2160 2170
Index bug
2
bugs core 0086
tracker
 SS 2420 2400 2439 2410 2410 2420 2429 2430 2400 2429 859 840 2430 2410 2399 2410 2419 2390 2439 2470 2420 2450 2420 2420 2450 2479 2410 2389 2370 2459 2420
Index bug
3
bugs core 1006
tracker
 CS 2399 2320 3039 2980 3019 3009 3569 2359 2409 2429 740 1290 2369 2399 2330 2349 2390 2399 3000 2979 2930 3289 2919 2390 2389 2379 2940 3009 2329 2339
AV at rollback and \ or garbage collection if updated table have expression index with SELECT in it
4
bugs core 1006
tracker
 SS 2639 2640 2710 2599 2620 2649 2630 2639 2670 2630 859 839 2630 2680 2650 2710 2649 2649 2619 2680 2629 2680 2609 2659 2649 2590 2700 2589 2650 2630 2620
AV at rollback and \ or garbage collection if updated table have expression index with SELECT in it
5
bugs core 1063
tracker
 CS 2259 2259 3019 2860 2799 2960 2839 2259 2259 2240 759 1490 2259 2230 2200 2240 2000 2279 2840 2940 2759 2809 2769 2000 2000 2259 2839 2950 2220 2230
Server hangs eating CPU and performs huge I/O copying different codepage fields
6
bugs core 1063
tracker
 SS 1789 1859 1759 1779 1809 1759 1000 1799 1759 1789 559 559 1779 1799 1870 1759 1830 1769 1779 1790 1779 1809 1809 1789 1829 1779 1899 1809 1850 1759 1799
Server hangs eating CPU and performs huge I/O copying different codepage fields
7
bugs core 1331
tracker
 CS 2164 2150 2640 2540 2129 2639 2639 2159 2169 2149 0 730 2169 2179 2090 2139 2150 2150 2620 2609 2650 2569 2559 2130 2150 2130 2560 2620 2099 2089
Charset transliterations don't work with EXECUTE STATEMENT
8
bugs core 1331
tracker
 SS 2400 2400 2400 2390 2379 2400 2399 2400 2390 2400 819 879 2400 2390 2389 2430 2420 2000 2450 2420 2419 2420 2410 2390 2400 2420 2449 2369 2370 2420 2430
Charset transliterations don't work with EXECUTE STATEMENT
9
bugs core 1642
tracker
 CS 2589 2620 2659 2609 2590 2609 2690 2559 2569 2549 2559 2599 2579 2559 2589 2579 2569 2589 2620 2559 2620 2620 2559 2589 2619 2609 4350 3940 2560 2569
Non-privileged monitoring reports wrong attachment data
10
bugs core 1642
tracker
 SS 2490 2490 2000 2450 2539 2490 2519 2489 2519 2529 2490 2480 2510 2509 2490 2470 2519 2460 2519 2450 2470 2470 2000 2509 2430 2490 2530 2710 2720 2000 2509
Non-privileged monitoring reports wrong attachment data
11
bugs core 1752
tracker
 CS 2589 2589 3059 3029 2520 2980 2980 2529 2529 2519 740 730 2509 2519 2530 2519 2549 2570 3080 3009 3089 3159 3000 2959 2610 2589 3119 3059 2490 2519
Results of a join with different collations depend on the execution plan
12
bugs core 1752
tracker
 SS 2964 3089 3000 2950 3259 2969 2979 3000 2960 3019 819 809 3039 3009 2950 2899 2970 2900 2909 2919 3019 2869 2970 3009 2889 2950 2970 2949 2960 2960 3019
Results of a join with different collations depend on the execution plan
13
bugs core 2078
tracker
 CS 2899 2900 2929 2899 2829 2839 2980 2870 2819 2819 800 779 2890 2880 2970 3009 2980 2820 2960 3370 3389 3000 2870 2839 2960 2970 5000 5380 2859 2840
Suboptimal join plan if there are selective non-indexed predicates involved
14
bugs core 2078
tracker
 SS 3349 3339 3419 3309 3349 3349 3380 3359 3369 3319 929 890 3350 3350 3339 3290 3369 3299 3289 3299 3360 3289 3329 3339 3309 3349 3350 4120 4180 3359 3369
Suboptimal join plan if there are selective non-indexed predicates involved
15
bugs core 2233
tracker
 CS 2700 2769 2690 2720 2730 2700 2730 2679 2700 2700 2680 2730 2680 2710 2680 2680 2680 2680 2730 2679 2730 2820 2690 2720 2730 2730 2419 2389 2679 2710
Allow non-SYSDBA users to monitor not only their current attachment but other their attachments as well
16
bugs core 2233
tracker
 SS 2519 2519 2539 2509 2519 2510 2529 2519 2539 2519 2490 2480 2490 2590 2520 2000 2519 2000 2509 2509 2559 2479 2000 2000 2470 2529 2509 2720 2729 2529 2560
Allow non-SYSDBA users to monitor not only their current attachment but other their attachments as well
17
bugs core 2721
tracker
 CS 2614 2549 3039 3040 2630 3029 3059 2569 2620 2609 0 759 2569 2650 2590 2590 2570 2589 3039 3019 3119 3039 3059 2589 2539 2590 3049 2980 2569 2539
Issue with SIMILAR TO and UTF8 on 2.5 Beta 2 (and 1)
18
bugs core 2721
tracker
 SS 3009 3029 3019 3009 3000 3009 3099 3049 3029 2990 849 840 3089 3000 3009 2970 3039 3009 3009 3009 2990 3039 2990 2980 3030 3009 3039 2990 2980 3039 3009
Issue with SIMILAR TO and UTF8 on 2.5 Beta 2 (and 1)
19
bugs core 2890
tracker
 CS 2579 2589 3040 3070 2560 3069 3039 2579 2559 2570 740 769 2560 2560 2559 2620 2619 2559 2980 3060 3049 3040 3039 2549 2490 2559 3009 3059 2549 2559
SQLSTATE should also be available as a PSQL context variable like GDSCODE/SQLCODE
20
bugs core 2890
tracker
 SS 3009 3000 3009 3000 3019 3000 3019 3009 3000 3029 819 839 3009 3000 2979 3009 3009 3019 3009 3029 3069 2990 3039 3240 3009 3019 3039 2960 2970 3009 3039
SQLSTATE should also be available as a PSQL context variable like GDSCODE/SQLCODE
21
bugs core 3076
tracker
 CS 2850 2930 2869 2839 2840 2940 2849 2779 2860 2870 779 780 2960 2850 2759 2779 2919 2930 2810 2839 2910 2940 2860 2949 2769 2839 2910 2790 2819 2940
Better performance for (table.field = :param or :param = -1) in where clause
22
bugs core 3076
tracker
 SS 3259 3259 3259 3259 3000 3259 3269 3200 3299 3279 850 859 3240 3230 3259 3259 3230 3290 3000 3290 3190 3210 3000 3000 3289 3230 3289 3309 3210 3289 3290
Better performance for (table.field = :param or :param = -1) in where clause
23
bugs core 3210
tracker
 CS 2759 2789 3369 3340 2730 3380 3359 2619 2759 2680 740 0 2730 2000 2580 2610 2759 2740 3349 3370 3299 3190 3369 2759 2740 2759 3279 3279 2610 2740
The cursor identified in the UPDATE or DELETE statement is not positioned on a row. no current record for fetch operation in SELECT query
24
bugs core 3210
tracker
 SS 3139 3190 3159 3119 3149 3170 3140 3170 3120 3190 919 889 3089 3179 3149 3139 3059 3220 3089 3100 3089 3109 3200 3099 3140 3120 3149 3099 3190 3130 3230
The cursor identified in the UPDATE or DELETE statement is not positioned on a row. no current record for fetch operation in SELECT query
25
bugs core 3277
tracker
 CS 2560 2560 3599 2929 2539 3020 3070 2560 2569 2000 0 730 2549 2540 2460 2000 2560 2539 3059 3049 2960 3009 2990 2559 2540 2669 3029 3029 2539 2529
Wrong result for RIGHT(UTF8 varchar)
26
bugs core 3277
tracker
 SS 3004 3039 2980 3009 3009 3009 3000 2969 3070 3009 830 819 2980 2990 2989 3049 2930 3049 3009 2950 2930 2930 2950 3019 3029 3009 3089 2959 3009 3030 3000
Wrong result for RIGHT(UTF8 varchar)
27
bugs core 3282
tracker
 CS 2579 2559 3060 3090 2570 3189 3019 2529 2579 2509 730 730 2550 2559 2509 2589 2579 2550 3029 3019 2980 2990 3019 2559 2649 2570 3060 2960 2529 3009
EXECUTE STATEMENT parses the SQL text using wrong charset
28
bugs core 3282
tracker
 SS 2980 2990 2980 2980 3029 2980 2990 2930 3000 3000 809 819 2960 2959 2970 3009 2950 2990 2980 2980 2919 2919 2950 2970 2990 3009 3000 2970 2930 2979 3009
EXECUTE STATEMENT parses the SQL text using wrong charset
29
bugs core 3310
tracker
 CS 2869 2880 2890 2849 2910 2869 2870 2789 2870 2799 800 810 2869 2870 2799 2809 2879 2870 2850 3509 3369 3399 2850 2869 2849 2930 2829 2769 2809 2869
RDB$GET_CONTEXT and between in view
30
bugs core 3310
tracker
 SS 3314 3319 3340 3319 3369 3309 3340 3259 3310 3399 920 910 3289 3309 3309 3329 3279 3330 3329 3319 3259 3299 3000 3259 3370 3339 3339 3299 3309 3319 3329
RDB$GET_CONTEXT and between in view
31
bugs core 3435
tracker
 CS 2640 2559 3099 3039 2670 3059 3029 2509 2629 2509 769 769 2629 2610 2509 2579 2650 2579 3140 3119 2969 2980 3120 2640 2619 2659 2970 3079 2619 2539
Lateral derived tables
32
bugs core 3435
tracker
 SS 3009 3019 3009 3000 3000 3000 2979 2920 3000 3009 930 859 3009 3009 3009 3019 3029 3009 2979 2990 2950 3029 3000 3009 3019 3009 3019 3039 2990 3019 3309
Lateral derived tables
33
bugs core 3474
tracker
 CS 2850 2900 2850 2870 2869 2840 2870 2779 2880 2789 789 789 2869 2920 2800 2829 2869 2889 2869 2859 2829 2789 2849 2869 2880 2869 2809 2789 2800 2839
Regression in joins on procedures
34
bugs core 3474
tracker
 SS 3289 3290 3289 3259 3339 3310 3309 3180 3320 3260 869 880 3289 3269 3259 3299 3209 3289 3309 3290 3000 3240 3240 3259 3309 3329 3320 3340 3259 3299 3319
Regression in joins on procedures
35
bugs core 3557
tracker
 CS 2589 2529 3080 3029 2589 3119 3029 2529 2580 2000 769 740 2589 2619 2569 2559 2599 2559 3190 3070 3039 2980 3019 2569 2570 2620 3009 3009 2480 2559
AV in engine when preparing query against dropping table
36
bugs core 3557
tracker
 SS 3009 3079 3009 3009 3039 3029 2960 2950 3039 2980 859 839 2980 3019 3009 3009 2940 3019 3009 3000 3009 2950 3000 2980 3009 3009 3009 3009 3039 3039 3009
AV in engine when preparing query against dropping table
37
bugs core 3675
tracker
 CS 2589 2589 3090 3040 2590 3130 3019 2000 2559 2480 0 799 2539 2589 2000 2559 2539 2559 3059 3049 2960 3150 3049 2589 2559 2579 3039 3009 2529 2549
CREATE INDEX considers NULL and empty string being the same in compound indices
38
bugs core 3675
tracker
 SS 3000 2990 2990 3009 2990 3089 3059 2950 3000 3000 839 849 3119 3029 3019 3009 2960 3030 2990 3200 2990 2980 2980 3170 3009 3019 2990 3070 2980 3009 2980
CREATE INDEX considers NULL and empty string being the same in compound indices
39
bugs core 3697
tracker
 CS 3079 2970 3590 3659 3089 3669 3670 3000 3130 3000 899 900 3079 3069 3039 3059 3059 3060 3680 3609 3600 3669 3660 3069 3089 3049 3620 3559 3009 3049
String truncation error when selecting from a VIEW with UNION inside
40
bugs core 3697
tracker
 SS 3469 3580 3529 3440 3509 3519 3460 3429 3469 3489 1000 970 3549 3480 3460 3480 3419 3460 3490 3480 3470 3400 3430 3480 3449 3490 3470 3429 3460 3509 3439
String truncation error when selecting from a VIEW with UNION inside
41
bugs core 3829
tracker
 CS 2650 2659 3129 3129 2639 3119 3109 2589 2640 2579 779 769 2640 2670 2559 2650 2620 2650 3210 3110 3140 3140 3109 2619 2630 2630 3160 3059 2569 2619
Bad alias table choice joining CTE
42
bugs core 3829
tracker
 SS 3069 3079 3069 3089 3069 3069 3069 3089 3069 3069 839 870 3070 3119 3070 3069 2990 3099 3080 3120 3079 3009 3069 3069 3079 3059 3140 3060 3069 3069 3069
Bad alias table choice joining CTE
43
bugs core 3919
tracker
 CS 3430 3429 4079 4039 3440 4080 4100 3399 3390 3310 0 0 3389 3400 3369 3410 3370 3400 4039 4039 4060 4079 4240 3400 3460 3430 4069 4099 3340 3419
Improve SIMILAR TO performance
44
bugs core 3919
tracker
 SS 3870 3870 3869 4069 3870 3880 3849 3880 3889 3900 889 860 3829 3830 3850 3950 3809 3859 3939 3859 3900 3900 3839 3929 3889 3900 3880 3789 3929 3850 3860
Improve SIMILAR TO performance
45
bugs core 3965
tracker
 CS 2869 2869 2869 2789 2870 2859 2860 2789 2869 2790 789 809 2869 2889 2890 2860 2860 2869 2900 2880 2890 2869 2849 2869 2889 2870 2859 2779 2779 2849
Creating a procedure containing "case when" expression leads to a server crash
46
bugs core 3965
tracker
 SS 3309 3289 3329 3299 3359 3340 3290 3309 3330 3309 870 889 3319 3259 3330 3320 3240 3309 3319 3320 3339 3230 3230 3000 3379 3300 3309 3240 3319 3309 3269
Creating a procedure containing "case when" expression leads to a server crash
47
bugs core 3966
tracker
 CS 2879 2900 2890 2829 2879 2870 2869 2819 2930 2809 799 810 2860 2900 2869 2919 2879 2900 2900 2869 2879 2880 2900 2850 2900 2900 2869 2839 2799 3220
Creating a stored procedure with an "update or insert" statement with MATCHING fails
48
bugs core 3966
tracker
 SS 3319 3309 3300 3329 3319 3319 3309 3340 3339 3350 889 870 3330 3289 3319 3309 3259 3299 3329 3329 3319 3259 3000 3259 3329 3369 3319 3349 3240 3349 3309
Creating a stored procedure with an "update or insert" statement with MATCHING fails
49
bugs core 3967
tracker
 CS 2850 2859 2849 2810 2850 2829 2849 2790 2870 2789 789 799 2879 2849 2810 2870 2870 2869 2859 2870 2859 2869 2859 2809 2879 2849 2850 2779 2830 2880
subselect with reference to outer select fails
50
bugs core 3967
tracker
 SS 3279 3289 3299 3289 3289 3269 3359 3289 3289 3259 870 910 3289 3259 3259 3279 3219 3279 3320 3269 3310 3230 3210 3230 3290 3279 3339 3000 3000 3320 3230
subselect with reference to outer select fails
51
bugs core 4200
tracker
 CS 2920 3329 2809 2920 3340 2809 2940 2919 2879 2980 2809 2920 2890 2809 2930 2920 2809 2919 2950 2809 2920 2930 2809 2920 2980 2919 3900 3130 2930 2950
An uncommitted select of the pseudo table sec$users blocks new database connections
52
bugs core 4200
tracker
 SS 2939 2939 2960 2960 2950 2979 2950 2920 2919 2899 2950 2980 2970 2910 2930 2960 2960 2920 2939 2940 2869 3430 2980 2949 2930 2930 2920 2740 2669 2930 2970
An uncommitted select of the pseudo table sec$users blocks new database connections
53
bugs core 4379
tracker
 CS 3959 4079 3920 3960 3960 3890 3950 3990 3900 4009 779 780 3889 4000 3959 3960 3880 3980 4069 3899 3969 3959 4000 4029 4039 3919 4009 3950 3939 3879
Poor performance of explicit cursors containing correlated subqueries in the select list
54
bugs core 4379
tracker
 SS 4370 4390 4419 4420 4380 4349 4339 4349 4380 4319 860 859 4350 4349 4340 4269 4390 4400 4350 4310 4339 4570 4490 4370 4419 4299 4370 4609 4399 4380 4400
Poor performance of explicit cursors containing correlated subqueries in the select list
55
bugs core 4417
tracker
 CS 2590 2569 2970 3029 2559 2980 3049 2640 2490 2579 730 730 2519 2590 2529 2509 2490 2559 3069 2950 3060 3039 2970 2620 2570 2620 3100 3049 2529 2509
gbak: cannot commit index ; primary key with german umlaut
56
bugs core 4417
tracker
 SS 2995 3050 3009 3019 3000 2960 2970 3039 3029 2930 839 840 2990 3009 2930 2910 3029 3029 3019 2919 2930 2970 3039 2950 3019 2930 3009 2950 2919 3029 3059
gbak: cannot commit index ; primary key with german umlaut
57
bugs core 4425
tracker
 CS 2210 2200 2130 2700 2210 2600 2660 2180 2210 2180 759 0 2149 2210 2200 2150 2129 2230 2680 2600 2689 2690 2609 2259 2200 2179 2650 2650 2210 2139
User-collations based on UNICODE are not upgrade to newer ICU version on restore
58
bugs core 4425
tracker
 SS 2450 2449 2450 2509 2460 2450 2450 2450 2460 2799 840 829 2459 2509 2469 2450 2480 2450 2509 2410 2409 2539 2710 2439 2000 2479 2449 2000 2420 2480 2480
User-collations based on UNICODE are not upgrade to newer ICU version on restore
59
bugs core 4634
tracker
 CS 2859 2789 2850 2869 2870 2870 2859 2849 2920 2920 800 799 2900 2859 2849 2859 2870 2869 2809 2869 2860 2839 2870 2849 2810 2869 2859 2869 2880 2780
Regression: ORDER BY via an index + WHERE clause: error "no current record for fetch operation"
60
bugs core 4634
tracker
 SS 3309 3289 3380 3440 3339 3389 3349 3289 3309 3259 940 880 3289 3369 3309 3220 3319 3309 3359 3289 3230 3319 3309 3539 3359 3309 3289 3269 3279 3319 3339
Regression: ORDER BY via an index + WHERE clause: error "no current record for fetch operation"
61
bugs core 4675
tracker
 CS 2779 2700 2730 2819 2730 2810 2000 2730 2809 2900 779 779 2730 2800 2809 2820 2809 2849 2700 2810 2729 2819 2759 2830 2710 2000 2779 2789 3230 2720
Conditions like WHERE <field> = <cursor>.<field> do not use existing index
62
bugs core 4675
tracker
 SS 3149 3169 3199 3170 3160 3180 3179 3169 3150 3079 879 839 3119 3160 3129 3090 3160 3140 3180 3070 3089 3120 3149 3139 3170 3170 3149 3119 3089 3169 3160
Conditions like WHERE <field> = <cursor>.<field> do not use existing index
63
bugs core 4798
tracker
 CS 2700 2769 2700 2759 2700 2689 2690 2680 2759 2680 799 779 2679 2679 2680 2810 2759 2760 2619 2690 2779 2680 2680 2780 2619 2759 3900 2779 2759 2759
Regression: MIN/MAX with a join ignores possible index navigation
64
bugs core 4798
tracker
 SS 3114 3120 3140 3130 3109 3119 3179 3140 3119 3140 879 849 3150 3109 3090 3069 3129 3099 3080 3089 3089 2980 3120 3109 3140 3119 3120 3070 3039 3110 3140
Regression: MIN/MAX with a join ignores possible index navigation
65
bugs core 5018
tracker
 CS 2700 2789 2700 2700 2769 2710 2759 2620 2759 2619 779 779 2700 2690 2630 2710 2700 2779 2699 2690 2759 2649 3199 2769 2740 2700 2769 2630 2620 2709
Regression: Non-indexed predicates may not be applied immediately after retrieval when tables are being joined
66
bugs core 5018
tracker
 SS 3119 3199 3170 3139 3149 3120 3109 3109 3149 3099 859 880 3219 3129 3120 3109 3139 3110 3169 3110 3110 3109 3119 3099 3169 3079 3140 3039 3079 3129 3130
Regression: Non-indexed predicates may not be applied immediately after retrieval when tables are being joined
67
bugs core 5075
tracker
 CS 8000 8019 8000 8490 8080 7990 8019 7779 7990 7819 8000 7819 8090 7990 7940 7799 8170 8000 8110 8129 7880 7960 8200 8019 7980 8160 13539 14360 7769 8029
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
68
bugs core 5075
tracker
 SS 8030 7970 8050 8030 8049 8080 8019 7980 8049 7909 8020 8019 8220 7940 7960 8020 8129 8039 8139 7959 8019 8259 7970 8079 8030 8039 8019 10509 10560 8029 8319
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
69
bugs core 5087
tracker
 SS 13900 13619 13809 14179 14400 14000 14329 14150 13649 13890 14400 13820 13939 13480 13680 13569 13910 14000 14089 13000 13860 14079 13880 13950 14400 14070 13439 7269 7539 14009 13650
Database shutdown can cause server crash if multiple attachments run EXECUTE STATEMENT
70
bugs core 5295
tracker
 CS 6229 6319 6230 6190 6210 6240 6210 6130 6229 6139 790 799 6240 6000 6160 6259 6200 6259 6370 6769 6829 6950 6259 6269 6210 6220 6819 7279 6130 6160
Validation could read after the end-of-file when handle multifile database
71
bugs core 5295
tracker
 SS 6679 6730 6679 6670 6730 6689 6689 6730 6639 6740 880 889 6680 6639 6640 6630 6689 6729 6689 6629 6679 6649 6630 6630 6710 6649 6769 6769 6629 6710 6689
Validation could read after the end-of-file when handle multifile database
72
bugs core 5309
tracker
 CS 2589 2569 2609 2650 2600 2579 2589 2539 2599 2519 0 769 2569 2589 2529 2589 2569 2589 2590 3080 3059 3090 2569 2579 2569 2589 3119 3000 2550 2639
Backup created under FB2.5 can be restored in FB3.0.0.32419 but not under current snapshot (FB3.0.1.32556)
73
bugs core 5309
tracker
 SS 3000 2990 2990 3000 3000 3009 2990 3039 3000 3040 809 849 3009 2990 3009 3000 2990 3079 3000 3019 3039 3009 3000 2990 3009 3009 3000 2980 2969 3029 3009
Backup created under FB2.5 can be restored in FB3.0.0.32419 but not under current snapshot (FB3.0.1.32556)
74
bugs core 5329
tracker
 CS 5050 5050 5039 4899 5420 5080 5019 5040 5039 4990 759 779 5050 5069 4970 5009 5059 5710 5019 5740 5670 5970 5090 5279 5459 4990 5640 5460 4960 4990
Database gets partially corrupted in the "no-reserve" mode
75
bugs core 5329
tracker
 SS 4319 4309 4269 4319 4570 4319 4269 4670 4360 4269 860 890 4279 4279 4529 4829 4359 4259 4539 4460 4300 4320 4269 4269 4529 4400 4309 4359 4420 4359 4400
Database gets partially corrupted in the "no-reserve" mode
76
bugs core 6440
tracker
 CS 2170 2180 2129 2090 2139 2200 2200 2190 2119 2119 769 769 2150 2180 2160 2169 2180 2160 2220 2580 2620 2680 2150 2170 2190 2150 2589 2619 2189 2149
Expression indexes containing COALESCE inside cannot be matched by the optimizer after migration from v2.5 to v3.0
77
bugs core 6440
tracker
 SS 2480 2480 2480 2470 2580 2490 2480 2480 2000 2480 840 859 2429 2509 2480 2000 2480 2480 2000 2480 2480 2490 2000 2759 2000 2480 2480 2000 2519 2000 2509
Expression indexes containing COALESCE inside cannot be matched by the optimizer after migration from v2.5 to v3.0
78
gtcs gtcs proc isql 01
 CS 2589 2620 2529 2619 2620 2519 2640 2530 2569 2589 0 0 2529 2590 2589 2640 2530 2569 2579 2980 2979 3079 2579 2569 2589 2610 2960 2979 2580 2519
gtcs-proc-isql-01
79
gtcs gtcs proc isql 01
 SS 3009 2950 3039 2970 2980 2980 3060 2970 3010 3070 840 850 2970 2950 3009 2960 3039 3019 3009 3019 3049 2960 3019 3009 2970 3009 3039 3019 3039 3039 3019
gtcs-proc-isql-01
80
gtcs gtcs proc isql 02
 CS 2569 2519 2509 2590 2569 2569 2569 2529 2549 2570 0 0 2509 2569 2589 2539 2529 2610 2619 2509 2509 2569 2539 2579 2569 2599 2000 2509 2579 2490
gtcs-proc-isql-02
81
gtcs gtcs proc isql 02
 SS 3000 2949 3009 2960 2950 2920 3019 2979 2929 3000 809 809 2980 2970 3009 2960 3019 3019 3030 3000 3009 2949 3029 3009 2950 2970 3019 3029 3009 3039 3029
gtcs-proc-isql-02
82
gtcs gtcs proc isql 03
 CS 2534 2519 2509 2589 2589 2509 2580 2509 2539 2579 0 740 2529 2579 2600 2529 2509 2569 2570 2529 2530 2590 2570 2509 2590 2590 2000 2510 2569 2509
gtcs-proc-isql-03
83
gtcs gtcs proc isql 03
 SS 2990 2970 3009 2970 2930 2899 3029 2930 2950 2990 809 819 2980 2930 3009 2949 3009 2990 3039 3009 3019 2960 3009 3039 2949 2929 3029 3000 3039 3029 3029
gtcs-proc-isql-03
84
gtcs gtcs proc isql 04
 CS 2529 2509 2529 2600 2640 2509 2589 2529 2529 2589 740 0 2000 2580 2579 2509 2529 2589 2569 2529 2519 2589 2579 2529 2609 2589 2519 2529 2610 2529
gtcs-proc-isql-04
85
gtcs gtcs proc isql 04
 SS 2990 2960 3000 2930 2930 2920 3029 2930 2930 3009 809 810 2930 2950 3000 2970 3019 3039 3029 2990 3029 2940 3029 3019 2940 2960 3039 2990 3009 3019 3019
gtcs-proc-isql-04
86
gtcs gtcs proc isql 05
 CS 2569 2509 2509 2579 2539 2519 2569 2519 2509 2600 0 0 2509 2609 2589 2539 2490 2570 2629 2570 2509 2620 2639 2509 2569 2579 2529 2559 2569 2610
gtcs-proc-isql-05
87
gtcs gtcs proc isql 05
 SS 2995 2930 3009 2929 2919 2950 3009 2950 2970 3000 810 799 2950 2909 3009 2940 3009 3009 3009 3059 3040 2940 3090 2990 2940 2920 3000 3039 3009 3029 3000
gtcs-proc-isql-05
88
gtcs gtcs proc isql 06
 CS 2554 2529 2520 2639 2589 2520 2590 2000 2509 2579 0 769 2490 2609 2570 2509 2529 2579 2580 2509 2609 2569 2550 2539 2590 2570 2559 2509 2579 2479
gtcs-proc-isql-06
89
gtcs gtcs proc isql 06
 SS 2990 2930 3009 2930 2980 2929 3009 2980 2929 3009 809 809 2909 2920 3009 2950 3029 3000 2990 3009 3029 2919 2990 3000 2950 2950 3009 3019 3000 3039 3039
gtcs-proc-isql-06
90
gtcs gtcs proc isql 07
 CS 2529 2519 2529 2580 2640 2509 2589 2509 2509 2619 769 740 2519 2570 2589 2510 2509 2569 2599 2539 2529 2599 2619 2510 2579 2569 2509 2490 2570 2520
gtcs-proc-isql-07
91
gtcs gtcs proc isql 07
 SS 2995 2969 3009 2950 2980 2950 3009 2929 2970 3009 799 829 2950 3059 2990 2970 3009 3029 3000 3000 3039 2970 3109 2980 2950 2929 3009 3009 3009 3070 3029
gtcs-proc-isql-07
92
gtcs gtcs proc isql 10
 CS 2559 2559 2509 2579 2590 2539 2570 2000 2539 2649 740 0 2509 2590 2689 2559 2509 2579 2669 2509 2549 2659 2569 2529 2610 2590 2509 2549 2640 2000
gtcs-proc-isql-10
93
gtcs gtcs proc isql 10
 SS 3009 2930 3009 2950 2929 3029 2990 2950 2939 3009 829 809 2930 3029 3000 2950 3049 3029 3029 3009 3009 2980 3029 3039 2930 2960 3009 3009 3029 3279 3029
gtcs-proc-isql-10
94
gtcs gtcs proc isql 11
 CS 2569 2519 2529 2580 2569 2529 2589 2519 2529 2580 769 0 2519 2589 2580 2509 2509 2599 2590 2509 2529 2570 2569 2529 2619 2589 2609 2520 2569 2569
gtcs-proc-isql-11
95
gtcs gtcs proc isql 11
 SS 2980 2949 3019 2950 2940 2980 3009 2959 2950 3040 799 809 2950 2949 2990 2930 3009 2990 2980 3000 3009 2949 3009 3029 2980 2929 3009 2990 2980 3050 3039
gtcs-proc-isql-11
96
gtcs gtcs proc isql 12
 CS 2529 2519 2519 2589 2589 2529 2579 2529 2509 2669 0 0 2529 2589 2659 2529 2529 2590 2589 2529 2529 2589 2559 2509 2600 2589 2509 2529 2559 2509
gtcs-proc-isql-12
97
gtcs gtcs proc isql 12
 SS 3004 2950 3000 2930 2930 2990 3069 2940 2930 3009 840 810 2920 3040 3009 2959 3019 3019 3060 2990 3019 2950 3059 3009 2959 3000 3039 3110 3019 3029 3039
gtcs-proc-isql-12
98
gtcs gtcs proc isql 13
 CS 2559 2600 2529 2559 2590 2509 2620 2529 2519 2570 0 759 2509 2600 2570 2529 2509 2559 2589 2570 2529 2579 2590 2509 2589 2570 2579 2529 2560 2509
gtcs-proc-isql-13
99
gtcs gtcs proc isql 13
 SS 3000 3000 3009 2970 2980 3009 3019 2930 2950 3039 819 789 2929 3000 2980 2940 3030 3039 2980 3079 3019 2930 3019 3009 2940 2950 3000 3069 3009 3039 3040
gtcs-proc-isql-13
100
gtcs gtcs proc isql 14
 CS 2559 2539 2509 2590 2569 2570 2669 2490 2509 2589 740 0 2550 2579 2569 2520 2509 2609 2620 2519 2519 2570 2589 2509 2609 2609 2509 2490 2569 2519
gtcs-proc-isql-14
101
gtcs gtcs proc isql 14
 SS 2995 2960 2980 2909 2949 3029 3019 2930 2959 3029 819 819 2920 2909 3009 2950 3009 3009 3019 3009 3009 2930 3029 3009 2940 2930 2990 3009 3029 3029 3000
gtcs-proc-isql-14
102
gtcs gtcs proc isql 15
 CS 2569 2529 2529 2589 2589 2509 3150 2509 2519 2569 0 0 2589 2650 2599 2539 2510 2630 2619 2519 2579 2589 2579 2509 2570 2569 2520 2529 2579 2519
gtcs-proc-isql-15
103
gtcs gtcs proc isql 15
 SS 2990 2950 3069 2950 2930 2990 3039 2949 2930 3019 809 789 2960 3080 3000 2930 3009 3029 3059 3009 2990 2970 3000 3030 2950 2950 3019 2980 2980 3009 3039
gtcs-proc-isql-15
104
gtcs gtcs proc isql 16
 CS 2569 2509 2530 2579 2660 2529 2589 2660 2519 2580 0 0 2549 2569 2569 2549 2519 2609 2570 2529 2510 2569 2580 2000 2619 2650 2509 2509 2569 2000
gtcs-proc-isql-16
105
gtcs gtcs proc isql 16
 SS 2995 2960 3049 2950 2950 3079 3019 2950 2950 3019 810 799 2930 2990 2980 2960 3029 3009 3009 3000 3009 2949 3019 3009 2950 2949 3019 3009 2990 3029 3029
gtcs-proc-isql-16
106
gtcs gtcs proc isql 17
 CS 2539 2509 2490 2650 2589 2509 2590 2539 2509 2589 799 0 2529 2589 2560 2529 2509 2600 2589 2529 2529 2640 2599 2529 2610 2690 2529 2529 2590 2540
gtcs-proc-isql-17
107
gtcs gtcs proc isql 17
 SS 2985 3009 3009 2960 2950 2990 2980 2930 2930 2990 809 810 2939 3029 2979 2949 3009 3040 2980 3019 3009 2980 2980 3009 2959 2930 3000 3000 3000 3059 3430
gtcs-proc-isql-17
108
gtcs gtcs proc isql 18
 CS 2569 2579 2529 2569 2600 2529 2589 2509 2529 2569 809 0 2509 2590 2569 2539 2519 2589 2579 2529 2589 2740 2650 2519 2589 2649 2579 2000 2559 2509
gtcs-proc-isql-18
109
gtcs gtcs proc isql 18
 SS 3004 3009 3040 3059 2929 3000 3019 2930 2939 3069 809 789 2910 3069 2980 2950 3009 3039 3009 3039 3009 2950 2970 3009 2970 2950 2990 3039 2980 3040 3059
gtcs-proc-isql-18
110
gtcs gtcs proc isql 19
 CS 2529 2509 2509 2650 2559 2529 2559 2000 2510 2570 759 740 2000 2559 2559 2509 2519 2579 2590 2509 2490 2579 2730 2000 2559 2590 2569 2490 2589 2529
gtcs-proc-isql-19
111
gtcs gtcs proc isql 19
 SS 2990 3009 3019 2950 2930 2980 3009 2919 2950 3009 809 819 2930 2950 3029 2930 2990 3009 2980 3029 3019 2910 2990 3009 2930 2950 3029 3039 3009 3009 3009
gtcs-proc-isql-19
112
gtcs gtcs proc isql 20
 CS 2559 2529 2509 2559 2589 2509 2580 2570 2509 2669 0 0 2540 2559 2559 2509 2509 2550 2619 2490 2000 2559 2549 2490 2570 2569 2590 2609 2560 2509
gtcs-proc-isql-20
113
gtcs gtcs proc isql 20
 SS 2990 3000 2980 2929 2950 3019 3000 2980 2930 3000 830 850 2919 2919 2980 2920 3009 3009 3039 3030 3009 2970 2980 3000 2920 2909 3059 3000 3009 3009 3009
gtcs-proc-isql-20
114
gtcs gtcs select delete isql
 CS 2589 2600 2539 2000 2600 2539 2589 2539 2619 2590 0 769 2609 2620 2650 2560 2539 2639 2620 2529 2539 2620 2599 2550 2589 2619 2619 3040 2569 2549
GTCS/tests/SELECT_DELETE_ISQL. Test for select from SP that deletes record after its output.
115
gtcs gtcs select delete isql
 SS 3009 3019 3019 2980 2950 3009 3039 2950 2960 3029 809 799 2940 3040 3009 2990 3029 3029 3009 3019 3039 2990 3009 3009 2980 2970 3019 3009 3009 3039 3059
GTCS/tests/SELECT_DELETE_ISQL. Test for select from SP that deletes record after its output.
116
gtcs sql join 03
 CS 2839 2779 2779 2849 2849 2759 2849 2809 2759 2839 810 809 2779 2859 2819 2790 2859 2850 2839 3349 3349 3450 2839 2779 2839 2869 3789 3299 2839 2789
GTCS/tests/C_SQL_JOIN_3. Ability to run query: ( A LEFT JOIN B ) INER JOIN C, plus ORDER BY with fields not from SELECT list.
117
gtcs sql join 03
 SS 3220 3240 3240 3219 3200 3220 3230 3170 3180 3230 920 910 3140 3399 3199 3180 3240 3289 3279 3210 3240 3170 3179 3220 3180 3150 3240 3279 3229 3279 3289
GTCS/tests/C_SQL_JOIN_3. Ability to run query: ( A LEFT JOIN B ) INER JOIN C, plus ORDER BY with fields not from SELECT list.
118
gtcs sql join 04
 CS 2809 2839 2790 2860 2809 2759 2840 2779 2759 2829 809 810 2780 2849 2869 2779 2759 2829 2850 2759 2789 2870 2839 2789 2819 2830 2840 2780 2839 2789
GTCS/tests/C_SQL_JOIN_4. Ability to run query: ( A LEFT JOIN B ) , C. Then add ORDER BY with fields not from SELECT list.
119
gtcs sql join 04
 SS 3195 3210 3200 3130 3139 3179 3200 3119 3140 3229 920 869 3119 3310 3190 3119 3220 3230 3190 3240 3279 3139 3230 3210 3160 3130 3219 3139 3200 3259 3230
GTCS/tests/C_SQL_JOIN_4. Ability to run query: ( A LEFT JOIN B ) , C. Then add ORDER BY with fields not from SELECT list.
120
tabloid bus 3103 windowed funcs
 CS 2590 2589 2590 2639 2609 2590 2570 2600 2589 2609 740 779 2580 2599 2589 2540 2539 2769 2649 3039 2980 3099 2579 2540 2509 2610 3089 2990 2539 2620
Query for test MAX()OVER().
121
tabloid bus 3103 windowed funcs
 SS 3039 3039 3049 3000 2980 3110 3039 2970 3069 3039 840 840 2960 2970 3029 3010 3059 3059 3079 3119 3059 3009 3039 3029 3029 2970 3049 3059 3049 3049 3080
Query for test MAX()OVER().
122
tabloid dbp 0951 multiple nested cte
 CS 3850 3859 3819 4029 3849 3850 3889 3869 3840 3890 779 759 3900 3839 3830 3870 3889 3869 3809 4289 4210 4269 3789 3740 3720 3829 4000 4220 3789 3829
Query for test multiple CTEs
123
tabloid dbp 0951 multiple nested cte
 SS 4225 4200 4310 4179 4340 4269 4230 4220 4289 4340 849 860 4230 4649 4309 4180 4270 4269 4279 4210 4190 4179 4210 4269 4149 4180 4200 4210 4210 4279 4240
Query for test multiple CTEs
124
tabloid dbp 1697 windowed funcs
 CS 2639 2650 2630 3069 2640 2639 2650 2720 2649 2619 0 0 2639 2619 2000 2730 2630 2650 2629 2679 2660 2780 2649 2579 2570 2620 2629 2639 2610 2629
Query for test SUM()OVER() and COUNT()OVER().
125
tabloid dbp 1697 windowed funcs
 SS 3059 3070 3049 2990 3059 3039 3089 3049 3059 3069 819 839 3049 3150 3089 3069 3039 3059 3099 3079 3069 3050 3049 3079 3009 2980 3049 3069 3059 3089 3090
Query for test SUM()OVER() and COUNT()OVER().
126
tabloid dbp 1940 20040130 1740
 CS 2820 2849 2829 2840 2849 2840 2829 2819 2809 2800 779 779 2800 2820 2789 2839 2829 2829 2830 2820 2849 2819 2830 2819 2919 2819 2830 2809 2740 2810
Common SQL. Check correctness of the results
127
tabloid dbp 1940 20040130 1740
 SS 3259 3289 3299 3170 3269 3000 3269 3259 3230 3419 860 870 3259 3419 3319 3339 3000 3240 3279 3360 3400 3189 3259 3259 3230 3200 3269 3000 3289 3269 3240
Common SQL. Check correctness of the results
128
tabloid dbp 1940 20061108 2141
 CS 2820 2829 2809 2839 2839 2839 2830 2820 2840 2859 779 779 2829 2809 2809 2819 2839 2870 2819 2829 2819 3609 2789 2840 2810 2819 2789 2820 2000 2819
Common SQL. Check correctness of the results
129
tabloid dbp 1940 20061108 2141
 SS 3249 3279 3230 3200 3259 3269 3000 3000 3240 3260 859 839 3259 3270 3260 3230 3269 3309 3290 3279 3309 3220 3259 3240 3200 3149 3269 3210 3210 3000 3259
Common SQL. Check correctness of the results
130
tabloid dbp 1940 20080912 1005
 CS 2839 2870 2840 2819 2840 2819 2839 2899 2839 2819 779 780 2899 2839 2840 2830 2840 2819 2849 2819 2840 2910 2839 2829 2819 2840 2839 2829 2789 2859
Common SQL. Check correctness of the results
131
tabloid dbp 1940 20080912 1005
 SS 3259 3259 3269 3169 3269 3259 3269 3349 3259 3209 1029 879 3309 3399 3229 3259 3000 3329 3259 3259 3279 3269 3289 3230 3230 3200 3289 3230 3230 3259 3259
Common SQL. Check correctness of the results
132
tabloid dbp 1940 20090521 1520
 CS 2820 2839 2799 2860 2859 2809 2829 2800 2809 2830 779 779 2810 2810 3269 2819 2799 2839 2840 2820 2859 2829 2820 2839 2839 2809 2809 2819 2759 2820
Common SQL. Check correctness of the results
133
tabloid dbp 1940 20090521 1520
 SS 3259 3259 3259 3180 3240 3269 3259 3230 3000 3279 860 870 3000 3329 3259 3000 3240 3290 3259 3259 3269 3310 3380 3259 3210 3000 3240 3259 3240 3259 3000
Common SQL. Check correctness of the results
134
tabloid dbp 1940 20110426 1906
 CS 2820 2850 2890 2849 2830 2820 2820 2819 2820 2809 779 779 2809 2929 2809 2829 2859 2850 2869 2809 2810 2820 2809 2800 2840 2859 2850 2810 2759 2829
Common SQL. Check correctness of the results
135
tabloid dbp 1940 20110426 1906
 SS 3259 3269 3000 3210 3259 3220 3259 3240 3240 3260 919 890 3289 3320 3000 3269 3259 3269 3240 3289 3289 3259 3309 3259 3309 3259 3230 3279 3279 3289 3240
Common SQL. Check correctness of the results
136
tabloid dbp 1940 20110725 1159
 CS 2819 2819 2819 2829 2859 2839 2809 2819 2809 2819 779 799 2819 2840 2809 2870 2900 2910 2860 2829 2819 2819 2819 2839 2869 2830 2789 2799 2000 2849
Common SQL. Check correctness of the results
137
tabloid dbp 1940 20110725 1159
 SS 3259 3000 3259 3180 3000 3259 3000 3000 3000 3259 850 839 3269 3269 3320 3230 3000 3259 3000 3259 3300 3259 3259 3329 3279 3240 3259 3240 3000 3279 3259
Common SQL. Check correctness of the results
138
tabloid dbp 1940 20130412 1008
 CS 2829 2829 2809 2850 2819 2839 2819 2829 2839 2850 920 920 2820 2809 2819 2879 2839 2879 2819 2829 2849 2839 2839 2809 3039 2839 2809 2809 2779 2840
Common SQL. Check correctness of the results
139
tabloid dbp 1940 20130412 1008
 SS 3259 3240 3240 3189 3259 3300 3230 3259 3269 3229 859 849 3240 3359 3259 3230 3339 3289 3259 3279 3289 3279 3279 3259 3240 3000 3279 3230 3210 3240 3259
Common SQL. Check correctness of the results
140
tabloid dbp 1940 20130831 2039
 CS 2820 2850 2809 2869 2830 2820 2829 2820 2799 2809 829 779 2829 2809 2870 2829 2840 2859 2809 2840 2809 2860 2830 2840 2819 2829 2809 2809 2769 2819
Common SQL. Check correctness of the results
141
tabloid dbp 1940 20130831 2039
 SS 3240 3259 3000 3160 3240 3229 3240 3260 3000 3260 860 870 3240 3240 3279 3279 3000 3230 3240 3259 3240 3269 3240 3520 3279 3240 3259 3289 3240 3290 3259
Common SQL. Check correctness of the results
142
tabloid dbp 1940 20130912 1908
 CS 3030 3039 3029 3070 3069 3049 3040 3059 3060 3029 810 779 3049 3019 3049 3020 3029 3050 3029 3029 3080 3039 3019 3009 3030 3039 3009 3039 2980 3029
Common SQL. Check correctness of the results
143
tabloid dbp 1940 20130912 1908
 SS 3460 3480 3490 3390 3460 3460 3450 3449 3460 3459 839 859 3490 3730 3430 3430 3460 3450 3439 3000 3509 3509 3450 3509 3519 3480 3480 3470 3470 3509 3480
Common SQL. Check correctness of the results
144
tabloid dbp 2146 distinct not in
 CS 2599 2589 2650 2639 2650 2589 2619 2599 2609 2650 740 0 2620 2590 2599 2589 2599 2589 2590 2670 2649 2649 2609 2609 2589 2600 2590 2660 2509 2589
Common SQL. Check correctness of the results
145
tabloid dbp 2146 distinct not in
 SS 3039 3039 3029 2959 3029 3090 3079 3019 3039 3060 829 819 3029 3230 3039 3059 3039 3039 3040 3150 3079 3049 3039 3009 3040 3029 3059 2970 3009 3059 3089
Common SQL. Check correctness of the results
146
tabloid dbp 4137 full join and windowed funcs
 CS 2679 2690 2660 2680 2729 2660 2670 2650 2660 2669 819 740 2689 2669 2720 2670 2670 2670 2679 3149 3150 3140 2759 2660 2710 2669 3119 3130 2700 2680
Common SQL. Check correctness of the results
147
tabloid dbp 4137 full join and windowed funcs
 SS 3104 3100 3100 3080 3170 3089 3100 3120 3110 3119 840 830 3090 3089 3109 3100 3150 3109 3089 3149 3120 3150 3089 3089 3109 3100 3100 3109 3109 3170 3170
Common SQL. Check correctness of the results
148
tabloid dbp 4391 full join and windowed funcs
 CS 2905 2880 2919 2889 3000 2900 2899 2910 2889 2900 740 0 2870 2850 2910 2990 2869 2889 2900 3340 3379 3369 2890 2869 2950 3010 3340 3369 2930 2980
Common SQL. Check correctness of the results
149
tabloid dbp 4391 full join and windowed funcs
 SS 3319 3329 3309 3240 3299 3329 3349 3309 3349 3309 849 839 3319 3380 3320 3349 3309 3319 3299 3320 3289 3319 3340 3400 3370 3309 3319 3309 3329 3339 3339
Common SQL. Check correctness of the results
150
tabloid dbp 4391 full join and windowed funcs2
 CS 2820 2859 2810 2820 2840 2829 2820 2819 2810 2789 0 0 2809 2839 2869 2859 2840 2820 2819 2849 2840 2930 2839 2809 2799 2809 2809 2809 2829 2809
Common SQL. Check correctness of the results
151
tabloid dbp 4391 full join and windowed funcs2
 SS 3240 3230 3230 3169 3230 3200 3259 3230 3279 3259 819 829 3279 3549 3259 3220 3240 3230 3000 3259 3259 3279 3259 3229 3240 3240 3220 3230 3259 3269 3269
Common SQL. Check correctness of the results
152
tabloid dbp 5125 windowed funcs
 CS 2650 2660 2649 2659 2710 2649 2639 2639 2649 2650 769 779 2650 2660 2660 2650 2669 2679 2660 2000 2659 2650 2650 2670 2659 2669 2629 2670 2680 2650
Common SQL. Check correctness of the results
153
tabloid dbp 5125 windowed funcs
 SS 3069 3069 3059 3050 3079 3079 3059 3059 3059 3100 830 840 3069 3100 3089 3149 3079 3070 3069 3069 3089 3120 3059 3100 3079 3109 3069 3069 3040 3109 3110
Common SQL. Check correctness of the results
154
tabloid dbp 7029 heavy test for windowed funcs
 CS 3399 3449 3400 3380 3399 3370 3370 3410 3390 3369 759 0 3399 3399 3380 3449 3410 3400 3369 3539 3570 3529 3379 3410 3440 3370 3529 3549 3399 3389
Common SQL. Check correctness of the results
155
tabloid dbp 7029 heavy test for windowed funcs
 SS 3609 3589 3620 3529 3610 3580 3640 3600 3580 3619 819 859 3590 3699 3619 3730 3580 3609 3620 3640 3630 3599 3589 3619 3629 3600 3680 3570 3599 3620 3619
Common SQL. Check correctness of the results
156
tabloid dbp 7114 windowed funcs
 CS 2640 2690 2609 2619 2650 2640 2629 2620 2649 2640 0 0 2620 2660 2699 2650 2620 2639 2630 2620 2619 2619 2620 2629 2650 2650 2680 2670 2640 2640
Common SQL. Check correctness of the results
157
tabloid dbp 7114 windowed funcs
 SS 3074 3150 3079 3009 3059 3059 3049 3069 3079 3100 879 830 3089 3090 3050 3060 3079 3069 3059 3089 3119 3119 3050 3160 3090 3069 3079 3089 3049 3049 3100
Common SQL. Check correctness of the results
158
tabloid eqc 343715
 CS 2789 3359 2809 2839 2759 2789 2789 2699 2799 2779 779 800 2800 2799 2779 2789 2700 2779 2790 2789 2810 2780 2710 2759 2769 2810 3230 2699 2769 2789
Checking PK index is used when table is joined as driven (right) source in LEFT OUTER join from VIEW
159
tabloid eqc 343715
 SS 3149 3150 3130 3139 3150 3150 3140 3150 3149 3159 879 839 3149 3000 3160 3150 3170 3090 3150 3149 3139 3219 3110 3139 3180 3150 3170 3119 3099 3160 3159
Checking PK index is used when table is joined as driven (right) source in LEFT OUTER join from VIEW
160
tabloid snd 7795 20120706 1249
 CS 2834 2860 2859 2830 2839 2899 2829 2829 2830 2820 769 0 2820 2829 2820 2840 2809 2809 2810 3299 3340 3000 2819 2900 2849 2879 3290 3289 2759 2839
Common SQL. Check correctness of the results
161
tabloid snd 7795 20120706 1249
 SS 3269 3289 3289 3310 3269 3210 3279 3299 3269 3269 839 839 3270 3259 3259 3259 3259 3230 3259 3299 3279 3289 3279 3259 3269 3279 3280 3240 3000 3289 3290
Common SQL. Check correctness of the results

List of tests in this report:


http://tracker.firebirdsql.org/browse/core-1006
http://tracker.firebirdsql.org/browse/core-1063
http://tracker.firebirdsql.org/browse/core-1331
http://tracker.firebirdsql.org/browse/core-1642
http://tracker.firebirdsql.org/browse/core-1752
http://tracker.firebirdsql.org/browse/core-2078
http://tracker.firebirdsql.org/browse/core-2233
http://tracker.firebirdsql.org/browse/core-2721
http://tracker.firebirdsql.org/browse/core-2890
http://tracker.firebirdsql.org/browse/core-3076
http://tracker.firebirdsql.org/browse/core-3210
http://tracker.firebirdsql.org/browse/core-3277
http://tracker.firebirdsql.org/browse/core-3282
http://tracker.firebirdsql.org/browse/core-3310
http://tracker.firebirdsql.org/browse/core-3435
http://tracker.firebirdsql.org/browse/core-3474
http://tracker.firebirdsql.org/browse/core-3557
http://tracker.firebirdsql.org/browse/core-3675
http://tracker.firebirdsql.org/browse/core-3697
http://tracker.firebirdsql.org/browse/core-3829
http://tracker.firebirdsql.org/browse/core-3919
http://tracker.firebirdsql.org/browse/core-3965
http://tracker.firebirdsql.org/browse/core-3966
http://tracker.firebirdsql.org/browse/core-3967
http://tracker.firebirdsql.org/browse/core-4200
http://tracker.firebirdsql.org/browse/core-4379
http://tracker.firebirdsql.org/browse/core-4417
http://tracker.firebirdsql.org/browse/core-4425
http://tracker.firebirdsql.org/browse/core-4634
http://tracker.firebirdsql.org/browse/core-4675
http://tracker.firebirdsql.org/browse/core-4798
http://tracker.firebirdsql.org/browse/core-5018
http://tracker.firebirdsql.org/browse/core-5075
http://tracker.firebirdsql.org/browse/core-5087
http://tracker.firebirdsql.org/browse/core-5295
http://tracker.firebirdsql.org/browse/core-5309
http://tracker.firebirdsql.org/browse/core-5329
http://tracker.firebirdsql.org/browse/core-6440
http://tracker.firebirdsql.org/browse/core-86
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/gtcs/gtcs-proc-isql-01.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/gtcs/gtcs-proc-isql-02.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/gtcs/gtcs-proc-isql-03.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/gtcs/gtcs-proc-isql-04.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/gtcs/gtcs-proc-isql-05.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/gtcs/gtcs-proc-isql-06.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/gtcs/gtcs-proc-isql-07.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/gtcs/gtcs-proc-isql-10.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/gtcs/gtcs-proc-isql-11.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/gtcs/gtcs-proc-isql-12.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/gtcs/gtcs-proc-isql-13.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/gtcs/gtcs-proc-isql-14.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/gtcs/gtcs-proc-isql-15.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/gtcs/gtcs-proc-isql-16.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/gtcs/gtcs-proc-isql-17.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/gtcs/gtcs-proc-isql-18.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/gtcs/gtcs-proc-isql-19.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/gtcs/gtcs-proc-isql-20.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/gtcs/gtcs-select-delete-isql.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/gtcs/sql-join-03.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/gtcs/sql-join-04.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/bus-3103-windowed-funcs.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-1697-windowed-funcs.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/dbp-1940_20040130_1740.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/dbp-1940_20061108_2141.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/dbp-1940_20080912_1005.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/dbp-1940_20090521_1520.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/dbp-1940_20110426_1906.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/dbp-1940_20110725_1159.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/dbp-1940_20130412_1008.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/dbp-1940_20130831_2039.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/dbp-1940_20130912_1908.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/dbp-4137-full-join-and-windowed-funcs.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/dbp-4391-full-join-and-windowed-funcs.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/dbp-4391-full-join-and-windowed-funcs2.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/dbp-5125-windowed-funcs.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/dbp-7029-heavy-test-for-windowed-funcs.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/dbp-7114-windowed-funcs.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/eqc-343715.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/snd-7795_20120706_1249.fbt

=== end of list ===