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