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 (15 rows)
05. NEW SLOWDOWN: tests with performance problem for LAST 5 runs (43 rows)
[CURRENT] 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 (55 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 (0 rows)
11. All tests: outcomes for previous 30 runs (2695 rows)
12. Skipped: tests which was intentionally excluded from execution (79 rows)

Generated UTC 07.06.2025 01:31
Tested: FB60.   Build / date: 6.0.0.797-303e8d4b / 2025.06.06;
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

Performance slowdown for more than 5 recent runs - moving medians

At least 2 recent moving medians (window = 5) greater than "normal" for at least 1.5x. No more than 50 rows are shown, pre-filtered in descending order of ratio between latest and "normal" medians:
NN Test name mode Test last update Moving medians chart
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
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
Test TITLE
1 CS 2022.02.02 14:46
1389 1389 1389 1389 1389 1247 1336 1366 1336 1241 734 732 732 702 732 1229 1229 1199 1229 1199 1198 1196 1198 1198 1196 1199
Optimization problem with COALESCE
2 CS 2024.10.31 10:17
1819 1772 1675 1591 1591 1591 1591 1591 1568 1568 1568 1568 1568 1449 941 914 914 914 941 935 1043 1043 1099 1043 1099 1099
Charset transliterations don't work with EXECUTE STATEMENT
3 CS 2022.02.02 14:46
1164 1155 1155 1134 1129 1129 1091 1091 1091 954 954 966 966 966 966 966 604 1011 604 1011 1011 1011 993 993 993 642
CREATE VIEW without column list when UNION is used
4 CS 2022.02.02 14:46
1159 1100 1087 1078 1051 1028 1024 1024 614 603 597 603 614 823 1017 1017 1017 612 612 587 612 612 843 843 843 843
Conversion from double to varchar insert trailing spaces
5 CS 2022.02.02 14:46
1104 1104 1061 1032 1032 1032 1035 1063 1063 1076 1116 1076 1076 1076 1119 1044 1044 578 578 578 839 915 1000 1070 1070 1070
Include information about context variables into the monitoring tables
6 CS 2023.11.25 22:13
1520 1383 1383 807 1278 1278 1278 1290 1290 1290 773 773 773 793 1316 1316 1316 1322 1301 1272 1288 1276 1276 1276 1288 1295
Dependencies are not removed after dropping the procedure and the table it depends on in the same transaction
7 CS 2022.02.02 14:46
1138 1138 1001 995 995 995 995 1049 1134 1134 925 599 599 599 599 953 985 1003 1003 1012 1029 1029 1080 1080 1080 1023
Wrong results (internal wrapping occured) for the multi-byte blob SUBSTRING function and its boundary arguments
8 CS 2022.02.02 14:46
1254 1142 1142 1142 1211 1142 1161 1161 1161 1097 1113 1097 1113 1097 1113 907 907 907 939 939 1020 1020 1021 1020 597 597
Incorrect results when left join on subquery with constant column
9 CS 2022.02.02 14:46
1134 1049 1038 1038 1038 1063 1063 1064 1064 1063 1073 1073 1020 585 1020 1020 1020 952 992 992 992 1025 1055 1059 1059 1120
Failed attempt to violate unique constraint could leave unneeded "lock conflict" error in status-vector
10 CS 2022.02.02 14:46
1811 1811 1811 1756 1746 1650 1650 1650 1662 1565 1635 1565 1565 948 948 948 948 948 933 1525 1525 1546 1546 1557 1576 1576
Can't drop table when computed field depends on later created another field
11 CS 2022.02.02 14:46
1291 1240 1240 1236 1100 1048 1100 1235 1222 1222 1222 1052 686 686 686 706 713 1047 1123 1123 1047 1044 1044 1044 707 788
computed index by substring function for long columns
12 CS 2022.02.02 14:46
1177 1177 1177 1167 1167 1105 1040 1040 621 613 613 621 625 1002 1002 1002 995 652 652 589 587 589 609 589 609 619
isql does not insert boolean values correctly, always shown as False
13 CS 2022.02.02 14:46
1484 1413 1413 1352 1352 1352 1352 1352 739 724 724 739 799 1090 1407 1407 1407 800 800 770 770 746 706 706 704 706
Incorrect full join result with ROW_NUMBER() Function in CTE
14 CS 2022.02.02 14:46
1163 1067 1067 1067 1067 1068 1068 1068 601 601 601 609 672 882 1103 1103 1103 560 560 560 583 594 605 741 743 888
Regression: Server crashes when executing sql query "delete from mytable order by id desc rows 2"
15 CS 2022.02.02 14:46
1256 1256 1256 1178 1083 1055 1055 1055 1055 1055 641 641 679 679 973 973 973 631 586 586 586 586 622 638 1123 1123
Sharp-S character treated incorrectly in UNICODE_CI_AI collation
16 CS 2024.10.31 10:17
1488 1488 1488 1431 1410 1356 1356 1356 1347 1183 1200 1200 1157 1157 1157 1155 758 728 724 724 724 724 732 798 1366 1366
The parameterized exception does not accept not ASCII characters as parameter
17 CS 2022.02.02 14:46
1095 1095 1095 1075 1051 1051 1051 1142 1142 1142 1182 1093 1071 1071 998 991 934 583 542 542 583 625 648 1075 1075 1075
GTT should not reference permanent relation
18 CS 2022.02.02 14:46
1165 1116 1068 1136 1136 1059 1112 1112 1098 1098 1098 1098 1098 1100 1100 1100 1040 1040 598 583 598 598 635 974 1073 1073
Parametrized queries using RDB$DB_KEY do not work
19 CS 2022.02.02 14:46
1133 1133 1110 1108 1062 1062 1062 1062 1085 1085 1094 1098 1098 1098 1142 1142 971 971 556 551 556 556 573 843 843 928
Context parsing error with derived tables and CASE functions
20 CS 2023.12.12 08:08
1244 1244 1244 1198 1174 1174 1028 1028 1028 1075 1075 1126 1126 1132 1132 1124 1033 1033 617 599 599 599 617 987 987 989
Engine crashes in case of re-creation of an erratic package body
21 CS 2022.02.02 14:46
1209 1209 1187 1107 1107 1107 1044 1044 1012 1012 1012 1079 1079 1156 1156 1064 1061 1012 575 575 587 587 789 908 908 973
FB 3: TYPE OF arguments of stored functions will hang firebird engine if depending domain or column is changed
22 CS 2022.02.02 14:46
1523 1523 1507 1523 1523 1507 1392 1392 1249 1249 1249 1400 1407 1425 1450 1450 1450 1450 1349 806 1349 1355 1253 1355 1355 1391
fbsvcmgr doesn't recognise sts_record_versions and other sts switches
23 CS 2022.02.07 17:03
1608 1527 1472 1472 1472 1497 1517 1536 1531 1531 1555 1555 1531 1555 1555 1510 1424 1335 808 791 791 791 1380 1380 1380 1380
Lookup (or scan) in descending index could be very inefficient for some keys
24 CS 2022.02.02 14:46
1212 1203 1203 1062 1062 1062 1062 1062 1015 1003 1003 1003 1017 1077 1171 1077 1017 997 616 593 616 616 918 925 944 1003
Engine crashes when attempt to REcreate table with FK after syntax error before such recreating
25 CS 2022.02.02 14:46
1421 1421 1421 1318 1420 1400 1243 1243 1189 1158 1158 1189 1311 1351 1360 1351 1351 1160 699 699 723 723 1058 1058 1098 1098
Fields present only in WHERE clause of views WITH CHECK OPTION causes invalid CHECK CONSTRAINT violation
26 CS 2022.02.02 14:46
1415 1415 1328 1328 1328 1350 1350 1350 1296 1296 1296 1324 1373 1373 1374 1374 1323 1305 745 745 832 832 1151 1151 1321 1321
Usage of field(s) alias in view WITH CHECK OPTION leads to incorrect compile error or incorrect internal triggers
27 CS 2023.03.04 16:28
1460 1420 1420 1349 1349 1355 1349 1349 1257 1257 1257 1312 1357 1357 1395 1352 1352 1328 764 764 768 768 1160 1160 1179 1179
Regression: Predicates involving PSQL variables/parameters are not pushed inside the aggregation
28 CS 2022.02.02 14:46
993 993 933 933 927 909 863 909 863 524 524 949 949 958 958 949 1028 936 919 919 870 870 541 541 898 932
Report the remote port number in MON$ATTACHMENTS
29 CS 2022.02.02 14:46
1160 1164 1164 1071 1016 1016 917 917 917 602 602 640 1014 1014 1068 1068 1068 986 986 976 962 962 1012 1036 1082 1082
Add datatypes (VAR)BINARY(n) and BINARY VARYING(n) as alias for (VAR)CHAR(n) CHARACTER SET OCTETS
30 CS 2022.02.02 14:46
1204 1194 1194 1066 1066 1063 1031 1031 628 628 628 639 862 1037 1037 940 940 879 730 632 616 632 620 620 628 628
Garbage value in RDB$FIELD_SUB_TYPE in RDB$FUNCTION_ARGUMENTS after altering function
31 SS 2022.08.18 10:51
625 559 559 559 557 521 465 521 465 465 308 308 308 550 588 588 550 401 391 391 391 401 391 404 347 408
MON$ATTACHMENTS.MON$TIMESTAMP is incorrect when DefaultTimeZone is configured with time zone different from the server's default
32 SS 2024.12.29 06:59
25106 25106 23445 23445 23445 24594 24594 24594 23072 22461 22461 22669 22669 23584 23705 23705 23705 12770 12492 12365 12492 12502 12502 13568 13805 21071
Indexed STARTING WITH execution is very slow with UNICODE collation
33 SS 2023.05.21 20:53
11132 9885 9288 9288 9288 9572 9572 10263 9572 9371 9371 8587 8587 9756 9756 7956 4787 X 4745 4593 4745 4787 4939 5689 8392 X
Significant performance regression of SIMILAR TO and SUBSTRING(SIMILAR) when pattern is taken from variable (rather than directly specified)
34 SS 2024.12.30 09:13
18593 18931 18931 18253 18253 18333 18197 18197 17471 17471 17297 17297 17197 16816 16816 16816 16214 8845 8845 8845 9013 9142 9165 14301 16633 16633
Performance effect of applying 'DISABLE-COMPRESSIONS=1' in UNICODE collation for LOCALE=cs_CZ
35 SS 2024.12.30 09:13
19328 19328 18444 18444 18444 19190 19190 19190 17689 17663 17663 17663 17689 17736 18063 17736 17736 8791 8791 8791 9071 9228 9238 16070 16781 16781
Performance effect of applying 'DISABLE-COMPRESSIONS=1' in UNICODE collation for LOCALE=hu_HU
36 SS 2023.02.20 13:37
3121 3121 3121 3121 3071 2980 2985 2985 2985 2930 2930 2897 2897 2897 2806 2803 2713 1644 1644 1594 1596 1596 1734 2533 2664 2806
Dummy (always true) conditions may change the join order
37 SS 2023.05.13 17:33
74939 74939 74939 73884 73884 73884 74281 74281 74281 71057 68741 66572 66572 68741 70711 70711 70711 32676 31962 31440 31440 32676 39208 57558 61351 61351
Improve performance of STARTING WITH with insensitive collations
38 SS 2024.08.20 03:12
738 629 629 629 701 647 647 647 640 376 366 366 366 593 613 613 609 608 608 608 607 607 596 465 358 358
WHEN NOT MATCHED BY SOURCE - does not work with a direct table as source
39 SS 2025.03.20 20:26
589 589 589 585 526 585 526 526 524 523 523 524 532 576 576 532 466 301 301 296 301 307 448 448 539 539
Inheritance of WINDOW does not work
40 SS 2025.04.02 09:03
667 667 636 605 595 595 595 687 693 693 687 669 669 669 672 672 672 342 342 342 350 383 645 653 680 680
Fix reset of db guid in fixup
41 SS 2022.02.04 18:05
767 638 638 638 638 638 725 778 778 778 712 689 689 662 689 655 655 398 398 398 403 528 612 676 676 682
TIMESTAMP in index with values below julian date
42 CS 2022.07.31 08:04
1194 1194 1096 1045 1040 1040 1045 1116 1127 1127 1116 1042 632 632 632 621 621 672 672 952 952 907 907 636 610 584
Test for external table with field of DOUBLE PRECISION datatype
43 SS 2022.02.04 18:05
588 527 467 527 527 618 618 618 518 501 310 310 310 342 404 405 475 487 487 501 487 487 484 540 484 521
Statement with TRIM raises "bad BLR -- invalid stream"
44 CS 2025.05.17 07:35
3540 3540 3540 3468 2323 949 949 949 982 999 999 982 1408 1482 917 917 1358 1304 1085 1085 1304 1085 1085 934 974 934
Minimum grant test
45 SS 2025.05.17 07:35
1733 1733 1716 1716 1290 840 840 735 655 434 428 428 434 468 529 683 643 613 613 643 613 613 610 664 664 664
Minimum grant test
46 SS 2022.02.04 18:05
581 545 533 545 544 544 565 565 544 464 464 464 523 558 559 558 558 491 491 489 480 491 496 480 309 496
CAST CHAR -> TIME
47 SS 2022.02.04 18:05
589 589 589 553 529 529 529 538 538 561 538 572 608 608 551 551 461 298 298 298 291 298 335 376 424 456
LOG10( <number> )
48 SS 2022.02.04 18:05
613 613 613 655 533 533 632 632 632 632 581 549 549 581 596 596 596 500 310 310 329 500 472 521 527 562
GEN_UUID()
49 CS 2022.02.04 18:05
6154 6154 6154 6302 6302 6302 6145 5072 4739 4739 2865 5072 6032 6032 6032 6032 5706 4904 4904 4904 5464 5464 5541 5785 5785 5477
Verify ability to create exactly 254 changes of format (increasing it by 1) after initial creating table
50 SS 2023.11.25 21:40
1231 1370 1370 1231 1432 1346 1346 1498 1498 1498 1498 1088 1088 1186 1186 1186 1186 1186 1071 1046 1046 1045 985 654 985 985
Check ability of outer join simplification.

Elapsed time, milliseconds:

NN Test name mode Test last update
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
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
Test TITLE
1 CS 2022.02.02 14:46 1168 1349 1519 1455 1389 1247 892 1389 1477 1241 1336 1366 734 702 732 648 1233 674 1229 1238 1199 1136 1305 1198 1189 1196 1300 1204 699 1199
Optimization problem with COALESCE
2 CS 2024.10.31 10:17 1899 1819 1675 1849 1772 1575 1243 1591 1627 1674 963 1057 1568 1639 1674 1449 891 898 941 914 1485 893 1475 935 1043 1262 1099 896 1694 1012
Charset transliterations don't work with EXECUTE STATEMENT
3 CS 2022.02.02 14:46 1176 1073 1155 1200 1164 1134 692 1129 1091 1219 656 669 1134 954 1080 966 598 1211 604 1035 572 1011 594 1016 1079 642 993 590 1059 566
CREATE VIEW without column list when UNION is used
4 CS 2022.02.02 14:46 1168 1163 1159 1087 1100 1051 701 1078 1028 1024 580 603 614 592 597 823 1076 1017 1045 557 514 612 1062 587 955 570 843 929 656 1004
Conversion from double to varchar insert trailing spaces
5 CS 2022.02.02 14:46 986 1104 1242 1237 1061 616 636 1032 1063 1035 1116 1135 582 1076 1172 1025 1143 1044 1119 555 555 578 915 1000 839 1070 1091 1108 1046 1031
Include information about context variables into the monitoring tables
6 CS 2023.11.25 22:13 1520 1288 1527 804 2037 1383 807 785 1278 1301 1380 1290 760 732 773 793 1316 1367 1372 1272 1301 1322 1272 1224 1288 1276 1362 751 1295 1351
Dependencies are not removed after dropping the procedure and the table it depends on in the same transaction
7 CS 2022.02.02 14:46 1063 1143 1273 1001 1138 949 619 995 1049 1150 925 1134 1140 599 595 599 576 1022 985 953 1012 1003 1029 1175 1080 1023 1128 911 1152 563
Wrong results (internal wrapping occured) for the multi-byte blob SUBSTRING function and its boundary arguments
8 CS 2022.02.02 14:46 1288 1113 1554 1119 1254 1142 655 1211 1223 1061 1161 990 1246 1097 1113 617 1165 653 1116 907 587 939 1021 1024 1020 588 1151 597 573 1180
Incorrect results when left join on subquery with constant column
9 CS 2022.02.02 14:46 1134 1049 1185 1178 1036 1038 623 1135 1064 1063 647 1156 1073 565 1074 585 1020 551 1083 1020 564 952 992 1077 1025 1135 1055 1059 1135 1120
Failed attempt to violate unique constraint could leave unneeded "lock conflict" error in status-vector
10 CS 2022.02.02 14:46 1653 1631 1979 1811 1869 1756 1092 1650 1746 994 1662 1459 1719 1565 1635 948 948 948 933 1530 853 1525 848 1557 1546 1872 1461 1729 1576 945
Can't drop table when computed field depends on later created another field
11 CS 2022.02.02 14:46 1375 1230 1291 1323 1240 1048 819 1236 1100 773 1259 1235 1222 1052 686 670 645 706 713 1208 1047 1123 1130 1044 707 629 1101 1412 640 788
computed index by substring function for long columns
12 CS 2022.02.02 14:46 1094 1056 1267 1180 1177 1167 704 1105 1385 1040 595 621 602 613 625 1002 1107 1176 995 652 536 578 1031 589 587 619 609 585 647 1081
isql does not insert boolean values correctly, always shown as False
13 CS 2022.02.02 14:46 1489 1131 1541 1413 1484 1176 999 1352 1529 1555 724 739 685 682 799 1090 1407 1718 1492 636 800 746 1302 770 636 692 706 718 704 1398
Incorrect full join result with ROW_NUMBER() Function in CTE
14 CS 2022.02.02 14:46 1188 998 1173 1163 1067 1030 685 1068 1070 1105 601 573 586 672 609 882 1138 1103 1148 523 560 518 605 594 583 888 741 743 1129 1033
Regression: Server crashes when executing sql query "delete from mytable order by id desc rows 2"
15 CS 2022.02.02 14:46 1115 1194 1256 1360 1531 1178 795 1083 1046 1055 1132 638 1077 641 635 679 1044 998 973 586 631 560 568 622 586 1126 638 1123 1170 1000
Sharp-S character treated incorrectly in UNICODE_CI_AI collation
16 CS 2024.10.31 10:17 1420 1305 1525 1553 1488 1431 968 1356 1410 1183 1461 1347 774 830 1200 1428 1157 758 1155 728 710 724 724 732 696 1453 1457 798 1366 1252
The parameterized exception does not accept not ASCII characters as parameter
17 CS 2022.02.02 14:46 1107 1025 1144 1075 1095 1139 728 971 1051 1142 1219 1182 1093 1071 1203 991 998 1126 934 533 542 583 537 625 648 1075 1078 1117 1035 935
GTT should not reference permanent relation
18 CS 2022.02.02 14:46 1289 1116 1068 1180 1165 1059 675 1136 1207 701 1112 1072 1098 1185 1090 1100 591 1196 1209 544 1040 598 566 583 635 974 1073 1101 1074 941
Parametrized queries using RDB$DB_KEY do not work
19 CS 2022.02.02 14:46 1069 1134 1211 1133 1108 1110 722 1062 1039 1085 1094 973 1099 1056 1098 1142 562 1187 1244 536 971 542 556 551 573 843 928 1089 841 1110
Context parsing error with derived tables and CASE functions
20 CS 2023.12.12 08:08 1121 1237 1244 1252 1261 1174 807 1198 1028 1177 967 976 1126 1075 1172 1132 652 1143 1124 571 1033 599 617 596 599 989 987 1043 908 1125
Engine crashes in case of re-creation of an erratic package body
21 CS 2022.02.02 14:46 1024 1230 1308 1057 1209 1187 814 1107 1044 1181 884 886 1012 1079 1220 1156 1061 1167 1064 522 1012 541 575 789 587 908 973 1088 907 1051
FB 3: TYPE OF arguments of stored functions will hang firebird engine if depending domain or column is changed
22 CS 2022.02.02 14:46 1467 1616 1428 1687 1523 1507 1024 1598 1547 1392 1249 1219 852 1407 1425 1400 1569 1450 1559 806 1349 1453 787 764 1355 1391 1253 1483 1155 1445
fbsvcmgr doesn't recognise sts_record_versions and other sts switches
23 CS 2022.02.07 17:03 1776 1527 1651 1608 1413 1472 1179 1536 1517 1497 1709 1603 1531 1148 1555 1707 1424 1720 1510 808 1335 761 788 791 1399 1427 1380 1301 1176 1834
Lookup (or scan) in descending index could be very inefficient for some keys
24 CS 2022.02.02 14:46 1259 1080 1333 1203 1212 1041 735 1062 1124 1168 1015 942 942 1003 1201 1077 1017 1213 1171 575 997 616 593 557 944 1003 918 925 1004 1105
Engine crashes when attempt to REcreate table with FK after syntax error before such recreating
25 CS 2022.02.02 14:46 1473 1324 1479 1318 1421 1432 904 1243 1420 1400 1139 1189 1158 1151 1404 1311 1360 1351 1494 699 1160 693 683 723 1242 1098 1058 1029 1197 1411
Fields present only in WHERE clause of views WITH CHECK OPTION causes invalid CHECK CONSTRAINT violation
26 CS 2022.02.02 14:46 1412 1415 1616 1471 1328 1259 921 1350 1428 1358 1296 1274 1178 1324 1373 1374 1439 1323 1512 745 1305 743 737 832 1407 1151 1405 1068 1321 1401
Usage of field(s) alias in view WITH CHECK OPTION leads to incorrect compile error or incorrect internal triggers
27 CS 2023.03.04 16:28 1460 1385 1496 1505 1312 1420 950 1349 1355 1462 1173 1169 1257 1357 1395 1312 1489 1352 1544 764 1328 722 695 768 1465 1160 1179 1144 1200 1396
Regression: Predicates involving PSQL variables/parameters are not pushed inside the aggregation
28 CS 2022.02.02 14:46 578 1052 993 1009 927 933 659 1004 909 863 515 991 518 524 958 949 1071 1045 594 936 1028 919 870 493 501 989 541 898 932 1073
Report the remote port number in MON$ATTACHMENTS
29 CS 2022.02.02 14:46 1042 1160 1220 1191 1071 1164 705 1016 917 1104 602 596 1037 547 1014 640 1071 1175 1068 986 976 962 1012 551 875 1099 1132 1036 1082 568
Add datatypes (VAR)BINARY(n) and BINARY VARYING(n) as alias for (VAR)CHAR(n) CHARACTER SET OCTETS
30 CS 2022.02.02 14:46 1204 1094 1207 1311 1194 1066 731 1063 1132 1031 588 576 628 639 1058 862 1037 1056 879 940 567 632 730 616 591 1197 620 628 947 608
Garbage value in RDB$FIELD_SUB_TYPE in RDB$FUNCTION_ARGUMENTS after altering function
31 SS 2022.08.18 10:51 652 375 450 640 625 559 413 557 374 521 465 586 290 286 308 616 550 629 588 369 358 401 391 404 347 408 275 537 305 549
MON$ATTACHMENTS.MON$TIMESTAMP is incorrect when DefaultTimeZone is configured with time zone different from the server's default
32 SS 2024.12.29 06:59 23967 25106 26658 25489 23445 22519 17093 24729 24874 24594 22461 23072 16007 20335 23584 22669 23705 25059 25265 11717 11769 12770 12492 12365 12502 22199 13805 13568 21563 21071
Indexed STARTING WITH execution is very slow with UNICODE collation
33 SS 2023.05.21 20:53 11132 9885 11203 11205 9288 9246 6970 10473 9572 10546 9371 10263 7351 8587 9756 7956 10702 X 10403 4197 4745 4787 4593 4384 4939 9966 8392 5689 9023 X
Significant performance regression of SIMILAR TO and SUBSTRING(SIMILAR) when pattern is taken from variable (rather than directly specified)
34 SS 2024.12.30 09:13 18593 18493 19947 19484 18253 18931 12381 18197 18333 19861 16701 17297 17471 17671 16204 17197 16214 16816 18419 8550 8799 8845 9013 9165 9142 18857 16633 14301 17707 15200
Performance effect of applying 'DISABLE-COMPRESSIONS=1' in UNICODE collation for LOCALE=cs_CZ
35 SS 2024.12.30 09:13 18650 19328 20682 19683 18444 18256 12027 20095 19999 19190 17145 17381 17689 17663 18063 16271 17736 19976 19241 8599 8731 8791 9228 9071 9238 17511 16781 16070 18629 16357
Performance effect of applying 'DISABLE-COMPRESSIONS=1' in UNICODE collation for LOCALE=hu_HU
36 SS 2023.02.20 13:37 2980 2988 3289 3252 3121 2980 1876 3143 3071 2785 2985 2930 3018 2897 2806 2803 3036 2988 2713 1549 1644 1519 1734 1594 1596 2989 2533 2806 2664 2885
Dummy (always true) conditions may change the join order
37 SS 2023.05.13 17:33 73591 71016 78505 80343 74939 69956 45555 73884 78531 79388 74281 71057 65705 66572 68741 62184 74231 73301 70711 31962 31440 32676 31203 31285 39208 69933 61351 57558 70169 60608
Improve performance of STARTING WITH with insensitive collations
38 SS 2024.08.20 03:12 738 495 805 629 751 456 516 711 701 647 640 376 353 366 343 613 691 593 661 609 524 608 607 637 465 596 358 342 336 704
WHEN NOT MATCHED BY SOURCE - does not work with a direct table as source
39 SS 2025.03.20 20:26 604 567 589 656 442 624 440 585 526 598 477 524 523 471 578 532 576 584 466 295 301 296 539 285 307 594 448 549 539 536
Inheritance of WINDOW does not work
40 SS 2025.04.02 09:03 761 667 672 605 636 768 513 529 595 863 687 693 696 575 669 467 745 676 672 342 300 307 645 350 383 784 680 653 746 547
Fix reset of db guid in fixup
41 SS 2022.02.04 18:05 767 548 633 818 805 638 601 609 725 781 778 856 712 662 689 568 693 655 706 379 375 398 528 612 403 676 729 682 660 714
TIMESTAMP in index with values below julian date
42 CS 2022.07.31 08:04 707 1242 1261 1194 1096 1040 861 1045 658 1218 1167 1116 1127 610 1042 632 613 1215 621 560 1111 672 952 988 907 636 564 584 610 549
Test for external table with field of DOUBLE PRECISION datatype
43 SS 2022.02.04 18:05 588 613 409 609 527 447 467 618 642 700 501 518 310 298 305 404 405 342 475 538 501 487 428 560 484 563 333 540 468 521
Statement with TRIM raises "bad BLR -- invalid stream"
44 CS 2025.05.17 07:35 2274 3497 3540 3653 3642 3468 2323 863 949 872 999 982 1408 1482 836 917 1501 1512 893 798 1358 1304 1085 748 1460 823 1404 934 974 844
Minimum grant test
45 SS 2025.05.17 07:35 1795 1828 1547 1716 1733 1791 1290 840 735 655 844 414 420 434 428 756 683 468 529 707 643 613 610 680 572 664 415 760 688 556
Minimum grant test
46 SS 2022.02.04 18:05 625 594 367 545 581 533 406 566 544 565 591 279 383 464 559 523 647 558 564 489 302 491 533 480 301 550 496 293 309 536
CAST CHAR -> TIME
47 SS 2022.02.04 18:05 619 560 589 597 553 632 421 529 481 561 538 572 536 608 297 628 640 461 551 298 280 287 335 298 291 555 376 424 518 456
LOG10( <number> )
48 SS 2022.02.04 18:05 600 610 613 657 655 424 441 709 533 632 701 632 489 581 413 549 596 613 635 298 277 500 310 521 329 527 472 562 564 654
GEN_UUID()
49 CS 2022.02.04 18:05 6751 6228 5670 6154 6023 6699 6302 6700 6145 4739 2856 5072 2778 6074 2865 6032 6041 5706 6049 2600 4904 2677 5464 5541 6143 2594 5785 5957 4792 5477
Verify ability to create exactly 254 changes of format (increasing it by 1) after initial creating table
50 SS 2023.11.25 21:40 1123 1141 1370 1231 1545 1432 1142 1042 1698 1346 1556 1498 681 1541 1088 916 1496 1186 1496 860 1046 1311 1071 635 652 1045 985 654 1152 956
Check ability of outer join simplification.

List of tests in this report:


http://tracker.firebirdsql.org/browse/CORE-1331
http://tracker.firebirdsql.org/browse/CORE-1402
http://tracker.firebirdsql.org/browse/CORE-1509
http://tracker.firebirdsql.org/browse/CORE-1750
http://tracker.firebirdsql.org/browse/CORE-3314
http://tracker.firebirdsql.org/browse/CORE-3335
http://tracker.firebirdsql.org/browse/CORE-3362
http://tracker.firebirdsql.org/browse/CORE-3394
http://tracker.firebirdsql.org/browse/CORE-3579
http://tracker.firebirdsql.org/browse/CORE-3672
http://tracker.firebirdsql.org/browse/CORE-4061
http://tracker.firebirdsql.org/browse/CORE-4091
http://tracker.firebirdsql.org/browse/CORE-4108
http://tracker.firebirdsql.org/browse/CORE-4136
http://tracker.firebirdsql.org/browse/CORE-4160
http://tracker.firebirdsql.org/browse/CORE-4214
http://tracker.firebirdsql.org/browse/CORE-4255
http://tracker.firebirdsql.org/browse/CORE-4262
http://tracker.firebirdsql.org/browse/CORE-4271
http://tracker.firebirdsql.org/browse/CORE-4281
http://tracker.firebirdsql.org/browse/CORE-4298
http://tracker.firebirdsql.org/browse/CORE-4302
http://tracker.firebirdsql.org/browse/CORE-4304
http://tracker.firebirdsql.org/browse/CORE-4307
http://tracker.firebirdsql.org/browse/CORE-4315
http://tracker.firebirdsql.org/browse/CORE-4318
http://tracker.firebirdsql.org/browse/CORE-501
http://tracker.firebirdsql.org/browse/CORE-5028
http://tracker.firebirdsql.org/browse/CORE-5064
http://tracker.firebirdsql.org/browse/CORE-5535
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/indices/test_timestamps_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_external_file_06_d.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_invalid_stream_when_use_trim.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_minimum_grant_test.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/cast/test_12.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/math/test_log10_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/misc/test_gen_uuid_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/table/alter/test_12.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_join_transformation_002.py
https://github.com/FirebirdSQL/firebird/issues/6790
https://github.com/FirebirdSQL/firebird/issues/6872
https://github.com/FirebirdSQL/firebird/issues/6875
https://github.com/FirebirdSQL/firebird/issues/6915
https://github.com/FirebirdSQL/firebird/issues/6941
https://github.com/FirebirdSQL/firebird/issues/7038
https://github.com/FirebirdSQL/firebird/issues/8213
https://github.com/FirebirdSQL/firebird/issues/8477
https://github.com/FirebirdSQL/firebird/issues/8491
=== end of list ===

Last commits information (all timestamps in UTC):