Generated 05.02.2023 03:26
Tested: FB50. Build: 5.0.0.930; SS: 05.02.23 01:32:45 - 05.02.23 02:22:45; CS: 05.02.23 02:24:27 - 05.02.23 03:24:22;
OS and hardware info: Windows 10 10.0.19041 ; logical CPUs: 8 ; total memory: 31.7 Gb
Jump to LIST of unique test names from this report
NN | Test name | mode | 5.0.0.930 2023-02-05 |
5.0.0.928 2023-02-03 |
5.0.0.923 2023-02-02 |
5.0.0.920 2023-01-28 |
5.0.0.917 2023-01-22 |
5.0.0.916 2023-01-20 |
5.0.0.915 2023-01-31 |
5.0.0.914 2023-01-18 |
5.0.0.912 2023-01-16 |
5.0.0.910 2023-01-14 |
5.0.0.908 2023-01-13 |
5.0.0.907 2023-01-12 |
5.0.0.905 2023-01-11 |
5.0.0.890 2023-01-07 |
5.0.0.888 2023-01-01 |
5.0.0.884 2022-12-24 |
5.0.0.883 2022-12-23 |
5.0.0.882 2022-12-22 |
5.0.0.879 2022-12-21 |
5.0.0.877 2022-12-17 |
5.0.0.871 2022-12-14 |
5.0.0.870 2022-12-13 |
5.0.0.869 2022-12-12 |
5.0.0.867 2022-12-11 |
5.0.0.865 2022-12-10 |
5.0.0.863 2022-12-07 |
5.0.0.862 2022-12-05 |
5.0.0.848 2022-11-29 |
5.0.0.847 2022-11-27 |
5.0.0.845 2022-11-26 |
Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | CS | P | P | P | P | P | P | X | P | P | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Subquery-based predicates are not evaluated early in the join order |
|
2 | SS | P | P | P | P | P | P | X | P | P | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Subquery-based predicates are not evaluated early in the join order |
|
3 | CS | F | F | F | F | F | F | X | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | Suboptimal join plan if there are selective non-indexed predicates involved |
|
4 | SS | F | F | F | F | F | F | X | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | Suboptimal join plan if there are selective non-indexed predicates involved |
|
5 | CS | P | P | P | P | P | P | X | P | P | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Include PLAN in mon$statements |
|
6 | SS | P | P | P | P | P | P | X | P | P | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Include PLAN in mon$statements |
|
7 | CS | P | P | P | P | P | P | X | P | P | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Improve sorting performance when long VARCHARs are involved |
|
8 | SS | P | P | P | P | P | P | X | P | P | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Improve sorting performance when long VARCHARs are involved |
|
9 | CS | P | P | P | P | P | P | X | P | P | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Regression: Predicates involving PSQL variables/parameters are not pushed inside the aggregation |
|
10 | SS | P | P | P | P | P | P | X | P | P | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Regression: Predicates involving PSQL variables/parameters are not pushed inside the aggregation |
|
11 | CS | P | P | P | P | P | P | X | P | P | F | F | F | F | 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 |
|
12 | SS | P | P | P | P | P | P | X | P | P | F | F | F | F | 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 |
|
13 | CS | P | P | P | P | P | P | X | P | P | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Positioned UPDATE statement prohibits index usage for the subsequent cursor field references |
|
14 | SS | P | P | P | P | P | P | X | P | P | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Positioned UPDATE statement prohibits index usage for the subsequent cursor field references |
|
15 | CS | F | F | F | F | F | F | X | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | Allow hash/merge joins for non-field (dbkey or derived expression) equalities |
|
16 | SS | F | F | F | F | F | F | X | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | Allow hash/merge joins for non-field (dbkey or derived expression) equalities |
|
17 | CS | P | P | P | P | P | P | X | P | P | P | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Prohibit an ability to issue DML or DDL statements on RDB$ tables |
|
18 | SS | P | P | P | P | P | P | X | P | P | P | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Prohibit an ability to issue DML or DDL statements on RDB$ tables |
|
19 | CS | P | P | P | P | P | P | X | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | ISQL plan output is unexpectedly truncated after a query is simplified to become shorter |
|
20 | SS | P | P | P | P | P | P | X | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | ISQL plan output is unexpectedly truncated after a query is simplified to become shorter |
|
21 | CS | F | F | F | F | F | F | X | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins |
|
22 | SS | F | F | F | F | F | F | X | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins |
|
23 | CS | P | P | P | P | P | P | X | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Badly selective index could be used for extra filtering even if selective index is used for sorting |
|
24 | CS | P | P | P | P | P | P | X | P | P | P | P | P | P | P | P | P | P | P | F | F | P | P | P | P | P | P | P | P | P | P | Slow performance when executing SQL scripts as non-SYSDBA user [CORE5966] |
|
25 | CS | P | P | P | P | P | P | X | P | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Inconsistent cursor-driven deletion |
|
26 | SS | P | P | P | P | P | P | X | P | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Inconsistent cursor-driven deletion |
|
27 | CS | P | P | P | P | P | P | X | P | P | P | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | MON$ATTACHMENTS.MON$TIMESTAMP is incorrect when DefaultTimeZone is configured with time zone different from the server's default |
|
28 | SS | P | P | P | P | P | P | X | P | P | P | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | MON$ATTACHMENTS.MON$TIMESTAMP is incorrect when DefaultTimeZone is configured with time zone different from the server's default |
|
29 | CS | P | P | P | P | P | P | X | P | P | P | P | P | P | P | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired |
|
30 | SS | P | P | P | P | P | P | X | P | P | P | P | P | P | P | P | F | P | P | P | P | P | P | P | P | P | P | F | P | P | P | When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired |
|
31 | CS | P | P | P | P | P | P | X | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | P | Indexed STARTING WITH execution is very slow with UNICODE collation |
|
32 | SS | P | P | P | P | P | P | X | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | Indexed STARTING WITH execution is very slow with UNICODE collation |
|
33 | CS | F | F | F | F | F | F | X | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
|
34 | SS | F | F | F | F | F | F | X | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
|
35 | CS | F | F | F | F | F | F | X | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
|
36 | SS | F | F | F | F | F | F | X | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
|
37 | CS | F | F | F | F | F | F | X | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
|
38 | SS | F | F | F | F | F | F | X | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
|
39 | CS | F | F | F | F | F | F | X | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | INNER JOIN join order LIKE and STARTING WITH |
|
40 | SS | F | F | F | F | F | F | X | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | INNER JOIN join order LIKE and STARTING WITH |
|
41 | CS | F | F | F | F | F | F | X | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | LEFT OUTER JOIN with full match and reference in WHERE clause |
|
42 | SS | F | F | F | F | F | F | X | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | LEFT OUTER JOIN with full match and reference in WHERE clause |
|
43 | CS | F | F | F | F | F | F | X | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | LEFT OUTER JOIN with full match, but limited in ON clause |
|
44 | SS | F | F | F | F | F | F | X | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | LEFT OUTER JOIN with full match, but limited in ON clause |
|
45 | CS | F | F | F | F | F | F | X | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | LEFT OUTER JOIN with STARTING WITH in WHERE clause |
|
46 | SS | F | F | F | F | F | F | X | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | LEFT OUTER JOIN with STARTING WITH in WHERE clause |
|
47 | CS | F | F | F | F | F | F | X | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | Mixed JOINS |
|
48 | SS | F | F | F | F | F | F | X | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | Mixed JOINS |
|
49 | CS | S | S | S | S | S | S | X | S | P | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | Empty DB - RDB$FIELDS |
|
50 | SS | S | S | S | S | S | S | X | S | P | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | Empty DB - RDB$FIELDS |
|
51 | CS | S | S | S | S | S | S | X | S | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Empty DB - RDB$FORMATS |
|
52 | SS | S | S | S | S | S | S | X | S | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Empty DB - RDB$FORMATS |
|
53 | CS | S | S | S | S | S | S | X | S | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | New DB - RDB$FUNCTION_ARGUMENTS |
|
54 | SS | S | S | S | S | S | S | X | S | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | New DB - RDB$FUNCTION_ARGUMENTS |
|
55 | CS | S | S | S | S | S | S | X | S | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | New DB - RDB$FUNCTIONS |
|
56 | SS | S | S | S | S | S | S | X | S | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | New DB - RDB$FUNCTIONS |
|
57 | CS | S | S | S | S | S | S | X | S | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | New DB - RDB$PROCEDURE_PARAMETERS |
|
58 | SS | S | S | S | S | S | S | X | S | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | New DB - RDB$PROCEDURE_PARAMETERS |
|
59 | CS | S | S | S | S | S | S | X | S | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | New database: content of RDB$PROCEDURES |
|
60 | SS | S | S | S | S | S | S | X | S | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | New database: content of RDB$PROCEDURES |
|
61 | CS | S | S | S | S | S | S | X | S | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Empty DB - RDB$RELATIONS |
|
62 | SS | S | S | S | S | S | S | X | S | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Empty DB - RDB$RELATIONS |
|
63 | CS | S | S | S | S | S | S | X | S | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | Empty DB - RDB$SECURITY_CLASSES |
|
64 | SS | S | S | S | S | S | S | X | S | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | Empty DB - RDB$SECURITY_CLASSES |
|
65 | CS | S | S | S | S | S | S | X | S | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | Empty DB - RDB$USER_PRIVILEGES |
|
66 | SS | S | S | S | S | S | S | X | S | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | Empty DB - RDB$USER_PRIVILEGES |
|
67 | CS | P | P | P | P | P | P | X | P | P | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | ISQL - SHOW SYSTEM TABLES |
|
68 | SS | P | P | P | P | P | P | X | P | P | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | ISQL - SHOW SYSTEM TABLES |
|
69 | CS | P | P | P | P | P | P | X | P | P | P | P | P | P | P | F | P | P | P | F | F | P | P | P | F | F | P | P | F | F | F | Error "BLOB is not found" while replication converts INSERT into UPDATE for a conflicting record |
|
70 | SS | P | P | P | P | P | P | X | P | P | P | P | P | P | P | F | P | P | P | F | F | P | P | P | F | F | P | P | F | F | F | Error "BLOB is not found" while replication converts INSERT into UPDATE for a conflicting record |
|
71 | CS | P | P | P | P | P | P | X | P | P | P | P | P | P | P | F | P | P | P | F | F | P | P | P | F | F | P | P | F | F | F | Problem with replication of BLOB segments longer than 32KB |
|
72 | SS | P | P | P | P | P | P | X | P | P | P | P | P | P | P | F | P | P | P | F | F | P | P | P | F | F | P | P | F | F | F | Problem with replication of BLOB segments longer than 32KB |
|
73 | CS | P | P | P | P | P | P | X | P | P | P | P | P | P | P | F | P | P | P | F | F | P | P | P | F | F | P | P | F | F | F | Replica DB must not fire DB-level triggers but their activity on master must be eventually seen in replica. |
|
74 | SS | P | P | P | P | P | P | X | P | P | P | P | P | P | P | F | P | P | P | F | F | P | P | P | F | F | P | P | F | F | F | Replica DB must not fire DB-level triggers but their activity on master must be eventually seen in replica. |
|
75 | CS | P | P | P | P | P | P | X | P | P | P | P | P | P | P | F | P | P | P | F | F | P | P | P | F | F | P | P | F | F | F | DDL-triggers must fire only on master DB. |
|
76 | SS | P | P | P | P | P | P | X | P | P | P | P | P | P | P | F | P | P | P | F | F | P | P | P | F | F | P | P | F | F | F | DDL-triggers must fire only on master DB. |
|
77 | CS | P | P | P | P | P | P | X | P | P | P | P | P | P | P | F | P | P | P | F | F | P | P | P | F | F | P | P | F | F | F | Conflicting INSERT propagated into a read-write replica may cause duplicate records to appear |
|
78 | SS | P | P | P | P | P | P | X | P | P | P | P | P | P | P | F | P | P | P | F | F | P | P | P | F | F | P | P | F | F | F | Conflicting INSERT propagated into a read-write replica may cause duplicate records to appear |
|
79 | CS | P | P | P | P | P | P | X | P | P | P | P | P | P | P | F | P | P | P | F | F | P | P | P | F | F | P | P | F | F | F | Failed DDL commands can be replicated |
|
80 | SS | P | P | P | P | P | P | X | P | P | P | P | P | P | P | F | P | P | P | F | F | P | P | P | F | F | P | P | F | F | F | Failed DDL commands can be replicated |
|
81 | CS | P | P | P | P | P | P | X | P | P | P | P | P | P | P | F | P | P | P | F | F | P | P | P | F | F | P | P | F | F | F | Generator values may not replicate after commit |
|
82 | SS | P | P | P | P | P | P | X | P | P | P | P | P | P | P | F | P | P | P | F | F | P | P | P | F | F | P | P | F | F | F | Generator values may not replicate after commit |
|
83 | CS | P | P | P | P | P | P | X | P | P | P | P | P | P | P | F | P | P | P | F | F | P | P | P | F | F | P | P | F | F | F | Invalid message in replication.log (and possibly crash in the case of synchronous replication) when the target DB has no its "replica" flag set |
|
84 | SS | P | P | P | P | P | P | X | P | P | P | P | P | P | P | F | P | P | P | F | F | P | P | P | F | F | P | P | F | F | F | Invalid message in replication.log (and possibly crash in the case of synchronous replication) when the target DB has no its "replica" flag set |
|
85 | CS | P | P | P | P | P | P | X | P | P | P | P | P | P | P | F | P | P | P | F | F | P | P | P | F | F | P | P | F | F | F | Permission error with replication |
|
86 | SS | P | P | P | P | P | P | X | P | P | P | P | P | P | P | F | P | P | P | F | F | P | P | P | F | F | P | P | F | F | F | Permission error with replication |
|
87 | CS | P | P | P | P | P | P | X | P | P | P | P | P | P | P | F | P | P | P | F | F | P | P | P | F | F | P | P | F | F | F | Crash or hang while shutting down the replica database if segments are being applied |
|
88 | SS | P | P | P | P | P | P | X | P | P | P | P | P | P | P | F | P | P | P | F | F | P | P | P | F | F | P | P | F | F | F | Crash or hang while shutting down the replica database if segments are being applied |
|
89 | CS | P | P | P | P | P | P | X | P | P | P | P | P | P | P | F | P | P | P | F | F | P | P | P | F | F | P | P | F | F | F | Some updates can crash Firebird server on replica side |
|
90 | SS | P | P | P | P | P | P | X | P | P | P | P | P | P | P | F | P | P | P | F | F | P | P | P | F | F | P | P | F | F | F | Some updates can crash Firebird server on replica side |
|
91 | CS | P | P | P | F | P | P | X | P | F | P | P | P | P | P | F | P | P | P | F | F | P | F | P | F | F | P | P | F | F | F | Replication gets stuck due to "Blob xxx.xx is not found for table xxx" error |
|
92 | SS | P | P | P | P | P | P | X | P | P | P | P | P | P | P | F | P | P | P | F | F | P | P | P | F | F | P | P | F | F | F | Replication gets stuck due to "Blob xxx.xx is not found for table xxx" error |
NN | Test name | mode | median_ms | 5.0.0.930 2023-02-05 |
5.0.0.928 2023-02-03 |
5.0.0.923 2023-02-02 |
5.0.0.920 2023-01-28 |
5.0.0.917 2023-01-22 |
5.0.0.916 2023-01-20 |
5.0.0.915 2023-01-31 |
5.0.0.914 2023-01-18 |
5.0.0.912 2023-01-16 |
5.0.0.910 2023-01-14 |
5.0.0.908 2023-01-13 |
5.0.0.907 2023-01-12 |
5.0.0.905 2023-01-11 |
5.0.0.890 2023-01-07 |
5.0.0.888 2023-01-01 |
5.0.0.884 2022-12-24 |
5.0.0.883 2022-12-23 |
5.0.0.882 2022-12-22 |
5.0.0.879 2022-12-21 |
5.0.0.877 2022-12-17 |
5.0.0.871 2022-12-14 |
5.0.0.870 2022-12-13 |
5.0.0.869 2022-12-12 |
5.0.0.867 2022-12-11 |
5.0.0.865 2022-12-10 |
5.0.0.863 2022-12-07 |
5.0.0.862 2022-12-05 |
5.0.0.848 2022-11-29 |
5.0.0.847 2022-11-27 |
5.0.0.845 2022-11-26 |
Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | CS | 630 | 660 | 620 | 650 | 620 | 620 | 610 | 670 | 610 | 630 | 700 | 620 | 630 | 680 | 680 | 610 | 600 | 610 | 690 | 610 | 610 | 640 | 620 | 670 | 630 | 610 | 590 | 650 | 630 | 650 | Subquery-based predicates are not evaluated early in the join order |
||
2 | SS | 440 | 460 | 450 | 460 | 430 | 430 | 620 | 430 | 430 | 450 | 440 | 460 | 450 | 800 | 450 | 760 | 610 | 430 | 440 | 440 | 440 | 440 | 870 | 430 | 450 | 430 | 430 | 430 | 450 | 440 | Subquery-based predicates are not evaluated early in the join order |
||
3 | CS | 1350 | 1360 | 1360 | 1380 | 1360 | 1340 | 1330 | 1400 | 1350 | 1350 | 1390 | 1380 | 1370 | 1370 | 1360 | 1280 | 1340 | 1320 | 1340 | 1390 | 1410 | 1310 | 1400 | 1310 | 1450 | 1330 | 1280 | 1330 | 1330 | 1320 | Suboptimal join plan if there are selective non-indexed predicates involved |
||
4 | SS | 1010 | 1080 | 1020 | 1000 | 990 | 1000 | 1010 | 990 | 1010 | 1020 | 1010 | 1000 | 1030 | 990 | 1000 | 1020 | 1040 | 1020 | 1000 | 1040 | 990 | 1080 | 1070 | 1010 | 1010 | 990 | 970 | 1000 | 990 | 990 | Suboptimal join plan if there are selective non-indexed predicates involved |
||
5 | CS | 855 | 850 | 880 | 860 | 840 | 840 | 860 | 850 | 860 | 870 | 840 | 840 | 870 | 830 | 820 | 0 | 830 | 900 | 860 | 930 | 870 | 840 | 860 | 860 | 860 | 830 | 800 | 820 | 870 | 850 | Include PLAN in mon$statements |
||
6 | SS | 580 | 600 | 580 | 580 | 570 | 580 | 590 | 570 | 580 | 590 | 600 | 590 | 590 | 570 | 590 | 580 | 600 | 580 | 600 | 600 | 580 | 570 | 620 | 580 | 600 | 560 | 560 | 570 | 580 | 570 | Include PLAN in mon$statements |
||
7 | CS | 950 | 950 | 980 | 950 | 930 | 930 | 920 | 980 | 990 | 960 | 1000 | 1010 | 970 | 990 | 920 | 870 | 940 | 950 | 1040 | 940 | 930 | 930 | 1010 | 1000 | 940 | 990 | 840 | 910 | 980 | 940 | Improve sorting performance when long VARCHARs are involved |
||
8 | SS | 660 | 650 | 660 | 650 | 650 | 640 | 690 | 680 | 650 | 680 | 660 | 670 | 660 | 650 | 680 | 660 | 660 | 660 | 690 | 680 | 680 | 640 | 660 | 680 | 680 | 670 | 640 | 650 | 650 | 640 | Improve sorting performance when long VARCHARs are involved |
||
9 | CS | 900 | 950 | 880 | 930 | 880 | 890 | 880 | 870 | 910 | 890 | 890 | 910 | 900 | 900 | 920 | 790 | 960 | 940 | 940 | 940 | 930 | 940 | 920 | 880 | 870 | 880 | 820 | 910 | 850 | 850 | Regression: Predicates involving PSQL variables/parameters are not pushed inside the aggregation |
||
10 | SS | 630 | 620 | 640 | 620 | 650 | 630 | 600 | 610 | 630 | 620 | 630 | 630 | 640 | 620 | 610 | 640 | 640 | 670 | 640 | 710 | 600 | 630 | 630 | 610 | 640 | 620 | 610 | 600 | 620 | 610 | Regression: Predicates involving PSQL variables/parameters are not pushed inside the aggregation |
||
11 | CS | 1990 | 2020 | 2100 | 2000 | 2040 | 1970 | 1940 | 1960 | 1950 | 2020 | 2050 | 2060 | 1970 | 2020 | 2030 | 1830 | 2200 | 2050 | 2060 | 1990 | 2040 | 1920 | 2000 | 1930 | 1960 | 1950 | 1830 | 1960 | 1910 | 1900 | Poor performance of explicit cursors containing correlated subqueries in the select list |
||
12 | SS | 1630 | 1610 | 1650 | 1640 | 1620 | 1630 | 1630 | 1650 | 1620 | 1650 | 1640 | 1660 | 1650 | 1620 | 1600 | 1650 | 1650 | 1630 | 1650 | 1640 | 1720 | 1620 | 1630 | 1600 | 1640 | 1680 | 1560 | 1600 | 1630 | 1600 | Poor performance of explicit cursors containing correlated subqueries in the select list |
||
13 | CS | 870 | 890 | 900 | 900 | 870 | 920 | 860 | 910 | 850 | 880 | 860 | 890 | 870 | 890 | 850 | 780 | 860 | 870 | 880 | 870 | 860 | 910 | 860 | 860 | 850 | 850 | 830 | 860 | 870 | 860 | Positioned UPDATE statement prohibits index usage for the subsequent cursor field references |
||
14 | SS | 620 | 620 | 620 | 600 | 600 | 610 | 600 | 600 | 630 | 640 | 640 | 620 | 620 | 610 | 600 | 620 | 620 | 620 | 620 | 620 | 600 | 600 | 630 | 590 | 630 | 610 | 570 | 610 | 620 | 600 | Positioned UPDATE statement prohibits index usage for the subsequent cursor field references |
||
15 | CS | 880 | 870 | 910 | 900 | 840 | 830 | 920 | 840 | 870 | 960 | 1220 | 880 | 900 | 900 | 940 | 1130 | 1280 | 880 | 850 | 880 | 840 | 930 | 880 | 900 | 870 | 830 | 780 | 1220 | 860 | 900 | Allow hash/merge joins for non-field (dbkey or derived expression) equalities |
||
16 | SS | 600 | 610 | 590 | 580 | 600 | 600 | 600 | 610 | 620 | 630 | 610 | 630 | 610 | 580 | 600 | 590 | 610 | 620 | 600 | 650 | 620 | 600 | 620 | 600 | 620 | 580 | 560 | 610 | 600 | 580 | Allow hash/merge joins for non-field (dbkey or derived expression) equalities |
||
17 | CS | 8870 | 9590 | 8970 | 8920 | 9060 | 9030 | 8740 | 8990 | 9120 | 9020 | 2480 | 2600 | 2420 | 8890 | 8000 | 8580 | 8940 | 9040 | 8850 | 8920 | 9010 | 8810 | 8840 | 8920 | 8770 | 8870 | 8630 | 8840 | 8770 | 8810 | Prohibit an ability to issue DML or DDL statements on RDB$ tables |
||
18 | SS | 5430 | 5450 | 5550 | 5480 | 5340 | 5330 | 5620 | 5330 | 5510 | 5830 | 1590 | 1620 | 1600 | 5400 | 5320 | 5320 | 5520 | 5700 | 5560 | 5490 | 5550 | 5910 | 5900 | 5340 | 5520 | 5000 | 5300 | 5000 | 5430 | 5410 | Prohibit an ability to issue DML or DDL statements on RDB$ tables |
||
19 | CS | 1710 | 1740 | 1710 | 1730 | 1720 | 1710 | 1680 | 1720 | 1710 | 1710 | 1720 | 1800 | 1800 | 1700 | 1710 | 1650 | 1720 | 1700 | 1710 | 1710 | 1710 | 1690 | 1720 | 1710 | 1710 | 1690 | 1670 | 1730 | 1700 | 1710 | ISQL plan output is unexpectedly truncated after a query is simplified to become shorter |
||
20 | SS | 1470 | 1470 | 1470 | 1480 | 1940 | 1460 | 1430 | 1460 | 1460 | 1620 | 1480 | 1000 | 1480 | 1460 | 1490 | 1440 | 1000 | 1840 | 2010 | 1920 | 1450 | 1460 | 1470 | 1490 | 1460 | 1790 | 1860 | 1460 | 1460 | 1450 | ISQL plan output is unexpectedly truncated after a query is simplified to become shorter |
||
21 | CS | 900 | 890 | 1000 | 980 | 880 | 920 | 850 | 870 | 930 | 920 | 880 | 880 | 950 | 900 | 850 | 830 | 970 | 920 | 890 | 960 | 1240 | 860 | 900 | 880 | 990 | 930 | 850 | 890 | 900 | 900 | IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins |
||
22 | SS | 630 | 620 | 650 | 680 | 670 | 980 | 640 | 630 | 620 | 1000 | 660 | 650 | 640 | 630 | 630 | 630 | 640 | 660 | 640 | 630 | 610 | 610 | 650 | 610 | 630 | 630 | 610 | 620 | 610 | 620 | IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins |
||
23 | CS | 5650 | 5700 | 5650 | 5790 | 5690 | 5640 | 5620 | 5690 | 5620 | 5610 | 5640 | 6110 | 5740 | 5890 | 5640 | 5000 | 5720 | 5650 | 5660 | 5740 | 5620 | 5630 | 5730 | 5840 | 5680 | 5610 | 5550 | 5650 | 5910 | 5640 | Badly selective index could be used for extra filtering even if selective index is used for sorting |
||
24 | CS | 13840 | 13720 | 14200 | 14420 | 13890 | 13000 | 13740 | 13840 | 14190 | 13730 | 13960 | 13820 | 13780 | 13960 | 13580 | 14020 | 14130 | 14260 | 13870 | 14390 | 13820 | 13830 | 13770 | 13890 | 13840 | 14240 | 13780 | 13720 | 13790 | 14290 | Slow performance when executing SQL scripts as non-SYSDBA user [CORE5966] |
||
25 | CS | 630 | 630 | 620 | 680 | 650 | 630 | 620 | 630 | 660 | 680 | 630 | 640 | 620 | 660 | 680 | 610 | 630 | 610 | 620 | 640 | 700 | 680 | 610 | 630 | 640 | 670 | 590 | 600 | 600 | 610 | Inconsistent cursor-driven deletion |
||
26 | SS | 440 | 430 | 470 | 470 | 420 | 430 | 430 | 430 | 440 | 460 | 450 | 430 | 470 | 440 | 430 | 410 | 470 | 450 | 460 | 440 | 430 | 430 | 460 | 450 | 440 | 440 | 400 | 440 | 430 | 430 | Inconsistent cursor-driven deletion |
||
27 | CS | 1710 | 1710 | 1740 | 1710 | 1720 | 1690 | 1740 | 1720 | 1710 | 1710 | 1710 | 1700 | 1710 | 1730 | 2120 | 1670 | 1710 | 1720 | 1720 | 2230 | 1740 | 1710 | 1700 | 1720 | 1000 | 1720 | 1660 | 1710 | 1700 | 1690 | MON$ATTACHMENTS.MON$TIMESTAMP is incorrect when DefaultTimeZone is configured with time zone different from the server's default |
||
28 | SS | 1460 | 1460 | 1480 | 1490 | 1460 | 1440 | 1440 | 1460 | 1460 | 1460 | 1480 | 1470 | 1480 | 1450 | 1440 | 1410 | 1470 | 1470 | 1470 | 1460 | 1460 | 1510 | 1490 | 1490 | 1450 | 1470 | 1410 | 1440 | 1440 | 1460 | MON$ATTACHMENTS.MON$TIMESTAMP is incorrect when DefaultTimeZone is configured with time zone different from the server's default |
||
29 | CS | 4650 | 4630 | 4690 | 4650 | 4620 | 4640 | 4650 | 4620 | 4610 | 4670 | 4680 | 4620 | 4680 | 4700 | 4690 | 4590 | 4680 | 4620 | 4620 | 4650 | 4670 | 4600 | 4620 | 4700 | 4610 | 4680 | 4600 | 4680 | 4600 | 4660 | When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired |
||
30 | SS | 4440 | 4440 | 4470 | 4460 | 4450 | 4440 | 4430 | 4440 | 4450 | 4470 | 4450 | 4430 | 4440 | 4440 | 4440 | 4420 | 4440 | 4450 | 4450 | 4450 | 4440 | 4490 | 4450 | 4440 | 4440 | 4440 | 4420 | 4450 | 4430 | 4440 | When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired |
||
31 | CS | 7840 | 7720 | 7990 | 8060 | 7740 | 7670 | 7610 | 7910 | 7690 | 7650 | 7700 | 8180 | 7930 | 7990 | 7840 | 7540 | 7920 | 7900 | 7780 | 7840 | 7860 | 7840 | 7740 | 7000 | 7830 | 7840 | 7670 | 7970 | 8000 | 8430 | Indexed STARTING WITH execution is very slow with UNICODE collation |
||
32 | SS | 7580 | 7390 | 7820 | 7910 | 7580 | 7000 | 7490 | 8240 | 7520 | 7470 | 7730 | 7640 | 7470 | 7620 | 7710 | 7450 | 7000 | 7600 | 7570 | 7000 | 7620 | 8950 | 7580 | 7520 | 7540 | 7700 | 7480 | 7530 | 7910 | 7980 | Indexed STARTING WITH execution is very slow with UNICODE collation |
||
33 | CS | 1800 | 1800 | 2000 | 1840 | 1810 | 1820 | 1780 | 1770 | 1770 | 1840 | 1790 | 1770 | 1780 | 1840 | 1880 | 1770 | 1820 | 1830 | 1790 | 2560 | 1790 | 1810 | 1810 | 1930 | 1800 | 1770 | 1000 | 1790 | 1950 | 1790 | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
||
34 | SS | 1550 | 1640 | 1660 | 1540 | 1540 | 1530 | 1540 | 1640 | 1540 | 1560 | 1550 | 1530 | 1730 | 1780 | 1540 | 1520 | 1540 | 1550 | 1560 | 1560 | 1530 | 1000 | 2100 | 1980 | 1560 | 1530 | 1510 | 1550 | 1530 | 1560 | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
||
35 | CS | 1790 | 1800 | 2170 | 1830 | 1760 | 1780 | 1770 | 1900 | 1780 | 1790 | 1780 | 1800 | 1780 | 1800 | 1830 | 1000 | 1880 | 1780 | 1810 | 1830 | 1780 | 1790 | 1830 | 1800 | 1780 | 1800 | 1000 | 1790 | 1770 | 1780 | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
||
36 | SS | 1550 | 1550 | 1740 | 1530 | 1630 | 1530 | 1520 | 1640 | 1670 | 1550 | 1550 | 1550 | 1550 | 1520 | 1520 | 1530 | 1560 | 1540 | 1560 | 1580 | 1640 | 1000 | 2080 | 1560 | 1560 | 1540 | 1520 | 1540 | 1530 | 1570 | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
||
37 | CS | 1790 | 2170 | 2190 | 1780 | 1760 | 1770 | 1780 | 1780 | 1820 | 1800 | 1790 | 1780 | 1780 | 1780 | 1810 | 1730 | 1820 | 1770 | 1770 | 2290 | 1830 | 1780 | 1810 | 2360 | 1880 | 1790 | 1920 | 1790 | 1780 | 1000 | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
||
38 | SS | 1550 | 1550 | 1560 | 1550 | 1520 | 1560 | 1520 | 1780 | 1540 | 1540 | 1550 | 1540 | 1550 | 1520 | 1550 | 1520 | 1560 | 1560 | 1570 | 1560 | 1530 | 1000 | 2130 | 1620 | 1550 | 1540 | 1510 | 1550 | 1740 | 2050 | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
||
39 | CS | 950 | 990 | 960 | 1090 | 980 | 960 | 950 | 950 | 930 | 890 | 930 | 920 | 990 | 910 | 1000 | 890 | 980 | 1010 | 930 | 980 | 940 | 940 | 950 | 950 | 930 | 950 | 840 | 950 | 900 | 960 | INNER JOIN join order LIKE and STARTING WITH |
||
40 | SS | 680 | 700 | 690 | 700 | 650 | 680 | 650 | 670 | 680 | 680 | 690 | 680 | 790 | 670 | 650 | 640 | 690 | 690 | 690 | 700 | 660 | 660 | 700 | 660 | 690 | 680 | 640 | 680 | 680 | 690 | INNER JOIN join order LIKE and STARTING WITH |
||
41 | CS | 880 | 930 | 890 | 890 | 890 | 930 | 860 | 890 | 900 | 860 | 940 | 910 | 860 | 960 | 930 | 770 | 910 | 850 | 840 | 870 | 950 | 870 | 870 | 880 | 870 | 830 | 760 | 870 | 840 | 930 | LEFT OUTER JOIN with full match and reference in WHERE clause |
||
42 | SS | 620 | 630 | 630 | 620 | 600 | 620 | 610 | 590 | 590 | 630 | 660 | 630 | 630 | 620 | 590 | 610 | 640 | 620 | 650 | 640 | 600 | 620 | 630 | 600 | 630 | 630 | 600 | 650 | 620 | 630 | LEFT OUTER JOIN with full match and reference in WHERE clause |
||
43 | CS | 890 | 970 | 890 | 890 | 840 | 890 | 930 | 910 | 880 | 940 | 900 | 860 | 860 | 930 | 860 | 820 | 880 | 880 | 860 | 960 | 940 | 860 | 970 | 990 | 900 | 890 | 810 | 940 | 900 | 860 | LEFT OUTER JOIN with full match, but limited in ON clause |
||
44 | SS | 620 | 630 | 630 | 620 | 590 | 620 | 600 | 590 | 610 | 620 | 710 | 640 | 640 | 630 | 620 | 600 | 620 | 630 | 670 | 620 | 600 | 600 | 630 | 600 | 630 | 610 | 590 | 650 | 600 | 640 | LEFT OUTER JOIN with full match, but limited in ON clause |
||
45 | CS | 890 | 890 | 930 | 870 | 900 | 850 | 920 | 920 | 890 | 910 | 890 | 860 | 890 | 910 | 920 | 780 | 940 | 960 | 880 | 910 | 920 | 860 | 880 | 890 | 880 | 860 | 840 | 880 | 880 | 880 | LEFT OUTER JOIN with STARTING WITH in WHERE clause |
||
46 | SS | 620 | 630 | 640 | 620 | 620 | 610 | 600 | 590 | 620 | 640 | 640 | 640 | 640 | 620 | 600 | 610 | 630 | 640 | 630 | 640 | 620 | 600 | 630 | 610 | 630 | 610 | 600 | 630 | 610 | 640 | LEFT OUTER JOIN with STARTING WITH in WHERE clause |
||
47 | CS | 900 | 1010 | 890 | 980 | 910 | 880 | 930 | 910 | 890 | 890 | 910 | 890 | 900 | 890 | 920 | 820 | 890 | 920 | 900 | 1000 | 940 | 960 | 900 | 900 | 880 | 920 | 870 | 900 | 880 | 900 | Mixed JOINS |
||
48 | SS | 650 | 660 | 660 | 640 | 640 | 650 | 640 | 700 | 650 | 660 | 670 | 640 | 660 | 650 | 650 | 630 | 670 | 650 | 660 | 680 | 640 | 650 | 650 | 660 | 720 | 650 | 630 | 660 | 660 | 670 | Mixed JOINS |
||
49 | CS | 700 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 690 | 700 | 700 | 700 | 740 | 790 | 700 | 670 | 720 | 710 | 720 | 700 | 0 | 690 | 700 | 710 | 700 | 700 | 680 | 680 | 670 | 680 | Empty DB - RDB$FIELDS |
||
50 | SS | 490 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 480 | 490 | 0 | 510 | 0 | 0 | 0 | 460 | 510 | 510 | 510 | 490 | 490 | 480 | 490 | 480 | 0 | 490 | 450 | 470 | 480 | 490 | Empty DB - RDB$FIELDS |
||
51 | CS | 595 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 580 | 580 | 600 | 640 | 650 | 640 | 620 | 580 | 590 | 580 | 630 | 590 | 680 | 600 | 580 | 600 | 590 | 600 | 560 | 620 | 580 | 570 | Empty DB - RDB$FORMATS |
||
52 | SS | 420 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 420 | 430 | 420 | 430 | 430 | 420 | 410 | 400 | 420 | 420 | 440 | 420 | 400 | 420 | 410 | 420 | 430 | 410 | 390 | 410 | 410 | 0 | Empty DB - RDB$FORMATS |
||
53 | CS | 585 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 600 | 580 | 590 | 590 | 600 | 670 | 580 | 580 | 580 | 610 | 640 | 590 | 660 | 580 | 580 | 610 | 570 | 580 | 560 | 590 | 580 | 580 | New DB - RDB$FUNCTION_ARGUMENTS |
||
54 | SS | 420 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 410 | 420 | 430 | 430 | 420 | 420 | 420 | 410 | 450 | 430 | 460 | 420 | 410 | 430 | 430 | 430 | 430 | 420 | 390 | 410 | 420 | 420 | New DB - RDB$FUNCTION_ARGUMENTS |
||
55 | CS | 590 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 600 | 620 | 590 | 580 | 600 | 590 | 590 | 570 | 600 | 630 | 600 | 580 | 640 | 590 | 580 | 650 | 830 | 600 | 560 | 580 | 580 | 580 | New DB - RDB$FUNCTIONS |
||
56 | SS | 420 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 400 | 420 | 420 | 420 | 420 | 420 | 410 | 410 | 430 | 420 | 440 | 420 | 410 | 420 | 430 | 410 | 430 | 420 | 390 | 410 | 400 | 440 | New DB - RDB$FUNCTIONS |
||
57 | CS | 600 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 600 | 610 | 690 | 580 | 620 | 580 | 610 | 580 | 640 | 610 | 600 | 600 | 580 | 620 | 590 | 620 | 580 | 600 | 580 | 590 | 580 | 580 | New DB - RDB$PROCEDURE_PARAMETERS |
||
58 | SS | 430 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 430 | 450 | 430 | 430 | 430 | 420 | 430 | 400 | 440 | 440 | 440 | 430 | 410 | 410 | 430 | 420 | 430 | 450 | 410 | 430 | 420 | 440 | New DB - RDB$PROCEDURE_PARAMETERS |
||
59 | CS | 590 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 580 | 650 | 690 | 580 | 650 | 630 | 580 | 560 | 640 | 590 | 630 | 650 | 590 | 590 | 620 | 610 | 580 | 580 | 560 | 570 | 580 | 580 | New database: content of RDB$PROCEDURES |
||
60 | SS | 425 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 430 | 460 | 440 | 440 | 420 | 420 | 410 | 430 | 440 | 430 | 440 | 420 | 410 | 420 | 420 | 430 | 440 | 420 | 400 | 430 | 400 | 420 | New database: content of RDB$PROCEDURES |
||
61 | CS | 605 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 660 | 620 | 690 | 670 | 660 | 670 | 590 | 600 | 590 | 610 | 700 | 670 | 640 | 580 | 600 | 600 | 590 | 640 | 570 | 590 | 580 | 590 | Empty DB - RDB$RELATIONS |
||
62 | SS | 440 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 430 | 430 | 440 | 440 | 450 | 450 | 440 | 400 | 450 | 450 | 440 | 440 | 420 | 430 | 430 | 430 | 450 | 430 | 400 | 460 | 430 | 440 | Empty DB - RDB$RELATIONS |
||
63 | CS | 780 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4370 | 4340 | 4360 | 4370 | 4330 | 780 | 830 | 800 | 780 | 800 | 880 | 820 | 760 | 700 | 740 | 730 | 0 | 710 | 650 | 710 | 710 | 720 | Empty DB - RDB$SECURITY_CLASSES |
||
64 | SS | 575 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4140 | 4130 | 4140 | 4560 | 4110 | 580 | 560 | 550 | 640 | 570 | 570 | 600 | 510 | 0 | 0 | 0 | 0 | 510 | 490 | 550 | 0 | 0 | Empty DB - RDB$SECURITY_CLASSES |
||
65 | CS | 770 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 820 | 820 | 810 | 810 | 830 | 770 | 780 | 740 | 0 | 0 | 760 | 760 | 0 | 0 | 0 | 780 | 830 | 730 | 700 | 730 | 740 | 730 | Empty DB - RDB$USER_PRIVILEGES |
||
66 | SS | 550 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 590 | 600 | 620 | 610 | 600 | 530 | 530 | 520 | 580 | 550 | 590 | 560 | 560 | 520 | 540 | 530 | 540 | 570 | 510 | 550 | 520 | 510 | Empty DB - RDB$USER_PRIVILEGES |
||
67 | CS | 600 | 600 | 590 | 610 | 580 | 580 | 580 | 600 | 640 | 580 | 580 | 580 | 590 | 600 | 590 | 560 | 640 | 640 | 630 | 600 | 650 | 640 | 640 | 620 | 620 | 600 | 560 | 580 | 580 | 570 | ISQL - SHOW SYSTEM TABLES |
||
68 | SS | 420 | 440 | 420 | 430 | 410 | 410 | 410 | 410 | 410 | 440 | 450 | 430 | 440 | 420 | 410 | 410 | 450 | 430 | 440 | 450 | 400 | 410 | 440 | 410 | 430 | 420 | 410 | 410 | 410 | 410 | ISQL - SHOW SYSTEM TABLES |
||
69 | CS | 10590 | 10000 | 9580 | 11740 | 10570 | 9510 | 11560 | 10000 | 9550 | 8930 | 9550 | 11700 | 10600 | 11560 | 200000 | 11310 | 9480 | 10550 | 200080 | 200920 | 10590 | 9440 | 10580 | 200380 | 200280 | 9480 | 10390 | 200190 | 199960 | 199950 | Error "BLOB is not found" while replication converts INSERT into UPDATE for a conflicting record |
||
70 | SS | 10620 | 8490 | 10590 | 9670 | 9520 | 10490 | 11550 | 10540 | 11570 | 9610 | 9610 | 9600 | 10690 | 8520 | 199390 | 9420 | 10660 | 10630 | 198950 | 199110 | 9480 | 10620 | 11690 | 199120 | 199050 | 10550 | 9390 | 199030 | 199080 | 198930 | Error "BLOB is not found" while replication converts INSERT into UPDATE for a conflicting record |
||
71 | CS | 6040 | 5970 | 6020 | 6080 | 5950 | 5920 | 6020 | 5920 | 8960 | 6020 | 5890 | 6040 | 5890 | 5940 | 134290 | 6640 | 5880 | 5890 | 134090 | 134670 | 6880 | 6000 | 7010 | 134130 | 134590 | 6800 | 5680 | 134340 | 134080 | 133860 | Problem with replication of BLOB segments longer than 32KB |
||
72 | SS | 6080 | 6070 | 6080 | 6130 | 6000 | 6030 | 6010 | 6030 | 6060 | 6050 | 6070 | 6060 | 6100 | 7090 | 133200 | 5940 | 6110 | 6060 | 132980 | 133120 | 6010 | 7560 | 6180 | 133550 | 132990 | 6020 | 5890 | 133090 | 133050 | 133080 | Problem with replication of BLOB segments longer than 32KB |
||
73 | CS | 6030 | 5970 | 5940 | 6030 | 5840 | 5840 | 5880 | 5960 | 9010 | 5960 | 5930 | 8080 | 6140 | 5940 | 134440 | 5740 | 5920 | 5900 | 134120 | 134560 | 8930 | 9010 | 6070 | 134140 | 134610 | 5840 | 5680 | 134180 | 134030 | 134050 | Replica DB must not fire DB-level triggers but their activity on master must be eventually seen in replica. |
||
74 | SS | 6090 | 7040 | 6170 | 6120 | 6020 | 6010 | 6010 | 6060 | 6090 | 6080 | 6080 | 6090 | 6140 | 6160 | 133190 | 5920 | 6070 | 6090 | 133040 | 133090 | 6060 | 5020 | 6080 | 133210 | 133150 | 6040 | 5960 | 133190 | 133110 | 133040 | Replica DB must not fire DB-level triggers but their activity on master must be eventually seen in replica. |
||
75 | CS | 6830 | 7040 | 6760 | 6970 | 6780 | 6900 | 6730 | 6740 | 6830 | 6780 | 6830 | 7740 | 6870 | 6810 | 155300 | 6460 | 6760 | 6740 | 154880 | 155220 | 6780 | 6800 | 6890 | 155230 | 155320 | 6830 | 6540 | 155160 | 154990 | 155040 | DDL-triggers must fire only on master DB. |
||
76 | SS | 7880 | 7800 | 7900 | 7920 | 7790 | 7840 | 7760 | 8850 | 6850 | 7840 | 7870 | 7930 | 6870 | 7790 | 154210 | 6640 | 7890 | 7880 | 153910 | 154120 | 7780 | 8870 | 7880 | 154150 | 153970 | 7790 | 7680 | 154050 | 153980 | 153980 | DDL-triggers must fire only on master DB. |
||
77 | CS | 9860 | 9230 | 9860 | 9060 | 9720 | 9910 | 9840 | 9800 | 9790 | 9760 | 9740 | 9890 | 9820 | 9860 | 200510 | 9430 | 9890 | 9760 | 200260 | 201060 | 9890 | 9740 | 9980 | 200620 | 200550 | 9000 | 10430 | 201020 | 200400 | 200210 | Conflicting INSERT propagated into a read-write replica may cause duplicate records to appear |
||
78 | SS | 9670 | 9670 | 9000 | 9760 | 9620 | 9610 | 9610 | 8000 | 9650 | 9670 | 9730 | 9740 | 9700 | 9590 | 199230 | 9510 | 9700 | 8700 | 199030 | 199230 | 9580 | 10630 | 8000 | 199610 | 199080 | 9650 | 9550 | 199130 | 199370 | 199070 | Conflicting INSERT propagated into a read-write replica may cause duplicate records to appear |
||
79 | CS | 6270 | 6230 | 6270 | 6370 | 6130 | 6240 | 6230 | 6140 | 6220 | 6270 | 6190 | 8170 | 6140 | 6120 | 134360 | 5890 | 6140 | 6270 | 134000 | 134600 | 8290 | 6330 | 8320 | 134580 | 134340 | 6000 | 5860 | 134450 | 134310 | 134140 | Failed DDL commands can be replicated |
||
80 | SS | 6290 | 6240 | 7660 | 6330 | 6220 | 6260 | 7180 | 7620 | 6240 | 6270 | 6260 | 6290 | 6000 | 6220 | 133350 | 6100 | 6270 | 6300 | 133110 | 133680 | 6260 | 6270 | 7280 | 133280 | 133140 | 6000 | 6080 | 133280 | 133360 | 133240 | Failed DDL commands can be replicated |
||
81 | CS | 6460 | 6410 | 8650 | 6550 | 6000 | 6290 | 6340 | 6420 | 8450 | 6380 | 6390 | 6400 | 8360 | 6290 | 134720 | 6030 | 6460 | 6360 | 134460 | 135110 | 6300 | 8430 | 6340 | 134640 | 134980 | 9390 | 6030 | 134000 | 134480 | 134530 | Generator values may not replicate after commit |
||
82 | SS | 6370 | 6320 | 5350 | 6400 | 6300 | 6320 | 6340 | 5270 | 6360 | 6370 | 6370 | 5340 | 6430 | 6350 | 133450 | 6200 | 6380 | 6380 | 133300 | 133630 | 6280 | 6800 | 5350 | 133380 | 133300 | 6310 | 6190 | 133440 | 133400 | 133360 | Generator values may not replicate after commit |
||
83 | CS | 11110 | 10110 | 11310 | 13210 | 11050 | 9980 | 10120 | 10080 | 11090 | 10010 | 10070 | 11110 | 11140 | 10130 | 134310 | 10810 | 13110 | 10150 | 133900 | 134490 | 11100 | 11030 | 11140 | 134190 | 134040 | 13130 | 10740 | 134470 | 133960 | 133910 | Invalid message in replication.log (and possibly crash in the case of synchronous replication) when the target DB has no its "replica" flag set |
||
84 | SS | 10260 | 10160 | 10300 | 10300 | 10100 | 10150 | 10200 | 11140 | 10220 | 10190 | 10210 | 11240 | 10240 | 10170 | 133260 | 11050 | 10260 | 10210 | 133030 | 133210 | 10150 | 9140 | 11230 | 133120 | 133000 | 10200 | 10010 | 133260 | 133140 | 133010 | Invalid message in replication.log (and possibly crash in the case of synchronous replication) when the target DB has no its "replica" flag set |
||
85 | CS | 5570 | 3560 | 5720 | 5770 | 5460 | 3490 | 3560 | 3540 | 5000 | 3550 | 3600 | 5570 | 5710 | 3650 | 133860 | 3380 | 5520 | 6640 | 133610 | 133840 | 5000 | 5490 | 5640 | 134050 | 133830 | 5580 | 5280 | 133720 | 133640 | 133580 | Permission error with replication |
||
86 | SS | 14730 | 14650 | 14710 | 14800 | 15660 | 14670 | 14670 | 14670 | 14660 | 14680 | 14670 | 14710 | 14730 | 14680 | 132720 | 14560 | 14730 | 15710 | 132540 | 133070 | 15620 | 15680 | 14760 | 132640 | 132570 | 14650 | 14550 | 132690 | 132640 | 132710 | Permission error with replication |
||
87 | CS | 17320 | 29150 | 17320 | 14470 | 17000 | 17130 | 17150 | 17140 | 14070 | 17150 | 27700 | 17300 | 17190 | 27650 | 412430 | 16790 | 25540 | 27510 | 411810 | 412080 | 17200 | 14080 | 17630 | 412590 | 412700 | 7740 | 14720 | 412210 | 412120 | 412040 | Crash or hang while shutting down the replica database if segments are being applied |
||
88 | SS | 35920 | 35610 | 49670 | 35920 | 34700 | 50080 | 35690 | 35640 | 35660 | 35630 | 35670 | 38780 | 35630 | 38790 | 410950 | 35390 | 38680 | 34790 | 410230 | 411120 | 34000 | 35730 | 35620 | 410850 | 410000 | 38730 | 33610 | 410840 | 410900 | 410450 | Crash or hang while shutting down the replica database if segments are being applied |
||
89 | CS | 6420 | 8510 | 5800 | 5920 | 6670 | 5650 | 5630 | 5720 | 6760 | 5680 | 5770 | 5710 | 5680 | 5910 | 133890 | 6420 | 5820 | 5860 | 133730 | 133920 | 5680 | 6800 | 5760 | 133940 | 134430 | 8730 | 6510 | 134390 | 133730 | 133650 | Some updates can crash Firebird server on replica side |
||
90 | SS | 26890 | 29760 | 26680 | 26890 | 27720 | 26560 | 26790 | 29780 | 26760 | 26780 | 26790 | 26730 | 26800 | 26810 | 132650 | 30630 | 26790 | 27810 | 132440 | 132600 | 27730 | 26820 | 24720 | 132590 | 132520 | 26760 | 26690 | 132620 | 132580 | 132470 | Some updates can crash Firebird server on replica side |
||
91 | CS | 6230 | 6230 | 6040 | 6060 | 71560 | 6100 | 7000 | 6030 | 71620 | 5970 | 6080 | 5920 | 6950 | 6140 | 134270 | 5690 | 6110 | 6050 | 134130 | 134100 | 6880 | 71670 | 6100 | 134070 | 134000 | 5880 | 5610 | 134140 | 134050 | 134190 | Replication gets stuck due to "Blob xxx.xx is not found for table xxx" error |
||
92 | SS | 30020 | 31000 | 31060 | 30060 | 29990 | 31060 | 26930 | 30980 | 26940 | 28000 | 30980 | 27000 | 29990 | 30020 | 132870 | 26780 | 29970 | 26970 | 132700 | 133700 | 26920 | 26900 | 27040 | 132920 | 132000 | 26980 | 29890 | 132870 | 132810 | 133010 | Replication gets stuck due to "Blob xxx.xx is not found for table xxx" error |