java/testing/org/apache/derbyTesting/functionTests/tests/nist/dml016.sql

AUTOCOMMIT OFF;

-- MODULE DML016

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

-- AUTHORIZATION SULLIVAN
   create schema SULLIVAN;
   set schema SULLIVAN;

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

-- date_time print

-- TEST:0064 SELECT USER!

     SELECT USER, PNAME
          FROM HU.PROJ;
-- PASS:0064 If 6 rows are selected and each USER = 'SULLIVAN' ?

-- END TEST >>> 0064 <<< END TEST
-- ***********************************************************

-- NO_TEST:0172 SELECT USER into short variable!
-- Tests Host Variable

-- **********************************************************

-- TEST:0065 SELECT CHAR literal and term with numeric literal!

     SELECT 'USER',PNAME
          FROM HU.PROJ;
-- PASS:0065 If 6 rows are selected and first column is value 'USER'?

     SELECT PNUM,'BUDGET IN GRAMS IS ',BUDGET * 5
          FROM HU.PROJ
          WHERE PNUM = 'P1';
-- PASS:0065 If values are 'P1', 'BUDGET IN GRAMS IS ', 50000?

-- END TEST >>> 0065 <<< END TEST
-- ************************************************************

-- TEST:0066 SELECT numeric literal!
     SELECT EMPNUM,10
          FROM HU.STAFF
          WHERE GRADE = 10;
-- PASS:0066 If 1 row with values 'E2' and 10?

     SELECT EMPNUM, 10
          FROM HU.STAFF;
-- PASS:0066 If 5 rows are selected with second value always = 10?
-- PASS:0066 and EMPNUMs are 'E1', 'E2', 'E3', 'E4', 'E5'?

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