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 (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 (19 rows)
05. NEW SLOWDOWN: tests with performance problem for LAST 5 runs (0 rows)
06. STILL SLOWDOWN: tests with performance problem for MORE THAN 5 last runs (12 rows)
[CURRENT] 07. Has fails: tests with at least one fail for previous 35 runs (77 rows)
08. Has runtime errors: tests with at least one runtime error for previous 35 runs (805 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 (15 rows)
11. All tests: outcomes for previous 35 runs (3700 rows)
12. Skipped: tests which was intentionally excluded from execution (263 rows)

Generated UTC 08.10.2025 10:45
Tested: HQ50.   Build / date: 5.0.4.1722-bd11e231 / 2025.10.06;
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: 2.0.2; firebird.Qa: 0.21.0 
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.4.1722
2025.10.06
5.0.3.1685
2025.09.08
5.0.3.1683
2025.09.04
5.0.3.1683
2025.09.03
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
Test TITLE
1 CS P P P P 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
CREATE VIEW ignores PLAN
2 SS P P P P 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
CREATE VIEW ignores PLAN
3 CS F F F F 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
Compress Data over the Network
4 SS P P P P 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
Compress Data over the Network
5 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
6 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
7 CS P P P P 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
Error "connection lost to database" could happen when application creates few local attachments (using XNET) simultaneously
8 CS P P 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
Regression in FB 4.x: error "Implementation of text subtype <NNNN> not located" on attempt to use some collations defined in fbintl.conf
9 SS P P 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
Regression in FB 4.x: error "Implementation of text subtype <NNNN> not located" on attempt to use some collations defined in fbintl.conf
10 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 F F F F F F
Memory leak when running EXECUTE STATEMENT with named parameters [CORE6475]
11 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 F F F F F F
Memory leak when running EXECUTE STATEMENT with named parameters [CORE6475]
12 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
13 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 F X X X X X X X X
Unnest IN/ANY/EXISTS subqueries and optimize them using semi-join algorithm
14 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 F X X X X X X X X
Unnest IN/ANY/EXISTS subqueries and optimize them using semi-join algorithm
15 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 F F F F F F
Memory leak when executing a lot of different queries and StatementTimeout > 0
16 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 F F F F F F
Memory leak when executing a lot of different queries and StatementTimeout > 0
17 CS P P P P 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
IN predicate incorrectly handles single parenthesized subquery as IN-list, instead of table subquery
18 SS P P P P 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
IN predicate incorrectly handles single parenthesized subquery as IN-list, instead of table subquery
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 F F F F F
gbak on Classic with ParallelWorkers > 1 doesn't restore indices, giving a cryptic error message
20 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
21 SS F F F F 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
Crash when creating index on table that uses UDR and ParallelWorkers > 1
22 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 P F F F F P P P P P
gbak: Incorrect total statistics for restore
23 CS P F P P 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
Add pointers tree to TempSpace class
24 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 F F F F F F F F F
A user with "GRANT_REVOKE_ON_ANY_OBJECT" privilege can't revoke a role from himself if he is not a grantor
25 SS P P P P 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
A user with "GRANT_REVOKE_ON_ANY_OBJECT" privilege can't revoke a role from himself if he is not a grantor
26 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 F F F F F F X X X
Inheritance of WINDOW does not work
27 SS P P P P 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
Inheritance of WINDOW does not work
28 CS S S S S 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
Segfault/AV on incorrect databases.conf starting with subconfig (without line alias=database_path)
29 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 F X X X X X X X X
Conversion Error with old.field in UPDATE OR INSERT
30 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 F 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
31 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 X X X X X
Get the modification time of a config file with a higher precision to fix cases when it's not reloaded after modification/replacement
32 CS 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 X X X X X X X X X X
PERCENT_RANK may return NaN instead of 0
33 SS 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 X X X X X X X X X X
PERCENT_RANK may return NaN instead of 0
34 CS P P P P 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
Presence of 'ROWS <n_limit>' causes garbage in error message when string conversion problem raises
35 SS P P P P 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
Presence of 'ROWS <n_limit>' causes garbage in error message when string conversion problem raises
36 CS P P P P P P P P P P F X X X X X X X X X X X X X X X X X X X X X X X X
AV when ON CONNECT triggers uses EXECUTE STATEMENT ON EXTERNAL
37 CS P F F F F F F F F F X X X X X X X X X X X X X X X X X X X X X X X X X
TRANSACTION_ROLLBACK missing in the trace log when appropriate DB-level trigger fires
38 SS P F F F F F F F F F X X X X X X X X X X X X X X X X X X X X X X X X X
TRANSACTION_ROLLBACK missing in the trace log when appropriate DB-level trigger fires
39 CS P F F F F F F F F X X X X X X X X X X X X X X X X X X X X X X X X X X
SHOW DEPENDENCIES command terminates unexpectedly if there are packages in the dependencies
40 SS P F F F F F F F F X X X X X X X X X X X X X X X X X X X X X X X X X X
SHOW DEPENDENCIES command terminates unexpectedly if there are packages in the dependencies
41 CS P F F F F F F F X X X X X X X X X X X X X X X X X X X X X X X X X X X
Error unable to allocate memory from operating system
42 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 X X X X X
Check diagnostic message and errorlevel when ISQL is launched with "< nul"
43 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 X X X X X
Check diagnostic message and errorlevel when ISQL is launched with "< nul"
44 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 X X X X X
Wrong SQLSTATE in case of table alias conflict
45 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 X X X X X
Wrong SQLSTATE in case of table alias conflict
46 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)
47 SS F F F F 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
ORDER BY ASC using index (multi)
48 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)
49 SS F F F F 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
ORDER BY ASC using index (multi)
50 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
51 SS F F F F 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
ORDER BY ASC using index (multi) and WHERE clause
52 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
53 SS F F F F 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
ISQL - SHOW SYSTEM TABLES
54 SS P P P P 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
Add REPLICA MODE to the output of the isql SHOW DATABASE command
55 SS P P P P 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
ISQL showing publication status
56 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 F F X X X X X X X
Ability to read same blob_id using multiple cursors
57 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 F F X X X X X X X
Operations with inline streamed blobs when boundary values are used for seek() and read() methods.
58 SS P P P P 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
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 SS P P P P 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
Error "BLOB is not found" while replication converts INSERT into UPDATE for a conflicting record
60 SS P P P P 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
Problem with replication of BLOB segments longer than 32KB
61 SS P P P P 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
Replica DB must not fire DB-level triggers but their activity on master must be eventually seen in replica
62 SS P P P P 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
DDL-triggers must fire only on master DB
63 SS P P P P 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
Disallow replication of RDB$BACKUP_HISTORY
64 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 X X X X X
Replicator could produce log segments with duplicated segment numbers
65 SS P P P P 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
Conflicting INSERT propagated into a read-write replica may cause duplicate records to appear
66 SS P P P P 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
Failed DDL commands can be replicated
67 SS P P P P 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
Generator values may not replicate after commit
68 SS P P P P 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
Invalid message in replication.log (and possibly crash in the case of synchronous replication) when the target DB has no its "replica" flag set
69 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
70 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
71 SS P P P P 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
Applying full DDL from OLTP-EMUL test on master with further check replica
72 SS P P P P 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
Crash or hang while shutting down the replica database if segments are being applied
73 SS P P P P 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
Some updates can crash Firebird server on replica side
74 SS P P P P 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
Replication gets stuck due to "Blob xxx.xx is not found for table xxx" error
75 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
76 SS F F F F 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
Change error by warning in the case when isc_dpb_parallel_workers value is not at valid range
77 CS 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 P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01.

