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 (3 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 (7 rows)
[CURRENT] 05. NEW SLOWDOWN: tests with performance problem for LAST 5 runs (26 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 (59 rows)
08. Has runtime errors: tests with at least one runtime error for previous 30 runs (0 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 (2 rows)
11. All tests: outcomes for previous 30 runs (2672 rows)
12. Skipped: tests which was intentionally excluded from execution (80 rows)

Generated UTC 25.04.2025 01:04
Tested: FB60.   Build / date: 6.0.0.745-78ad8660 / 2025.04.21;
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.745
2025.04.21
6.0.0.744
2025.04.19
6.0.0.742
2025.04.17
6.0.0.737
2025.04.16
6.0.0.736
2025.04.14
6.0.0.735
2025.04.13
6.0.0.734
2025.04.12
6.0.0.730
2025.04.11
6.0.0.726
2025.04.10
6.0.0.725
2025.04.09
6.0.0.722
2025.04.08
6.0.0.719
2025.04.06
6.0.0.717
2025.04.04
6.0.0.716
2025.04.03
6.0.0.715
2025.04.02
6.0.0.710
2025.04.01
6.0.0.708
2025.03.31
6.0.0.707
2025.03.28
6.0.0.698
2025.03.26
6.0.0.693
2025.03.24
6.0.0.687
2025.03.22
6.0.0.686
2025.03.20
6.0.0.685
2025.03.19
6.0.0.680
2025.03.18
6.0.0.677
2025.03.16
6.0.0.676
2025.03.15
Test TITLE
1 CS 2022.02.02 14:46
1086 671 1023 984 1023 984 984 932 707 707 707 886 886 886 684 616 616 616 837 1062 1089 1089 1119 1062 952 952
Generated columns
2 CS 2022.02.02 14:46
990 606 990 606 990 993 993 994 994 1013 763 1013 1043 1043 1028 1028 926 926 926 926 1008 1008 736 721 700 700
Global temporary table instance may pick up not all indices
3 CS 2022.02.02 14:46
1035 604 1011 604 1011 1011 1011 993 993 993 642 993 1012 1059 1012 1012 946 880 880 880 946 887 1020 887 887 887
CREATE VIEW without column list when UNION is used
4 CS 2022.02.02 14:46
1090 681 940 941 941 941 984 984 984 1059 655 655 948 1059 1089 1089 1089 704 704 704 1137 1461 1525 2076 2138 2138
Cannot compile source with "ELSE IF ( <expr> ) THEN" statement and commands to manupulate explicit cursor inside
5 CS 2024.09.12 18:04
1889 1059 1059 1059 1059 1474 1742 1599 1599 1599 1826 1804 1804 1804 1804 1748 1638 1462 1462 1183 1183 1183 1218 1141 1141 981
Indices on computed fields are broken after restore (all keys are NULL)
6 CS 2022.02.02 14:46
1261 828 828 792 792 1212 1260 1260 1260 1141 1141 1095 1141 1200 1204 1200 1200 865 865 732 865 751 1105 1083 1083 993
Expression index may not be used by the optimizer if created and used in different connection charsets
7 CS 2022.02.02 14:46
1315 823 823 823 1306 1291 1306 1291 1291 893 893 893 994 1296 1344 1296 1344 1296 1068 1068 1068 1066 1068 1066 1066 1475
Error "no current record to fetch" if some record is to be deleted both by the statement itself and by some trigger fired during statement execution
8 CS 2025.01.19 14:06
2250 1387 1365 1387 1365 1357 1357 1399 1430 1522 1528 2311 2311 1528 1528 1530 1530 2630 2630 2679 2683 3020 3150 3150 3020 1846
The partial index is not involved when filtering conditions through OR.
9 CS 2023.11.18 14:14
969 627 627 604 590 590 608 608 611 628 956 956 956 869 869 636 636 637 1085 1087 1090 1384 1474 1474 1384 1088
Removing first column with SET WIDTH crashes ISQL
10 CS 2025.01.18 13:03
1212 714 1212 1245 1212 793 793 749 682 682 749 770 770 853 853 853 853 1338 1338 1304 1304 1097 1080 791 791 664
Non-correlated sub-query is evaluated multiple times if it is based on a VIEW rathe than on appropriate derived table.
11 CS 2023.11.27 19:20
1013 589 1013 1020 1020 1020 1020 607 604 604 604 604 707 707 707 707 707 1116 1116 1030 1116 1030 1030 719 719 679
Unexpected Results when Using Natural Right Join
12 CS 2023.11.29 07:13
984 614 984 1004 984 965 965 591 591 591 591 615 687 687 687 687 687 1084 1084 1003 1084 1003 1003 716 716 656
ISQL sets return code to 1 for script that is called via IN command even if this script completes OK. Problem caused by presence of tail comments in the callee
13 CS 2024.01.10 07:14
986 588 779 986 978 779 779 590 590 590 639 791 791 701 701 701 701 1040 1052 1040 1063 1040 1063 863 863 701
The ability to retrieve the total number of pages in the database
14 CS 2024.01.12 15:40
1213 753 712 1164 1081 712 702 702 702 702 723 1227 1227 786 786 786 786 1319 1319 1248 1276 1248 1188 777 777 667
Inconsistent state of master-detail occurs after RE-connect + 'SET AUTODDL OFF' + 'drop <FK>' which is ROLLED BACK
15 CS 2023.12.04 08:40
992 636 813 992 813 563 664 588 588 664 664 724 724 599 599 685 685 1112 1112 1132 1189 2498 2704 2704 2704 2544
Unexpected Results when Using CASE-WHEN with LEFT JOIN
16 CS 2023.12.07 10:10
952 594 952 952 595 595 628 595 615 628 615 615 615 651 651 651 651 1155 1160 1155 1155 740 740 735 701 701
Unexpected results when the join condition contains the OR predicate
17 CS 2024.01.22 20:57
1113 690 1113 1113 1076 690 1076 662 662 1160 1160 1160 1160 1227 1236 1236 1217 1264 1239 1217 1186 767 767 713 675 675
ALTER TABLE ALTER COLUMN <textual_field> can not be changed properly in some cases
18 CS 2024.01.12 15:40
1023 587 952 952 928 843 928 843 843 1093 1093 1093 1093 1043 1043 1043 991 1035 1035 991 729 760 760 729 638 638
Some default values is set incorrectly for SC/CS architectures
19 CS 2023.12.20 13:02
1024 604 1024 1024 1004 1004 1028 1004 1075 1075 1045 1045 1045 1045 1136 1136 978 1107 1107 978 686 804 804 686 643 626
Incorrect variable usage using UPDATE OR INSERT
20 CS 2024.01.23 05:23
1002 636 1002 1002 969 969 1008 969 916 1024 916 916 801 1037 1037 1037 672 1143 1030 875 875 884 884 875 884 884
System procedure/function inconsistency between ISQL SHOW FUNCTIONS and SHOW PROCEDURES
21 CS 2024.07.10 09:03
1189 729 1184 1189 1184 1184 1184 1250 901 1250 1233 1245 1233 1245 1245 1245 713 1269 1221 1221 1221 1245 1245 1245 1103 1085
Option for GEN_UUID to generate v7 UUID
22 CS 2024.03.13 19:34
1075 675 968 968 968 675 604 599 591 599 599 656 656 1200 1200 1200 701 1160 1160 717 717 717 717 693 693 695
Unexpected results when comparing integer with string containing value out of range of that integer datatype
23 CS 2025.02.13 13:01
1489 930 1503 1503 1281 856 856 856 856 856 856 910 1336 910 910 920 920 920 1026 1026 1143 1143 714 714 880 687
Fix implicitly used collations after ALTER DOMAIN
24 CS 2025.03.31 12:33
977 597 977 980 977 567 652 609 609 652 652 609 937 X X X X X X X X X X X X X
Error "Can not transliterate character" with text concatention utf8 + win1250
25 SS 2025.04.24 18:30
X 416 187 187 187 198 213 345 374 374 X X X X X X X X X X X X X X X X
Segfault/AV on incorrect databases.conf starting with subconfig (without line alias=database_path)
26 CS 2022.02.04 18:05
1037 686 1027 1027 1020 1020 1020 635 592 592 630 630 652 750 750 1076 750 719 719 820 719 787 787 787 769 769
Computed fields

Elapsed time, milliseconds:

NN Test name mode
6.0.0.745
2025.04.21
6.0.0.744
2025.04.19
6.0.0.742
2025.04.17
6.0.0.737
2025.04.16
6.0.0.736
2025.04.14
6.0.0.735
2025.04.13
6.0.0.734
2025.04.12
6.0.0.730
2025.04.11
6.0.0.726
2025.04.10
6.0.0.725
2025.04.09
6.0.0.722
2025.04.08
6.0.0.719
2025.04.06
6.0.0.717
2025.04.04
6.0.0.716
2025.04.03
6.0.0.715
2025.04.02
6.0.0.710
2025.04.01
6.0.0.708
2025.03.31
6.0.0.707
2025.03.28
6.0.0.698
2025.03.26
6.0.0.693
2025.03.24
6.0.0.687
2025.03.22
6.0.0.686
2025.03.20
6.0.0.685
2025.03.19
6.0.0.680
2025.03.18
6.0.0.677
2025.03.16
6.0.0.676
2025.03.15
6.0.0.673
2025.03.13
6.0.0.671
2025.03.12
6.0.0.663
2025.03.11
6.0.0.661
2025.03.07
Test TITLE
1 CS 1193 671 1092 635 1086 517 1023 984 1041 567 567 932 707 886 684 1066 1101 593 616 615 837 1089 1119 1062 1630 952 1544 896 952 1405
Generated columns
2 CS 1173 603 1023 578 990 606 993 562 994 1056 763 1013 654 1043 628 1144 1043 1028 614 691 926 1069 1008 736 1148 721 580 700 642 1085
Global temporary table instance may pick up not all indices
3 CS 1162 598 1211 604 1035 572 1011 594 1016 1079 642 993 590 1059 566 1105 1012 1083 609 690 946 880 1140 869 1183 887 1020 811 832 1162
CREATE VIEW without column list when UNION is used
4 CS 1097 591 681 1090 1161 547 940 941 984 1144 1092 652 655 1059 603 948 1089 1092 1094 667 645 704 1137 1461 2076 1525 2407 2230 2138 1893
Cannot compile source with "ELSE IF ( <expr> ) THEN" statement and commands to manupulate explicit cursor inside
5 CS 1956 1992 1017 1889 956 1059 1742 968 1756 1474 1826 1599 1122 1888 1868 1804 1638 1748 1968 1462 1111 1183 1798 753 1218 726 1237 1141 635 981
Indices on computed fields are broken after restore (all keys are NULL)
6 CS 1403 1261 828 1435 654 792 1212 671 1275 1260 1412 1095 955 1141 1220 937 1200 1204 1352 650 865 716 1301 732 1105 751 1237 1083 617 993
Expression index may not be used by the optimizer if created and used in different connection charsets
7 CS 1513 1495 811 823 1315 744 1321 689 1306 1291 1498 887 784 893 1435 994 1344 1296 1509 819 1370 937 1068 1083 859 1066 1672 868 1565 1475
Error "no current record to fetch" if some record is to be deleted both by the statement itself and by some trigger fired during statement execution
8 CS 2250 2795 1327 2483 1365 1387 1357 1399 1322 1335 1430 1522 2311 2679 1528 2371 1497 1404 2630 1530 2683 2679 2575 3150 3020 3216 3332 1786 1594 1846
The partial index is not involved when filtering conditions through OR.
9 CS 1028 985 627 969 604 580 659 590 523 628 608 611 956 1109 1006 869 636 631 1085 610 637 1090 1087 1474 1974 1384 1999 1033 1088 1073
Removing first column with SET WIDTH crashes ISQL
10 CS 1544 685 714 1252 1212 686 1245 1263 793 671 682 749 668 1234 770 1379 743 853 1338 649 1399 1382 1304 719 1097 791 1080 664 598 581
Non-correlated sub-query is evaluated multiple times if it is based on a VIEW rathe than on appropriate derived table.
11 CS 1280 589 571 1152 1013 557 1030 1020 1049 595 607 593 604 1039 562 1154 707 556 1128 595 1197 1116 1030 714 1181 719 1228 625 679 521
Unexpected Results when Using Natural Right Join
12 CS 1095 614 545 1064 984 510 1038 1004 965 537 560 591 615 962 585 1131 687 595 1203 560 1084 1136 1003 653 1147 716 1007 599 656 541
ISQL sets return code to 1 for script that is called via IN command even if this script completes OK. Problem caused by presence of tail comments in the callee
13 CS 1065 557 588 1076 986 540 779 1060 978 564 590 533 791 1068 639 1060 701 580 1052 560 1114 1040 1063 835 1339 863 1228 695 701 623
The ability to retrieve the total number of pages in the database
14 CS 1361 753 620 1348 1213 712 641 1164 1081 664 702 687 1227 1245 723 1289 738 786 1408 758 1468 1319 1248 662 1276 777 1188 629 667 571
Inconsistent state of master-detail occurs after RE-connect + 'SET AUTODDL OFF' + 'drop <FK>' which is ROLLED BACK
15 CS 1132 636 593 1097 992 563 813 1227 541 541 664 588 724 996 586 1176 595 599 1112 685 1189 1132 1108 2498 3964 2704 3638 2544 2282 1805
Unexpected Results when Using CASE-WHEN with LEFT JOIN
16 CS 1100 588 594 1044 952 557 1099 549 595 628 760 568 615 1103 600 1205 583 651 1372 643 1155 1206 1160 740 639 735 1007 576 701 567
Unexpected results when the join condition contains the OR predicate
17 CS 1464 649 680 1185 1113 690 1135 1076 602 662 1427 640 1160 1227 685 1236 626 1294 1490 1217 1186 1264 1239 767 606 713 1014 675 616 509
ALTER TABLE ALTER COLUMN <textual_field> can not be changed properly in some cases
18 CS 1071 587 552 1185 1023 564 952 928 613 843 1124 573 1111 1093 567 1128 619 1043 1127 991 628 1035 1055 729 620 760 1127 632 638 600
Some default values is set incorrectly for SC/CS architectures
19 CS 1076 564 561 1039 1024 604 1028 1004 717 1170 1076 617 1075 1045 575 1136 647 1152 1142 978 686 1107 1155 686 643 804 1184 626 615 550
Incorrect variable usage using UPDATE OR INSERT
20 CS 1116 608 612 1024 1002 636 1008 969 566 1024 1067 916 801 1156 572 1037 625 1207 1143 668 672 1212 1030 875 854 884 1331 848 917 761
System procedure/function inconsistency between ISQL SHOW FUNCTIONS and SHOW PROCEDURES
21 CS 1286 729 682 1216 1189 720 1184 1283 752 1250 901 1252 719 1272 1233 1245 713 1269 1511 689 710 1351 1221 1245 1103 1317 1805 1085 1044 994
Option for GEN_UUID to generate v7 UUID
22 CS 1131 613 1171 595 1075 675 968 1106 569 604 591 599 583 1356 656 1200 598 1251 1308 701 661 1160 1257 717 693 658 1240 673 695 961
Unexpected results when comparing integer with string containing value out of range of that integer datatype
23 CS 1489 930 849 1521 1519 730 1503 1281 785 856 856 824 1519 1336 831 910 1475 865 920 1026 849 1623 1444 714 1143 687 598 1128 880 599
Fix implicitly used collations after ALTER DOMAIN
24 CS 1107 558 597 1099 977 567 1048 980 564 555 652 609 937 1123 597 594 1064 X X X X X X X X X X X X X
Error "Can not transliterate character" with text concatention utf8 + win1250
25 SS X 471 483 416 176 187 183 345 198 213 413 374 411 315 X X X X X X X X X X X X X X X X
Segfault/AV on incorrect databases.conf starting with subconfig (without line alias=database_path)
26 CS 1168 686 1037 1181 563 589 1027 1059 1020 565 635 555 592 652 630 1076 750 1125 719 1100 655 719 1140 820 653 787 769 1043 684 737
Computed fields

List of tests in this report:


http://tracker.firebirdsql.org/browse/CORE-1386
http://tracker.firebirdsql.org/browse/CORE-1401
http://tracker.firebirdsql.org/browse/CORE-1402
http://tracker.firebirdsql.org/browse/CORE-4929
http://tracker.firebirdsql.org/browse/CORE-5118
http://tracker.firebirdsql.org/browse/CORE-5122
http://tracker.firebirdsql.org/browse/CORE-5142
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_computed_fields_06.py
https://github.com/FirebirdSQL/firebird/issues/7804
https://github.com/FirebirdSQL/firebird/issues/7844
https://github.com/FirebirdSQL/firebird/issues/7863
https://github.com/FirebirdSQL/firebird/issues/7879
https://github.com/FirebirdSQL/firebird/issues/7886
https://github.com/FirebirdSQL/firebird/issues/7888
https://github.com/FirebirdSQL/firebird/issues/7899
https://github.com/FirebirdSQL/firebird/issues/7903
https://github.com/FirebirdSQL/firebird/issues/7908
https://github.com/FirebirdSQL/firebird/issues/7924
https://github.com/FirebirdSQL/firebird/issues/7927
https://github.com/FirebirdSQL/firebird/issues/7931
https://github.com/FirebirdSQL/firebird/issues/7962
https://github.com/FirebirdSQL/firebird/issues/7980
https://github.com/FirebirdSQL/firebird/issues/7997
https://github.com/FirebirdSQL/firebird/issues/8434
https://github.com/FirebirdSQL/firebird/issues/8435
https://github.com/FirebirdSQL/firebird/issues/8485
=== end of list ===

Last commits information (all timestamps in UTC):