| ij> AUTOCOMMIT OFF; |
| ij> -- MODULE DML177 |
| |
| -- SQL Test Suite, V6.0, Interactive SQL, dml177.sql |
| -- 59-byte ID |
| -- TEd Version # |
| |
| -- AUTHORIZATION FLATER |
| set schema FLATER; |
| 0 rows inserted/updated/deleted |
| ij> --0 SELECT USER FROM HU.ECCO; |
| VALUES USER; |
| 1 |
| -------------------------------------------------------------------------------------------------------------------------------- |
| FLATER |
| ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment |
| ROLLBACK WORK; |
| ij> -- date_time print |
| |
| -- TEST:0889 FIPS sizing, INTEGER binary prec >= 31! |
| |
| CREATE TABLE NOMAIL (C1 INT); |
| 0 rows inserted/updated/deleted |
| ij> -- PASS:0889 If table created successfully? |
| |
| COMMIT WORK; |
| ij> INSERT INTO NOMAIL VALUES (2147483647); |
| 1 row inserted/updated/deleted |
| ij> -- PASS:0889 If 1 row inserted successfully? |
| |
| INSERT INTO NOMAIL VALUES (-2147483647); |
| 1 row inserted/updated/deleted |
| ij> -- PASS:0889 If 1 row inserted successfully? |
| |
| SELECT C1 |
| FROM NOMAIL WHERE C1 > 0; |
| C1 |
| ----------- |
| 2147483647 |
| ij> -- PASS:0889 If C1 = 2147483647? |
| |
| SELECT C1 |
| FROM NOMAIL WHERE C1 < 0; |
| C1 |
| ----------- |
| -2147483647 |
| ij> -- PASS:0889 If C1 = -2147483647? |
| |
| SELECT C1 - 2147483646 |
| FROM NOMAIL |
| WHERE C1 > 0; |
| 1 |
| ----------- |
| 1 |
| ij> -- PASS:0889 If value = 1? |
| |
| SELECT C1 + 2147483646 |
| FROM NOMAIL |
| WHERE C1 < 0; |
| 1 |
| ----------- |
| -1 |
| ij> -- PASS:0889 If value = -1? |
| |
| UPDATE NOMAIL |
| SET C1 = C1 + 2147483646 |
| WHERE C1 < 0; |
| 1 row inserted/updated/deleted |
| ij> -- PASS:0889 If update completed successfully? |
| |
| SELECT C1 |
| FROM NOMAIL WHERE C1 < 0; |
| C1 |
| ----------- |
| -1 |
| ij> -- PASS:0889 If C1 = -1? |
| |
| UPDATE NOMAIL |
| SET C1 = C1 - 1; |
| 2 rows inserted/updated/deleted |
| ij> -- PASS:0889 If update completed successfully? |
| |
| SELECT COUNT(*) |
| FROM NOMAIL |
| WHERE C1 = 2147483645; |
| 1 |
| ----------- |
| 0 |
| ij> -- PASS:0889 If COUNT = 0? |
| |
| SELECT COUNT(*) |
| FROM NOMAIL |
| WHERE C1 = 2147483646; |
| 1 |
| ----------- |
| 1 |
| ij> -- PASS:0889 If COUNT = 1? |
| |
| SELECT COUNT(*) |
| FROM NOMAIL |
| WHERE C1 = 2147483647; |
| 1 |
| ----------- |
| 0 |
| ij> -- PASS:0889 If COUNT = 0? |
| |
| COMMIT WORK; |
| ij> --0 DROP TABLE NOMAIL CASCADE; |
| DROP TABLE NOMAIL ; |
| 0 rows inserted/updated/deleted |
| ij> -- PASS:0889 If table dropped successfully? |
| |
| COMMIT WORK; |
| ij> -- END TEST >>> 0889 <<< END TEST |
| -- ********************************************* |
| |
| -- TEST:0890 FIPS sizing, SMALLINT binary prec >= 15! |
| |
| CREATE TABLE YESMAIL (C1 SMALLINT); |
| 0 rows inserted/updated/deleted |
| ij> -- PASS:0890 If table created successfully? |
| |
| COMMIT WORK; |
| ij> INSERT INTO YESMAIL VALUES (32767); |
| 1 row inserted/updated/deleted |
| ij> -- PASS:0890 If 1 row inserted successfully? |
| |
| INSERT INTO YESMAIL VALUES (-32767); |
| 1 row inserted/updated/deleted |
| ij> -- PASS:0890 If 1 row inserted successfully? |
| |
| SELECT C1 |
| FROM YESMAIL WHERE C1 > 0; |
| C1 |
| ------ |
| 32767 |
| ij> -- PASS:0890 If C1 = 32767? |
| |
| SELECT C1 |
| FROM YESMAIL WHERE C1 < 0; |
| C1 |
| ------ |
| -32767 |
| ij> -- PASS:0890 If C1 = -32767? |
| |
| SELECT C1 - 32766 |
| FROM YESMAIL |
| WHERE C1 > 0; |
| 1 |
| ----------- |
| 1 |
| ij> -- PASS:0890 If value = 1? |
| |
| SELECT C1 + 32766 |
| FROM YESMAIL |
| WHERE C1 < 0; |
| 1 |
| ----------- |
| -1 |
| ij> -- PASS:0890 If value = -1? |
| |
| UPDATE YESMAIL |
| SET C1 = C1 + 32766 |
| WHERE C1 < 0; |
| 1 row inserted/updated/deleted |
| ij> -- PASS:0890 If update completed successfully? |
| |
| SELECT C1 |
| FROM YESMAIL WHERE C1 < 0; |
| C1 |
| ------ |
| -1 |
| ij> -- PASS:0890 If C1 = -1? |
| |
| UPDATE YESMAIL |
| SET C1 = C1 - 1; |
| 2 rows inserted/updated/deleted |
| ij> -- PASS:0890 If update completed successfully? |
| |
| SELECT COUNT(*) |
| FROM YESMAIL |
| WHERE C1 = 32765; |
| 1 |
| ----------- |
| 0 |
| ij> -- PASS:0890 If COUNT = 0? |
| |
| SELECT COUNT(*) |
| FROM YESMAIL |
| WHERE C1 = 32766; |
| 1 |
| ----------- |
| 1 |
| ij> -- PASS:0890 If COUNT = 1? |
| |
| SELECT COUNT(*) |
| FROM YESMAIL |
| WHERE C1 = 32767; |
| 1 |
| ----------- |
| 0 |
| ij> -- PASS:0890 If COUNT = 0? |
| |
| COMMIT WORK; |
| ij> --0 DROP TABLE YESMAIL CASCADE; |
| DROP TABLE YESMAIL ; |
| 0 rows inserted/updated/deleted |
| ij> -- PASS:0890 If table dropped successfully? |
| |
| COMMIT WORK; |
| ij> -- END TEST >>> 0890 <<< END TEST |
| -- ********************************************* |
| -- *************************************************////END-OF-MODULE |
| ; |
| ij> |