Elapsed time, milliseconds:

NN Test name mode median_ms
5.0.4.1722
2025.10.06
5.0.3.1685
2025.09.08
5.0.3.1683
2025.09.04
5.0.3.1683
2025.09.03
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
Test TITLE
1 CS 693 745 750 809 785 757 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
CREATE VIEW ignores PLAN
2 SS 474 497 489 490 501 494 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
CREATE VIEW ignores PLAN
3 CS 16966 16515 17767 16334 16993 17385 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
Compress Data over the Network
4 SS 16047 15466 16172 15927 15714 16966 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
Compress Data over the Network
5 CS 1492 1465 1466 1477 1484 1485 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
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
6 SS 1190 1582 1521 1510 1508 875 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
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
7 CS 3415 3225 3266 3515 3415 3485 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
Error "connection lost to database" could happen when application creates few local attachments (using XNET) simultaneously
8 CS 22493 4228 4264 4359 4305 4269 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
Regression in FB 4.x: error "Implementation of text subtype <NNNN> not located" on attempt to use some collations defined in fbintl.conf
9 SS 13335 3827 3816 4231 3843 3848 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
Regression in FB 4.x: error "Implementation of text subtype <NNNN> not located" on attempt to use some collations defined in fbintl.conf
10 CS 17530 17524 17421 17498 17806 17478 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
Memory leak when running EXECUTE STATEMENT with named parameters [CORE6475]
11 SS 17558 17582 17379 17682 17391 17333 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
Memory leak when running EXECUTE STATEMENT with named parameters [CORE6475]
12 SS 318 556 537 343 537 522 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
Events in system attachments (like garbage collector) are not traced
13 CS 893 890 884 887 894 885 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
Unnest IN/ANY/EXISTS subqueries and optimize them using semi-join algorithm
14 SS 656 654 636 663 646 663 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
Unnest IN/ANY/EXISTS subqueries and optimize them using semi-join algorithm
15 CS 18530 18550 18513 18527 18517 18524 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
Memory leak when executing a lot of different queries and StatementTimeout > 0
16 SS 18288 18285 18294 18282 18282 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
Memory leak when executing a lot of different queries and StatementTimeout > 0
17 CS 590 590 600 579 615 597 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
IN predicate incorrectly handles single parenthesized subquery as IN-list, instead of table subquery
18 SS 381 374 366 374 359 370 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
IN predicate incorrectly handles single parenthesized subquery as IN-list, instead of table subquery
19 CS 1056 1105 1026 1049 1045 1087 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
gbak on Classic with ParallelWorkers > 1 doesn't restore indices, giving a cryptic error message
20 CS 1095 1119 1094 1070 1097 1112 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
Crash when creating index on table that uses UDR and ParallelWorkers > 1
21 SS 869 892 854 864 856 841 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
Crash when creating index on table that uses UDR and ParallelWorkers > 1
22 SS 2739 2778 2628 2739 2728 2581 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
gbak: Incorrect total statistics for restore
23 CS 23234 23205 23162 22570 22555 22681 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
Add pointers tree to TempSpace class
24 CS 1699 1718 1638 1671 1689 1703 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
A user with "GRANT_REVOKE_ON_ANY_OBJECT" privilege can't revoke a role from himself if he is not a grantor
25 SS 963 937 958 949 1062 942 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
A user with "GRANT_REVOKE_ON_ANY_OBJECT" privilege can't revoke a role from himself if he is not a grantor
26 CS 600 599 575 588 591 584 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
Inheritance of WINDOW does not work
27 SS 387 387 375 385 387 381 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
Inheritance of WINDOW does not work
28 CS 1 1 1 1 1 2 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
Segfault/AV on incorrect databases.conf starting with subconfig (without line alias=database_path)
29 CS 600 598 577 594 591 594 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
Conversion Error with old.field in UPDATE OR INSERT
30 CS 590 585 610 572 581 577 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
Makes MON$COMPILED_STATEMENTS and MON$STATEMENTS share blobs with text and plan content of the same statement
31 SS 696 679 714 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 0 0
Get the modification time of a config file with a higher precision to fix cases when it's not reloaded after modification/replacement
32 CS 593 640 577 589 607 589 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
PERCENT_RANK may return NaN instead of 0
33 SS 387 383 375 379 572 380 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
PERCENT_RANK may return NaN instead of 0
34 CS 609 631 582 595 584 592 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
Presence of 'ROWS <n_limit>' causes garbage in error message when string conversion problem raises
35 SS 388 385 373 379 498 371 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
Presence of 'ROWS <n_limit>' causes garbage in error message when string conversion problem raises
36 CS 1220 1254 1198 1222 1208 1203 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
AV when ON CONNECT triggers uses EXECUTE STATEMENT ON EXTERNAL
37 CS 2942 3216 2974 2916 2926 2931 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
TRANSACTION_ROLLBACK missing in the trace log when appropriate DB-level trigger fires
38 SS 2686 2670 2843 2689 2950 2676 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
TRANSACTION_ROLLBACK missing in the trace log when appropriate DB-level trigger fires
39 CS 2325 608 2078 2691 3457 2325 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
SHOW DEPENDENCIES command terminates unexpectedly if there are packages in the dependencies
40 SS 3041 377 3067 3543 3049 3138 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
SHOW DEPENDENCIES command terminates unexpectedly if there are packages in the dependencies
41 CS 6945 6849 6912 6723 6979 6980 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
Error unable to allocate memory from operating system
42 CS 625 625 626 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 0 0
Check diagnostic message and errorlevel when ISQL is launched with "< nul"
43 SS 416 394 438 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 0 0
Check diagnostic message and errorlevel when ISQL is launched with "< nul"
44 CS 614 608 620 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 0 0
Wrong SQLSTATE in case of table alias conflict
45 SS 387 375 400 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 0 0
Wrong SQLSTATE in case of table alias conflict
46 CS 838 893 689 688 720 729 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
ORDER BY ASC using index (multi)
47 SS 569 442 455 454 779 451 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
ORDER BY ASC using index (multi)
48 CS 833 686 722 689 690 717 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
ORDER BY ASC using index (multi)
49 SS 595 453 688 699 775 447 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
ORDER BY ASC using index (multi)
50 CS 643 697 688 687 688 694 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
ORDER BY ASC using index (multi) and WHERE clause
51 SS 456 457 456 485 766 458 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
ORDER BY ASC using index (multi) and WHERE clause
52 CS 620 627 613 583 595 597 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
ISQL - SHOW SYSTEM TABLES
53 SS 422 400 389 409 652 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
ISQL - SHOW SYSTEM TABLES
54 SS 371 306 299 359 523 386 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
Add REPLICA MODE to the output of the isql SHOW DATABASE command
55 SS 157 157 157 154 237 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
ISQL showing publication status
56 CS 784 772 790 828 806 781 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
Ability to read same blob_id using multiple cursors
57 CS 875 849 841 859 888 858 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
Operations with inline streamed blobs when boundary values are used for seek() and read() methods.
58 SS 8687 8664 9536 9700 9038 8693 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
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 SS 9057 10239 8932 9339 9323 10313 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
Error "BLOB is not found" while replication converts INSERT into UPDATE for a conflicting record
60 SS 6379 5423 6379 6347 6393 6513 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
Problem with replication of BLOB segments longer than 32KB
61 SS 6142 6129 6189 6171 6384 6156 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
Replica DB must not fire DB-level triggers but their activity on master must be eventually seen in replica
62 SS 6336 7333 7317 6381 6408 6375 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
DDL-triggers must fire only on master DB
63 SS 8671 9364 11909 11819 8871 7340 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
Disallow replication of RDB$BACKUP_HISTORY
64 CS 50526 6518 94535 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 0 0
Replicator could produce log segments with duplicated segment numbers
65 SS 8705 8532 8678 9550 9274 8869 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
Conflicting INSERT propagated into a read-write replica may cause duplicate records to appear
66 SS 6112 6139 6117 6122 6147 6117 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
Failed DDL commands can be replicated
67 SS 6041 6074 6041 6056 6078 6052 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
Generator values may not replicate after commit
68 SS 12172 13143 12097 12181 13244 13104 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
Invalid message in replication.log (and possibly crash in the case of synchronous replication) when the target DB has no its "replica" flag set
69 CS 50859 53442 50705 52721 50796 49720 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
Make asynchronous replica re-initialization reliable #8324
70 SS 50545 54246 53213 50248 50426 51298 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
Make asynchronous replica re-initialization reliable #8324
71 SS 13909 16506 13964 14419 13181 16013 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
Applying full DDL from OLTP-EMUL test on master with further check replica
72 SS 13481 13077 13886 13512 14040 13944 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
Crash or hang while shutting down the replica database if segments are being applied
73 SS 6056 6056 6057 6040 6096 6052 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
Some updates can crash Firebird server on replica side
74 SS 6043 6055 6068 6038 6750 6063 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
Replication gets stuck due to "Blob xxx.xx is not found for table xxx" error
75 CS 1459 1459 1446 1446 1422 1489 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
Change error by warning in the case when isc_dpb_parallel_workers value is not at valid range
76 SS 1245 1040 1012 1335 990 1265 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
Change error by warning in the case when isc_dpb_parallel_workers value is not at valid range
77 CS 7213 7189 8208 8224 7219 8273 7203 8275 7215 7189 7813 7388 8243 7213 8482 6325 7321 8292 7215 6432 6384 7200 7265 6407 7234 7264 6499 6243 6238 6287 6279 8347 6276 6241 6269 6266
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01.

List of tests in this report:


http://tracker.firebirdsql.org/browse/CORE-203
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_duplicated_segment_numbers.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/transactions/test_read_consist_sttm_restart_on_update_01.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/8182
https://github.com/FirebirdSQL/firebird/issues/8263
https://github.com/FirebirdSQL/firebird/issues/8386
https://github.com/FirebirdSQL/firebird/issues/8391
https://github.com/FirebirdSQL/firebird/issues/8421
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/8553
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
https://github.com/FirebirdSQL/firebird/issues/8690
https://github.com/FirebirdSQL/firebird/issues/8739
=== end of list ===

Last commits information (all timestamps in UTC):