01. Total results for each kind of outcome and server mode, for previous 35 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 (1 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 (2 rows)
[CURRENT] 05. NEW SLOWDOWN: tests with performance problem for LAST 5 runs (50 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 35 runs (40 rows)
08. Has runtime errors: tests with at least one runtime error for previous 35 runs (1 rows)
09. Has crashes/bugchecks: tests that caused FB abnormal termination for previous 35 runs (0 rows)
10. NEW PASSED: successful tests for last run and outcome = FAIL/ERROR/SKIPPED or absent previously (3 rows)
11. All tests: outcomes for previous 35 runs (2963 rows)
12. Skipped: tests which was intentionally excluded from execution (173 rows)

Generated UTC 28.10.2025 01:42
Tested: FB60.   Build / date: 6.0.0.1334-67c93d49 / 2025.10.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: 2.0.2; firebird.Qa: 0.21.0 
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.1334
2025.10.27
67c93
6.0.0.1330
2025.10.26
07e61
6.0.0.1315
2025.10.24
8df33
6.0.0.1313
2025.10.21
7e32c
6.0.0.1312
2025.10.17
efa86
6.0.0.1311
2025.10.16
08844
6.0.0.1309
2025.10.15
fd9c0
6.0.0.1306
2025.10.13
a74c8
6.0.0.1305
2025.10.12
1bfb3
6.0.0.1304
2025.10.11
19b95
6.0.0.1301
2025.10.10
50548
6.0.0.1300
2025.10.08
f40d5
6.0.0.1299
2025.10.07
7c542
6.0.0.1295
2025.10.06
b1425
6.0.0.1293
2025.10.04
2caed
6.0.0.1292
2025.10.01
83c4c
6.0.0.1290
2025.09.30
53b91
6.0.0.1286
2025.09.28
33a72
6.0.0.1283
2025.09.25
8c40a
6.0.0.1282
2025.09.24
de661
6.0.0.1280
2025.09.22
4cb87
6.0.0.1278
2025.09.17
6b73f
6.0.0.1277
2025.09.15
365ba
6.0.0.1275
2025.09.14
68571
6.0.0.1274
2025.09.12
85ea9
6.0.0.1273
2025.09.08
f9194
6.0.0.1267
2025.09.07
6441f
6.0.0.1266
2025.09.05
1a0af
6.0.0.1265
2025.09.04
ba248
6.0.0.1264
2025.09.02
6a321
6.0.0.1262
2025.09.01
984aa
Test TITLE
1
bugs core 1554 
 tracker
 CS 2022.02.02 14:46
1210 784 742 735 716 735 735 1051 1071 1071 1060 1060 964 939 800 939 939 939 680 634 634 631 586 586 917 866 926 926 866 866 605
select ... where ... <> ALL (select ... join ...) bug
2
bugs core 1555 
 tracker
 CS 2022.02.02 14:46
1253 764 732 727 725 725 732 1127 1203 1203 1203 1066 1052 1052 819 964 964 964 769 769 769 761 761 900 1014 1014 1042 1014 970 945 650
'select ...from...where...not in (select...from...)' no results
3
bugs core 1560 
 tracker
 CS 2022.02.02 14:46
1199 728 709 709 695 695 1003 1070 1112 1112 1112 943 867 867 867 943 986 986 659 659 659 618 618 737 842 842 873 842 833 786 607
NULLIF crashes when first parameter is constant empty string
4
bugs core 1572 
 tracker
 CS 2022.02.02 14:46
1461 915 879 879 879 879 932 1350 1350 1350 1346 1154 1121 1121 1121 1154 1257 1257 885 885 885 885 1011 1218 1218 1218 1219 1141 981 981 795
Multiple Rows in Singleton Select not reported in a View
5
bugs core 1607 
 tracker
 CS 2025.06.25 17:48
1141 744 645 645 645 678 1097 1122 1155 1155 1122 1120 984 963 862 963 963 963 609 877 782 782 798 877 825 825 825 912 825 878 878
Correlated subquery is optimized badly if it depends on the union stream
6
bugs core 1609 
 tracker
 CS 2022.02.02 14:46
1152 703 668 668 668 672 1229 1229 1229 1183 1166 1166 1004 993 890 993 993 993 724 721 721 721 784 801 878 878 878 1028 1038 1038 1038
PSQL output parameter size limited
7
bugs core 1619 
 tracker
 CS 2022.02.02 14:46
1229 788 788 714 714 714 976 1043 1082 1096 1096 1096 932 925 687 925 925 925 660 660 660 660 847 847 851 847 847 851 881 886 886
Some aggregate functions does NOT support NULL-constant in 3-d dialect
8
bugs core 2230 
 tracker
 CS 2025.07.26 10:04
1262 791 767 767 821 767 766 766 766 766 766 804 991 1043 991 1043 1043 1043 886 1194 1144 1060 1117 1117 1117 1102 1117 1135 1144 1177 1177
Implement domain check of input parameters of execute block
9
bugs core 2233 
 tracker
 CS 2022.02.02 14:46
5135 3331 3331 3331 3113 3067 3067 2973 2973 3155 3437 3466 4277 4731 4277 4731 4731 4731 3355 4946 4943 4943 4943 4943 4907 4907 4907 4962 4993 4993 4993
Allow non-SYSDBA users to monitor not only their current attachment but other their attachments as well
10
bugs core 4452 
 tracker
 CS 2022.04.24 09:51
1380 918 1380 1368 1365 1368 1368 1365 1337 1140 1132 1132 1132 1139 1139 1164 1186 1164 844 1164 1136 844 744 686 686 686 1032 1032 1032 1032 886
Can`t create two collations with different names if autoddl OFF in FB 2.5.3
11
bugs core 5855 
 tracker
 CS 2022.02.02 14:46
1968 1176 1176 1176 1176 1838 1838 1838 1918 1918 1820 1646 1646 1595 1595 1628 1595 1141 1085 1085 1085 1085 959 959 985 985 985 985 950 950 950
Latest builds of Firebird 4.0 cannot backup DB with generators which contains space in the names
12
bugs core 5857 
 tracker
 CS 2022.02.02 14:46
1196 724 724 694 694 1137 1137 1126 1137 1126 1122 946 945 945 945 945 892 700 700 700 700 700 642 642 642 634 634 625 625 607 607
Varchar computed column length stores incorrect and invalid values for field
13
bugs core 5858 
 tracker
 CS 2022.02.02 14:46
1157 770 770 739 770 1174 1174 1174 1174 1167 1101 968 968 965 965 968 965 748 710 660 642 627 601 601 593 593 601 618 618 618 618
Command 'REVOKE ALL ON ALL FROM <anyname>' lead server to crash
14
bugs core 5871 
 tracker
 CS 2023.10.09 09:04
1167 758 1190 758 758 1190 1190 1100 1158 1100 755 1071 923 923 923 972 923 665 665 657 630 600 554 554 554 598 598 598 598 598 611
Incorrect caching of the subquery result (procedure call) in independent queries
15
bugs core 5874 
 tracker
 CS 2025.07.02 12:37
1195 767 1195 767 767 1110 1110 1045 1110 1045 797 933 933 933 933 966 966 751 705 642 611 611 592 592 592 592 597 597 590 590 610
Provide name of read-only column incorrectly referenced in UPDATE ... SET xxx
16
bugs core 5876 
 tracker
 CS 2025.07.02 12:39
1165 688 1081 694 694 716 812 812 1142 812 827 916 893 893 893 893 831 708 699 699 613 590 590 590 622 622 622 570 569 560 569
Provide name of udf function for "arithmetic exception, numeric overflow, or string truncation"
17
bugs gh 6873 
 tracker
 CS 2025.07.04 14:38
1330 850 850 1142 846 1142 1316 1316 1294 1294 1211 1211 1155 1155 1155 1155 1155 1141 893 1071 893 813 707 682 682 707 758 813 813 1072 1072
SIMILAR TO does not use index when pattern starts with non-wildcard character (in contrary to LIKE)
18
bugs gh 6903 
 tracker
 CS 2025.07.04 14:40
1386 869 869 1213 782 1213 1295 1431 1416 1416 1416 1339 1149 1149 1149 1183 1179 1179 936 1133 765 745 656 656 656 656 674 770 770 1118 1118
Unable to create ICU-based collation with locale keywords
19
bugs gh 7167 
 tracker
 CS 2025.07.04 20:39
1203 695 1281 1281 804 804 804 733 733 733 734 1071 1071 1028 898 1028 898 903 854 892 892 892 892 892 892 876 803 803 803 876 803
Incorrect transliteration of field names in constraint violation errors
20
bugs gh 7168 
 tracker
 CS 2025.07.18 06:01
1453 813 1291 1291 1291 1291 1291 881 881 881 897 1261 1261 1235 1034 1235 1235 1235 1027 1027 1027 1027 1254 1254 1254 929 929 929 909 909 909
Ignore missing UDR libraries during restore
21
bugs gh 7176 
 tracker
 CS 2023.02.27 09:32
1285 799 1144 1144 1144 1144 1144 778 778 778 773 1129 1129 1045 888 1045 1045 1045 869 869 869 869 1218 1218 1218 849 849 849 818 818 786
Incorrect error "Invalid token. Malformed string." with union + blob + non utf8 varchar
22
bugs gh 7217 
 tracker
 CS 2023.02.25 11:00
4652 2999 4652 4652 2999 2925 4135 4135 4135 4761 4761 4761 4362 4362 3970 4362 3970 3985 3657 3836 3836 3836 3836 3836 4880 3772 3772 3668 3668 3668 3668
user with DROP ANY PACKAGE privilege can not execute DROP PACKAGE BODY
23
bugs gh 7227 
 tracker
 CS 2024.03.23 18:25
2511 1416 2376 2376 1396 1307 2376 2302 2092 2092 2092 2003 1951 1887 1887 1951 1887 1690 1611 1663 1663 1611 1594 1663 2305 1594 1594 1618 1582 1582 1618
Dependencies of subroutines are not preserved after backup restore
24
bugs gh 7237 
 tracker
 CS 2023.02.22 19:21
1220 788 1094 1094 682 748 1094 769 769 769 825 825 943 943 943 976 976 976 868 868 868 868 837 837 878 842 878 878 842 842 942
Starting operator become unstable on indexed varchar fields
25
bugs gh 7255 
 tracker
 CS 2024.05.13 19:24
1240 804 1240 1259 757 757 1259 781 781 875 875 875 1003 1003 1003 1077 1003 1009 937 971 971 971 876 861 861 861 876 933 933 933 956
READ COMMITTED READ CONSISTENCY mode is broken in Classic / SuperClassic on Linux (the newly created users are not visible to execute statement)
26
bugs gh 7256 
 tracker
 CS 2025.07.04 20:48
1469 967 1472 1472 967 856 1472 1070 1070 1070 1070 1070 1115 1115 1115 1217 1115 1147 1100 1100 1100 1032 1002 1032 1136 1097 1103 1103 1097 1097 1103
Inconsistent conversion of non-TEXT blobs in BLOB_APPEND
27
bugs gh 7257 misc datatypes 
 tracker
 CS 2025.07.04 20:52
8955 5756 8620 8620 5342 5174 8236 6359 6359 6822 6822 6822 7319 7319 7319 7869 7319 5710 5570 5570 5570 5525 5431 5018 5018 5018 5318 5434 5434 5434 5461
Support for partial indices
28
bugs gh 7350 
 tracker
 CS 2025.07.05 14:33
2031 1140 1655 1655 1037 1037 1655 1051 1051 1650 1650 1650 1650 1650 1624 1624 1536 1536 1470 1470 1536 1470 1379 1241 1241 1241 1373 1404 1404 1404 1406
SKIP LOCKED clause for SELECT WITH LOCK, UPDATE and DELETE
29
bugs gh 7379 
 tracker
 CS 2023.02.16 09:33
1249 788 1033 1033 675 706 1033 765 765 927 927 927 927 893 884 884 830 830 830 849 867 867 867 849 868 866 866 827 827 827 827
BLOB_APPEND with existing blob accepts malformed string
30
bugs gh 7388 
 tracker
 CS 2025.01.18 13:08
1336 863 863 863 863 886 1365 1365 914 1060 1011 1011 1060 1194 1194 1194 1014 1014 1014 1037 1099 1112 1099 1492 1492 1236 1109 1109 1085 1085 1109
Different invariants optimization between views and CTEs
31
bugs gh 7391 
 tracker
 CS 2023.02.16 09:01
1141 714 714 714 714 777 1218 1218 777 856 801 801 856 958 958 958 876 876 866 866 876 886 868 1040 1040 899 868 865 791 865 865
AV when compiling stored procedure
32
bugs gh 7398 
 tracker
 CS 2025.07.26 09:51
2213 1381 1390 1390 1381 1390 2109 2109 1414 2109 1414 1414 1711 1842 1711 1711 1443 1393 1393 1393 1398 1398 1505 1505 1505 1389 1389 1389 1389 1415 1442
Worst plan sort created to execute an indexed tables
33
bugs gh 7434 
 tracker
 CS 2024.04.26 07:46
1184 708 681 681 679 681 1099 1099 679 952 736 736 952 954 954 954 838 838 832 838 879 891 897 897 1269 897 844 844 844 844 948
Crash or error in SUBSTRING()'s regexp parser with UTF-8 encoding
34
bugs gh 7493 
 tracker
 CS 2023.03.03 22:02
1251 777 714 714 714 714 1121 1121 684 682 682 682 775 960 960 960 905 905 781 812 905 946 828 1258 1258 828 828 844 794 794 844
Firebird 5.0 snapshot blob not found error after first commit / rollback
35
bugs gh 7517 
 tracker
 SS 2025.07.05 17:12
642 412 412 416 659 693 693 693 492 492 436 436 553 578 578 578 584 566 469 566 577 469 577 580 583 580 583 589 589 589 608
Successful compiling of procedure with wrong PLAN(s) used by some of its statement(s)
36
bugs gh 7715 
 tracker
 CS 2023.10.02 12:48
1476 860 843 802 802 794 794 834 834 834 848 862 985 1150 1150 1150 1015 1015 976 976 976 931 931 868 868 987 1011 1011 1011 1011 928
Alternative String Literals and multibyte (UTF8) alternatives
37
bugs gh 7749 
 tracker
 SS 2025.07.05 19:26
1181 772 730 730 1181 709 1182 1182 891 876 891 891 902 992 992 1221 905 950 916 950 950 1091 1135 1240 1240 1246 1230 1230 1227 1134 1134
Fix character set and collation output
38
bugs gh 7758 
 tracker
 SS 2023.10.09 14:20
800 509 450 450 801 472 723 723 528 528 609 609 609 678 609 678 683 683 579 683 667 667 730 730 740 758 758 754 754 753 733
Added the ability to change function DETERMINISTIC option without recompile the entire function body
39
bugs gh 7804 
 tracker
 CS 2025.07.05 20:10
2703 1777 2541 2541 1777 1640 1640 1640 1640 1756 1767 1878 2173 2173 2173 2173 1719 1719 1687 1687 1661 1647 1647 1647 1674 1686 1766 1766 1758 1758 1758
The partial index is not involved when filtering conditions through OR.
40
bugs gh 7992 
 tracker
 CS 2024.02.03 07:04
2048 1235 1231 1231 1145 1145 1246 1246 2054 2054 1354 1354 1826 1726 1726 1726 1349 1349 1326 1326 1349 1342 1330 1342 1381 1354 1354 1354 1353 1343 1343
Assertion (space > 0) failure during restore
41
bugs gh 8015 
 tracker
 CS 2024.10.31 10:17
1486 806 1088 1088 806 1088 1248 1248 1211 1211 999 999 1031 1031 1031 1042 1031 1030 928 1020 933 988 988 989 988 988 989 1014 971 996 1014
Add multi-character TRIM function
42
bugs gh 8020 
 tracker
 CS 2025.07.06 09:55
1391 810 1343 1343 810 1343 1361 1361 1390 1390 1343 1278 1138 1138 1138 1138 1071 1053 932 932 932 974 974 1028 1036 1036 1036 1036 1009 1004 992
AV when both function and dependent table are dropped in the same transaction
43
bugs gh 8061 
 tracker
 SS 2025.07.06 10:24
1865 1169 1169 1386 1386 1386 1386 1366 1340 1320 1340 1340 1404 1975 1975 1975 1368 1368 1368 1398 1398 1467 1564 1564 1564 1591 1564 1563 1420 1380 1379
Unnest IN/ANY/EXISTS subqueries and optimize them using semi-join algorithm
44
bugs gh 8113 
 tracker
 CS 2025.03.27 10:21
1459 832 832 821 832 1412 1412 912 912 912 906 912 949 1197 1197 1197 1132 1124 1080 1080 1080 1039 993 993 993 993 1025 1084 1025 1084 1048
UNION ALL optimization with constant false condition
45
bugs gh 8120 
 tracker
 CS 2024.05.27 09:46
1171 694 686 686 694 738 738 992 992 731 729 729 729 918 918 918 865 836 823 836 824 824 824 824 824 816 802 816 824 824 848
Cast dies with numeric value is out of range error
46
functional arno optimizer opt selectivity 03 
 CS 2022.02.04 18:05
1549 986 986 924 905 905 905 924 924 947 1030 1069 1069 1254 1254 1254 1136 1136 1099 1136 1136 1136 1128 1142 1138 1142 1195 1195 1139 1142 1139
SELECTIVITY - INDEX INACTIVE / ACTIVE
47
functional arno optimizer opt single index selection 04 
 CS 2025.07.16 15:54
1431 945 945 771 750 750 771 763 763 831 839 911 913 1032 1032 1035 1032 1035 969 972 972 993 972 993 1001 1001 1001 1001 977 977 977
Best match index selection (single segment)
48
functional arno optimizer opt single index selection 10 
 CS 2025.07.16 15:54
1350 872 1223 872 775 718 775 704 704 750 845 845 946 1098 1098 1098 1086 1086 1003 1003 1002 988 988 1000 1002 1072 1072 1025 1091 1025 1006
Best match index selection (single segment) OR
49
functional arno optimizer opt sort by index 04 
 SS 2025.07.08 12:49
747 420 420 503 503 503 644 503 726 558 558 558 662 662 662 662 693 583 539 583 610 610 615 626 626 648 660 660 705 705 705
ORDER BY DESC using index (non-unique)
50
functional arno optimizer opt sort by index 12 
 SS 2025.07.08 12:50
764 419 419 761 596 596 671 596 596 671 671 673 673 679 569 679 623 623 520 623 623 611 702 719 719 693 693 676 676 676 697
ORDER BY ASC, DESC using index (multi)

Elapsed time, milliseconds:

NN Test name mode
6.0.0.1334
2025.10.27
67c93
6.0.0.1330
2025.10.26
07e61
6.0.0.1315
2025.10.24
8df33
6.0.0.1313
2025.10.21
7e32c
6.0.0.1312
2025.10.17
efa86
6.0.0.1311
2025.10.16
08844
6.0.0.1309
2025.10.15
fd9c0
6.0.0.1306
2025.10.13
a74c8
6.0.0.1305
2025.10.12
1bfb3
6.0.0.1304
2025.10.11
19b95
6.0.0.1301
2025.10.10
50548
6.0.0.1300
2025.10.08
f40d5
6.0.0.1299
2025.10.07
7c542
6.0.0.1295
2025.10.06
b1425
6.0.0.1293
2025.10.04
2caed
6.0.0.1292
2025.10.01
83c4c
6.0.0.1290
2025.09.30
53b91
6.0.0.1286
2025.09.28
33a72
6.0.0.1283
2025.09.25
8c40a
6.0.0.1282
2025.09.24
de661
6.0.0.1280
2025.09.22
4cb87
6.0.0.1278
2025.09.17
6b73f
6.0.0.1277
2025.09.15
365ba
6.0.0.1275
2025.09.14
68571
6.0.0.1274
2025.09.12
85ea9
6.0.0.1273
2025.09.08
f9194
6.0.0.1267
2025.09.07
6441f
6.0.0.1266
2025.09.05
1a0af
6.0.0.1265
2025.09.04
ba248
6.0.0.1264
2025.09.02
6a321
6.0.0.1262
2025.09.01
984aa
6.0.0.1261
2025.08.31
8d5bb
6.0.0.1259
2025.08.30
66b1c
6.0.0.1255
2025.08.29
037e1
6.0.0.1247
2025.08.28
6ad59
Test TITLE
1
bugs core 1554 
 tracker
 CS 1210 1439 1221 784 716 742 735 664 588 1071 1051 1212 1238 1060 715 964 800 939 680 944 988 634 631 549 917 586 570 926 1026 866 1097 605 586 898 566
select ... where ... <> ALL (select ... join ...) bug
2
bugs core 1555 
 tracker
 CS 1508 1253 1259 727 764 682 732 725 693 1127 1222 1203 1251 1052 819 1066 720 1055 632 964 965 769 718 761 900 579 1042 1042 1014 970 1116 650 632 945 620
'select ...from...where...not in (select...from...)' no results
3
bugs core 1560 
 tracker
 CS 1199 1250 1435 709 728 675 683 1070 695 1003 1112 1249 1204 589 731 943 867 996 626 986 1020 659 618 548 737 571 881 873 842 833 944 607 565 786 572
NULLIF crashes when first parameter is constant empty string
4
bugs core 1572 
 tracker
 CS 1679 1564 1461 827 915 879 859 932 821 1465 1722 1350 1346 816 977 1154 1121 1333 800 1326 1257 885 840 770 1011 1218 1221 1274 1141 981 1219 795 703 1161 683
Multiple Rows in Singleton Select not reported in a View
5
bugs core 1607 
 tracker
 CS 1246 1141 1237 744 645 603 641 678 1097 1207 1362 1122 1155 1120 702 984 862 963 606 1092 997 601 609 877 782 1068 798 912 825 602 1026 980 553 878 796
Correlated subquery is optimized badly if it depends on the union stream
6
bugs core 1609 
 tracker
 CS 1152 1271 1373 703 668 644 597 672 1229 1269 1239 1166 1183 1166 739 1004 890 993 724 1129 1044 716 681 721 784 965 801 878 1028 631 1071 1060 1038 917 656
PSQL output parameter size limited
7
bugs core 1619 
 tracker
 CS 1308 1229 1256 788 689 609 976 714 1043 629 1082 1096 1143 1288 687 932 679 925 513 1015 1020 614 660 569 852 950 847 800 851 569 1005 881 1028 886 527
Some aggregate functions does NOT support NULL-constant in 3-d dialect
8
bugs core 2230 
 tracker
 CS 1262 791 1300 759 1373 767 735 1121 821 721 766 676 804 1269 754 1130 991 1043 828 1301 1210 886 815 1194 1144 1060 1117 1102 1135 1096 1144 1177 1273 1240 1156
Implement domain check of input parameters of execute block
9
bugs core 2233 
 tracker
 CS 5385 3188 5135 3331 5572 3113 3067 4534 2959 2973 3437 2810 3155 5410 3466 4877 4277 4731 3116 5043 4946 3355 3054 4968 4943 4997 4817 4907 4799 5002 4962 4993 5074 4874 5036
Allow non-SYSDBA users to monitor not only their current attachment but other their attachments as well
10
bugs core 4452 
 tracker
 CS 1385 918 1380 1416 843 766 1636 1368 1365 1447 1140 1337 884 1132 911 1139 1460 1320 792 1164 1186 844 744 1166 1136 636 686 681 1138 1228 1032 748 683 1189 886
Can`t create two collations with different names if autoddl OFF in FB 2.5.3
11
bugs core 5855 
 tracker
 CS 1968 1976 2000 1136 1176 1110 1972 1838 1102 2059 1820 2135 1918 1024 1156 1646 1885 1595 1034 1628 962 1141 1085 959 1701 956 957 1714 985 985 944 950 904 1037 1180
Latest builds of Firebird 4.0 cannot backup DB with generators which contains space in the names
12
bugs core 5857 
 tracker
 CS 1252 1196 1200 724 683 633 1246 694 1137 1287 1126 1122 1177 656 751 946 945 989 613 892 627 700 733 567 705 589 642 1119 634 560 625 607 656 580 573
Varchar computed column length stores incorrect and invalid values for field
13
bugs core 5858 
 tracker
 CS 1157 1217 1215 739 770 653 1259 615 1267 1174 1101 1190 1167 592 740 968 1079 965 748 1050 642 710 627 660 566 554 601 997 593 567 631 618 639 567 588
Command 'REVOKE ALL ON ALL FROM <anyname>' lead server to crash
14
bugs core 5871 
 tracker
 CS 1167 667 1212 1228 758 687 1190 667 1224 1233 714 1100 1158 664 755 1071 923 972 665 1032 630 657 666 600 554 540 551 641 1030 598 549 564 611 617 653
Incorrect caching of the subquery result (procedure call) in independent queries
15
bugs core 5874 
 tracker
 CS 1213 668 1195 1292 767 717 1318 721 1110 1162 696 1045 1226 739 797 933 966 1005 751 1048 567 705 642 611 542 592 587 597 991 564 626 562 590 610 753
Provide name of read-only column incorrectly referenced in UPDATE ... SET xxx
16
bugs core 5876 
 tracker
 CS 1383 641 1165 1181 688 676 1081 694 1142 716 812 1196 1365 622 827 916 893 960 680 831 708 699 613 588 590 552 622 667 1022 544 569 570 545 560 858
Provide name of udf function for "arithmetic exception, numeric overflow, or string truncation"
17
bugs gh 6873 
 tracker
 CS 1416 1567 850 1330 846 724 1142 1925 804 1316 1474 1211 1294 856 861 1283 1155 1197 882 1141 1201 893 813 1071 640 626 707 682 813 758 1072 1144 705 1220 727
SIMILAR TO does not use index when pattern starts with non-wildcard character (in contrary to LIKE)
18
bugs gh 6903 
 tracker
 CS 1480 1386 869 1402 721 778 1213 1755 782 1295 1472 1431 1416 741 951 1339 1149 1183 936 1232 1179 745 765 1133 630 620 656 674 656 770 1118 1208 609 1129 681
Unable to create ICU-based collation with locale keywords
19
bugs gh 7167 
 tracker
 CS 1203 695 1325 1281 684 676 1344 1508 804 727 733 707 1071 1135 734 1071 898 1028 663 1383 722 903 854 892 1305 892 1208 732 718 876 803 1308 736 1208 729
Incorrect transliteration of field names in constraint violation errors
20
bugs gh 7168 
 tracker
 CS 1453 794 1476 1683 813 802 1291 2060 1487 850 881 854 1474 1365 897 1261 1034 1235 804 1541 1660 1027 938 942 1483 1451 1254 929 890 886 951 1491 909 849 811
Ignore missing UDR libraries during restore
21
bugs gh 7176 
 tracker
 CS 1372 799 1308 1285 679 663 1144 1421 1185 778 760 643 1150 1129 773 1138 888 1045 653 1288 1235 869 840 850 1241 1218 1331 849 725 818 879 1387 786 699 781
Incorrect error "Invalid token. Malformed string." with union + blob + non utf8 varchar
22
bugs gh 7217 
 tracker
 CS 5057 2907 5019 4652 2999 2925 5139 5487 2584 2727 4135 5307 4761 4905 3262 4362 3970 4598 2955 5621 3346 3985 3657 3836 5508 3039 5464 3083 4880 3772 3668 3603 3392 5800 5634
user with DROP ANY PACKAGE privilege can not execute DROP PACKAGE BODY
23
bugs gh 7227 
 tracker
 CS 2526 1416 2512 2511 1396 1285 2376 2732 1208 1307 2513 2302 2092 1219 1422 2003 1951 1887 1314 2473 1690 1611 1524 1663 2490 1291 1594 2391 2305 1489 1582 1618 1430 2406 2425
Dependencies of subroutines are not preserved after backup restore
24
bugs gh 7237 
 tracker
 CS 1322 788 1221 1220 652 682 1094 1408 624 748 1254 769 1284 635 825 943 983 976 669 1407 857 978 868 837 1286 727 735 878 1396 842 942 836 722 1295 1364
Starting operator become unstable on indexed varchar fields
25
bugs gh 7255 
 tracker
 CS 1409 804 1240 1328 714 757 1259 1628 721 712 1541 781 1252 875 832 1102 1003 1077 759 1492 937 1009 876 971 1386 777 792 861 1129 876 956 933 749 1285 1358
READ COMMITTED READ CONSISTENCY mode is broken in Classic / SuperClassic on Linux (the newly created users are not visible to execute statement)
26
bugs gh 7256 
 tracker
 CS 1469 902 1574 1612 967 820 1472 1918 856 826 1592 1070 1410 793 980 1217 1115 1292 899 1683 1100 1147 1002 1032 1614 896 923 1136 1463 1097 1103 1025 910 1472 1545
Inconsistent conversion of non-TEXT blobs in BLOB_APPEND
27
bugs gh 7257 misc datatypes 
 tracker
 CS 8973 5756 9051 8955 5342 5156 8620 13083 5174 5010 8236 6359 8455 6822 6294 8209 7319 7869 5455 8293 5710 5570 5525 5431 7850 4605 4857 5018 7384 5318 5434 5461 4699 7928 7885
Support for partial indices
28
bugs gh 7350 
 tracker
 CS 2217 1140 2108 2031 1003 993 1655 2011 1037 974 2002 1051 1775 1650 1335 1759 1624 1744 1098 1339 1536 1551 1470 1379 2107 1126 1241 1087 1766 1404 1373 1406 1175 2016 2145
SKIP LOCKED clause for SELECT WITH LOCK, UPDATE and DELETE
29
bugs gh 7379 
 tracker
 CS 1249 788 1293 1340 662 675 1033 1396 673 706 1247 765 927 946 698 949 884 893 576 727 830 920 867 849 1327 689 868 708 1190 866 791 827 688 1256 1249
BLOB_APPEND with existing blob accepts malformed string
30
bugs gh 7388 
 tracker
 CS 1457 831 1341 1336 803 863 733 1365 886 1391 1404 914 776 1060 1011 1278 1194 1302 799 894 1014 1112 1099 1037 1518 1492 1074 1630 1236 1085 1109 1041 891 1510 1607
Different invariants optimization between views and CTEs
31
bugs gh 7391 
 tracker
 CS 1342 705 1192 1141 714 588 622 1305 777 1218 1313 665 654 856 801 1042 977 958 623 745 876 886 866 840 1224 1319 868 1040 760 899 865 791 778 1268 1362
AV when compiling stored procedure
32
bugs gh 7398 
 tracker
 CS 2213 1369 2247 2271 1381 1355 1390 2218 1208 2109 2563 1414 1221 2208 1346 1863 1711 1842 1158 1370 1443 1393 1398 1361 1977 1984 1505 1282 1389 1385 1415 1442 1291 2248 2307
Worst plan sort created to execute an indexed tables
33
bugs gh 7434 
 tracker
 CS 1283 708 1184 1296 625 681 664 1192 679 1256 1099 662 656 952 736 1010 954 997 689 784 838 879 832 891 1348 1269 897 743 1361 844 827 948 772 1415 1436
Crash or error in SUBSTRING()'s regexp parser with UTF-8 encoding
34
bugs gh 7493 
 tracker
 CS 1351 1410 1251 668 777 686 714 1121 684 1163 1344 682 662 670 775 1076 960 1016 775 781 905 946 771 812 1264 1258 828 1337 752 794 863 844 761 750 1292
Firebird 5.0 snapshot blob not found error after first commit / rollback
35
bugs gh 7517 
 tracker
 SS 751 642 376 412 659 341 416 693 699 786 492 368 373 553 436 578 614 584 426 566 636 469 414 577 592 459 580 605 583 480 589 608 612 536 675
Successful compiling of procedure with wrong PLAN(s) used by some of its statement(s)
36
bugs gh 7715 
 tracker
 CS 1647 1648 843 860 1476 802 757 794 1302 721 834 862 828 848 985 1220 1150 1167 796 854 1015 1131 976 931 804 868 987 865 1117 1020 1011 928 882 1696 845
Alternative String Literals and multibyte (UTF8) alternatives
37
bugs gh 7749 
 tracker
 SS 1260 772 1368 730 1181 694 686 1328 1182 709 1295 772 891 876 992 1360 902 1318 847 1221 905 950 916 1091 1240 1246 1135 1252 1230 1401 1134 1105 1227 1099 1240
Fix character set and collation output
38
bugs gh 7758 
 tracker
 SS 815 509 800 450 864 437 448 855 801 472 723 507 528 680 609 678 476 736 557 751 683 579 564 730 667 740 795 714 758 794 753 754 711 733 680
Added the ability to change function DETERMINISTIC option without recompile the entire function body
39
bugs gh 7804 
 tracker
 CS 3076 1579 2703 2815 1777 1572 2541 2607 1562 1640 1618 1878 2738 1756 1767 2621 2173 2593 1564 1719 1719 1687 1661 1647 1623 1576 1674 2424 1776 1686 1766 1521 1758 1796 1755
The partial index is not involved when filtering conditions through OR.
40
bugs gh 7992 
 tracker
 CS 2048 1235 2180 2097 1231 1066 1111 1246 1145 2217 2054 1245 2208 1203 1354 1826 1829 1726 1138 1326 1349 1466 1245 1279 1499 1342 1330 1381 1399 1354 1353 1275 1298 1343 1411
Assertion (space > 0) failure during restore
41
bugs gh 8015 
 tracker
 CS 1486 785 1532 1526 806 708 1088 1248 663 1258 1691 999 1211 937 844 1196 1031 1142 742 1042 829 1030 928 1020 933 988 989 1043 883 955 1014 1035 971 996 1018
Add multi-character TRIM function
42
bugs gh 8020 
 tracker
 CS 1391 795 1445 1401 810 719 1343 1361 742 1390 1688 1343 1393 858 842 1278 1138 1206 802 1071 929 1053 932 890 1058 974 1028 1046 1036 1086 1009 948 1004 992 991
AV when both function and dependent table are dropped in the same transaction
43
bugs gh 8061 
 tracker
 SS 1865 2008 1081 1994 1075 1169 1386 1755 2049 923 1366 1340 1320 880 1404 2128 2099 1975 1218 1368 1233 1467 1398 1584 1093 1647 1564 1563 1755 1591 1379 1420 1380 1304 826
Unnest IN/ANY/EXISTS subqueries and optimize them using semi-join algorithm
44
bugs gh 8113 
 tracker
 CS 1603 1550 1459 792 832 794 1412 821 1470 1447 877 912 905 949 906 1210 1197 1286 795 1132 1124 1080 1039 977 1090 980 993 1095 969 1119 1025 1084 1015 1096 1048
UNION ALL optimization with constant false condition
45
bugs gh 8120 
 tracker
 CS 1210 1240 1171 671 678 694 686 738 992 1168 731 1264 618 729 728 1046 918 939 724 836 865 823 819 836 824 865 790 816 824 768 802 864 852 824 848
Cast dies with numeric value is out of range error
46
functional arno optimizer opt selectivity 03 
 CS 1571 971 1595 1549 986 924 846 877 905 924 947 1242 886 1069 1030 1396 1254 1349 915 1099 1136 1136 1067 1146 1092 1142 1128 1196 1138 1195 1207 1089 1139 1142 1117
SELECTIVITY - INDEX INACTIVE / ACTIVE
47
functional arno optimizer opt single index selection 04 
 CS 1503 919 1431 1540 945 750 771 739 698 831 839 763 759 911 913 1201 1032 1138 871 1035 875 1087 969 972 1069 993 932 1010 1001 1046 977 950 957 1042 982
Best match index selection (single segment)
48
functional arno optimizer opt single index selection 10 
 CS 1441 868 1350 1452 872 718 1223 775 704 697 872 701 750 845 946 1217 1098 1242 846 1003 1086 1097 988 947 1002 962 1072 1000 1159 1128 1025 1006 1091 1002 987
Best match index selection (single segment) OR
49
functional arno optimizer opt sort by index 04 
 SS 753 907 397 747 420 415 644 503 838 398 782 390 726 558 540 662 725 693 468 583 722 539 504 651 610 615 723 626 648 740 660 718 705 657 782
ORDER BY DESC using index (non-unique)
50
functional arno optimizer opt sort by index 12 
 SS 828 904 400 764 419 409 761 802 596 431 671 394 673 749 565 707 569 679 489 733 623 520 497 702 719 611 732 764 693 676 640 581 700 697 698
ORDER BY ASC, DESC using index (multi)

List of tests in this report:


http://tracker.firebirdsql.org/browse/CORE-1554
http://tracker.firebirdsql.org/browse/CORE-1555
http://tracker.firebirdsql.org/browse/CORE-1560
http://tracker.firebirdsql.org/browse/CORE-1572
http://tracker.firebirdsql.org/browse/CORE-1607
http://tracker.firebirdsql.org/browse/CORE-1609
http://tracker.firebirdsql.org/browse/CORE-1619
http://tracker.firebirdsql.org/browse/CORE-2230
http://tracker.firebirdsql.org/browse/CORE-2233
http://tracker.firebirdsql.org/browse/CORE-4452
http://tracker.firebirdsql.org/browse/CORE-5855
http://tracker.firebirdsql.org/browse/CORE-5857
http://tracker.firebirdsql.org/browse/CORE-5858
http://tracker.firebirdsql.org/browse/CORE-5871
http://tracker.firebirdsql.org/browse/CORE-5874
http://tracker.firebirdsql.org/browse/CORE-5876
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_selectivity_03.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_single_index_selection_04.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_single_index_selection_10.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_sort_by_index_04.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_sort_by_index_12.py
https://github.com/FirebirdSQL/firebird/issues/6873
https://github.com/FirebirdSQL/firebird/issues/6903
https://github.com/FirebirdSQL/firebird/issues/7167
https://github.com/FirebirdSQL/firebird/issues/7168
https://github.com/FirebirdSQL/firebird/issues/7176
https://github.com/FirebirdSQL/firebird/issues/7217
https://github.com/FirebirdSQL/firebird/issues/7227
https://github.com/FirebirdSQL/firebird/issues/7237
https://github.com/FirebirdSQL/firebird/issues/7255
https://github.com/FirebirdSQL/firebird/issues/7256
https://github.com/FirebirdSQL/firebird/issues/7257
https://github.com/FirebirdSQL/firebird/issues/7350
https://github.com/FirebirdSQL/firebird/issues/7379
https://github.com/FirebirdSQL/firebird/issues/7388
https://github.com/FirebirdSQL/firebird/issues/7391
https://github.com/FirebirdSQL/firebird/issues/7398
https://github.com/FirebirdSQL/firebird/issues/7434
https://github.com/FirebirdSQL/firebird/issues/7493
https://github.com/FirebirdSQL/firebird/issues/7517
https://github.com/FirebirdSQL/firebird/issues/7715
https://github.com/FirebirdSQL/firebird/issues/7749
https://github.com/FirebirdSQL/firebird/issues/7758
https://github.com/FirebirdSQL/firebird/issues/7804
https://github.com/FirebirdSQL/firebird/issues/7992
https://github.com/FirebirdSQL/firebird/issues/8015
https://github.com/FirebirdSQL/firebird/issues/8020
https://github.com/FirebirdSQL/firebird/issues/8061
https://github.com/FirebirdSQL/firebird/issues/8113
https://github.com/FirebirdSQL/firebird/issues/8120
=== end of list ===

Last commits information (all timestamps in UTC):