| NN | Test name | mode | Test last update | Moving medians chart |
6.0.0.1366
|
6.0.0.1365
|
6.0.0.1364
|
6.0.0.1363
|
6.0.0.1361
|
6.0.0.1360
|
6.0.0.1358
|
6.0.0.1357
|
6.0.0.1356
|
6.0.0.1355
|
6.0.0.1354
|
6.0.0.1352
|
6.0.0.1351
|
6.0.0.1346
|
6.0.0.1342
|
6.0.0.1338
|
6.0.0.1337
|
6.0.0.1336
|
6.0.0.1335
|
6.0.0.1334
|
6.0.0.1330
|
6.0.0.1315
|
6.0.0.1313
|
6.0.0.1312
|
6.0.0.1311
|
6.0.0.1309
|
6.0.0.1306
|
6.0.0.1305
|
6.0.0.1304
|
6.0.0.1301
|
6.0.0.1300
|
Test TITLE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | CS | 2022.02.02 14:46 | 1447 | 851 | 1447 | 990 | 990 | 1536 | 1536 | 990 | 893 | 893 | 893 | 985 | 985 | 985 | 985 | 914 | 914 | 914 | 892 | 892 | 902 | 902 | 1212 | 1409 | 1409 | 1366 | 1212 | 1006 | 1006 | 856 | 1006 | Incorrect VIEW expansion when RDB$DB_KEY is used in view body |
||
| 2 | CS | 2022.02.02 14:46 | 1388 | 832 | 1275 | 971 | 971 | 1267 | 1267 | 971 | 917 | 917 | 917 | 943 | 943 | 943 | 940 | 883 | 883 | 883 | 880 | 880 | 956 | 1377 | 1377 | 1456 | 1434 | 1377 | 1213 | 912 | 863 | 863 | 912 | Parts of RDB$DB_KEY of views may be inverted when using outer joins |
||
| 3 | CS | 2023.12.15 21:42 | 2240 | 1409 | 1755 | 1507 | 1507 | 1611 | 1611 | 1565 | 1587 | 1587 | 1587 | 1587 | 1748 | 1748 | 1665 | 1650 | 1650 | 1545 | 1545 | 1545 | 1646 | 2188 | 2188 | 2314 | 2192 | 2192 | 2116 | 1549 | 1478 | 1478 | 1478 | Suboptimal join plan if there are selective non-indexed predicates involved |
||
| 4 | CS | 2025.07.26 14:08 | 1313 | 806 | 882 | 867 | 867 | 882 | 882 | 867 | 857 | 857 | 857 | 857 | 888 | 925 | 891 | 891 | 891 | 891 | 888 | 888 | 888 | 1391 | 1391 | 1391 | 1391 | 1136 | 848 | 836 | 821 | 821 | 836 | Query plan is missing for the long query |
||
| 5 | CS | 2022.02.02 14:46 | 1360 | 843 | 853 | 853 | 853 | 917 | 917 | 917 | 896 | 896 | 896 | 896 | 896 | 992 | 880 | 859 | 859 | 929 | 929 | 961 | 978 | 1366 | 1366 | 1371 | 1366 | 1233 | 938 | 927 | 927 | 921 | 921 | Incorrect ROW_COUNT value with indexed retrieval and subquery |
||
| 6 | CS | 2025.06.26 13:36 | 1146 | 678 | 799 | 796 | 796 | 799 | 837 | 837 | 837 | 837 | 837 | 807 | 1077 | 1077 | 807 | 764 | 764 | 733 | 764 | 853 | 873 | 1124 | 1124 | 1124 | 1077 | 736 | 676 | 675 | 675 | 676 | 812 | Indexed retrieval cannot be chosen if a stored procedure is used inside the comparison predicate |
||
| 7 | CS | 2022.02.02 14:46 | 1210 | 715 | 715 | 692 | 692 | 750 | 770 | 774 | 774 | 774 | 781 | 781 | 754 | 715 | 707 | 704 | 704 | 694 | 694 | 724 | 824 | 724 | 961 | 961 | 682 | 682 | 685 | 685 | 727 | 729 | 761 | SIMILAR TO predicate hangs with "|" option |
||
| 8 | CS | 2025.09.09 14:35 | 1463 | 876 | 876 | 926 | 926 | 1494 | 1494 | 958 | 958 | 958 | 958 | 958 | 887 | 887 | 887 | 876 | 876 | 866 | 850 | 866 | 854 | 854 | 890 | 890 | 854 | 879 | 833 | 830 | 830 | 879 | 940 | GROUP BY concatenation with empty string |
||
| 9 | CS | 2025.06.27 07:42 | 1077 | 659 | 1128 | 1201 | 1201 | 1201 | 1201 | 1208 | 1175 | 1175 | 1199 | 1208 | 1216 | 1216 | 1199 | 1246 | 1181 | 1181 | 1248 | 1248 | 1221 | 1248 | 1242 | 1221 | 1221 | 1242 | 1209 | 1192 | 1124 | 1039 | 1039 | PK index is not used for derived tables |
||
| 10 | CS | 2025.06.27 08:00 | 1139 | 673 | 1139 | 1052 | 1052 | 1333 | 1333 | 1209 | 1209 | 1200 | 1200 | 1209 | 1227 | 1227 | 1227 | 1227 | 1262 | 1233 | 1320 | 1320 | 1397 | 1259 | 1259 | 1190 | 1259 | 1234 | 1190 | 1234 | 1234 | 1161 | 1059 | Exception when upper casing string with 'ΓΏ' (lowercase y trema, code 0xFF in ISO8859_1) |
||
| 11 | CS | 2022.02.02 14:46 | 1147 | 703 | 1189 | 1060 | 1060 | 1166 | 1166 | 1138 | 1138 | 1138 | 1138 | 1138 | 1169 | 1169 | 1140 | 1140 | 1169 | 1150 | 1196 | 1224 | 1253 | 1224 | 1224 | 1182 | 1089 | 1089 | 969 | 969 | 1088 | 1088 | 927 | COLLATE expressions are applied incorrectly |
||
| 12 | CS | 2025.07.03 15:26 | 1109 | 669 | 1109 | 1030 | 1030 | 1185 | 1185 | 1185 | 1197 | 1207 | 1197 | 1197 | 1207 | 1152 | 1152 | 1214 | 1216 | 1216 | 1216 | 1243 | 1247 | 1243 | 1190 | 1190 | 1070 | 1070 | 973 | 973 | 1154 | 1154 | 987 | Broken error handling in the case of a conversion error happened during index creation |
||
| 13 | CS | 2022.02.02 14:46 | 1141 | 698 | 698 | 698 | 715 | 784 | 854 | 1160 | 1160 | 1160 | 854 | 994 | 994 | 994 | 1107 | 1107 | 1107 | 811 | 734 | 731 | 734 | 734 | 734 | 1075 | 1139 | 1075 | 1139 | 1139 | 697 | 697 | 746 | Incorrect size of the output parameter/argument when execute block, procedure or function use system field in metadata charset |
||
| 14 | CS | 2022.02.02 14:46 | 1124 | 710 | 710 | 710 | 834 | 841 | 893 | 1244 | 1244 | 1244 | 893 | 719 | 719 | 719 | 1196 | 1196 | 1196 | 697 | 697 | 661 | 661 | 698 | 734 | 1044 | 1075 | 1075 | 1138 | 1075 | 682 | 682 | 765 | BIN_SHL and BIN_SHR does not work in Dialect 1 |
||
| 15 | CS | 2023.12.13 17:04 | 1108 | 674 | 674 | 674 | 791 | 1000 | 1000 | 1177 | 1241 | 1177 | 1064 | 1177 | 1064 | 1064 | 732 | 1224 | 1224 | 1224 | 1188 | 1188 | 1175 | 1175 | 1099 | 1021 | 1065 | 1099 | 1065 | 1065 | 1065 | 676 | 676 | SubType information is lost when calculating arithmetic expressions |
||
| 16 | CS | 2022.02.02 14:46 | 1199 | 656 | 773 | 773 | 773 | 1200 | 1200 | 1215 | 1317 | 1244 | 1244 | 1244 | 1244 | 1244 | 1229 | 1229 | 1254 | 1168 | 1168 | 1168 | 1135 | 1135 | 1166 | 1100 | 1166 | 1189 | 1224 | 1189 | 1189 | 1082 | 1014 | Server crashes on overflow of division result |
||
| 17 | CS | 2022.02.02 14:46 | 1185 | 705 | 685 | 685 | 705 | 711 | 719 | 1240 | 1197 | 1197 | 1197 | 1197 | 1197 | 1223 | 1234 | 1268 | 1268 | 1223 | 1180 | 886 | 886 | 1135 | 697 | 1124 | 1124 | 1066 | 1066 | 1066 | 706 | 706 | 761 | ROUND() does not allow second argument >=1 when its first argument is more than MAX_BIGINT / 10 |
||
| 18 | CS | 2023.12.13 17:10 | 1193 | 734 | 734 | 734 | 753 | 758 | 949 | 1256 | 1178 | 1178 | 1178 | 1178 | 1178 | 1210 | 1277 | 1349 | 1349 | 1277 | 817 | 753 | 753 | 817 | 731 | 1015 | 1015 | 829 | 829 | 829 | 768 | 768 | 816 | LEAD() and LAG() do not allow to specify 3rd argument ("DEFAULT" value when pointer is out of scope) of INT128 datatype. |
||
| 19 | CS | 2025.07.25 08:47 | 1403 | 856 | 780 | 856 | 856 | 1100 | 1100 | 1100 | 921 | 865 | 810 | 865 | 790 | 790 | 795 | 1290 | 859 | 859 | 795 | 800 | 800 | 800 | 826 | 826 | 855 | 826 | 818 | 818 | 844 | 844 | 902 | Optimizer fails applying stream-local predicates before merging [CORE2832] |
||
| 20 | CS | 2022.02.02 14:46 | 1255 | 750 | 750 | 776 | 776 | 776 | 776 | 758 | 718 | 680 | 680 | 681 | 681 | 707 | 707 | 707 | 707 | 721 | 705 | 704 | 721 | 696 | 696 | 696 | 965 | 786 | 884 | 786 | 884 | 786 | 884 | recreate table T with PK or UK is impossible after duplicate typing w/o commit when ISQL is launched in AUTODDL=OFF mode |
||
| 21 | CS | 2025.07.26 09:53 | 1494 | 822 | 822 | 843 | 843 | 855 | 958 | 958 | 958 | 902 | 902 | 884 | 902 | 1022 | 1022 | 906 | 1022 | 911 | 906 | 862 | 911 | 862 | 862 | 826 | 824 | 824 | 853 | 780 | 853 | 864 | 985 | subselect losing the index when where clause includes coalesce() [CORE4640] |
||
| 22 | CS | 2024.11.09 12:49 | 1199 | 696 | 737 | 737 | 737 | 724 | 724 | 724 | 719 | 646 | 646 | 646 | 646 | 686 | 705 | 686 | 705 | 686 | 716 | 685 | 736 | 685 | 736 | 626 | 877 | 649 | 1064 | 649 | 1209 | 735 | 975 | Non US-ASCII field names treated as unicode, although charset non-unicode, lowering max field length [CORE5258] |
||
| 23 | CS | 2025.06.24 06:05 | 1140 | 689 | 677 | 807 | 807 | 778 | 807 | 807 | 778 | 778 | 728 | 712 | 728 | 725 | 725 | 725 | 745 | 725 | 717 | 717 | 749 | 720 | 749 | 749 | 1180 | 814 | 1180 | 814 | 1124 | 814 | 941 | Token unknown error on formfeed in query [CORE5479] |
||
| 24 | CS | 2023.05.12 17:50 | 1170 | 702 | 812 | 812 | 812 | 767 | 812 | 805 | 805 | 779 | 779 | 722 | 722 | 722 | 722 | 722 | 735 | 708 | 727 | 709 | 727 | 709 | 727 | 709 | 991 | 723 | 1122 | 723 | 1153 | 762 | 999 | Add support for QUARTER to EXTRACT, FIRST_DAY and LAST_DAY [CORE5693] |
||
| 25 | CS | 2022.02.02 14:46 | 1164 | 723 | 789 | 723 | 789 | 789 | 789 | 747 | 747 | 747 | 712 | 728 | 728 | 736 | 736 | 751 | 751 | 820 | 820 | 820 | 762 | 1144 | 1144 | 1144 | 762 | 729 | 696 | 696 | 729 | 762 | 1045 | Support for WHEN NOT MATCHED BY SOURCE for MERGE statement |
||
| 26 | CS | 2025.07.04 20:24 | 1136 | 712 | 796 | 796 | 796 | 796 | 837 | 857 | 857 | 837 | 778 | 778 | 735 | 735 | 1321 | 1321 | 1321 | 1321 | 733 | 733 | 733 | 728 | 733 | 728 | 728 | 768 | 806 | 768 | 806 | 806 | 858 | Creation of expression index does not release its statement correctly |
||
| 27 | CS | 2024.01.21 07:31 | 1285 | 756 | 843 | 843 | 843 | 843 | 949 | 949 | 949 | 898 | 898 | 898 | 930 | 1006 | 1006 | 930 | 930 | 883 | 823 | 883 | 1273 | 1273 | 1376 | 1376 | 1376 | 1394 | 1394 | 908 | 869 | 869 | 869 | Allow DEFAULT keyword in argument list |
||
| 28 | CS | 2025.07.05 17:16 | 1103 | 666 | 688 | 688 | 688 | 688 | 760 | 770 | 811 | 770 | 811 | 811 | 811 | 1180 | 1180 | 823 | 823 | 823 | 699 | 699 | 1143 | 1143 | 1143 | 1143 | 1127 | 1127 | 1094 | 1094 | 757 | 757 | 757 | Equivalence of boolean condition in partial index |
||
| 29 | CS | 2023.05.12 18:01 | 1545 | 939 | 988 | 1181 | 1181 | 1181 | 1297 | 1297 | 1297 | 1022 | 1022 | 1022 | 1049 | 1614 | 1614 | 1049 | 1049 | 1002 | 1002 | 1046 | 1581 | 1046 | 1046 | 1619 | 1421 | 1108 | 1108 | 1108 | 994 | 994 | 994 | Allow nested parenthesized joined table |
||
| 30 | CS | 2024.01.12 15:08 | 1206 | 704 | 803 | 803 | 803 | 803 | 925 | 925 | 925 | 782 | 782 | 782 | 782 | 1262 | 1262 | 740 | 740 | 738 | 736 | 738 | 1135 | 736 | 720 | 1135 | 1135 | 803 | 803 | 803 | 803 | 803 | 809 | Named arguments for function call, EXECUTE PROCEDURE and procedure record source |
||
| 31 | CS | 2023.05.24 17:29 | 1086 | 628 | 746 | 746 | 746 | 746 | 812 | 812 | 812 | 812 | 812 | 812 | 812 | 1242 | 1242 | 718 | 718 | 1068 | 694 | 1068 | 1130 | 1068 | 664 | 997 | 997 | 997 | 997 | 997 | 758 | 757 | 757 | RELEASE SAVEPOINT ONLY works incorrectly |
||
| 32 | CS | 2023.06.03 07:32 | 1127 | 707 | 707 | 675 | 675 | 675 | 711 | 732 | 732 | 722 | 732 | 732 | 848 | 861 | 861 | 848 | 848 | 747 | 722 | 747 | 1118 | 747 | 673 | 1118 | 1118 | 697 | 697 | 697 | 683 | 683 | 683 | Conversion of text with '#x00' to DECFLOAT without errors. |
||
| 33 | CS | 2025.07.05 17:51 | 3402 | 2034 | 2206 | 2206 | 2206 | 2206 | 2432 | 2432 | 2432 | 2196 | 2196 | 2196 | 2332 | 2702 | 2702 | 2332 | 2332 | 2202 | 2113 | 2202 | 3311 | 2047 | 2047 | 3311 | 3311 | 2453 | 2453 | 2453 | 2192 | 2192 | 2192 | Uninitialized/random value assigned to RDB$ROLES -> RDB$SYSTEM PRIVILEGES when restoring from FB3 backup |
||
| 34 | CS | 2023.06.04 06:02 | 1454 | 822 | 879 | 1009 | 1009 | 958 | 1009 | 1009 | 958 | 871 | 871 | 871 | 879 | 990 | 990 | 879 | 990 | 871 | 847 | 871 | 1384 | 847 | 844 | 1379 | 1310 | 874 | 1007 | 1007 | 874 | 874 | 973 | Can't backup/restore database from v3 to v4 with SEC$USER_NAME field longer than 10 characters. |
||
| 35 | CS | 2023.06.26 19:57 | 1094 | 658 | 668 | 733 | 733 | 733 | 812 | 812 | 812 | 799 | 799 | 785 | 784 | 784 | 680 | 680 | 680 | 1143 | 1143 | 1143 | 1121 | 1109 | 672 | 1091 | 1075 | 663 | 663 | 743 | 743 | 697 | 743 | Getting the current DECFLOAT ROUND/TRAPS settings |
||
| 36 | CS | 2023.07.18 21:00 | 1192 | 686 | 1192 | 1192 | 1198 | 725 | 1198 | 768 | 768 | 747 | 768 | 747 | 747 | 706 | 792 | 792 | 796 | 792 | 1125 | 1213 | 1250 | 1213 | 1213 | 1126 | 1126 | 740 | 740 | 740 | 740 | 725 | 725 | Unable to find savepoint in insert with nested query and returning clause in FB4 |
||
| 37 | CS | 2025.07.05 19:04 | 1424 | 846 | 907 | 907 | 907 | 907 | 1294 | 1294 | 1294 | 1251 | 1251 | 1132 | 1030 | 1030 | 960 | 960 | 1010 | 941 | 930 | 1010 | 1393 | 930 | 855 | 1393 | 1393 | 1028 | 1028 | 1028 | 958 | 958 | 958 | EXPLAIN statement and RDB$SQL package |
||
| 38 | CS | 2025.07.05 19:06 | 1104 | 688 | 688 | 761 | 761 | 761 | 839 | 839 | 839 | 747 | 747 | 697 | 697 | 747 | 776 | 762 | 776 | 776 | 762 | 762 | 1085 | 637 | 668 | 1073 | 1073 | 713 | 802 | 802 | 771 | 769 | 771 | Invalid message when violating unique constraint ("Attempt to evaluate index expression recursively") |
||
| 39 | CS | 2023.07.31 06:51 | 1107 | 648 | 686 | 808 | 808 | 756 | 808 | 808 | 756 | 754 | 754 | 718 | 733 | 731 | 731 | 731 | 733 | 731 | 659 | 796 | 1166 | 653 | 646 | 1067 | 1067 | 701 | 701 | 701 | 701 | 701 | 722 | rdb$time_zone_util.transitions returns an infinite resultset |
||
| 40 | CS | 2023.08.17 13:20 | 1198 | 683 | 838 | 838 | 838 | 838 | 857 | 857 | 857 | 745 | 745 | 745 | 831 | 831 | 1182 | 831 | 831 | 746 | 734 | 734 | 734 | 734 | 741 | 748 | 748 | 826 | 826 | 826 | 797 | 782 | 782 | Expression index - more than one null value cause attempt to store duplicate value error |
||
| 41 | CS | 2023.08.25 18:25 | 1270 | 783 | 839 | 839 | 839 | 827 | 839 | 827 | 827 | 799 | 799 | 799 | 799 | 826 | 1231 | 1252 | 1252 | 1252 | 1252 | 1252 | 876 | 740 | 783 | 783 | 783 | 840 | 840 | 840 | 827 | 827 | 827 | Stability of implicit cursor could be broken, if cursor's select expression is based on view with sub-query in select list, or on table with sub-query in computed field. |
||
| 42 | CS | 2023.10.02 12:48 | 1413 | 791 | 802 | 802 | 802 | 802 | 854 | 854 | 907 | 854 | 907 | 907 | 907 | 847 | 1508 | 1508 | 1520 | 1520 | 1520 | 1476 | 860 | 843 | 802 | 802 | 794 | 794 | 834 | 834 | 834 | 848 | 862 | Alternative String Literals and multibyte (UTF8) alternatives |
||
| 43 | CS | 2023.08.29 11:08 | 1043 | 604 | 732 | 732 | 637 | 637 | 653 | 653 | 657 | 657 | 1047 | 1057 | 1057 | 720 | 1057 | 720 | 720 | 720 | 715 | 715 | 609 | 558 | 609 | 671 | 671 | 671 | 671 | 629 | 629 | 629 | 654 | Wrong error message on login if the user doesn't exists and WireCrypt is disabled |
||
| 44 | CS | 2025.07.05 19:14 | 1175 | 735 | 820 | 820 | 775 | 775 | 810 | 775 | 810 | 810 | 1075 | 1075 | 1075 | 719 | 1075 | 814 | 814 | 814 | 814 | 814 | 700 | 682 | 700 | 787 | 787 | 787 | 787 | 717 | 717 | 717 | 749 | Index for integer column cannot be used when INT128/DECFLOAT value is being searched |
||
| 45 | CS | 2025.07.05 19:18 | 4985 | 3006 | 3183 | 4302 | 3183 | 3183 | 3412 | 3412 | 3074 | 2984 | 2984 | 2984 | 2994 | 2994 | 3058 | 2994 | 3058 | 2953 | 2953 | 2953 | 2954 | 2954 | 3516 | 4332 | 3516 | 3516 | 3181 | 3181 | 3181 | 3345 | 3450 | Provide ability to run "ALTER SQL SECURITY DEFINER / INVOKER" without specifying further part of proc/func/package |
||
| 46 | CS | 2024.02.17 06:43 | 1864 | 1083 | 1083 | 1323 | 1250 | 1250 | 1288 | 1288 | 1250 | 1167 | 1167 | 1160 | 1167 | 1225 | 1241 | 1225 | 1241 | 1241 | 1335 | 1335 | 1335 | 1335 | 1976 | 1984 | 1976 | 1976 | 1155 | 1155 | 1155 | 1288 | 1338 | garbage collection in indexes and blobs is not performed in VIO_backout |
||
| 47 | CS | 2024.10.22 17:29 | 1078 | 663 | 726 | 815 | 815 | 815 | 821 | 821 | 821 | 830 | 873 | 740 | 687 | 776 | 776 | 687 | 776 | 776 | 760 | 760 | 760 | 760 | 1182 | 1182 | 1076 | 1076 | 710 | 679 | 679 | 710 | 720 | Allow collation to be a part of data type |
||
| 48 | CS | 2025.07.05 19:26 | 1896 | 1165 | 1165 | 1248 | 1248 | 1248 | 1313 | 1313 | 1313 | 1190 | 1190 | 1137 | 1190 | 1200 | 1538 | 1258 | 1538 | 1258 | 1258 | 1258 | 1127 | 1127 | 1481 | 1807 | 1481 | 1481 | 1200 | 1154 | 1154 | 1200 | 1436 | Fix character set and collation output |
||
| 49 | SS | 2023.10.09 14:20 | 832 | 462 | 832 | 845 | 845 | 845 | 845 | 878 | 888 | 888 | 873 | 932 | 929 | 873 | 892 | 892 | 848 | 815 | 800 | 800 | 509 | 450 | 450 | 801 | 472 | 723 | 723 | 528 | 528 | 609 | 609 | Added the ability to change function DETERMINISTIC option without recompile the entire function body |
||
| 50 | CS | 2025.10.21 12:28 | 3006 | 1864 | 1864 | 2017 | 2017 | 2029 | 2060 | 2060 | 2060 | 2060 | 2060 | 2015 | 2206 | 3171 | 3171 | 2206 | 2206 | 2090 | 2059 | X | X | X | X | X | X | X | X | X | X | X | X | Support bitwise aggregate functions (BIN_AND_AGG, BIN_OR_AGG, BIN_XOR_AGG) |
| NN | Test name | mode |
6.0.0.1366
|
6.0.0.1365
|
6.0.0.1364
|
6.0.0.1363
|
6.0.0.1361
|
6.0.0.1360
|
6.0.0.1358
|
6.0.0.1357
|
6.0.0.1356
|
6.0.0.1355
|
6.0.0.1354
|
6.0.0.1352
|
6.0.0.1351
|
6.0.0.1346
|
6.0.0.1342
|
6.0.0.1338
|
6.0.0.1337
|
6.0.0.1336
|
6.0.0.1335
|
6.0.0.1334
|
6.0.0.1330
|
6.0.0.1315
|
6.0.0.1313
|
6.0.0.1312
|
6.0.0.1311
|
6.0.0.1309
|
6.0.0.1306
|
6.0.0.1305
|
6.0.0.1304
|
6.0.0.1301
|
6.0.0.1300
|
6.0.0.1299
|
6.0.0.1295
|
6.0.0.1293
|
6.0.0.1292
|
Test TITLE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | CS | 1450 | 831 | 1555 | 1447 | 851 | 842 | 1760 | 990 | 1536 | 1562 | 835 | 893 | 879 | 1339 | 1527 | 985 | 878 | 914 | 1387 | 860 | 934 | 892 | 795 | 902 | 1409 | 1480 | 1212 | 1624 | 1366 | 851 | 1006 | 856 | 1317 | 848 | 1312 | Incorrect VIEW expansion when RDB$DB_KEY is used in view body |
|
| 2 | CS | 1571 | 810 | 1393 | 1388 | 832 | 807 | 1275 | 971 | 1703 | 1267 | 917 | 869 | 829 | 1467 | 1409 | 943 | 871 | 940 | 883 | 835 | 956 | 841 | 880 | 1521 | 1456 | 1377 | 1213 | 1516 | 1434 | 863 | 793 | 912 | 849 | 940 | 1245 | Parts of RDB$DB_KEY of views may be inverted when using outer joins |
|
| 3 | CS | 2768 | 1361 | 2595 | 2240 | 1346 | 1409 | 1755 | 1507 | 2611 | 1611 | 1552 | 1565 | 1587 | 2268 | 1957 | 1579 | 1748 | 1665 | 1650 | 1545 | 1470 | 1374 | 1646 | 2646 | 2188 | 2314 | 2116 | 2883 | 2192 | 1549 | 1341 | 1335 | 1478 | 1756 | 2503 | Suboptimal join plan if there are selective non-indexed predicates involved |
|
| 4 | CS | 1313 | 759 | 1339 | 1332 | 743 | 806 | 882 | 867 | 1266 | 948 | 857 | 846 | 857 | 1388 | 1413 | 831 | 888 | 925 | 891 | 931 | 888 | 816 | 803 | 1570 | 1391 | 1394 | 1136 | 1391 | 848 | 821 | 769 | 836 | 771 | 901 | 1113 | Query plan is missing for the long query |
|
| 5 | CS | 1503 | 839 | 1405 | 1360 | 804 | 843 | 853 | 917 | 1442 | 1051 | 804 | 853 | 896 | 1592 | 1198 | 880 | 857 | 992 | 859 | 838 | 929 | 961 | 978 | 1371 | 1394 | 1366 | 1233 | 1405 | 927 | 938 | 807 | 821 | 1407 | 921 | 1201 | Incorrect ROW_COUNT value with indexed retrieval and subquery |
|
| 6 | CS | 1196 | 612 | 1146 | 1286 | 678 | 644 | 799 | 796 | 1332 | 857 | 837 | 795 | 720 | 1289 | 1210 | 807 | 1077 | 733 | 764 | 712 | 873 | 692 | 853 | 1196 | 1124 | 1139 | 1077 | 736 | 675 | 676 | 675 | 666 | 1073 | 812 | 978 | Indexed retrieval cannot be chosen if a stored procedure is used inside the comparison predicate |
|
| 7 | CS | 1241 | 1240 | 715 | 1210 | 601 | 636 | 770 | 692 | 1212 | 750 | 774 | 781 | 754 | 1202 | 973 | 707 | 715 | 704 | 667 | 694 | 824 | 616 | 724 | 1332 | 1196 | 612 | 961 | 614 | 682 | 729 | 685 | 727 | 1029 | 761 | 1009 | SIMILAR TO predicate hangs with "|" option |
|
| 8 | CS | 1463 | 1487 | 870 | 1476 | 876 | 837 | 1650 | 926 | 1494 | 1680 | 846 | 958 | 883 | 1437 | 1275 | 847 | 887 | 887 | 850 | 876 | 866 | 781 | 777 | 1492 | 854 | 890 | 1166 | 833 | 828 | 879 | 830 | 800 | 1353 | 940 | 1240 | GROUP BY concatenation with empty string |
|
| 9 | CS | 1077 | 648 | 1128 | 1287 | 627 | 659 | 1201 | 1213 | 1300 | 1175 | 975 | 1208 | 706 | 1216 | 1199 | 1246 | 1293 | 1076 | 1181 | 1265 | 1153 | 1284 | 1248 | 707 | 1221 | 1307 | 1242 | 1209 | 1192 | 1297 | 1037 | 1124 | 1039 | 767 | 1077 | PK index is not used for derived tables |
|
| 10 | CS | 1277 | 659 | 1139 | 1173 | 652 | 673 | 1430 | 1052 | 1333 | 1397 | 1127 | 1209 | 695 | 1200 | 1258 | 1227 | 1262 | 1104 | 1172 | 1320 | 1419 | 1233 | 1397 | 718 | 1428 | 1259 | 1190 | 1163 | 1311 | 1234 | 1059 | 1376 | 1161 | 749 | 1032 | Exception when upper casing string with 'ΓΏ' (lowercase y trema, code 0xFF in ISO8859_1) |
|
| 11 | CS | 1147 | 638 | 1232 | 1189 | 703 | 603 | 1246 | 1060 | 1166 | 1316 | 1006 | 1138 | 1054 | 1210 | 1300 | 745 | 1169 | 1140 | 970 | 1196 | 1262 | 1150 | 1224 | 1260 | 1253 | 1089 | 1182 | 931 | 969 | 1188 | 883 | 1217 | 1088 | 742 | 927 | COLLATE expressions are applied incorrectly |
|
| 12 | CS | 1184 | 642 | 1109 | 1266 | 669 | 656 | 1262 | 1030 | 1185 | 1509 | 693 | 1197 | 1296 | 1207 | 1152 | 716 | 1270 | 1019 | 1214 | 1216 | 1316 | 1243 | 1142 | 1251 | 1247 | 1190 | 1070 | 631 | 973 | 1169 | 950 | 1257 | 1154 | 748 | 987 | Broken error handling in the case of a conversion error happened during index creation |
|
| 13 | CS | 1152 | 1184 | 1141 | 686 | 589 | 698 | 715 | 1294 | 784 | 1496 | 854 | 1160 | 1301 | 679 | 677 | 994 | 1322 | 1177 | 1107 | 731 | 660 | 811 | 734 | 684 | 1147 | 703 | 1075 | 1139 | 1256 | 697 | 1395 | 656 | 646 | 746 | 1042 | Incorrect size of the output parameter/argument when execute block, procedure or function use system field in metadata charset |
|
| 14 | CS | 1124 | 1212 | 1263 | 686 | 598 | 710 | 834 | 1293 | 841 | 1313 | 893 | 1244 | 1297 | 657 | 704 | 719 | 1199 | 1196 | 1259 | 697 | 661 | 625 | 698 | 610 | 1044 | 734 | 1209 | 1138 | 1075 | 682 | 1246 | 632 | 619 | 765 | 1031 | BIN_SHL and BIN_SHR does not work in Dialect 1 |
|
| 15 | CS | 1218 | 1202 | 1108 | 674 | 588 | 662 | 791 | 1000 | 1359 | 1241 | 674 | 1177 | 1257 | 1064 | 732 | 1366 | 676 | 1317 | 665 | 1224 | 1456 | 1188 | 1175 | 674 | 711 | 1224 | 1099 | 1021 | 1065 | 1253 | 676 | 1103 | 623 | 674 | 973 | SubType information is lost when calculating arithmetic expressions |
|
| 16 | CS | 1199 | 656 | 1285 | 1208 | 652 | 653 | 773 | 1200 | 1392 | 1215 | 663 | 1317 | 1380 | 1244 | 765 | 1229 | 1254 | 1270 | 657 | 1168 | 1268 | 1135 | 1168 | 810 | 704 | 1166 | 1290 | 1100 | 1189 | 1224 | 1276 | 1082 | 604 | 733 | 1014 | Server crashes on overflow of division result |
|
| 17 | CS | 1207 | 1185 | 1241 | 656 | 685 | 705 | 661 | 1360 | 711 | 719 | 1250 | 1240 | 1197 | 706 | 694 | 1234 | 1268 | 1223 | 1287 | 1341 | 886 | 1180 | 656 | 697 | 1135 | 1139 | 687 | 1124 | 1066 | 654 | 1362 | 706 | 698 | 761 | 979 | ROUND() does not allow second argument >=1 when its first argument is more than MAX_BIGINT / 10 |
|
| 18 | CS | 1238 | 1240 | 1193 | 664 | 734 | 693 | 758 | 1280 | 753 | 949 | 1436 | 1256 | 1178 | 739 | 771 | 1210 | 1494 | 1277 | 1349 | 1432 | 753 | 817 | 647 | 672 | 1184 | 1015 | 731 | 1109 | 829 | 703 | 1197 | 768 | 636 | 816 | 1042 | LEAD() and LAG() do not allow to specify 3rd argument ("DEFAULT" value when pointer is out of scope) of INT128 datatype. |
|
| 19 | CS | 1411 | 1403 | 733 | 1491 | 856 | 780 | 745 | 1611 | 1292 | 1100 | 810 | 921 | 865 | 785 | 774 | 1290 | 790 | 1397 | 795 | 1431 | 859 | 784 | 715 | 800 | 1375 | 826 | 855 | 818 | 1502 | 774 | 766 | 844 | 1305 | 902 | 1155 | Optimizer fails applying stream-local predicates before merging [CORE2832] |
|
| 20 | CS | 1382 | 1255 | 750 | 1271 | 703 | 707 | 776 | 788 | 1383 | 758 | 680 | 718 | 660 | 654 | 681 | 909 | 707 | 1240 | 705 | 704 | 721 | 737 | 691 | 696 | 1212 | 640 | 965 | 690 | 1208 | 786 | 884 | 708 | 1164 | 778 | 1010 | recreate table T with PK or UK is impossible after duplicate typing w/o commit when ISQL is launched in AUTODDL=OFF mode |
|
| 21 | CS | 1541 | 1521 | 822 | 1494 | 816 | 809 | 855 | 843 | 1572 | 992 | 958 | 861 | 821 | 902 | 1482 | 884 | 1022 | 1539 | 906 | 789 | 1732 | 911 | 862 | 826 | 963 | 824 | 1617 | 780 | 732 | 853 | 985 | 767 | 1372 | 864 | 1186 | subselect losing the index when where clause includes coalesce() [CORE4640] |
|
| 22 | CS | 1199 | 651 | 696 | 1245 | 1253 | 677 | 737 | 724 | 1197 | 719 | 620 | 724 | 612 | 646 | 1120 | 645 | 705 | 686 | 716 | 645 | 1145 | 685 | 736 | 594 | 877 | 626 | 1064 | 614 | 1356 | 649 | 1209 | 644 | 1241 | 735 | 975 | Non US-ASCII field names treated as unicode, although charset non-unicode, lowering max field length [CORE5258] |
|
| 23 | CS | 1150 | 689 | 655 | 1199 | 1140 | 632 | 677 | 807 | 1092 | 778 | 1225 | 710 | 728 | 823 | 670 | 712 | 745 | 725 | 785 | 676 | 1197 | 672 | 717 | 749 | 1285 | 720 | 1180 | 674 | 1196 | 814 | 1196 | 729 | 1124 | 726 | 941 | Token unknown error on formfeed in query [CORE5479] |
|
| 24 | CS | 1270 | 702 | 690 | 1448 | 1170 | 661 | 812 | 688 | 1292 | 767 | 1363 | 805 | 718 | 779 | 678 | 722 | 774 | 708 | 735 | 680 | 1357 | 698 | 727 | 709 | 991 | 665 | 1122 | 678 | 1297 | 723 | 1310 | 677 | 1153 | 762 | 999 | Add support for QUARTER to EXTRACT, FIRST_DAY and LAST_DAY [CORE5693] |
|
| 25 | CS | 1186 | 677 | 1164 | 675 | 1279 | 723 | 789 | 708 | 827 | 1299 | 655 | 747 | 711 | 1260 | 712 | 728 | 751 | 736 | 862 | 820 | 702 | 1287 | 680 | 1390 | 762 | 1144 | 1908 | 668 | 696 | 729 | 688 | 1275 | 1182 | 762 | 1045 | Support for WHEN NOT MATCHED BY SOURCE for MERGE statement |
|
| 26 | CS | 1324 | 671 | 712 | 1199 | 1136 | 704 | 796 | 658 | 1408 | 837 | 1301 | 857 | 778 | 735 | 684 | 1408 | 710 | 1337 | 1321 | 689 | 1340 | 708 | 733 | 1211 | 644 | 728 | 1232 | 687 | 1227 | 768 | 806 | 711 | 1175 | 858 | 1118 | Creation of expression index does not release its statement correctly |
|
| 27 | CS | 1285 | 752 | 754 | 1479 | 1466 | 756 | 843 | 821 | 1676 | 949 | 1301 | 802 | 898 | 733 | 1006 | 1458 | 930 | 1401 | 823 | 800 | 1699 | 883 | 772 | 1451 | 1273 | 1376 | 1394 | 908 | 1464 | 1560 | 754 | 793 | 869 | 915 | 1245 | Allow DEFAULT keyword in argument list |
|
| 28 | CS | 1103 | 666 | 648 | 1290 | 1126 | 660 | 688 | 661 | 1360 | 760 | 1241 | 770 | 811 | 641 | 1301 | 1233 | 745 | 1180 | 823 | 696 | 1309 | 699 | 649 | 1143 | 1156 | 1200 | 729 | 1094 | 1127 | 1614 | 652 | 722 | 757 | 787 | 1015 | Equivalence of boolean condition in partial index |
|
| 29 | CS | 1633 | 839 | 938 | 1545 | 1584 | 939 | 988 | 1181 | 1694 | 1297 | 1567 | 1022 | 907 | 930 | 1877 | 1614 | 1049 | 1724 | 1002 | 896 | 1581 | 923 | 1046 | 1698 | 1619 | 1012 | 943 | 1927 | 1421 | 1108 | 994 | 953 | 987 | 1028 | 1369 | Allow nested parenthesized joined table |
|
| 30 | CS | 1225 | 704 | 681 | 1206 | 1324 | 700 | 803 | 680 | 1383 | 925 | 1373 | 748 | 782 | 650 | 1716 | 1262 | 740 | 1314 | 715 | 738 | 1290 | 736 | 720 | 1300 | 1135 | 692 | 672 | 1238 | 1141 | 803 | 694 | 732 | 836 | 809 | 1077 | Named arguments for function call, EXECUTE PROCEDURE and procedure record source |
|
| 31 | CS | 1173 | 602 | 628 | 1152 | 1086 | 602 | 746 | 731 | 1448 | 812 | 1265 | 688 | 635 | 812 | 1348 | 1263 | 718 | 1242 | 626 | 694 | 1323 | 1068 | 653 | 1138 | 1130 | 616 | 664 | 997 | 1056 | 1225 | 711 | 757 | 758 | 735 | 988 | RELEASE SAVEPOINT ONLY works incorrectly |
|
| 32 | CS | 1127 | 682 | 707 | 1237 | 1160 | 590 | 655 | 675 | 1522 | 711 | 1200 | 732 | 722 | 689 | 1410 | 1344 | 848 | 861 | 722 | 703 | 1494 | 747 | 659 | 1148 | 1118 | 647 | 673 | 1244 | 1220 | 697 | 667 | 661 | 683 | 781 | 983 | Conversion of text with '#x00' to DECFLOAT without errors. |
|
| 33 | CS | 4032 | 1963 | 2014 | 3547 | 3402 | 2034 | 2206 | 2121 | 3881 | 2432 | 3552 | 2196 | 2173 | 2015 | 3838 | 2702 | 2332 | 2915 | 2113 | 2202 | 4336 | 2020 | 2047 | 3637 | 3311 | 1953 | 1971 | 4096 | 3597 | 2453 | 2192 | 2137 | 2179 | 2311 | 3119 | Uninitialized/random value assigned to RDB$ROLES -> RDB$SYSTEM PRIVILEGES when restoring from FB3 backup |
|
| 34 | CS | 1469 | 822 | 731 | 1454 | 1478 | 822 | 879 | 1009 | 1413 | 958 | 1473 | 827 | 871 | 785 | 1540 | 879 | 1110 | 990 | 804 | 871 | 1728 | 847 | 844 | 1384 | 1511 | 772 | 818 | 1379 | 1310 | 874 | 1007 | 854 | 730 | 973 | 1054 | Can't backup/restore database from v3 to v4 with SEC$USER_NAME field longer than 10 characters. |
|
| 35 | CS | 1094 | 612 | 595 | 1116 | 1228 | 658 | 668 | 733 | 1554 | 812 | 1145 | 785 | 638 | 799 | 1238 | 784 | 680 | 661 | 647 | 1251 | 1291 | 1143 | 672 | 1121 | 1109 | 602 | 655 | 1091 | 1075 | 663 | 646 | 743 | 778 | 697 | 932 | Getting the current DECFLOAT ROUND/TRAPS settings |
|
| 36 | CS | 1219 | 686 | 657 | 1192 | 1205 | 639 | 1198 | 725 | 1393 | 717 | 1280 | 768 | 747 | 699 | 1251 | 706 | 796 | 694 | 792 | 1125 | 1405 | 682 | 1315 | 1213 | 1250 | 617 | 686 | 1126 | 1235 | 740 | 706 | 683 | 770 | 725 | 938 | Unable to find savepoint in insert with nested query and returning clause in FB4 |
|
| 37 | CS | 1492 | 844 | 846 | 1424 | 1500 | 805 | 907 | 905 | 1619 | 1294 | 1502 | 1251 | 868 | 1132 | 1610 | 960 | 1030 | 941 | 855 | 1010 | 1761 | 930 | 855 | 1419 | 1393 | 829 | 813 | 1490 | 1476 | 1028 | 878 | 910 | 958 | 1016 | 1322 | EXPLAIN statement and RDB$SQL package |
|
| 38 | CS | 1248 | 605 | 652 | 1104 | 1135 | 688 | 667 | 761 | 1548 | 839 | 1176 | 747 | 689 | 697 | 1258 | 687 | 747 | 840 | 776 | 762 | 1664 | 630 | 620 | 1085 | 1332 | 637 | 668 | 1073 | 1211 | 713 | 802 | 742 | 771 | 769 | 911 | Invalid message when violating unique constraint ("Attempt to evaluate index expression recursively") |
|
| 39 | CS | 1157 | 611 | 642 | 1107 | 1161 | 648 | 686 | 808 | 1327 | 756 | 1095 | 718 | 754 | 698 | 1292 | 692 | 733 | 731 | 659 | 796 | 1592 | 653 | 608 | 1255 | 1166 | 624 | 646 | 1067 | 1149 | 701 | 687 | 685 | 789 | 722 | 1100 | rdb$time_zone_util.transitions returns an infinite resultset |
|
| 40 | CS | 1230 | 683 | 639 | 1198 | 1261 | 676 | 838 | 744 | 972 | 857 | 1396 | 714 | 745 | 668 | 1285 | 1194 | 831 | 746 | 1182 | 676 | 1385 | 678 | 734 | 1316 | 635 | 741 | 748 | 1144 | 1206 | 826 | 797 | 720 | 776 | 782 | 1014 | Expression index - more than one null value cause attempt to store duplicate value error |
|
| 41 | CS | 1343 | 665 | 783 | 1270 | 1275 | 701 | 839 | 697 | 843 | 827 | 1321 | 739 | 799 | 672 | 1231 | 1324 | 788 | 826 | 1301 | 1252 | 1502 | 740 | 876 | 1292 | 688 | 698 | 783 | 1124 | 1185 | 840 | 721 | 700 | 827 | 850 | 1144 | Stability of implicit cursor could be broken, if cursor's select expression is based on view with sub-query in select list, or on table with sub-query in computed field. |
|
| 42 | CS | 1413 | 750 | 785 | 1475 | 1510 | 791 | 802 | 756 | 994 | 854 | 1387 | 835 | 907 | 818 | 1700 | 1508 | 847 | 844 | 1520 | 1647 | 1648 | 843 | 860 | 1476 | 802 | 757 | 794 | 1302 | 721 | 834 | 862 | 828 | 848 | 985 | 1220 | Alternative String Literals and multibyte (UTF8) alternatives |
|
| 43 | CS | 1043 | 587 | 594 | 1098 | 1043 | 604 | 732 | 599 | 637 | 653 | 1047 | 657 | 1160 | 600 | 1057 | 1195 | 622 | 720 | 1167 | 715 | 1143 | 558 | 609 | 1237 | 529 | 557 | 671 | 1013 | 909 | 629 | 580 | 568 | 700 | 654 | 953 | Wrong error message on login if the user doesn't exists and WireCrypt is disabled |
|
| 44 | CS | 1422 | 661 | 678 | 1175 | 1179 | 735 | 820 | 699 | 775 | 810 | 1298 | 671 | 1328 | 631 | 1075 | 1226 | 719 | 718 | 1376 | 814 | 1449 | 660 | 682 | 1258 | 700 | 669 | 787 | 1209 | 1235 | 671 | 624 | 717 | 749 | 789 | 1022 | Index for integer column cannot be used when INT128/DECFLOAT value is being searched |
|
| 45 | CS | 5013 | 2664 | 3006 | 4985 | 5424 | 2829 | 3183 | 4302 | 3074 | 3412 | 5195 | 2984 | 2836 | 2890 | 5399 | 2994 | 3058 | 2895 | 4093 | 2875 | 5571 | 2953 | 2750 | 4793 | 2954 | 3516 | 4332 | 4854 | 2635 | 3181 | 2801 | 5141 | 3450 | 3345 | 4859 | Provide ability to run "ALTER SQL SECURITY DEFINER / INVOKER" without specifying further part of proc/func/package |
|
| 46 | CS | 1864 | 993 | 985 | 1888 | 1977 | 1083 | 1035 | 1323 | 1250 | 1288 | 2013 | 1110 | 1160 | 1167 | 1942 | 1111 | 1225 | 1241 | 2240 | 1126 | 2101 | 1036 | 1335 | 2122 | 1072 | 1976 | 2140 | 1984 | 1039 | 1155 | 1146 | 1424 | 1288 | 1338 | 1707 | garbage collection in indexes and blobs is not performed in VIO_backout |
|
| 47 | CS | 1129 | 663 | 638 | 1078 | 1128 | 642 | 726 | 815 | 821 | 830 | 1256 | 740 | 682 | 873 | 1201 | 683 | 687 | 776 | 1492 | 651 | 1294 | 677 | 760 | 1182 | 667 | 1223 | 1206 | 1076 | 679 | 677 | 710 | 670 | 720 | 786 | 1078 | Allow collation to be a part of data type |
|
| 48 | CS | 1896 | 1093 | 1165 | 2006 | 1964 | 1083 | 1137 | 1248 | 1313 | 1370 | 2160 | 1137 | 1190 | 1057 | 1932 | 1047 | 1538 | 1200 | 2252 | 1258 | 2223 | 1127 | 1060 | 2137 | 1064 | 1877 | 1481 | 1807 | 1136 | 1131 | 1200 | 1154 | 1508 | 1436 | 2079 | Fix character set and collation output |
|
| 49 | SS | 843 | 444 | 462 | 832 | 852 | 437 | 845 | 878 | 828 | 888 | 832 | 932 | 1050 | 873 | 648 | 972 | 929 | 848 | 892 | 815 | 509 | 800 | 450 | 864 | 437 | 448 | 855 | 801 | 472 | 723 | 507 | 528 | 680 | 609 | 678 | Added the ability to change function DETERMINISTIC option without recompile the entire function body |
|
| 50 | CS | 4141 | 3195 | 1793 | 3006 | 1756 | 1864 | 2029 | 2017 | 3717 | 2082 | 2060 | 1989 | 1978 | 3544 | 3324 | 2015 | 2206 | 3171 | 3624 | 2059 | 2090 | 1831 | 1923 | X | X | X | X | X | X | X | X | X | X | X | X | Support bitwise aggregate functions (BIN_AND_AGG, BIN_OR_AGG, BIN_XOR_AGG) |