| ij> AUTOCOMMIT OFF; |
| ij> -- MODULE YTS812 |
| |
| -- SQL Test Suite, V6.0, Interactive SQL, yts812.sql |
| -- 59-byte ID |
| -- TEd Version # |
| |
| -- AUTHORIZATION CTS1 |
| set schema CTS1; |
| 0 rows inserted/updated/deleted |
| ij> --O SELECT USER FROM HU.ECCO; |
| VALUES USER; |
| 1 |
| -------------------------------------------------------------------------------------------------------------------------------- |
| CTS1 |
| ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment |
| ROLLBACK WORK; |
| ij> -- date_time print |
| |
| -- TEST:7569 <null predicate> with concatenation in <row value constructor>! |
| |
| --O SELECT COUNT (*) |
| SELECT * |
| FROM TX |
| WHERE TX2 || TX3 IS NOT NULL; |
| TX1 |TX2 |TX3 |
| ---------------------------- |
| 3 |apple| |
| 4 |melon|Peter |
| 5 |peach|Matthew |
| ij> -- PASS:7569 If COUNT = 3? |
| |
| SELECT TX1 FROM TX |
| WHERE TX3 || TX2 IS NULL; |
| TX1 |
| ----------- |
| 1 |
| 2 |
| ij> -- PASS:7569 If 2 rows returned in any order? |
| -- PASS:7569 If TX1 = 1? |
| -- PASS:7569 If TX1 = 2? |
| |
| ROLLBACK WORK; |
| ij> -- END TEST >>> 7569 <<< END TEST |
| -- ********************************************* |
| -- *************************************************////END-OF-MODULE |
| ; |
| ij> |