dml049.out

derby database source code.good for you.

ij> AUTOCOMMIT OFF;
ij> -- MODULE DML049
-- SQL Test Suite, V6.0, Interactive SQL, dml049.sql
-- 59-byte ID
-- TEd Version #
-- AUTHORIZATION HU
   set schema HU;
0 rows inserted/updated/deleted
ij> --O   SELECT USER FROM HU.ECCO;
  VALUES USER;
1                                                                                                                               
--------------------------------------------------------------------------------------------------------------------------------
HU                                                                                                                              
ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment
-- date_time print
-- TEST:0225 FIPS sizing -- ten tables in FROM clause!
-- FIPS sizing TEST
-- setup
     INSERT INTO TEMP_S
            SELECT EMPNUM,GRADE,CITY
                 FROM STAFF
                 WHERE GRADE > 11;
4 rows inserted/updated/deleted
ij> -- PASS:0225 If 4 rows are inserted ?
     INSERT INTO STAFF1
            SELECT *
                 FROM STAFF;
5 rows inserted/updated/deleted
ij> -- PASS:0225 If 5 rows are inserted?
     INSERT INTO WORKS1
            SELECT *
                 FROM WORKS;
12 rows inserted/updated/deleted
ij> -- PASS:0225 If 12 rows are inserted?
     INSERT INTO STAFF4
            SELECT *
                 FROM STAFF;
5 rows inserted/updated/deleted
ij> -- PASS:0225 If 5 rows are inserted?
     INSERT INTO PROJ1
            SELECT *
                 FROM PROJ;
6 rows inserted/updated/deleted
ij> -- PASS:0225 If 6 rows are inserted?
                 SELECT STAFF.EMPNUM,PROJ.PNUM,WORKS.HOURS,
                        STAFF3.GRADE,STAFF4.CITY,WORKS1.HOURS,
                        TEMP_S.GRADE,PROJ1.PNUM,STAFF1.GRADE,
                        UPUNIQ.COL2
                 FROM   STAFF,PROJ,WORKS,STAFF3,STAFF4,WORKS1,
                        TEMP_S,PROJ1,STAFF1,UPUNIQ
                 WHERE  STAFF.EMPNUM = WORKS.EMPNUM    AND
                        PROJ.PNUM = WORKS.PNUM         AND
                        STAFF3.EMPNUM = WORKS.EMPNUM   AND
                        STAFF4.EMPNUM = WORKS.EMPNUM   AND
                        WORKS1.EMPNUM = WORKS.EMPNUM   AND
                        WORKS1.PNUM = WORKS.PNUM       AND
                        TEMP_S.EMPNUM = WORKS.EMPNUM   AND
                        PROJ1.PNUM = WORKS.PNUM        AND
                        STAFF1.EMPNUM = WORKS.EMPNUM   AND
                        UPUNIQ.COL2 = 'A'
                 ORDER BY 1, 2;
EM&|PN&|HOURS |GRADE|CITY           |HOURS |GRADE|PN&|GRADE|COL2
----------------------------------------------------------------
E1 |P1 |40    |12   |Deale          |40    |12   |P1 |12   |A   
E1 |P2 |20    |12   |Deale          |20    |12   |P2 |12   |A   
E1 |P3 |80    |12   |Deale          |80    |12   |P3 |12   |A   
E1 |P4 |20    |12   |Deale          |20    |12   |P4 |12   |A   
E1 |P5 |12    |12   |Deale          |12    |12   |P5 |12   |A   
E1 |P6 |12    |12   |Deale          |12    |12   |P6 |12   |A   
E3 |P2 |20    |13   |Vienna         |20    |13   |P2 |13   |A   
E4 |P2 |20    |12   |Deale          |20    |12   |P2 |12   |A   
E4 |P4 |40    |12   |Deale          |40    |12   |P4 |12   |A   
E4 |P5 |80    |12   |Deale          |80    |12   |P5 |12   |A   
ij> ;
ij> -- PASS:0225 If 10 rows are selected ?
-- PASS:0225 If first STAFF.EMPNUM='E1',PROJ.PNUM='P1',WORKS.HOURS=40?
-- PASS:0225 If last  STAFF.EMPNUM='E4',PROJ.PNUM='P5',WORKS.HOURS=80?
-- restore
     ROLLBACK WORK;
ij> -- END TEST >>> 0225 <<< END TEST
-- *************************************************////END-OF-MODULE
;
ij>