Generated 15.05.2024 06:41
Tested: HQ50. Build: 5.0.1.1398; SS: 14.05.24 07:16:31 - 14.05.24 08:08:03; CS: 15.05.24 05:31:04 - 15.05.24 06:40:53;
OS and hardware info: Linux 6.5.0-5-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.5.13-1 (2023-11-29) ; logical CPUs: 2 ; total memory: 7.6 Gb
QA-software: Python 3.11.9, virtual env; pytest: 7.4.4; firebird.driver: 1.10.4; Firebird.Qa: 0.19.3
Jump to LIST of unique test names from this report
NN | Test name | mode | 5.0.1.1398 2024-05-15 |
5.0.1.1392 2024-05-10 |
5.0.1.1386 2024-04-26 |
5.0.1.1378 2024-04-21 |
5.0.1.1346 2024-04-07 |
5.0.1.1340 2024-03-01 |
5.0.1.1325 2024-02-18 |
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 | X | Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | SS | P | P | X | P | P | F | P | P | X | 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 |
|
2 | SS | F | P | X | 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 | X | Write note into log when automatic sweep is started |
|
3 | CS | P | P | X | 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 | Natural is used to select instead of primary key index |
|
4 | SS | P | P | X | 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 | Natural is used to select instead of primary key index |
|
5 | CS | P | P | X | 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 | Inefficient optimization (regression) |
|
6 | SS | P | P | X | 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 | Inefficient optimization (regression) |
|
7 | CS | F | P | X | 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 | X | Database shutdown is reported as successfully completed before all active connections are in fact interrupted |
|
8 | CS | P | P | X | 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 | Choose the best matching index for navigation |
|
9 | SS | P | P | X | 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 | Choose the best matching index for navigation |
|
10 | CS | P | P | X | 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 | Predicate IS [NOT] DISTINCT FROM is not pushed into unions/aggregates thus causing sub-optimal plans |
|
11 | SS | P | P | X | 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 | Predicate IS [NOT] DISTINCT FROM is not pushed into unions/aggregates thus causing sub-optimal plans |
|
12 | CS | P | P | X | 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 | ORDER BY on index can cause suboptimal index choices |
|
13 | SS | P | P | X | 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 | ORDER BY on index can cause suboptimal index choices |
|
14 | CS | P | P | X | 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 | FB3.0.4.33063 vs FB3.0.5.33100 manual plan cause "index cannot be used in the specified plan" |
|
15 | SS | P | P | X | 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 | FB3.0.4.33063 vs FB3.0.5.33100 manual plan cause "index cannot be used in the specified plan" |
|
16 | CS | 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 | X | System table with keywords |
|
17 | SS | 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 | X | System table with keywords |
|
18 | CS | P | P | X | 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 | Query with SP doesn't accept explicit plan [CORE3451] |
|
19 | SS | P | P | X | 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 | Query with SP doesn't accept explicit plan [CORE3451] |
|
20 | CS | P | F | X | 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 | X | DROP DATABASE lead FB to hang if it is issued while DB encrypting/decrypting is in progress |
|
21 | CS | P | P | X | 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 | Backup error for wide table |
|
22 | SS | P | P | X | 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 | Backup error for wide table |
|
23 | CS | P | P | X | 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 | FB5 uses PK for ordered plan even if less count of fields matching index exists |
|
24 | SS | P | P | X | 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 | FB5 uses PK for ordered plan even if less count of fields matching index exists |
|
25 | CS | P | P | X | 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 | System procedure/function inconsistency between ISQL SHOW FUNCTIONS and SHOW PROCEDURES |
|
26 | SS | P | P | X | 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 | System procedure/function inconsistency between ISQL SHOW FUNCTIONS and SHOW PROCEDURES |
|
27 | CS | P | P | X | 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 | False validation error for short unpacked records |
|
28 | SS | P | P | X | 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 | False validation error for short unpacked records |
|
29 | CS | P | P | X | 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 | Assertion (space > 0) failure during restore |
|
30 | SS | P | P | X | 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 | Assertion (space > 0) failure during restore |
|
31 | CS | P | P | X | 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 | Unexpected results when using CASE WHEN with RIGHT JOIN |
|
32 | SS | P | P | X | 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 | Unexpected results when using CASE WHEN with RIGHT JOIN |
|
33 | CS | P | P | X | 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 | Unexpected results after creating partial index |
|
34 | SS | P | P | X | 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 | Unexpected results after creating partial index |
|
35 | CS | P | P | X | 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 | Unexpected results when comparing integer with string containing value out of range of that integer datatype |
|
36 | SS | P | P | X | 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 | Unexpected results when comparing integer with string containing value out of range of that integer datatype |
|
37 | CS | P | P | X | 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 | Invalid result when string compared with indexed numeric(x,y) field where x > 18 and y != 0 |
|
38 | SS | P | P | X | 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 | Invalid result when string compared with indexed numeric(x,y) field where x > 18 and y != 0 |
|
39 | CS | P | P | X | 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 | "Too many temporary blobs" with blob_append when select a stored procedue using rows-clause |
|
40 | SS | P | P | X | 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 | "Too many temporary blobs" with blob_append when select a stored procedue using rows-clause |
|
41 | CS | P | P | X | 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 | (var)char variables/parameters assignments fail in Stored Procedures with subroutines |
|
42 | SS | P | P | X | 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 | (var)char variables/parameters assignments fail in Stored Procedures with subroutines |
|
43 | CS | P | P | X | 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 | SIMILAR TO with constant pattern using '|', '*', '?' or '{0,N}' doesn't work as expected |
|
44 | SS | P | P | X | 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 | SIMILAR TO with constant pattern using '|', '*', '?' or '{0,N}' doesn't work as expected |
|
45 | CS | P | P | X | 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 | Partial index uniqueness violation (changes in columns participating in index filtering expression are not properly tracked). |
|
46 | SS | P | P | X | 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 | Partial index uniqueness violation (changes in columns participating in index filtering expression are not properly tracked). |
|
47 | CS | P | P | X | 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 | Memory leak when executing a lot of different queries and StatementTimeout > 0 |
|
48 | SS | P | P | X | 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 | Memory leak when executing a lot of different queries and StatementTimeout > 0 |
|
49 | 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 | IN predicate with string-type elements is evaluated wrongly against a numeric field |
|
50 | 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 | IN predicate with string-type elements is evaluated wrongly against a numeric field |
|
51 | CS | P | P | X | 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 | AV when preparing a query with IN list that contains both literals and sub-query |
|
52 | 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 | Inefficient evaluation of expressions like rdb$db_key <= ? after mass delete |
|
53 | 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 | Inefficient evaluation of expressions like rdb$db_key <= ? after mass delete |
|
54 | CS | P | P | X | 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 | FULL OUTER JOIN, list all values |
|
55 | SS | P | P | X | 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 | FULL OUTER JOIN, list all values |
|
56 | CS | P | P | X | 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 | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
|
57 | SS | P | P | X | 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 | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
|
58 | CS | P | P | X | 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 | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
|
59 | SS | P | P | X | 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 | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
|
60 | CS | P | P | X | 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 | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
|
61 | SS | P | P | X | 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 | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
|
62 | CS | P | P | X | 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 | Best match index selection (multi segment) |
|
63 | SS | P | P | X | 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 | Best match index selection (multi segment) |
|
64 | CS | F | F | X | 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 | X | ORDER BY ASC using index (multi) |
|
65 | SS | F | F | X | 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 | X | ORDER BY ASC using index (multi) |
|
66 | CS | P | P | X | 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 | ORDER BY ASC using index (multi) |
|
67 | SS | P | P | X | 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 | ORDER BY ASC using index (multi) |
|
68 | CS | F | F | X | 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 | X | ORDER BY ASC using index (multi) |
|
69 | SS | F | F | X | 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 | X | ORDER BY ASC using index (multi) |
|
70 | CS | F | F | X | 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 | X | ORDER BY ASC using index (multi) and WHERE clause |
|
71 | SS | F | F | X | 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 | X | ORDER BY ASC using index (multi) and WHERE clause |
|
72 | CS | P | P | X | 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 | Characters are garbled when replicating fields with type BLOB SUB_TYPE TEXT if the character set of the connection and the field are different |
|
73 | SS | P | P | X | 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 | Characters are garbled when replicating fields with type BLOB SUB_TYPE TEXT if the character set of the connection and the field are different |
|
74 | CS | P | F | X | 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 | X | External Connections Pool, functionality test 01 |
|
75 | CS | F | F | X | 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 | X | Change error by warning in the case when isc_dpb_parallel_workers value is not at valid range |
|
76 | SS | F | F | X | 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 | 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.1392 2024-05-10 |
5.0.1.1386 2024-04-26 |
5.0.1.1378 2024-04-21 |
5.0.1.1346 2024-04-07 |
5.0.1.1340 2024-03-01 |
5.0.1.1325 2024-02-18 |
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 | X | Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | SS | 49551 | 42041 | 72016 | 0 | 52126 | 56859 | 32896 | 49551 | 39803 | 0 | 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 |
|
2 | SS | 5504 | 5500 | 5504 | 0 | 5488 | 5505 | 5669 | 5559 | 5316 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Write note into log when automatic sweep is started |
|
3 | CS | 700 | 814 | 1081 | 0 | 560 | 540 | 545 | 963 | 700 | 0 | 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 |
|
4 | SS | 544 | 495 | 555 | 0 | 544 | 547 | 381 | 637 | 423 | 0 | 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 |
|
5 | CS | 617 | 703 | 885 | 0 | 484 | 494 | 851 | 478 | 617 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Inefficient optimization (regression) |
|
6 | SS | 379 | 379 | 571 | 0 | 366 | 412 | 476 | 280 | 326 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Inefficient optimization (regression) |
|
7 | CS | 11720 | 11464 | 11720 | 0 | 11496 | 11517 | 12923 | 13212 | 11970 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Database shutdown is reported as successfully completed before all active connections are in fact interrupted |
|
8 | CS | 738 | 895 | 567 | 0 | 626 | 654 | 1103 | 1201 | 738 | 0 | 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 |
|
9 | SS | 505 | 451 | 673 | 0 | 336 | 505 | 655 | 544 | 452 | 0 | 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 |
|
10 | CS | 700 | 918 | 1178 | 0 | 619 | 677 | 676 | 713 | 700 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Predicate IS [NOT] DISTINCT FROM is not pushed into unions/aggregates thus causing sub-optimal plans |
|
11 | SS | 413 | 502 | 643 | 0 | 313 | 321 | 413 | 542 | 402 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Predicate IS [NOT] DISTINCT FROM is not pushed into unions/aggregates thus causing sub-optimal plans |
|
12 | CS | 589 | 763 | 503 | 0 | 519 | 561 | 604 | 663 | 589 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ORDER BY on index can cause suboptimal index choices |
|
13 | SS | 421 | 462 | 479 | 0 | 298 | 360 | 421 | 441 | 348 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ORDER BY on index can cause suboptimal index choices |
|
14 | CS | 473 | 654 | 412 | 0 | 433 | 473 | 438 | 578 | 521 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | FB3.0.4.33063 vs FB3.0.5.33100 manual plan cause "index cannot be used in the specified plan" |
|
15 | SS | 366 | 410 | 420 | 0 | 229 | 366 | 372 | 357 | 286 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | FB3.0.4.33063 vs FB3.0.5.33100 manual plan cause "index cannot be used in the specified plan" |
|
16 | CS | 550 | 0 | 0 | 0 | 0 | 0 | 592 | 550 | 527 | 0 | 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 |
|
17 | SS | 336 | 0 | 0 | 0 | 0 | 0 | 374 | 336 | 309 | 0 | 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 |
|
18 | CS | 519 | 685 | 458 | 0 | 440 | 483 | 577 | 521 | 519 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Query with SP doesn't accept explicit plan [CORE3451] |
|
19 | SS | 355 | 356 | 355 | 0 | 250 | 262 | 403 | 407 | 303 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Query with SP doesn't accept explicit plan [CORE3451] |
|
20 | CS | 5908 | 5908 | 8563 | 0 | 4777 | 5084 | 5386 | 6029 | 6105 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | DROP DATABASE lead FB to hang if it is issued while DB encrypting/decrypting is in progress |
|
21 | CS | 1246 | 1310 | 1587 | 0 | 991 | 1024 | 1246 | 1359 | 1134 | 0 | 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 |
|
22 | SS | 771 | 860 | 735 | 0 | 748 | 771 | 741 | 1368 | 846 | 0 | 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 |
|
23 | CS | 2308 | 2308 | 3188 | 0 | 1812 | 1946 | 2369 | 2158 | 2343 | 0 | 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 |
|
24 | SS | 1717 | 1836 | 1535 | 0 | 1537 | 1717 | 1715 | 2100 | 1912 | 0 | 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 |
|
25 | CS | 505 | 700 | 762 | 0 | 438 | 470 | 501 | 538 | 505 | 0 | 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 |
|
26 | SS | 229 | 380 | 201 | 0 | 229 | 216 | 236 | 222 | 310 | 0 | 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 |
|
27 | CS | 760 | 963 | 1016 | 0 | 631 | 605 | 634 | 1407 | 760 | 0 | 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 |
|
28 | SS | 339 | 515 | 296 | 0 | 339 | 317 | 310 | 1119 | 405 | 0 | 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 |
|
29 | CS | 1025 | 1151 | 1005 | 0 | 935 | 923 | 1046 | 1279 | 0 | 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 |
|
30 | SS | 751 | 768 | 735 | 0 | 652 | 773 | 662 | 1109 | 0 | 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 |
|
31 | CS | 498 | 753 | 403 | 0 | 457 | 446 | 539 | 587 | 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 using CASE WHEN with RIGHT JOIN |
|
32 | SS | 248 | 378 | 190 | 0 | 250 | 246 | 267 | 216 | 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 using CASE WHEN with RIGHT JOIN |
|
33 | CS | 547 | 732 | 405 | 0 | 473 | 597 | 551 | 544 | 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 after creating partial index |
|
34 | SS | 239 | 400 | 210 | 0 | 260 | 232 | 247 | 218 | 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 after creating partial index |
|
35 | CS | 502 | 678 | 432 | 0 | 498 | 506 | 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 | Unexpected results when comparing integer with string containing value out of range of that integer datatype |
|
36 | SS | 275 | 398 | 231 | 0 | 289 | 262 | 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 | Unexpected results when comparing integer with string containing value out of range of that integer datatype |
|
37 | CS | 453 | 716 | 421 | 0 | 447 | 459 | 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 | Invalid result when string compared with indexed numeric(x,y) field where x > 18 and y != 0 |
|
38 | SS | 229 | 343 | 197 | 0 | 252 | 207 | 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 | Invalid result when string compared with indexed numeric(x,y) field where x > 18 and y != 0 |
|
39 | CS | 585 | 868 | 575 | 0 | 595 | 485 | 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 | "Too many temporary blobs" with blob_append when select a stored procedue using rows-clause |
|
40 | SS | 376 | 546 | 362 | 0 | 391 | 227 | 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 | "Too many temporary blobs" with blob_append when select a stored procedue using rows-clause |
|
41 | CS | 497 | 679 | 457 | 0 | 535 | 460 | 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 | (var)char variables/parameters assignments fail in Stored Procedures with subroutines |
|
42 | SS | 287 | 367 | 207 | 0 | 370 | 208 | 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 | (var)char variables/parameters assignments fail in Stored Procedures with subroutines |
|
43 | CS | 450 | 752 | 433 | 0 | 450 | 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 | SIMILAR TO with constant pattern using '|', '*', '?' or '{0,N}' doesn't work as expected |
|
44 | SS | 232 | 422 | 195 | 0 | 232 | 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 | SIMILAR TO with constant pattern using '|', '*', '?' or '{0,N}' doesn't work as expected |
|
45 | CS | 475 | 727 | 475 | 0 | 472 | 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 | Partial index uniqueness violation (changes in columns participating in index filtering expression are not properly tracked). |
|
46 | SS | 286 | 372 | 237 | 0 | 286 | 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 | Partial index uniqueness violation (changes in columns participating in index filtering expression are not properly tracked). |
|
47 | CS | 18701 | 18772 | 18701 | 0 | 18538 | 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 | Memory leak when executing a lot of different queries and StatementTimeout > 0 |
|
48 | SS | 18494 | 18494 | 18368 | 0 | 19095 | 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 | Memory leak when executing a lot of different queries and StatementTimeout > 0 |
|
49 | CS | 795 | 705 | 885 | 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 | IN predicate with string-type elements is evaluated wrongly against a numeric field |
|
50 | SS | 340 | 456 | 224 | 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 | IN predicate with string-type elements is evaluated wrongly against a numeric field |
|
51 | CS | 676 | 676 | 792 | 0 | 606 | 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 | AV when preparing a query with IN list that contains both literals and sub-query |
|
52 | CS | 2685 | 2182 | 3189 | 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 | Inefficient evaluation of expressions like rdb$db_key <= ? after mass delete |
|
53 | SS | 1865 | 2099 | 1631 | 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 | Inefficient evaluation of expressions like rdb$db_key <= ? after mass delete |
|
54 | CS | 727 | 872 | 1138 | 0 | 611 | 640 | 700 | 811 | 727 | 0 | 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 |
|
55 | SS | 378 | 497 | 527 | 0 | 378 | 312 | 336 | 367 | 471 | 0 | 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 |
|
56 | CS | 783 | 861 | 1080 | 0 | 640 | 665 | 787 | 783 | 758 | 0 | 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 |
|
57 | SS | 400 | 492 | 522 | 0 | 361 | 316 | 347 | 400 | 410 | 0 | 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 |
|
58 | CS | 726 | 821 | 1080 | 0 | 636 | 633 | 726 | 716 | 734 | 0 | 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 |
|
59 | SS | 358 | 554 | 529 | 0 | 358 | 337 | 351 | 349 | 452 | 0 | 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 |
|
60 | CS | 746 | 889 | 1080 | 0 | 670 | 653 | 746 | 742 | 761 | 0 | 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 |
|
61 | SS | 363 | 479 | 528 | 0 | 363 | 338 | 323 | 361 | 466 | 0 | 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 |
|
62 | CS | 690 | 884 | 547 | 0 | 600 | 601 | 720 | 692 | 690 | 0 | 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) |
|
63 | SS | 362 | 505 | 397 | 0 | 338 | 320 | 340 | 362 | 406 | 0 | 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) |
|
64 | CS | 742 | 839 | 621 | 0 | 633 | 611 | 742 | 759 | 757 | 0 | 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) |
|
65 | SS | 412 | 501 | 412 | 0 | 326 | 332 | 533 | 534 | 389 | 0 | 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) |
|
66 | CS | 558 | 718 | 433 | 0 | 440 | 525 | 607 | 596 | 558 | 0 | 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) |
|
67 | SS | 343 | 462 | 343 | 0 | 250 | 237 | 427 | 400 | 312 | 0 | 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) |
|
68 | CS | 701 | 894 | 564 | 0 | 613 | 637 | 704 | 754 | 701 | 0 | 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) |
|
69 | SS | 399 | 506 | 388 | 0 | 354 | 319 | 490 | 564 | 399 | 0 | 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) |
|
70 | CS | 579 | 791 | 466 | 0 | 403 | 532 | 599 | 589 | 579 | 0 | 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 |
|
71 | SS | 302 | 456 | 250 | 0 | 241 | 241 | 439 | 485 | 302 | 0 | 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 |
|
72 | CS | 9292 | 9011 | 9791 | 0 | 9189 | 9123 | 9395 | 10681 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Characters are garbled when replicating fields with type BLOB SUB_TYPE TEXT if the character set of the connection and the field are different |
|
73 | SS | 9607 | 10252 | 9752 | 0 | 8322 | 9463 | 9363 | 10454 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Characters are garbled when replicating fields with type BLOB SUB_TYPE TEXT if the character set of the connection and the field are different |
|
74 | CS | 29533 | 29473 | 31459 | 0 | 29076 | 29223 | 29533 | 29842 | 29697 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | External Connections Pool, functionality test 01 |
|
75 | CS | 1615 | 1660 | 2333 | 0 | 1290 | 1443 | 1558 | 1615 | 1640 | 0 | 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 |
|
76 | SS | 894 | 1203 | 1342 | 0 | 894 | 822 | 867 | 872 | 1101 | 0 | 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 |