| NN | Test name | mode |
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.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
|
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 | E | P | X | X | Support for SINGULAR <subquery> |
|
| 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 | E | P | X | X | Support for SINGULAR <subquery> |
|
| 3 | SS | P | P | P | P | P | 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 | Compiler check. Test ability to compile source code of OLTP-EMUL test. |
|
| 4 | SS | P | P | P | P | P | 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 | Check that optimizer takes in account presense of index and does navigation instead of external sort. |
|
| 5 | SS | P | P | P | P | P | 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 | Wrong (empty) result of query in Oracle 19 |
|
| 6 | SS | P | P | P | P | P | 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 | Some _TRIVIAL_ queries allow to specify HAVING without group by, and for such case one may to get record from EMPTY source rowset(!) |
|
| 7 | SS | P | P | P | P | P | 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 | Check ability to compile query with combination of full and right join. Taken from PG bug library. |
|
| 8 | SS | P | P | P | P | P | 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 | UPDATE/DETERE RETURNING should issue only one row when applying to table with self-referencing FK |
|
| 9 | SS | P | P | P | P | P | 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 | request of expression index could run outside of main request's snapshot. |
|
| 10 | SS | P | P | P | P | P | 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 | Common SQL. Check correctness of the results |
|
| 11 | SS | P | P | P | P | P | 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 | READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-01 |
|
| 12 | SS | P | P | P | P | P | 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 | READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-02 |
|
| 13 | SS | P | P | P | P | P | 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 | READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart. |
|
| 14 | SS | P | P | P | P | P | 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 | READ CONSISTENCY. Maximal number of statement-level restarts must be 10. |
|
| 15 | SS | P | P | P | P | P | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-01. |
|
| 16 | SS | P | P | P | P | P | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-02. |
|
| 17 | SS | P | P | P | P | P | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-03. |
|
| 18 | SS | P | P | P | P | P | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04. |
|
| 19 | SS | P | P | P | P | P | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-01. |
|
| 20 | SS | P | P | P | P | P | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-02. |
|
| 21 | SS | P | P | P | P | P | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-03. |
|
| 22 | SS | P | P | P | P | P | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04. |
|
| 23 | SS | P | P | P | P | P | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01. |
|
| 24 | SS | P | P | P | P | P | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02. |
|
| 25 | SS | P | P | P | P | P | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-03. |
|
| 26 | SS | P | P | P | P | P | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04. |
|
| 27 | SS | P | P | P | P | P | 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 | ALTER TRIGGER - basic checks for DML triggers |
|
| 28 | SS | P | P | P | P | P | 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 | CREATE TRIGGER - basic checks for DML triggers |
|
| 29 | SS | P | P | P | P | P | 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 | Trigger on database connect. See also CORE-745 |
|
| 30 | SS | P | P | P | P | P | 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 | Error handling in trigger on database connect |
|
| 31 | SS | P | P | P | P | P | 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 | Multiple triggers on database connect |
|
| 32 | SS | P | P | P | P | P | 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 | Error handling when multiple triggers on database connect exist |
|
| 33 | SS | P | P | P | P | P | 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 | Trigger on database disconnect: check that exception that raised when trigger fires is written to firebird.log |
|
| 34 | SS | P | P | P | P | P | 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 | ON DISCONNECT trigger must fire during database shutdown (gfix -shut full -force 0). |
|
| 35 | SS | P | P | P | P | P | 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 | ON DISCONNECT trigger must fire if attachment is deleted from MON$ATTACHMENTS by another attachment. |
|
| 36 | SS | P | P | P | P | P | 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 | ON DISCONNECT trigger must fire if attachment is closed by IDLE timeout. |
|
| 37 | SS | P | P | P | P | P | 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 | ON DISCONNECT trigger and OnDisconnectTriggerTimeout expiration |
|
| 38 | SS | P | P | P | P | P | 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 | ON DISCONNECT trigger: print exceptions (including cancelling) to trace if log_errors = true |
|
| 39 | SS | P | P | P | P | P | 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 | Multiple triggers on start transaction |
|
| 40 | SS | P | P | P | P | P | 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 | Trigger on commit transaction. See also CORE-645 |
|
| 41 | SS | P | P | P | P | P | 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 | Trigger on rollback transaction |
|
| 42 | SS | P | P | P | P | P | 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 | Trigger on start tansaction |
|
| 43 | SS | P | P | P | P | P | 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 | gbak utility: check ability to use -ZIP command switch when create backup |
|
| 44 | SS | P | P | P | P | P | 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 | CREATE VIEW |
|
| 45 | SS | P | P | P | P | P | 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 | CREATE VIEW |
|
| 46 | SS | P | P | P | P | P | 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 | CREATE VIEW - bad number of columns |
|
| 47 | SS | P | P | P | P | P | 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 | CREATE VIEW |
|
| 48 | SS | P | P | P | P | P | 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 | CREATE VIEW - updateable |
|
| 49 | SS | P | P | P | P | P | 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 | CREATE VIEW - updateable WITH CHECK OPTION |
|
| 50 | SS | P | P | P | P | P | 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 | CREATE VIEW - updateable WITH CHECK OPTION |
| NN | Test name | mode | median_ms |
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.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
|
Test TITLE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | CS | 840 | 832 | 832 | 837 | 843 | 873 | 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 | Support for SINGULAR <subquery> |
|
| 2 | SS | 647 | 642 | 638 | 670 | 814 | 643 | 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 | Support for SINGULAR <subquery> |
|
| 3 | SS | 1500 | 1593 | 1766 | 1469 | 1500 | 1414 | 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 | Compiler check. Test ability to compile source code of OLTP-EMUL test. |
|
| 4 | SS | 916 | 924 | 916 | 916 | 917 | 918 | 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 | Check that optimizer takes in account presense of index and does navigation instead of external sort. |
|
| 5 | SS | 407 | 404 | 409 | 408 | 409 | 412 | 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 | Wrong (empty) result of query in Oracle 19 |
|
| 6 | SS | 396 | 395 | 401 | 411 | 409 | 399 | 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 | Some _TRIVIAL_ queries allow to specify HAVING without group by, and for such case one may to get record from EMPTY source rowset(!) |
|
| 7 | SS | 407 | 408 | 405 | 435 | 417 | 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 | Check ability to compile query with combination of full and right join. Taken from PG bug library. |
|
| 8 | SS | 411 | 435 | 407 | 417 | 437 | 422 | 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 | UPDATE/DETERE RETURNING should issue only one row when applying to table with self-referencing FK |
|
| 9 | SS | 408 | 423 | 407 | 405 | 419 | 417 | 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 | request of expression index could run outside of main request's snapshot. |
|
| 10 | SS | 741 | 750 | 751 | 753 | 750 | 757 | 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 | Common SQL. Check correctness of the results |
|
| 11 | SS | 5924 | 5938 | 5929 | 5983 | 5931 | 5908 | 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 | READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-01 |
|
| 12 | SS | 5874 | 5871 | 5854 | 5871 | 5936 | 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 | READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-02 |
|
| 13 | SS | 5920 | 5957 | 5924 | 5917 | 5924 | 5920 | 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 | READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart. |
|
| 14 | SS | 41365 | 42308 | 41400 | 41305 | 42942 | 42160 | 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 | READ CONSISTENCY. Maximal number of statement-level restarts must be 10. |
|
| 15 | SS | 5897 | 5904 | 5866 | 6150 | 5885 | 5883 | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-01. |
|
| 16 | SS | 5888 | 5883 | 5895 | 5908 | 5899 | 5894 | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-02. |
|
| 17 | SS | 6212 | 6213 | 6209 | 6246 | 6230 | 6206 | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-03. |
|
| 18 | SS | 5896 | 5902 | 5893 | 5882 | 5909 | 5900 | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04. |
|
| 19 | SS | 5878 | 5892 | 5878 | 5862 | 5911 | 5947 | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-01. |
|
| 20 | SS | 5897 | 5884 | 5883 | 5880 | 5888 | 5887 | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-02. |
|
| 21 | SS | 6201 | 6256 | 6239 | 6213 | 6201 | 6190 | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-03. |
|
| 22 | SS | 5890 | 5891 | 5882 | 5884 | 5883 | 6250 | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04. |
|
| 23 | SS | 5891 | 5897 | 5891 | 5884 | 5904 | 5872 | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01. |
|
| 24 | SS | 5906 | 5915 | 5907 | 5900 | 5923 | 5916 | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02. |
|
| 25 | SS | 6698 | 6428 | 7706 | 5919 | 6946 | 6961 | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-03. |
|
| 26 | SS | 5892 | 5896 | 5884 | 5891 | 5902 | 5884 | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04. |
|
| 27 | SS | 450 | 458 | 447 | 458 | 464 | 954 | 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 | ALTER TRIGGER - basic checks for DML triggers |
|
| 28 | SS | 1051 | 1057 | 1031 | 1083 | 1059 | 1051 | 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 | CREATE TRIGGER - basic checks for DML triggers |
|
| 29 | SS | 546 | 543 | 545 | 561 | 546 | 542 | 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 | Trigger on database connect. See also CORE-745 |
|
| 30 | SS | 1113 | 1117 | 1089 | 1145 | 1158 | 1104 | 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 | Error handling in trigger on database connect |
|
| 31 | SS | 554 | 539 | 541 | 566 | 543 | 534 | 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 | Multiple triggers on database connect |
|
| 32 | SS | 1122 | 1126 | 1085 | 1144 | 1126 | 1125 | 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 | Error handling when multiple triggers on database connect exist |
|
| 33 | SS | 1870 | 1936 | 1857 | 1888 | 1936 | 1968 | 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 | Trigger on database disconnect: check that exception that raised when trigger fires is written to firebird.log |
|
| 34 | SS | 949 | 970 | 936 | 987 | 962 | 949 | 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 | ON DISCONNECT trigger must fire during database shutdown (gfix -shut full -force 0). |
|
| 35 | SS | 896 | 891 | 907 | 880 | 909 | 917 | 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 | ON DISCONNECT trigger must fire if attachment is deleted from MON$ATTACHMENTS by another attachment. |
|
| 36 | SS | 5899 | 5924 | 5906 | 5909 | 5908 | 5895 | 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 | ON DISCONNECT trigger must fire if attachment is closed by IDLE timeout. |
|
| 37 | SS | 5231 | 5226 | 6032 | 5210 | 5246 | 5219 | 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 | ON DISCONNECT trigger and OnDisconnectTriggerTimeout expiration |
|
| 38 | SS | 3131 | 3142 | 3128 | 3134 | 3149 | 3162 | 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 | ON DISCONNECT trigger: print exceptions (including cancelling) to trace if log_errors = true |
|
| 39 | SS | 411 | 428 | 425 | 415 | 414 | 421 | 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 | Multiple triggers on start transaction |
|
| 40 | SS | 562 | 555 | 560 | 566 | 581 | 581 | 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 | Trigger on commit transaction. See also CORE-645 |
|
| 41 | SS | 410 | 410 | 410 | 406 | 603 | 414 | 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 | Trigger on rollback transaction |
|
| 42 | SS | 408 | 409 | 404 | 417 | 409 | 408 | 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 | Trigger on start tansaction |
|
| 43 | SS | 4580 | 4559 | 4575 | 4621 | 4583 | 4591 | 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 | gbak utility: check ability to use -ZIP command switch when create backup |
|
| 44 | SS | 405 | 404 | 430 | 403 | 413 | 403 | 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 | CREATE VIEW |
|
| 45 | SS | 406 | 422 | 406 | 412 | 409 | 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 | CREATE VIEW |
|
| 46 | SS | 400 | 401 | 409 | 402 | 402 | 409 | 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 | CREATE VIEW - bad number of columns |
|
| 47 | SS | 563 | 553 | 551 | 567 | 604 | 567 | 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 | CREATE VIEW |
|
| 48 | SS | 559 | 563 | 561 | 563 | 562 | 556 | 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 | CREATE VIEW - updateable |
|
| 49 | SS | 560 | 562 | 549 | 569 | 562 | 577 | 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 | CREATE VIEW - updateable WITH CHECK OPTION |
|
| 50 | SS | 406 | 406 | 394 | 416 | 435 | 415 | 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 | CREATE VIEW - updateable WITH CHECK OPTION |