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

Generated UTC 01.07.2025 03:13
Tested: FB60.   Build / date: 6.0.0.884-f7e5f554 / 2025.06.30;
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.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
Test TITLE
1 CS 2022.02.02 14:46
1187 718 718 1161 1161 1034 1034 853 853 768 768 1207 1316 1316 1337 1348 1422 1422 1422 1322 1304 1197 1001 1001 806 806
Keyword AS not recognized in clause FROM
2 CS 2022.02.02 14:46
1026 634 634 634 634 634 613 613 614 956 964 1038 1061 1061 1061 1080 1080 1108 1108 1073 1056 1016 1002 1002 622 622
Bad handling of /*/ comments in ISQL
3 CS 2022.02.02 14:46
1310 770 770 817 817 817 929 871 929 1241 1295 1376 1376 1376 1376 1379 1379 1379 1329 1293 1293 1329 1248 1248 840 840
Context already in use (BLR error)
4 CS 2022.02.02 14:46
1225 793 793 793 793 793 1151 793 1241 1241 1271 1271 1300 1300 1302 1302 1302 1302 1297 1297 1303 1303 1115 1115 1040 797
Wrong single-segment ascending index on character field with NULL and empty string values
5 CS 2022.02.02 14:46
X 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
ABS() rounds NUMERIC values
6 CS 2022.02.02 14:46
X 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
MERGE not correctly worked with parameters in MATCHING clause
7 CS 2022.02.02 14:46
X 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
Floor & ceiling functions give wrong results with exact numeric arguments
8 SS 2025.06.26 07:18
1231 608 607 X X X X X X X X X X X 606 606 604 597 581 581 579 579 579 579 579 585
Incorrect "key size exceeds implementation restriction for index" error
9 CS 2022.02.02 14:46
X 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
Parts of RDB$DB_KEY of views may be inverted when using outer joins
10 CS 2022.02.02 14:46
X 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
AV using recursive query as subquery in SELECT list and ORDER'ing by them
11 CS 2022.02.02 14:46
X 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
Incorrect LEFT JOIN result using table and derived constant subquery
12 SS 2024.07.29 16:57
458 304 488 544 488 412 412 412 412 453 453 453 330 330 330 360 497 497 478 478 478 478 476 535 476 476
Client-side positioned updates work wrongly with scrollable cursors
13 SS 2023.11.12 10:17
X 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
Provide ability to run "ALTER SQL SECURITY DEFINER / INVOKER" without specifying further part of proc/func/package
14 CS 2024.01.12 15:40
X 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
Inconsistent state of master-detail occurs after RE-connect + 'SET AUTODDL OFF' + 'drop <FK>' which is ROLLED BACK
15 CS 2024.01.23 05:23
X 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
System procedure/function inconsistency between ISQL SHOW FUNCTIONS and SHOW PROCEDURES
16 CS 2025.04.16 17:03
X 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
Unnest IN/ANY/EXISTS subqueries and optimize them using semi-join algorithm
17 CS 2024.10.26 08:21
X 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
"Unique scan" is incorrectly reported in the explained plan for unique index and IS NULL predicate
18 CS 2022.02.04 18:05
X 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
AVOID index usage in WHERE <indexed_varchar_field> = <integer_value>
19 SS 2025.06.20 21:59
644 361 361 491 582 582 X X X X X X X X X X X X X X X X X X X X
Deleting record in master must cause deletions in appropriate detail if FK references to PK and 'ON DELETE CASCADE' option is used.
20 SS 2025.06.20 21:55
657 376 376 657 695 727 X X X X X X X X X X X X X X X X X X X X
Attempt to delete record in master with UK must fail if there is FK record in detail and FK was declared without CASCADE option
21 CS 2022.02.04 18:05
X 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
Check correct work fix with foreign key
22 CS 2022.02.04 18:05
X 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
Zero divide in SP can crash database when call this SP several times

Elapsed time, milliseconds:

NN Test name mode
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
6.0.0.767
2025.05.01
6.0.0.762
2025.04.30
6.0.0.755
2025.04.29
Test TITLE
1 CS 1245 1318 696 718 1187 713 1326 1161 853 1034 768 768 1207 727 1337 1316 1348 1295 1480 1499 1422 1322 854 1304 1197 1001 806 742 705 1291
Keyword AS not recognized in clause FROM
2 CS 1026 1118 592 534 1042 634 989 613 613 956 603 614 964 1069 1038 1061 1080 1031 1155 1132 1073 1108 737 1056 1016 1002 611 622 552 1104
Bad handling of /*/ comments in ISQL
3 CS 1441 1396 727 710 1310 770 1302 817 793 1241 929 871 1400 1425 1295 1376 1323 1404 1379 1391 1293 1329 862 1248 1354 1387 761 840 773 1273
Context already in use (BLR error)
4 CS 1430 1310 682 774 1225 793 1151 793 778 1241 1586 756 1347 1219 1271 1300 1349 1307 1302 1297 1263 1351 877 1344 1303 1040 1115 797 767 743
Wrong single-segment ascending index on character field with NULL and empty string values
5 CS X 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
ABS() rounds NUMERIC values
6 CS X 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
MERGE not correctly worked with parameters in MATCHING clause
7 CS X 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
Floor & ceiling functions give wrong results with exact numeric arguments
8 SS 1231 1380 1369 X X X X X X X X X X X 607 608 606 606 553 604 597 559 581 570 579 585 554 597 573 597
Incorrect "key size exceeds implementation restriction for index" error
9 CS X 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
Parts of RDB$DB_KEY of views may be inverted when using outer joins
10 CS X 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
AV using recursive query as subquery in SELECT list and ORDER'ing by them
11 CS X 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
Incorrect LEFT JOIN result using table and derived constant subquery
12 SS 458 289 304 544 488 298 669 546 292 412 330 453 467 460 328 330 293 554 497 360 538 478 336 535 369 538 476 559 246 329
Client-side positioned updates work wrongly with scrollable cursors
13 SS 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 2435 2268 2482
Provide ability to run "ALTER SQL SECURITY DEFINER / INVOKER" without specifying further part of proc/func/package
14 CS 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 843 1321 912
Inconsistent state of master-detail occurs after RE-connect + 'SET AUTODDL OFF' + 'drop <FK>' which is ROLLED BACK
15 CS 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 672 683 632
System procedure/function inconsistency between ISQL SHOW FUNCTIONS and SHOW PROCEDURES
16 CS 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 1126 1025 1104
Unnest IN/ANY/EXISTS subqueries and optimize them using semi-join algorithm
17 CS 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 740 676 1200
"Unique scan" is incorrectly reported in the explained plan for unique index and IS NULL predicate
18 CS 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 1604 744 1344
AVOID index usage in WHERE <indexed_varchar_field> = <integer_value>
19 SS 644 704 345 361 658 355 694 491 582 723 X X X X X X X X X X X X X X X X X X X X
Deleting record in master must cause deletions in appropriate detail if FK references to PK and 'ON DELETE CASCADE' option is used.
20 SS 702 658 352 349 657 376 752 695 734 727 X X X X X X X X X X X X X X X X X X X X
Attempt to delete record in master with UK must fail if there is FK record in detail and FK was declared without CASCADE option
21 CS 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 804 1432 827
Check correct work fix with foreign key
22 CS 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 1320 1332 701
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-1002
http://tracker.firebirdsql.org/browse/CORE-1004
http://tracker.firebirdsql.org/browse/CORE-1040
http://tracker.firebirdsql.org/browse/CORE-1582
http://tracker.firebirdsql.org/browse/CORE-1624
http://tracker.firebirdsql.org/browse/CORE-1677
http://tracker.firebirdsql.org/browse/CORE-1715
http://tracker.firebirdsql.org/browse/CORE-2075
http://tracker.firebirdsql.org/browse/CORE-2783
http://tracker.firebirdsql.org/browse/CORE-3090
http://tracker.firebirdsql.org/browse/CORE-996
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/cascade/test_master_pk_on_delete_cascade.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/fkey/cascade/test_master_uk_delete_if_no_cascade.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/7057
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):