java/testing/org/apache/derbyTesting/functionTests/master/yts799.out

ij> AUTOCOMMIT OFF;
ij> -- MODULE  YTS799  

-- SQL Test Suite, V6.0, Interactive SQL, yts799.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:7531 <subquery> as <row val constr> in <null predicate>!


   SELECT TTA, TTB, TTC FROM CTS1.TT
     WHERE (SELECT TUD FROM TU WHERE TU.TUE = TT.TTA)
     IS NULL ORDER BY TTA DESC;
TTA        |TTB        |TTC        
-----------------------------------
5          |42         |26         
2          |98         |NULL       
1          |NULL       |99         
ij> -- PASS:7531 If 3 rows are selected in the following order?
--                  col1     col2     col3
--                  ====     ====     ====
-- PASS:7531 If     5        42       26  ?
-- PASS:7531 If     2        98       NULL?
-- PASS:7531 If     1        NULL     99  ?

   SELECT TTA, TTB, TTC FROM CTS1.TT
     WHERE (SELECT TUD FROM TU WHERE TU.TUE = TT.TTA)
     IS NOT NULL ORDER BY TTA;
TTA        |TTB        |TTC        
-----------------------------------
3          |97         |96         
4          |NULL       |NULL       
ij> -- PASS:7531 If 2 rows are selected in the following order?
--                 col1     col1     col3
--                 ====     ====     ====
-- PASS:7531 If    3        97       96  ? 
-- PASS:7531 If    4        NULL     NULL?

--O   SELECT COUNT (*) FROM CTS1.TT
   SELECT * FROM CTS1.TT
     WHERE TTB IS NULL OR TTC IS NULL;
TTA        |TTB        |TTC        
-----------------------------------
1          |NULL       |99         
2          |98         |NULL       
4          |NULL       |NULL       
ij> -- PASS:7531 If COUNT = 3?

--O   SELECT COUNT (*) FROM CTS1.TT
   SELECT * FROM CTS1.TT
     WHERE TTB IS NOT NULL AND TTC IS NOT NULL;
TTA        |TTB        |TTC        
-----------------------------------
3          |97         |96         
5          |42         |26         
ij> -- PASS:7531 If COUNT = 2?

--O   SELECT COUNT (*) FROM CTS1.TT
   SELECT * FROM CTS1.TT
     WHERE NOT (TTB IS NULL AND TTC IS NULL);
TTA        |TTB        |TTC        
-----------------------------------
1          |NULL       |99         
2          |98         |NULL       
3          |97         |96         
5          |42         |26         
ij> -- PASS:7531 If COUNT = 4?

   ROLLBACK WORK;
ij> -- END TEST >>> 7531 <<< END TEST
-- *********************************************
-- *************************************************////END-OF-MODULE
;
ij>