Generated 15.05.2024 15:07
Tested: HQ50. Build: 5.0.1.1398; SS: 15.05.24 12:38:19 - 15.05.24 13:40:33; CS: 15.05.24 13:41:55 - 15.05.24 15:06:30;
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.1398 2024-05-15 |
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 | X | X | Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | CS | 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 | X | CREATE VIEW ignores PLAN |
|
2 | SS | 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 | X | CREATE VIEW ignores PLAN |
|
3 | CS | F | 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 | X | X | Count ( DISTINCT ... ) is too slow |
|
4 | CS | F | 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 | X | X | Compress Data over the Network |
|
5 | SS | F | 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 | X | X | Compress Data over the Network |
|
6 | CS | 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 | X | Subquery-based predicates are not evaluated early in the join order |
|
7 | SS | 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 | X | Subquery-based predicates are not evaluated early in the join order |
|
8 | CS | 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 | X | Natural is used to select instead of primary key index |
|
9 | SS | 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 | X | Natural is used to select instead of primary key index |
|
10 | CS | F | 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 | X | X | Ability to cancel waiting in lock manager |
|
11 | CS | 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 | X | Choose the best matching index for navigation |
|
12 | SS | 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 | X | Choose the best matching index for navigation |
|
13 | CS | 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 | X | Regression: Join order in v3 is less optimal than in v2.x |
|
14 | SS | 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 | X | Regression: Join order in v3 is less optimal than in v2.x |
|
15 | CS | 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 | X | Performance degradation in FB 3.0.2 compared to FB 2.5.7 |
|
16 | SS | 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 | X | Performance degradation in FB 3.0.2 compared to FB 2.5.7 |
|
17 | CS | 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 | X | Badly selective index could be used for extra filtering even if selective index is used for sorting |
|
18 | SS | 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 | X | Badly selective index could be used for extra filtering even if selective index is used for sorting |
|
19 | CS | 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 | X | Bad performance for NULLs filtering inside a navigational index scan |
|
20 | SS | 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 | X | Bad performance for NULLs filtering inside a navigational index scan |
|
21 | CS | 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 | X | Bad PLAN generated for query on Firebird v3.0 |
|
22 | SS | 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 | X | Bad PLAN generated for query on Firebird v3.0 |
|
23 | SS | F | 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 | X | X | Very poor "similar to" performance |
|
24 | CS | 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 | X | FB3 Optimiser chooses less efficient plan than FB2.5 optimiser |
|
25 | SS | 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 | X | FB3 Optimiser chooses less efficient plan than FB2.5 optimiser |
|
26 | CS | F | 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 | X | X | Error "connection lost to database" could happen when application creates few local attachments (using XNET) simultaneously |
|
27 | CS | 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 | X | X | System table with keywords |
|
28 | SS | 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 | X | X | System table with keywords |
|
29 | CS | 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 | X | Bad execution plan if some stream depends on multiple streams via a function [CORE2975] |
|
30 | SS | 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 | X | Bad execution plan if some stream depends on multiple streams via a function [CORE2975] |
|
31 | SS | F | 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 | X | X | Problem when restoring the database on FB 4.0 RC1 (gbak regression) |
|
32 | SS | F | 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 | X | X | Significant performance regression of SIMILAR TO and SUBSTRING(SIMILAR) when pattern is taken from variable (rather than directly specified) |
|
33 | CS | 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 | X | Cost-based choice between nested loop join and hash join |
|
34 | SS | 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 | X | Cost-based choice between nested loop join and hash join |
|
35 | CS | 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 | X | Regression: bad plan in FB 3.0.9+ (correct in FB 3.0.8) |
|
36 | SS | 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 | X | Regression: bad plan in FB 3.0.9+ (correct in FB 3.0.8) |
|
37 | CS | 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 | X | Backup error for wide table |
|
38 | SS | 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 | X | Backup error for wide table |
|
39 | CS | 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 | X | Add COMPILE trace events - ability to see execution plan of every PSQL statement. |
|
40 | SS | 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 | X | Add COMPILE trace events - ability to see execution plan of every PSQL statement. |
|
41 | CS | 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 | X | Add LEVEL column to PLG$PROF_RECORD_SOURCES and PLG$PROF_RECORD_SOURCE_STATS_VIEW |
|
42 | SS | 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 | X | Add LEVEL column to PLG$PROF_RECORD_SOURCES and PLG$PROF_RECORD_SOURCE_STATS_VIEW |
|
43 | CS | 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 | X | X | Extend rdb$get_context('SYSTEM', '***') with client-related info |
|
44 | SS | 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 | X | X | Extend rdb$get_context('SYSTEM', '***') with client-related info |
|
45 | CS | 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 | X | FB5 uses PK for ordered plan even if less count of fields matching index exists |
|
46 | SS | 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 | X | FB5 uses PK for ordered plan even if less count of fields matching index exists |
|
47 | CS | 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 | X | System procedure/function inconsistency between ISQL SHOW FUNCTIONS and SHOW PROCEDURES |
|
48 | SS | 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 | X | System procedure/function inconsistency between ISQL SHOW FUNCTIONS and SHOW PROCEDURES |
|
49 | CS | 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 | X | False validation error for short unpacked records |
|
50 | SS | 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 | X | False validation error for short unpacked records |
|
51 | 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 | Assertion (space > 0) failure during restore |
|
52 | 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 | Assertion (space > 0) failure during restore |
|
53 | 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 using CASE WHEN with RIGHT JOIN |
|
54 | 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 using CASE WHEN with RIGHT JOIN |
|
55 | 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 after creating partial index |
|
56 | 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 after creating partial index |
|
57 | CS | 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 | X | Unexpected results when comparing integer with string containing value out of range of that integer datatype |
|
58 | SS | 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 | X | Unexpected results when comparing integer with string containing value out of range of that integer datatype |
|
59 | CS | 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 | X | Invalid result when string compared with indexed numeric(x,y) field where x > 18 and y != 0 |
|
60 | SS | 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 | X | Invalid result when string compared with indexed numeric(x,y) field where x > 18 and y != 0 |
|
61 | CS | 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 | X | "Too many temporary blobs" with blob_append when select a stored procedue using rows-clause |
|
62 | SS | 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 | X | "Too many temporary blobs" with blob_append when select a stored procedue using rows-clause |
|
63 | CS | 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 | X | (var)char variables/parameters assignments fail in Stored Procedures with subroutines |
|
64 | SS | 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 | X | (var)char variables/parameters assignments fail in Stored Procedures with subroutines |
|
65 | 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 | SIMILAR TO with constant pattern using '|', '*', '?' or '{0,N}' doesn't work as expected |
|
66 | 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 | SIMILAR TO with constant pattern using '|', '*', '?' or '{0,N}' doesn't work as expected |
|
67 | 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 | Partial index uniqueness violation (changes in columns participating in index filtering expression are not properly tracked). |
|
68 | 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 | Partial index uniqueness violation (changes in columns participating in index filtering expression are not properly tracked). |
|
69 | 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 | Memory leak when executing a lot of different queries and StatementTimeout > 0 |
|
70 | 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 | Memory leak when executing a lot of different queries and StatementTimeout > 0 |
|
71 | CS | 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 | X | X | IN predicate with string-type elements is evaluated wrongly against a numeric field |
|
72 | SS | 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 | X | X | IN predicate with string-type elements is evaluated wrongly against a numeric field |
|
73 | 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 | AV when preparing a query with IN list that contains both literals and sub-query |
|
74 | 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 | AV when preparing a query with IN list that contains both literals and sub-query |
|
75 | CS | 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 | X | X | Inefficient evaluation of expressions like rdb$db_key <= ? after mass delete |
|
76 | SS | 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 | X | X | Inefficient evaluation of expressions like rdb$db_key <= ? after mass delete |
|
77 | CS | 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 | X | Error isc_read_only_trans (335544361) should report SQLSTATE 25006. |
|
78 | SS | 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 | X | Error isc_read_only_trans (335544361) should report SQLSTATE 25006. |
|
79 | CS | 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 | X | FULL OUTER JOIN, list all values |
|
80 | SS | 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 | X | FULL OUTER JOIN, list all values |
|
81 | CS | 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 | X | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
|
82 | SS | 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 | X | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
|
83 | CS | 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 | X | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
|
84 | SS | 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 | X | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
|
85 | CS | 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 | X | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
|
86 | SS | 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 | X | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
|
87 | CS | 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 | X | INNER JOIN join order LIKE and IS NULL |
|
88 | SS | 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 | X | INNER JOIN join order LIKE and IS NULL |
|
89 | CS | 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 | X | INNER JOIN join order LIKE and STARTING WITH |
|
90 | SS | 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 | X | INNER JOIN join order LIKE and STARTING WITH |
|
91 | CS | 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 | X | INNER JOIN join order |
|
92 | SS | 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 | X | INNER JOIN join order |
|
93 | CS | 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 | X | Best match index selection (multi segment) |
|
94 | SS | 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 | X | Best match index selection (multi segment) |
|
95 | CS | 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 | X | Best match index selection (multi segment) |
|
96 | SS | 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 | X | Best match index selection (multi segment) |
|
97 | CS | 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 | X | Best match index selection (single segment) |
|
98 | SS | 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 | X | Best match index selection (single segment) |
|
99 | CS | 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 | X | Best match index selection (single segment) |
|
100 | SS | 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 | X | Best match index selection (single segment) |
|
101 | CS | 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 | X | Best match index selection (single segment) ASC and DESC |
|
102 | SS | 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 | X | Best match index selection (single segment) ASC and DESC |
|
103 | CS | 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 | X | Best match index selection (single segment) |
|
104 | SS | 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 | X | Best match index selection (single segment) |
|
105 | CS | 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 | X | Best match index selection (single segment) |
|
106 | SS | 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 | X | Best match index selection (single segment) |
|
107 | CS | 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 | X | X | ORDER BY ASC using index (multi) |
|
108 | SS | 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 | X | X | ORDER BY ASC using index (multi) |
|
109 | CS | 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 | X | ORDER BY ASC, DESC using index (multi) |
|
110 | SS | 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 | X | ORDER BY ASC, DESC using index (multi) |
|
111 | CS | 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 | X | X | ORDER BY ASC using index (multi) |
|
112 | SS | 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 | X | X | ORDER BY ASC using index (multi) |
|
113 | CS | 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 | X | X | ORDER BY ASC using index (multi) and WHERE clause |
|
114 | SS | 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 | X | X | ORDER BY ASC using index (multi) and WHERE clause |
|
115 | CS | 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 | X | X | Change error by warning in the case when isc_dpb_parallel_workers value is not at valid range |
|
116 | SS | 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 | 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.1398 2024-05-15 |
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 | X | X | Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | CS | 560 | 626 | 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 | 0 | 0 | CREATE VIEW ignores PLAN |
|
2 | SS | 377 | 405 | 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 | 0 | 0 | CREATE VIEW ignores PLAN |
|
3 | CS | 2159 | 3709 | 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 | 0 | 0 | Count ( DISTINCT ... ) is too slow |
|
4 | CS | 24801 | 107631 | 24052 | 24557 | 24853 | 24242 | 24093 | 25972 | 24801 | 25182 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Compress Data over the Network |
|
5 | SS | 23439 | 101800 | 22574 | 23776 | 23439 | 23916 | 22549 | 23119 | 22661 | 23980 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Compress Data over the Network |
|
6 | CS | 490 | 555 | 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 | 0 | 0 | Subquery-based predicates are not evaluated early in the join order |
|
7 | SS | 315 | 386 | 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 | 0 | 0 | Subquery-based predicates are not evaluated early in the join order |
|
8 | CS | 583 | 620 | 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 | 0 | 0 | Natural is used to select instead of primary key index |
|
9 | SS | 379 | 393 | 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 | 0 | 0 | Natural is used to select instead of primary key index |
|
10 | CS | 6776 | 11849 | 6710 | 7326 | 6776 | 6795 | 6653 | 6726 | 6734 | 6995 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Ability to cancel waiting in lock manager |
|
11 | CS | 795 | 789 | 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 | 0 | 0 | Choose the best matching index for navigation |
|
12 | SS | 475 | 489 | 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 | 0 | 0 | Choose the best matching index for navigation |
|
13 | CS | 3126 | 5903 | 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 | 0 | 0 | Regression: Join order in v3 is less optimal than in v2.x |
|
14 | SS | 2730 | 3543 | 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 | 0 | 0 | Regression: Join order in v3 is less optimal than in v2.x |
|
15 | CS | 513 | 1205 | 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 | 0 | 0 | Performance degradation in FB 3.0.2 compared to FB 2.5.7 |
|
16 | SS | 334 | 431 | 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 | 0 | 0 | Performance degradation in FB 3.0.2 compared to FB 2.5.7 |
|
17 | CS | 3586 | 7363 | 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 | 0 | 0 | Badly selective index could be used for extra filtering even if selective index is used for sorting |
|
18 | SS | 3324 | 3675 | 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 | 0 | 0 | Badly selective index could be used for extra filtering even if selective index is used for sorting |
|
19 | CS | 3601 | 7192 | 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 | 0 | 0 | Bad performance for NULLs filtering inside a navigational index scan |
|
20 | SS | 3332 | 3570 | 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 | 0 | 0 | Bad performance for NULLs filtering inside a navigational index scan |
|
21 | CS | 1215 | 2218 | 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 | 0 | 0 | Bad PLAN generated for query on Firebird v3.0 |
|
22 | SS | 902 | 1181 | 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 | 0 | 0 | Bad PLAN generated for query on Firebird v3.0 |
|
23 | SS | 308 | 5391 | 299 | 308 | 298 | 310 | 298 | 318 | 298 | 309 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Very poor "similar to" performance |
|
24 | CS | 1561 | 4203 | 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 | 0 | 0 | FB3 Optimiser chooses less efficient plan than FB2.5 optimiser |
|
25 | SS | 1188 | 1665 | 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 | 0 | 0 | FB3 Optimiser chooses less efficient plan than FB2.5 optimiser |
|
26 | CS | 3697 | 242806 | 4015 | 3697 | 3658 | 3753 | 3508 | 3486 | 3594 | 3834 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Error "connection lost to database" could happen when application creates few local attachments (using XNET) simultaneously |
|
27 | CS | 868 | 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 | 0 | 0 | System table with keywords |
|
28 | SS | 654 | 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 | 0 | 0 | System table with keywords |
|
29 | CS | 1421 | 1925 | 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 | 0 | 0 | Bad execution plan if some stream depends on multiple streams via a function [CORE2975] |
|
30 | SS | 431 | 508 | 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 | 0 | 0 | Bad execution plan if some stream depends on multiple streams via a function [CORE2975] |
|
31 | SS | 112247 | 319904 | 115429 | 115504 | 111834 | 111867 | 112505 | 112247 | 111111 | 76075 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Problem when restoring the database on FB 4.0 RC1 (gbak regression) |
|
32 | SS | 2812 | 4672 | 2750 | 2848 | 2757 | 2812 | 3052 | 2789 | 2783 | 3018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Significant performance regression of SIMILAR TO and SUBSTRING(SIMILAR) when pattern is taken from variable (rather than directly specified) |
|
33 | CS | 1585 | 1746 | 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 | 0 | 0 | Cost-based choice between nested loop join and hash join |
|
34 | SS | 802 | 1007 | 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 | 0 | 0 | Cost-based choice between nested loop join and hash join |
|
35 | CS | 985 | 1211 | 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 | 0 | 0 | Regression: bad plan in FB 3.0.9+ (correct in FB 3.0.8) |
|
36 | SS | 692 | 827 | 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 | 0 | 0 | Regression: bad plan in FB 3.0.9+ (correct in FB 3.0.8) |
|
37 | CS | 904 | 1079 | 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 | 0 | 0 | Backup error for wide table |
|
38 | SS | 665 | 1060 | 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 | 0 | 0 | Backup error for wide table |
|
39 | CS | 3145 | 3186 | 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 | 0 | 0 | Add COMPILE trace events - ability to see execution plan of every PSQL statement. |
|
40 | SS | 2458 | 2519 | 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 | 0 | 0 | Add COMPILE trace events - ability to see execution plan of every PSQL statement. |
|
41 | CS | 905 | 1057 | 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 | 0 | 0 | Add LEVEL column to PLG$PROF_RECORD_SOURCES and PLG$PROF_RECORD_SOURCE_STATS_VIEW |
|
42 | SS | 453 | 496 | 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 | 0 | 0 | Add LEVEL column to PLG$PROF_RECORD_SOURCES and PLG$PROF_RECORD_SOURCE_STATS_VIEW |
|
43 | CS | 366 | 500 | 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 | 0 | 0 | Extend rdb$get_context('SYSTEM', '***') with client-related info |
|
44 | SS | 202 | 290 | 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 | 0 | 0 | Extend rdb$get_context('SYSTEM', '***') with client-related info |
|
45 | CS | 1484 | 1745 | 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 | 0 | 0 | FB5 uses PK for ordered plan even if less count of fields matching index exists |
|
46 | SS | 1399 | 2066 | 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 | 0 | 0 | FB5 uses PK for ordered plan even if less count of fields matching index exists |
|
47 | CS | 474 | 527 | 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 | 0 | 0 | System procedure/function inconsistency between ISQL SHOW FUNCTIONS and SHOW PROCEDURES |
|
48 | SS | 313 | 355 | 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 | 0 | 0 | System procedure/function inconsistency between ISQL SHOW FUNCTIONS and SHOW PROCEDURES |
|
49 | CS | 733 | 845 | 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 | 0 | 0 | False validation error for short unpacked records |
|
50 | SS | 461 | 511 | 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 | 0 | 0 | False validation error for short unpacked records |
|
51 | CS | 829 | 1354 | 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 | 0 | 0 | Assertion (space > 0) failure during restore |
|
52 | SS | 614 | 809 | 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 | 0 | 0 | Assertion (space > 0) failure during restore |
|
53 | CS | 512 | 523 | 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 | 0 | 0 | Unexpected results when using CASE WHEN with RIGHT JOIN |
|
54 | SS | 313 | 343 | 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 | 0 | 0 | Unexpected results when using CASE WHEN with RIGHT JOIN |
|
55 | CS | 498 | 565 | 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 | 0 | 0 | Unexpected results after creating partial index |
|
56 | SS | 316 | 347 | 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 | 0 | 0 | Unexpected results after creating partial index |
|
57 | CS | 489 | 617 | 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 | 0 | 0 | Unexpected results when comparing integer with string containing value out of range of that integer datatype |
|
58 | SS | 326 | 348 | 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 | 0 | 0 | Unexpected results when comparing integer with string containing value out of range of that integer datatype |
|
59 | CS | 471 | 508 | 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 | 0 | 0 | Invalid result when string compared with indexed numeric(x,y) field where x > 18 and y != 0 |
|
60 | SS | 307 | 356 | 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 | 0 | 0 | Invalid result when string compared with indexed numeric(x,y) field where x > 18 and y != 0 |
|
61 | CS | 602 | 713 | 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 | 0 | 0 | "Too many temporary blobs" with blob_append when select a stored procedue using rows-clause |
|
62 | SS | 406 | 1225 | 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 | 0 | 0 | "Too many temporary blobs" with blob_append when select a stored procedue using rows-clause |
|
63 | CS | 509 | 502 | 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 | 0 | 0 | (var)char variables/parameters assignments fail in Stored Procedures with subroutines |
|
64 | SS | 313 | 1131 | 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 | 0 | 0 | (var)char variables/parameters assignments fail in Stored Procedures with subroutines |
|
65 | CS | 473 | 570 | 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 | 0 | 0 | SIMILAR TO with constant pattern using '|', '*', '?' or '{0,N}' doesn't work as expected |
|
66 | SS | 319 | 1563 | 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 | 0 | 0 | SIMILAR TO with constant pattern using '|', '*', '?' or '{0,N}' doesn't work as expected |
|
67 | CS | 533 | 549 | 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 | 0 | 0 | Partial index uniqueness violation (changes in columns participating in index filtering expression are not properly tracked). |
|
68 | SS | 323 | 1322 | 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 | 0 | 0 | Partial index uniqueness violation (changes in columns participating in index filtering expression are not properly tracked). |
|
69 | CS | 18430 | 18708 | 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 | 0 | 0 | Memory leak when executing a lot of different queries and StatementTimeout > 0 |
|
70 | SS | 18210 | 18372 | 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 | 0 | 0 | Memory leak when executing a lot of different queries and StatementTimeout > 0 |
|
71 | CS | 482 | 519 | 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 | 0 | 0 | IN predicate with string-type elements is evaluated wrongly against a numeric field |
|
72 | SS | 405 | 405 | 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 | 0 | 0 | IN predicate with string-type elements is evaluated wrongly against a numeric field |
|
73 | CS | 540 | 497 | 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 | 0 | 0 | AV when preparing a query with IN list that contains both literals and sub-query |
|
74 | SS | 306 | 331 | 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 | 0 | 0 | AV when preparing a query with IN list that contains both literals and sub-query |
|
75 | CS | 1135 | 1239 | 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 | 0 | 0 | Inefficient evaluation of expressions like rdb$db_key <= ? after mass delete |
|
76 | SS | 934 | 1386 | 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 | 0 | 0 | Inefficient evaluation of expressions like rdb$db_key <= ? after mass delete |
|
77 | CS | 636 | 636 | 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 | 0 | Error isc_read_only_trans (335544361) should report SQLSTATE 25006. |
|
78 | SS | 934 | 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 | 0 | 0 | 0 | 0 | Error isc_read_only_trans (335544361) should report SQLSTATE 25006. |
|
79 | CS | 796 | 865 | 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 | 0 | 0 | FULL OUTER JOIN, list all values |
|
80 | SS | 469 | 544 | 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 | 0 | 0 | FULL OUTER JOIN, list all values |
|
81 | CS | 798 | 851 | 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 | 0 | 0 | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
|
82 | SS | 466 | 505 | 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 | 0 | 0 | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
|
83 | CS | 795 | 931 | 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 | 0 | 0 | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
|
84 | SS | 473 | 519 | 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 | 0 | 0 | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
|
85 | CS | 803 | 857 | 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 | 0 | 0 | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
|
86 | SS | 464 | 499 | 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 | 0 | 0 | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
|
87 | CS | 823 | 887 | 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 | 0 | 0 | INNER JOIN join order LIKE and IS NULL |
|
88 | SS | 514 | 566 | 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 | 0 | 0 | INNER JOIN join order LIKE and IS NULL |
|
89 | CS | 625 | 674 | 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 | 0 | 0 | INNER JOIN join order LIKE and STARTING WITH |
|
90 | SS | 413 | 441 | 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 | 0 | 0 | INNER JOIN join order LIKE and STARTING WITH |
|
91 | CS | 816 | 2558 | 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 | 0 | 0 | INNER JOIN join order |
|
92 | SS | 468 | 510 | 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 | 0 | 0 | INNER JOIN join order |
|
93 | CS | 779 | 885 | 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 | 0 | 0 | Best match index selection (multi segment) |
|
94 | SS | 476 | 496 | 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 | 0 | 0 | Best match index selection (multi segment) |
|
95 | CS | 814 | 866 | 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 | 0 | 0 | Best match index selection (multi segment) |
|
96 | SS | 491 | 517 | 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 | 0 | 0 | Best match index selection (multi segment) |
|
97 | CS | 801 | 841 | 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 | 0 | 0 | Best match index selection (single segment) |
|
98 | SS | 470 | 488 | 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 | 0 | 0 | Best match index selection (single segment) |
|
99 | CS | 821 | 915 | 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 | 0 | 0 | Best match index selection (single segment) |
|
100 | SS | 464 | 517 | 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 | 0 | 0 | Best match index selection (single segment) |
|
101 | CS | 802 | 850 | 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 | 0 | 0 | Best match index selection (single segment) ASC and DESC |
|
102 | SS | 468 | 593 | 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 | 0 | 0 | Best match index selection (single segment) ASC and DESC |
|
103 | CS | 812 | 934 | 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 | 0 | 0 | Best match index selection (single segment) |
|
104 | SS | 473 | 514 | 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 | 0 | 0 | Best match index selection (single segment) |
|
105 | CS | 805 | 990 | 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 | 0 | 0 | Best match index selection (single segment) |
|
106 | SS | 470 | 495 | 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 | 0 | 0 | Best match index selection (single segment) |
|
107 | CS | 812 | 885 | 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 | 0 | 0 | ORDER BY ASC using index (multi) |
|
108 | SS | 482 | 881 | 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 | 0 | 0 | ORDER BY ASC using index (multi) |
|
109 | CS | 802 | 791 | 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 | 0 | 0 | ORDER BY ASC, DESC using index (multi) |
|
110 | SS | 469 | 512 | 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 | 0 | 0 | ORDER BY ASC, DESC using index (multi) |
|
111 | CS | 788 | 881 | 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 | 0 | 0 | ORDER BY ASC using index (multi) |
|
112 | SS | 491 | 585 | 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 | 0 | 0 | ORDER BY ASC using index (multi) |
|
113 | CS | 542 | 646 | 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 | 0 | 0 | ORDER BY ASC using index (multi) and WHERE clause |
|
114 | SS | 336 | 381 | 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 | 0 | 0 | ORDER BY ASC using index (multi) and WHERE clause |
|
115 | CS | 1537 | 1946 | 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 | 0 | 0 | Change error by warning in the case when isc_dpb_parallel_workers value is not at valid range |
|
116 | SS | 1051 | 1375 | 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 | 0 | 0 | Change error by warning in the case when isc_dpb_parallel_workers value is not at valid range |