Generated 15.06.2024 10:51
Tested: HQ50. Build: 5.0.1.1415; SS: 15.06.24 09:14:34 - 15.06.24 09:56:15; CS: 15.06.24 09:56:56 - 15.06.24 10:50:22;
OS and hardware info: Windows 10 10.0.19045 ; logical CPUs: 8 ; total memory: 31.7 Gb
QA-software: Python 3.11.2; pytest: 7.4.4; firebird.driver: 1.10.4; Firebird.Qa: 0.19.3
Loading data. Please wait...
Jump to LIST of unique test names from this report
NN | Test name | mode | 5.0.1.1415 2024-06-15 |
5.0.1.1401 2024-06-10 |
5.0.1.1398 2024-05-22 |
5.0.1.1397 2024-05-10 |
5.0.1.1392 2024-05-08 |
5.0.1.1386 2024-04-27 |
5.0.1.1378 2024-04-20 |
5.0.1.1346 2024-04-07 |
5.0.1.1340 2024-02-21 |
5.0.1.1325 2024-02-15 |
5.0.1.1318 2024-01-26 |
X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | CS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | CREATE VIEW ignores PLAN |
|
2 | SS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | CREATE VIEW ignores PLAN |
|
3 | CS | F | P | P | P | P | P | P | P | P | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Count ( DISTINCT ... ) is too slow |
|
4 | CS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Subquery-based predicates are not evaluated early in the join order |
|
5 | SS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Subquery-based predicates are not evaluated early in the join order |
|
6 | CS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Natural is used to select instead of primary key index |
|
7 | SS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Natural is used to select instead of primary key index |
|
8 | CS | P | F | P | P | P | P | P | P | P | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | exclude_filter doesn't work for <services></section> section of the Trace facility |
|
9 | SS | P | F | P | P | P | P | P | P | P | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | exclude_filter doesn't work for <services></section> section of the Trace facility |
|
10 | CS | P | F | P | P | P | P | P | P | P | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | FBSVCMGR connects to server as OS user name rather than value of ISC_USER environment variable |
|
11 | SS | P | F | P | P | P | P | P | P | P | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | FBSVCMGR connects to server as OS user name rather than value of ISC_USER environment variable |
|
12 | CS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Choose the best matching index for navigation |
|
13 | SS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Choose the best matching index for navigation |
|
14 | CS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Regression: Join order in v3 is less optimal than in v2.x |
|
15 | SS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Regression: Join order in v3 is less optimal than in v2.x |
|
16 | CS | F | S | S | S | S | S | S | S | S | S | S | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Allow to enforce IPv4 or IPv6 in URL-like connection strings |
|
17 | SS | F | S | S | S | S | S | S | S | S | S | S | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Allow to enforce IPv4 or IPv6 in URL-like connection strings |
|
18 | CS | F | P | P | P | P | P | P | P | P | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins |
|
19 | SS | F | P | P | P | P | P | P | P | P | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins |
|
20 | CS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Performance degradation in FB 3.0.2 compared to FB 2.5.7 |
|
21 | SS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Performance degradation in FB 3.0.2 compared to FB 2.5.7 |
|
22 | CS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Badly selective index could be used for extra filtering even if selective index is used for sorting |
|
23 | SS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | 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 | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Bad performance for NULLs filtering inside a navigational index scan |
|
25 | SS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Bad performance for NULLs filtering inside a navigational index scan |
|
26 | CS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Bad PLAN generated for query on Firebird v3.0 |
|
27 | SS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Bad PLAN generated for query on Firebird v3.0 |
|
28 | CS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | FB3 Optimiser chooses less efficient plan than FB2.5 optimiser |
|
29 | SS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | FB3 Optimiser chooses less efficient plan than FB2.5 optimiser |
|
30 | CS | X | X | X | X | X | X | X | X | F | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | System table with keywords |
|
31 | SS | X | X | X | X | X | X | X | X | F | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | System table with keywords |
|
32 | CS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Bad execution plan if some stream depends on multiple streams via a function [CORE2975] |
|
33 | SS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Bad execution plan if some stream depends on multiple streams via a function [CORE2975] |
|
34 | SS | F | P | P | P | P | P | P | P | P | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired |
|
35 | CS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Cost-based choice between nested loop join and hash join |
|
36 | SS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Cost-based choice between nested loop join and hash join |
|
37 | CS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Regression: bad plan in FB 3.0.9+ (correct in FB 3.0.8) |
|
38 | SS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Regression: bad plan in FB 3.0.9+ (correct in FB 3.0.8) |
|
39 | CS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Backup error for wide table |
|
40 | SS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Backup error for wide table |
|
41 | CS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Add COMPILE trace events - ability to see execution plan of every PSQL statement. |
|
42 | SS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Add COMPILE trace events - ability to see execution plan of every PSQL statement. |
|
43 | CS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Add LEVEL column to PLG$PROF_RECORD_SOURCES and PLG$PROF_RECORD_SOURCE_STATS_VIEW |
|
44 | SS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Add LEVEL column to PLG$PROF_RECORD_SOURCES and PLG$PROF_RECORD_SOURCE_STATS_VIEW |
|
45 | CS | P | P | P | P | F | P | P | P | P | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Extend rdb$get_context('SYSTEM', '***') with client-related info |
|
46 | SS | P | P | P | P | F | P | P | P | P | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Extend rdb$get_context('SYSTEM', '***') with client-related info |
|
47 | CS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | FB5 uses PK for ordered plan even if less count of fields matching index exists |
|
48 | SS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | FB5 uses PK for ordered plan even if less count of fields matching index exists |
|
49 | CS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | System procedure/function inconsistency between ISQL SHOW FUNCTIONS and SHOW PROCEDURES |
|
50 | SS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | System procedure/function inconsistency between ISQL SHOW FUNCTIONS and SHOW PROCEDURES |
|
51 | CS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | False validation error for short unpacked records |
|
52 | SS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | False validation error for short unpacked records |
|
53 | CS | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Assertion (space > 0) failure during restore |
|
54 | SS | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Assertion (space > 0) failure during restore |
|
55 | CS | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Unexpected results when using CASE WHEN with RIGHT JOIN |
|
56 | SS | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Unexpected results when using CASE WHEN with RIGHT JOIN |
|
57 | CS | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Unexpected results after creating partial index |
|
58 | SS | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Unexpected results after creating partial index |
|
59 | CS | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Unexpected results when comparing integer with string containing value out of range of that integer datatype |
|
60 | SS | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Unexpected results when comparing integer with string containing value out of range of that integer datatype |
|
61 | CS | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Invalid result when string compared with indexed numeric(x,y) field where x > 18 and y != 0 |
|
62 | SS | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Invalid result when string compared with indexed numeric(x,y) field where x > 18 and y != 0 |
|
63 | CS | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | "Too many temporary blobs" with blob_append when select a stored procedue using rows-clause |
|
64 | SS | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | "Too many temporary blobs" with blob_append when select a stored procedue using rows-clause |
|
65 | CS | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | (var)char variables/parameters assignments fail in Stored Procedures with subroutines |
|
66 | SS | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | (var)char variables/parameters assignments fail in Stored Procedures with subroutines |
|
67 | CS | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Error "Too many recursion levels" does not stop execuition of code that uses ON DISCONNECT trigger (FB 4.x+) |
|
68 | SS | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Error "Too many recursion levels" does not stop execuition of code that uses ON DISCONNECT trigger (FB 4.x+) |
|
69 | CS | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | SIMILAR TO with constant pattern using '|', '*', '?' or '{0,N}' doesn't work as expected |
|
70 | SS | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | SIMILAR TO with constant pattern using '|', '*', '?' or '{0,N}' doesn't work as expected |
|
71 | CS | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Partial index uniqueness violation (changes in columns participating in index filtering expression are not properly tracked). |
|
72 | SS | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Partial index uniqueness violation (changes in columns participating in index filtering expression are not properly tracked). |
|
73 | CS | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Memory leak when executing a lot of different queries and StatementTimeout > 0 |
|
74 | SS | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Memory leak when executing a lot of different queries and StatementTimeout > 0 |
|
75 | CS | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | IN predicate with string-type elements is evaluated wrongly against a numeric field |
|
76 | SS | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | IN predicate with string-type elements is evaluated wrongly against a numeric field |
|
77 | CS | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | AV when preparing a query with IN list that contains both literals and sub-query |
|
78 | SS | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | AV when preparing a query with IN list that contains both literals and sub-query |
|
79 | CS | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Inefficient evaluation of expressions like rdb$db_key <= ? after mass delete |
|
80 | SS | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Inefficient evaluation of expressions like rdb$db_key <= ? after mass delete |
|
81 | CS | P | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Engine returns empty string when unable to translate Unicode symbol into ICU-codepage. |
|
82 | SS | P | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Engine returns empty string when unable to translate Unicode symbol into ICU-codepage. |
|
83 | CS | P | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Error isc_read_only_trans (335544361) should report SQLSTATE 25006. |
|
84 | SS | P | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Error isc_read_only_trans (335544361) should report SQLSTATE 25006. |
|
85 | CS | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Cast dies with numeric value is out of range error |
|
86 | SS | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Cast dies with numeric value is out of range error |
|
87 | CS | P | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Procedure manipulation can lead to wrong dependencies removal |
|
88 | SS | P | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Procedure manipulation can lead to wrong dependencies removal |
|
89 | CS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | FULL OUTER JOIN, list all values |
|
90 | SS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | FULL OUTER JOIN, list all values |
|
91 | CS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
|
92 | SS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
|
93 | CS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
|
94 | SS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
|
95 | CS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
|
96 | SS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
|
97 | CS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | INNER JOIN join order LIKE and IS NULL |
|
98 | SS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | INNER JOIN join order LIKE and IS NULL |
|
99 | CS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | INNER JOIN join order LIKE and STARTING WITH |
|
100 | SS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | INNER JOIN join order LIKE and STARTING WITH |
|
101 | CS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | INNER JOIN join order |
|
102 | SS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | INNER JOIN join order |
|
103 | CS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Best match index selection (multi segment) |
|
104 | SS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Best match index selection (multi segment) |
|
105 | CS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Best match index selection (multi segment) |
|
106 | SS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Best match index selection (multi segment) |
|
107 | CS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Best match index selection (single segment) |
|
108 | SS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Best match index selection (single segment) |
|
109 | CS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Best match index selection (single segment) |
|
110 | SS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Best match index selection (single segment) |
|
111 | CS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Best match index selection (single segment) ASC and DESC |
|
112 | SS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Best match index selection (single segment) ASC and DESC |
|
113 | CS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Best match index selection (single segment) |
|
114 | SS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Best match index selection (single segment) |
|
115 | CS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Best match index selection (single segment) |
|
116 | SS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Best match index selection (single segment) |
|
117 | CS | F | F | F | F | F | F | F | F | F | F | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | ORDER BY ASC using index (multi) |
|
118 | SS | F | F | F | F | F | F | F | F | F | F | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | ORDER BY ASC using index (multi) |
|
119 | CS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | ORDER BY ASC, DESC using index (multi) |
|
120 | SS | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | ORDER BY ASC, DESC using index (multi) |
|
121 | CS | F | F | F | F | F | F | F | F | F | F | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | ORDER BY ASC using index (multi) |
|
122 | SS | F | F | F | F | F | F | F | F | F | F | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | ORDER BY ASC using index (multi) |
|
123 | CS | F | F | F | F | F | F | F | F | F | F | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | ORDER BY ASC using index (multi) and WHERE clause |
|
124 | SS | F | F | F | F | F | F | F | F | F | F | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | ORDER BY ASC using index (multi) and WHERE clause |
|
125 | CS | P | F | P | P | P | P | P | P | P | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Check that trace plugin shows ROLE used in service attachment. Format: USER[:ROLE] |
|
126 | SS | P | F | P | P | P | P | P | P | P | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Check that trace plugin shows ROLE used in service attachment. Format: USER[:ROLE] |
|
127 | CS | F | F | F | F | F | F | F | F | F | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Change error by warning in the case when isc_dpb_parallel_workers value is not at valid range |
|
128 | SS | F | F | F | F | F | F | F | F | F | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Change error by warning in the case when isc_dpb_parallel_workers value is not at valid range |
NN | Test name | mode | median_ms | 5.0.1.1415 2024-06-15 |
5.0.1.1401 2024-06-10 |
5.0.1.1398 2024-05-22 |
5.0.1.1397 2024-05-10 |
5.0.1.1392 2024-05-08 |
5.0.1.1386 2024-04-27 |
5.0.1.1378 2024-04-20 |
5.0.1.1346 2024-04-07 |
5.0.1.1340 2024-02-21 |
5.0.1.1325 2024-02-15 |
5.0.1.1318 2024-01-26 |
X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | CS | 560 | 530 | 595 | 560 | 553 | 560 | 604 | 550 | 557 | 553 | 594 | 912 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | CREATE VIEW ignores PLAN |
|
2 | SS | 377 | 358 | 377 | 404 | 376 | 406 | 364 | 377 | 376 | 380 | 374 | 720 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | CREATE VIEW ignores PLAN |
|
3 | CS | 2138 | 2546 | 1928 | 1854 | 1868 | 2138 | 2250 | 1901 | 2159 | 2313 | 2495 | 1908 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Count ( DISTINCT ... ) is too slow |
|
4 | CS | 485 | 452 | 469 | 495 | 556 | 499 | 519 | 490 | 480 | 484 | 466 | 485 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Subquery-based predicates are not evaluated early in the join order |
|
5 | SS | 315 | 296 | 315 | 315 | 311 | 319 | 355 | 315 | 310 | 306 | 309 | 328 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Subquery-based predicates are not evaluated early in the join order |
|
6 | CS | 566 | 515 | 566 | 551 | 534 | 544 | 624 | 611 | 543 | 568 | 583 | 640 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Natural is used to select instead of primary key index |
|
7 | SS | 376 | 358 | 363 | 374 | 432 | 376 | 374 | 379 | 379 | 376 | 373 | 388 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Natural is used to select instead of primary key index |
|
8 | CS | 2603 | 2591 | 2977 | 2603 | 2601 | 2607 | 2608 | 2593 | 2647 | 2602 | 2688 | 2597 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | exclude_filter doesn't work for <services></section> section of the Trace facility |
|
9 | SS | 2449 | 2420 | 2772 | 2449 | 2523 | 2456 | 2428 | 2438 | 2441 | 2454 | 2453 | 2443 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | exclude_filter doesn't work for <services></section> section of the Trace facility |
|
10 | CS | 2280 | 2267 | 2626 | 2281 | 2310 | 2280 | 2279 | 2291 | 2280 | 2275 | 2278 | 2296 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | FBSVCMGR connects to server as OS user name rather than value of ISC_USER environment variable |
|
11 | SS | 2144 | 2137 | 2159 | 2144 | 2161 | 3289 | 2144 | 2143 | 2140 | 2141 | 2146 | 2168 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | FBSVCMGR connects to server as OS user name rather than value of ISC_USER environment variable |
|
12 | CS | 789 | 702 | 762 | 784 | 809 | 789 | 820 | 833 | 739 | 768 | 795 | 844 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Choose the best matching index for navigation |
|
13 | SS | 472 | 436 | 468 | 483 | 488 | 499 | 475 | 465 | 463 | 472 | 463 | 495 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Choose the best matching index for navigation |
|
14 | CS | 3120 | 2890 | 3884 | 3060 | 3065 | 3120 | 3149 | 3210 | 3126 | 3059 | 3025 | 3191 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Regression: Join order in v3 is less optimal than in v2.x |
|
15 | SS | 2726 | 2671 | 2704 | 2706 | 2738 | 2788 | 2725 | 2728 | 2730 | 2726 | 2726 | 2792 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Regression: Join order in v3 is less optimal than in v2.x |
|
16 | CS | 351 | 702 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Allow to enforce IPv4 or IPv6 in URL-like connection strings |
|
17 | SS | 312 | 624 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Allow to enforce IPv4 or IPv6 in URL-like connection strings |
|
18 | CS | 788 | 749 | 746 | 754 | 831 | 827 | 768 | 854 | 784 | 809 | 788 | 810 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins |
|
19 | SS | 517 | 483 | 505 | 514 | 564 | 508 | 522 | 528 | 525 | 519 | 517 | 512 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins |
|
20 | CS | 508 | 484 | 536 | 508 | 503 | 513 | 498 | 504 | 525 | 554 | 499 | 584 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Performance degradation in FB 3.0.2 compared to FB 2.5.7 |
|
21 | SS | 327 | 312 | 327 | 324 | 327 | 325 | 328 | 334 | 344 | 327 | 360 | 587 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Performance degradation in FB 3.0.2 compared to FB 2.5.7 |
|
22 | CS | 3582 | 3503 | 3578 | 3546 | 3586 | 3606 | 3586 | 3578 | 3582 | 3655 | 3554 | 3622 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Badly selective index could be used for extra filtering even if selective index is used for sorting |
|
23 | SS | 3315 | 3253 | 3303 | 3311 | 3312 | 3309 | 3323 | 3386 | 3324 | 3315 | 3382 | 3488 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Badly selective index could be used for extra filtering even if selective index is used for sorting |
|
24 | CS | 3580 | 3534 | 3603 | 3565 | 3580 | 3567 | 3572 | 3670 | 3621 | 4073 | 3556 | 3601 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bad performance for NULLs filtering inside a navigational index scan |
|
25 | SS | 3320 | 3253 | 3298 | 3306 | 3336 | 3315 | 3331 | 3332 | 3426 | 3320 | 3310 | 3346 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bad performance for NULLs filtering inside a navigational index scan |
|
26 | CS | 1160 | 1140 | 1141 | 1152 | 1383 | 1160 | 1227 | 1215 | 1144 | 1264 | 1125 | 1177 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bad PLAN generated for query on Firebird v3.0 |
|
27 | SS | 900 | 874 | 907 | 900 | 902 | 927 | 898 | 914 | 889 | 884 | 874 | 910 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bad PLAN generated for query on Firebird v3.0 |
|
28 | CS | 1554 | 1530 | 1548 | 1532 | 1645 | 1554 | 1558 | 1535 | 1561 | 1568 | 1515 | 1588 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | FB3 Optimiser chooses less efficient plan than FB2.5 optimiser |
|
29 | SS | 1188 | 1155 | 1323 | 1190 | 1188 | 1280 | 1182 | 1171 | 1174 | 1185 | 1269 | 1333 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | FB3 Optimiser chooses less efficient plan than FB2.5 optimiser |
|
30 | CS | 868 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 882 | 868 | 553 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | System table with keywords |
|
31 | SS | 654 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 662 | 654 | 332 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | System table with keywords |
|
32 | CS | 1409 | 1374 | 1352 | 1462 | 1409 | 1850 | 1392 | 1386 | 1431 | 1870 | 1407 | 1421 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bad execution plan if some stream depends on multiple streams via a function [CORE2975] |
|
33 | SS | 430 | 421 | 411 | 445 | 428 | 444 | 430 | 431 | 442 | 429 | 415 | 437 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bad execution plan if some stream depends on multiple streams via a function [CORE2975] |
|
34 | SS | 21347 | 21311 | 21343 | 21342 | 21344 | 21368 | 21379 | 21356 | 21347 | 21356 | 21343 | 21365 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired |
|
35 | CS | 1543 | 1436 | 1477 | 1491 | 1627 | 1543 | 1642 | 1585 | 1491 | 1497 | 1800 | 1562 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Cost-based choice between nested loop join and hash join |
|
36 | SS | 792 | 764 | 776 | 788 | 792 | 804 | 785 | 801 | 802 | 813 | 788 | 835 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Cost-based choice between nested loop join and hash join |
|
37 | CS | 982 | 921 | 982 | 994 | 999 | 945 | 1008 | 930 | 931 | 985 | 922 | 1061 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Regression: bad plan in FB 3.0.9+ (correct in FB 3.0.8) |
|
38 | SS | 692 | 672 | 705 | 714 | 707 | 708 | 683 | 692 | 674 | 675 | 664 | 726 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Regression: bad plan in FB 3.0.9+ (correct in FB 3.0.8) |
|
39 | CS | 901 | 874 | 880 | 944 | 962 | 901 | 904 | 884 | 892 | 973 | 945 | 786 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Backup error for wide table |
|
40 | SS | 662 | 624 | 656 | 659 | 705 | 666 | 662 | 654 | 687 | 663 | 665 | 551 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Backup error for wide table |
|
41 | CS | 3142 | 2925 | 3145 | 2911 | 2950 | 2914 | 3152 | 3145 | 3158 | 3148 | 3131 | 3142 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Add COMPILE trace events - ability to see execution plan of every PSQL statement. |
|
42 | SS | 2456 | 2425 | 2448 | 2460 | 2465 | 2445 | 2458 | 2468 | 2464 | 2451 | 2451 | 2456 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Add COMPILE trace events - ability to see execution plan of every PSQL statement. |
|
43 | CS | 899 | 874 | 889 | 899 | 900 | 888 | 880 | 894 | 905 | 942 | 1002 | 1137 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Add LEVEL column to PLG$PROF_RECORD_SOURCES and PLG$PROF_RECORD_SOURCE_STATS_VIEW |
|
44 | SS | 453 | 421 | 458 | 453 | 470 | 480 | 462 | 452 | 440 | 452 | 439 | 453 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Add LEVEL column to PLG$PROF_RECORD_SOURCES and PLG$PROF_RECORD_SOURCE_STATS_VIEW |
|
45 | CS | 363 | 359 | 354 | 362 | 392 | 738 | 360 | 363 | 366 | 363 | 358 | 409 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Extend rdb$get_context('SYSTEM', '***') with client-related info |
|
46 | SS | 201 | 202 | 196 | 200 | 201 | 538 | 202 | 200 | 202 | 239 | 197 | 200 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Extend rdb$get_context('SYSTEM', '***') with client-related info |
|
47 | CS | 1475 | 1436 | 1444 | 1570 | 1469 | 1484 | 1456 | 1449 | 1490 | 1543 | 1475 | 1522 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | FB5 uses PK for ordered plan even if less count of fields matching index exists |
|
48 | SS | 1267 | 1218 | 1245 | 1238 | 1247 | 1267 | 1399 | 1247 | 1455 | 1426 | 1451 | 1311 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | FB5 uses PK for ordered plan even if less count of fields matching index exists |
|
49 | CS | 474 | 452 | 499 | 488 | 506 | 486 | 464 | 519 | 466 | 465 | 471 | 474 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | System procedure/function inconsistency between ISQL SHOW FUNCTIONS and SHOW PROCEDURES |
|
50 | SS | 312 | 296 | 299 | 313 | 312 | 313 | 315 | 308 | 314 | 312 | 303 | 319 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | System procedure/function inconsistency between ISQL SHOW FUNCTIONS and SHOW PROCEDURES |
|
51 | CS | 733 | 624 | 759 | 772 | 733 | 715 | 737 | 732 | 715 | 749 | 744 | 723 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | False validation error for short unpacked records |
|
52 | SS | 456 | 436 | 456 | 456 | 455 | 471 | 467 | 456 | 469 | 447 | 459 | 461 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | False validation error for short unpacked records |
|
53 | CS | 807 | 780 | 774 | 828 | 844 | 800 | 858 | 781 | 815 | 789 | 1287 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Assertion (space > 0) failure during restore |
|
54 | SS | 589 | 530 | 550 | 639 | 610 | 618 | 620 | 556 | 567 | 569 | 1100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Assertion (space > 0) failure during restore |
|
55 | CS | 485 | 452 | 471 | 494 | 476 | 523 | 521 | 460 | 517 | 463 | 508 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unexpected results when using CASE WHEN with RIGHT JOIN |
|
56 | SS | 305 | 296 | 304 | 314 | 319 | 307 | 334 | 304 | 297 | 298 | 325 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unexpected results when using CASE WHEN with RIGHT JOIN |
|
57 | CS | 476 | 452 | 465 | 556 | 525 | 476 | 469 | 477 | 547 | 464 | 519 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unexpected results after creating partial index |
|
58 | SS | 315 | 296 | 311 | 317 | 315 | 305 | 317 | 314 | 327 | 315 | 320 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unexpected results after creating partial index |
|
59 | CS | 481 | 469 | 473 | 528 | 480 | 497 | 481 | 481 | 924 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unexpected results when comparing integer with string containing value out of range of that integer datatype |
|
60 | SS | 326 | 327 | 310 | 340 | 311 | 325 | 314 | 328 | 654 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unexpected results when comparing integer with string containing value out of range of that integer datatype |
|
61 | CS | 470 | 451 | 507 | 470 | 466 | 473 | 470 | 468 | 478 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Invalid result when string compared with indexed numeric(x,y) field where x > 18 and y != 0 |
|
62 | SS | 305 | 296 | 297 | 314 | 306 | 304 | 308 | 295 | 312 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Invalid result when string compared with indexed numeric(x,y) field where x > 18 and y != 0 |
|
63 | CS | 597 | 577 | 647 | 597 | 598 | 607 | 596 | 670 | 500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | "Too many temporary blobs" with blob_append when select a stored procedue using rows-clause |
|
64 | SS | 405 | 390 | 407 | 425 | 420 | 404 | 408 | 404 | 323 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | "Too many temporary blobs" with blob_append when select a stored procedue using rows-clause |
|
65 | CS | 483 | 452 | 458 | 473 | 519 | 519 | 482 | 516 | 484 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | (var)char variables/parameters assignments fail in Stored Procedures with subroutines |
|
66 | SS | 311 | 296 | 300 | 319 | 313 | 310 | 314 | 297 | 322 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | (var)char variables/parameters assignments fail in Stored Procedures with subroutines |
|
67 | CS | 6819 | 8314 | 5325 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Error "Too many recursion levels" does not stop execuition of code that uses ON DISCONNECT trigger (FB 4.x+) |
|
68 | SS | 3684 | 3142 | 4226 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Error "Too many recursion levels" does not stop execuition of code that uses ON DISCONNECT trigger (FB 4.x+) |
|
69 | CS | 472 | 451 | 471 | 472 | 470 | 472 | 473 | 841 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | SIMILAR TO with constant pattern using '|', '*', '?' or '{0,N}' doesn't work as expected |
|
70 | SS | 316 | 295 | 316 | 332 | 319 | 311 | 307 | 637 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | SIMILAR TO with constant pattern using '|', '*', '?' or '{0,N}' doesn't work as expected |
|
71 | CS | 494 | 468 | 485 | 532 | 549 | 480 | 533 | 494 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Partial index uniqueness violation (changes in columns participating in index filtering expression are not properly tracked). |
|
72 | SS | 323 | 312 | 330 | 338 | 323 | 319 | 312 | 329 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Partial index uniqueness violation (changes in columns participating in index filtering expression are not properly tracked). |
|
73 | CS | 18427 | 18422 | 18427 | 18427 | 18428 | 18430 | 18421 | 18433 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Memory leak when executing a lot of different queries and StatementTimeout > 0 |
|
74 | SS | 18210 | 18197 | 18219 | 18211 | 18210 | 18210 | 18207 | 18229 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Memory leak when executing a lot of different queries and StatementTimeout > 0 |
|
75 | CS | 482 | 468 | 514 | 539 | 470 | 482 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | IN predicate with string-type elements is evaluated wrongly against a numeric field |
|
76 | SS | 308 | 295 | 306 | 308 | 425 | 320 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | IN predicate with string-type elements is evaluated wrongly against a numeric field |
|
77 | CS | 473 | 453 | 461 | 456 | 473 | 540 | 561 | 570 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | AV when preparing a query with IN list that contains both literals and sub-query |
|
78 | SS | 299 | 281 | 298 | 295 | 305 | 306 | 299 | 402 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | AV when preparing a query with IN list that contains both literals and sub-query |
|
79 | CS | 1111 | 1078 | 1106 | 1111 | 1118 | 1135 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Inefficient evaluation of expressions like rdb$db_key <= ? after mass delete |
|
80 | SS | 917 | 889 | 906 | 917 | 917 | 934 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Inefficient evaluation of expressions like rdb$db_key <= ? after mass delete |
|
81 | CS | 526 | 451 | 526 | 847 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Engine returns empty string when unable to translate Unicode symbol into ICU-codepage. |
|
82 | SS | 303 | 296 | 303 | 640 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Engine returns empty string when unable to translate Unicode symbol into ICU-codepage. |
|
83 | CS | 552 | 547 | 552 | 613 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Error isc_read_only_trans (335544361) should report SQLSTATE 25006. |
|
84 | SS | 360 | 327 | 360 | 376 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Error isc_read_only_trans (335544361) should report SQLSTATE 25006. |
|
85 | CS | 470 | 467 | 474 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Cast dies with numeric value is out of range error |
|
86 | SS | 311 | 281 | 341 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Cast dies with numeric value is out of range error |
|
87 | CS | 493 | 468 | 560 | 493 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Procedure manipulation can lead to wrong dependencies removal |
|
88 | SS | 347 | 311 | 347 | 352 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Procedure manipulation can lead to wrong dependencies removal |
|
89 | CS | 792 | 733 | 819 | 786 | 796 | 779 | 792 | 726 | 843 | 824 | 759 | 825 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | FULL OUTER JOIN, list all values |
|
90 | SS | 464 | 436 | 487 | 459 | 472 | 469 | 479 | 452 | 464 | 462 | 456 | 479 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | FULL OUTER JOIN, list all values |
|
91 | CS | 796 | 656 | 709 | 806 | 806 | 799 | 796 | 774 | 768 | 744 | 817 | 798 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
|
92 | SS | 466 | 452 | 468 | 477 | 466 | 464 | 462 | 470 | 466 | 468 | 464 | 477 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
|
93 | CS | 779 | 639 | 797 | 772 | 795 | 762 | 735 | 767 | 829 | 809 | 824 | 779 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
|
94 | SS | 468 | 437 | 467 | 464 | 468 | 483 | 467 | 477 | 467 | 473 | 468 | 486 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
|
95 | CS | 774 | 656 | 791 | 766 | 774 | 759 | 764 | 727 | 825 | 803 | 809 | 821 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
|
96 | SS | 460 | 436 | 453 | 469 | 456 | 467 | 455 | 483 | 464 | 460 | 449 | 485 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
|
97 | CS | 823 | 702 | 830 | 829 | 857 | 823 | 814 | 813 | 874 | 812 | 770 | 837 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | INNER JOIN join order LIKE and IS NULL |
|
98 | SS | 513 | 483 | 518 | 513 | 512 | 524 | 506 | 514 | 513 | 515 | 510 | 527 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | INNER JOIN join order LIKE and IS NULL |
|
99 | CS | 621 | 608 | 676 | 618 | 607 | 700 | 677 | 625 | 617 | 621 | 616 | 709 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | INNER JOIN join order LIKE and STARTING WITH |
|
100 | SS | 412 | 406 | 412 | 415 | 417 | 412 | 446 | 413 | 412 | 398 | 405 | 461 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | INNER JOIN join order LIKE and STARTING WITH |
|
101 | CS | 796 | 624 | 776 | 763 | 816 | 801 | 837 | 796 | 819 | 794 | 765 | 823 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | INNER JOIN join order |
|
102 | SS | 467 | 437 | 467 | 467 | 478 | 465 | 470 | 468 | 483 | 468 | 457 | 461 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | INNER JOIN join order |
|
103 | CS | 777 | 639 | 802 | 765 | 714 | 767 | 779 | 777 | 827 | 839 | 756 | 796 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Best match index selection (multi segment) |
|
104 | SS | 476 | 437 | 478 | 486 | 469 | 477 | 453 | 469 | 478 | 476 | 446 | 481 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Best match index selection (multi segment) |
|
105 | CS | 801 | 811 | 722 | 789 | 781 | 814 | 739 | 801 | 747 | 815 | 816 | 820 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Best match index selection (multi segment) |
|
106 | SS | 489 | 453 | 482 | 482 | 477 | 492 | 491 | 490 | 491 | 506 | 458 | 489 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Best match index selection (multi segment) |
|
107 | CS | 770 | 686 | 746 | 715 | 952 | 801 | 767 | 770 | 777 | 814 | 720 | 827 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Best match index selection (single segment) |
|
108 | SS | 470 | 453 | 471 | 483 | 503 | 467 | 454 | 457 | 474 | 470 | 454 | 490 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Best match index selection (single segment) |
|
109 | CS | 804 | 780 | 765 | 804 | 835 | 829 | 745 | 765 | 821 | 797 | 821 | 822 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Best match index selection (single segment) |
|
110 | SS | 455 | 436 | 455 | 454 | 464 | 462 | 452 | 453 | 484 | 469 | 450 | 489 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Best match index selection (single segment) |
|
111 | CS | 793 | 624 | 796 | 789 | 812 | 793 | 802 | 770 | 826 | 766 | 756 | 817 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Best match index selection (single segment) ASC and DESC |
|
112 | SS | 468 | 436 | 472 | 472 | 474 | 464 | 468 | 470 | 464 | 480 | 457 | 463 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Best match index selection (single segment) ASC and DESC |
|
113 | CS | 803 | 656 | 803 | 765 | 812 | 800 | 806 | 792 | 825 | 814 | 791 | 813 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Best match index selection (single segment) |
|
114 | SS | 470 | 437 | 473 | 465 | 482 | 467 | 473 | 467 | 478 | 470 | 459 | 484 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Best match index selection (single segment) |
|
115 | CS | 798 | 655 | 805 | 798 | 752 | 776 | 763 | 805 | 819 | 812 | 766 | 821 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Best match index selection (single segment) |
|
116 | SS | 468 | 437 | 456 | 473 | 470 | 466 | 479 | 447 | 471 | 468 | 452 | 487 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Best match index selection (single segment) |
|
117 | CS | 801 | 718 | 791 | 797 | 1087 | 795 | 1170 | 801 | 812 | 803 | 821 | 794 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ORDER BY ASC using index (multi) |
|
118 | SS | 477 | 453 | 457 | 475 | 1124 | 480 | 823 | 465 | 477 | 772 | 473 | 482 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ORDER BY ASC using index (multi) |
|
119 | CS | 802 | 639 | 785 | 810 | 802 | 778 | 818 | 795 | 791 | 811 | 849 | 803 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ORDER BY ASC, DESC using index (multi) |
|
120 | SS | 468 | 437 | 469 | 468 | 458 | 469 | 467 | 467 | 470 | 777 | 467 | 481 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ORDER BY ASC, DESC using index (multi) |
|
121 | CS | 788 | 796 | 781 | 797 | 781 | 788 | 778 | 769 | 830 | 775 | 811 | 802 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ORDER BY ASC using index (multi) |
|
122 | SS | 484 | 452 | 477 | 485 | 484 | 482 | 515 | 492 | 473 | 1028 | 480 | 491 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ORDER BY ASC using index (multi) |
|
123 | CS | 518 | 483 | 518 | 546 | 482 | 559 | 558 | 542 | 483 | 496 | 542 | 496 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ORDER BY ASC using index (multi) and WHERE clause |
|
124 | SS | 334 | 296 | 334 | 346 | 336 | 341 | 395 | 324 | 331 | 994 | 322 | 312 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ORDER BY ASC using index (multi) and WHERE clause |
|
125 | CS | 3393 | 3349 | 3356 | 3376 | 3393 | 3415 | 3395 | 3465 | 3612 | 3385 | 3352 | 3811 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Check that trace plugin shows ROLE used in service attachment. Format: USER[:ROLE] |
|
126 | SS | 2822 | 2974 | 2850 | 2806 | 2811 | 2842 | 2796 | 2782 | 2856 | 2822 | 2819 | 3042 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Check that trace plugin shows ROLE used in service attachment. Format: USER[:ROLE] |
|
127 | CS | 1518 | 1406 | 1565 | 1470 | 1537 | 1490 | 1495 | 1556 | 1579 | 1466 | 1629 | 1518 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Change error by warning in the case when isc_dpb_parallel_workers value is not at valid range |
|
128 | SS | 1049 | 999 | 1091 | 1035 | 1088 | 1048 | 1049 | 1051 | 1042 | 1066 | 1068 | 1024 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Change error by warning in the case when isc_dpb_parallel_workers value is not at valid range |