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

Generated UTC 27.06.2025 02:35
Tested: FB60.   Build / date: 6.0.0.877-8e38f19a / 2025.06.26;
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.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
Test TITLE
1 CS 2022.02.02 14:46
1905 1171 1905 1299 1299 1200 1200 1146 1146 1146 2087 2087 2087 2087 2074 2074 2074 2074 2007 2007 2007 2054 2113 2133 2133 2164
Server shutdown
2 CS 2022.02.02 14:46
1000 610 1007 610 610 610 620 620 631 644 1037 1052 1083 1138 1138 1138 1138 1091 1091 1077 1077 1084 1122 1161 1162 1161
Incorrect value returned with execute statement calculation
3 CS 2022.02.02 14:46
974 637 974 616 616 616 616 587 587 623 1050 1093 1185 1191 1185 1128 1128 1112 1035 1035 1035 1082 1082 1082 1082 1108
Navigation vs IS NULL vs compound index
4 CS 2022.02.02 14:46
2364 1455 1455 1455 1544 1471 1544 2458 2458 2458 2458 2458 2494 2494 2523 2604 2523 2576 2572 2572 2224 2224 1807 1767 1516 1516
Services Manager and gsec truncate First.Middle.Last Name fields to 17 chars instead of 32 chars available in field definition
5 CS 2022.02.02 14:46
1151 746 811 811 943 811 943 1277 1277 1300 1300 1303 1309 1373 1373 1373 1350 1348 1326 1320 1320 1320 977 912 776 766
View with equally named source fields not faisible
6 SS 2025.06.25 15:39
1000 577 572 X X X X X X X X X 572 562 577 562 582 564 576 564 564 540 540 531 531 556
User (not SYSDBA) that have privileges with grant option, can't revoke privileges, granted by other user or SYSDBA
7 CS 2022.02.02 14:46
1158 707 707 707 707 1135 1135 1135 1156 1145 1145 1156 1174 1207 1248 1207 1207 1156 1156 1113 859 1087 1087 887 1087 1103
A remote attacker can check, if a file is present in the system, running firebird server
8 CS 2022.02.02 14:46
1002 635 635 591 635 635 639 677 1038 1038 1013 1038 1038 1104 1123 1123 1123 1041 1041 999 849 849 849 849 849 665
Aliases for the RETURNING clause
9 CS 2022.02.02 14:46
948 571 619 619 747 747 747 1070 1070 1075 1075 1075 1075 1089 1092 1092 1092 1092 1089 1041 1041 1041 992 939 966 939
Possible drop role RDB$ADMIN
10 CS 2025.02.06 06:38
1277 764 913 875 913 913 943 1136 1328 1389 1389 1431 1450 1450 1450 1438 1438 1412 1412 1360 1412 1422 1422 1351 1451 1351
Incorrect TEXT BLOB charset transliteration on VIEW with trigger
11 CS 2022.02.02 14:46
1105 704 1147 806 806 806 806 806 1182 1182 1112 1112 1112 1112 1209 1209 1209 1172 1030 993 993 1047 993 830 1047 830
Wrong data while retrieving from CTEs (or derived tables) with same column names
12 CS 2022.02.02 14:46
1210 722 1210 1055 1055 1055 1055 1055 1263 1334 1337 1343 1343 1376 1407 1407 1376 1334 1274 1268 1268 1274 1274 890 1411 800
Plan returned for query with recursive CTE return wrong count of parenthesis
13 CS 2022.02.02 14:46
1061 614 882 824 824 824 855 855 1151 1196 1174 1188 1188 1235 1192 1210 1210 1192 1130 1111 1111 1113 1130 1113 1113 1101
Window Function: cume_dist()
14 CS 2022.02.02 14:46
1275 790 786 786 786 786 950 966 1362 1362 1343 1362 1362 1511 1511 1511 1502 1481 1391 1359 1359 1369 1369 1369 1396 1369
MON$IO_STATS doesn't report page writes performed asynchronously (at the AST level)
15 SS 2022.02.02 14:46
417 276 310 310 250 250 310 371 371 371 356 336 336 336 336 336 309 309 309 287 331 331 335 287 281 281
isc_info_svc_user_dbpath always returns alias of main security database
16 SS 2023.11.12 10:17
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 2268
Provide ability to run "ALTER SQL SECURITY DEFINER / INVOKER" without specifying further part of proc/func/package
17 CS 2024.01.12 15:40
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 912
Inconsistent state of master-detail occurs after RE-connect + 'SET AUTODDL OFF' + 'drop <FK>' which is ROLLED BACK
18 CS 2024.01.23 05:23
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 683
System procedure/function inconsistency between ISQL SHOW FUNCTIONS and SHOW PROCEDURES
19 CS 2025.04.16 17:03
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 1104
Unnest IN/ANY/EXISTS subqueries and optimize them using semi-join algorithm
20 CS 2024.10.26 08:21
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 740
"Unique scan" is incorrectly reported in the explained plan for unique index and IS NULL predicate
21 CS 2022.02.04 18:05
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 789
AVOID index usage in WHERE <indexed_varchar_field> = <integer_value>
22 CS 2022.02.04 18:05
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 1396
Check correct work fix with foreign key
23 CS 2022.02.04 18:05
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 725
Zero divide in SP can crash database when call this SP several times

Elapsed time, milliseconds:

