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 (3 rows)
05. NEW SLOWDOWN: tests with performance problem for LAST 5 runs (31 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 35 runs (63 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 (1 rows)
11. All tests: outcomes for previous 35 runs (2983 rows)
12. Skipped: tests which was intentionally excluded from execution (173 rows)

Generated UTC 10.11.2025 01:35
Tested: FB60.   Build / date: 6.0.0.1354-174ee333 / 2025.11.09;
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

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.1354
2025.11.09
174ee
6.0.0.1352
2025.11.08
c595c
6.0.0.1351
2025.11.07
d7fef
6.0.0.1346
2025.11.06
bf133
6.0.0.1342
2025.11.05
ff3e4
6.0.0.1338
2025.11.03
c32dc
6.0.0.1337
2025.11.01
339dc
6.0.0.1336
2025.10.31
a7d03
6.0.0.1335
2025.10.29
eceaf
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
Test TITLE
1
bugs core 0001 
 tracker
 CS 2022.02.02 14:46
2488 2497 2497 2462 2462 2462 2462 2396 2396 2368 2226 1956 1956 1956 1956 2174 2207 2207 2257 2257 2207 2257 1882 1824 1824 1187 1187 1187 1296 1361 1899
Server shutdown
2
bugs core 0037 
 tracker
 CS 2022.02.02 14:46
1398 1336 1336 1336 1319 1336 1348 1319 1319 1297 1256 1090 1090 1090 1090 1197 1358 1344 1344 1344 1293 1293 1072 1010 1010 656 656 656 683 755 1036
Error "no current record for fetch operation" on view select
3
bugs core 0059 
 tracker
 CS 2025.07.01 12:34
1231 1220 1220 1231 1276 1276 1369 1276 1258 1258 1258 1254 1198 971 971 1180 1180 1180 1180 1132 1100 1132 1019 917 917 600 600 600 613 699 998
Automatic not null in PK columns incomplete
4
bugs core 0070 
 tracker
 CS 2025.07.01 12:34
1238 1163 1163 1238 1393 1393 1393 1346 1345 1153 1153 1102 1102 1044 1044 1170 1184 1184 1184 1178 1101 1101 1015 942 942 624 624 624 642 669 940
Expression index regression since 2.0a3
5
bugs core 0148 
 tracker
 CS 2022.02.02 14:46
1324 1263 1263 1237 1263 1276 1276 1195 1212 1212 1195 1131 1212 1219 1216 1216 1216 1216 1202 1111 1086 1086 998 989 989 618 618 618 636 691 994
SELECT '1' UNION SELECT '12'
6
bugs core 0297 
 tracker
 CS 2022.02.02 14:46
1536 1536 1464 1464 1527 1530 1527 1527 1444 1421 1404 1415 1415 1387 1309 1289 1248 1248 1289 1248 1317 1317 1273 1205 1205 779 779 716 716 803 1145
IB server stalled by simple script
7
bugs core 0337 
 tracker
 CS 2022.02.02 14:46
2149 2151 2183 2183 2240 2272 2261 2261 2272 2261 2142 2103 2142 2142 2118 2126 2126 2118 2088 2016 1815 1946 1815 1768 1768 1119 1119 1114 1119 1208 1630
ISQL and database dialect
8
bugs core 0475 
 tracker
 CS 2022.02.02 14:46
1397 1381 1261 1205 1261 1201 1194 1194 1234 1234 1234 1234 1184 1184 1184 1334 1334 1334 1267 1262 1173 1173 1015 993 993 660 660 653 653 794 1006
ORDER BY has no effect
9
bugs core 0855 
 tracker
 CS 2022.02.02 14:46
1140 1245 1245 1245 1245 1245 1287 1287 1287 1177 1177 1136 1117 1117 1129 1129 1149 1149 1149 1137 1114 1073 980 957 957 604 604 604 621 629 949
Aggregates in the WHERE clause vs derived tables
10
bugs core 0857 
 tracker
 CS 2024.10.30 22:17
1292 1292 1313 1262 1313 1334 1334 1262 1220 1217 1217 1198 1187 1187 1219 1219 1248 1248 1258 1258 1203 1203 1028 1007 1007 668 668 668 697 740 1000
Containing not working correctly
11
bugs core 0888 
 tracker
 CS 2022.02.02 14:46
1220 1159 1220 1220 1202 1220 1220 1202 1173 1168 1100 1100 1168 1168 1229 1238 1238 1118 1118 1055 1020 1020 1034 968 968 639 638 593 593 638 1025
DDL - object in use
12
bugs core 0932 
 tracker
 CS 2022.02.02 14:46
1782 1715 1715 1715 1777 1777 1932 1777 1756 1611 1611 1611 1854 1865 1865 1877 1854 1872 1847 1847 1386 1386 1363 1363 1363 898 898 898 948 975 1384
Comment in create database
13
bugs core 1019 
 tracker
 CS 2022.02.02 14:46
1267 1267 1263 1263 1286 1263 1302 1302 1242 1211 1170 1164 1145 1164 1170 1348 1348 1348 1227 1151 999 999 952 952 952 610 610 610 610 610 659
Make information available regading ODS Version and Dialect via SQL
14
bugs core 1026 utf8 
 tracker
 CS 2024.10.31 10:17
1477 1449 1449 1477 1494 1494 1494 1424 1412 1361 1412 1412 1361 1363 1363 1363 1363 1363 1257 1196 1196 1196 1253 1253 1253 753 753 753 777 777 816
Estonian collation in UTF8 charset
15
bugs core 1126 
 tracker
 CS 2022.02.02 14:46
1133 1136 1136 1189 1237 1237 1245 1245 1237 1173 1173 1160 1160 1160 1179 1179 1203 1203 1203 1189 971 971 971 971 971 596 596 596 658 738 927
Incorrect results when left join on subquery with constant column
16
bugs core 1172 
 tracker
 CS 2022.02.02 14:46
1541 1541 1541 1601 1601 1588 1588 1518 1511 1509 1509 1487 1509 1458 1514 1514 1521 1521 1521 1521 1211 1211 1211 1211 1211 802 802 802 866 893 925
Symbols ignored for ES_ES_CI_AI collation
17
bugs core 1183 
 tracker
 CS 2022.02.02 14:46
1523 1523 1542 1542 1504 1462 1504 1457 1457 1457 1418 1418 1476 1476 1476 1476 1486 1476 1476 1447 1367 1367 1249 1170 1170 737 737 737 866 869 869
View cannot be created if its WHERE clause contains IN <subquery> with a procedure reference
18
bugs core 1196 
 tracker
 CS 2022.02.02 14:46
1271 1359 1344 1374 1344 1410 1418 1418 1312 1319 1319 1319 1342 1342 1343 1385 1385 1318 1318 1242 1185 1185 1082 1000 1000 650 650 650 667 757 757
Long SQL statements break TCP/IP connection
19
bugs core 3018 
 tracker
 CS 2022.02.02 14:46
1199 1187 1199 1199 1223 1217 1223 1217 1217 1214 1171 1171 1209 1110 1158 1158 1121 1121 1121 1021 1021 1021 1006 939 939 605 605 605 644 671 974
RECREATE, ALTER and CREATE OR ALTER SEQUENCE/GENERATOR statements
20
bugs core 3052 
 tracker
 CS 2022.02.02 14:46
1219 1219 1271 1271 1246 1246 1233 1225 1212 1194 1194 1187 1187 1187 1158 1153 1153 1146 1146 1110 1113 1121 1113 971 971 629 629 629 674 698 1010
Wrong resultset
21
bugs core 3057 
 tracker
 CS 2022.02.02 14:46
1396 1396 1328 1320 1320 1319 1319 1319 1225 1225 1239 1225 1239 1239 1207 1207 1207 1207 1175 1170 1111 1111 1098 1098 1098 714 714 697 697 759 1019
Allow the usage of blobs in COMPUTED BY expressions
22
bugs core 3360 
 tracker
 CS 2022.02.02 14:46
2644 2665 2665 2681 2681 2709 2709 2709 2612 2580 2580 2580 2599 2599 2599 2586 2586 2586 2586 2586 2250 2250 2250 2250 2250 1394 1394 1394 1462 1607 2245
update ... returning ... raises -551 (no perm to update) for a column present only in the returning clause
23
bugs core 3427 
 tracker
 CS 2022.02.02 14:46
1295 1295 1304 1304 1304 1348 1348 1250 1348 1287 1274 1287 1323 1287 1274 1323 1218 1218 1222 1222 1168 1222 1140 1063 1063 668 668 668 668 737 773
Server crashing with UTF8 blobs
24
bugs core 3447 
 tracker
 CS 2023.10.05 12:00
1397 1397 1425 1558 1558 1558 1456 1404 1345 1336 1328 1328 1328 1336 1372 1389 1389 1372 1359 1291 1291 1291 1291 1239 1239 734 734 734 725 763 844
Collation is not installed with icu > 4.2
25
bugs core 3475 
 tracker
 CS 2023.12.11 11:27
1182 1182 1182 1167 1213 1213 1213 1177 1177 1177 1177 1190 1229 1229 1229 1160 1110 1110 1110 1077 1066 1066 1003 932 932 590 590 590 649 697 866
Parameters inside the CAST function are described as not nullable
26
bugs core 3526 
 tracker
 CS 2022.02.02 14:46
1240 1220 1244 1266 1266 1184 1200 1167 1119 1149 1161 1161 1161 1161 1161 1210 1129 1129 1157 1157 1129 1128 994 977 977 648 648 648 663 663 721
Support for WHEN SQLSTATE
27
bugs core 4006 
 tracker
 CS 2022.02.02 14:46
1240 1240 1222 1179 1179 1183 1164 1183 1183 1129 1119 1129 1129 1129 1257 1394 1394 1280 1280 1064 977 977 977 977 977 610 610 610 648 700 705
using a result from a procedure in a substring expression leads to server crash
28
bugs core 4058 
 tracker
 CS 2022.02.02 14:46
1054 1055 1118 1055 1163 1163 1163 1073 1088 1088 1088 1088 1091 1091 1052 1042 1052 1042 1042 1041 814 814 814 814 814 541 541 528 518 518 518
Remote Stack Buffer Overflow in Firebird SQL Server (when specially crafted packet is sent via socket API)
29
bugs core 4093 
 tracker
 CS 2022.02.02 14:46
1229 1255 1255 1166 1166 1197 1197 1197 1197 1144 1143 1143 1143 1143 1143 1184 1196 1189 1189 1189 947 947 947 947 947 593 593 593 592 592 592
Server crashes while converting an overscaled numeric to a string
30
bugs core 4136 
 tracker
 CS 2022.02.02 14:46
1293 1293 1293 1371 1371 1371 1330 1330 1291 1242 1242 1242 1242 1242 1194 1194 1194 1164 1124 1098 1046 1046 1046 1046 1060 1118 1060 671 671 600 600
Sharp-S character treated incorrectly in UNICODE_CI_AI collation
31
bugs core 4460 
 tracker
 CS 2025.09.26 18:01
3669 3856 3205 3205 3602 3619 3619 3619 3602 2634 2629 2629 2629 2763 3684 3698 4392 4392 4392 4155 4155 4155 4803 4803 4803 3688 3603 3596 3596 3485 981
UNION sub-parts may be badly optimized. Check for ALL built-in functions.
32
bugs core 4460 
 tracker
 SS 2025.09.26 18:01
3862 3866 3598 3598 3598 3554 3554 3554 3450 3707 3766 3766 3701 3701 3681 3613 3596 3596 3596 3613 3697 3848 4802 4802 4802 3565 3499 3264 3264 3234 447
UNION sub-parts may be badly optimized. Check for ALL built-in functions.
33
bugs core 4731 
 tracker
 SS 2025.10.31 13:25
32427 33438 33052 33052 33052 31288 13556 13408 X X X X X X 13408 13408 14335 X X X X X 18087 18087 18087 12699 12699 12529 12667 12632 12632
Prohibit an ability to issue DML or DDL statements on RDB$ tables
34
bugs core 5231 
 tracker
 CS 2024.08.09 16:30
4432 4432 4432 4404 4432 4568 4689 4689 4689 4468 4468 4286 4274 4197 4197 4197 4397 4397 4397 3985 3738 3738 3738 3738 3738 3527 3357 2210 3298 2994 2994
EXECUTE STATEMENT: BLR error if more than 256 output parameters exist
35
bugs core 5302 
 tracker
 CS 2023.05.13 17:30
44635 44635 44635 43848 45495 45495 45139 43594 45139 44557 42207 42454 42454 42454 42454 42662 43051 43051 42662 41963 40916 38558 37998 37324 37324 33398 32755 21472 31724 31724 31724
Performance regression when bulk inserting into table with indices
36
bugs core 5612 
 tracker
 CS 2025.10.19 16:22
18954 19576 19823 19576 18684 19576 19814 18684 18639 19645 19645 18639 18639 1091 X X 1018 X X X X X 978 923 923 622 622 622 656 705 896
Gradual slowdown compilation (create, recreate or drop) of views
37
bugs core 5612 
 tracker
 SS 2025.10.19 16:22
15665 15758 15665 15188 15387 15286 15286 15387 15387 15286 16048 16703 17677 17677 17677 17677 17733 17379 17379 593 593 X 593 593 593 432 423 408 408 392 383
Gradual slowdown compilation (create, recreate or drop) of views
38
bugs core 5637 
 tracker
 CS 2025.07.16 14:32
1944 1944 1944 1960 2096 2172 2096 2096 2088 1993 1965 1848 1848 1908 1796 1908 1950 2010 2010 2010 1660 1660 1617 1576 1576 1002 1002 1002 1036 1086 1379
string right truncation on restore of security db
39
bugs core 5638 
 tracker
 CS 2022.02.02 14:46
1465 1465 1465 1452 1452 1452 1357 1357 1399 1381 1399 1399 1381 1366 1366 1366 1366 1366 1349 1325 1225 1225 1318 1179 1179 774 774 692 692 833 1091
Wrong result with index on case-insensitive collation using NUMERIC-SORT
40
bugs core 5794 
 tracker
 CS 2025.07.02 11:51
1296 1241 1296 1248 1248 1224 1248 1248 1179 1309 1309 1206 1186 1186 1186 1194 1194 1194 1194 1144 1008 1008 1008 1008 1008 621 621 621 646 646 646
Wrong behavour FOR <select_stmt> [AS CURSOR cursorname] with next update and delete
41
bugs core 6452 
 tracker
 CS 2022.02.02 14:46
1268 1196 1196 1196 1236 1247 1247 1236 1154 660 660 660 1151 1026 1026 774 1026 774 734 774 776 776 972 972 993 1032 972 693 1018 667 667
SIMILAR TO leads to an infinite loop
42
bugs gh 6915 hu hu 
 tracker
 SS 2024.12.30 09:13
20326 21282 22029 22029 22029 21287 21752 21287 21287 20640 20260 20260 20250 19133 19133 19292 19292 19839 19839 19839 17291 17291 15454 15435 15454 17148 15435 10012 15170 13315 13315
Performance effect of applying 'DISABLE-COMPRESSIONS=1' in UNICODE collation for LOCALE=hu_HU
43
bugs gh 7038 
 tracker
 SS 2023.05.13 17:33
59981 59981 61288 63017 65061 65061 65061 63298 63298 60701 63298 62304 62304 56388 57156 57156 57156 58981 58981 58981 53622 53622 53622 52063 52063 46816 46675 28971 28971 28971 28971
Improve performance of STARTING WITH with insensitive collations
44
bugs gh 7627 
 tracker
 SS 2023.08.26 15:57
2697 2697 2657 2464 2284 2464 2339 2124 2124 2124 2074 1350 1350 1360 1350 1360 1360 1360 2071 2071 2071 2071 2328 1931 1927 1927 1905 1776 1884 1905 1884
The size of the database with big records becomes bigger after backup/restore
45
bugs gh 7744 
 tracker
 SS 2025.07.05 19:18
2605 2700 2700 2571 2571 2415 2415 2415 2415 2419 2419 1337 1337 2261 1337 2261 2261 2144 2117 2117 2117 2117 2117 1919 2073 2073 2073 1906 2073 2276 1770
Provide ability to run "ALTER SQL SECURITY DEFINER / INVOKER" without specifying further part of proc/func/package
46
bugs gh 7749 
 tracker
 SS 2025.07.05 19:26
1462 1408 1375 1375 1219 1260 1260 1260 1219 1181 772 730 730 1181 709 1182 1182 891 876 891 891 902 992 992 1221 905 950 916 950 950 1091
Fix character set and collation output
47
bugs gh 7854 
 tracker
 SS 2023.11.22 22:35
7612 7555 7555 7555 7691 7758 7758 7758 7826 7827 7612 7612 7827 7612 6942 6942 7128 6919 6919 6919 6300 5976 5976 5976 5976 3350 3350 3350 3394 3678 5013
Performance issue with time zones
48
bugs gh 8161 
 tracker
 SS 2025.10.09 11:20
2236 2236 2224 2224 2224 2224 2233 2233 2192 2192 2268 2180 2154 2116 2116 2116 2116 1952 1862 1862 1862 X 1807 1807 1807 1140 1140 1124 1140 1156 1427
Cardinality estimation should use primary record versions only
49
bugs gh 8673 
 tracker
 CS 2025.07.29 20:28
27319 27319 23740 23740 23740 23497 23497 13513 13432 13432 13432 12837 16864 23989 16864 16183 16864 16183 16183 23144 23834 25340 32885 32885 32885 25762 25762 25627 25627 24580 24052
Error unable to allocate memory from operating system
50
functional arno optimizer opt sort by index 16 
 CS 2025.07.08 12:50
1569 1318 1318 1318 827 827 890 886 890 918 890 918 918 786 786 795 786 745 795 795 833 871 1174 1174 1174 1081 1052 1035 1035 1033 1010
ORDER BY DESC NULLS FIRST using index

Elapsed time, milliseconds:

NN Test name mode Test last update
6.0.0.1354
2025.11.09
174ee
6.0.0.1352
2025.11.08
c595c
6.0.0.1351
2025.11.07
d7fef
6.0.0.1346
2025.11.06
bf133
6.0.0.1342
2025.11.05
ff3e4
6.0.0.1338
2025.11.03
c32dc
6.0.0.1337
2025.11.01
339dc
6.0.0.1336
2025.10.31
a7d03
6.0.0.1335
2025.10.29
eceaf
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
Test TITLE
1
bugs core 0001 
 tracker
 CS 2022.02.02 14:46 2488 2408 2540 2637 2457 2497 2462 2342 2608 2396 2869 2226 2368 1611 1956 1740 2236 2174 1215 2344 2207 2460 2257 1480 1882 2428 1824 1183 1187 1098 1361 1296 1909 2140 1899
Server shutdown
2
bugs core 0037 
 tracker
 CS 2022.02.02 14:46 1447 1552 1313 1398 1223 1336 1441 1294 1319 1363 1348 1297 776 1256 1090 933 1389 1080 1197 1416 1358 1344 1293 729 1010 1547 1072 653 656 571 755 683 1036 1074 1093
Error "no current record for fetch operation" on view select
3
bugs core 0059 
 tracker
 CS 2025.07.01 12:34 1323 1349 1220 1213 1231 1140 1369 1276 1401 765 1423 1254 1258 1274 971 900 1198 743 1180 1242 1100 1355 1132 739 917 1324 1019 577 581 600 613 699 1028 998 1044
Automatic not null in PK columns incomplete
4
bugs core 0070 
 tracker
 CS 2025.07.01 12:34 1248 1417 756 1238 1163 741 1425 1401 1393 798 1346 1345 1153 1102 1044 980 1170 650 1280 1436 1184 1178 1101 720 942 1325 1015 624 601 571 642 669 940 1066 1032
Expression index regression since 2.0a3
5
bugs core 0148 
 tracker
 CS 2022.02.02 14:46 1324 1368 1352 1237 1263 1213 1348 1145 1290 1276 1195 1131 1212 1247 668 970 1233 1219 1216 1202 1111 1312 1086 715 989 1135 998 618 618 580 691 636 1145 995 994
SELECT '1' UNION SELECT '12'
6
bugs core 0297 
 tracker
 CS 2022.02.02 14:46 1570 1536 1642 1464 1378 1599 1341 1527 1741 1530 1325 1404 1444 1421 1387 1415 1309 741 1289 1248 779 1397 1353 899 1317 1273 1205 779 652 716 803 682 1273 1145 1204
IB server stalled by simple script
7
bugs core 0337 
 tracker
 CS 2022.02.02 14:46 1975 2014 2151 2183 2149 2316 2240 1289 2512 2272 2261 2103 2323 2142 1994 2087 2176 2244 2118 2126 1428 2088 2016 1244 1815 1946 1768 1114 1119 1079 1208 1086 1872 1774 1630
ISQL and database dialect
8
bugs core 0475 
 tracker
 CS 2022.02.02 14:46 1419 1398 1397 1205 1261 1381 1201 1194 1354 1171 1169 1234 1290 1289 1184 1155 1135 1363 1334 1416 1267 1262 1173 773 993 1250 1015 660 574 619 794 653 1010 1006 1077
ORDER BY has no effect
9
bugs core 0855 
 tracker
 CS 2022.02.02 14:46 1135 1118 1140 1296 1250 1245 1214 1166 1331 1287 1345 1136 1177 1073 1380 1117 1113 1129 1149 1200 1224 1137 1114 705 957 1073 980 565 560 604 629 621 1124 949 1004
Aggregates in the WHERE clause vs derived tables
10
bugs core 0857 
 tracker
 CS 2024.10.30 22:17 1202 1292 1412 1241 1313 1216 1348 1262 1449 1334 1220 1217 1198 1187 1256 1125 1176 1248 1219 1258 1309 1203 1321 858 1007 1256 1028 654 668 582 740 697 1124 1000 1060
Containing not working correctly
11
bugs core 0888 
 tracker
 CS 2022.02.02 14:46 1350 1126 1220 1293 1159 1140 1220 1328 1202 1331 1173 1074 1100 1168 1078 1229 1261 1076 1238 1265 1118 1020 1055 785 968 1067 1034 639 590 558 638 593 1047 1025 1086
DDL - object in use
12
bugs core 0932 
 tracker
 CS 2022.02.02 14:46 1827 1786 1782 1613 1626 1715 2083 1777 1938 1756 1932 1565 1542 1611 1865 1890 1854 1877 1689 1915 1847 1872 1305 1036 1386 1957 1363 898 827 823 975 948 1448 1384 1502
Comment in create database
13
bugs core 1019 
 tracker
 CS 2022.02.02 14:46 1101 1267 1312 1101 1286 1179 1263 1302 1330 1211 1312 1242 1145 1145 1170 1164 1023 1389 1348 1398 1227 1151 692 673 999 1253 952 598 605 610 755 659 587 593 1020
Make information available regading ODS Version and Dialect via SQL
14
bugs core 1026 utf8 
 tracker
 CS 2024.10.31 10:17 1541 1496 1443 1477 1449 1333 1501 1515 1494 1290 1424 1412 1361 1359 1456 1498 1149 1363 1257 1448 1381 1196 1111 980 1272 1434 1253 748 753 751 816 852 777 674 1017
Estonian collation in UTF8 charset
15
bugs core 1126 
 tracker
 CS 2022.02.02 14:46 1121 1133 1136 1124 1255 1189 1103 1288 1237 1245 1285 1173 1124 1079 1182 1160 1179 1104 1249 1203 1375 1189 619 662 971 1329 986 596 595 582 658 738 927 1037 1012
Incorrect results when left join on subquery with constant column
16
bugs core 1172 
 tracker
 CS 2022.02.02 14:46 1452 1618 1541 1364 1601 1531 1613 1632 1511 1588 1518 1487 1509 1376 1521 1458 1526 1366 1514 1643 1521 1545 1198 964 1211 1692 1309 802 777 723 893 866 925 1187 1312
Symbols ignored for ES_ES_CI_AI collation
17
bugs core 1183 
 tracker
 CS 2022.02.02 14:46 1355 1521 1523 1724 1542 1462 1581 1450 1504 1457 1629 1379 1417 1685 1418 1476 1494 1453 1476 1856 1486 1447 1367 959 1170 1402 1249 737 698 706 866 869 1248 1297 745
View cannot be created if its WHERE clause contains IN <subquery> with a procedure reference
18
bugs core 1196 
 tracker
 CS 2022.02.02 14:46 1228 1359 1201 1374 1271 1410 1344 1482 1312 1546 1418 1267 1261 1319 1342 1343 1385 1278 1523 1654 1318 1242 1185 803 1000 1283 1082 650 623 614 757 667 1100 1122 556
Long SQL statements break TCP/IP connection
19
bugs core 3018 
 tracker
 CS 2022.02.02 14:46 1235 1113 624 1199 1276 1187 1347 1171 1223 1217 1344 1171 1214 1081 1100 1209 1321 1110 1158 713 1121 1217 1021 733 939 1129 1006 605 569 591 671 644 1010 1053 974
RECREATE, ALTER and CREATE OR ALTER SEQUENCE/GENERATOR statements
20
bugs core 3052 
 tracker
 CS 2022.02.02 14:46 1381 1219 1193 1538 1142 1271 1501 1225 1246 953 1233 1212 1176 1194 1187 1104 1571 1153 1158 780 1110 1146 1154 742 1113 1121 971 629 572 563 698 674 1020 1109 1010
Wrong resultset
21
bugs core 3057 
 tracker
 CS 2022.02.02 14:46 1040 1441 1476 1294 1396 1328 1279 1320 1319 696 1442 717 1225 1453 1239 1157 2091 1207 1175 1401 1170 1233 1084 784 1111 1200 1098 714 590 641 759 697 1116 1157 1019
Allow the usage of blobs in COMPUTED BY expressions
22
bugs core 3360 
 tracker
 CS 2022.02.02 14:46 2644 2460 2665 2771 2598 2681 2493 2709 2765 2941 2612 2580 2535 2428 2599 2750 3245 2395 2420 2586 2636 2605 1458 1478 2250 2584 2448 1394 1300 1355 1607 1462 2396 2331 2245
update ... returning ... raises -551 (no perm to update) for a column present only in the returning clause
23
bugs core 3427 
 tracker
 CS 2022.02.02 14:46 1338 1295 1211 1323 1244 1304 1519 1250 1447 1348 1249 1136 1392 1287 1274 1323 1906 1124 1218 1402 1168 1222 1273 704 1140 1269 1063 644 668 608 773 737 587 1047 1047
Server crashing with UTF8 blobs
24
bugs core 3447 
 tracker
 CS 2023.10.05 12:00 1428 1397 1278 1425 1375 1609 1568 1558 1456 1404 1324 1345 1328 1336 1278 1220 1749 1389 1372 1547 1359 1252 1291 887 1316 1603 1239 734 725 654 844 763 641 1101 1096
Collation is not installed with icu > 4.2
25
bugs core 3475 
 tracker
 CS 2023.12.11 11:27 1037 1226 1182 1166 1279 1167 1410 1101 1213 1280 1177 1119 1150 1190 1233 1229 1368 1087 1160 1110 1077 1165 1066 756 932 1128 1003 566 590 556 697 649 866 986 973
Parameters inside the CAST function are described as not nullable
26
bugs core 3526 
 tracker
 CS 2022.02.02 14:46 1240 1220 1135 1244 1266 1184 1298 1277 1119 1080 1200 1167 1028 1149 1161 1233 1726 1018 1035 1210 1129 1191 1157 682 977 1128 994 648 617 580 721 663 1044 531 1059
Support for WHEN SQLSTATE
27
bugs core 4006 
 tracker
 CS 2022.02.02 14:46 1340 1240 1292 1222 1179 1258 1136 1164 1183 1359 1112 1210 1024 1129 1119 1257 1569 1121 1394 1460 1280 1064 685 717 977 1066 1003 610 609 559 705 700 648 996 1108
using a result from a procedure in a substring expression leads to server crash
28
bugs core 4058 
 tracker
 CS 2022.02.02 14:46 1054 1051 1118 1016 1186 1055 1163 1005 1277 1219 1073 1056 1088 1091 1129 861 1464 870 1052 1042 1282 1041 571 637 814 906 895 541 487 528 629 518 495 466 900
Remote Stack Buffer Overflow in Firebird SQL Server (when specially crafted packet is sent via socket API)
29
bugs core 4093 
 tracker
 CS 2022.02.02 14:46 1156 1229 1255 1363 719 1382 1166 1156 1197 1209 1275 1144 1063 1134 1143 1184 1384 1084 1102 1196 1295 1189 628 718 947 1165 988 593 562 579 727 680 592 534 557
Server crashes while converting an overscaled numeric to a string
30
bugs core 4136 
 tracker
 CS 2022.02.02 14:46 1318 1425 1293 1247 1038 1371 1381 1430 1330 1291 1135 1368 1177 1242 1276 1170 1792 1164 1194 1261 1098 1124 830 804 1046 1210 1060 660 1118 1138 671 600 580 586 746
Sharp-S character treated incorrectly in UNICODE_CI_AI collation
31
bugs core 4460 
 tracker
 CS 2025.09.26 18:01 3669 4416 4106 2700 3188 3856 3205 3619 3602 4201 4819 2634 2629 2484 2546 3698 3684 2763 4952 4967 4392 4155 3532 4062 5591 4803 5438 3303 3688 3603 3596 3485 573 981 539
UNION sub-parts may be badly optimized. Check for ALL built-in functions.
32
bugs core 4460 
 tracker
 SS 2025.09.26 18:01 3862 3866 3482 3539 4021 3882 3598 3554 3375 3450 3707 3937 3389 3766 3785 3701 3681 3435 3328 3613 3596 3848 3355 3697 4802 4822 5171 3160 3499 3565 3234 3264 403 393 447
UNION sub-parts may be badly optimized. Check for ALL built-in functions.
33
bugs core 4731 
 tracker
 SS 2025.10.31 13:25 32427 33515 32079 29807 33658 33438 33052 31288 X X X X X X 13556 13408 13347 X X X X X 13356 14335 18194 18087 18212 12370 12699 12529 13244 11468 12667 12632 11977
Prohibit an ability to issue DML or DDL statements on RDB$ tables
34
bugs core 5231 
 tracker
 CS 2024.08.09 16:30 4430 5225 4455 4331 4432 4324 4568 4404 4689 5216 4785 4286 4274 4468 4567 4197 4171 3775 4833 5000 4397 3985 3689 2450 3738 4327 3941 2078 3357 3527 2210 2207 3298 2994 3225
EXECUTE STATEMENT: BLR error if more than 256 output parameters exist
35
bugs core 5302 
 tracker
 CS 2023.05.13 17:30 46717 46816 44635 42224 43848 47870 45495 43594 49620 45139 41494 42207 47711 44557 41989 42454 40484 43051 42662 47234 44859 41963 40916 27996 37324 38558 37998 21073 33398 32755 21472 20675 31724 33521 33057
Performance regression when bulk inserting into table with indices
36
bugs core 5612 
 tracker
 CS 2025.10.19 16:22 17620 18954 19823 19881 17731 19576 21185 18684 18231 19814 19868 17726 18639 19645 X X 31149 X X X X X 1091 727 923 1018 978 622 564 580 705 656 1034 896 996
Gradual slowdown compilation (create, recreate or drop) of views
37
bugs core 5612 
 tracker
 SS 2025.10.19 16:22 15020 15758 16327 15188 15665 15835 15169 14767 15387 15286 16048 16703 15184 15241 18333 17677 17758 16878 17379 18570 17733 X 411 417 593 628 626 408 432 423 383 306 408 392 349
Gradual slowdown compilation (create, recreate or drop) of views
38
bugs core 5637 
 tracker
 CS 2025.07.16 14:32 2172 2036 1944 1876 1935 2186 1960 2096 2277 2172 1965 2088 1848 1993 1732 1698 1908 1950 1796 2010 2206 2040 1660 1205 1576 2047 1617 1002 864 877 1086 1036 1379 1561 1552
string right truncation on restore of security db
39
bugs core 5638 
 tracker
 CS 2022.02.02 14:46 1456 1653 1478 1465 1257 1452 1516 1336 1551 1357 1338 1448 1399 1381 1401 1234 1352 1366 1515 1724 1325 1225 1349 965 1179 1331 1318 774 624 642 833 692 1217 1142 1091
Wrong result with index on case-insensitive collation using NUMERIC-SORT
40
bugs core 5794 
 tracker
 CS 2025.07.02 11:51 1345 1241 1299 691 1296 1224 1432 1248 1179 1112 1309 1365 684 1323 1186 1206 644 1123 1194 1349 1235 1144 622 791 1008 1326 1107 621 599 601 742 741 646 545 565
Wrong behavour FOR <select_stmt> [AS CURSOR cursorname] with next update and delete
41
bugs core 6452 
 tracker
 CS 2022.02.02 14:46 1355 1349 1268 702 1193 1196 1264 1326 1236 1247 646 660 1154 594 1220 644 1151 1026 629 774 1247 734 587 776 993 1153 972 693 1049 1032 667 616 1018 588 997
SIMILAR TO leads to an infinite loop
42
bugs gh 6915 hu hu 
 tracker
 SS 2024.12.30 09:13 20326 19195 19948 22220 22708 21282 22029 20735 24870 21287 21752 20260 20250 20640 19010 20461 19133 18890 19292 21505 19839 20556 17291 13026 15454 21144 15435 9930 17223 17148 9688 10012 15170 13315 15475
Performance effect of applying 'DISABLE-COMPRESSIONS=1' in UNICODE collation for LOCALE=hu_HU
43
bugs gh 7038 
 tracker
 SS 2023.05.13 17:33 65724 57422 59981 52548 63017 61288 65061 68610 81407 60701 63298 56446 65692 56186 63338 62304 37639 56388 57156 60591 58981 63198 53622 45797 52063 73300 55968 28142 46816 46675 28971 28962 26854 39762 35108
Improve performance of STARTING WITH with insensitive collations
44
bugs gh 7627 
 tracker
 SS 2023.08.26 15:57 1748 2697 2824 3231 2284 2464 2657 1951 1442 2936 2339 2124 1151 2074 1316 1350 2816 1360 1239 2113 1252 2071 2328 1931 2666 1927 2706 1645 1132 2276 1905 1776 1884 2295 1725
The size of the database with big records becomes bigger after backup/restore
45
bugs gh 7744 
 tracker
 SS 2025.07.05 19:18 2605 2152 2804 2561 2700 2701 2571 2352 2415 2332 2419 2493 1294 2635 1337 1322 2261 2598 1324 2344 1528 2144 2117 1919 2384 1791 2421 1906 2073 2476 1770 1713 2276 2336 1225
Provide ability to run "ALTER SQL SECURITY DEFINER / INVOKER" without specifying further part of proc/func/package
46
bugs gh 7749 
 tracker
 SS 2025.07.05 19:26 1462 1408 1483 1554 745 1156 1375 1380 1219 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
Fix character set and collation output
47
bugs gh 7854 
 tracker
 SS 2023.11.22 22:35 7802 7612 7892 7041 7555 6767 7691 7758 7826 8304 7546 7387 7827 8005 7612 6942 9950 4489 6852 7475 7128 6919 5145 4927 6300 5976 6669 3350 3248 3181 3678 3394 5280 5013 5268
Performance issue with time zones
48
bugs gh 8161 
 tracker
 SS 2025.10.09 11:20 2135 2236 2460 2396 2200 2224 2201 2267 2233 2192 2268 2180 2154 2313 2443 2012 2116 1952 2171 2136 1862 X 1483 1367 1875 1939 1807 1047 1140 1073 1156 1124 1427 1903 1714
Cardinality estimation should use primary record versions only
49
bugs gh 8673 
 tracker
 CS 2025.07.29 20:28 23189 29190 15299 31243 27319 14014 23740 23497 28203 13513 13432 12364 12358 27051 24925 12837 16864 23989 16183 13488 23144 15176 23834 25340 35690 33899 32885 22317 25627 25762 26435 23660 24580 22775 24052
Error unable to allocate memory from operating system
50
functional arno optimizer opt sort by index 16 
 CS 2025.07.08 12:50 1628 1600 800 1569 1318 788 1623 827 798 1449 890 886 1323 918 739 1495 786 701 1353 795 718 745 833 871 1227 1174 1174 858 1052 1081 1035 1006 1010 1033 945
ORDER BY DESC NULLS FIRST using index

List of tests in this report:


http://tracker.firebirdsql.org/browse/CORE-1
http://tracker.firebirdsql.org/browse/CORE-1019
http://tracker.firebirdsql.org/browse/CORE-1026
http://tracker.firebirdsql.org/browse/CORE-1126
http://tracker.firebirdsql.org/browse/CORE-1172
http://tracker.firebirdsql.org/browse/CORE-1183
http://tracker.firebirdsql.org/browse/CORE-1196
http://tracker.firebirdsql.org/browse/CORE-148
http://tracker.firebirdsql.org/browse/CORE-297
http://tracker.firebirdsql.org/browse/CORE-3018
http://tracker.firebirdsql.org/browse/CORE-3052
http://tracker.firebirdsql.org/browse/CORE-3057
http://tracker.firebirdsql.org/browse/CORE-3360
http://tracker.firebirdsql.org/browse/CORE-337
http://tracker.firebirdsql.org/browse/CORE-3427
http://tracker.firebirdsql.org/browse/CORE-3447
http://tracker.firebirdsql.org/browse/CORE-3475
http://tracker.firebirdsql.org/browse/CORE-3526
http://tracker.firebirdsql.org/browse/CORE-37
http://tracker.firebirdsql.org/browse/CORE-4006
http://tracker.firebirdsql.org/browse/CORE-4058
http://tracker.firebirdsql.org/browse/CORE-4093
http://tracker.firebirdsql.org/browse/CORE-4136
http://tracker.firebirdsql.org/browse/CORE-4460
http://tracker.firebirdsql.org/browse/CORE-4731
http://tracker.firebirdsql.org/browse/CORE-475
http://tracker.firebirdsql.org/browse/CORE-5231
http://tracker.firebirdsql.org/browse/CORE-5302
http://tracker.firebirdsql.org/browse/CORE-5612
http://tracker.firebirdsql.org/browse/CORE-5637
http://tracker.firebirdsql.org/browse/CORE-5638
http://tracker.firebirdsql.org/browse/CORE-5794
http://tracker.firebirdsql.org/browse/CORE-59
http://tracker.firebirdsql.org/browse/CORE-6452
http://tracker.firebirdsql.org/browse/CORE-70
http://tracker.firebirdsql.org/browse/CORE-855
http://tracker.firebirdsql.org/browse/CORE-857
http://tracker.firebirdsql.org/browse/CORE-888
http://tracker.firebirdsql.org/browse/CORE-932
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_sort_by_index_16.py
https://github.com/FirebirdSQL/firebird/issues/6915
https://github.com/FirebirdSQL/firebird/issues/7038
https://github.com/FirebirdSQL/firebird/issues/7627
https://github.com/FirebirdSQL/firebird/issues/7744
https://github.com/FirebirdSQL/firebird/issues/7749
https://github.com/FirebirdSQL/firebird/issues/7854
https://github.com/FirebirdSQL/firebird/issues/8161
https://github.com/FirebirdSQL/firebird/issues/8673
=== end of list ===

Last commits information (all timestamps in UTC):