text: --
  --   Licensed to the Apache Software Foundation (ASF) under one or more
  --   contributor license agreements.  See the NOTICE file distributed with
  --   this work for additional information regarding copyright ownership.
  --   The ASF licenses this file to You under the Apache License, Version 2.0
  --   (the "License"); you may not use this file except in compliance with
  --   the License.  You may obtain a copy of the License at
  --
  --      http://www.apache.org/licenses/LICENSE-2.0
  --
  --   Unless required by applicable law or agreed to in writing, software
  --   distributed under the License is distributed on an "AS IS" BASIS,
  --   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  --   See the License for the specific language governing permissions and
  --   limitations under the License.
  --
  AUTOCOMMIT OFF;
  
  -- MODULE CDR004
  
  -- SQL Test Suite, V6.0, Interactive SQL, cdr004.sql
  -- 59-byte ID
  -- TEd Version #
  
  -- AUTHORIZATION SUN
     set schema SUN;
  
  --O   SELECT USER FROM SUN.ECCO;
    VALUES USER;
  -- RERUN if USER value does not match preceding AUTHORIZATION comment
  
  -- date_time print
  
  -- TEST:0309 CHECK combination predicates in <tab. cons.>, insert!
  
  -- setup
    DELETE FROM STAFF11;
  
    INSERT INTO STAFF11
          VALUES('E1','Thomas',0,'Deale');
  -- PASS:0309 If ERROR, check constraint, 0 rows inserted?
  
    INSERT INTO STAFF11
          VALUES('E2','Tom',22,'Newyork');
  -- PASS:0309 If ERROR, check constraint, 0 rows inserted?
  
    INSERT INTO STAFF11
          VALUES('E3','Susan',11,'Hawaii');
  
    SELECT COUNT(*) FROM STAFF11;
  -- PASS:0309 If count = 1?
  
  
  -- END TEST >>> 0309 <<< END TEST
  
  -- *************************************************
  
  
  -- TEST:0310 CHECK if X NOT IN, NOT X IN equivalent, insert!
  
  -- setup
    DELETE FROM STAFF12;
  
    INSERT INTO STAFF12
          VALUES('E1','Thomas',0,'Deale');
  -- PASS:0310 If ERROR, check constraint, 0 rows inserted?
  
    INSERT INTO STAFF12
          VALUES('E2','Tom',22,'Newyork');
  -- PASS:0310 If ERROR, check constraint, 0 rows inserted?
  
    INSERT INTO STAFF12
          VALUES('E3','Susan',11,'Hawaii');
  
    SELECT COUNT(*) FROM STAFF12;
  -- PASS:0310 If count = 1?
  
  -- END TEST >>> 0310 <<< END TEST
  
  -- *************************************************
  
  
  -- TEST:0311 CHECK NOT NULL in col.cons., insert, null explicit!
  
  -- setup
    DELETE FROM STAFF15;
  
    INSERT INTO STAFF15
          VALUES('E1','Alice',52,'Deale');
  
    SELECT COUNT(*) FROM STAFF15;
  -- PASS:0311 If count = 1?
  
    INSERT INTO STAFF15
          VALUES('E2',NULL,52,'Newyork');
  -- PASS:0311 If ERROR, check constraint, 0 rows inserted?
  
    SELECT COUNT(*) FROM STAFF15;
  -- PASS:0311 If count = 1?
  
  
  -- END TEST >>> 0311 <<< END TEST
  
  -- *************************************************
  
  
  -- TEST:0312 CHECK NOT NULL in col.cons., insert, null implicit!
  
  -- setup
    DELETE FROM STAFF15;
  
    INSERT INTO STAFF15
          VALUES('E1','Alice',52,'Deale');
  
    SELECT COUNT(*) FROM STAFF15;
  -- PASS:0312 If count = 1?
  
    INSERT INTO STAFF15(EMPNUM,GRADE,CITY)
          VALUES('E2',52,'Newyork');
  -- PASS:0312 If ERROR, check constraint, 0 rows inserted?
  
    SELECT COUNT(*) FROM STAFF15;
  -- PASS:0312 If count = 1?
  
  
    COMMIT WORK;
   
  -- END TEST >>> 0312 <<< END TEST
  
  -- *************************************************////END-OF-MODULE
  