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 (777 rows)
[CURRENT] 05. NEW SLOWDOWN: tests with performance problem for LAST 5 runs (19 rows)
06. STILL SLOWDOWN: tests with performance problem for MORE THAN 5 last runs (50 rows)
07. Has fails: tests with at least one fail for previous 30 runs (1873 rows)
08. Has runtime errors: tests with at least one runtime error for previous 30 runs (4 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 (49 rows)
11. All tests: outcomes for previous 30 runs (3632 rows)
12. Skipped: tests which was intentionally excluded from execution (78 rows)

Generated UTC 04.07.2025 02:58
Tested: FB60.   Build / date: 6.0.0.894-789ba56a / 2025.07.03;
Test machine: Linux 6.11.5-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.11.5-1 (2024-10-27); logical CPUs: 2; RAM: 7 Gb 
QA software: Python: 3.11.9; 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

Tests with performance slowdown for LAST 5 runs - moving medians

LAST moving median (window = 5) greater than previous for at least 1.5x. No more than 50 rows are shown, pre-filtered in descending order of ratio between latest and previous medians:
NN Test name mode Test last update Moving medians chart
6.0.0.894
2025.07.03
6.0.0.892
2025.07.02
6.0.0.889
2025.07.01
6.0.0.884
2025.06.30
6.0.0.881
2025.06.27
6.0.0.877
2025.06.26
6.0.0.876
2025.06.25
6.0.0.863
2025.06.24
6.0.0.858
2025.06.23
6.0.0.849
2025.06.20
6.0.0.848
2025.06.19
6.0.0.845
2025.06.18
6.0.0.843
2025.06.16
6.0.0.840
2025.06.14
6.0.0.838
2025.06.13
6.0.0.835
2025.06.12
6.0.0.834
2025.06.11
6.0.0.800
2025.06.10
6.0.0.799
2025.06.07
6.0.0.797
2025.06.06
6.0.0.795
2025.05.29
6.0.0.792
2025.05.28
6.0.0.791
2025.05.27
6.0.0.789
2025.05.21
6.0.0.787
2025.05.20
6.0.0.783
2025.05.12
Test TITLE
1 CS 2022.02.02 14:46
1298 770 X X 1298 1298 1017 780 1017 1017 1183 1183 1183 1202 1202 1288 1359 1473 1473 1473 1397 1384 1346 1296 1250 980
Incorrect result of recursive CTE query when recursive member's SELECT list contains expression using self-referenced fields
2 CS 2022.02.02 14:46
1222 808 X X 1222 1245 1222 842 842 842 842 842 759 1336 1325 1325 1325 1336 1392 1392 1425 1425 1425 1377 1361 1304
Collation not propagated between record formats
3 CS 2022.02.02 14:46
1021 661 689 661 661 611 599 599 611 623 623 974 974 933 933 933 933 986 1104 1104 1104 1061 1032 1032 1032 1035
Include information about context variables into the monitoring tables
4 CS 2022.02.02 14:46
1036 683 683 683 923 625 614 660 629 629 660 660 654 1061 733 654 647 696 696 647 696 736 736 736 1038 1081
Incorrect buffer size for ORDER BY expression with system fields
5 CS 2025.06.26 17:32
1364 896 896 1253 1253 864 X X X X X X X X X X X 885 885 885 885 885 875 875 875 1304
ALTER VIEW could remove column used in stored procedure or trigger
6 CS 2022.02.02 14:46
1013 659 659 641 636 559 636 624 624 577 624 624 638 639 961 961 638 628 628 628 634 655 655 746 746 1060
Wrong matching of SIMILAR TO expression with brackets
7 CS 2022.02.02 14:46
1577 1041 1041 1477 1477 1086 1477 1086 1086 1086 955 940 955 955 955 996 1568 1575 1568 1568 1418 972 972 972 972 1106
Current connection may be used by EXECUTE STATEMENT instead of creation of new attachment
8 CS 2022.02.02 14:46
1057 662 X X 745 745 687 745 745 687 687 752 728 752 770 1032 1088 1088 1116 1165 1116 1068 1136 1136 1059 1112
Parametrized queries using RDB$DB_KEY do not work
9 SS 2022.02.02 14:46
652 427 438 408 408 408 438 450 657 657 452 452 452 443 452 443 455 455 455 449 455 452 452 452 463 468
Nested OR conditions may lead to incorrest results
10 SS 2022.08.18 10:51
563 349 291 291 274 274 358 454 400 435 435 485 484 589 589 589 484 455 455 625 559 559 559 557 521 465
MON$ATTACHMENTS.MON$TIMESTAMP is incorrect when DefaultTimeZone is configured with time zone different from the server's default
11 SS 2023.10.09 09:12
679 447 660 660 626 660 689 689 792 792 792 868 868 850 850 773 773 850 773 888 888 768 768 821 821 823
Some orphan records left at RDB$SECURITY_CLASSES and RDB$USER_PRIVILEGES after DROP PROCEDURE\FUNCTION
12 SS 2023.11.12 10:17
X X X X X X X X X X X X X X X X X 1962 1304 1250 1204 1204 1204 1772 1772 1790
Provide ability to run "ALTER SQL SECURITY DEFINER / INVOKER" without specifying further part of proc/func/package
13 CS 2024.01.12 15:40
X X X X X X X X X X X X X X X X X 1248 751 1248 751 751 751 725 725 751
Inconsistent state of master-detail occurs after RE-connect + 'SET AUTODDL OFF' + 'drop <FK>' which is ROLLED BACK
14 CS 2024.01.23 05:23
X X X X X X X X X X X X X X X X X 1085 638 638 623 623 623 657 741 1083
System procedure/function inconsistency between ISQL SHOW FUNCTIONS and SHOW PROCEDURES
15 CS 2025.04.16 17:03
X X X X X X X X X X X X X X X X X 1776 1183 1183 1183 1206 1206 1206 1712 1733
Unnest IN/ANY/EXISTS subqueries and optimize them using semi-join algorithm
16 CS 2024.10.26 08:21
X X X X X X X X X X X X X X X X X 1191 755 1313 858 888 858 858 742 742
"Unique scan" is incorrectly reported in the explained plan for unique index and IS NULL predicate
17 CS 2022.02.04 18:05
X X X X X X X X X X X X X X X X X 1168 774 774 774 910 772 910 910 910
AVOID index usage in WHERE <indexed_varchar_field> = <integer_value>
18 CS 2022.02.04 18:05
X X X X X X X X X X X X X X X X X 1388 913 913 913 888 888 888 995 1351
Check correct work fix with foreign key
19 CS 2022.02.04 18:05
X X X X X X X X X X X X X X X X X 1223 775 1244 1244 1217 1192 1192 823 758
Zero divide in SP can crash database when call this SP several times

Elapsed time, milliseconds:

NN Test name mode
6.0.0.894
2025.07.03
6.0.0.892
2025.07.02
6.0.0.889
2025.07.01
6.0.0.884
2025.06.30
6.0.0.881
2025.06.27
6.0.0.877
2025.06.26
6.0.0.876
2025.06.25
6.0.0.863
2025.06.24
6.0.0.858
2025.06.23
6.0.0.849
2025.06.20
6.0.0.848
2025.06.19
6.0.0.845
2025.06.18
6.0.0.843
2025.06.16
6.0.0.840
2025.06.14
6.0.0.838
2025.06.13
6.0.0.835
2025.06.12
6.0.0.834
2025.06.11
6.0.0.800
2025.06.10
6.0.0.799
2025.06.07
6.0.0.797
2025.06.06
6.0.0.795
2025.05.29
6.0.0.792
2025.05.28
6.0.0.791
2025.05.27
6.0.0.789
2025.05.21
6.0.0.787
2025.05.20
6.0.0.783
2025.05.12
6.0.0.779
2025.05.11
6.0.0.778
2025.05.07
6.0.0.776
2025.05.06
6.0.0.770
2025.05.05
Test TITLE
1 CS 1364 770 X X 770 1310 1298 687 1322 1017 780 751 1183 1314 1202 778 757 1288 1359 1724 1486 1473 1346 1397 1384 980 1296 1250 868 863
Incorrect result of recursive CTE query when recursive member's SELECT list contains expression using self-referenced fields
2 CS 1373 808 X X 793 1245 1222 792 1344 1280 803 842 718 1375 1354 759 708 1336 1325 1392 1198 1598 1425 1377 1582 838 1461 1304 1361 801
Collation not propagated between record formats
3 CS 1021 563 1071 658 1021 661 689 599 611 533 564 623 1033 623 974 1043 933 698 611 986 1104 1242 1237 1061 616 636 1032 1063 1035 1116
Include information about context variables into the monitoring tables
4 CS 1036 589 1216 683 1204 625 570 923 1099 614 574 660 629 1096 1061 654 594 1206 733 647 592 696 1159 621 1038 736 623 1084 1155 1081
Incorrect buffer size for ORDER BY expression with system fields
5 CS 1377 1364 896 785 1400 864 X X X X X X X X X X X 1253 1407 811 804 885 902 1380 849 875 874 1304 1314 1307
ALTER VIEW could remove column used in stored procedure or trigger
6 CS 1013 1031 659 641 1143 558 1054 551 636 559 1080 624 577 564 639 1088 638 961 1100 628 601 589 634 1082 655 746 562 1128 1060 1204
Wrong matching of SIMILAR TO expression with brackets
7 CS 1698 1644 1041 1016 1577 916 1477 1488 905 1086 1599 940 1630 823 955 864 996 1639 875 1575 1568 1663 941 1418 867 972 1106 850 1707 1507
Current connection may be used by EXECUTE STATEMENT instead of creation of new attachment
8 CS 1057 573 X X 1073 1072 594 662 745 752 687 1100 666 564 752 770 728 1032 1088 1289 1116 1068 1180 1165 1059 675 1136 1207 701 1112
Parametrized queries using RDB$DB_KEY do not work
9 SS 652 427 710 333 652 404 438 408 395 657 450 703 668 356 452 411 719 443 470 417 455 535 396 449 463 452 498 447 496 468
Nested OR conditions may lead to incorrest results
10 SS 698 752 563 349 291 262 265 454 274 622 358 485 400 435 638 589 484 599 455 652 375 450 640 625 559 413 557 374 521 465
MON$ATTACHMENTS.MON$TIMESTAMP is incorrect when DefaultTimeZone is configured with time zone different from the server's default
11 SS 844 415 776 679 447 412 660 689 626 882 792 640 868 547 947 888 743 850 773 761 934 949 768 888 607 622 821 861 823 856
Some orphan records left at RDB$SECURITY_CLASSES and RDB$USER_PRIVILEGES after DROP PROCEDURE\FUNCTION
12 SS X X X X X X X X X X X X X X X X X 1965 1962 1304 1250 2396 1204 1149 1160 1790 1981 1772 1677 2209
Provide ability to run "ALTER SQL SECURITY DEFINER / INVOKER" without specifying further part of proc/func/package
13 CS X X X X X X X X X X X X X X X X X 1464 643 1328 669 1248 751 1428 725 706 751 704 1484 1209
Inconsistent state of master-detail occurs after RE-connect + 'SET AUTODDL OFF' + 'drop <FK>' which is ROLLED BACK
14 CS X X X X X X X X X X X X X X X X X 1085 604 1101 638 1210 589 611 623 741 1124 657 1083 1093
System procedure/function inconsistency between ISQL SHOW FUNCTIONS and SHOW PROCEDURES
15 CS X X X X X X X X X X X X X X X X X 1844 1776 1132 1043 2343 1183 1206 1052 1712 1733 1168 1947 2411
Unnest IN/ANY/EXISTS subqueries and optimize them using semi-join algorithm
16 CS X X X X X X X X X X X X X X X X X 1191 667 1313 683 1591 755 1344 858 888 702 717 742 1350
"Unique scan" is incorrectly reported in the explained plan for unique index and IS NULL predicate
17 CS X X X X X X X X X X X X X X X X X 1294 1307 689 774 1168 772 1411 760 910 758 1431 1363 877
AVOID index usage in WHERE <indexed_varchar_field> = <integer_value>
18 CS X X X X X X X X X X X X X X X X X 1388 874 817 1529 1464 913 855 852 888 1421 995 1363 1351
Check correct work fix with foreign key
19 CS X X X X X X X X X X X X X X X X X 1223 775 725 1449 1574 769 1244 1217 823 1192 758 747 743
Zero divide in SP can crash database when call this SP several times

List of tests in this report:


http://tracker.firebirdsql.org/browse/CORE-1373
http://tracker.firebirdsql.org/browse/CORE-1432
http://tracker.firebirdsql.org/browse/CORE-1750
http://tracker.firebirdsql.org/browse/CORE-2027
http://tracker.firebirdsql.org/browse/CORE-2386
http://tracker.firebirdsql.org/browse/CORE-2389
http://tracker.firebirdsql.org/browse/CORE-2729
http://tracker.firebirdsql.org/browse/CORE-4255
http://tracker.firebirdsql.org/browse/CORE-5268
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_avoid_index_usage.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/fkey/primary/test_insert_pk_09.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_division_by_zero_corrupts_db.py
https://github.com/FirebirdSQL/firebird/issues/6790
https://github.com/FirebirdSQL/firebird/issues/6866
https://github.com/FirebirdSQL/firebird/issues/7744
https://github.com/FirebirdSQL/firebird/issues/7899
https://github.com/FirebirdSQL/firebird/issues/7962
https://github.com/FirebirdSQL/firebird/issues/8061
https://github.com/FirebirdSQL/firebird/issues/8290
=== end of list ===

Last commits information (all timestamps in UTC):