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 (33 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 (57 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 (2 rows)
11. All tests: outcomes for previous 35 runs (2989 rows)
12. Skipped: tests which was intentionally excluded from execution (174 rows)

Generated UTC 08.12.2025 01:21
Tested: FB60.   Build / date: 6.0.0.1365-e878785a / 2025.12.07;
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.1365
2025.12.07
e8787
6.0.0.1364
2025.12.04
90488
6.0.0.1363
2025.12.03
ead6d
6.0.0.1361
2025.12.01
56dfb
6.0.0.1360
2025.11.29
8b3c3
6.0.0.1358
2025.11.24
312cc
6.0.0.1357
2025.11.19
d37c9
6.0.0.1356
2025.11.17
df73f
6.0.0.1355
2025.11.16
f3c5d
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
Test TITLE
1
bugs core 1607 
 tracker
 CS 2025.06.25 17:48
1101 718 718 726 726 802 883 1093 1093 1093 1093 1203 1203 1203 1210 1203 1237 1141 1141 744 645 645 645 678 1097 1122 1155 1155 1122 1120 984
Correlated subquery is optimized badly if it depends on the union stream
2
bugs core 1609 
 tracker
 CS 2022.02.02 14:46
1178 730 730 819 819 869 869 869 871 871 871 1212 1212 1241 1241 1271 1373 1271 1152 703 668 668 668 672 1229 1229 1229 1183 1166 1166 1004
PSQL output parameter size limited
3
bugs core 1715 
 tracker
 CS 2025.06.26 07:18
2890 1894 1894 2007 3043 3009 3009 2888 2888 1893 1893 1893 2758 2758 2758 2740 2638 2638 2223 2638 2641 2641 2776 2838 2776 1916 2468 2468 1916 2403 2403
Incorrect "key size exceeds implementation restriction for index" error
4
bugs core 1885 
 tracker
 CS 2022.04.24 10:50
1222 804 804 1303 1311 1303 1303 1233 727 727 717 717 698 717 698 698 697 708 708 728 787 811 1141 1181 1181 1195 1181 1038 907 976 976
CREATE COLLATION connection lost under Posix
5
bugs core 1891 
 tracker
 CS 2025.06.26 10:27
1147 757 757 1088 1147 1152 1152 1152 739 739 739 750 758 1103 758 750 736 680 680 703 703 783 1051 1116 1116 1134 1134 1130 776 980 980
SHOW VIEW shows non-sense information for view fields with expressions
6
bugs core 2039 
 tracker
 CS 2022.02.02 14:46
1335 868 868 868 886 892 920 920 892 892 920 879 923 938 923 903 938 903 903 975 1005 1308 1324 1386 1324 1308 873 873 873 885 1268
Domain-level CHECK constraints wrongly process NULL values
7
bugs core 2041 
 tracker
 CS 2022.02.02 14:46
1461 890 890 890 946 960 960 960 923 868 868 868 939 967 967 967 932 907 907 907 916 1266 1346 1494 1494 1494 961 961 961 985 1319
update or insert with gen_id() with wrong generator value
8
bugs core 2042 
 tracker
 CS 2022.02.02 14:46
1427 917 915 915 917 917 915 893 893 893 893 893 929 1013 903 935 935 903 898 898 898 1204 1394 1415 1394 1204 897 897 897 971 1297
Connection lost to database when used AUTONOMOUS TRANSACTION
9
bugs core 2044 
 tracker
 CS 2022.02.02 14:46
1375 908 857 857 857 898 925 925 925 925 925 900 900 900 892 900 924 924 860 924 924 1342 1422 1422 1373 1342 932 932 869 932 1281
Incorrect result with UPDATE OR INSERT ... RETURNING OLD and non-nullable columns
10
bugs core 5726 
 tracker
 CS 2023.12.13 10:42
1103 694 694 1103 1172 1225 1225 1270 1225 1158 1158 1172 1172 1192 1192 1192 1192 1263 1192 1263 1263 1263 1181 1181 1181 1181 1148 1148 1131 1018 867
Unclear error message when inserting value exceeding max of dec_fixed decimal
11
bugs core 5728 
 tracker
 CS 2023.12.13 10:53
1159 753 753 1084 1084 1247 1247 1247 1247 1188 1188 1188 1171 1171 1253 1171 1163 1170 1163 1130 1130 1170 1131 1176 1176 1208 1225 1225 1099 996 772
Field subtype of DEC_FIXED columns not returned by isc_info_sql_sub_type
12
bugs core 5904 
 tracker
 CS 2022.02.02 14:46
1244 806 806 1244 1260 1271 1346 1348 1348 1348 1365 1365 1365 1387 1387 1286 1276 1276 885 885 1148 1231 1231 1231 1170 1225 1170 798 798 847 847
An attempt to create global mapping with long (greater than SQL identifier length) FROM field fails
13
bugs core 6382 
 tracker
 CS 2022.02.02 14:46
1519 995 983 983 953 983 1086 1560 1560 1560 1560 1560 1723 1727 1727 1727 1656 967 906 906 906 894 1478 1478 953 953 953 871 953 1119 1062
Triggers accessing a table prevent concurrent DDL command from dropping that table
14
bugs core 6408 
 tracker
 CS 2022.02.02 14:46
1167 770 705 705 770 786 800 1188 1188 1188 1188 1226 1207 1278 1278 1238 1207 1238 1238 1164 1229 1229 1167 1164 693 693 681 681 710 776 776
RETURNING clause in MERGE cannot reference column in aliased target table using qualified reference (alias.column) if DELETE action present
15
bugs core 6414 
 tracker
 CS 2024.10.31 10:32
1241 772 768 768 768 810 1287 1368 1368 1287 1241 1241 1200 1241 1327 1327 1200 1274 1255 1255 1255 1255 1242 914 785 785 785 729 785 860 860
Error message "expected length N, actual M" contains wrong value of M when charset UTF8 is used in the field declaration of a table
16
bugs core 6419 
 tracker
 CS 2024.10.31 10:32
1147 698 698 698 761 834 1275 1275 1275 1216 1145 1145 1145 1319 1328 1328 1319 750 750 750 750 750 1146 716 709 709 709 698 709 794 794
Truncation of strings to put in MON$ tables do not work correctly
17
bugs core 6429 
 tracker
 CS 2022.02.02 14:46
1176 777 766 766 770 777 806 1227 1227 1227 1227 1372 1421 1421 1421 1384 1317 742 742 742 795 806 822 822 806 806 719 701 719 792 792
Timezone offset in timestamp/time literal, CAST, SET TIME ZONE and AT TIME ZONE should follow SQL standard syntax only
18
bugs core 6440 
 tracker
 CS 2025.07.03 12:40
1744 1143 1141 1141 1141 1143 1313 1860 1860 1860 1756 1756 1756 1960 1960 1960 1920 1115 1115 1115 1118 1141 1277 1277 1141 1141 1112 1092 1112 1292 1292
Expression indexes containing COALESCE inside cannot be matched by the optimizer
19
bugs core 6444 
 tracker
 CS 2025.07.03 12:42
1119 694 694 694 716 731 1188 1301 1301 1301 1219 1219 1219 1222 1222 1222 1108 749 749 749 746 746 796 746 740 740 740 692 692 738 738
Ability to query Firebird configuration using SQL
20
bugs core 6460 
 tracker
 CS 2022.02.02 14:46
1131 743 743 743 749 766 810 820 820 1115 1115 1200 1184 1200 1200 1184 1179 767 767 767 767 1012 1012 711 667 711 711 667 726 751 751
Incorrect query result when using named window
21
bugs gh 7046 
 tracker
 CS 2025.07.04 20:15
1660 1066 1066 1066 1066 1122 1122 1137 1122 1034 1034 1049 1049 1672 1672 1814 1814 1197 1197 1090 972 1090 972 972 964 960 951 951 951 969 1403
Make ability to add comment to mapping ('COMMENT ON MAPPING ... IS ...')
22
bugs gh 7993 
 tracker
 CS 2024.02.06 09:34
1165 705 705 1255 1339 1339 1339 1314 1186 728 1115 1115 728 728 1115 696 696 1207 1207 1081 1081 694 694 708 708 836 985 985 836 836 935
Unexpected results when using CASE WHEN with RIGHT JOIN
23
bugs gh 7995 
 tracker
 CS 2024.02.07 09:08
1092 727 727 1092 1320 1320 1320 1301 1240 745 1240 1190 745 782 1190 782 782 1213 1213 1148 1148 738 716 716 716 797 1114 1114 826 826 961
Unexpected results after creating partial index
24
bugs gh 8066 
 tracker
 CS 2024.05.08 06:33
1678 1097 1097 1638 1638 1638 1781 1783 1781 1781 1725 1725 1723 1723 1144 1098 1086 1086 1086 1052 1052 1052 1152 1591 1611 1611 1657 1657 1172 1172 1440
Make protocol schemes case-insensitive
25
bugs gh 8077 
 tracker
 CS 2025.07.06 10:28
17912 11611 11611 17912 17912 18069 19147 19104 18069 18069 19104 19104 14026 14026 12577 12577 12577 14767 14767 14767 15648 15672 11967 15672 17925 17925 17070 17070 12663 12663 15854
Error "Too many recursion levels" does not stop execuition of code that uses ON DISCONNECT trigger (FB 4.x+)
26
bugs gh 8722 
 tracker
 CS 2025.09.01 20:41
1116 673 855 855 839 839 839 725 725 725 757 757 1080 1080 757 746 746 710 710 746 676 1096 1124 1096 1179 1179 1047 768 786 786 786
The "IF NOT EXISTS" clause is missing for DECLARE FILTER
27
functional arno derived tables 06 
 CS 2025.07.07 10:57
1348 895 895 895 895 991 991 991 962 909 901 909 962 1123 1123 1393 1393 1385 1385 1388 1388 1388 1388 851 838 838 838 1053 1053 1303 1255
Outer reference inside derived table to other relations in from clause is not allowed
28
functional arno derived tables 21 
 CS 2022.02.04 18:05
1403 886 851 851 851 880 880 880 838 831 831 838 901 943 943 1448 1448 880 872 880 880 901 901 901 879 879 879 924 988 1260 1215
Implicit derived table by IN predicate
29
functional arno optimizer opt full join 02 
 SS 2025.07.16 15:54
831 511 468 468 511 621 621 621 621 619 569 619 480 454 480 491 491 491 491 548 491 491 662 677 662 662 566 566 537 537 661
FULL OUTER JOIN, list all values, but filtered in WHERE clause
30
functional intfunc string ascii 01 
 SS 2022.02.04 18:05
618 367 367 503 631 678 678 678 471 377 377 377 413 508 513 612 612 612 554 613 613 613 554 474 469 446 469 469 446 558 574
ASCII_CHAR( <number> )
31
functional intfunc string left 01 
 SS 2022.02.04 18:05
628 364 364 606 606 541 541 516 448 438 438 385 438 608 608 630 630 629 603 629 565 565 565 573 551 573 623 623 523 572 572
LEFT function
32
functional tabloid dbp 1940 20110725 1159 
 SS 2022.02.04 18:05
1517 816 856 856 1517 1655 1655 1655 1350 951 849 849 849 849 848 848 848 848 935 935 947 935 947 1079 1079 1170 1355 1328 1349 1355 1355
Common SQL. Check correctness of the results
33
functional tabloid join transformation 008 
 SS 2023.11.25 21:42
1813 974 974 974 1105 1105 1256 1256 1221 1221 1221 1175 1221 1175 1175 1218 1218 1218 1218 1345 1521 1521 1461 1521 1521 1461 1461 1713 1304 1304 1680
Check ability of outer join simplification.

Elapsed time, milliseconds:

NN Test name mode
6.0.0.1365
2025.12.07
e8787
6.0.0.1364
2025.12.04
90488
6.0.0.1363
2025.12.03
ead6d
6.0.0.1361
2025.12.01
56dfb
6.0.0.1360
2025.11.29
8b3c3
6.0.0.1358
2025.11.24
312cc
6.0.0.1357
2025.11.19
d37c9
6.0.0.1356
2025.11.17
df73f
6.0.0.1355
2025.11.16
f3c5d
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
Test TITLE
1
bugs core 1607 
 tracker
 CS 1194 1225 691 1101 580 718 726 802 883 1139 1093 1372 832 718 1210 1203 1321 749 1246 1141 1237 744 645 603 641 678 1097 1207 1362 1122 1155 1120 702 984 862
Correlated subquery is optimized badly if it depends on the union stream
2
bugs core 1609 
 tracker
 CS 1265 1413 730 1178 643 711 1375 819 869 1259 689 1368 871 752 1241 1212 1394 1468 1152 1271 1373 703 668 644 597 672 1229 1269 1239 1166 1183 1166 739 1004 890
PSQL output parameter size limited
3
bugs core 1715 
 tracker
 CS 2890 3113 1852 1745 3043 1894 3112 2007 3235 3009 2888 1893 1836 1850 3151 2994 2758 2740 2223 1849 2638 2641 1819 3169 2776 1867 2910 2838 1916 1777 2468 2669 1831 2403 2171
Incorrect "key size exceeds implementation restriction for index" error
4
bugs core 1885 
 tracker
 CS 1222 1341 712 790 1311 804 1303 1610 1626 1233 715 727 643 1245 717 698 688 1235 692 708 697 728 811 787 1141 1220 1181 1226 823 1195 731 1038 907 976 1022
CREATE COLLATION connection lost under Posix
5
bugs core 1891 
 tracker
 CS 1229 1358 694 757 1147 754 1088 1627 1540 1152 739 644 673 1359 758 750 1125 1103 680 736 631 668 783 703 1051 1116 1271 1199 756 1134 646 1130 776 980 1011
SHOW VIEW shows non-sense information for view fields with expressions
6
bugs core 2039 
 tracker
 CS 1335 1453 1393 835 821 868 886 1368 1528 892 920 823 870 1555 923 879 938 1499 903 829 1005 844 975 1511 1324 1308 1386 1393 873 866 834 1582 885 1268 1354
Domain-level CHECK constraints wrongly process NULL values
7
bugs core 2041 
 tracker
 CS 1496 1556 1461 796 835 890 946 1560 1466 960 923 845 853 868 939 967 972 1752 932 907 897 850 916 1346 1266 1494 1531 1548 961 846 887 1519 985 1319 1395
update or insert with gen_id() with wrong generator value
8
bugs core 2042 
 tracker
 CS 1566 1492 1427 826 781 917 915 1448 1390 884 875 893 929 1524 885 875 1013 1613 903 935 832 877 898 1415 1394 1204 1517 1429 897 867 811 1497 971 1297 1373
Connection lost to database when used AUTONOMOUS TRANSACTION
9
bugs core 2044 
 tracker
 CS 1425 1375 1544 908 786 857 835 1682 1170 898 925 816 1463 1365 892 900 890 1569 860 945 924 826 814 1458 1471 1342 1422 1373 869 856 932 1297 860 1293 1281
Incorrect result with UPDATE OR INSERT ... RETURNING OLD and non-nullable columns
10
bugs core 5726 
 tracker
 CS 1140 1233 672 1103 689 694 1172 1270 1225 1356 1158 1299 1112 688 1227 1172 1192 1360 1192 1393 1157 1263 725 1267 1276 1181 1120 1148 1231 1273 1131 689 767 1018 867
Unclear error message when inserting value exceeding max of dec_fixed decimal
11
bugs core 5728 
 tracker
 CS 1275 1408 753 1159 745 749 1084 1359 1247 1259 1136 1188 1344 747 1253 1171 1155 1259 1272 1163 1130 1170 697 1090 1176 1208 1131 1240 1099 1329 1225 637 726 996 772
Field subtype of DEC_FIXED columns not returned by isc_info_sql_sub_type
12
bugs core 5904 
 tracker
 CS 1276 1275 761 771 1244 806 1260 1412 1346 1271 1348 1447 1365 764 1460 1286 1565 1387 1276 759 885 1370 837 1231 1148 1283 1275 1170 707 1225 798 699 847 994 923
An attempt to create global mapping with long (greater than SQL identifier length) FROM field fails
13
bugs core 6382 
 tracker
 CS 1596 1601 1519 995 881 953 983 1086 937 1593 1729 1560 1007 910 1723 1727 1789 1776 1656 967 906 894 877 1654 1478 880 1641 871 953 1791 855 820 1119 1354 1062
Triggers accessing a table prevent concurrent DDL command from dropping that table
14
bugs core 6408 
 tracker
 CS 1167 1304 1178 698 682 770 705 800 786 1331 1188 1226 706 712 1278 1312 1207 1361 1238 757 691 1306 1315 1164 1229 693 1167 621 681 1371 653 776 710 964 819
RETURNING clause in MERGE cannot reference column in aliased target table using qualified reference (alias.column) if DELETE action present
15
bugs core 6414 
 tracker
 CS 1241 1359 1256 772 768 723 732 810 1432 1454 1287 1368 747 778 1241 1327 1200 1329 1449 894 748 1274 1255 1274 914 709 1242 709 785 1425 689 729 860 1073 1216
Error message "expected length N, actual M" contains wrong value of M when charset UTF8 is used in the field declaration of a table
16
bugs core 6419 
 tracker
 CS 1147 1255 1189 698 636 686 834 761 1275 1382 1410 1216 735 746 1145 1328 1364 1319 1347 750 667 750 1160 1178 716 621 1146 698 709 1193 664 620 794 966 1244
Truncation of strings to put in MON$ tables do not work correctly
17
bugs core 6429 
 tracker
 CS 1269 1360 1176 739 676 777 766 806 770 1279 1227 1372 711 852 1444 1421 1487 1384 1317 742 725 702 795 1359 822 806 1160 693 701 1396 719 696 792 1058 1413
Timezone offset in timestamp/time literal, CAST, SET TIME ZONE and AT TIME ZONE should follow SQL standard syntax only
18
bugs core 6440 
 tracker
 CS 1744 1801 1810 1102 1098 1143 1141 1313 1099 1860 2208 1969 1073 1085 1756 2055 2127 1960 1920 1115 1072 1078 1118 1834 1277 1141 1877 1092 1065 2021 1112 1038 1292 1676 1765
Expression indexes containing COALESCE inside cannot be matched by the optimizer
19
bugs core 6444 
 tracker
 CS 1119 1180 1232 694 690 684 731 1188 716 1301 1306 1319 679 660 1219 1222 1302 1280 1108 749 734 705 796 1272 746 709 1245 740 692 1099 633 674 738 963 1120
Ability to query Firebird configuration using SQL
20
bugs core 6460 
 tracker
 CS 1133 1176 1131 723 678 743 766 810 749 1192 820 1279 709 1115 1200 1255 1184 1271 1179 735 767 697 1012 1274 630 1084 711 667 661 1196 751 589 726 922 1350
Incorrect query result when using named window
21
bugs gh 7046 
 tracker
 CS 1663 952 1660 1782 911 1066 1053 1837 1122 1664 1034 1137 1034 985 1672 1049 1814 1915 1197 1898 967 1090 1599 972 964 2054 960 1163 951 909 884 1690 969 1576 1403
Make ability to add comment to mapping ('COMMENT ON MAPPING ... IS ...')
22
bugs gh 7993 
 tracker
 CS 1244 1165 593 647 1255 705 1339 1396 1437 661 1186 1314 683 728 1115 1234 696 686 1296 689 1207 1295 644 1081 675 694 708 1257 1093 836 985 690 794 1049 935
Unexpected results when using CASE WHEN with RIGHT JOIN
23
bugs gh 7995 
 tracker
 CS 1157 1259 644 639 1092 727 1320 1499 1609 707 1240 1301 722 745 1311 1190 718 782 1308 778 1253 1213 738 1148 667 716 637 1276 1378 797 1114 764 826 1079 961
Unexpected results after creating partial index
24
bugs gh 8066 
 tracker
 CS 1844 1880 1049 1044 1678 1097 1638 1927 1122 1896 1781 1783 905 1723 1725 1845 1026 1047 1144 1098 1086 1052 991 988 1152 1611 1591 1844 2035 1022 1657 1072 1172 1440 1451
Make protocol schemes case-insensitive
25
bugs gh 8077 
 tracker
 CS 17981 17981 9580 10668 17912 11611 19147 21160 11650 18069 20027 19104 12577 14026 19127 21252 11687 12577 10640 14767 15648 16693 10590 10600 15672 17925 11967 19024 19230 11754 17070 12633 12663 16909 15854
Error "Too many recursion levels" does not stop execuition of code that uses ON DISCONNECT trigger (FB 4.x+)
26
bugs gh 8722 
 tracker
 CS 1116 673 1154 1122 600 611 855 1262 839 660 725 696 1432 1085 757 677 1080 1244 710 746 676 630 1124 1096 660 1179 1241 631 1182 1047 722 768 786 978 961
The "IF NOT EXISTS" clause is missing for DECLARE FILTER
27
functional arno derived tables 06 
 CS 1379 861 1399 1348 895 844 857 1165 991 1385 896 889 962 909 901 1123 1469 1393 893 1559 1385 774 1528 1388 1421 851 781 838 827 1328 1463 1053 1033 1303 1255
Outer reference inside derived table to other relations in from clause is not allowed
28
functional arno derived tables 21 
 CS 1448 1740 1403 886 842 851 810 941 1016 880 823 831 838 810 901 943 1448 1490 848 1517 880 822 872 1463 1332 901 878 857 879 1352 1562 924 988 1260 1215
Implicit derived table by IN predicate
29
functional arno optimizer opt full join 02 
 SS 831 837 882 396 363 511 468 993 837 621 569 619 837 423 454 679 480 429 491 548 564 479 398 746 491 812 662 677 566 496 431 662 537 661 688
FULL OUTER JOIN, list all values, but filtered in WHERE clause
30
functional intfunc string ascii 01 
 SS 618 622 367 367 631 344 503 678 711 686 471 351 339 377 508 413 657 612 513 635 406 613 554 687 656 347 474 469 309 446 660 651 423 558 574
ASCII_CHAR( <number> )
31
functional intfunc string left 01 
 SS 644 643 362 364 628 331 671 606 516 541 448 369 378 438 608 385 750 687 603 630 369 629 565 694 551 342 573 647 413 630 623 499 523 572 614
LEFT function
32
functional tabloid dbp 1940 20110725 1159 
 SS 1593 816 1631 727 1517 811 856 2326 1787 1655 951 1350 783 849 848 1043 1384 833 828 848 1867 935 947 803 1079 828 1471 1170 788 1658 1355 1328 1349 1566 1698
Common SQL. Check correctness of the results
33
functional tabloid join transformation 008 
 SS 1813 1913 1924 974 925 910 1105 1376 1466 953 1256 960 1221 1286 1140 1175 1644 972 1218 1345 847 1556 977 1653 1521 952 1461 1713 1915 1001 969 1970 1304 1680 1841
Check ability of outer join simplification.

List of tests in this report:


http://tracker.firebirdsql.org/browse/CORE-1607
http://tracker.firebirdsql.org/browse/CORE-1609
http://tracker.firebirdsql.org/browse/CORE-1715
http://tracker.firebirdsql.org/browse/CORE-1885
http://tracker.firebirdsql.org/browse/CORE-1891
http://tracker.firebirdsql.org/browse/CORE-2039
http://tracker.firebirdsql.org/browse/CORE-2041
http://tracker.firebirdsql.org/browse/CORE-2042
http://tracker.firebirdsql.org/browse/CORE-2044
http://tracker.firebirdsql.org/browse/CORE-5726
http://tracker.firebirdsql.org/browse/CORE-5728
http://tracker.firebirdsql.org/browse/CORE-5904
http://tracker.firebirdsql.org/browse/CORE-6382
http://tracker.firebirdsql.org/browse/CORE-6408
http://tracker.firebirdsql.org/browse/CORE-6414
http://tracker.firebirdsql.org/browse/CORE-6419
http://tracker.firebirdsql.org/browse/CORE-6429
http://tracker.firebirdsql.org/browse/CORE-6440
http://tracker.firebirdsql.org/browse/CORE-6444
http://tracker.firebirdsql.org/browse/CORE-6460
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/derived_tables/test_06.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/derived_tables/test_21.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_full_join_02.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/string/test_ascii_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/string/test_left_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_dbp_1940_20110725_1159.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_join_transformation_008.py
https://github.com/FirebirdSQL/firebird/issues/7046
https://github.com/FirebirdSQL/firebird/issues/7993
https://github.com/FirebirdSQL/firebird/issues/7995
https://github.com/FirebirdSQL/firebird/issues/8066
https://github.com/FirebirdSQL/firebird/issues/8077
https://github.com/FirebirdSQL/firebird/issues/8722
=== end of list ===

Last commits information (all timestamps in UTC):