01. Total results for each kind of outcome and server mode, for previous 35 runs
02. NEW CRASHES/BUGCHECKS: tests that caused FB abnormal termination for LAST run (2 rows)
03. NEW FAILS: tests which failed for LAST run (1 rows)
04. NEW ERRORS: tests which raised runtime error for LAST run (0 rows)
04. STILL FAILS: tests which fail for at least TWO LAST runs (24 rows)
05. NEW SLOWDOWN: tests with performance problem for LAST 5 runs (2 rows)
06. STILL SLOWDOWN: tests with performance problem for MORE THAN 5 last runs (8 rows)
[CURRENT] 07. Has fails: tests with at least one fail for previous 35 runs (85 rows)
08. Has runtime errors: tests with at least one runtime error for previous 35 runs (806 rows)
09. Has crashes/bugchecks: tests that caused FB abnormal termination for previous 35 runs (2 rows)
10. NEW PASSED: successful tests for last run and outcome = FAIL/ERROR/SKIPPED or absent previously (0 rows)
11. All tests: outcomes for previous 35 runs (3668 rows)
12. Skipped: tests which was intentionally excluded from execution (262 rows)

Generated UTC 01.09.2025 06:39
Tested: HQ50.   Build / date: 5.0.3.1683-4515fe09 / 2025.08.29;
Test machine: Windows 10 10.0.19045; logical CPUs: 8; RAM: 31 Gb 
QA software: Python: 3.11.2; pytest: 7.4.4; firebird.driver: 1.10.9; firebird.Qa: 0.19.3 
Jump to the list of unique test names from this report
Jump to the list with last developing commits information

Test with at least one result = "FAIL" for last 35 runs:

