NN | Test name | mode | Test last update | Moving medians chart |
6.0.0.881
|
6.0.0.877
|
6.0.0.876
|
6.0.0.863
|
6.0.0.858
|
6.0.0.849
|
6.0.0.848
|
6.0.0.845
|
6.0.0.843
|
6.0.0.840
|
6.0.0.838
|
6.0.0.835
|
6.0.0.834
|
6.0.0.800
|
6.0.0.799
|
6.0.0.797
|
6.0.0.795
|
6.0.0.792
|
6.0.0.791
|
6.0.0.789
|
6.0.0.787
|
6.0.0.783
|
6.0.0.779
|
6.0.0.778
|
6.0.0.776
|
6.0.0.770
|
Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | CS | 2025.06.25 15:39 | 2558 | 1524 | 1524 | 1524 | X | X | X | X | X | X | X | X | X | 1498 | 1524 | 1483 | 1483 | 1483 | 1562 | 1508 | 1541 | 1508 | 1508 | 1309 | 1085 | 823 | User (not SYSDBA) that have privileges with grant option, can't revoke privileges, granted by other user or SYSDBA |
||
2 | CS | 2022.02.02 14:46 | 1037 | 645 | 1037 | 1037 | 1037 | 653 | 653 | 653 | 653 | 653 | 636 | 674 | 674 | 1030 | 1199 | 1199 | 1199 | 1188 | 1167 | 1167 | 1188 | 725 | 1105 | 1142 | 1142 | 1142 | 'select ...from...where...not in (select...from...)' no results |
||
3 | CS | 2022.02.02 14:46 | 1020 | 652 | 652 | 635 | 635 | 635 | 617 | 617 | 582 | 582 | 598 | 627 | 627 | 627 | 679 | 878 | 1014 | 878 | 878 | 878 | 693 | 693 | 1094 | 1094 | 1094 | 1094 | ABS() rounds NUMERIC values |
||
4 | CS | 2022.02.02 14:46 | 1042 | 639 | 639 | 639 | 639 | 587 | 609 | 609 | 648 | 639 | 648 | 653 | 653 | 677 | 991 | 991 | 991 | 731 | 731 | 731 | 731 | 731 | 1017 | 1103 | 1103 | 1104 | Bugcheck 232 (invalid operation) for an aggregated query |
||
5 | CS | 2024.06.09 15:53 | 1191 | 785 | 785 | 785 | 785 | 699 | 749 | 749 | 749 | 749 | 749 | 881 | 881 | 1086 | 1306 | 1306 | 1306 | 1086 | 844 | 844 | 821 | 821 | 1157 | 1234 | 1234 | 1292 | Ability to insert child record if parent record is locked but foreign key target unchanged |
||
6 | CS | 2022.02.02 14:46 | 1069 | 672 | 672 | 672 | 672 | 672 | 666 | 666 | 666 | 664 | 664 | 664 | 664 | 828 | 1073 | 1073 | 1073 | 828 | 752 | 752 | 752 | 752 | 1103 | 1103 | 1103 | 1142 | PSQL output parameter size limited |
||
7 | CS | 2022.02.02 14:46 | 991 | 580 | 580 | 757 | 757 | 757 | 757 | 757 | 672 | 672 | 672 | 702 | 702 | 702 | 699 | 699 | 699 | 699 | 729 | 1064 | 1111 | 1111 | 1111 | 1120 | 1120 | 1098 | MERGE not correctly worked with parameters in MATCHING clause |
||
8 | CS | 2023.10.05 09:23 | 1285 | 810 | 810 | 806 | 806 | 801 | 783 | 783 | 771 | 771 | 812 | 904 | 904 | 904 | 919 | 1355 | 1355 | 919 | 1357 | 1429 | 1357 | 1318 | 1318 | 1290 | 1290 | 1318 | CREATE OR ALTER VIEW statement |
||
9 | CS | 2022.02.02 14:46 | 4345 | 2730 | 2730 | 2837 | 2837 | 2837 | 2838 | 2838 | 2838 | 2776 | 2776 | 2776 | 2776 | 4515 | 4675 | 4830 | 4675 | 4515 | 4830 | 4830 | 4963 | 4990 | 4990 | 4963 | 4752 | 4752 | Non-privileged monitoring reports wrong attachment data |
||
10 | CS | 2022.02.02 14:46 | 940 | 576 | 569 | 576 | 576 | 634 | 634 | 827 | 827 | 601 | 601 | 747 | 747 | 1000 | 1100 | 1100 | 1135 | 1135 | 1078 | 1078 | 1078 | 1078 | 1110 | 1110 | 1101 | 1101 | Floor & ceiling functions give wrong results with exact numeric arguments |
||
11 | CS | 2022.02.02 14:46 | 1324 | 876 | 876 | 876 | 792 | 792 | 1304 | 1304 | 847 | 1351 | 847 | 825 | 842 | 842 | 842 | 842 | 847 | 886 | 970 | 970 | 1294 | 1311 | 1312 | 1312 | 1381 | 1403 | Parts of RDB$DB_KEY of views may be inverted when using outer joins |
||
12 | CS | 2025.06.26 18:01 | 993 | 642 | X | X | X | X | X | X | X | X | X | X | X | 652 | 652 | 652 | 680 | 687 | 687 | 687 | 687 | 687 | 995 | 1041 | 1058 | 1082 | Tricky index names can defeat the parsing logic when generating a human readable plan |
||
13 | CS | 2025.06.26 18:07 | 1167 | 763 | X | X | X | X | X | X | X | X | X | X | X | 789 | 763 | 763 | 763 | 789 | 768 | 768 | 768 | 918 | 1130 | 1149 | 1290 | 1318 | CI column does not group correctly with a second column |
||
14 | CS | 2022.02.02 14:46 | 949 | 616 | 949 | 616 | 616 | 701 | 701 | 624 | 624 | 624 | 624 | 680 | 1009 | 1090 | 1090 | 849 | 1121 | 849 | 700 | 700 | 700 | 700 | 1035 | 1035 | 1035 | 1031 | AV using recursive query as subquery in SELECT list and ORDER'ing by them |
||
15 | CS | 2022.02.02 14:46 | 1597 | 1046 | 1512 | 1512 | 1512 | 1039 | 1039 | 1028 | 1028 | 1028 | 1042 | 1670 | 1670 | 1670 | 1664 | 1586 | 1586 | 1542 | 1542 | 1143 | 1143 | 1143 | 1545 | 1703 | 1721 | 1731 | Problems with COMMENT ON and strings using introducer (charset) |
||
16 | CS | 2023.12.10 10:22 | 1053 | 674 | 674 | 1105 | 1044 | 1044 | 1044 | 651 | 641 | 641 | 651 | 1072 | 1072 | 1072 | 1072 | 1049 | 1049 | 1049 | 1091 | 1049 | 964 | 964 | 1053 | 1005 | 1053 | 1062 | count(*) from big table returns negative result |
||
17 | CS | 2022.02.02 14:46 | 1024 | 667 | 667 | 1031 | 1003 | 1003 | 1003 | 600 | 592 | 592 | 600 | 947 | 947 | 989 | 989 | 947 | 934 | 934 | 934 | 812 | 812 | 1020 | 1033 | 1020 | 1020 | 1033 | Incorrect ROW_COUNT value after SINGULAR condition |
||
18 | CS | 2022.02.02 14:46 | 1206 | 747 | 1206 | 843 | 843 | 839 | 839 | 810 | 805 | 805 | 810 | 1272 | 1333 | 1368 | 1369 | 1368 | 1369 | 1369 | 1349 | 1349 | 1308 | 1308 | 1310 | 1312 | 1310 | 1312 | Incorrect LEFT JOIN result using table and derived constant subquery |
||
19 | CS | 2022.02.02 14:46 | 996 | 576 | 996 | 643 | 724 | 643 | 679 | 669 | 679 | 679 | 714 | 714 | 1024 | 1040 | 1073 | 1087 | 1087 | 1087 | 1046 | 1042 | 1042 | 1042 | 1057 | 1057 | 1057 | 1057 | Built-in function POWER(X, Y) does not work when the X argument is negative and the Y value is scaled numeric but integral |
||
20 | CS | 2023.11.25 22:13 | 1199 | 758 | 758 | 758 | 758 | 792 | 843 | 881 | 881 | 881 | 1206 | 1321 | 1321 | 1388 | 1388 | 1520 | 1383 | 1383 | 807 | 1278 | 1278 | 1278 | 1290 | 1290 | 1290 | 773 | Dependencies are not removed after dropping the procedure and the table it depends on in the same transaction |
||
21 | SS | 2022.02.02 14:46 | 555 | 353 | 348 | 348 | 348 | 363 | 363 | 436 | 363 | 363 | 355 | 524 | 382 | 382 | 370 | 382 | 382 | 470 | 506 | 506 | 470 | 463 | 445 | 445 | 463 | 471 | Support for WHEN NOT MATCHED BY SOURCE for MERGE statement |
||
22 | SS | 2023.11.12 10:17 | X | X | X | X | X | X | X | X | X | X | X | X | X | 1962 | 1304 | 1250 | 1204 | 1204 | 1204 | 1772 | 1772 | 1790 | 1981 | 2209 | 2268 | 2268 | Provide ability to run "ALTER SQL SECURITY DEFINER / INVOKER" without specifying further part of proc/func/package |
||
23 | CS | 2024.01.12 15:40 | X | X | X | X | X | X | X | X | X | X | X | X | X | 1248 | 751 | 1248 | 751 | 751 | 751 | 725 | 725 | 751 | 843 | 1209 | 1209 | 1209 | Inconsistent state of master-detail occurs after RE-connect + 'SET AUTODDL OFF' + 'drop <FK>' which is ROLLED BACK |
||
24 | CS | 2024.01.23 05:23 | X | X | X | X | X | X | X | X | X | X | X | X | X | 1085 | 638 | 638 | 623 | 623 | 623 | 657 | 741 | 1083 | 1083 | 683 | 683 | 683 | System procedure/function inconsistency between ISQL SHOW FUNCTIONS and SHOW PROCEDURES |
||
25 | CS | 2025.04.16 17:03 | X | X | X | X | X | X | X | X | X | X | X | X | X | 1776 | 1183 | 1183 | 1183 | 1206 | 1206 | 1206 | 1712 | 1733 | 1733 | 1168 | 1126 | 1126 | Unnest IN/ANY/EXISTS subqueries and optimize them using semi-join algorithm |
||
26 | CS | 2024.10.26 08:21 | X | X | X | X | X | X | X | X | X | X | X | X | X | 1191 | 755 | 1313 | 858 | 888 | 858 | 858 | 742 | 742 | 740 | 740 | 742 | 1200 | "Unique scan" is incorrectly reported in the explained plan for unique index and IS NULL predicate |
||
27 | CS | 2022.02.04 18:05 | X | X | X | X | X | X | X | X | X | X | X | X | X | 1168 | 774 | 774 | 774 | 910 | 772 | 910 | 910 | 910 | 1363 | 1363 | 1344 | 877 | AVOID index usage in WHERE <indexed_varchar_field> = <integer_value> |
||
28 | CS | 2022.02.04 18:05 | X | X | X | X | X | X | X | X | X | X | X | X | X | 1388 | 913 | 913 | 913 | 888 | 888 | 888 | 995 | 1351 | 1351 | 1351 | 1351 | 1351 | Check correct work fix with foreign key |
||
29 | CS | 2022.02.04 18:05 | X | X | X | X | X | X | X | X | X | X | X | X | X | 1223 | 775 | 1244 | 1244 | 1217 | 1192 | 1192 | 823 | 758 | 758 | 758 | 747 | 743 | Zero divide in SP can crash database when call this SP several times |
NN | Test name | mode |
6.0.0.881
|
6.0.0.877
|
6.0.0.876
|
6.0.0.863
|
6.0.0.858
|
6.0.0.849
|
6.0.0.848
|
6.0.0.845
|
6.0.0.843
|
6.0.0.840
|
6.0.0.838
|
6.0.0.835
|
6.0.0.834
|
6.0.0.800
|
6.0.0.799
|
6.0.0.797
|
6.0.0.795
|
6.0.0.792
|
6.0.0.791
|
6.0.0.789
|
6.0.0.787
|
6.0.0.783
|
6.0.0.779
|
6.0.0.778
|
6.0.0.776
|
6.0.0.770
|
6.0.0.767
|
6.0.0.762
|
6.0.0.755
|
6.0.0.753
|
Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | CS | 3024 | 2558 | 1524 | 2704 | X | X | X | X | X | X | X | X | X | 1498 | 1524 | 1574 | 1359 | 1483 | 1667 | 1457 | 1562 | 1115 | 1624 | 1508 | 1541 | 1309 | 1085 | 784 | 801 | 823 | User (not SYSDBA) that have privileges with grant option, can't revoke privileges, granted by other user or SYSDBA |
|
2 | CS | 1184 | 645 | 584 | 1041 | 1037 | 597 | 1115 | 652 | 1129 | 653 | 636 | 1004 | 587 | 674 | 618 | 1030 | 1199 | 1209 | 1217 | 1167 | 1188 | 725 | 711 | 1233 | 1352 | 629 | 1105 | 1142 | 1207 | 1154 | 'select ...from...where...not in (select...from...)' no results |
|
3 | CS | 1091 | 1020 | 652 | 1129 | 561 | 635 | 1053 | 617 | 1092 | 570 | 582 | 1068 | 568 | 598 | 627 | 679 | 1014 | 600 | 1138 | 878 | 1063 | 670 | 553 | 1231 | 693 | 1111 | 1094 | 964 | 1111 | 1025 | ABS() rounds NUMERIC values |
|
4 | CS | 1042 | 1094 | 624 | 1106 | 639 | 551 | 1122 | 587 | 1091 | 586 | 609 | 1067 | 648 | 639 | 653 | 1214 | 991 | 677 | 1283 | 588 | 1137 | 731 | 719 | 1345 | 597 | 1017 | 1103 | 1104 | 1112 | 1123 | Bugcheck 232 (invalid operation) for an aggregated query |
|
5 | CS | 1287 | 1262 | 657 | 1191 | 785 | 645 | 1172 | 670 | 1247 | 699 | 749 | 1304 | 720 | 881 | 737 | 1481 | 1306 | 1086 | 1341 | 844 | 1388 | 821 | 768 | 1573 | 753 | 1234 | 1157 | 1330 | 1292 | 1326 | Ability to insert child record if parent record is locked but foreign key target unchanged |
|
6 | CS | 1256 | 1069 | 573 | 1171 | 605 | 672 | 1126 | 632 | 1062 | 646 | 666 | 1006 | 617 | 664 | 621 | 1098 | 1073 | 828 | 1149 | 700 | 1124 | 752 | 600 | 1323 | 674 | 1142 | 1103 | 1029 | 1167 | 1169 | PSQL output parameter size limited |
|
7 | CS | 1104 | 1073 | 569 | 991 | 580 | 577 | 1049 | 757 | 1059 | 564 | 672 | 1053 | 561 | 702 | 614 | 1129 | 1079 | 654 | 699 | 641 | 1064 | 729 | 1111 | 1367 | 1168 | 1077 | 1056 | 1120 | 1129 | 1098 | MERGE not correctly worked with parameters in MATCHING clause |
|
8 | CS | 1393 | 1285 | 810 | 1353 | 806 | 801 | 1278 | 783 | 1356 | 754 | 771 | 1417 | 760 | 812 | 904 | 1470 | 1355 | 791 | 919 | 1529 | 1357 | 840 | 1429 | 1605 | 1290 | 1318 | 860 | 1273 | 1347 | 1419 | CREATE OR ALTER VIEW statement |
|
9 | CS | 4955 | 4530 | 2648 | 4345 | 2676 | 2730 | 4624 | 2837 | 4625 | 2699 | 2838 | 4782 | 2494 | 2776 | 2684 | 5059 | 4675 | 4515 | 4995 | 4830 | 4464 | 3082 | 4990 | 5656 | 4963 | 5062 | 3816 | 4752 | 4728 | 4977 | Non-privileged monitoring reports wrong attachment data |
|
10 | CS | 1131 | 948 | 569 | 940 | 548 | 576 | 561 | 634 | 995 | 827 | 565 | 1036 | 577 | 601 | 747 | 1100 | 1000 | 1207 | 1135 | 1054 | 1176 | 761 | 1078 | 1277 | 1048 | 1110 | 1136 | 1047 | 1101 | 1058 | Floor & ceiling functions give wrong results with exact numeric arguments |
|
11 | CS | 1432 | 780 | 1324 | 1324 | 876 | 792 | 753 | 1304 | 744 | 1364 | 1351 | 825 | 847 | 1393 | 722 | 752 | 842 | 847 | 1380 | 803 | 970 | 886 | 1517 | 1311 | 1294 | 1381 | 1312 | 1446 | 1403 | 1433 | Parts of RDB$DB_KEY of views may be inverted when using outer joins |
|
12 | CS | 1144 | 559 | X | X | X | X | X | X | X | X | X | X | X | 1200 | 993 | 630 | 642 | 652 | 680 | 981 | 692 | 687 | 675 | 602 | 995 | 1157 | 1151 | 1041 | 1058 | 1082 | Tricky index names can defeat the parsing logic when generating a human readable plan |
|
13 | CS | 1235 | 669 | X | X | X | X | X | X | X | X | X | X | X | 1251 | 1167 | 657 | 763 | 789 | 762 | 1255 | 726 | 918 | 768 | 741 | 1130 | 1290 | 1334 | 1149 | 1318 | 1391 | CI column does not group correctly with a second column |
|
14 | CS | 1115 | 565 | 982 | 949 | 616 | 585 | 1092 | 601 | 1008 | 701 | 587 | 624 | 583 | 1009 | 1090 | 680 | 1337 | 1121 | 672 | 849 | 1160 | 700 | 549 | 689 | 1035 | 1144 | 1102 | 974 | 976 | 1031 | AV using recursive query as subquery in SELECT list and ORDER'ing by them |
|
15 | CS | 1730 | 981 | 1046 | 1597 | 1816 | 886 | 1512 | 1039 | 1539 | 974 | 948 | 1028 | 1042 | 1711 | 1687 | 1670 | 1586 | 1527 | 1664 | 1542 | 1743 | 1143 | 989 | 1051 | 1545 | 1703 | 1721 | 1767 | 1761 | 1731 | Problems with COMMENT ON and strings using introducer (charset) |
|
16 | CS | 1131 | 1053 | 613 | 1107 | 674 | 558 | 1216 | 1105 | 1044 | 566 | 651 | 583 | 641 | 1078 | 1164 | 1072 | 952 | 1018 | 1093 | 1049 | 1091 | 719 | 1111 | 634 | 964 | 1062 | 1053 | 1005 | 1129 | 1277 | count(*) from big table returns negative result |
|
17 | CS | 1181 | 1024 | 524 | 1031 | 667 | 626 | 1178 | 1187 | 1003 | 592 | 600 | 582 | 547 | 1065 | 1181 | 947 | 887 | 989 | 1101 | 934 | 812 | 684 | 1106 | 590 | 1020 | 1033 | 1067 | 1020 | 1008 | 1312 | Incorrect ROW_COUNT value after SINGULAR condition |
|
18 | CS | 1361 | 736 | 1238 | 747 | 1206 | 745 | 1310 | 843 | 839 | 749 | 810 | 805 | 793 | 1272 | 1384 | 1368 | 1333 | 1378 | 1369 | 1349 | 1536 | 938 | 1308 | 1553 | 1260 | 1336 | 1310 | 1312 | 1248 | 1437 | Incorrect LEFT JOIN result using table and derived constant subquery |
|
19 | CS | 1123 | 576 | 1053 | 563 | 996 | 556 | 1110 | 643 | 724 | 582 | 679 | 669 | 714 | 1024 | 1073 | 592 | 1040 | 1094 | 1087 | 1507 | 1046 | 655 | 1032 | 1042 | 1115 | 1060 | 1057 | 1007 | 1056 | 1167 | Built-in function POWER(X, Y) does not work when the X argument is negative and the Y value is scaled numeric but integral |
|
20 | CS | 1259 | 739 | 1199 | 1296 | 758 | 750 | 723 | 1352 | 905 | 792 | 843 | 881 | 1206 | 1321 | 1388 | 1520 | 1288 | 1527 | 804 | 2037 | 1383 | 807 | 785 | 1278 | 1301 | 1380 | 1290 | 760 | 732 | 773 | Dependencies are not removed after dropping the procedure and the table it depends on in the same transaction |
|
21 | SS | 670 | 555 | 582 | 353 | 342 | 330 | 348 | 683 | 436 | 363 | 355 | 524 | 343 | 636 | 310 | 611 | 382 | 370 | 348 | 668 | 506 | 470 | 507 | 439 | 445 | 463 | 438 | 490 | 472 | 471 | Support for WHEN NOT MATCHED BY SOURCE for MERGE statement |
|
22 | SS | X | X | X | X | X | X | X | X | X | X | X | X | X | 1965 | 1962 | 1304 | 1250 | 2396 | 1204 | 1149 | 1160 | 1790 | 1981 | 1772 | 1677 | 2209 | 2435 | 2268 | 2482 | 2177 | Provide ability to run "ALTER SQL SECURITY DEFINER / INVOKER" without specifying further part of proc/func/package |
|
23 | CS | X | X | X | X | X | X | X | X | X | X | X | X | X | 1464 | 643 | 1328 | 669 | 1248 | 751 | 1428 | 725 | 706 | 751 | 704 | 1484 | 1209 | 843 | 1321 | 912 | 1264 | Inconsistent state of master-detail occurs after RE-connect + 'SET AUTODDL OFF' + 'drop <FK>' which is ROLLED BACK |
|
24 | CS | X | X | X | X | X | X | X | X | X | X | X | X | X | 1085 | 604 | 1101 | 638 | 1210 | 589 | 611 | 623 | 741 | 1124 | 657 | 1083 | 1093 | 672 | 683 | 632 | 1055 | System procedure/function inconsistency between ISQL SHOW FUNCTIONS and SHOW PROCEDURES |
|
25 | CS | X | X | X | X | X | X | X | X | X | X | X | X | X | 1844 | 1776 | 1132 | 1043 | 2343 | 1183 | 1206 | 1052 | 1712 | 1733 | 1168 | 1947 | 2411 | 1126 | 1025 | 1104 | 2170 | Unnest IN/ANY/EXISTS subqueries and optimize them using semi-join algorithm |
|
26 | CS | X | X | X | X | X | X | X | X | X | X | X | X | X | 1191 | 667 | 1313 | 683 | 1591 | 755 | 1344 | 858 | 888 | 702 | 717 | 742 | 1350 | 740 | 676 | 1200 | 1455 | "Unique scan" is incorrectly reported in the explained plan for unique index and IS NULL predicate |
|
27 | CS | X | X | X | X | X | X | X | X | X | X | X | X | X | 1294 | 1307 | 689 | 774 | 1168 | 772 | 1411 | 760 | 910 | 758 | 1431 | 1363 | 877 | 1604 | 744 | 1344 | 789 | AVOID index usage in WHERE <indexed_varchar_field> = <integer_value> |
|
28 | CS | X | X | X | X | X | X | X | X | X | X | X | X | X | 1388 | 874 | 817 | 1529 | 1464 | 913 | 855 | 852 | 888 | 1421 | 995 | 1363 | 1351 | 804 | 1432 | 827 | 1396 | Check correct work fix with foreign key |
|
29 | CS | X | X | X | X | X | X | X | X | X | X | X | X | X | 1223 | 775 | 725 | 1449 | 1574 | 769 | 1244 | 1217 | 823 | 1192 | 758 | 747 | 743 | 1320 | 1332 | 701 | 725 | Zero divide in SP can crash database when call this SP several times |