| ij> AUTOCOMMIT OFF; |
| ij> -- MODULE DML044 |
| |
| -- SQL Test Suite, V6.0, Interactive SQL, dml044.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:0215 FIPS sizing -- 6 columns in a UNIQUE constraint! |
| -- FIPS sizing TEST |
| |
| -- setup |
| INSERT INTO T8 |
| VALUES('th','seco','third3','fourth_4','fifth_colu', |
| 'sixth_column','seventh_column','last_column_of_t'); |
| 1 row inserted/updated/deleted |
| ij> -- PASS:0215 If 1 row is inserted? |
| |
| INSERT INTO T8 |
| VALUES('th','seco','third3','fourth_4','fifth_colu', |
| 'sixth_column','column_seventh','column_eighth_la'); |
| ERROR 23505: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'T8C1' defined on 'T8'. |
| ij> -- PASS:0215 If ERROR, unique constraint, 0 rows inserted? |
| |
| SELECT COL1,COL2,COL3,COL4,COL5,COL6,COL7,COL8 |
| FROM T8; |
| C&|COL2|COL3 |COL4 |COL5 |COL6 |COL7 |COL8 |
| ------------------------------------------------------------------------------- |
| th|seco|third3|fourth_4|fifth_colu|sixth_column|seventh_column|last_column_of_t |
| ij> -- PASS:0215 If COL1 = 'th'? |
| |
| -- restore |
| ROLLBACK WORK; |
| ij> -- END TEST >>> 0215 <<< END TEST |
| -- ************************************************************** |
| |
| -- TEST:0216 FIPS sizing -- 120 bytes in a UNIQUE constraint! |
| -- FIPS sizing TEST |
| |
| -- setup |
| DELETE FROM T4; |
| 0 rows inserted/updated/deleted |
| WARNING 02000: No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table. |
| ij> -- Making sure the table is empty |
| |
| -- setup |
| INSERT INTO T4 VALUES ( |
| 'This test is trying to test the limit on the total length of an index', |
| -123456, 'which is','not less than 120'); |
| 1 row inserted/updated/deleted |
| ij> -- PASS:0216 If 1 row is inserted? |
| |
| INSERT INTO T4 VALUES ( |
| 'This test is trying to test the limit on the total length of an index', |
| -123456,'which is','not less than 120'); |
| ERROR 23505: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'T4C1' defined on 'T4'. |
| ij> -- PASS:0216 If ERROR, unique constraint, 0 rows inserted? |
| |
| SELECT STR110 |
| FROM T4; |
| STR110 |
| -------------------------------------------------------------------------------------------------------------- |
| This test is trying to test the limit on the total length of an index |
| ij> -- PASS:0216 If STR110 starts with 'This test is trying to test the '? |
| -- PASS:0216 and ends with 'limit on the total length of an index'? |
| |
| -- restore |
| ROLLBACK WORK; |
| ij> -- END TEST >>> 0216 <<< END TEST |
| |
| -- *************************************************////END-OF-MODULE |
| ; |
| ij> |