NN | Test name | mode | Test last update | Moving medians chart |
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
|
Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | CS | 2022.02.02 14:46 | 1905 | 1171 | 1905 | 1299 | 1299 | 1200 | 1200 | 1146 | 1146 | 1146 | 2087 | 2087 | 2087 | 2087 | 2074 | 2074 | 2074 | 2074 | 2007 | 2007 | 2007 | 2054 | 2113 | 2133 | 2133 | 2164 | Server shutdown |
||
2 | CS | 2022.02.02 14:46 | 1000 | 610 | 1007 | 610 | 610 | 610 | 620 | 620 | 631 | 644 | 1037 | 1052 | 1083 | 1138 | 1138 | 1138 | 1138 | 1091 | 1091 | 1077 | 1077 | 1084 | 1122 | 1161 | 1162 | 1161 | Incorrect value returned with execute statement calculation |
||
3 | CS | 2022.02.02 14:46 | 974 | 637 | 974 | 616 | 616 | 616 | 616 | 587 | 587 | 623 | 1050 | 1093 | 1185 | 1191 | 1185 | 1128 | 1128 | 1112 | 1035 | 1035 | 1035 | 1082 | 1082 | 1082 | 1082 | 1108 | Navigation vs IS NULL vs compound index |
||
4 | CS | 2022.02.02 14:46 | 2364 | 1455 | 1455 | 1455 | 1544 | 1471 | 1544 | 2458 | 2458 | 2458 | 2458 | 2458 | 2494 | 2494 | 2523 | 2604 | 2523 | 2576 | 2572 | 2572 | 2224 | 2224 | 1807 | 1767 | 1516 | 1516 | Services Manager and gsec truncate First.Middle.Last Name fields to 17 chars instead of 32 chars available in field definition |
||
5 | CS | 2022.02.02 14:46 | 1151 | 746 | 811 | 811 | 943 | 811 | 943 | 1277 | 1277 | 1300 | 1300 | 1303 | 1309 | 1373 | 1373 | 1373 | 1350 | 1348 | 1326 | 1320 | 1320 | 1320 | 977 | 912 | 776 | 766 | View with equally named source fields not faisible |
||
6 | SS | 2025.06.25 15:39 | 1000 | 577 | 572 | X | X | X | X | X | X | X | X | X | 572 | 562 | 577 | 562 | 582 | 564 | 576 | 564 | 564 | 540 | 540 | 531 | 531 | 556 | User (not SYSDBA) that have privileges with grant option, can't revoke privileges, granted by other user or SYSDBA |
||
7 | CS | 2022.02.02 14:46 | 1158 | 707 | 707 | 707 | 707 | 1135 | 1135 | 1135 | 1156 | 1145 | 1145 | 1156 | 1174 | 1207 | 1248 | 1207 | 1207 | 1156 | 1156 | 1113 | 859 | 1087 | 1087 | 887 | 1087 | 1103 | A remote attacker can check, if a file is present in the system, running firebird server |
||
8 | CS | 2022.02.02 14:46 | 1002 | 635 | 635 | 591 | 635 | 635 | 639 | 677 | 1038 | 1038 | 1013 | 1038 | 1038 | 1104 | 1123 | 1123 | 1123 | 1041 | 1041 | 999 | 849 | 849 | 849 | 849 | 849 | 665 | Aliases for the RETURNING clause |
||
9 | CS | 2022.02.02 14:46 | 948 | 571 | 619 | 619 | 747 | 747 | 747 | 1070 | 1070 | 1075 | 1075 | 1075 | 1075 | 1089 | 1092 | 1092 | 1092 | 1092 | 1089 | 1041 | 1041 | 1041 | 992 | 939 | 966 | 939 | Possible drop role RDB$ADMIN |
||
10 | CS | 2025.02.06 06:38 | 1277 | 764 | 913 | 875 | 913 | 913 | 943 | 1136 | 1328 | 1389 | 1389 | 1431 | 1450 | 1450 | 1450 | 1438 | 1438 | 1412 | 1412 | 1360 | 1412 | 1422 | 1422 | 1351 | 1451 | 1351 | Incorrect TEXT BLOB charset transliteration on VIEW with trigger |
||
11 | CS | 2022.02.02 14:46 | 1105 | 704 | 1147 | 806 | 806 | 806 | 806 | 806 | 1182 | 1182 | 1112 | 1112 | 1112 | 1112 | 1209 | 1209 | 1209 | 1172 | 1030 | 993 | 993 | 1047 | 993 | 830 | 1047 | 830 | Wrong data while retrieving from CTEs (or derived tables) with same column names |
||
12 | CS | 2022.02.02 14:46 | 1210 | 722 | 1210 | 1055 | 1055 | 1055 | 1055 | 1055 | 1263 | 1334 | 1337 | 1343 | 1343 | 1376 | 1407 | 1407 | 1376 | 1334 | 1274 | 1268 | 1268 | 1274 | 1274 | 890 | 1411 | 800 | Plan returned for query with recursive CTE return wrong count of parenthesis |
||
13 | CS | 2022.02.02 14:46 | 1061 | 614 | 882 | 824 | 824 | 824 | 855 | 855 | 1151 | 1196 | 1174 | 1188 | 1188 | 1235 | 1192 | 1210 | 1210 | 1192 | 1130 | 1111 | 1111 | 1113 | 1130 | 1113 | 1113 | 1101 | Window Function: cume_dist() |
||
14 | CS | 2022.02.02 14:46 | 1275 | 790 | 786 | 786 | 786 | 786 | 950 | 966 | 1362 | 1362 | 1343 | 1362 | 1362 | 1511 | 1511 | 1511 | 1502 | 1481 | 1391 | 1359 | 1359 | 1369 | 1369 | 1369 | 1396 | 1369 | MON$IO_STATS doesn't report page writes performed asynchronously (at the AST level) |
||
15 | SS | 2022.02.02 14:46 | 417 | 276 | 310 | 310 | 250 | 250 | 310 | 371 | 371 | 371 | 356 | 336 | 336 | 336 | 336 | 336 | 309 | 309 | 309 | 287 | 331 | 331 | 335 | 287 | 281 | 281 | isc_info_svc_user_dbpath always returns alias of main security database |
||
16 | SS | 2023.11.12 10:17 | 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 | 2268 | Provide ability to run "ALTER SQL SECURITY DEFINER / INVOKER" without specifying further part of proc/func/package |
||
17 | CS | 2024.01.12 15:40 | 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 | 912 | Inconsistent state of master-detail occurs after RE-connect + 'SET AUTODDL OFF' + 'drop <FK>' which is ROLLED BACK |
||
18 | CS | 2024.01.23 05:23 | 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 | 683 | System procedure/function inconsistency between ISQL SHOW FUNCTIONS and SHOW PROCEDURES |
||
19 | CS | 2025.04.16 17:03 | 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 | 1104 | Unnest IN/ANY/EXISTS subqueries and optimize them using semi-join algorithm |
||
20 | CS | 2024.10.26 08:21 | 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 | 740 | "Unique scan" is incorrectly reported in the explained plan for unique index and IS NULL predicate |
||
21 | CS | 2022.02.04 18:05 | 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 | 789 | AVOID index usage in WHERE <indexed_varchar_field> = <integer_value> |
||
22 | CS | 2022.02.04 18:05 | 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 | 1396 | Check correct work fix with foreign key |
||
23 | CS | 2022.02.04 18:05 | 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 | 725 | Zero divide in SP can crash database when call this SP several times |
NN | Test name | mode |
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
|
6.0.0.745
|
Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | CS | 1969 | 1147 | 1905 | 1171 | 2093 | 1119 | 2167 | 1299 | 1200 | 1130 | 1146 | 1099 | 2140 | 2087 | 2372 | 2053 | 1189 | 2253 | 2074 | 2137 | 1430 | 2007 | 1990 | 2245 | 2133 | 2054 | 2113 | 2230 | 2164 | 2235 | Server shutdown |
|
2 | CS | 1000 | 610 | 1088 | 561 | 1151 | 610 | 1007 | 606 | 608 | 620 | 644 | 631 | 1037 | 1083 | 1138 | 1052 | 1138 | 1208 | 1091 | 1155 | 684 | 1077 | 1122 | 1037 | 1178 | 1084 | 1169 | 1161 | 1162 | 1129 | Incorrect value returned with execute statement calculation |
|
3 | CS | 1043 | 637 | 1071 | 588 | 974 | 595 | 1206 | 616 | 554 | 623 | 587 | 581 | 1050 | 1191 | 1185 | 1093 | 1210 | 1209 | 1128 | 1112 | 663 | 1035 | 949 | 1158 | 1082 | 1108 | 1039 | 1045 | 1127 | 1212 | Navigation vs IS NULL vs compound index |
|
4 | CS | 2364 | 1407 | 2418 | 1383 | 2743 | 1455 | 1432 | 2501 | 1544 | 1471 | 2493 | 2458 | 2699 | 2365 | 2453 | 2604 | 2494 | 2686 | 2523 | 2687 | 1623 | 2576 | 2572 | 2224 | 1767 | 1807 | 1428 | 1442 | 1516 | 1589 | Services Manager and gsec truncate First.Middle.Last Name fields to 17 chars instead of 32 chars available in field definition |
|
5 | CS | 1291 | 729 | 1151 | 746 | 1271 | 741 | 811 | 1340 | 943 | 760 | 1277 | 1303 | 1309 | 1300 | 1239 | 1373 | 1513 | 1507 | 1350 | 1299 | 950 | 1348 | 1326 | 1320 | 977 | 912 | 671 | 760 | 776 | 766 | View with equally named source fields not faisible |
|
6 | SS | 1000 | 1038 | 1097 | X | X | X | X | X | X | X | X | X | 572 | 560 | 577 | 554 | 582 | 562 | 670 | 543 | 586 | 564 | 576 | 540 | 531 | 511 | 632 | 487 | 588 | 556 | User (not SYSDBA) that have privileges with grant option, can't revoke privileges, granted by other user or SYSDBA |
|
7 | CS | 1197 | 1158 | 642 | 1183 | 707 | 657 | 707 | 1135 | 1288 | 1256 | 636 | 647 | 1156 | 1145 | 1248 | 1174 | 1207 | 1274 | 1489 | 1156 | 859 | 1113 | 1208 | 694 | 778 | 1087 | 1131 | 887 | 1151 | 1103 | A remote attacker can check, if a file is present in the system, running firebird server |
|
8 | CS | 1036 | 620 | 1002 | 531 | 1058 | 635 | 586 | 591 | 639 | 1137 | 677 | 1089 | 1038 | 953 | 1013 | 1104 | 1168 | 1251 | 1123 | 1041 | 626 | 999 | 1142 | 604 | 849 | 665 | 1029 | 1120 | 564 | 646 | Aliases for the RETURNING clause |
|
9 | CS | 1021 | 564 | 1066 | 571 | 948 | 565 | 619 | 747 | 1070 | 1091 | 687 | 1104 | 957 | 1075 | 1089 | 953 | 1195 | 1114 | 1092 | 1089 | 647 | 1138 | 1041 | 574 | 1180 | 992 | 704 | 939 | 966 | 630 | Possible drop role RDB$ADMIN |
|
10 | CS | 1376 | 737 | 1293 | 724 | 1277 | 764 | 913 | 875 | 1328 | 1496 | 943 | 1136 | 1453 | 1389 | 1450 | 1431 | 1525 | 1480 | 1438 | 1360 | 893 | 1412 | 1422 | 836 | 1555 | 1511 | 846 | 1351 | 1451 | 825 | Incorrect TEXT BLOB charset transliteration on VIEW with trigger |
|
11 | CS | 1105 | 683 | 1147 | 704 | 1297 | 638 | 1216 | 806 | 662 | 1347 | 788 | 1182 | 1396 | 1112 | 1065 | 1074 | 1209 | 1237 | 1261 | 1030 | 789 | 1172 | 993 | 579 | 1114 | 1047 | 670 | 830 | 1144 | 562 | Wrong data while retrieving from CTEs (or derived tables) with same column names |
|
12 | CS | 1230 | 713 | 1252 | 703 | 1210 | 722 | 1329 | 1055 | 982 | 1263 | 843 | 1412 | 1334 | 1343 | 1337 | 1407 | 1376 | 1475 | 1415 | 1334 | 900 | 1268 | 1274 | 890 | 1423 | 1448 | 800 | 769 | 1411 | 778 | Plan returned for query with recursive CTE return wrong count of parenthesis |
|
13 | CS | 1138 | 613 | 1065 | 614 | 1061 | 591 | 882 | 824 | 641 | 1239 | 855 | 1196 | 1151 | 1235 | 1174 | 1188 | 1270 | 1304 | 1192 | 1210 | 779 | 1111 | 1130 | 688 | 1229 | 1113 | 1156 | 662 | 1101 | 725 | Window Function: cume_dist() |
|
14 | CS | 1303 | 790 | 1275 | 720 | 1283 | 707 | 786 | 950 | 758 | 1442 | 966 | 1381 | 1362 | 1343 | 1296 | 1511 | 1617 | 1553 | 1481 | 1502 | 966 | 1391 | 1359 | 819 | 1405 | 1369 | 1396 | 893 | 1520 | 713 | MON$IO_STATS doesn't report page writes performed asynchronously (at the AST level) |
|
15 | SS | 447 | 254 | 276 | 417 | 435 | 228 | 310 | 226 | 250 | 371 | 439 | 529 | 291 | 285 | 356 | 336 | 336 | 360 | 309 | 263 | 276 | 331 | 348 | 287 | 335 | 265 | 344 | 245 | 281 | 329 | isc_info_svc_user_dbpath always returns alias of main security database |
|
16 | SS | 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 | 1657 | Provide ability to run "ALTER SQL SECURITY DEFINER / INVOKER" without specifying further part of proc/func/package |
|
17 | CS | 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 | 783 | Inconsistent state of master-detail occurs after RE-connect + 'SET AUTODDL OFF' + 'drop <FK>' which is ROLLED BACK |
|
18 | CS | 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 | 683 | System procedure/function inconsistency between ISQL SHOW FUNCTIONS and SHOW PROCEDURES |
|
19 | CS | 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 | 1037 | Unnest IN/ANY/EXISTS subqueries and optimize them using semi-join algorithm |
|
20 | CS | 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 | 645 | "Unique scan" is incorrectly reported in the explained plan for unique index and IS NULL predicate |
|
21 | CS | 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 | 772 | AVOID index usage in WHERE <indexed_varchar_field> = <integer_value> |
|
22 | CS | 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 | 1435 | Check correct work fix with foreign key |
|
23 | CS | 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 | 690 | Zero divide in SP can crash database when call this SP several times |