NN Test name mode
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
6.0.0.745
2025.04.21
Test TITLE
1 CS 1969 1147 1905 1171 2093 1119 2167 1299 1200 1130 1146 1099 2140 2087 2372 2053 1189 2253 2074 2137 1430 2007 1990 2245 2133 2054 2113 2230 2164 2235
Server shutdown
2 CS 1000 610 1088 561 1151 610 1007 606 608 620 644 631 1037 1083 1138 1052 1138 1208 1091 1155 684 1077 1122 1037 1178 1084 1169 1161 1162 1129
Incorrect value returned with execute statement calculation
3 CS 1043 637 1071 588 974 595 1206 616 554 623 587 581 1050 1191 1185 1093 1210 1209 1128 1112 663 1035 949 1158 1082 1108 1039 1045 1127 1212
Navigation vs IS NULL vs compound index
4 CS 2364 1407 2418 1383 2743 1455 1432 2501 1544 1471 2493 2458 2699 2365 2453 2604 2494 2686 2523 2687 1623 2576 2572 2224 1767 1807 1428 1442 1516 1589
Services Manager and gsec truncate First.Middle.Last Name fields to 17 chars instead of 32 chars available in field definition
5 CS 1291 729 1151 746 1271 741 811 1340 943 760 1277 1303 1309 1300 1239 1373 1513 1507 1350 1299 950 1348 1326 1320 977 912 671 760 776 766
View with equally named source fields not faisible
6 SS 1000 1038 1097 X X X X X X X X X 572 560 577 554 582 562 670 543 586 564 576 540 531 511 632 487 588 556
User (not SYSDBA) that have privileges with grant option, can't revoke privileges, granted by other user or SYSDBA
7 CS 1197 1158 642 1183 707 657 707 1135 1288 1256 636 647 1156 1145 1248 1174 1207 1274 1489 1156 859 1113 1208 694 778 1087 1131 887 1151 1103
A remote attacker can check, if a file is present in the system, running firebird server
8 CS 1036 620 1002 531 1058 635 586 591 639 1137 677 1089 1038 953 1013 1104 1168 1251 1123 1041 626 999 1142 604 849 665 1029 1120 564 646
Aliases for the RETURNING clause
9 CS 1021 564 1066 571 948 565 619 747 1070 1091 687 1104 957 1075 1089 953 1195 1114 1092 1089 647 1138 1041 574 1180 992 704 939 966 630
Possible drop role RDB$ADMIN
10 CS 1376 737 1293 724 1277 764 913 875 1328 1496 943 1136 1453 1389 1450 1431 1525 1480 1438 1360 893 1412 1422 836 1555 1511 846 1351 1451 825
Incorrect TEXT BLOB charset transliteration on VIEW with trigger
11 CS 1105 683 1147 704 1297 638 1216 806 662 1347 788 1182 1396 1112 1065 1074 1209 1237 1261 1030 789 1172 993 579 1114 1047 670 830 1144 562
Wrong data while retrieving from CTEs (or derived tables) with same column names
12 CS 1230 713 1252 703 1210 722 1329 1055 982 1263 843 1412 1334 1343 1337 1407 1376 1475 1415 1334 900 1268 1274 890 1423 1448 800 769 1411 778
Plan returned for query with recursive CTE return wrong count of parenthesis
13 CS 1138 613 1065 614 1061 591 882 824 641 1239 855 1196 1151 1235 1174 1188 1270 1304 1192 1210 779 1111 1130 688 1229 1113 1156 662 1101 725
Window Function: cume_dist()
14 CS 1303 790 1275 720 1283 707 786 950 758 1442 966 1381 1362 1343 1296 1511 1617 1553 1481 1502 966 1391 1359 819 1405 1369 1396 893 1520 713
MON$IO_STATS doesn't report page writes performed asynchronously (at the AST level)
15 SS 447 254 276 417 435 228 310 226 250 371 439 529 291 285 356 336 336 360 309 263 276 331 348 287 335 265 344 245 281 329
isc_info_svc_user_dbpath always returns alias of main security database
16 SS 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 1657
Provide ability to run "ALTER SQL SECURITY DEFINER / INVOKER" without specifying further part of proc/func/package
17 CS 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 783
Inconsistent state of master-detail occurs after RE-connect + 'SET AUTODDL OFF' + 'drop <FK>' which is ROLLED BACK
18 CS 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 683
System procedure/function inconsistency between ISQL SHOW FUNCTIONS and SHOW PROCEDURES
19 CS 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 1037
Unnest IN/ANY/EXISTS subqueries and optimize them using semi-join algorithm
20 CS 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 645
"Unique scan" is incorrectly reported in the explained plan for unique index and IS NULL predicate
21 CS 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 772
AVOID index usage in WHERE <indexed_varchar_field> = <integer_value>
22 CS 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 1435
Check correct work fix with foreign key
23 CS 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 690
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-1
http://tracker.firebirdsql.org/browse/CORE-10
http://tracker.firebirdsql.org/browse/CORE-1076
http://tracker.firebirdsql.org/browse/CORE-1078
http://tracker.firebirdsql.org/browse/CORE-1083
http://tracker.firebirdsql.org/browse/CORE-1312
http://tracker.firebirdsql.org/browse/CORE-2
http://tracker.firebirdsql.org/browse/CORE-3546
http://tracker.firebirdsql.org/browse/CORE-3599
http://tracker.firebirdsql.org/browse/CORE-3601
http://tracker.firebirdsql.org/browse/CORE-3611
http://tracker.firebirdsql.org/browse/CORE-3614
http://tracker.firebirdsql.org/browse/CORE-3617
http://tracker.firebirdsql.org/browse/CORE-3625
http://tracker.firebirdsql.org/browse/CORE-6227
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/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):