| ij> AUTOCOMMIT OFF; |
| ij> -- MODULE DML012 |
| |
| -- SQL Test Suite, V6.0, Interactive SQL, dml012.sql |
| -- 59-byte ID |
| -- TEd Version # |
| |
| -- AUTHORIZATION HU |
| set schema HU; |
| 0 rows inserted/updated/deleted |
| ij> --0 SELECT USER FROM HU.ECCO; |
| VALUES USER; |
| 1 |
| -------------------------------------------------------------------------------------------------------------------------------- |
| HU |
| ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment |
| |
| -- date_time print |
| |
| -- TEST:0037 DELETE without WHERE clause! |
| SELECT COUNT(*) |
| FROM STAFF; |
| 1 |
| ----------- |
| 5 |
| ij> -- PASS:0037 If count = 5? |
| |
| DELETE FROM STAFF; |
| 5 rows inserted/updated/deleted |
| ij> -- PASS:0037 If 5 rows deleted? |
| |
| SELECT COUNT(*) |
| FROM STAFF; |
| 1 |
| ----------- |
| 0 |
| ij> -- PASS:0037 If count = 0? |
| |
| -- restore |
| ROLLBACK WORK; |
| ij> -- Testing Rollback |
| SELECT COUNT(*) |
| FROM STAFF; |
| 1 |
| ----------- |
| 5 |
| ij> -- PASS:0037 If count = 5? |
| |
| -- END TEST >>> 0037 <<< END TEST |
| -- ************************************************************** |
| |
| -- TEST:0038 DELETE with correlated subquery in WHERE clause! |
| SELECT COUNT(*) |
| FROM WORKS; |
| 1 |
| ----------- |
| 12 |
| ij> -- PASS:0038 If count = 12? |
| |
| DELETE FROM WORKS |
| WHERE WORKS.PNUM IN |
| (SELECT PROJ.PNUM |
| FROM PROJ |
| WHERE PROJ.PNUM=WORKS.PNUM |
| AND PROJ.CITY='Tampa'); |
| 1 row inserted/updated/deleted |
| ij> -- PASS:0038 If 1 row deleted? |
| |
| SELECT COUNT(*) |
| FROM WORKS; |
| 1 |
| ----------- |
| 11 |
| ij> -- PASS:0038 If count = 11? |
| |
| -- restore |
| ROLLBACK WORK; |
| ij> -- Testing Rollback |
| SELECT COUNT(*) |
| FROM WORKS; |
| 1 |
| ----------- |
| 12 |
| ij> -- PASS:0038 If count = 12? |
| |
| -- END TEST >>> 0038 <<< END TEST |
| -- *************************************************////END-OF-MODULE |
| ; |
| ij> |