NN Test name mode
5.0.3.1683
2025.08.29
5.0.3.1683
2025.08.19
5.0.3.1683
2025.08.18
5.0.3.1683
2025.07.28
5.0.3.1683
2025.07.21
5.0.3.1683
2025.07.15
5.0.3.1674
2025.06.27
5.0.3.1657
2025.06.26
5.0.3.1657
2025.06.20
5.0.3.1657
2025.06.19
5.0.3.1657
2025.06.11
5.0.3.1657
2025.06.10
5.0.3.1656
2025.06.05
5.0.3.1656
2025.05.20
5.0.3.1652
2025.05.13
5.0.3.1651
2025.05.08
5.0.3.1651
2025.05.04
5.0.3.1651
2025.04.30
5.0.3.1650
2025.04.30
5.0.3.1650
2025.04.28
5.0.3.1649
2025.04.21
5.0.3.1648
2025.04.18
5.0.3.1635
2025.04.03
5.0.3.1635
2025.03.31
5.0.3.1633
2025.03.28
5.0.3.1633
2025.03.27
5.0.3.1631
2025.03.25
5.0.3.1631
2025.03.21
5.0.3.1629
2025.03.18
5.0.3.1628
2025.03.14
5.0.3.1627
2025.02.26
5.0.3.1624
2025.02.25
5.0.2.1615
2025.02.20
5.0.2.1615
2025.02.14
5.0.2.1577
2025.02.07
Test TITLE
1 CS P P P P P P P F F P P P P P P P P P P P P P P P P P P P P P P P P P P
CREATE VIEW ignores PLAN
2 SS P P P P P P P F F P P P P P P P P P P P P P P P P P P P P P P P P P P
CREATE VIEW ignores PLAN
3 CS F F F F P F F F F F F F F F F F F F F P P F F F F F P P F F P F F F P
Compress Data over the Network
4 SS F P P P P F P P P P P P P P P P P P F P F P P F P F P F P P P F P P P
Compress Data over the Network
5 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P F
Improve sorting performance when long VARCHARs are involved
6 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P F
Improve sorting performance when long VARCHARs are involved
7 CS F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
8 SS F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
9 CS P P P P P P P P F P P P P P P P P P P P P P P P P P P P P P P P P P P
Error "connection lost to database" could happen when application creates few local attachments (using XNET) simultaneously
10 CS P P P P P P F P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Regression in FB 4.x: error "Implementation of text subtype <NNNN> not located" on attempt to use some collations defined in fbintl.conf
11 SS P P P P P P F P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Regression in FB 4.x: error "Implementation of text subtype <NNNN> not located" on attempt to use some collations defined in fbintl.conf
12 CS P P P P P P P P P P P P P P P P P P P P P P P P P F F F F F F F F F P
Memory leak when running EXECUTE STATEMENT with named parameters [CORE6475]
13 SS P P P P P P P P P P P P P P P P P P P P P P P P P F F F F F F F F F P
Memory leak when running EXECUTE STATEMENT with named parameters [CORE6475]
14 SS F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F
Events in system attachments (like garbage collector) are not traced
15 CS P P P P P P P P P P P P P P P P P P P P P P F X X X X X X X X X X X X
Unnest IN/ANY/EXISTS subqueries and optimize them using semi-join algorithm
16 SS P P P P P P P P P P P P P P P P P P P P P P F X X X X X X X X X X X X
Unnest IN/ANY/EXISTS subqueries and optimize them using semi-join algorithm
17 CS P P P P P P P P P P P P P P P P P P P P P P P P P F F F F F F F F F P
Memory leak when executing a lot of different queries and StatementTimeout > 0
18 SS P P P P P P P P P P P P P P P P P P P P P P P P P F F F F F F F F F P
Memory leak when executing a lot of different queries and StatementTimeout > 0
19 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P F
Plan/Performance regression when using special construct for IN in FB5.x compared to FB3.x
20 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P F
Plan/Performance regression when using special construct for IN in FB5.x compared to FB3.x
21 CS P P P P P P P 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 X X
IN predicate incorrectly handles single parenthesized subquery as IN-list, instead of table subquery
22 SS P P P P P P P 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 X X
IN predicate incorrectly handles single parenthesized subquery as IN-list, instead of table subquery
23 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P F
SIGSEGV in Firebird 5.0.0.1306 embedded during update on cursor
24 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P F
SIGSEGV in Firebird 5.0.0.1306 embedded during update on cursor
25 CS F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F
gbak on Classic with ParallelWorkers > 1 doesn't restore indices, giving a cryptic error message
26 SS P P P P P P P P P P P P P P P E E E E E E P E E E E P P P P P P P P F
Report unique usernames for isc_info_user_names
27 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P F
Make Trace use HEX representation for parameter values of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY
28 SS P P P P P P P P P P P P P P P E E E E E E P E E E E P P P P P P P P F
Make Trace use HEX representation for parameter values of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY
29 CS F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F
Crash when creating index on table that uses UDR and ParallelWorkers > 1
30 SS F F F F F F F F F F F F F F F E E E E E E F E E E E F F F F F F F F F
Crash when creating index on table that uses UDR and ParallelWorkers > 1
31 SS P P P P P P P P P P P P P P P F F F F F F P F F F F P P P P P P P P F
gbak: Incorrect total statistics for restore
32 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P F
Make Trace use HEX representation for parameter values of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY
33 SS P P P P P P P P P P P P P P P E E E E E E P E E E E P P P P P P P P F
Make Trace use HEX representation for parameter values of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY
34 CS P P P P P P P P F P P P P P P P P P P P P P P P P P P P P P P P X X X
Add pointers tree to TempSpace class
35 SS P P P P P P P P P P P P P P P E E E E E E P E E E E P P P P P P F X X
Segfault when already destroyed callback interface is used
36 CS X X X X X X X X X X X X X X X X X X X X X P P P P P P P P P P P F X X
Segmentation fault when running query with partition by and subquery
37 CS P P P P P P P P P P P P P P P P P P P P P P F F F F F F F F F X X X X
A user with "GRANT_REVOKE_ON_ANY_OBJECT" privilege can't revoke a role from himself if he is not a grantor
38 SS P P P P P P P P P P P P P P P E E E E E E P E E E E F F F F F X X X X
A user with "GRANT_REVOKE_ON_ANY_OBJECT" privilege can't revoke a role from himself if he is not a grantor
39 CS P P P P P P P P P P P P P P P P P P P P P P F F F F F F X X X X X X X
Inheritance of WINDOW does not work
40 SS P P P P P P P P P P P P P P P E E E E E E P E E E E F F X X X X X X X
Inheritance of WINDOW does not work
41 CS S S S S S S S S S S S S S S S S S S S S S P F F X X X X X X X X X X X
Segfault/AV on incorrect databases.conf starting with subconfig (without line alias=database_path)
42 CS P P P P P P P P P P P P P P P P P P P P P P F X X X X X X X X X X X X
Conversion Error with old.field in UPDATE OR INSERT
43 CS P P P P P P P P P P P P P P P P P P P P P P F X X X X X X X X X X X X
Makes MON$COMPILED_STATEMENTS and MON$STATEMENTS share blobs with text and plan content of the same statement
44 CS P P P P P P P 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 X
PERCENT_RANK may return NaN instead of 0
45 SS P P P P P P P 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 X
PERCENT_RANK may return NaN instead of 0
46 CS P P P P P P P 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 X
Presence of 'ROWS <n_limit>' causes garbage in error message when string conversion problem raises
47 SS P P P P P P P 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 X
Presence of 'ROWS <n_limit>' causes garbage in error message when string conversion problem raises
48 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 X X X X X
AV when ON CONNECT triggers uses EXECUTE STATEMENT ON EXTERNAL
49 CS 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 X X X X X X X X
TRANSACTION_ROLLBACK missing in the trace log when appropriate DB-level trigger fires
50 SS 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 X X X X X X X X
TRANSACTION_ROLLBACK missing in the trace log when appropriate DB-level trigger fires
51 CS 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 X X X X X X X X
SHOW DEPENDENCIES command terminates unexpectedly if there are packages in the dependencies
52 SS 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 X X X X X X X X
SHOW DEPENDENCIES command terminates unexpectedly if there are packages in the dependencies
53 CS 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 X X X X X X X X X
Error unable to allocate memory from operating system
54 CS F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F
ORDER BY ASC using index (multi)
55 SS F F F F F F E F F F F F F F F E E E E E E F E E E E F F F F F F E F F
ORDER BY ASC using index (multi)
56 CS F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F
ORDER BY ASC using index (multi)
57 SS F F F F F F E F F F F F F F F E E E E E E F E E E E F F F F F F E F F
ORDER BY ASC using index (multi)
58 CS F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F
ORDER BY ASC using index (multi) and WHERE clause
59 SS F F F F F F E F F F F F F F F E E E E E E F E E E E F F F F F F E F F
ORDER BY ASC using index (multi) and WHERE clause
60 CS F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F
ISQL - SHOW SYSTEM TABLES
61 SS F F F F F F E F F F F F F F F E E E E E E F E E E E F F F F F F E F F
ISQL - SHOW SYSTEM TABLES
62 SS P P P P P P F P P P P P P P P F F F F F F P F F F F P P P P P P F P P
Add REPLICA MODE to the output of the isql SHOW DATABASE command
63 SS P P P P P P F P P P P P P P P F F F F F F P F F F F P P P P P P F P P
ISQL showing publication status
64 CS P P P P P P P P P P P P P P P P P P P P P P F F X X X X X X X X X X X
Ability to read same blob_id using multiple cursors
65 CS P P P P P P P P P P P P P P P P P P P P P P F F X X X X X X X X X X X
Operations with inline streamed blobs when boundary values are used for seek() and read() methods.
66 SS P P P P P P F P P P P P P P P F F F F F F P F F F F P P P P P P F P P
Characters are garbled when replicating fields with type BLOB SUB_TYPE TEXT if the character set of the connection and the field are different
67 SS P P P P P P F P P P P P P P P F F F F F F P F F F F P P P P P P F P P
Error "BLOB is not found" while replication converts INSERT into UPDATE for a conflicting record
68 SS P P P P P P F P P P P P P P P F F F F F F P F F F F P P P P P P F P P
Problem with replication of BLOB segments longer than 32KB
69 SS P P P P P P F P P P P P P P P F F F F F F P F F F F P P P P P P F P P
Replica DB must not fire DB-level triggers but their activity on master must be eventually seen in replica
70 SS P P P P P P F P P P P P P P P F F F F F F P F F F F P P P P P P F P P
DDL-triggers must fire only on master DB
71 SS P P P P P P F P P P P P P P P F F F F F F P F F F F P P P P P P F P P
Disallow replication of RDB$BACKUP_HISTORY
72 SS P P P P P P F P P P P P P P P F F F F F F P F F F F P P P P P P F P P
Conflicting INSERT propagated into a read-write replica may cause duplicate records to appear
73 SS P P P P P P F P P P P P P P P F F F F F F P F F F F P P P P P P F P P
Failed DDL commands can be replicated
74 SS P P P P P P F P P P P P P P P F F F F F F P F F F F P P P P P P F P P
Generator values may not replicate after commit
75 SS P P P P P P F P P P P P P P P F F F F F F P F F F F P P P P P P F P P
Invalid message in replication.log (and possibly crash in the case of synchronous replication) when the target DB has no its "replica" flag set
76 CS F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F
Make asynchronous replica re-initialization reliable #8324
77 SS F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F
Make asynchronous replica re-initialization reliable #8324
78 SS P P P P P P F P P P P P P P P F F F F F F P F F F F P P P P P P F P P
Applying full DDL from OLTP-EMUL test on master with further check replica
79 SS P P P P P P F P P P P P P P P F F F F F F P F F F F P P P P P P F P P
Crash or hang while shutting down the replica database if segments are being applied
80 SS P P P P P P F P P P P P P P P F F F F F F P F F F F P P P P P P F P P
Some updates can crash Firebird server on replica side
81 SS P P P P P P F P P P P P P P P F F F F F F P F F F F P P P P P P F P P
Replication gets stuck due to "Blob xxx.xx is not found for table xxx" error
82 CS F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F
Change error by warning in the case when isc_dpb_parallel_workers value is not at valid range
83 SS F F F F F F E F F F F F F F F E E E E E E F E E E E F F F F F F E F F
Change error by warning in the case when isc_dpb_parallel_workers value is not at valid range
84 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P F
Allow computable but non-invariant lists to be used for index lookup
85 SS P P P P P P E P P P P P P P P E E E E E E P E E E E P P P P P P E P F
Allow computable but non-invariant lists to be used for index lookup

