| NN | Test name | mode |
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.1307
|
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 | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | E | With multiple trace sessions user may receive trace events related to engine's requests |
|
| 2 | SS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | E | With multiple trace sessions user may receive trace events related to engine's requests |
|
| 3 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | E | Services manager breaks long lines into 1023 bytes portions when using isc_info_svc_line in Service::query() |
|
| 4 | SS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | E | Services manager breaks long lines into 1023 bytes portions when using isc_info_svc_line in Service::query() |
|
| 5 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | E | P | X | X | X | X | X | X | X | Support for SINGULAR <subquery> |
|
| 6 | SS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | E | P | X | X | X | X | X | X | X | Support for SINGULAR <subquery> |
|
| 7 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Compiler check. Test ability to compile source code of OLTP-EMUL test. |
|
| 8 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Check that optimizer takes in account presense of index and does navigation instead of external sort. |
|
| 9 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Wrong (empty) result of query in Oracle 19 |
|
| 10 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Some _TRIVIAL_ queries allow to specify HAVING without group by, and for such case one may to get record from EMPTY source rowset(!) |
|
| 11 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Check ability to compile query with combination of full and right join. Taken from PG bug library. |
|
| 12 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | UPDATE/DETERE RETURNING should issue only one row when applying to table with self-referencing FK |
|
| 13 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | request of expression index could run outside of main request's snapshot. |
|
| 14 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Common SQL. Check correctness of the results |
|
| 15 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-01 |
|
| 16 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-02 |
|
| 17 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart. |
|
| 18 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | READ CONSISTENCY. Maximal number of statement-level restarts must be 10. |
|
| 19 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-01. |
|
| 20 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-02. |
|
| 21 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-03. |
|
| 22 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04. |
|
| 23 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-01. |
|
| 24 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-02. |
|
| 25 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-03. |
|
| 26 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04. |
|
| 27 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01. |
|
| 28 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02. |
|
| 29 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-03. |
|
| 30 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04. |
|
| 31 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TRIGGER - basic checks for DML triggers |
|
| 32 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | CREATE TRIGGER - basic checks for DML triggers |
|
| 33 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Trigger on database connect. See also CORE-745 |
|
| 34 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Error handling in trigger on database connect |
|
| 35 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Multiple triggers on database connect |
|
| 36 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Error handling when multiple triggers on database connect exist |
|
| 37 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Trigger on database disconnect: check that exception that raised when trigger fires is written to firebird.log |
|
| 38 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ON DISCONNECT trigger must fire during database shutdown (gfix -shut full -force 0). |
|
| 39 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ON DISCONNECT trigger must fire if attachment is deleted from MON$ATTACHMENTS by another attachment. |
|
| 40 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ON DISCONNECT trigger must fire if attachment is closed by IDLE timeout. |
|
| 41 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ON DISCONNECT trigger and OnDisconnectTriggerTimeout expiration |
|
| 42 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ON DISCONNECT trigger: print exceptions (including cancelling) to trace if log_errors = true |
|
| 43 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Multiple triggers on start transaction |
|
| 44 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Trigger on commit transaction. See also CORE-645 |
|
| 45 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Trigger on rollback transaction |
|
| 46 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Trigger on start tansaction |
|
| 47 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | gbak utility: check ability to use -ZIP command switch when create backup |
|
| 48 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | CREATE VIEW |
|
| 49 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | CREATE VIEW |
|
| 50 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | CREATE VIEW - bad number of columns |
|
| 51 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | CREATE VIEW |
|
| 52 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | CREATE VIEW - updateable |
|
| 53 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | CREATE VIEW - updateable WITH CHECK OPTION |
|
| 54 | SS | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | CREATE VIEW - updateable WITH CHECK OPTION |
| NN | Test name | mode | median_ms |
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.1307
|
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 | 6004 | 5991 | 5977 | 5985 | 6039 | 6020 | 6037 | 6036 | 5972 | 5991 | 5986 | 6026 | 5975 | 5973 | 6004 | 6037 | 5997 | 6041 | 6046 | 6032 | 6047 | 6027 | 6035 | 7023 | 6008 | 5994 | 5972 | 6020 | 5945 | 5972 | 5980 | 6004 | 6018 | 5998 | 5989 | 5025 | With multiple trace sessions user may receive trace events related to engine's requests |
|
| 2 | SS | 5641 | 5651 | 5633 | 5645 | 5652 | 5636 | 5658 | 5623 | 5649 | 5641 | 5638 | 5637 | 5631 | 5640 | 5807 | 5640 | 5642 | 5643 | 5642 | 5653 | 5634 | 5717 | 5648 | 5650 | 5601 | 5643 | 5630 | 5625 | 5623 | 5664 | 5647 | 5644 | 5611 | 5606 | 5611 | 5189 | With multiple trace sessions user may receive trace events related to engine's requests |
|
| 3 | CS | 3015 | 3017 | 3018 | 3015 | 3043 | 3059 | 3014 | 3011 | 3016 | 3013 | 3825 | 3015 | 3030 | 3014 | 3826 | 3050 | 3020 | 3038 | 3031 | 3034 | 3037 | 3015 | 3009 | 3005 | 2982 | 3566 | 2995 | 2984 | 2991 | 3022 | 2996 | 2986 | 2977 | 3000 | 2949 | 1932 | Services manager breaks long lines into 1023 bytes portions when using isc_info_svc_line in Service::query() |
|
| 4 | SS | 2699 | 2724 | 2699 | 2699 | 2703 | 2690 | 2710 | 2702 | 2702 | 2699 | 2705 | 2700 | 2703 | 2692 | 2737 | 2695 | 2702 | 2702 | 2731 | 2706 | 2757 | 2709 | 2704 | 2684 | 2656 | 2677 | 2667 | 2655 | 2675 | 2666 | 2679 | 2663 | 2657 | 2659 | 2661 | 1918 | Services manager breaks long lines into 1023 bytes portions when using isc_info_svc_line in Service::query() |
|
| 5 | CS | 840 | 835 | 866 | 837 | 843 | 834 | 865 | 866 | 838 | 842 | 843 | 837 | 828 | 820 | 833 | 833 | 863 | 955 | 872 | 875 | 900 | 841 | 905 | 840 | 817 | 810 | 802 | 514 | 1214 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Support for SINGULAR <subquery> |
|
| 6 | SS | 648 | 629 | 654 | 623 | 628 | 769 | 664 | 639 | 642 | 663 | 675 | 672 | 1179 | 670 | 626 | 661 | 651 | 641 | 649 | 653 | 647 | 632 | 666 | 643 | 618 | 612 | 595 | 611 | 1457 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Support for SINGULAR <subquery> |
|
| 7 | SS | 1440 | 1426 | 1405 | 1561 | 7178 | 1393 | 1643 | 1410 | 1440 | 1610 | 1407 | 1399 | 1720 | 1403 | 1647 | 1671 | 1937 | 1662 | 1500 | 1435 | 1677 | 1434 | 1651 | 1328 | 1312 | 1299 | 1607 | 1314 | 1608 | 1602 | 1331 | 1332 | 1340 | 1660 | 1594 | 1365 | Compiler check. Test ability to compile source code of OLTP-EMUL test. |
|
| 8 | SS | 910 | 909 | 920 | 910 | 2247 | 928 | 934 | 983 | 914 | 969 | 899 | 893 | 909 | 902 | 909 | 1000 | 1276 | 910 | 1005 | 929 | 929 | 910 | 922 | 904 | 902 | 899 | 884 | 892 | 917 | 887 | 890 | 903 | 959 | 894 | 875 | 909 | Check that optimizer takes in account presense of index and does navigation instead of external sort. |
|
| 9 | SS | 406 | 409 | 453 | 410 | 2438 | 408 | 411 | 425 | 408 | 425 | 400 | 394 | 406 | 405 | 406 | 408 | 509 | 406 | 408 | 407 | 401 | 404 | 407 | 394 | 375 | 386 | 384 | 392 | 391 | 389 | 381 | 384 | 381 | 390 | 359 | 407 | Wrong (empty) result of query in Oracle 19 |
|
| 10 | SS | 393 | 407 | 405 | 403 | 2240 | 401 | 390 | 421 | 396 | 393 | 400 | 395 | 402 | 398 | 389 | 408 | 467 | 409 | 392 | 404 | 387 | 393 | 396 | 391 | 376 | 375 | 375 | 375 | 377 | 383 | 379 | 379 | 360 | 377 | 359 | 398 | Some _TRIVIAL_ queries allow to specify HAVING without group by, and for such case one may to get record from EMPTY source rowset(!) |
|
| 11 | SS | 407 | 407 | 411 | 404 | 2402 | 408 | 442 | 406 | 405 | 414 | 410 | 396 | 407 | 404 | 408 | 413 | 489 | 409 | 408 | 407 | 412 | 413 | 392 | 390 | 374 | 371 | 388 | 378 | 387 | 388 | 398 | 372 | 386 | 426 | 375 | 420 | Check ability to compile query with combination of full and right join. Taken from PG bug library. |
|
| 12 | SS | 406 | 423 | 421 | 403 | 2420 | 406 | 422 | 412 | 404 | 442 | 403 | 406 | 424 | 411 | 417 | 430 | 511 | 408 | 410 | 414 | 412 | 421 | 403 | 399 | 390 | 374 | 388 | 388 | 393 | 392 | 391 | 380 | 383 | 393 | 375 | 408 | UPDATE/DETERE RETURNING should issue only one row when applying to table with self-referencing FK |
|
| 13 | SS | 407 | 408 | 404 | 408 | 2457 | 406 | 417 | 426 | 405 | 425 | 412 | 411 | 421 | 442 | 408 | 423 | 489 | 422 | 420 | 420 | 411 | 402 | 407 | 400 | 390 | 377 | 388 | 393 | 386 | 377 | 392 | 393 | 374 | 394 | 375 | 407 | request of expression index could run outside of main request's snapshot. |
|
| 14 | SS | 740 | 750 | 747 | 744 | 4150 | 739 | 740 | 752 | 740 | 739 | 756 | 724 | 752 | 741 | 745 | 737 | 962 | 739 | 756 | 757 | 754 | 735 | 740 | 716 | 717 | 731 | 720 | 727 | 726 | 726 | 720 | 743 | 723 | 725 | 688 | 750 | Common SQL. Check correctness of the results |
|
| 15 | SS | 5921 | 5921 | 6193 | 5924 | 2229 | 5914 | 5937 | 5964 | 5933 | 5911 | 5945 | 5894 | 5922 | 6147 | 5935 | 5939 | 6119 | 5945 | 5932 | 5915 | 5921 | 5934 | 5931 | 5884 | 5897 | 5878 | 5893 | 5860 | 5884 | 5912 | 5876 | 5905 | 5881 | 5903 | 5815 | 5933 | READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-01 |
|
| 16 | SS | 5874 | 5880 | 5883 | 5881 | 2437 | 5889 | 5896 | 5882 | 5874 | 5853 | 5886 | 5851 | 5874 | 5868 | 5933 | 5881 | 6131 | 5918 | 5898 | 5896 | 5875 | 5879 | 5878 | 5860 | 5854 | 5871 | 5850 | 5843 | 5858 | 5854 | 5846 | 5852 | 5860 | 5874 | 5733 | 5897 | READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-02 |
|
| 17 | SS | 5915 | 5921 | 5932 | 5899 | 2448 | 5902 | 5915 | 5922 | 5931 | 5923 | 5931 | 5933 | 5920 | 5893 | 5907 | 5915 | 6049 | 5926 | 5927 | 5947 | 5936 | 5919 | 5938 | 5903 | 5883 | 5900 | 5852 | 5896 | 5919 | 5915 | 5900 | 5881 | 5914 | 5894 | 5790 | 5914 | READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart. |
|
| 18 | SS | 41338 | 43474 | 43711 | 42972 | 2235 | 41666 | 41379 | 41280 | 41336 | 41235 | 41467 | 41303 | 41338 | 41450 | 41478 | 41230 | 41675 | 41267 | 41351 | 41504 | 42840 | 41386 | 41600 | 41218 | 41126 | 41222 | 41165 | 41185 | 41321 | 41365 | 41224 | 41318 | 42858 | 41317 | 40430 | 41572 | READ CONSISTENCY. Maximal number of statement-level restarts must be 10. |
|
| 19 | SS | 5896 | 5897 | 5984 | 6143 | 2436 | 5895 | 5879 | 5905 | 5909 | 5898 | 5894 | 5902 | 5925 | 5874 | 5900 | 5923 | 6155 | 5888 | 5945 | 5937 | 5880 | 5894 | 5891 | 5856 | 5870 | 5899 | 5851 | 5856 | 5857 | 6849 | 6882 | 5880 | 5896 | 5897 | 5751 | 5891 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-01. |
|
| 20 | SS | 5888 | 5882 | 5915 | 5877 | 2257 | 5892 | 5898 | 5937 | 5884 | 5888 | 5926 | 5896 | 5885 | 5890 | 5905 | 5900 | 5908 | 5881 | 5880 | 5890 | 5887 | 5917 | 5895 | 5861 | 5861 | 5870 | 5857 | 5862 | 5876 | 5840 | 5862 | 5891 | 6074 | 5930 | 5749 | 5891 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-02. |
|
| 21 | SS | 6209 | 6204 | 6198 | 7259 | 2455 | 6223 | 6402 | 6245 | 6209 | 6175 | 6212 | 6178 | 6236 | 6207 | 6214 | 6217 | 6239 | 6241 | 6205 | 6422 | 6230 | 6204 | 6219 | 6229 | 6168 | 6169 | 6195 | 6171 | 6176 | 6440 | 6174 | 6163 | 6558 | 6256 | 6063 | 6195 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-03. |
|
| 22 | SS | 5896 | 5864 | 5870 | 5966 | 2427 | 5903 | 5900 | 5910 | 5921 | 5890 | 5895 | 5896 | 5872 | 5903 | 5899 | 5905 | 6084 | 5897 | 5895 | 5884 | 5898 | 5961 | 5884 | 5881 | 5867 | 5875 | 5850 | 5843 | 5932 | 6876 | 5863 | 5873 | 5906 | 5906 | 5753 | 6016 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04. |
|
| 23 | SS | 5876 | 5873 | 5879 | 5879 | 2434 | 5865 | 5873 | 5845 | 5890 | 5900 | 5882 | 5865 | 5914 | 5906 | 5888 | 5867 | 5876 | 5886 | 5873 | 6177 | 6115 | 5955 | 5903 | 5864 | 5888 | 5809 | 5846 | 5844 | 5860 | 5850 | 5843 | 5847 | 5879 | 5896 | 5755 | 5881 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-01. |
|
| 24 | SS | 5899 | 6082 | 5899 | 5903 | 2245 | 5894 | 5959 | 5885 | 5871 | 5903 | 5901 | 5896 | 5891 | 5897 | 5899 | 5906 | 5879 | 5909 | 5895 | 5907 | 5909 | 5944 | 5898 | 5878 | 5906 | 5906 | 5918 | 5881 | 5883 | 5920 | 5845 | 5879 | 5900 | 5922 | 5782 | 5946 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-02. |
|
| 25 | SS | 6201 | 6465 | 6518 | 6186 | 2421 | 6231 | 6216 | 6176 | 6192 | 6188 | 6204 | 6209 | 6206 | 6194 | 6218 | 6246 | 6257 | 6225 | 6225 | 6380 | 6201 | 6228 | 6181 | 6201 | 6148 | 6200 | 6150 | 6167 | 6161 | 6187 | 6168 | 6192 | 6226 | 6229 | 6066 | 6654 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-03. |
|
| 26 | SS | 5890 | 5865 | 5873 | 5887 | 2467 | 5899 | 5935 | 5897 | 5891 | 5896 | 5895 | 5890 | 5885 | 5908 | 5918 | 5894 | 5862 | 5890 | 5903 | 5881 | 5896 | 5884 | 5940 | 5868 | 5871 | 5849 | 5873 | 5860 | 5895 | 5866 | 5930 | 5875 | 6395 | 6419 | 5751 | 5923 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04. |
|
| 27 | SS | 5887 | 5900 | 5886 | 5887 | 2257 | 5913 | 5898 | 5898 | 5886 | 5907 | 5917 | 5887 | 5894 | 5891 | 5916 | 5898 | 6168 | 5893 | 5892 | 5887 | 5885 | 5916 | 5920 | 5860 | 5844 | 5847 | 5852 | 5857 | 5871 | 5843 | 5868 | 5871 | 5944 | 5881 | 5752 | 5889 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01. |
|
| 28 | SS | 5906 | 5919 | 5896 | 5915 | 2445 | 5929 | 6917 | 5897 | 5914 | 5888 | 5907 | 5955 | 5903 | 5922 | 5951 | 5880 | 5902 | 5910 | 5906 | 5917 | 5886 | 5927 | 5906 | 5883 | 5873 | 5869 | 5896 | 5891 | 5878 | 6370 | 5857 | 5917 | 5940 | 5965 | 5786 | 5901 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02. |
|
| 29 | SS | 6518 | 6184 | 6932 | 6175 | 2234 | 7439 | 6193 | 6427 | 6698 | 6952 | 7130 | 6958 | 5899 | 7159 | 6427 | 6518 | 7639 | 6178 | 6945 | 6961 | 6707 | 6707 | 6963 | 6680 | 6148 | 6420 | 7145 | 5914 | 6130 | 7465 | 6133 | 6143 | 6426 | 6640 | 6056 | 5952 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-03. |
|
| 30 | SS | 5892 | 5891 | 6090 | 6083 | 2424 | 6054 | 5899 | 5926 | 5890 | 5927 | 5905 | 5899 | 5889 | 5898 | 5890 | 5907 | 5911 | 5910 | 5892 | 5874 | 5898 | 5909 | 5900 | 5861 | 5839 | 5856 | 5881 | 5859 | 5874 | 5867 | 5867 | 5866 | 6421 | 5913 | 5771 | 5878 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04. |
|
| 31 | SS | 450 | 607 | 464 | 453 | 2446 | 456 | 980 | 461 | 451 | 450 | 478 | 434 | 452 | 448 | 447 | 444 | 449 | 456 | 447 | 446 | 450 | 451 | 452 | 431 | 425 | 431 | 424 | 428 | 440 | 419 | 420 | 434 | 466 | 451 | 422 | 476 | ALTER TRIGGER - basic checks for DML triggers |
|
| 32 | SS | 1049 | 1057 | 1107 | 1058 | 2457 | 1041 | 1055 | 1117 | 1052 | 1063 | 1083 | 1021 | 1039 | 1036 | 1054 | 1046 | 1038 | 1043 | 1042 | 1055 | 1082 | 1039 | 1053 | 1044 | 1032 | 1004 | 1026 | 1011 | 1032 | 1273 | 1049 | 1037 | 1130 | 1118 | 1000 | 1086 | CREATE TRIGGER - basic checks for DML triggers |
|
| 33 | SS | 547 | 553 | 562 | 560 | 2238 | 540 | 543 | 564 | 547 | 541 | 592 | 547 | 546 | 547 | 543 | 541 | 588 | 547 | 552 | 555 | 556 | 544 | 548 | 532 | 524 | 531 | 526 | 528 | 522 | 527 | 515 | 526 | 582 | 576 | 516 | 571 | Trigger on database connect. See also CORE-745 |
|
| 34 | SS | 1113 | 1124 | 1154 | 1101 | 2430 | 1125 | 1102 | 1168 | 1111 | 1110 | 1139 | 1091 | 1111 | 1103 | 1147 | 1117 | 1109 | 1121 | 1116 | 1119 | 1098 | 1113 | 1121 | 1106 | 1101 | 1099 | 1113 | 1110 | 1108 | 1092 | 1126 | 1098 | 1230 | 1245 | 1093 | 1139 | Error handling in trigger on database connect |
|
| 35 | SS | 555 | 555 | 577 | 561 | 2238 | 593 | 588 | 567 | 555 | 554 | 579 | 544 | 536 | 556 | 558 | 547 | 582 | 558 | 552 | 547 | 559 | 598 | 552 | 556 | 539 | 533 | 526 | 533 | 527 | 522 | 535 | 548 | 559 | 588 | 516 | 560 | Multiple triggers on database connect |
|
| 36 | SS | 1120 | 1124 | 1112 | 1126 | 2444 | 1093 | 1116 | 1126 | 1139 | 1122 | 1120 | 1099 | 1115 | 1090 | 1122 | 1115 | 1130 | 1116 | 1114 | 1105 | 1124 | 1124 | 1137 | 1105 | 1092 | 1083 | 1127 | 1115 | 1122 | 1125 | 1115 | 1116 | 1203 | 1253 | 1094 | 1168 | Error handling when multiple triggers on database connect exist |
|
| 37 | SS | 1870 | 1949 | 1933 | 2032 | 2429 | 1868 | 2302 | 1854 | 1959 | 1849 | 1954 | 1847 | 1845 | 1852 | 1870 | 1893 | 1943 | 1855 | 1870 | 1970 | 2216 | 1869 | 1868 | 1856 | 1846 | 1842 | 1823 | 1845 | 1848 | 1934 | 1936 | 1877 | 2417 | 1930 | 1816 | 1891 | Trigger on database disconnect: check that exception that raised when trigger fires is written to firebird.log |
|
| 38 | SS | 948 | 957 | 946 | 979 | 2443 | 953 | 965 | 966 | 956 | 933 | 964 | 949 | 929 | 935 | 934 | 961 | 981 | 970 | 935 | 957 | 963 | 937 | 946 | 941 | 918 | 920 | 948 | 940 | 938 | 918 | 919 | 946 | 1031 | 1008 | 906 | 1093 | ON DISCONNECT trigger must fire during database shutdown (gfix -shut full -force 0). |
|
| 39 | SS | 896 | 893 | 924 | 925 | 2243 | 918 | 903 | 918 | 904 | 886 | 914 | 879 | 892 | 889 | 903 | 908 | 895 | 917 | 896 | 923 | 911 | 899 | 888 | 895 | 880 | 888 | 882 | 891 | 887 | 896 | 892 | 891 | 945 | 930 | 859 | 935 | ON DISCONNECT trigger must fire if attachment is deleted from MON$ATTACHMENTS by another attachment. |
|
| 40 | SS | 5899 | 5907 | 5905 | 5924 | 2438 | 5913 | 6306 | 5902 | 5894 | 5897 | 5899 | 5896 | 5891 | 5884 | 5887 | 5888 | 5921 | 5904 | 5896 | 5901 | 5907 | 5901 | 5896 | 5899 | 5883 | 5865 | 5870 | 5896 | 5900 | 6361 | 5877 | 5888 | 5930 | 5953 | 5859 | 5922 | ON DISCONNECT trigger must fire if attachment is closed by IDLE timeout. |
|
| 41 | SS | 5228 | 6357 | 6006 | 5989 | 2454 | 5231 | 5532 | 5227 | 5228 | 5197 | 5199 | 5237 | 5260 | 5212 | 5202 | 5222 | 5247 | 5212 | 5218 | 5264 | 5276 | 5234 | 5998 | 5977 | 5920 | 5162 | 5211 | 5208 | 6023 | 5234 | 5188 | 5206 | 5222 | 5244 | 5145 | 5228 | ON DISCONNECT trigger and OnDisconnectTriggerTimeout expiration |
|
| 42 | SS | 3131 | 3126 | 3125 | 3560 | 2245 | 3123 | 3160 | 3159 | 3141 | 3130 | 3131 | 3138 | 3174 | 3135 | 3132 | 3120 | 3132 | 3140 | 3147 | 3118 | 3123 | 3120 | 3124 | 3153 | 3116 | 3113 | 3176 | 3112 | 3123 | 3124 | 3114 | 3134 | 3200 | 3189 | 3068 | 3136 | ON DISCONNECT trigger: print exceptions (including cancelling) to trace if log_errors = true |
|
| 43 | SS | 406 | 433 | 415 | 411 | 2444 | 401 | 411 | 420 | 419 | 403 | 402 | 401 | 421 | 411 | 400 | 406 | 412 | 425 | 426 | 407 | 399 | 426 | 425 | 390 | 386 | 370 | 391 | 386 | 396 | 412 | 383 | 391 | 412 | 405 | 391 | 401 | Multiple triggers on start transaction |
|
| 44 | SS | 562 | 577 | 560 | 558 | 2443 | 572 | 565 | 584 | 571 | 568 | 564 | 555 | 561 | 569 | 555 | 564 | 565 | 562 | 573 | 560 | 563 | 554 | 576 | 544 | 541 | 530 | 535 | 534 | 560 | 522 | 533 | 530 | 572 | 577 | 516 | 565 | Trigger on commit transaction. See also CORE-645 |
|
| 45 | SS | 410 | 406 | 424 | 654 | 2240 | 425 | 410 | 418 | 424 | 408 | 421 | 401 | 426 | 405 | 417 | 414 | 407 | 405 | 420 | 410 | 403 | 417 | 438 | 412 | 382 | 394 | 401 | 393 | 386 | 924 | 398 | 388 | 431 | 406 | 375 | 416 | Trigger on rollback transaction |
|
| 46 | SS | 407 | 580 | 404 | 413 | 2452 | 408 | 408 | 409 | 403 | 405 | 414 | 405 | 408 | 407 | 407 | 441 | 406 | 408 | 412 | 412 | 406 | 406 | 409 | 403 | 391 | 385 | 387 | 389 | 390 | 441 | 387 | 389 | 411 | 412 | 375 | 404 | Trigger on start tansaction |
|
| 47 | SS | 4580 | 4779 | 4591 | 5029 | 2507 | 4545 | 4580 | 4551 | 4576 | 4593 | 4844 | 4580 | 4595 | 4551 | 4546 | 4564 | 4577 | 4618 | 4579 | 4589 | 4999 | 4609 | 4588 | 4505 | 4440 | 4630 | 4509 | 4462 | 4498 | 4871 | 4466 | 4461 | 4622 | 4621 | 4329 | 4630 | gbak utility: check ability to use -ZIP command switch when create backup |
|
| 48 | SS | 405 | 412 | 404 | 415 | 2310 | 404 | 408 | 408 | 415 | 401 | 400 | 394 | 417 | 395 | 407 | 405 | 419 | 410 | 398 | 410 | 408 | 409 | 412 | 404 | 398 | 413 | 377 | 382 | 392 | 384 | 399 | 386 | 405 | 405 | 375 | 427 | CREATE VIEW |
|
| 49 | SS | 406 | 407 | 476 | 413 | 2435 | 419 | 408 | 408 | 403 | 405 | 412 | 409 | 399 | 391 | 401 | 409 | 415 | 401 | 404 | 409 | 417 | 406 | 409 | 392 | 393 | 384 | 379 | 387 | 375 | 391 | 378 | 392 | 413 | 410 | 375 | 427 | CREATE VIEW |
|
| 50 | SS | 397 | 421 | 399 | 400 | 2237 | 433 | 406 | 396 | 411 | 394 | 392 | 413 | 391 | 392 | 403 | 401 | 412 | 391 | 393 | 404 | 396 | 410 | 397 | 385 | 388 | 418 | 374 | 374 | 388 | 375 | 381 | 375 | 403 | 399 | 375 | 406 | CREATE VIEW - bad number of columns |
|
| 51 | SS | 563 | 592 | 563 | 563 | 2423 | 568 | 554 | 563 | 559 | 564 | 550 | 571 | 579 | 551 | 556 | 568 | 561 | 578 | 556 | 582 | 579 | 547 | 564 | 604 | 535 | 569 | 537 | 531 | 545 | 531 | 540 | 533 | 562 | 577 | 500 | 564 | CREATE VIEW |
|
| 52 | SS | 555 | 564 | 861 | 549 | 2445 | 578 | 561 | 559 | 553 | 553 | 583 | 544 | 548 | 544 | 559 | 569 | 561 | 561 | 565 | 561 | 565 | 555 | 565 | 536 | 533 | 537 | 544 | 534 | 526 | 533 | 534 | 532 | 566 | 539 | 516 | 569 | CREATE VIEW - updateable |
|
| 53 | SS | 556 | 567 | 560 | 570 | 2245 | 556 | 549 | 551 | 548 | 575 | 575 | 556 | 571 | 555 | 587 | 561 | 611 | 552 | 551 | 555 | 562 | 547 | 565 | 575 | 536 | 566 | 556 | 537 | 529 | 536 | 550 | 528 | 567 | 549 | 500 | 550 | CREATE VIEW - updateable WITH CHECK OPTION |
|
| 54 | SS | 406 | 408 | 410 | 406 | 2424 | 412 | 419 | 413 | 396 | 415 | 409 | 405 | 414 | 401 | 407 | 409 | 414 | 404 | 406 | 404 | 458 | 404 | 404 | 392 | 375 | 377 | 379 | 392 | 390 | 382 | 384 | 394 | 493 | 411 | 375 | 407 | CREATE VIEW - updateable WITH CHECK OPTION |