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 (1036 rows)
[CURRENT] 05. NEW SLOWDOWN: tests with performance problem for LAST 5 runs (29 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 (1605 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 (242 rows)
11. All tests: outcomes for previous 30 runs (3499 rows)
12. Skipped: tests which was intentionally excluded from execution (78 rows)

Generated UTC 30.06.2025 03:00
Tested: FB60.   Build / date: 6.0.0.881-7035d6ee / 2025.06.27;
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.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 2025.06.25 15:39
2558 1524 1524 1524 X X X X X X X X X 1498 1524 1483 1483 1483 1562 1508 1541 1508 1508 1309 1085 823
User (not SYSDBA) that have privileges with grant option, can't revoke privileges, granted by other user or SYSDBA
2 CS 2022.02.02 14:46
1037 645 1037 1037 1037 653 653 653 653 653 636 674 674 1030 1199 1199 1199 1188 1167 1167 1188 725 1105 1142 1142 1142
'select ...from...where...not in (select...from...)' no results
3 CS 2022.02.02 14:46
1020 652 652 635 635 635 617 617 582 582 598 627 627 627 679 878 1014 878 878 878 693 693 1094 1094 1094 1094
ABS() rounds NUMERIC values
4 CS 2022.02.02 14:46
1042 639 639 639 639 587 609 609 648 639 648 653 653 677 991 991 991 731 731 731 731 731 1017 1103 1103 1104
Bugcheck 232 (invalid operation) for an aggregated query
5 CS 2024.06.09 15:53
1191 785 785 785 785 699 749 749 749 749 749 881 881 1086 1306 1306 1306 1086 844 844 821 821 1157 1234 1234 1292
Ability to insert child record if parent record is locked but foreign key target unchanged
6 CS 2022.02.02 14:46
1069 672 672 672 672 672 666 666 666 664 664 664 664 828 1073 1073 1073 828 752 752 752 752 1103 1103 1103 1142
PSQL output parameter size limited
7 CS 2022.02.02 14:46
991 580 580 757 757 757 757 757 672 672 672 702 702 702 699 699 699 699 729 1064 1111 1111 1111 1120 1120 1098
MERGE not correctly worked with parameters in MATCHING clause
8 CS 2023.10.05 09:23
1285 810 810 806 806 801 783 783 771 771 812 904 904 904 919 1355 1355 919 1357 1429 1357 1318 1318 1290 1290 1318
CREATE OR ALTER VIEW statement
9 CS 2022.02.02 14:46
4345 2730 2730 2837 2837 2837 2838 2838 2838 2776 2776 2776 2776 4515 4675 4830 4675 4515 4830 4830 4963 4990 4990 4963 4752 4752
Non-privileged monitoring reports wrong attachment data
10 CS 2022.02.02 14:46
940 576 569 576 576 634 634 827 827 601 601 747 747 1000 1100 1100 1135 1135 1078 1078 1078 1078 1110 1110 1101 1101
Floor & ceiling functions give wrong results with exact numeric arguments
11 CS 2022.02.02 14:46
1324 876 876 876 792 792 1304 1304 847 1351 847 825 842 842 842 842 847 886 970 970 1294 1311 1312 1312 1381 1403
Parts of RDB$DB_KEY of views may be inverted when using outer joins
12 CS 2025.06.26 18:01
993 642 X X X X X X X X X X X 652 652 652 680 687 687 687 687 687 995 1041 1058 1082
Tricky index names can defeat the parsing logic when generating a human readable plan
13 CS 2025.06.26 18:07
1167 763 X X X X X X X X X X X 789 763 763 763 789 768 768 768 918 1130 1149 1290 1318
CI column does not group correctly with a second column
14 CS 2022.02.02 14:46
949 616 949 616 616 701 701 624 624 624 624 680 1009 1090 1090 849 1121 849 700 700 700 700 1035 1035 1035 1031
AV using recursive query as subquery in SELECT list and ORDER'ing by them
15 CS 2022.02.02 14:46
1597 1046 1512 1512 1512 1039 1039 1028 1028 1028 1042 1670 1670 1670 1664 1586 1586 1542 1542 1143 1143 1143 1545 1703 1721 1731
Problems with COMMENT ON and strings using introducer (charset)
16 CS 2023.12.10 10:22
1053 674 674 1105 1044 1044 1044 651 641 641 651 1072 1072 1072 1072 1049 1049 1049 1091 1049 964 964 1053 1005 1053 1062
count(*) from big table returns negative result
17 CS 2022.02.02 14:46
1024 667 667 1031 1003 1003 1003 600 592 592 600 947 947 989 989 947 934 934 934 812 812 1020 1033 1020 1020 1033
Incorrect ROW_COUNT value after SINGULAR condition
18 CS 2022.02.02 14:46
1206 747 1206 843 843 839 839 810 805 805 810 1272 1333 1368 1369 1368 1369 1369 1349 1349 1308 1308 1310 1312 1310 1312
Incorrect LEFT JOIN result using table and derived constant subquery
19 CS 2022.02.02 14:46
996 576 996 643 724 643 679 669 679 679 714 714 1024 1040 1073 1087 1087 1087 1046 1042 1042 1042 1057 1057 1057 1057
Built-in function POWER(X, Y) does not work when the X argument is negative and the Y value is scaled numeric but integral
20 CS 2023.11.25 22:13
1199 758 758 758 758 792 843 881 881 881 1206 1321 1321 1388 1388 1520 1383 1383 807 1278 1278 1278 1290 1290 1290 773
Dependencies are not removed after dropping the procedure and the table it depends on in the same transaction
21 SS 2022.02.02 14:46
555 353 348 348 348 363 363 436 363 363 355 524 382 382 370 382 382 470 506 506 470 463 445 445 463 471
Support for WHEN NOT MATCHED BY SOURCE for MERGE statement
22 SS 2023.11.12 10:17
X X X X X X X X X X X X X 1962 1304 1250 1204 1204 1204 1772 1772 1790 1981 2209 2268 2268
Provide ability to run "ALTER SQL SECURITY DEFINER / INVOKER" without specifying further part of proc/func/package
23 CS 2024.01.12 15:40
X X X X X X X X X X X X X 1248 751 1248 751 751 751 725 725 751 843 1209 1209 1209
Inconsistent state of master-detail occurs after RE-connect + 'SET AUTODDL OFF' + 'drop <FK>' which is ROLLED BACK
24 CS 2024.01.23 05:23
X X X X X X X X X X X X X 1085 638 638 623 623 623 657 741 1083 1083 683 683 683
System procedure/function inconsistency between ISQL SHOW FUNCTIONS and SHOW PROCEDURES
25 CS 2025.04.16 17:03
X X X X X X X X X X X X X 1776 1183 1183 1183 1206 1206 1206 1712 1733 1733 1168 1126 1126
Unnest IN/ANY/EXISTS subqueries and optimize them using semi-join algorithm
26 CS 2024.10.26 08:21
X X X X X X X X X X X X X 1191 755 1313 858 888 858 858 742 742 740 740 742 1200
"Unique scan" is incorrectly reported in the explained plan for unique index and IS NULL predicate
27 CS 2022.02.04 18:05
X X X X X X X X X X X X X 1168 774 774 774 910 772 910 910 910 1363 1363 1344 877
AVOID index usage in WHERE <indexed_varchar_field> = <integer_value>
28 CS 2022.02.04 18:05
X X X X X X X X X X X X X 1388 913 913 913 888 888 888 995 1351 1351 1351 1351 1351
Check correct work fix with foreign key
29 CS 2022.02.04 18:05
X X X X X X X X X X X X X 1223 775 1244 1244 1217 1192 1192 823 758 758 758 747 743
Zero divide in SP can crash database when call this SP several times

Elapsed time, milliseconds:

NN Test name mode
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
6.0.0.767
2025.05.01
6.0.0.762
2025.04.30
6.0.0.755
2025.04.29
6.0.0.753
2025.04.27
Test TITLE
1 CS 3024 2558 1524 2704 X X X X X X X X X 1498 1524 1574 1359 1483 1667 1457 1562 1115 1624 1508 1541 1309 1085 784 801 823
User (not SYSDBA) that have privileges with grant option, can't revoke privileges, granted by other user or SYSDBA
2 CS 1184 645 584 1041 1037 597 1115 652 1129 653 636 1004 587 674 618 1030 1199 1209 1217 1167 1188 725 711 1233 1352 629 1105 1142 1207 1154
'select ...from...where...not in (select...from...)' no results
3 CS 1091 1020 652 1129 561 635 1053 617 1092 570 582 1068 568 598 627 679 1014 600 1138 878 1063 670 553 1231 693 1111 1094 964 1111 1025
ABS() rounds NUMERIC values
4 CS 1042 1094 624 1106 639 551 1122 587 1091 586 609 1067 648 639 653 1214 991 677 1283 588 1137 731 719 1345 597 1017 1103 1104 1112 1123
Bugcheck 232 (invalid operation) for an aggregated query
5 CS 1287 1262 657 1191 785 645 1172 670 1247 699 749 1304 720 881 737 1481 1306 1086 1341 844 1388 821 768 1573 753 1234 1157 1330 1292 1326
Ability to insert child record if parent record is locked but foreign key target unchanged
6 CS 1256 1069 573 1171 605 672 1126 632 1062 646 666 1006 617 664 621 1098 1073 828 1149 700 1124 752 600 1323 674 1142 1103 1029 1167 1169
PSQL output parameter size limited
7 CS 1104 1073 569 991 580 577 1049 757 1059 564 672 1053 561 702 614 1129 1079 654 699 641 1064 729 1111 1367 1168 1077 1056 1120 1129 1098
MERGE not correctly worked with parameters in MATCHING clause
8 CS 1393 1285 810 1353 806 801 1278 783 1356 754 771 1417 760 812 904 1470 1355 791 919 1529 1357 840 1429 1605 1290 1318 860 1273 1347 1419
CREATE OR ALTER VIEW statement
9 CS 4955 4530 2648 4345 2676 2730 4624 2837 4625 2699 2838 4782 2494 2776 2684 5059 4675 4515 4995 4830 4464 3082 4990 5656 4963 5062 3816 4752 4728 4977
Non-privileged monitoring reports wrong attachment data
10 CS 1131 948 569 940 548 576 561 634 995 827 565 1036 577 601 747 1100 1000 1207 1135 1054 1176 761 1078 1277 1048 1110 1136 1047 1101 1058
Floor & ceiling functions give wrong results with exact numeric arguments
11 CS 1432 780 1324 1324 876 792 753 1304 744 1364 1351 825 847 1393 722 752 842 847 1380 803 970 886 1517 1311 1294 1381 1312 1446 1403 1433
Parts of RDB$DB_KEY of views may be inverted when using outer joins
12 CS 1144 559 X X X X X X X X X X X 1200 993 630 642 652 680 981 692 687 675 602 995 1157 1151 1041 1058 1082
Tricky index names can defeat the parsing logic when generating a human readable plan
13 CS 1235 669 X X X X X X X X X X X 1251 1167 657 763 789 762 1255 726 918 768 741 1130 1290 1334 1149 1318 1391
CI column does not group correctly with a second column
14 CS 1115 565 982 949 616 585 1092 601 1008 701 587 624 583 1009 1090 680 1337 1121 672 849 1160 700 549 689 1035 1144 1102 974 976 1031
AV using recursive query as subquery in SELECT list and ORDER'ing by them
15 CS 1730 981 1046 1597 1816 886 1512 1039 1539 974 948 1028 1042 1711 1687 1670 1586 1527 1664 1542 1743 1143 989 1051 1545 1703 1721 1767 1761 1731
Problems with COMMENT ON and strings using introducer (charset)
16 CS 1131 1053 613 1107 674 558 1216 1105 1044 566 651 583 641 1078 1164 1072 952 1018 1093 1049 1091 719 1111 634 964 1062 1053 1005 1129 1277
count(*) from big table returns negative result
17 CS 1181 1024 524 1031 667 626 1178 1187 1003 592 600 582 547 1065 1181 947 887 989 1101 934 812 684 1106 590 1020 1033 1067 1020 1008 1312
Incorrect ROW_COUNT value after SINGULAR condition
18 CS 1361 736 1238 747 1206 745 1310 843 839 749 810 805 793 1272 1384 1368 1333 1378 1369 1349 1536 938 1308 1553 1260 1336 1310 1312 1248 1437
Incorrect LEFT JOIN result using table and derived constant subquery
19 CS 1123 576 1053 563 996 556 1110 643 724 582 679 669 714 1024 1073 592 1040 1094 1087 1507 1046 655 1032 1042 1115 1060 1057 1007 1056 1167
Built-in function POWER(X, Y) does not work when the X argument is negative and the Y value is scaled numeric but integral
20 CS 1259 739 1199 1296 758 750 723 1352 905 792 843 881 1206 1321 1388 1520 1288 1527 804 2037 1383 807 785 1278 1301 1380 1290 760 732 773
Dependencies are not removed after dropping the procedure and the table it depends on in the same transaction
21 SS 670 555 582 353 342 330 348 683 436 363 355 524 343 636 310 611 382 370 348 668 506 470 507 439 445 463 438 490 472 471
Support for WHEN NOT MATCHED BY SOURCE for MERGE statement
22 SS 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 2435 2268 2482 2177
Provide ability to run "ALTER SQL SECURITY DEFINER / INVOKER" without specifying further part of proc/func/package
23 CS 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 843 1321 912 1264
Inconsistent state of master-detail occurs after RE-connect + 'SET AUTODDL OFF' + 'drop <FK>' which is ROLLED BACK
24 CS 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 672 683 632 1055
System procedure/function inconsistency between ISQL SHOW FUNCTIONS and SHOW PROCEDURES
25 CS 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 1126 1025 1104 2170
Unnest IN/ANY/EXISTS subqueries and optimize them using semi-join algorithm
26 CS 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 740 676 1200 1455
"Unique scan" is incorrectly reported in the explained plan for unique index and IS NULL predicate
27 CS 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 1604 744 1344 789
AVOID index usage in WHERE <indexed_varchar_field> = <integer_value>
28 CS 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 804 1432 827 1396
Check correct work fix with foreign key
29 CS 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 1320 1332 701 725
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-1083
http://tracker.firebirdsql.org/browse/CORE-1555
http://tracker.firebirdsql.org/browse/CORE-1582
http://tracker.firebirdsql.org/browse/CORE-1605
http://tracker.firebirdsql.org/browse/CORE-1606
http://tracker.firebirdsql.org/browse/CORE-1609
http://tracker.firebirdsql.org/browse/CORE-1624
http://tracker.firebirdsql.org/browse/CORE-1640
http://tracker.firebirdsql.org/browse/CORE-1642
http://tracker.firebirdsql.org/browse/CORE-1677
http://tracker.firebirdsql.org/browse/CORE-2075
http://tracker.firebirdsql.org/browse/CORE-2508
http://tracker.firebirdsql.org/browse/CORE-2555
http://tracker.firebirdsql.org/browse/CORE-2783
http://tracker.firebirdsql.org/browse/CORE-2804
http://tracker.firebirdsql.org/browse/CORE-2957
http://tracker.firebirdsql.org/browse/CORE-2965
http://tracker.firebirdsql.org/browse/CORE-3090
http://tracker.firebirdsql.org/browse/CORE-3091
http://tracker.firebirdsql.org/browse/CORE-3314
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/6681
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):