01. Total results for each kind of outcome and server mode, for previous 30 runs
02. NEW CRASHES/BUGCHECKS: tests that caused FB abnormal termination for LAST run (0 rows)
03. NEW FAILS: tests which failed for LAST run (0 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 (20 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 (4 rows)
[CURRENT] 07. Has fails: tests with at least one fail for previous 30 runs (77 rows)
08. Has runtime errors: tests with at least one runtime error for previous 30 runs (762 rows)
09. Has crashes/bugchecks: tests that caused FB abnormal termination for previous 30 runs (0 rows)
10. NEW PASSED: successful tests for last run and outcome = FAIL/ERROR/SKIPPED or absent previously (7 rows)
11. All tests: outcomes for previous 30 runs (3424 rows)
12. Skipped: tests which was intentionally excluded from execution (83 rows)

Generated UTC 28.06.2025 11:37
Tested: HQ50.   Build / date: 5.0.3.1674-3ee5cc1f / 2025.06.27;
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 30 runs:

NN Test name mode
5.0.3.1674
2025.06.27
3ee5c
5.0.3.1657
2025.06.26
dcb8a
5.0.3.1657
2025.06.20
8b4d2
5.0.3.1657
2025.06.19
4bd4c
5.0.3.1657
2025.06.11
dae6f
5.0.3.1657
2025.06.10
dbc92
5.0.3.1656
2025.06.05
00512
5.0.3.1656
2025.05.20
c4b11
5.0.3.1652
2025.05.13
f51c6
5.0.3.1651
2025.05.08
ee9d2
5.0.3.1651
2025.05.04
3d914
5.0.3.1651
2025.04.30
141ef
5.0.3.1650
2025.04.30
6253f
5.0.3.1650
2025.04.28
4cbff
5.0.3.1649
2025.04.21
5b2d0
5.0.3.1648
2025.04.18
2f4c5
5.0.3.1635
2025.04.03
f6bd1
5.0.3.1635
2025.03.31
22ec6
5.0.3.1633
2025.03.28
3123a
5.0.3.1633
2025.03.27
e0fb8
5.0.3.1631
2025.03.25
bda65
5.0.3.1631
2025.03.21
1925b
5.0.3.1629
2025.03.18
506d7
5.0.3.1628
2025.03.14
16d05
5.0.3.1627
2025.02.26
4e218
5.0.3.1624
2025.02.25
dc3b2
5.0.2.1615
2025.02.20
4a726
5.0.2.1615
2025.02.14
9cb76
5.0.2.1577
2025.02.07
f50a2
5.0.2.1577
2024.12.24
3c80e
Test TITLE
1
bugs core 0203 
 tracker
 CS F 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 P
CREATE VIEW ignores PLAN
2
bugs core 0203 
 tracker
 SS F 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 P
CREATE VIEW ignores PLAN
3
bugs core 0733 
 tracker
 CS P 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 P
Compress Data over the Network
4
bugs core 0733 
 tracker
 SS 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 P
Compress Data over the Network
5
bugs core 2650 
 tracker
 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 F F
Improve sorting performance when long VARCHARs are involved
6
bugs core 2650 
 tracker
 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 F F
Improve sorting performance when long VARCHARs are involved
7
bugs core 5501 
 tracker
 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
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
8
bugs core 5501 
 tracker
 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
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
9
bugs core 6142 
 tracker
 CS 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
Error "connection lost to database" could happen when application creates few local attachments (using XNET) simultaneously
10
bugs gh 6706 
 tracker
 CS 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 P
Memory leak when running EXECUTE STATEMENT with named parameters [CORE6475]
11
bugs gh 6706 
 tracker
 SS 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 P
Memory leak when running EXECUTE STATEMENT with named parameters [CORE6475]
12
bugs gh 7304 
 tracker
 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
Events in system attachments (like garbage collector) are not traced
13
bugs gh 8061 
 tracker
 CS 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 X
Unnest IN/ANY/EXISTS subqueries and optimize them using semi-join algorithm
14
bugs gh 8061 
 tracker
 SS 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 X
Unnest IN/ANY/EXISTS subqueries and optimize them using semi-join algorithm
15
bugs gh 8085 
 tracker
 CS 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 P
Memory leak when executing a lot of different queries and StatementTimeout > 0
16
bugs gh 8085 
 tracker
 SS 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 P
Memory leak when executing a lot of different queries and StatementTimeout > 0
17
bugs gh 8109 
 tracker
 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 F F
Plan/Performance regression when using special construct for IN in FB5.x compared to FB3.x
18
bugs gh 8109 
 tracker
 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 F F
Plan/Performance regression when using special construct for IN in FB5.x compared to FB3.x
19
bugs gh 8182 
 tracker
 CS 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 X
IN predicate incorrectly handles single parenthesized subquery as IN-list, instead of table subquery
20
bugs gh 8182 
 tracker
 SS 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 X
IN predicate incorrectly handles single parenthesized subquery as IN-list, instead of table subquery
21
bugs gh 8185 
 tracker
 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 F F
SIGSEGV in Firebird 5.0.0.1306 embedded during update on cursor
22
bugs gh 8185 
 tracker
 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 F F
SIGSEGV in Firebird 5.0.0.1306 embedded during update on cursor
23
bugs gh 8263 
 tracker
 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
gbak on Classic with ParallelWorkers > 1 doesn't restore indices, giving a cryptic error message
24
bugs gh 8353 
 tracker
 SS 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 F
Report unique usernames for isc_info_user_names
25
bugs gh 8356 
 tracker
 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 F F
Make Trace use HEX representation for parameter values of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY
26
bugs gh 8356 
 tracker
 SS 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 F
Make Trace use HEX representation for parameter values of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY
27
bugs gh 8386 
 tracker
 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
Crash when creating index on table that uses UDR and ParallelWorkers > 1
28
bugs gh 8386 
 tracker
 SS 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 F
Crash when creating index on table that uses UDR and ParallelWorkers > 1
29
bugs gh 8391 
 tracker
 SS 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 F
gbak: Incorrect total statistics for restore
30
bugs gh 8394 
 tracker
 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 F F
Make Trace use HEX representation for parameter values of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY
31
bugs gh 8394 
 tracker
 SS 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 F
Make Trace use HEX representation for parameter values of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY
32
bugs gh 8421 
 tracker
 CS 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 X
Add pointers tree to TempSpace class
33
bugs gh 8429 
 tracker
 SS 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 X
Segfault when already destroyed callback interface is used
34
bugs gh 8437 
 tracker
 CS 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 X
Segmentation fault when running query with partition by and subquery
35
bugs gh 8462 
 tracker
 CS 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 X
A user with "GRANT_REVOKE_ON_ANY_OBJECT" privilege can't revoke a role from himself if he is not a grantor
36
bugs gh 8462 
 tracker
 SS 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 X
A user with "GRANT_REVOKE_ON_ANY_OBJECT" privilege can't revoke a role from himself if he is not a grantor
37
bugs gh 8477 
 tracker
 CS 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 X
Inheritance of WINDOW does not work
38
bugs gh 8477 
 tracker
 SS 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 X
Inheritance of WINDOW does not work
39
bugs gh 8485 
 tracker
 CS 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 X
Segfault/AV on incorrect databases.conf starting with subconfig (without line alias=database_path)
40
bugs gh 8508 
 tracker
 CS 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 X
Conversion Error with old.field in UPDATE OR INSERT
41
bugs gh 8513 
 tracker
 CS 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 X
Makes MON$COMPILED_STATEMENTS and MON$STATEMENTS share blobs with text and plan content of the same statement
42
bugs gh 8589 
 tracker
 CS 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 X
PERCENT_RANK may return NaN instead of 0
43
bugs gh 8589 
 tracker
 SS 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 X
PERCENT_RANK may return NaN instead of 0
44
bugs gh 8592 
 tracker
 CS 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 X
Presence of 'ROWS <n_limit>' causes garbage in error message when string conversion problem raises
45
bugs gh 8592 
 tracker
 SS 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 X
Presence of 'ROWS <n_limit>' causes garbage in error message when string conversion problem raises
46
functional arno optimizer opt sort by index 10 
 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
ORDER BY ASC using index (multi)
47
functional arno optimizer opt sort by index 10 
 SS 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 E F F F
ORDER BY ASC using index (multi)
48
functional arno optimizer opt sort by index 13 
 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
ORDER BY ASC using index (multi)
49
functional arno optimizer opt sort by index 13 
 SS 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 E F F F
ORDER BY ASC using index (multi)
50
functional arno optimizer opt sort by index 19 
 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
ORDER BY ASC using index (multi) and WHERE clause
51
functional arno optimizer opt sort by index 19 
 SS 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 E F F F
ORDER BY ASC using index (multi) and WHERE clause
52
functional basic isql 02 
 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
ISQL - SHOW SYSTEM TABLES
53
functional basic isql 02 
 SS 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 E F F F
ISQL - SHOW SYSTEM TABLES
54
functional basic isql 07 
 SS 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 F P P P
Add REPLICA MODE to the output of the isql SHOW DATABASE command
55
functional basic isql 08 
 SS 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 F P P P
ISQL showing publication status
56
functional blob read blob in multiple cursors 
 CS 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 X
Ability to read same blob_id using multiple cursors
57
functional blob small blob caching 
 CS 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 X
Operations with inline streamed blobs when boundary values are used for seek() and read() methods.
58
functional replication blob characters garbled when conn charset differs 
 SS 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 F P 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
59
functional replication blob not found in rw replica if target row exists 
 SS 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 F P P P
Error "BLOB is not found" while replication converts INSERT into UPDATE for a conflicting record
60
functional replication blob segments longer 32kb are not replicated 
 SS 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 F P P P
Problem with replication of BLOB segments longer than 32KB
61
functional replication dblevel triggers must not fire on replica 
 SS 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 F P P P
Replica DB must not fire DB-level triggers but their activity on master must be eventually seen in replica
62
functional replication ddl triggers must not fire on replica 
 SS 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 F P P P
DDL-triggers must fire only on master DB
63
functional replication disallow rdb backup history replication 
 SS 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 F P P P
Disallow replication of RDB$BACKUP_HISTORY
64
functional replication duplicates in rw replica after conflicting insert 
 SS 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 F P P P
Conflicting INSERT propagated into a read-write replica may cause duplicate records to appear
65
functional replication failed ddl commands can be replicated 
 SS 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 F P P P
Failed DDL commands can be replicated
66
functional replication generator could not be transferred to replica 
 SS 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 F P P P
Generator values may not replicate after commit
67
functional replication invalid msg if target db has no replica flag 
 SS 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 F P 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
68
functional replication make async reinit reliable 
 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
Make asynchronous replica re-initialization reliable #8324
69
functional replication make async reinit reliable 
 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
Make asynchronous replica re-initialization reliable #8324
70
functional replication oltp emul ddl 
 SS 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 F P P P
Applying full DDL from OLTP-EMUL test on master with further check replica
71
functional replication shutdown during applying segments leads to crash 
 SS 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 F P P P
Crash or hang while shutting down the replica database if segments are being applied
72
functional replication some updates crash server on replica side 
 SS 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 F P P P
Some updates can crash Firebird server on replica side
73
functional replication updating blob with empty string stops replication 
 SS 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 F P P P
Replication gets stuck due to "Blob xxx.xx is not found for table xxx" error
74
functional tabloid 333be4bf 
 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
Change error by warning in the case when isc_dpb_parallel_workers value is not at valid range
75
functional tabloid 333be4bf 
 SS 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 E F F F
Change error by warning in the case when isc_dpb_parallel_workers value is not at valid range
76
functional tabloid e260ced8 
 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 F F
Allow computable but non-invariant lists to be used for index lookup
77
functional tabloid e260ced8 
 SS 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 E P F 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.1674
2025.06.27
3ee5c
5.0.3.1657
2025.06.26
dcb8a
5.0.3.1657
2025.06.20
8b4d2
5.0.3.1657
2025.06.19
4bd4c
5.0.3.1657
2025.06.11
dae6f
5.0.3.1657
2025.06.10
dbc92
5.0.3.1656
2025.06.05
00512
5.0.3.1656
2025.05.20
c4b11
5.0.3.1652
2025.05.13
f51c6
5.0.3.1651
2025.05.08
ee9d2
5.0.3.1651
2025.05.04
3d914
5.0.3.1651
2025.04.30
141ef
5.0.3.1650
2025.04.30
6253f
5.0.3.1650
2025.04.28
4cbff
5.0.3.1649
2025.04.21
5b2d0
5.0.3.1648
2025.04.18
2f4c5
5.0.3.1635
2025.04.03
f6bd1
5.0.3.1635
2025.03.31
22ec6
5.0.3.1633
2025.03.28
3123a
5.0.3.1633
2025.03.27
e0fb8
5.0.3.1631
2025.03.25
bda65
5.0.3.1631
2025.03.21
1925b
5.0.3.1629
2025.03.18
506d7
5.0.3.1628
2025.03.14
16d05
5.0.3.1627
2025.02.26
4e218
5.0.3.1624
2025.02.25
dc3b2
5.0.2.1615
2025.02.20
4a726
5.0.2.1615
2025.02.14
9cb76
5.0.2.1577
2025.02.07
f50a2
5.0.2.1577
2024.12.24
3c80e
Test TITLE
1
bugs core 0203 
 tracker
 CS 679 1020 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 677
CREATE VIEW ignores PLAN
2
bugs core 0203 
 tracker
 SS 460 824 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 468
CREATE VIEW ignores PLAN
3
bugs core 0733 
 tracker
 CS 16971 16792 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 16271
Compress Data over the Network
4
bugs core 0733 
 tracker
 SS 16071 15566 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 16479
Compress Data over the Network
5
bugs core 2650 
 tracker
 CS 787 822 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 1112
Improve sorting performance when long VARCHARs are involved
6
bugs core 2650 
 tracker
 SS 465 449 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 837
Improve sorting performance when long VARCHARs are involved
7
bugs core 5501 
 tracker
 CS 1487 1464 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 1482
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
8
bugs core 5501 
 tracker
 SS 1034 875 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 956
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
9
bugs core 6142 
 tracker
 CS 3386 3398 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 3381
Error "connection lost to database" could happen when application creates few local attachments (using XNET) simultaneously
10
bugs gh 6706 
 tracker
 CS 17719 17619 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 17945
Memory leak when running EXECUTE STATEMENT with named parameters [CORE6475]
11
bugs gh 6706 
 tracker
 SS 17668 17364 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 17881
Memory leak when running EXECUTE STATEMENT with named parameters [CORE6475]
12
bugs gh 7304 
 tracker
 SS 302 299 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 570
Events in system attachments (like garbage collector) are not traced
13
bugs gh 8061 
 tracker
 CS 895 896 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 0
Unnest IN/ANY/EXISTS subqueries and optimize them using semi-join algorithm
14
bugs gh 8061 
 tracker
 SS 654 649 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 0
Unnest IN/ANY/EXISTS subqueries and optimize them using semi-join algorithm
15
bugs gh 8085 
 tracker
 CS 18533 18520 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 18535
Memory leak when executing a lot of different queries and StatementTimeout > 0
16
bugs gh 8085 
 tracker
 SS 18292 18282 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 18287
Memory leak when executing a lot of different queries and StatementTimeout > 0
17
bugs gh 8109 
 tracker
 CS 1389 1394 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 1386
Plan/Performance regression when using special construct for IN in FB5.x compared to FB3.x
18
bugs gh 8109 
 tracker
 SS 1100 1094 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 1120
Plan/Performance regression when using special construct for IN in FB5.x compared to FB3.x
19
bugs gh 8182 
 tracker
 CS 609 631 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 0
IN predicate incorrectly handles single parenthesized subquery as IN-list, instead of table subquery
20
bugs gh 8182 
 tracker
 SS 392 390 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 0
IN predicate incorrectly handles single parenthesized subquery as IN-list, instead of table subquery
21
bugs gh 8185 
 tracker
 CS 690 672 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 696
SIGSEGV in Firebird 5.0.0.1306 embedded during update on cursor
22
bugs gh 8185 
 tracker
 SS 456 454 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 710
SIGSEGV in Firebird 5.0.0.1306 embedded during update on cursor
23
bugs gh 8263 
 tracker
 CS 1066 1036 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 1091
gbak on Classic with ParallelWorkers > 1 doesn't restore indices, giving a cryptic error message
24
bugs gh 8353 
 tracker
 SS 907 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 1134
Report unique usernames for isc_info_user_names
25
bugs gh 8356 
 tracker
 CS 2945 3379 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 2945
Make Trace use HEX representation for parameter values of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY
26
bugs gh 8356 
 tracker
 SS 2670 2668 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 2687
Make Trace use HEX representation for parameter values of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY
27
bugs gh 8386 
 tracker
 CS 1094 1154 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 1133
Crash when creating index on table that uses UDR and ParallelWorkers > 1
28
bugs gh 8386 
 tracker
 SS 880 871 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 884
Crash when creating index on table that uses UDR and ParallelWorkers > 1
29
bugs gh 8391 
 tracker
 SS 2732 2734 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 2641
gbak: Incorrect total statistics for restore
30
bugs gh 8394 
 tracker
 CS 1217 1217 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 1308
Make Trace use HEX representation for parameter values of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY
31
bugs gh 8394 
 tracker
 SS 943 910 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 948
Make Trace use HEX representation for parameter values of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY
32
bugs gh 8421 
 tracker
 CS 23595 22430 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 0
Add pointers tree to TempSpace class
33
bugs gh 8429 
 tracker
 SS 2173 2050 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 0
Segfault when already destroyed callback interface is used
34
bugs gh 8437 
 tracker
 CS 610 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 0
Segmentation fault when running query with partition by and subquery
35
bugs gh 8462 
 tracker
 CS 1699 1698 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 0
A user with "GRANT_REVOKE_ON_ANY_OBJECT" privilege can't revoke a role from himself if he is not a grantor
36
bugs gh 8462 
 tracker
 SS 1070 953 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 0
A user with "GRANT_REVOKE_ON_ANY_OBJECT" privilege can't revoke a role from himself if he is not a grantor
37
bugs gh 8477 
 tracker
 CS 605 609 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 0
Inheritance of WINDOW does not work
38
bugs gh 8477 
 tracker
 SS 423 371 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 0
Inheritance of WINDOW does not work
39
bugs gh 8485 
 tracker
 CS 1 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 0
Segfault/AV on incorrect databases.conf starting with subconfig (without line alias=database_path)
40
bugs gh 8508 
 tracker
 CS 600 594 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 0
Conversion Error with old.field in UPDATE OR INSERT
41
bugs gh 8513 
 tracker
 CS 590 582 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 0
Makes MON$COMPILED_STATEMENTS and MON$STATEMENTS share blobs with text and plan content of the same statement
42
bugs gh 8589 
 tracker
 CS 600 579 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 0
PERCENT_RANK may return NaN instead of 0
43
bugs gh 8589 
 tracker
 SS 391 376 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 0
PERCENT_RANK may return NaN instead of 0
44
bugs gh 8592 
 tracker
 CS 607 581 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 0
Presence of 'ROWS <n_limit>' causes garbage in error message when string conversion problem raises
45
bugs gh 8592 
 tracker
 SS 391 379 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 0
Presence of 'ROWS <n_limit>' causes garbage in error message when string conversion problem raises
46
functional arno optimizer opt sort by index 10 
 CS 843 859 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 827
ORDER BY ASC using index (multi)
47
functional arno optimizer opt sort by index 10 
 SS 597 518 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 569
ORDER BY ASC using index (multi)
48
functional arno optimizer opt sort by index 13 
 CS 844 845 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 811
ORDER BY ASC using index (multi)
49
functional arno optimizer opt sort by index 13 
 SS 600 523 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 843
ORDER BY ASC using index (multi)
50
functional arno optimizer opt sort by index 19 
 CS 630 602 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 607
ORDER BY ASC using index (multi) and WHERE clause
51
functional arno optimizer opt sort by index 19 
 SS 426 388 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 426
ORDER BY ASC using index (multi) and WHERE clause
52
functional basic isql 02 
 CS 622 616 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 599
ISQL - SHOW SYSTEM TABLES
53
functional basic isql 02 
 SS 432 380 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 433
ISQL - SHOW SYSTEM TABLES
54
functional basic isql 07 
 SS 374 314 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 308
Add REPLICA MODE to the output of the isql SHOW DATABASE command
55
functional basic isql 08 
 SS 158 159 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 155
ISQL showing publication status
56
functional blob read blob in multiple cursors 
 CS 777 777 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 0
Ability to read same blob_id using multiple cursors
57
functional blob small blob caching 
 CS 875 855 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 0
Operations with inline streamed blobs when boundary values are used for seek() and read() methods.
58
functional replication blob characters garbled when conn charset differs 
 SS 8686 9667 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 9560
Characters are garbled when replicating fields with type BLOB SUB_TYPE TEXT if the character set of the connection and the field are different
59
functional replication blob not found in rw replica if target row exists 
 SS 9036 8892 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 9037
Error "BLOB is not found" while replication converts INSERT into UPDATE for a conflicting record
60
functional replication blob segments longer 32kb are not replicated 
 SS 6408 6533 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 6471
Problem with replication of BLOB segments longer than 32KB
61
functional replication dblevel triggers must not fire on replica 
 SS 6136 6157 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 6219
Replica DB must not fire DB-level triggers but their activity on master must be eventually seen in replica
62
functional replication ddl triggers must not fire on replica 
 SS 6336 6349 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 7395
DDL-triggers must fire only on master DB
63
functional replication disallow rdb backup history replication 
 SS 8529 9121 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 8352
Disallow replication of RDB$BACKUP_HISTORY
64
functional replication duplicates in rw replica after conflicting insert 
 SS 8710 9684 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 9544
Conflicting INSERT propagated into a read-write replica may cause duplicate records to appear
65
functional replication failed ddl commands can be replicated 
 SS 6108 6121 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 6130
Failed DDL commands can be replicated
66
functional replication generator could not be transferred to replica 
 SS 6043 6045 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 6068
Generator values may not replicate after commit
67
functional replication invalid msg if target db has no replica flag 
 SS 12142 12109 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 12129
Invalid message in replication.log (and possibly crash in the case of synchronous replication) when the target DB has no its "replica" flag set
68
functional replication make async reinit reliable 
 CS 50814 49833 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 53754
Make asynchronous replica re-initialization reliable #8324
69
functional replication make async reinit reliable 
 SS 50409 50253 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 53443
Make asynchronous replica re-initialization reliable #8324
70
functional replication oltp emul ddl 
 SS 13832 13224 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 14426
Applying full DDL from OLTP-EMUL test on master with further check replica
71
functional replication shutdown during applying segments leads to crash 
 SS 13261 13637 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 13374
Crash or hang while shutting down the replica database if segments are being applied
72
functional replication some updates crash server on replica side 
 SS 6056 6052 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 6076
Some updates can crash Firebird server on replica side
73
functional replication updating blob with empty string stops replication 
 SS 6037 6038 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 6054
Replication gets stuck due to "Blob xxx.xx is not found for table xxx" error
74
functional tabloid 333be4bf 
 CS 1468 1465 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 1467
Change error by warning in the case when isc_dpb_parallel_workers value is not at valid range
75
functional tabloid 333be4bf 
 SS 1243 998 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 1229
Change error by warning in the case when isc_dpb_parallel_workers value is not at valid range
76
functional tabloid e260ced8 
 CS 700 682 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 741
Allow computable but non-invariant lists to be used for index lookup
77
functional tabloid e260ced8 
 SS 459 436 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 461
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-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
=== end of list ===

Last commits information (all timestamps in UTC):