sdl012.sql

来自「derby database source code.good for you.」· SQL 代码 · 共 35 行

AUTOCOMMIT OFF;

-- MODULE SDL012

-- SQL Test Suite, V6.0, Interactive SQL, sdl012.sql
-- 59-byte ID
-- TEd Version #

-- AUTHORIZATION HU
   set schema HU;

--O   SELECT USER FROM HU.ECCO;
  VALUES USER;
-- RERUN if USER value does not match preceding AUTHORIZATION comment

-- date_time print

-- TEST:0148 CREATE Table with NOT NULL!

     INSERT INTO STAFF1(EMPNAME,GRADE,CITY)
            VALUES('Carmen',40,'Boston');
-- PASS:0148 If ERROR, NOT NULL constraint, 0 rows inserted?
-- NOTE:0148 Not Null Column EMPNUM is missing.

--O      SELECT COUNT(*)
      SELECT *
           FROM STAFF1;
-- PASS:0148 If count = 0?

-- restore
     ROLLBACK WORK;

-- END TEST >>> 0148 <<< END TEST
-- *************************************************////END-OF-MODULE