Elapsed time, milliseconds:

NN Test name mode median_ms
5.0.3.1683
2025.08.29
5.0.3.1683
2025.08.19
5.0.3.1683
2025.08.18
5.0.3.1683
2025.07.28
5.0.3.1683
2025.07.21
5.0.3.1683
2025.07.15
5.0.3.1674
2025.06.27
5.0.3.1657
2025.06.26
5.0.3.1657
2025.06.20
5.0.3.1657
2025.06.19
5.0.3.1657
2025.06.11
5.0.3.1657
2025.06.10
5.0.3.1656
2025.06.05
5.0.3.1656
2025.05.20
5.0.3.1652
2025.05.13
5.0.3.1651
2025.05.08
5.0.3.1651
2025.05.04
5.0.3.1651
2025.04.30
5.0.3.1650
2025.04.30
5.0.3.1650
2025.04.28
5.0.3.1649
2025.04.21
5.0.3.1648
2025.04.18
5.0.3.1635
2025.04.03
5.0.3.1635
2025.03.31
5.0.3.1633
2025.03.28
5.0.3.1633
2025.03.27
5.0.3.1631
2025.03.25
5.0.3.1631
2025.03.21
5.0.3.1629
2025.03.18
5.0.3.1628
2025.03.14
5.0.3.1627
2025.02.26
5.0.3.1624
2025.02.25
5.0.2.1615
2025.02.20
5.0.2.1615
2025.02.14
5.0.2.1577
2025.02.07
Test TITLE
1 CS 685 753 748 774 785 751 752 744 1021 1038 664 693 681 666 662 661 667 710 660 683 655 666 736 658 661 668 691 673 673 1041 695 685 727 689 684 672
CREATE VIEW ignores PLAN
2 SS 469 485 495 526 487 499 500 480 827 787 445 440 487 433 441 439 441 463 454 452 444 469 458 439 449 454 469 492 476 474 455 564 477 493 455 480
CREATE VIEW ignores PLAN
3 CS 16970 16970 16837 16656 16630 17536 17126 16810 17048 16507 16816 17075 16766 17487 16823 16519 16559 17308 16624 16966 16304 16353 16455 16787 16977 17080 17338 16997 17108 19684 17369 17187 17231 17656 16996 16698
Compress Data over the Network
4 SS 16095 16164 15872 16032 15888 16177 16233 16199 15755 16112 16095 16448 15768 16109 16596 15795 15703 16228 15270 15916 15448 16508 15409 16190 16870 16047 16003 19744 17154 16454 15619 15956 16624 16423 15796 15656
Compress Data over the Network
5 CS 771 761 753 744 778 761 767 752 782 780 760 752 752 803 785 749 754 753 797 756 790 766 760 807 790 799 888 804 821 771 805 792 826 756 766 1140
Improve sorting performance when long VARCHARs are involved
6 SS 465 459 470 466 461 448 464 462 455 467 452 451 458 458 465 474 455 454 459 457 449 488 470 466 469 465 514 512 463 476 469 522 510 463 506 847
Improve sorting performance when long VARCHARs are involved
7 CS 1497 1480 1499 1522 1489 1919 1454 1706 1460 1455 1477 1461 1492 1468 1474 1451 1469 1519 1533 1506 1845 1803 1465 1476 1497 1514 1515 1841 1826 1570 1536 1917 1483 1506 1354 1474
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
8 SS 1073 919 1314 1222 1236 1444 724 1287 959 913 1030 1030 1014 1020 1190 1234 1433 1183 1228 826 1249 999 1239 1234 921 1315 771 1131 1203 1032 1063 1150 762 1037 1073 743
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
9 CS 3427 3427 3471 3636 3339 3563 3980 3506 3391 3400 3596 3427 3672 3610 3353 3723 3679 3470 3237 3274 3307 3359 3247 3294 3292 3339 3437 3469 3661 3344 3354 3317 3375 3582 3283 3455
Error "connection lost to database" could happen when application creates few local attachments (using XNET) simultaneously
10 CS 22604 4259 4250 4168 4192 4254 4484 807 22516 24464 22404 22599 22682 22671 22325 22236 22899 22622 22583 22284 22348 22616 22493 22310 22604 22636 23598 23080 23733 22943 22921 23571 23657 22632 22673 22686
Regression in FB 4.x: error "Implementation of text subtype <NNNN> not located" on attempt to use some collations defined in fbintl.conf
11 SS 13495 3860 3913 3811 3855 3871 3848 478 13321 13264 13495 13307 14051 13257 13192 13184 13359 13352 13335 14286 13573 13709 13538 13365 14397 14311 14518 14977 15409 15092 13935 14636 14746 13852 14520 13910
Regression in FB 4.x: error "Implementation of text subtype <NNNN> not located" on attempt to use some collations defined in fbintl.conf
12 CS 17649 17486 17366 17530 17269 17334 18042 17523 17352 17391 17649 17528 17693 17993 17746 17501 17473 17440 17384 17385 17457 17665 17785 17814 17604 17901 18623 19247 18842 18861 18974 18645 18534 18494 18221 17644
Memory leak when running EXECUTE STATEMENT with named parameters [CORE6475]
13 SS 17608 17421 17292 17498 17109 17465 17342 17690 17227 17282 17683 17548 17570 17863 17311 17410 17817 17394 17486 18016 17643 17523 17558 17699 17551 17608 19629 18782 18818 18790 18849 18777 18706 18344 18300 17653
Memory leak when running EXECUTE STATEMENT with named parameters [CORE6475]
14 SS 304 325 523 291 310 535 285 304 293 287 295 522 578 530 288 292 285 302 291 331 295 302 297 298 325 318 413 325 328 291 571 326 324 295 429 301
Events in system attachments (like garbage collector) are not traced
15 CS 894 901 891 893 884 917 952 881 874 893 931 893 938 915 877 895 897 905 887 879 911 900 894 864 0 0 0 0 0 0 0 0 0 0 0 0
Unnest IN/ANY/EXISTS subqueries and optimize them using semi-join algorithm
16 SS 656 645 664 645 669 644 662 669 654 647 651 645 656 649 663 637 674 687 660 687 639 669 656 613 0 0 0 0 0 0 0 0 0 0 0 0
Unnest IN/ANY/EXISTS subqueries and optimize them using semi-join algorithm
17 CS 18532 18548 18515 18544 18531 18532 18573 18521 18530 18521 18552 18535 18529 18540 18513 18525 18524 18523 18527 18525 18525 18521 18531 18530 18557 18530 18882 18905 18921 18920 18895 18909 18799 18915 18956 18538
Memory leak when executing a lot of different queries and StatementTimeout > 0
18 SS 18289 18278 18298 18286 18284 18278 18281 18289 18288 18283 18292 18288 18292 18283 18288 18279 18294 18285 18282 18320 18286 18289 18293 18283 18292 18296 18717 18818 18666 18788 18541 18764 19228 18871 18783 18283
Memory leak when executing a lot of different queries and StatementTimeout > 0
19 CS 1390 1382 1376 1393 1397 1369 1513 1396 1392 1376 1420 1375 1398 1453 1374 1394 1366 1371 1397 1374 1361 1392 1376 1361 1377 1388 1429 1454 1413 1441 1377 1418 1427 1378 1375 1390
Plan/Performance regression when using special construct for IN in FB5.x compared to FB3.x
20 SS 1101 1077 1113 1102 1091 1086 1101 1129 1079 1084 1102 1094 1077 1113 1083 1093 1117 1118 1088 1112 1079 1102 1172 1066 1101 1133 1152 1154 1126 1081 1078 1098 1130 1090 1099 1111
Plan/Performance regression when using special construct for IN in FB5.x compared to FB3.x
21 CS 587 579 577 607 581 587 616 589 609 580 638 582 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 incorrectly handles single parenthesized subquery as IN-list, instead of table subquery
22 SS 387 379 389 382 381 388 379 374 392 387 394 394 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 incorrectly handles single parenthesized subquery as IN-list, instead of table subquery
23 CS 688 682 683 669 680 685 736 705 681 679 709 679 688 660 685 686 702 682 675 680 674 705 673 666 694 723 728 733 719 691 726 745 741 693 690 706
SIGSEGV in Firebird 5.0.0.1306 embedded during update on cursor
24 SS 456 451 440 465 449 450 447 470 448 453 449 449 450 457 456 454 451 450 451 490 445 459 456 449 466 504 497 505 477 457 467 468 514 455 477 485
SIGSEGV in Firebird 5.0.0.1306 embedded during update on cursor
25 CS 1065 1041 1304 1034 1031 1077 1097 1056 1050 1040 1022 1026 1098 1068 1065 1032 1047 1041 1034 1033 1103 1084 1041 1063 1070 1077 1076 1078 1390 1044 1031 1089 1148 1069 1072 1092
gbak on Classic with ParallelWorkers > 1 doesn't restore indices, giving a cryptic error message
26 SS 895 853 849 862 870 851 856 850 850 868 863 877 860 872 850 850 2391 2402 2380 2415 2390 2408 911 2395 2412 2239 2258 1212 981 891 881 944 898 895 903 900
Report unique usernames for isc_info_user_names
27 CS 2942 2916 2932 3055 2927 2989 3084 2924 3156 2921 3359 2910 2966 2918 2912 2930 3009 2899 2912 2946 2913 2942 2936 2978 2919 2953 2981 2955 2952 2927 2915 3314 2948 2999 2925 2958
Make Trace use HEX representation for parameter values of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY
28 SS 2672 2677 2680 2687 2672 2655 2663 2685 2665 2673 2676 2674 2666 2675 2668 2672 2227 2242 2386 2397 2397 2238 2682 2400 2246 2380 2427 2744 2699 2675 2674 2859 2678 2675 2669 2993
Make Trace use HEX representation for parameter values of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY
29 CS 1094 1096 1073 1083 1054 1075 1105 1113 1074 1069 1100 1062 1120 1111 1066 1057 1122 1095 1093 1092 1101 1102 1109 1109 1104 1094 1133 1094 1108 1079 1115 1089 1084 1094 1089 1094
Crash when creating index on table that uses UDR and ParallelWorkers > 1
30 SS 870 857 866 869 847 841 852 900 851 845 840 841 871 860 839 844 2390 2388 2392 2235 2405 2382 839 2402 2418 2391 2416 925 877 886 842 887 857 868 1113 870
Crash when creating index on table that uses UDR and ParallelWorkers > 1
31 SS 2747 2830 2882 2774 2706 2863 2441 2672 2730 2671 2539 2665 2803 2618 2630 2675 2929 3080 3020 3050 2969 2894 2593 3042 3127 3309 3026 2748 2678 2718 2747 2569 2415 2587 2793 2644
gbak: Incorrect total statistics for restore
32 CS 1217 1210 1223 1207 1230 1234 1251 1216 1199 1183 1185 1226 1185 1249 1208 1189 1200 1221 1219 1208 1186 1196 1217 1195 1226 1215 1309 1245 1287 1202 1193 1274 1238 1221 1241 1230
Make Trace use HEX representation for parameter values of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY
33 SS 937 909 934 953 925 1030 927 916 933 907 911 913 914 914 903 928 2377 2381 2393 2383 2400 2387 939 2412 2384 2377 2438 975 971 935 920 960 917 937 927 951
Make Trace use HEX representation for parameter values of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY
34 CS 23365 23147 22903 22810 22301 23313 23234 22633 23219 23628 23250 23563 23224 23417 23527 22402 22798 23105 22300 23092 22523 25280 25108 24830 25889 24787 25934 25485 25661 25650 25662 25625 25044 0 0 0
Add pointers tree to TempSpace class
35 SS 2101 2053 2086 2072 2080 2079 2063 2067 2088 2072 2079 2079 2082 2062 2096 2057 2396 2413 2236 2405 2235 2445 2113 2398 2399 2400 2426 2173 2268 2214 2113 2253 2101 1393 0 0
Segfault when already destroyed callback interface is used
36 CS 610 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 590 589 616 608 656 622 612 600 589 646 593 2022 0 0
Segmentation fault when running query with partition by and subquery
37 CS 1699 1691 1702 1653 1648 1773 1763 1649 1715 1649 1864 1672 1776 1687 1683 1644 1671 1663 1729 1640 1656 1694 1663 1699 1704 1704 1778 1757 1782 1727 1725 1768 0 0 0 0
A user with "GRANT_REVOKE_ON_ANY_OBJECT" privilege can't revoke a role from himself if he is not a grantor
38 SS 982 957 962 947 940 953 959 963 942 939 942 948 957 939 940 945 2408 2414 2375 2406 2393 2431 982 2440 2251 2234 2449 1072 1090 1070 982 1067 0 0 0 0
A user with "GRANT_REVOKE_ON_ANY_OBJECT" privilege can't revoke a role from himself if he is not a grantor
39 CS 609 591 613 609 613 612 642 588 609 586 650 591 590 591 602 580 590 612 583 580 611 581 595 633 632 641 651 620 660 0 0 0 0 0 0 0
Inheritance of WINDOW does not work
40 SS 390 371 376 380 377 379 392 390 386 383 374 379 381 383 378 382 2238 2238 2390 2240 2403 2236 390 2273 2394 2391 2444 415 432 0 0 0 0 0 0 0
Inheritance of WINDOW does not work
41 CS 1 1 2 1 2 1 2 1 2 1 1 2 1 1 1 1 1 1 1 2 1 1 452 3013 1820 0 0 0 0 0 0 0 0 0 0 0
Segfault/AV on incorrect databases.conf starting with subconfig (without line alias=database_path)
42 CS 606 589 624 609 598 607 635 606 610 600 654 608 622 578 613 585 587 592 574 583 575 604 622 635 0 0 0 0 0 0 0 0 0 0 0 0
Conversion Error with old.field in UPDATE OR INSERT
43 CS 593 587 615 575 574 606 649 601 593 579 620 576 600 608 571 584 575 580 577 600 602 616 590 625 0 0 0 0 0 0 0 0 0 0 0 0
Makes MON$COMPILED_STATEMENTS and MON$STATEMENTS share blobs with text and plan content of the same statement
44 CS 599 599 583 589 586 667 671 578 620 600 615 583 593 616 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PERCENT_RANK may return NaN instead of 0
45 SS 390 381 395 374 396 375 374 373 392 390 391 396 401 387 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PERCENT_RANK may return NaN instead of 0
46 CS 611 584 592 624 613 616 667 613 609 606 610 618 590 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Presence of 'ROWS <n_limit>' causes garbage in error message when string conversion problem raises
47 SS 391 393 388 393 380 375 371 397 393 390 392 393 388 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Presence of 'ROWS <n_limit>' causes garbage in error message when string conversion problem raises
48 CS 1220 1213 1220 1216 1234 1284 931 4403 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
AV when ON CONNECT triggers uses EXECUTE STATEMENT ON EXTERNAL
49 CS 2940 2927 2960 2924 2917 2953 3024 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
TRANSACTION_ROLLBACK missing in the trace log when appropriate DB-level trigger fires
50 SS 2680 2677 2670 2671 2690 2907 2683 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
TRANSACTION_ROLLBACK missing in the trace log when appropriate DB-level trigger fires
51 CS 2135 2135 3029 2066 1815 33727 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 0
SHOW DEPENDENCIES command terminates unexpectedly if there are packages in the dependencies
52 SS 2975 3000 2113 3041 2975 2112 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 0
SHOW DEPENDENCIES command terminates unexpectedly if there are packages in the dependencies
53 CS 6973 6948 6776 6999 7149 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 0 0
Error unable to allocate memory from operating system
54 CS 838 693 693 680 685 680 746 695 852 807 843 834 843 849 832 811 838 853 840 885 844 855 831 828 856 867 1108 840 853 833 843 849 894 828 810 831
ORDER BY ASC using index (multi)
55 SS 581 457 461 453 445 446 453 2410 535 551 537 525 548 569 775 555 2400 2384 2398 2256 2412 2398 566 2229 2393 2401 2429 576 611 611 558 584 581 2405 682 571
ORDER BY ASC using index (multi)
56 CS 842 690 687 711 686 690 737 719 851 833 848 833 843 817 797 812 829 847 833 844 868 849 816 850 851 858 916 856 854 836 844 889 898 851 833 842
ORDER BY ASC using index (multi)
57 SS 595 692 455 455 458 465 443 2397 531 542 567 548 555 529 526 549 2230 2237 2235 2395 2383 2233 562 2410 2419 2404 2436 597 609 595 559 604 570 2239 613 561
ORDER BY ASC using index (multi)
58 CS 640 714 732 683 700 715 721 703 655 600 631 640 662 604 598 627 643 637 621 642 623 878 632 637 649 628 716 668 629 594 629 619 642 647 615 599
ORDER BY ASC using index (multi) and WHERE clause
59 SS 454 454 456 461 455 443 456 2400 379 401 409 393 393 623 416 392 2405 2391 2399 2224 2409 2396 400 2244 2388 2413 2265 411 426 426 399 436 438 2401 420 415
ORDER BY ASC using index (multi) and WHERE clause
60 CS 620 586 608 589 577 573 623 630 678 642 611 617 671 620 609 587 620 644 634 625 627 644 594 624 666 633 677 626 615 597 586 615 658 875 589 589
ISQL - SHOW SYSTEM TABLES
61 SS 426 395 393 388 391 396 393 2407 379 397 379 379 649 406 426 414 2391 2237 2245 2427 2405 2239 406 2229 2229 2425 2431 431 443 422 405 429 425 2235 524 414
ISQL - SHOW SYSTEM TABLES
62 SS 371 372 370 313 297 371 311 2097 300 312 309 301 360 365 287 296 2085 2094 2082 2081 2081 2078 311 2082 2080 2091 2336 393 381 380 359 377 313 2076 371 356
Add REPLICA MODE to the output of the isql SHOW DATABASE command
63 SS 158 157 157 160 158 157 157 2076 158 155 156 155 159 157 157 156 2074 2080 2081 2090 2077 2076 157 2075 2071 2077 2120 157 173 154 156 155 156 2077 158 159
ISQL showing publication status
64 CS 779 772 786 801 766 796 808 771 808 802 816 776 814 792 761 770 776 777 773 766 776 782 774 1390 1387 0 0 0 0 0 0 0 0 0 0 0
Ability to read same blob_id using multiple cursors
65 CS 879 879 857 884 880 860 880 883 894 879 935 883 925 879 850 848 859 892 851 844 841 889 892 871 855 0 0 0 0 0 0 0 0 0 0 0
Operations with inline streamed blobs when boundary values are used for seek() and read() methods.
66 SS 8686 9688 9677 8685 8711 8674 9638 2435 9697 9707 8686 9689 8692 8687 8661 9651 2209 2211 2205 2377 2396 2432 8717 2210 2399 2194 2438 9291 8631 9544 8769 8759 8903 2394 8548 9701
Characters are garbled when replicating fields with type BLOB SUB_TYPE TEXT if the character set of the connection and the field are different
67 SS 9036 8911 9016 9975 10070 10046 8980 2228 8944 9036 9991 9103 9267 10019 9911 8992 2387 2389 2387 2396 2196 2401 9988 2382 2208 2401 2405 9057 9149 9112 10217 10029 9138 2200 9040 9127
Error "BLOB is not found" while replication converts INSERT into UPDATE for a conflicting record
68 SS 6398 6426 6435 6385 6362 6628 6447 2384 6543 6477 6398 6441 6519 6529 6424 6508 2207 2198 2209 2193 2382 2203 5458 2397 2421 2198 2437 7077 6925 7428 5406 5817 6527 2372 6419 6422
Problem with replication of BLOB segments longer than 32KB
69 SS 6138 6182 6256 6131 6142 6143 6197 2203 6190 6143 6125 6143 6179 6175 6122 6134 2395 2376 2380 2390 2212 2395 6174 2200 2214 2388 2210 5231 6218 6225 6176 6177 6446 2200 6138 6201
Replica DB must not fire DB-level triggers but their activity on master must be eventually seen in replica
70 SS 6327 6302 6414 6313 6357 6312 6323 2614 6381 6337 6327 6328 6336 7396 6323 7330 2419 2406 2404 2202 2385 2413 7354 2391 2374 2395 2420 7422 6411 7475 7347 6413 6404 2388 7398 6368
DDL-triggers must fire only on master DB
71 SS 8586 6430 9336 9819 8693 9499 5975 2399 9024 6602 6653 9011 12228 9005 9344 8904 2205 2216 2193 2381 2396 2209 8710 2225 2380 2226 2217 8661 8586 8762 8671 9329 9632 2406 8473 8857
Disallow replication of RDB$BACKUP_HISTORY
72 SS 8693 8693 8705 8686 9524 8538 9522 2199 9534 8657 8530 9532 9542 9520 8711 9678 2393 2400 2403 2404 2204 2395 8710 2424 2200 2392 2403 8789 9663 8719 9740 8790 8637 2248 9580 9681
Conflicting INSERT propagated into a read-write replica may cause duplicate records to appear
73 SS 6110 6127 6127 6134 6104 6112 6116 2399 6106 6110 6116 6124 6096 6163 6126 5110 2196 2209 2199 2195 2390 2206 6130 2392 2389 2204 2193 6462 6164 6147 5260 6523 6196 2407 6132 6136
Failed DDL commands can be replicated
74 SS 6040 6043 6039 6053 6033 6041 6034 2190 6061 6038 6070 6099 6038 6056 6040 6050 2396 2395 2420 2378 2198 2433 6042 2201 2194 2387 2393 6122 6128 6097 6440 6077 6097 2199 6079 6057
Generator values may not replicate after commit
75 SS 12155 12134 12107 12108 13107 13108 13117 2203 13111 12102 13099 13140 13154 13118 12126 12220 2383 2390 2469 2390 2405 2381 12155 2207 2382 2197 2254 12172 12235 13236 13265 13556 12165 2402 13131 13142
Invalid message in replication.log (and possibly crash in the case of synchronous replication) when the target DB has no its "replica" flag set
76 CS 50859 50765 54811 47085 54026 50866 53188 53241 49923 50777 50302 53466 50652 53271 49771 50860 50349 51281 50859 50807 50807 52753 49836 52056 50861 49736 51556 50014 54476 53461 49856 50610 50918 50244 50821 53798
Make asynchronous replica re-initialization reliable #8324
77 SS 51278 53276 53241 54375 50545 53385 53207 2398 52519 53288 52629 51278 53252 50323 50224 53644 2394 2391 2387 2395 2198 2422 53263 2391 2205 2398 2392 50393 54471 50426 51374 52927 53414 2213 54560 51399
Make asynchronous replica re-initialization reliable #8324
78 SS 13893 13743 13893 13183 16277 15888 14001 2406 13727 12801 13909 14077 14371 17243 14170 13756 2206 2225 2207 2194 2384 2199 14111 2400 2395 2205 2389 14570 16587 16843 17267 16922 16760 2391 16335 16708
Applying full DDL from OLTP-EMUL test on master with further check replica
79 SS 13460 13862 13838 14306 13691 13855 13541 2402 13460 14078 13481 13748 13268 13704 13654 14269 2407 2422 2398 2411 2212 2434 13155 2385 2199 2427 2394 13196 13770 13159 13921 13837 13255 2203 14149 13544
Crash or hang while shutting down the replica database if segments are being applied
80 SS 6059 6101 6056 6065 6059 6066 6057 2213 6043 6040 6063 7075 7065 6060 6041 6076 2201 2216 2194 2207 2411 2218 7834 2198 2398 2207 2409 6132 7160 7152 7166 6158 6147 2389 6075 6078
Some updates can crash Firebird server on replica side
81 SS 6043 6043 7031 6041 6044 6043 6048 2390 6037 6047 6044 6063 6066 6036 6575 6045 2392 2396 2405 2394 2220 2404 5062 2392 2219 2391 2204 6122 6135 5659 6271 6091 7112 2202 6082 6059
Replication gets stuck due to "Blob xxx.xx is not found for table xxx" error
82 CS 1467 1449 1467 1446 1430 1423 1523 1527 1633 1425 1532 1427 1691 1452 1456 1428 1460 1456 1469 1459 1458 1560 1434 1455 1484 1506 1861 1550 1511 1550 1458 1536 1521 1461 1505 1478
Change error by warning in the case when isc_dpb_parallel_workers value is not at valid range
83 SS 1245 1253 1220 1003 1011 1276 1163 2239 983 1009 998 997 1241 1432 1242 985 2224 2221 2242 2473 2448 2239 1006 2442 2425 2433 2442 1073 1313 1355 1009 1245 1059 2422 1084 1012
Change error by warning in the case when isc_dpb_parallel_workers value is not at valid range
84 CS 699 678 711 678 672 707 707 671 706 664 708 686 690 715 664 708 711 674 702 673 670 708 693 688 681 699 717 707 713 708 718 705 719 671 680 687
Allow computable but non-invariant lists to be used for index lookup
85 SS 447 427 423 431 423 425 437 2451 419 435 421 447 423 423 418 430 2420 2437 2423 2443 2446 2422 441 2444 2424 2450 2430 478 475 447 455 447 465 2424 442 457
Allow computable but non-invariant lists to be used for index lookup

