| NN | Test name | mode | Test last update | Moving medians chart |
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
|
6.0.0.1290
|
6.0.0.1286
|
6.0.0.1283
|
6.0.0.1282
|
6.0.0.1280
|
6.0.0.1278
|
Test TITLE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | CS | 2022.02.02 14:46 | 1245 | 692 | 692 | 692 | 1260 | 1266 | 1282 | 1282 | 1265 | 1265 | 1222 | 1083 | 703 | 703 | 703 | 1083 | 998 | 998 | 998 | 998 | 998 | 814 | 1016 | 814 | 1016 | 1008 | 1008 | 745 | 1008 | 802 | 802 | MERGE not correctly worked with parameters in MATCHING clause |
||
| 2 | CS | 2023.10.05 09:23 | 1538 | 956 | 956 | 956 | 1450 | 1557 | 1557 | 1471 | 1471 | 1407 | 1335 | 1335 | 925 | 925 | 1222 | 1377 | 1315 | 1315 | 1315 | 1315 | 1225 | 1043 | 1225 | 1043 | 1225 | 1241 | 1241 | 830 | 1241 | 1088 | 1088 | CREATE OR ALTER VIEW statement |
||
| 3 | CS | 2022.02.02 14:46 | 1447 | 931 | 931 | 931 | 1430 | 1440 | 1440 | 1440 | 1440 | 1355 | 1355 | 1355 | 839 | 839 | 1205 | 839 | 1205 | 1380 | 1380 | 1258 | 1258 | 1142 | 1142 | 1100 | 1142 | 1182 | 1182 | 917 | 1256 | 1002 | 1002 | Error in EXECUTE STATEMENT inside CONNECT / TRANSACTION START triggers |
||
| 4 | CS | 2025.06.25 19:08 | 1275 | 734 | 734 | 734 | 1280 | 1280 | 1280 | 1276 | 1258 | 1225 | 1204 | 1204 | 1168 | 1168 | 1168 | 1144 | 1144 | 1144 | 1144 | 972 | 972 | 969 | 969 | 834 | 969 | 974 | 974 | 725 | 974 | 835 | 835 | Bug in create/alter Database trigger (with Russian comment) |
||
| 5 | CS | 2022.02.02 14:46 | 1009 | 664 | 664 | 664 | 1033 | 1110 | 1152 | 1152 | 1152 | 1152 | 1145 | 1145 | 1145 | 1145 | 1145 | 1144 | 963 | 963 | 1121 | 954 | 943 | 789 | 943 | 789 | 943 | 983 | 983 | 716 | 1023 | 978 | 963 | EVL_expr: invalid operation (232) |
||
| 6 | CS | 2022.02.02 14:46 | 1163 | 745 | 745 | 1163 | 1245 | 1362 | 1370 | 1370 | 1370 | 1351 | 1326 | 1243 | 1167 | 1167 | 1202 | 1202 | 1205 | 1205 | 1202 | 1117 | 1102 | 1102 | 1007 | 1007 | 1031 | 1031 | 1007 | 765 | 1017 | 969 | 765 | Add DROP NOT NULL to ALTER COLUMN |
||
| 7 | CS | 2022.02.02 14:46 | 1388 | 824 | 824 | 824 | 824 | 801 | 801 | 801 | 801 | 801 | 1324 | 1324 | 790 | 790 | 766 | 766 | 790 | 815 | 815 | 844 | 1096 | 1096 | 1096 | 1096 | 1096 | 763 | 763 | 723 | 723 | 802 | 857 | Error "no current record for fetch operation" when sorting by a international string |
||
| 8 | CS | 2022.02.02 14:46 | 1319 | 813 | 813 | 813 | 813 | 763 | 767 | 767 | 767 | 767 | 1200 | 1200 | 814 | 814 | 759 | 759 | 814 | 942 | 942 | 942 | 1072 | 1072 | 1072 | 1072 | 1072 | 719 | 719 | 699 | 699 | 735 | 735 | COMPUTED BY column looses charset and collate of source field <F> when <F> is either of type BLOB or VARCHAR casted to BLOB |
||
| 9 | CS | 2022.02.02 14:46 | 1289 | 749 | 749 | 749 | 749 | 781 | 781 | 781 | 781 | 781 | 1169 | 1169 | 755 | 927 | 755 | 755 | 760 | 927 | 760 | 872 | 1039 | 1039 | 1039 | 1039 | 1039 | 717 | 709 | 709 | 717 | 718 | 718 | Results of concatenation with blob has no info about collation of source columns (which are declared with such info) |
||
| 10 | SS | 2025.07.04 20:27 | 790 | 435 | 456 | 456 | 456 | 495 | 495 | 569 | 495 | 669 | 669 | 669 | 659 | 691 | 659 | 560 | 560 | 697 | 697 | 697 | 697 | 603 | 603 | 543 | 603 | 455 | 455 | 441 | 441 | 433 | 419 | Incorrect indexed lookup of strings when the last keys characters are part of collated contractions and there is multi-segment insensitive descending index |
||
| 11 | CS | 2023.03.01 18:52 | 1172 | 734 | 725 | 725 | 725 | 720 | 725 | 720 | 708 | 720 | 751 | 1085 | 1221 | 1243 | 1221 | 1085 | 817 | 817 | 817 | 817 | 1160 | 1160 | 1096 | 1055 | 1076 | 1075 | 1075 | 844 | 844 | 727 | 718 | Firebird does not find an record when adding a foreign key |
||
| 12 | CS | 2025.07.04 20:30 | 1243 | 722 | 716 | 722 | 735 | 735 | 735 | 735 | 735 | 766 | 833 | 1081 | 1185 | 1185 | 1081 | 969 | 794 | 794 | 794 | 794 | 1015 | 1015 | 1015 | 987 | 1015 | 1016 | 1016 | 854 | 741 | 701 | 685 | Chained JOIN .. USING across the same column names may be optimized badly |
||
| 13 | SS | 2025.07.18 06:01 | 862 | 507 | 525 | 525 | 525 | 525 | 525 | 872 | 530 | 530 | 530 | 573 | 573 | 760 | 760 | 760 | 683 | 683 | 653 | 653 | 683 | 721 | 703 | 703 | 721 | 809 | 703 | 552 | 684 | 552 | 552 | Ignore missing UDR libraries during restore |
||
| 14 | SS | 2023.02.21 09:54 | 1517 | 852 | 852 | 852 | 852 | 863 | 977 | 1491 | 977 | 863 | 977 | 1114 | 1114 | 1436 | 1436 | 1436 | 1294 | 1294 | 1294 | 1294 | 1419 | 1522 | 1499 | 1499 | 1511 | 1499 | 1401 | 1164 | 1331 | 1164 | 1037 | DEFAULTed grants to PUBLIC must act as DEFAULTed to every user |
||
| 15 | SS | 2023.02.27 09:25 | 711 | 447 | 447 | 447 | 447 | 381 | 464 | 531 | 464 | 429 | 464 | 614 | 475 | 627 | 627 | 475 | 475 | 515 | 424 | 501 | 515 | 515 | 573 | 573 | 573 | 522 | 490 | 442 | 490 | 442 | 427 | Wrong error message - "string right truncation. expected length NN, actual NN." |
||
| 16 | SS | 2023.03.03 21:49 | 3695 | 2414 | 2414 | 2414 | 2414 | 2414 | 2423 | 3490 | 2423 | 2394 | 2423 | 3223 | 3223 | 3497 | 3497 | 3223 | 3429 | 3177 | 3177 | 3177 | 3370 | 3370 | 3416 | 3416 | 3542 | 3416 | 3295 | 2829 | 3295 | 2829 | 2638 | Nbackup RDB$BACKUP_HISTORY cleanup |
||
| 17 | CS | 2025.07.05 18:54 | 1233 | 781 | 701 | 701 | 742 | 705 | 742 | 760 | 742 | 761 | 1091 | 761 | 666 | 1062 | 1062 | 824 | 824 | 824 | 789 | 729 | 729 | 789 | 968 | 968 | 974 | 968 | 913 | 905 | 905 | 880 | 854 | Cursor name can duplicate parameter and variable names in procedures and functions |
||
| 18 | CS | 2024.05.27 09:46 | 1096 | 665 | 1096 | 1096 | 667 | 667 | 1210 | 1171 | 1171 | 1171 | 694 | 686 | 686 | 694 | 738 | 738 | 992 | 992 | 731 | 729 | 729 | 729 | 918 | 918 | 918 | 865 | 836 | 823 | 836 | 824 | 824 | Cast dies with numeric value is out of range error |
||
| 19 | CS | 2025.09.24 15:15 | 1069 | 711 | 711 | 711 | 711 | 711 | 725 | 664 | 664 | 725 | 600 | 594 | 594 | 662 | 662 | 1032 | 1032 | 1032 | 662 | 662 | 662 | 662 | 905 | 905 | 905 | X | X | X | X | X | X | Fix issues with longish concatenated context aliases |
||
| 20 | CS | 2025.10.24 12:14 | 1470 | 873 | 873 | 1470 | 1449 | 1449 | 1449 | 1449 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Gstat -table will only report one matching table |
||
| 21 | CS | 2022.02.04 18:05 | 1400 | 871 | 953 | 1522 | 1417 | 953 | 1417 | 1417 | 1166 | 1166 | 1428 | 1407 | 1407 | 1428 | 1407 | 959 | 959 | 1377 | 959 | 989 | 1231 | 1166 | 1166 | 1166 | 1166 | 1124 | 1047 | 1022 | 1047 | 1022 | 1022 | Derived table column names must be unique |
||
| 22 | CS | 2025.07.07 11:06 | 1471 | 903 | 903 | 1471 | 1519 | 963 | 1519 | 1519 | 963 | 859 | 859 | 859 | 859 | 946 | 946 | 911 | 911 | 946 | 922 | 1053 | 1184 | 1167 | 1167 | 1167 | 1167 | 1108 | 1089 | 1052 | 1052 | 1031 | 1031 | Derived table with outer reference from JOIN. |
||
| 23 | SS | 2025.07.16 15:54 | 699 | 463 | 714 | 645 | 469 | 469 | 480 | 480 | 469 | 434 | 428 | 428 | 428 | 656 | 743 | 743 | 747 | 747 | 733 | 554 | 664 | 664 | 688 | 664 | 664 | 688 | 656 | 532 | 632 | 632 | 532 | INNER JOIN join merge |
||
| 24 | SS | 2025.07.16 15:54 | 752 | 483 | 752 | 703 | 547 | 547 | 547 | 547 | 461 | 461 | 461 | 461 | 461 | 577 | 577 | 577 | 590 | 457 | 457 | 535 | 550 | 550 | 592 | 592 | 669 | 680 | 680 | 508 | 696 | 540 | 508 | INNER JOIN join merge and SP |
||
| 25 | SS | 2025.07.16 15:54 | 713 | 466 | 733 | 701 | 504 | 504 | 504 | 504 | 504 | 511 | 511 | 550 | 550 | 770 | 770 | 770 | 478 | 478 | 478 | 493 | 497 | 560 | 626 | 560 | 653 | 657 | 657 | 555 | 608 | 608 | 555 | LEFT OUTER JOIN with distribution CASE |
||
| 26 | SS | 2025.07.16 15:54 | 762 | 441 | 628 | 815 | 815 | 628 | 628 | 503 | 503 | 492 | 457 | 457 | 558 | 760 | 760 | 760 | 440 | 440 | 440 | 519 | 589 | 754 | 696 | 589 | 673 | 696 | 673 | 512 | 673 | 612 | 612 | Best match index selection (single segment) |
||
| 27 | CS | 2025.07.16 15:54 | 1464 | 903 | 873 | 873 | 873 | 903 | 919 | 1431 | 1503 | 1431 | 945 | 945 | 771 | 750 | 750 | 771 | 763 | 763 | 831 | 839 | 911 | 913 | 1032 | 1032 | 1035 | 1032 | 1035 | 969 | 972 | 972 | 993 | Best match index selection (single segment) |
||
| 28 | CS | 2025.07.16 15:54 | 1405 | 869 | 869 | 869 | 961 | 1357 | 1357 | 1459 | 1539 | 1459 | 1025 | 1025 | 817 | 801 | 794 | 801 | 794 | 769 | 794 | 902 | 902 | 929 | 1134 | 1134 | 1134 | 1089 | 1001 | 963 | 963 | 963 | 953 | Best match index selection (single segment) ASC and DESC |
||
| 29 | SS | 2025.09.29 04:30 | 1784 | 1182 | 1159 | 1159 | 1159 | 1092 | 1081 | 1092 | 1092 | 1804 | 1969 | 1969 | 1804 | 1796 | 1751 | 1425 | 1425 | 1425 | 1150 | 1150 | 1558 | 1447 | 1558 | X | X | X | X | X | X | X | X | Support for NOT SINGULAR when subquery refers to another table |
||
| 30 | SS | 2025.09.29 09:58 | 1660 | 1084 | 1067 | 1067 | 1098 | 1098 | 1694 | 1694 | 1499 | 1692 | 1499 | 1499 | 1692 | 1693 | 1693 | 1835 | 1693 | 1754 | 1271 | 1450 | 1450 | 1491 | 1491 | 1591 | X | X | X | X | X | X | X | Support to SINGULAR in nested subqueries |
||
| 31 | SS | 2022.02.04 18:05 | 610 | 360 | 610 | 620 | 649 | 620 | 620 | 597 | 549 | 477 | 549 | 565 | 565 | 565 | 565 | 589 | 562 | 537 | 537 | 523 | 523 | 523 | 545 | 545 | 574 | 574 | 568 | 413 | 413 | 389 | 389 | CAST DATE -> CHAR |
| NN | Test name | mode |
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
|
6.0.0.1290
|
6.0.0.1286
|
6.0.0.1283
|
6.0.0.1282
|
6.0.0.1280
|
6.0.0.1278
|
6.0.0.1277
|
6.0.0.1275
|
6.0.0.1274
|
6.0.0.1273
|
Test TITLE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | CS | 1344 | 1300 | 1245 | 659 | 691 | 692 | 1266 | 1282 | 1260 | 1337 | 1314 | 1222 | 1265 | 650 | 696 | 1083 | 703 | 1098 | 690 | 1287 | 998 | 676 | 1101 | 694 | 1016 | 814 | 1062 | 745 | 1156 | 1008 | 629 | 641 | 1215 | 802 | 969 | MERGE not correctly worked with parameters in MATCHING clause |
|
| 2 | CS | 1541 | 1538 | 1539 | 939 | 829 | 956 | 1710 | 1450 | 1557 | 1576 | 1471 | 1335 | 1407 | 868 | 925 | 1459 | 809 | 1377 | 1222 | 1582 | 1315 | 846 | 1341 | 999 | 1225 | 1043 | 1331 | 822 | 1336 | 1241 | 830 | 805 | 1373 | 1088 | 1220 | CREATE OR ALTER VIEW statement |
|
| 3 | CS | 1555 | 1485 | 1447 | 790 | 814 | 931 | 1430 | 1464 | 1684 | 1440 | 941 | 1355 | 1481 | 785 | 1507 | 839 | 815 | 1205 | 1380 | 838 | 1382 | 1414 | 1258 | 867 | 1142 | 1100 | 1182 | 776 | 1280 | 1310 | 917 | 792 | 1256 | 1002 | 1185 | Error in EXECUTE STATEMENT inside CONNECT / TRANSACTION START triggers |
|
| 4 | CS | 1370 | 1356 | 1275 | 722 | 628 | 734 | 1285 | 1336 | 1280 | 1258 | 776 | 1276 | 1225 | 677 | 1204 | 1168 | 681 | 1172 | 1144 | 771 | 1184 | 972 | 1158 | 774 | 969 | 834 | 1009 | 708 | 1284 | 974 | 609 | 725 | 1015 | 835 | 997 | Bug in create/alter Database trigger (with Russian comment) |
|
| 5 | CS | 1009 | 1243 | 1172 | 664 | 656 | 664 | 1110 | 1033 | 1225 | 1152 | 1215 | 1065 | 631 | 1234 | 1145 | 1204 | 665 | 963 | 1265 | 1144 | 954 | 699 | 1121 | 710 | 943 | 789 | 983 | 652 | 1023 | 1063 | 716 | 610 | 1079 | 978 | 963 | EVL_expr: invalid operation (232) |
|
| 6 | CS | 1356 | 1261 | 691 | 745 | 1163 | 664 | 1362 | 1245 | 1380 | 1372 | 1370 | 1351 | 1243 | 679 | 1326 | 1167 | 827 | 1205 | 1202 | 1350 | 1396 | 1117 | 967 | 870 | 1102 | 1471 | 1007 | 660 | 1031 | 1088 | 765 | 697 | 1017 | 969 | 618 | Add DROP NOT NULL to ALTER COLUMN |
|
| 7 | CS | 1388 | 1729 | 727 | 1618 | 824 | 801 | 1537 | 751 | 1678 | 749 | 801 | 1347 | 682 | 1324 | 1426 | 766 | 790 | 733 | 738 | 815 | 1597 | 1194 | 735 | 844 | 1096 | 1510 | 1140 | 763 | 662 | 649 | 802 | 723 | 1229 | 857 | 1152 | Error "no current record for fetch operation" when sorting by a international string |
|
| 8 | CS | 1319 | 1672 | 718 | 1425 | 813 | 763 | 1341 | 751 | 1317 | 759 | 767 | 1267 | 695 | 1260 | 1200 | 710 | 814 | 705 | 759 | 942 | 1360 | 1261 | 677 | 837 | 1072 | 1261 | 1076 | 719 | 608 | 699 | 735 | 648 | 1150 | 820 | 640 | COMPUTED BY column looses charset and collate of source field <F> when <F> is either of type BLOB or VARCHAR casted to BLOB |
|
| 9 | CS | 1504 | 1304 | 703 | 1289 | 749 | 705 | 1346 | 684 | 1439 | 781 | 708 | 1321 | 718 | 1169 | 1193 | 718 | 755 | 927 | 755 | 760 | 1196 | 1320 | 696 | 872 | 1039 | 1115 | 1053 | 669 | 652 | 717 | 709 | 718 | 1053 | 1066 | 620 | Results of concatenation with blob has no info about collation of source columns (which are declared with such info) |
|
| 10 | SS | 790 | 393 | 802 | 834 | 435 | 419 | 456 | 569 | 495 | 699 | 448 | 669 | 384 | 691 | 712 | 659 | 537 | 706 | 560 | 428 | 731 | 697 | 745 | 543 | 603 | 441 | 626 | 455 | 616 | 433 | 441 | 419 | 596 | 344 | 416 | Incorrect indexed lookup of strings when the last keys characters are part of collated contractions and there is multi-segment insensitive descending index |
|
| 11 | CS | 1375 | 1172 | 734 | 662 | 1296 | 702 | 725 | 743 | 700 | 720 | 751 | 707 | 708 | 1243 | 1221 | 1085 | 1536 | 1244 | 661 | 686 | 817 | 1367 | 1160 | 758 | 1168 | 1055 | 1096 | 680 | 1076 | 1075 | 844 | 718 | 727 | 569 | 585 | Firebird does not find an record when adding a foreign key |
|
| 12 | CS | 1284 | 1243 | 704 | 690 | 1286 | 722 | 716 | 785 | 735 | 735 | 766 | 687 | 833 | 1346 | 1281 | 1081 | 1185 | 969 | 698 | 794 | 730 | 1220 | 1168 | 767 | 1015 | 987 | 1016 | 854 | 1113 | 1112 | 741 | 701 | 685 | 570 | 583 | Chained JOIN .. USING across the same column names may be optimized badly |
|
| 13 | SS | 871 | 476 | 887 | 862 | 507 | 459 | 525 | 953 | 932 | 505 | 481 | 872 | 530 | 573 | 459 | 939 | 978 | 760 | 566 | 495 | 683 | 1028 | 653 | 519 | 721 | 809 | 703 | 480 | 901 | 829 | 541 | 552 | 684 | 421 | 744 | Ignore missing UDR libraries during restore |
|
| 14 | SS | 1538 | 833 | 1517 | 1573 | 852 | 836 | 821 | 1491 | 1686 | 863 | 977 | 1513 | 797 | 815 | 1114 | 1514 | 1436 | 1554 | 807 | 929 | 1294 | 1522 | 1419 | 1159 | 1553 | 1618 | 1499 | 958 | 1511 | 1401 | 1164 | 894 | 1331 | 725 | 1037 | DEFAULTed grants to PUBLIC must act as DEFAULTed to every user |
|
| 15 | SS | 749 | 385 | 716 | 711 | 447 | 377 | 363 | 531 | 631 | 381 | 464 | 614 | 329 | 429 | 628 | 627 | 475 | 671 | 368 | 424 | 638 | 515 | 419 | 501 | 583 | 573 | 603 | 409 | 522 | 490 | 442 | 427 | 585 | 343 | 336 | Wrong error message - "string right truncation. expected length NN, actual NN." |
|
| 16 | SS | 3803 | 2155 | 4052 | 3695 | 2276 | 2414 | 2231 | 3685 | 3692 | 2234 | 2423 | 3490 | 2394 | 2297 | 3497 | 3223 | 3503 | 3520 | 2210 | 2334 | 3429 | 3177 | 3370 | 2913 | 3708 | 3787 | 3416 | 2600 | 3542 | 3295 | 2829 | 2638 | 3362 | 1936 | 2095 | Nbackup RDB$BACKUP_HISTORY cleanup |
|
| 17 | CS | 1233 | 1401 | 781 | 668 | 1378 | 658 | 701 | 760 | 742 | 705 | 1335 | 761 | 619 | 1091 | 1136 | 605 | 666 | 1062 | 1140 | 824 | 725 | 685 | 789 | 729 | 974 | 1014 | 968 | 631 | 1267 | 905 | 913 | 880 | 854 | 776 | 719 | Cursor name can duplicate parameter and variable names in procedures and functions |
|
| 18 | CS | 1104 | 665 | 638 | 1144 | 1096 | 632 | 1343 | 664 | 667 | 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 | Cast dies with numeric value is out of range error |
|
| 19 | CS | 1185 | 1503 | 692 | 602 | 1069 | 711 | 1314 | 649 | 664 | 1208 | 725 | 600 | 555 | 1039 | 594 | 584 | 662 | 1032 | 1214 | 1198 | 627 | 544 | 662 | 662 | 961 | 918 | 905 | 669 | 823 | X | X | X | X | X | X | Fix issues with longish concatenated context aliases |
|
| 20 | CS | 1577 | 822 | 768 | 1470 | 1513 | 873 | 869 | 1520 | 1449 | 1515 | 891 | 785 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Gstat -table will only report one matching table |
|
| 21 | CS | 1400 | 851 | 857 | 1526 | 1522 | 871 | 953 | 1569 | 1417 | 891 | 1576 | 1166 | 806 | 1466 | 1428 | 1407 | 848 | 1489 | 881 | 959 | 1393 | 1377 | 926 | 989 | 1231 | 1166 | 1247 | 800 | 1047 | 1124 | 1022 | 1019 | 1057 | 994 | 1027 | Derived table column names must be unique |
|
| 22 | CS | 1503 | 887 | 903 | 1471 | 1535 | 895 | 862 | 1519 | 1576 | 963 | 1671 | 789 | 816 | 859 | 1531 | 1224 | 789 | 946 | 814 | 911 | 1374 | 1542 | 922 | 1053 | 1184 | 1167 | 1267 | 846 | 1108 | 1052 | 1089 | 1010 | 1018 | 1031 | 1036 | Derived table with outer reference from JOIN. |
|
| 23 | SS | 699 | 463 | 764 | 773 | 448 | 435 | 714 | 645 | 469 | 434 | 480 | 835 | 428 | 402 | 403 | 743 | 656 | 853 | 872 | 471 | 747 | 554 | 733 | 489 | 664 | 972 | 688 | 462 | 656 | 704 | 532 | 493 | 632 | 672 | 381 | INNER JOIN join merge |
|
| 24 | SS | 796 | 483 | 752 | 848 | 414 | 459 | 862 | 703 | 547 | 413 | 461 | 860 | 449 | 461 | 399 | 577 | 662 | 592 | 411 | 447 | 590 | 457 | 550 | 535 | 669 | 592 | 680 | 457 | 698 | 719 | 482 | 508 | 696 | 540 | 364 | INNER JOIN join merge and SP |
|
| 25 | SS | 713 | 466 | 733 | 777 | 463 | 406 | 959 | 701 | 504 | 477 | 478 | 636 | 550 | 511 | 478 | 770 | 865 | 885 | 400 | 478 | 432 | 497 | 626 | 493 | 653 | 560 | 657 | 523 | 788 | 718 | 555 | 501 | 608 | 673 | 389 | LEFT OUTER JOIN with distribution CASE |
|
| 26 | SS | 762 | 409 | 435 | 837 | 846 | 441 | 628 | 815 | 879 | 492 | 503 | 429 | 558 | 457 | 451 | 760 | 808 | 826 | 440 | 426 | 434 | 830 | 754 | 519 | 589 | 866 | 696 | 504 | 673 | 721 | 499 | 512 | 695 | 612 | 623 | Best match index selection (single segment) |
|
| 27 | CS | 1464 | 1556 | 1592 | 771 | 782 | 903 | 873 | 873 | 1536 | 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 | Best match index selection (single segment) |
|
| 28 | CS | 1445 | 1405 | 1728 | 856 | 788 | 869 | 961 | 1357 | 1596 | 1539 | 804 | 1459 | 1701 | 1025 | 749 | 817 | 801 | 756 | 794 | 902 | 755 | 769 | 929 | 902 | 1209 | 1134 | 1262 | 764 | 1089 | 1001 | 963 | 953 | 951 | 999 | 928 | Best match index selection (single segment) ASC and DESC |
|
| 29 | SS | 1853 | 1784 | 2061 | 847 | 1182 | 1159 | 888 | 1912 | 1092 | 1053 | 1081 | 1969 | 2077 | 1804 | 2120 | 1796 | 909 | 1425 | 1751 | 1150 | 1903 | 909 | 916 | 1558 | 1876 | 1447 | 2055 | X | X | X | X | X | X | X | X | Support for NOT SINGULAR when subquery refers to another table |
|
| 30 | SS | 1961 | 1660 | 1084 | 905 | 2055 | 1029 | 1067 | 1694 | 1098 | 1961 | 1863 | 1499 | 1220 | 1692 | 1244 | 1835 | 1693 | 2032 | 967 | 1912 | 999 | 1754 | 1271 | 1450 | 1613 | 1491 | 1949 | 1591 | X | X | X | X | X | X | X | Support to SINGULAR in nested subqueries |
|
| 31 | SS | 628 | 322 | 610 | 360 | 695 | 347 | 649 | 620 | 695 | 477 | 390 | 597 | 549 | 349 | 565 | 589 | 614 | 536 | 562 | 630 | 537 | 523 | 475 | 426 | 545 | 574 | 595 | 387 | 616 | 568 | 389 | 413 | 309 | 374 | 432 | CAST DATE -> CHAR |