List of tests in this report:


http://tracker.firebirdsql.org/browse/CORE-203
http://tracker.firebirdsql.org/browse/CORE-2650
http://tracker.firebirdsql.org/browse/CORE-5501
http://tracker.firebirdsql.org/browse/CORE-6142
http://tracker.firebirdsql.org/browse/CORE-6336
http://tracker.firebirdsql.org/browse/CORE-733
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_sort_by_index_10.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_sort_by_index_13.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_sort_by_index_19.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/basic/isql/test_02.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/basic/isql/test_07.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/basic/isql/test_08.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/blob/test_read_blob_in_multiple_cursors.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/blob/test_small_blob_caching.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_blob_characters_garbled_when_conn_charset_differs.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_blob_not_found_in_rw_replica_if_target_row_exists.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_blob_segments_longer_32kb_are_not_replicated.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_dblevel_triggers_must_not_fire_on_replica.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_ddl_triggers_must_not_fire_on_replica.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_disallow_rdb_backup_history_replication.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_duplicates_in_rw_replica_after_conflicting_insert.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_failed_ddl_commands_can_be_replicated.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_generator_could_not_be_transferred_to_replica.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_invalid_msg_if_target_db_has_no_replica_flag.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_make_async_reinit_reliable.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_oltp_emul_ddl.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_shutdown_during_applying_segments_leads_to_crash.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_some_updates_crash_server_on_replica_side.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_updating_blob_with_empty_string_stops_replication.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_333be4bf.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_e260ced8.py
https://github.com/FirebirdSQL/firebird/issues/6706
https://github.com/FirebirdSQL/firebird/issues/7304
https://github.com/FirebirdSQL/firebird/issues/8061
https://github.com/FirebirdSQL/firebird/issues/8085
https://github.com/FirebirdSQL/firebird/issues/8109
https://github.com/FirebirdSQL/firebird/issues/8182
https://github.com/FirebirdSQL/firebird/issues/8185
https://github.com/FirebirdSQL/firebird/issues/8263
https://github.com/FirebirdSQL/firebird/issues/8353
https://github.com/FirebirdSQL/firebird/issues/8356
https://github.com/FirebirdSQL/firebird/issues/8386
https://github.com/FirebirdSQL/firebird/issues/8391
https://github.com/FirebirdSQL/firebird/issues/8394
https://github.com/FirebirdSQL/firebird/issues/8421
https://github.com/FirebirdSQL/firebird/issues/8429
https://github.com/FirebirdSQL/firebird/issues/8437
https://github.com/FirebirdSQL/firebird/issues/8462
https://github.com/FirebirdSQL/firebird/issues/8477
https://github.com/FirebirdSQL/firebird/issues/8485
https://github.com/FirebirdSQL/firebird/issues/8508
https://github.com/FirebirdSQL/firebird/issues/8513
https://github.com/FirebirdSQL/firebird/issues/8589
https://github.com/FirebirdSQL/firebird/issues/8592
https://github.com/FirebirdSQL/firebird/issues/8649
https://github.com/FirebirdSQL/firebird/issues/8653
https://github.com/FirebirdSQL/firebird/issues/8665
https://github.com/FirebirdSQL/firebird/issues/8673
=== end of list ===

Last commits information (all timestamps in UTC):