db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From d..@apache.org
Subject svn commit: r468514 [3/7] - in /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests: master/ suites/ tests/lang/ tests/nist/
Date Fri, 27 Oct 2006 20:04:30 GMT
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml045.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml045.out?view=diff&rev=468514&r1=468513&r2=468514
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml045.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml045.out Fri Oct 27 13:04:21 2006
@@ -1,8 +1,10 @@
 ij> AUTOCOMMIT OFF;
 ij> -- MODULE DML045
+
 -- SQL Test Suite, V6.0, Interactive SQL, dml045.sql
 -- 59-byte ID
 -- TEd Version #
+
 -- AUTHORIZATION HU
    set schema HU;
 0 rows inserted/updated/deleted
@@ -12,36 +14,44 @@
 --------------------------------------------------------------------------------------------------------------------------------
 HU                                                                                                                              
 ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment
+
 -- date_time print
+
 -- TEST:0218 FIPS sizing -- 6 columns in GROUP BY!
 -- FIPS sizing TEST
+
 -- setup
      INSERT INTO T12
             VALUES('1','22','4444','666666','88888888','0101010101',
                 '2020...20','3030...30','4040...40','5050...50',44,48);
 1 row inserted/updated/deleted
 ij> -- PASS:0218 If 1 row is inserted?
+
      INSERT INTO T12
             VALUES('1','22','4444','666666','88888888','1010101010',
                 '2020...20','3030...30','4040...40','5050...50',11,12);
 1 row inserted/updated/deleted
 ij> -- PASS:0218 If 1 row is inserted?
+
      INSERT INTO T12
             VALUES('1','22','4444','666666','88888888','1010101010',
                 '2020...20','3030...30','4040...40','5050...50',22,24);
 1 row inserted/updated/deleted
 ij> -- PASS:0218 If 1 row is inserted?
+
      INSERT INTO T12
             VALUES('1','22','4444','666666','88888888','0101010101',
                 '2020...20','3030...30','4040...40','5050...50',33,36);
 1 row inserted/updated/deleted
 ij> -- PASS:0218 If 1 row is inserted?
+
      SELECT COUNT(*)
                 FROM  T12;
 1          
 -----------
 4          
 ij> -- PASS:0218 If count = 4?
+
      SELECT COL6,SUM(COL11),MAX(COL12)
           FROM T12
           GROUP BY COL1,COL5,COL3,COL6,COL2,COL4
@@ -52,12 +62,15 @@
 0101010101|77         |48         
 ij> -- PASS:0218 If 2 rows are selected and second COL6 = 0101010101 and ?
 -- PASS:0218 second SUM(COL11) = 77 and second MAX(COL12) = 48?
+
 -- restore
      ROLLBACK WORK;
 ij> -- END TEST >>> 0218 <<< END TEST
 -- ****************************************************************
+
 -- TEST:0219 FIPS sizing -- 120 bytes in GROUP BY!
 -- FIPS sizing TEST
+
 -- setup
     INSERT INTO T12
     VALUES('1','22','4444','666666','88888888','1010101010',
@@ -65,30 +78,35 @@
     '4040404040404040404040404040404040404040', '5050...50',111,112);
 1 row inserted/updated/deleted
 ij> -- PASS:0219 If 1 row is inserted?
+
     INSERT INTO T12
     VALUES('1','22','4444','666666','88888889','1010101010',
     '20202020202020202020','303030303030303030303030303030',
     '4040404040404040404040404040404040404040', '5050...50',333,336);
 1 row inserted/updated/deleted
 ij> -- PASS:0219 If 1 row is inserted?
+
     INSERT INTO T12
     VALUES('1','22','4444','666666','88888889','1010101010',
     '20202020202020202020','303030303030303030303030303030',
     '4040404040404040404040404040404040404040', '5050...50',444,448);
 1 row inserted/updated/deleted
 ij> -- PASS:0219 If 1 row is inserted?
+
     INSERT INTO T12
     VALUES('1','22','4444','666666','88888888','1010101010',
     '20202020202020202020','303030303030303030303030303030',
     '4040404040404040404040404040404040404040', '5050...50',222,224);
 1 row inserted/updated/deleted
 ij> -- PASS:0219 If 1 row is inserted?
+
      SELECT COUNT(*)
                 FROM  T12;
 1          
 -----------
 4          
 ij> -- PASS:0219 If count = 4?
+
      SELECT COL5,SUM(COL11),MAX(COL12)
           FROM T12
           GROUP BY COL9,COL5,COL7,COL4,COL3,COL8
@@ -100,9 +118,10 @@
 ij> -- PASS:0219 If 2 rows are selected ?
 -- PASS:0219 If row #1 COL5=88888889, SUM(COL11)=777, MAX(COL12)=448?
 -- PASS:0219 If row #2 COL5=88888888, SUM(COL11)=333, MAX(COL12)=224?
+
 -- restore
      ROLLBACK WORK;
 ij> -- END TEST >>> 0219 <<< END TEST
 -- *************************************************////END-OF-MODULE
 ;
-ij> 
+ij> 
\ No newline at end of file

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml046.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml046.out?view=diff&rev=468514&r1=468513&r2=468514
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml046.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml046.out Fri Oct 27 13:04:21 2006
@@ -1,8 +1,10 @@
 ij> AUTOCOMMIT OFF;
 ij> -- MODULE DML046
+
 -- SQL Test Suite, V6.0, Interactive SQL, dml046.sql
 -- 59-byte ID
 -- TEd Version #
+
 -- AUTHORIZATION HU
    set schema HU;
 0 rows inserted/updated/deleted
@@ -12,30 +14,37 @@
 --------------------------------------------------------------------------------------------------------------------------------
 HU                                                                                                                              
 ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment
+
 -- date_time print
+
 -- TEST:0220 FIPS sizing -- 6 column in ORDER BY!
 -- FIPS sizing TEST
+
 -- setup
      INSERT INTO T12
             VALUES('1','22','4444','666666','88888884','1010101010',
                '2020...20','3030...30','4040...40','5050...50',11,12);
 1 row inserted/updated/deleted
 ij> -- PASS:0220 If 1 row is inserted?
+
      INSERT INTO T12
             VALUES('1','22','4444','666666','88888883','1010101010',
                 '2020...20','3030...30','4040...40','5050...50',22,24);
 1 row inserted/updated/deleted
 ij> -- PASS:0220 If 1 row is inserted?
+
      INSERT INTO T12
             VALUES('1','22','4444','666666','88888882','0101010101',
                 '2020...20','3030...30','4040...40','5050...50',33,36);
 1 row inserted/updated/deleted
 ij> -- PASS:0220 If 1 row is inserted?
+
      INSERT INTO T12
             VALUES('1','22','4444','666666','88888881','0101010101',
                 '2020...20','3030...30','4040...40','5050...50',44,48);
 1 row inserted/updated/deleted
 ij> -- PASS:0220 If 1 row is inserted?
+
 --O     SELECT COUNT(*)
      SELECT COL5
                 FROM  T12;
@@ -46,6 +55,7 @@
 88888882
 88888881
 ij> -- PASS:0220 If count = 4?
+
      SELECT COL5,COL6,COL11,COL3,COL4,COL7,COL8
           FROM T12
           ORDER BY COL7,COL8,COL3,COL4,COL6,COL5 DESC;
@@ -57,12 +67,15 @@
 88888883|1010101010|22         |4444|666666|2020...20           |3030...30                     
 ij> -- PASS:0220 If 4 rows are selected and first row?
 -- PASS:0220 COL5 = 88888882, COL6 = 0101010101 and COL11 = 33?
+
 -- restore
      ROLLBACK WORK;
 ij> -- END TEST >>> 0220 <<< END TEST
 -- **************************************************************
+
 -- TEST:0221 FIPS sizing -- 120 bytes in ORDER BY!
 -- FIPS sizing TEST
+
 -- setup
      INSERT INTO T12
      VALUES('1','22','4442','666666','88888888','1010101010',
@@ -70,24 +83,28 @@
      '4040404040404040404040404040404040404040', '5050...50',111,112);
 1 row inserted/updated/deleted
 ij> -- PASS:0221 If 1 row is inserted?
+
      INSERT INTO T12
      VALUES('1','22','4443','666666','88888888','1010101010',
      '20202020202020202020','303030303030303030303030303030',
      '4040404040404040404040404040404040404040', '5050...50',222,224);
 1 row inserted/updated/deleted
 ij> -- PASS:0221 If 1 row is inserted?
+
      INSERT INTO T12
      VALUES('1','22','4441','666666','88888888','1010101010',
      '20202020202020202020','303030303030303030303030303030',
      '4040404040404040404040404040404040404040', '5050...50',333,336);
 1 row inserted/updated/deleted
 ij> -- PASS:0221 If 1 row is inserted?
+
      INSERT INTO T12
      VALUES('1','22','4444','666666','88888888','1010101010',
      '20202020202020202020','303030303030303030303030303030',
      '4040404040404040404040404040404040404040', '5050...50',444,448);
 1 row inserted/updated/deleted
 ij> -- PASS:0221 If 1 row is inserted?
+
 --O     SELECT COUNT(*)
      SELECT COL3
                 FROM  T12;
@@ -98,6 +115,7 @@
 4441
 4444
 ij> -- PASS:0221 If count = 4?
+
      SELECT COL3,COL11,COL9,COL8,COL7,COL5,COL4
           FROM T12
           ORDER BY COL9,COL8,COL7,COL5,COL4,COL3;
@@ -109,9 +127,10 @@
 4444|444        |4040404040404040404040404040404040404040|303030303030303030303030303030|20202020202020202020|88888888|666666
 ij> -- PASS:0221 If 4 rows are selected ?
 -- PASS:0221 If first row COL3 = 4441 and COL11 = 333?
+
 -- restore
      ROLLBACK WORK;
 ij> -- END TEST >>> 0221 <<< END TEST
 -- *************************************************////END-OF-MODULE
 ;
-ij> 
+ij> 
\ No newline at end of file

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml047.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml047.out?view=diff&rev=468514&r1=468513&r2=468514
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml047.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml047.out Fri Oct 27 13:04:21 2006
@@ -1,8 +1,10 @@
 ij> AUTOCOMMIT OFF;
 ij> -- MODULE DML047
+
 -- SQL Test Suite, V6.0, Interactive SQL, dml047.sql
 -- 59-byte ID
 -- TEd Version #
+
 -- AUTHORIZATION HU
    set schema HU;
 0 rows inserted/updated/deleted
@@ -12,16 +14,20 @@
 --------------------------------------------------------------------------------------------------------------------------------
 HU                                                                                                                              
 ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment
+
 -- date_time print
+
 -- TEST:0222 FIPS sizing -- Length(240) of a character string!
 -- FIPS sizing TEST
 -- NOTE:0222 Literal length is only 78
+
 -- setup
      INSERT INTO T240 VALUES(
 'Now is the time for all good men and women to come to the aid of their country'
 );
 1 row inserted/updated/deleted
 ij> -- PASS:0222 If 1 row is inserted?
+
      SELECT * 
           FROM T240;
 STR240                                                                                                                          
@@ -29,9 +35,10 @@
 Now is the time for all good men and women to come to the aid of their country                                                 &
 ij> -- PASS:0222 If STR240 starts with 'Now is the time for all good men'?
 -- PASS:0222 and ends 'and women to come to the aid of their country'?
+
 -- restore
      ROLLBACK WORK;
 ij> -- END TEST >>> 0222 <<< END TEST
 -- *************************************************////END-OF-MODULE
 ;
-ij> 
+ij> 
\ No newline at end of file

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml049.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml049.out?view=diff&rev=468514&r1=468513&r2=468514
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml049.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml049.out Fri Oct 27 13:04:21 2006
@@ -1,8 +1,10 @@
 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
@@ -12,9 +14,12 @@
 --------------------------------------------------------------------------------------------------------------------------------
 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
@@ -22,26 +27,31 @@
                  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,
@@ -75,9 +85,11 @@
 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> 
+ij> 
\ No newline at end of file

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml050.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml050.out?view=diff&rev=468514&r1=468513&r2=468514
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml050.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml050.out Fri Oct 27 13:04:21 2006
@@ -1,7 +1,9 @@
 ij> -- MODULE DML050
+
 -- SQL Test Suite, V6.0, Interactive SQL, dml050.sql
 -- 59-byte ID
 -- TEd Version #
+
 -- AUTHORIZATION HU
    set schema HU;
 0 rows inserted/updated/deleted
@@ -11,9 +13,12 @@
 --------------------------------------------------------------------------------------------------------------------------------
 HU                                                                                                                              
 ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment
+
 -- date_time print
+
 -- TEST:0226 FIPS sizing - 10 tables in SQL statement!
 -- FIPS sizing TEST
+
      SELECT EMPNUM, EMPNAME 
      FROM STAFF 
      WHERE EMPNUM IN 
@@ -43,7 +48,8 @@
 E3 |Carmen              
 E4 |Don                 
 ij> -- PASS:0226 If 4 rows selected excluding EMPNUM='E5', EMPNAME='Ed'?
+
 -- END TEST >>> 0226 <<< END TEST
 -- *************************************************////END-OF-MODULE
 ;
-ij> 
+ij> 
\ No newline at end of file

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml051.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml051.out?view=diff&rev=468514&r1=468513&r2=468514
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml051.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml051.out Fri Oct 27 13:04:21 2006
@@ -1,7 +1,9 @@
 ij> -- MODULE DML051
+
 -- SQL Test Suite, V6.0, Interactive SQL, dml051.sql
 -- 59-byte ID
 -- TEd Version #
+
 -- AUTHORIZATION HU
    set schema HU;
 0 rows inserted/updated/deleted
@@ -11,7 +13,9 @@
 --------------------------------------------------------------------------------------------------------------------------------
 HU                                                                                                                              
 ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment
+
 -- date_time print
+
 -- TEST:0227 BETWEEN predicate with character string values!
       SELECT PNUM
            FROM   PROJ
@@ -20,6 +24,7 @@
 ---
 P2 
 ij> -- PASS:0227 If PNUM = 'P2'?
+
       SELECT PNUM
            FROM   PROJ
            WHERE PNAME >= 'A' AND PNAME <= 'F';
@@ -27,8 +32,10 @@
 ---
 P2 
 ij> -- PASS:0227 If PNUM = 'P2'?
+
 -- END TEST >>> 0227 <<< END TEST
 -- ***********************************************************
+
 -- TEST:0228 NOT BETWEEN predicate with character string values!
       SELECT CITY
            FROM   STAFF
@@ -37,6 +44,7 @@
 ---------------
 Akron          
 ij> -- PASS:0228 If CITY = 'Akron'?
+
       SELECT CITY
            FROM   STAFF
            WHERE  NOT( EMPNAME BETWEEN 'A' AND 'E' );
@@ -44,7 +52,8 @@
 ---------------
 Akron          
 ij> -- PASS:0228 If CITY = 'Akron'?
+
 -- END TEST >>> 0228 <<< END TEST
 -- *************************************************////END-OF-MODULE
 ;
-ij> 
+ij> 
\ No newline at end of file

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml052.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml052.out?view=diff&rev=468514&r1=468513&r2=468514
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml052.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml052.out Fri Oct 27 13:04:21 2006
@@ -1,8 +1,10 @@
 ij> AUTOCOMMIT OFF;
 ij> -- MODULE DML052
+
 -- SQL Test Suite, V6.0, Interactive SQL, dml052.sql
 -- 59-byte ID
 -- TEd Version #
+
 -- AUTHORIZATION HU
    set schema HU;
 0 rows inserted/updated/deleted
@@ -12,13 +14,17 @@
 --------------------------------------------------------------------------------------------------------------------------------
 HU                                                                                                                              
 ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment
+
 -- date_time print
+
 -- TEST:0229 Case-sensitive LIKE predicate!
+
 -- setup
      INSERT INTO STAFF
             VALUES('E6','ALICE',11,'Gaithersburg');
 1 row inserted/updated/deleted
 ij> -- PASS:0229 If 1 row is inserted?
+
      SELECT EMPNAME
           FROM   STAFF
           WHERE  EMPNAME LIKE 'Ali%';
@@ -26,6 +32,7 @@
 --------------------
 Alice               
 ij> -- PASS:0229 If 1 row is returned and EMPNAME = 'Alice' (not 'ALICE')?
+
      SELECT EMPNAME
           FROM   STAFF
           WHERE  EMPNAME LIKE 'ALI%';
@@ -33,9 +40,10 @@
 --------------------
 ALICE               
 ij> -- PASS:0229 If 1 row is returned and EMPNAME = 'ALICE' (not 'Alice')?
+
 -- restore
      ROLLBACK WORK;
 ij> -- END TEST >>> 0229 <<< END TEST
 -- *************************************************////END-OF-MODULE
 ;
-ij> 
+ij> 
\ No newline at end of file

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml053.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml053.out?view=diff&rev=468514&r1=468513&r2=468514
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml053.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml053.out Fri Oct 27 13:04:21 2006
@@ -1,8 +1,10 @@
 ij> AUTOCOMMIT OFF;
 ij> -- MODULE DML053
+
 -- SQL Test Suite, V6.0, Interactive SQL, dml053.sql
 -- 59-byte ID
 -- TEd Version #
+
 -- AUTHORIZATION HU
    set schema HU;
 0 rows inserted/updated/deleted
@@ -12,17 +14,22 @@
 --------------------------------------------------------------------------------------------------------------------------------
 HU                                                                                                                              
 ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment
+
 -- date_time print
+
 -- TEST:0233 Table as multiset of rows - INSERT duplicate VALUES()!
+ 
 -- setup
      INSERT INTO TEMP_S
             VALUES('E1',11,'Deale');
 1 row inserted/updated/deleted
 ij> -- PASS:0233 If 1 row is inserted?
+
      INSERT INTO TEMP_S
             VALUES('E1',11,'Deale');
 1 row inserted/updated/deleted
 ij> -- PASS:0233 If 1 row is inserted?
+
 --O     SELECT COUNT(*)
      SELECT empnum
                 FROM TEMP_S
@@ -32,9 +39,10 @@
 E1  
 E1  
 ij> -- PASS:0233 If count = 2?
+
 -- restore
      ROLLBACK WORK;
 ij> -- END TEST >>> 0233 <<< END TEST
 -- *************************************************////END-OF-MODULE
 ;
-ij> 
+ij> 
\ No newline at end of file

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml055.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml055.out?view=diff&rev=468514&r1=468513&r2=468514
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml055.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml055.out Fri Oct 27 13:04:21 2006
@@ -1,8 +1,10 @@
 ij> AUTOCOMMIT OFF;
 ij> -- MODULE DML055
+
 -- SQL Test Suite, V6.0, Interactive SQL, dml055.sql
 -- 59-byte ID
 -- TEd Version #
+
 -- AUTHORIZATION HU
    set schema HU;
 0 rows inserted/updated/deleted
@@ -12,17 +14,23 @@
 --------------------------------------------------------------------------------------------------------------------------------
 HU                                                                                                                              
 ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment
+
 -- date_time print
+
 -- TEST:0243 FIPS sizing - precision of SMALLINT >= 4!
 -- FIPS sizing TEST
+
      DELETE FROM HH;
 0 rows inserted/updated/deleted
+WARNING 02000: No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table.
 ij> -- Making sure the table is empty
+
 -- setup
      INSERT INTO HH
             VALUES(9999);
 1 row inserted/updated/deleted
 ij> -- PASS:0243 If 1 row is inserted?
+
 --O     SELECT COUNT(*) 
      SELECT * 
           FROM HH
@@ -31,11 +39,13 @@
 ------
 9999  
 ij> -- PASS:0243 If count = 1?
+
 -- setup
      INSERT INTO HH
             VALUES(-9999);
 1 row inserted/updated/deleted
 ij> -- PASS:0243 If 1 row is inserted?
+
      SELECT SMALLTEST 
           FROM HH
           WHERE SMALLTEST = -9999;
@@ -43,20 +53,27 @@
 ------
 -9999 
 ij> -- PASS:0243 If SMALLTEST = -9999?
+
 -- restore
      ROLLBACK WORK;
 ij> -- END TEST >>> 0243 <<< END TEST
+
 -- ***************************************************************
+
 -- TEST:0244 FIPS sizing - precision of INTEGER >= 9!
 -- FIPS sizing TEST
+
      DELETE FROM EE;
 0 rows inserted/updated/deleted
+WARNING 02000: No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table.
 ij> -- Making sure the table is empty
+
 -- setup
      INSERT INTO EE
             VALUES(999999999);
 1 row inserted/updated/deleted
 ij> -- PASS:0244 If 1 row is inserted?
+
      SELECT INTTEST
           FROM EE
           WHERE INTTEST = 999999999;
@@ -64,11 +81,13 @@
 -----------
 999999999  
 ij> -- PASS:0244 If INTTEST = 999999999?
+
 -- setup
      INSERT INTO EE
             VALUES(-999999999);
 1 row inserted/updated/deleted
 ij> -- PASS:0244 If 1 row is inserted?
+
 --O     SELECT COUNT(*) 
      SELECT * 
           FROM EE
@@ -77,26 +96,34 @@
 -----------
 -999999999 
 ij> -- PASS:0244 If count = 1?
+
 -- restore
      ROLLBACK WORK;
 ij> -- END TEST >>> 0244 <<< END TEST
+
 -- *****************************************************************
+
 -- TEST:0245 FIPS sizing - precision of DECIMAL >= 15!
 -- FIPS sizing TEST
+
      DELETE FROM PP_15;
 0 rows inserted/updated/deleted
+WARNING 02000: No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table.
 ij> -- Making sure the table is empty
+
 -- setup
      INSERT INTO PP_15
             VALUES(.123456789012345);
 1 row inserted/updated/deleted
 ij> -- PASS:0245 If 1 row is inserted?
+
      SELECT NUMTEST
           FROM PP_15;
 NUMTEST           
 ------------------
 0.123456789012345 
 ij> -- PASS:0245 If NUMTEST = 0.123456789012345?
+
 --O     SELECT COUNT(*) FROM PP_15
      SELECT * FROM PP_15
        WHERE NUMTEST = 0.123456789012345;
@@ -104,14 +131,17 @@
 ------------------
 0.123456789012345 
 ij> -- PASS:0245 If count = 1?
+
      DELETE FROM PP_15;
 1 row inserted/updated/deleted
 ij> -- PASS:0245 If 1 row is deleted?
+
 -- setup
      INSERT INTO PP_15
             VALUES(-.912345678901234);
 1 row inserted/updated/deleted
 ij> -- PASS:0245 If 1 row is inserted?
+
 --O     SELECT COUNT(*) 
      SELECT * 
           FROM PP_15
@@ -120,9 +150,10 @@
 ------------------
 -0.912345678901234
 ij> -- PASS:0245 If count = 1?
+
 -- restore
      ROLLBACK WORK;
 ij> -- END TEST >>> 0245 <<< END TEST
 -- *************************************************////END-OF-MODULE
 ;
-ij> 
+ij> 
\ No newline at end of file

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml056.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml056.out?view=diff&rev=468514&r1=468513&r2=468514
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml056.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml056.out Fri Oct 27 13:04:21 2006
@@ -1,8 +1,10 @@
 ij> AUTOCOMMIT OFF;
 ij> -- MODULE DML056
+
 -- SQL Test Suite, V6.0, Interactive SQL, dml056.sql
 -- 59-byte ID
 -- TEd Version #
+
 -- AUTHORIZATION HU
    set schema HU;
 0 rows inserted/updated/deleted
@@ -12,12 +14,17 @@
 --------------------------------------------------------------------------------------------------------------------------------
 HU                                                                                                                              
 ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment
+
 -- date_time print
+
 -- TEST:0246 FIPS sizing - 100 values in INSERT!
 -- FIPS sizing TEST
+
      DELETE FROM T100;
 0 rows inserted/updated/deleted
+WARNING 02000: No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table.
 ij> -- Making sure the table is empty
+
 -- setup
      INSERT INTO T100 
             VALUES('ZA','ZB','CA','ZC','ZD','AA','ZE','ZF','BA','ZG',
@@ -32,6 +39,7 @@
                    'OA','OB','CJ','OC','OD','AJ','OE','OF','BJ','OG');
 1 row inserted/updated/deleted
 ij> -- PASS:0246 If 1 row is inserted?
+
      SELECT C6, C16, C26, C36, C46, C56, C66, C76, C86, C96, C100
           FROM T100
           WHERE C1 = 'ZA' AND C2 = 'ZB';
@@ -41,15 +49,21 @@
 ij> -- PASS:0246 If C6  = 'AA', C16 = 'AB', C26  = 'AC', C36 = 'AD' ?
 -- PASS:0246 If C46 = 'AE', C56 = 'AF', C66  = 'AG', C76 = 'AH' ?
 -- PASS:0246 If C86 = 'AI', C96 = 'AJ', C100 = 'OG' ?
+
 -- restore
      ROLLBACK WORK;
 ij> -- END TEST >>> 0246 <<< END TEST
+
 -- *********************************************************************
+
 -- TEST:0247 FIPS sizing - 20 values in update SET clause!
 -- FIPS sizing TEST
+
      DELETE FROM T100;
 0 rows inserted/updated/deleted
+WARNING 02000: No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table.
 ij> -- Making sure the table is empty
+
 -- setup
      INSERT INTO T100 
             VALUES('ZA','ZB','CA','ZC','ZD','AA','ZE','ZF','BA','ZG',
@@ -64,6 +78,7 @@
                    'OA','OB','CJ','OC','OD','AJ','OE','OF','BJ','OG');
 1 row inserted/updated/deleted
 ij> -- PASS:0247 If 1 row is inserted?
+
      UPDATE T100
           SET C5 = 'BA', C10 = 'ZP', C15 = 'BB', C20 = 'YP', C25 = 'BC',
              C30 = 'XP', C35 = 'BD', C40 = 'UP', C45 = 'BE', C50 = 'VP',
@@ -71,6 +86,7 @@
             C80 = 'MP', C85 = 'BI', C90 = 'NP', C95 = 'BJ', C100 = 'OP';
 1 row inserted/updated/deleted
 ij> -- PASS:0247 If 1 row is updated ?
+
      SELECT C5, C20, C35, C40, C55, C60, C75, C80, C90, C95, C100
           FROM T100
           WHERE C1 = 'ZA' AND C2 = 'ZB';
@@ -79,9 +95,10 @@
 BA  |YP  |BD  |UP  |BF  |WP  |BH  |MP  |NP  |BJ  |OP  
 ij> -- PASS:0247 If C5  = 'BA', C35  = 'BD', C55 = 'BF', C75 = 'BH' ?
 -- PASS:0247 If C90 = 'NP', C100 = 'OP'?
+
 -- restore
      ROLLBACK WORK;
 ij> -- END TEST >>> 0247 <<< END TEST
 -- *************************************************////END-OF-MODULE
 ;
-ij> 
+ij> 
\ No newline at end of file

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml057.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml057.out?view=diff&rev=468514&r1=468513&r2=468514
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml057.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml057.out Fri Oct 27 13:04:21 2006
@@ -1,8 +1,10 @@
 ij> AUTOCOMMIT OFF;
 ij> -- MODULE DML057
+
 -- SQL Test Suite, V6.0, Interactive SQL, dml057.sql
 -- 59-byte ID
 -- TEd Version #
+ 
 -- AUTHORIZATION HU
    set schema HU;
 0 rows inserted/updated/deleted
@@ -12,17 +14,23 @@
 --------------------------------------------------------------------------------------------------------------------------------
 HU                                                                                                                              
 ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment
+
 -- date_time print
+
 -- TEST:0248 FIPS sizing - binary precision of FLOAT >= 20!
 -- FIPS sizing TEST
+
      DELETE FROM JJ;
 0 rows inserted/updated/deleted
+WARNING 02000: No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table.
 ij> -- Making sure the table is empty
+
 -- setup
      INSERT INTO JJ
             VALUES(0.1048575);
 1 row inserted/updated/deleted
 ij> -- PASS:0248 If 1 row is inserted?
+
      SELECT FLOATTEST
           FROM JJ;
 FLOATTEST             
@@ -30,6 +38,7 @@
 0.1048575             
 ij> -- PASS:0248 If FLOATTEST = 0.1048575 ?
 -- PASS:0248 OR  is between 0.1048574 and 0.1048576 ?
+
 --O     SELECT COUNT(*) FROM JJ
      SELECT * FROM JJ
        WHERE FLOATTEST > 0.1048574 AND FLOATTEST < 0.1048576;
@@ -37,14 +46,17 @@
 ----------------------
 0.1048575             
 ij> -- PASS:0248 If count = 1?
+
      DELETE FROM JJ;
 1 row inserted/updated/deleted
 ij> -- Making sure the table is empty
+
 -- setup
      INSERT INTO JJ
             VALUES(-0.1048575);
 1 row inserted/updated/deleted
 ij> -- PASS:0248 If 1 row is inserted?
+
      SELECT FLOATTEST
           FROM JJ;
 FLOATTEST             
@@ -52,6 +64,7 @@
 -0.1048575            
 ij> -- PASS:0248 If FLOATTEST = -0.1048575 ?
 -- PASS:0248 OR  is between -0.1048576 and -0.1048574 ?
+
 --O     SELECT COUNT(*) FROM JJ
      SELECT * FROM JJ
        WHERE FLOATTEST > -0.1048576 AND FLOATTEST < -0.1048574;
@@ -59,20 +72,27 @@
 ----------------------
 -0.1048575            
 ij> -- PASS:0248 If count = 1?
+
 -- restore
      ROLLBACK WORK;
 ij> -- END TEST >>> 0248 <<< END TEST
+
 -- *****************************************************************
+
 -- TEST:0249 FIPS sizing - binary precision of REAL >= 20!
 -- FIPS sizing TEST
+
      DELETE FROM GG;
 0 rows inserted/updated/deleted
+WARNING 02000: No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table.
 ij> -- Making sure the table is empty
+
 -- setup
      INSERT INTO GG
             VALUES(0.1048575);
 1 row inserted/updated/deleted
 ij> -- PASS:0249 If 1 row is inserted?
+
      SELECT REALTEST
           FROM GG;
 REALTEST     
@@ -80,6 +100,7 @@
 0.1048575    
 ij> -- PASS:0249 If REALTEST =  0.1048575 ?
 -- PASS:0249 OR  is between 0.1048574 and 0.1048576 ?
+
 --O     SELECT COUNT(*) FROM GG
      SELECT * FROM GG
        WHERE REALTEST > 0.1048574 AND REALTEST < 0.1048576;
@@ -87,14 +108,17 @@
 -------------
 0.1048575    
 ij> -- PASS:0249 If count = 1?
+
      DELETE FROM GG;
 1 row inserted/updated/deleted
 ij> -- Making sure the table is empty
+
 -- setup
      INSERT INTO GG
             VALUES(-0.1048575);
 1 row inserted/updated/deleted
 ij> -- PASS:0249 If 1 row is inserted?
+
      SELECT REALTEST
           FROM GG;
 REALTEST     
@@ -102,6 +126,7 @@
 -0.1048575   
 ij> -- PASS:0249 If REALTEST =  -0.1048575 ?
 -- PASS:0249 OR  is between -0.1048576 and -0.1048574 ?
+
 --O     SELECT COUNT(*) FROM GG
      SELECT * FROM GG
        WHERE REALTEST > -0.1048576 AND REALTEST < -0.1048574;
@@ -109,20 +134,27 @@
 -------------
 -0.1048575   
 ij> -- PASS:0249 If count = 1?
+
 -- restore
      ROLLBACK WORK;
 ij> -- END TEST >>> 0249 <<< END TEST
+
 -- ***************************************************************
+
 -- TEST:0250 FIPS sizing - bin. precision of DOUBLE >= 30!
 -- FIPS sizing TEST
+
      DELETE FROM II;
 0 rows inserted/updated/deleted
+WARNING 02000: No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table.
 ij> -- Making sure the table is empty
+
 -- setup
      INSERT INTO II
             VALUES(0.1073741823);
 1 row inserted/updated/deleted
 ij> -- PASS:0250 If 1 row is inserted?
+
      SELECT DOUBLETEST
           FROM II;
 DOUBLETEST            
@@ -130,6 +162,7 @@
 0.1073741823          
 ij> -- PASS:0250 If DOUBLETEST = 0.1073741823 ?
 -- PASS:0250 OR  is between  0.1073741822 and 0.1073741824 ?
+
 --O     SELECT COUNT(*) FROM II
      SELECT * FROM II
        WHERE DOUBLETEST > 0.1073741822 AND DOUBLETEST < 0.1073741824;
@@ -137,14 +170,17 @@
 ----------------------
 0.1073741823          
 ij> -- PASS:0250 If count = 1?
+
      DELETE FROM II;
 1 row inserted/updated/deleted
 ij> -- Making sure the table is empty
+
 -- setup
      INSERT INTO II
             VALUES(-0.1073741823);
 1 row inserted/updated/deleted
 ij> -- PASS:0250 If 1 row is inserted?
+
      SELECT DOUBLETEST
           FROM II;
 DOUBLETEST            
@@ -152,6 +188,7 @@
 -0.1073741823         
 ij> -- PASS:0250 If DOUBLETEST = -0.1073741823 ?
 -- PASS:0250 OR  is between  -0.1073741824 and -0.1073741822 ?
+
 --O     SELECT COUNT(*) FROM II
      SELECT * FROM II
        WHERE DOUBLETEST > -0.1073741824 AND DOUBLETEST < -0.1073741822;
@@ -159,9 +196,10 @@
 ----------------------
 -0.1073741823         
 ij> -- PASS:0250 If count = 1?
+
 -- restore 
      ROLLBACK WORK;
 ij> -- END TEST >>> 0250 <<< END TEST
 -- *************************************************////END-OF-MODULE
 ;
-ij> 
+ij> 
\ No newline at end of file

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml058.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml058.out?view=diff&rev=468514&r1=468513&r2=468514
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml058.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml058.out Fri Oct 27 13:04:21 2006
@@ -1,8 +1,10 @@
 ij> AUTOCOMMIT OFF;
 ij> -- MODULE DML058
+
 -- SQL Test Suite, V6.0, Interactive SQL, dml058.sql
 -- 59-byte ID
 -- TEd Version #
+
 -- AUTHORIZATION HU
    set schema HU;
 0 rows inserted/updated/deleted
@@ -12,17 +14,23 @@
 --------------------------------------------------------------------------------------------------------------------------------
 HU                                                                                                                              
 ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment
+
 -- date_time print
+
 -- TEST:0251 COMMIT keeps changes of current transaction!
+
      DELETE FROM STAFF1;
 0 rows inserted/updated/deleted
+WARNING 02000: No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table.
 ij> -- Making sure the table is empty
+
 -- setup
      INSERT INTO STAFF1
             SELECT *
                  FROM STAFF;
 5 rows inserted/updated/deleted
 ij> -- PASS:0251 If 5 rows are inserted?
+
 --O     SELECT COUNT(*) 
      SELECT * 
           FROM STAFF1;
@@ -34,19 +42,23 @@
 E4 |Don                 |12   |Deale          
 E5 |Ed                  |13   |Akron          
 ij> -- PASS:0251 If count = 5?
+
      INSERT INTO STAFF1
             VALUES('E9','Tom',50,'London');
 1 row inserted/updated/deleted
 ij> -- PASS:0251 If 1 row is inserted?
+  
      UPDATE STAFF1
             SET GRADE = 40 
             WHERE EMPNUM = 'E2';
 1 row inserted/updated/deleted
 ij> -- PASS:0251 If 1 row is updated?
+
      COMMIT WORK;
 ij> DELETE FROM STAFF1;
 6 rows inserted/updated/deleted
 ij> -- PASS:0251 If 6 rows are deleted?
+
 -- verify
      ROLLBACK WORK;
 ij> -- verify previous commit
@@ -61,36 +73,46 @@
 E5 |Ed                  |13   |Akron          
 E9 |Tom                 |50   |London         
 ij> -- PASS:0251 If count = 4?
+
 -- restore
      DELETE FROM STAFF1;
 6 rows inserted/updated/deleted
 ij> COMMIT WORK;
 ij> -- END TEST >>> 0251 <<< END TEST
+
 -- ***************************************************************
+
 -- TEST:0252 ROLLBACK cancels changes of current transaction!
+
      DELETE FROM STAFF1;
 0 rows inserted/updated/deleted
+WARNING 02000: No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table.
 ij> -- Making sure the table is empty
+
 -- setup
      INSERT INTO STAFF1
             SELECT *
                  FROM STAFF;
 5 rows inserted/updated/deleted
 ij> -- PASS:0252 If 5 rows are inserted?
+
      COMMIT WORK;
 ij> INSERT INTO STAFF1
             VALUES('E10','Tom',50,'London');
 1 row inserted/updated/deleted
 ij> -- PASS:0252 If 1 row is inserted?
+
      UPDATE STAFF1
             SET GRADE = 40
             WHERE EMPNUM = 'E1';
 1 row inserted/updated/deleted
 ij> -- PASS:0252 If 1 row is updated?
+
      DELETE FROM STAFF1
             WHERE EMPNUM = 'E2';
 1 row inserted/updated/deleted
 ij> -- PASS:0252 If 1 row is deleted?
+
      ROLLBACK WORK;
 ij> -- verify     
      SELECT SUM(GRADE)
@@ -99,13 +121,17 @@
 ---------
 60       
 ij> -- PASS:0252 If SUM(GRADE) = 60?
+
 -- restore
      DELETE FROM STAFF1;
 5 rows inserted/updated/deleted
 ij> COMMIT WORK;
 ij> -- END TEST >>> 0252 <<< END TEST
+
 -- ****************************************************************
+
 -- TEST:0253 TEST0124 workaround (key = key+1)!
+
      SELECT NUMKEY
           FROM UPUNIQ
           ORDER BY NUMKEY DESC;
@@ -118,60 +144,76 @@
 2   
 1   
 ij> -- PASS:0253 If 6 rows are selected and first NUMKEY = 8 ?
+
      UPDATE UPUNIQ
           SET NUMKEY = 8 + 1
           WHERE NUMKEY = 8;
 1 row inserted/updated/deleted
 ij> -- PASS:0253 If 1 row is updated?
+
      UPDATE UPUNIQ
           SET NUMKEY = 6 + 1
           WHERE NUMKEY = 6;
 1 row inserted/updated/deleted
 ij> -- PASS:0253 If 1 row is updated?
+
      UPDATE UPUNIQ
           SET NUMKEY = 4 + 1
           WHERE NUMKEY = 4;
 1 row inserted/updated/deleted
 ij> -- PASS:0253 If 1 row is updated?
+
      UPDATE UPUNIQ
           SET NUMKEY = 3 + 1
           WHERE NUMKEY = 3;
 1 row inserted/updated/deleted
 ij> -- PASS:0253 If 1 row is updated?
+
      UPDATE UPUNIQ
           SET NUMKEY = 2 + 1 
           WHERE NUMKEY = 2;
 1 row inserted/updated/deleted
 ij> -- PASS:0253 If 1 row is updated?
+
      UPDATE UPUNIQ
           SET NUMKEY = 1 + 1
           WHERE NUMKEY = 1;
 1 row inserted/updated/deleted
 ij> -- PASS:0253 If 1 row is updated?
+
+
      SELECT MAX(NUMKEY), MIN(NUMKEY)
           FROM UPUNIQ;
 1   |2   
 ---------
 9   |2   
 ij> -- PASS:0253 If MAX(NUMKEY) = 9 AND MIN(NUMKEY) = 2?
+
 -- restore
      ROLLBACK WORK;
 ij> -- END TEST >>> 0253 <<< END TEST
+
 -- **************************************************************
+
 -- TEST:0254 Column name in SET clause!
+
      DELETE FROM PROJ1;
 0 rows inserted/updated/deleted
+WARNING 02000: No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table.
 ij> -- Making sure the table is empty
+
 -- setup
      INSERT INTO PROJ1
             SELECT *
                  FROM PROJ;
 6 rows inserted/updated/deleted
 ij> -- PASS:0254 If 6 rows are inserted?
+
      UPDATE PROJ1
           SET CITY = PTYPE;
 6 rows inserted/updated/deleted
 ij> -- PASS:0254 If 6 rows are updated?
+
      SELECT CITY
           FROM PROJ1
           WHERE PNUM = 'P1';
@@ -179,19 +221,27 @@
 ---------------
 Design         
 ij> -- PASS:0254 If CITY = 'Design'?
+
 -- restore
      ROLLBACK WORK;
 ij> -- END TEST >>> 0254 <<< END TEST
+
 -- **************************************************************
+
+
 -- TEST:0255 Key word USER for INSERT, UPDATE!
+
      DELETE FROM T4;
 0 rows inserted/updated/deleted
+WARNING 02000: No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table.
 ij> -- Making sure the table is empty
+
 -- setup
      INSERT INTO T4
           VALUES(USER,100,'good','luck');
 1 row inserted/updated/deleted
 ij> -- PASS:0255 If 1 row is inserted?
+
      SELECT STR110 
           FROM T4
           WHERE NUM6 = 100;
@@ -199,16 +249,19 @@
 --------------------------------------------------------------------------------------------------------------
 HU                                                                                                            
 ij> -- PASS:0255 If STR110 = 'HU'?
+
 -- setup
      INSERT INTO T4
           VALUES('Hello',101,'good','luck');
 1 row inserted/updated/deleted
 ij> -- PASS:0255 If 1 row is inserted?
+
      UPDATE T4
           SET STR110 = USER
           WHERE NUM6 = 101;
 1 row inserted/updated/deleted
 ij> -- PASS:0255 If 1 row is updated?
+
      SELECT STR110 
           FROM T4
           WHERE NUM6 = 101;
@@ -216,19 +269,26 @@
 --------------------------------------------------------------------------------------------------------------
 HU                                                                                                            
 ij> -- PASS:0255 If STR110 = 'HU'?
+
 -- restore
      ROLLBACK WORK;
 ij> -- END TEST >>> 0255 <<< END TEST
+
 -- ***************************************************************
+
 -- TEST:0256 Key word USER in WHERE clause!
+
      DELETE FROM T4;
 0 rows inserted/updated/deleted
+WARNING 02000: No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table.
 ij> -- Making sure the table is empty
+
 -- setup
      INSERT INTO T4
             VALUES('HU',100,'good','luck');
 1 row inserted/updated/deleted
 ij> -- PASS:0256 If 1 row is inserted?
+
      SELECT STR110 
           FROM T4
           WHERE STR110 = USER;
@@ -236,15 +296,18 @@
 --------------------------------------------------------------------------------------------------------------
 HU                                                                                                            
 ij> -- PASS:0256 If STR110 = 'HU'?
+
 -- setup
      INSERT INTO T4
             VALUES('Hello',101,'good','luck');
 1 row inserted/updated/deleted
 ij> -- PASS:0256 If 1 row is inserted?
+
      DELETE FROM T4
             WHERE STR110 = USER;
 1 row inserted/updated/deleted
 ij> -- PASS:0256 If 1 row is deleted?
+
      SELECT COUNT(*)
           FROM T4
           WHERE STR110 LIKE '%HU%';
@@ -252,9 +315,10 @@
 -----------
 0          
 ij> -- PASS:0256 If count = 0?
+
 -- restore
      ROLLBACK WORK;
 ij> -- END TEST >>> 0256 <<< END TEST
 -- *************************************************////END-OF-MODULE
 ;
-ij> 
+ij> 
\ No newline at end of file

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml059.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml059.out?view=diff&rev=468514&r1=468513&r2=468514
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml059.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml059.out Fri Oct 27 13:04:21 2006
@@ -1,8 +1,10 @@
 ij> AUTOCOMMIT OFF;
 ij> -- MODULE DML059
+
 -- SQL Test Suite, V6.0, Interactive SQL, dml059.sql
 -- 59-byte ID
 -- TEd Version #
+
 -- AUTHORIZATION HU
    set schema HU;
 0 rows inserted/updated/deleted
@@ -12,18 +14,23 @@
 --------------------------------------------------------------------------------------------------------------------------------
 HU                                                                                                                              
 ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment
+
 -- date_time print
+
 -- TEST:0257 SELECT MAX, MIN (COL1 + or - COL2)!
+
 -- setup
      INSERT INTO VTABLE
             VALUES(10,11,12,13,15);
 1 row inserted/updated/deleted
 ij> -- PASS:0257 If 1 row is inserted?
+
 -- setup
      INSERT INTO VTABLE
             VALUES(100,111,1112,113,115);
 1 row inserted/updated/deleted
 ij> -- PASS:0257 If 1 row is inserted?
+
      SELECT COL1, MAX(COL2 + COL3), MIN(COL3 - COL2)
           FROM VTABLE
           GROUP BY COL1
@@ -39,21 +46,27 @@
 -- PASS:0257    (   10,   50,    1)?
 -- PASS:0257    (  100, 1223,  100)?
 -- PASS:0257    ( 1000, 1000, 5000)?
+
 -- restore
      ROLLBACK WORK;
 ij> -- END TEST >>> 0257 <<< END TEST
+
 -- *********************************************************************
+
 -- TEST:0258 SELECT SUM(2*COL1*COL2) in HAVING SUM(COL2*COL3)!
+
 -- setup
      INSERT INTO VTABLE
             VALUES (10,11,12,13,15);
 1 row inserted/updated/deleted
 ij> -- PASS:0258 if 1 row is inserted?
+
 -- setup
      INSERT INTO VTABLE
             VALUES (100,111,1112,113,115);
 1 row inserted/updated/deleted
 ij> -- PASS:0258 if 1 row is inserted ?
+
      SELECT COL1,SUM(2 * COL2 * COL3)
                   FROM VTABLE
                   GROUP BY COL1
@@ -67,21 +80,28 @@
 ij> -- PASS:0258 If 2 rows are selected?
 -- PASS:0258 If first row has values (100, 366864)    ?
 -- PASS:0258 If second row has values (1000, -12000000)    ?
+
+
 -- restore
      ROLLBACK WORK;
 ij> -- END TEST >>> 0258 <<< END TEST
+
 -- *********************************************************************
+
 -- TEST:0259 SOME, ANY in HAVING clause!
+
 -- setup
      INSERT INTO VTABLE
             VALUES(10,11,12,13,15);
 1 row inserted/updated/deleted
 ij> -- PASS:0259 If 1 row is inserted?
+
 -- setup
      INSERT INTO VTABLE
             VALUES(100,111,1112,113,115);
 1 row inserted/updated/deleted
 ij> -- PASS:0259 If 1 row is inserted?
+
      SELECT COL1, MAX(COL2)
           FROM VTABLE
           GROUP BY COL1
@@ -92,21 +112,27 @@
 -----------------------
 10         |20         
 ij> -- PASS:0259 If 1 row is selected and COL1 = 10 and MAX(COL2) = 20?
+
 -- restore
      ROLLBACK WORK;
 ij> -- END TEST >>> 0259 <<< END TEST
+
 -- *******************************************************************
+
 -- TEST:0260 EXISTS in HAVING clause!
+
 -- setup
      INSERT INTO VTABLE
             VALUES(10,11,12,13,15);
 1 row inserted/updated/deleted
 ij> -- PASS:0260 If 1 row is inserted?
+
 -- setup
      INSERT INTO VTABLE
             VALUES(100,111,1112,113,115);
 1 row inserted/updated/deleted
 ij> -- PASS:0260 If 1 row is inserted?
+
      SELECT COL1, MAX(COL2)
           FROM VTABLE
           GROUP BY COL1
@@ -119,11 +145,15 @@
 -----------------------
 10         |20         
 ij> -- PASS:0260 If 1 row is selected and COL1 = 10 and MAX(COL2) = 20?
+
 -- restore
      ROLLBACK WORK;
 ij> -- END TEST >>> 0260 <<< END TEST
+
 -- ******************************************************************
+
 -- TEST:0264 WHERE, HAVING without GROUP BY!
+
      SELECT SUM(COL1) 
           FROM VTABLE
           WHERE 10 + COL1 > COL2
@@ -132,6 +162,7 @@
 -----------
 1000       
 ij> -- PASS:0264 If SUM(COL1) = 1000?
+
      SELECT SUM(COL1)
           FROM VTABLE
           WHERE 1000 + COL1 >= COL2
@@ -140,7 +171,9 @@
 -----------
 1110       
 ij> -- PASS:0264 If SUM(COL1) = 1110?
+
 -- END TEST >>> 0264 <<< END TEST
+
 -- *************************************************////END-OF-MODULE
 ;
-ij> 
+ij> 
\ No newline at end of file

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml060.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml060.out?view=diff&rev=468514&r1=468513&r2=468514
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml060.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml060.out Fri Oct 27 13:04:21 2006
@@ -1,8 +1,10 @@
 ij> AUTOCOMMIT OFF;
 ij> -- MODULE DML060
+
 -- SQL Test Suite, V6.0, Interactive SQL, dml060.sql
 -- 59-byte ID
 -- TEd Version #
+
 -- AUTHORIZATION HU
    set schema HU;
 0 rows inserted/updated/deleted
@@ -12,8 +14,11 @@
 --------------------------------------------------------------------------------------------------------------------------------
 HU                                                                                                                              
 ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment
+
 -- date_time print
+
 -- TEST:0261 WHERE (2 * (c1 - c2)) BETWEEN!
+
      SELECT COL1, COL2
           FROM VTABLE
           WHERE(2*(COL3 - COL2)) BETWEEN 5 AND 200
@@ -25,14 +30,19 @@
 ij> -- PASS:0261 If 2 rows are selected ?
 -- PASS:0261 If first row is  ( 10,  20)?
 -- PASS:0261 If second row is (100, 200)?
+
 -- END TEST >>> 0261 <<< END TEST
+
 -- ********************************************************************
+
 -- TEST:0262 WHERE clause with computation, ANY/ALL subqueries!
+
      UPDATE VTABLE
           SET COL1 = 1
           WHERE COL1 = 0;
 1 row inserted/updated/deleted
 ij> -- PASS:0262 If 1 row is updated?
+
      SELECT COL1, COL2
           FROM VTABLE
           WHERE (COL3 * COL2/COL1) > ALL
@@ -47,11 +57,15 @@
 ij> -- PASS:0262 If 2 rows are selected?
 -- PASS:0262 If first row is  ( 100,   200)?
 -- PASS:0262 If second row is (1000, -2000)?
+
 -- restore
      ROLLBACK WORK;
 ij> -- END TEST >>> 0262 <<< END TEST
+ 
 -- ******************************************************************
+
 -- TEST:0263 Computed column in ORDER BY!
+
      SELECT COL1, (COL3 * COL2/COL1 - COL2 + 10)
           FROM VTABLE
           WHERE COL1 > 0
@@ -65,14 +79,19 @@
 -- PASS:0263      (1000, -3990)?
 -- PASS:0263      (  10,    50)?
 -- PASS:0263      ( 100,   410)?
+
 -- END TEST >>> 0263 <<< END TEST
+
 -- ********************************************************************
+
 -- TEST:0265 Update:searched - view with check option!
+
 -- setup
      INSERT INTO WORKS
             VALUES('E3','P4',50);
 1 row inserted/updated/deleted
 ij> -- PASS:0265 If 1 row is inserted?
+
            SELECT EMPNUM, PNUM, HOURS
                 FROM SUBSP;
 EM&|PN&|HOURS 
@@ -80,6 +99,7 @@
 E3 |P2 |20    
 E3 |P4 |50    
 ij> -- PASS:0265 If 2 rows are selected?
+
      SELECT * FROM WORKS;
 EM&|PN&|HOURS 
 --------------
@@ -97,10 +117,12 @@
 E4 |P5 |80    
 E3 |P4 |50    
 ij> -- PASS:0265 If 13 rows selected?
+
 --O     UPDATE SUBSP 
 --O          SET EMPNUM = 'E9'
 --O          WHERE PNUM = 'P2';
 -- PASS:0265 If ERROR, view check constraint, 0 rows are updated?
+ 
      SELECT * FROM WORKS;
 EM&|PN&|HOURS 
 --------------
@@ -118,16 +140,21 @@
 E4 |P5 |80    
 E3 |P4 |50    
 ij> -- PASS:0265 If 13 rows selected and no EMPNUM = 'E9'?
+
 -- restore
      ROLLBACK WORK;
 ij> -- END TEST >>> 0265 <<< END TEST
+
 -- ******************************************************************
+
 -- TEST:0266 Update:searched - UNIQUE violation under view!
+
 -- setup
      INSERT INTO WORKS
             VALUES('E3','P4',50);
 1 row inserted/updated/deleted
 ij> -- PASS:0266 If 1 row is inserted?
+
      SELECT EMPNUM, PNUM, HOURS
           FROM SUBSP;
 EM&|PN&|HOURS 
@@ -135,29 +162,39 @@
 E3 |P2 |20    
 E3 |P4 |50    
 ij> -- PASS:0266 If 2 rows are selected?
+
      SELECT * FROM WORKS WHERE EMPNUM = 'E3';
 EM&|PN&|HOURS 
 --------------
 E3 |P2 |20    
 E3 |P4 |50    
 ij> -- PASS:0266 If 2 rows selected and PNUM values are 'P2' and 'P4'?
+
 --O     UPDATE SUBSP
 --O          SET PNUM = 'P6'
 --O          WHERE EMPNUM = 'E3';
 -- PASS:0266 If ERROR, unique constraint, 0 rows updated?
+
 --O     SELECT EMPNUM, PNUM, HOURS
 --O          FROM SUBSP;
 -- PASS:0266 If 2 rows are selected?
+
 --O     SELECT * FROM WORKS WHERE EMPNUM = 'E3';
 -- PASS:0266 If 2 rows selected and PNUM values are 'P2' and 'P4'?
+
 -- restore
      ROLLBACK WORK;
 ij> -- END TEST >>> 0266 <<< END TEST
+
 -- ******************************************************************
+
 -- TEST:0267 Update compound key, interim uniqueness conflict!
+
      DELETE FROM WORKS1;
 0 rows inserted/updated/deleted
+WARNING 02000: No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table.
 ij> -- Making sure the table is empty
+
 -- setup
      INSERT INTO WORKS1 VALUES ('P1','P6',1);
 1 row inserted/updated/deleted
@@ -235,6 +272,7 @@
        SET PNUM = EMPNUM, EMPNUM = PNUM;
 36 rows inserted/updated/deleted
 ij> -- PASS:0267 If 36 rows are updated?
+
 --O     SELECT COUNT(*) 
      SELECT * 
           FROM WORKS1
@@ -248,9 +286,11 @@
 P1 |P5 |35    
 P1 |P6 |36    
 ij> -- PASS:0267 If count = 6?
+
 -- restore
      ROLLBACK WORK;
 ij> -- END TEST >>> 0267 <<< END TEST
+
 -- *************************************************////END-OF-MODULE
 ;
-ij> 
+ij> 
\ No newline at end of file

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml061.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml061.out?view=diff&rev=468514&r1=468513&r2=468514
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml061.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml061.out Fri Oct 27 13:04:21 2006
@@ -1,8 +1,10 @@
 ij> AUTOCOMMIT OFF;
 ij> -- MODULE  DML061
+
 -- SQL Test Suite, V6.0, Interactive SQL, dml061.sql
 -- 59-byte ID
 -- TEd Version #
+
 -- AUTHORIZATION HU
    set schema HU;
 0 rows inserted/updated/deleted
@@ -12,8 +14,11 @@
 --------------------------------------------------------------------------------------------------------------------------------
 HU                                                                                                                              
 ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment
+
 -- date_time print
+
 -- TEST:0269 BETWEEN value expressions in wrong order!
+
             SELECT COUNT(*)
             FROM WORKS
             WHERE HOURS BETWEEN 80 AND 40;
@@ -21,6 +26,7 @@
 -----------
 0          
 ij> -- PASS:0269 If count = 0   ?
+
 -- setup   
          INSERT INTO WORKS
             VALUES('E6','P6',-60);
@@ -32,6 +38,7 @@
 -----------
 0          
 ij> -- PASS:0269 If count = 0?
+
             SELECT COUNT(*)
             FROM WORKS
             WHERE HOURS BETWEEN -80 AND -40;
@@ -39,11 +46,16 @@
 -----------
 1          
 ij> -- PASS:0269 If count = 1?
+
 -- restore
     ROLLBACK WORK;
 ij> -- END TEST >>> 0269 <<< END TEST
+
 -- ****************************************************************
+
+
 -- TEST:0270 BETWEEN approximate and exact numeric values!
+
             SELECT COUNT(*)
             FROM WORKS
             WHERE HOURS BETWEEN 11.999 AND 12 OR
@@ -52,9 +64,14 @@
 -----------
 6          
 ij> -- PASS:0270 If count = 6?
+
 -- END TEST >>> 0270 <<< END TEST
+
 -- ****************************************************************
+
+
 -- TEST:0271 COUNT(*) with Cartesian product subset !
+
             SELECT COUNT(*)
             FROM WORKS,STAFF
             WHERE WORKS.EMPNUM = 'E1';
@@ -62,21 +79,28 @@
 -----------
 30         
 ij> -- PASS:0271 If count = 30?
+
 -- END TEST >>> 0271 <<< END TEST
+
 -- ****************************************************************
+
+
 -- TEST:0272 Statement rollback for integrity!
         UPDATE WORKS
         SET EMPNUM = 'E7'
         WHERE EMPNUM = 'E1' OR EMPNUM = 'E4';
 ERROR 23505: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'WORKSC1' defined on 'WORKS'.
 ij> -- PASS:0272 If ERROR, unique constraint, 0 rows updated?
+
         INSERT INTO WORKS 
         SELECT 'E3',PNUM,17 FROM PROJ;
 ERROR 23505: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'WORKSC1' defined on 'WORKS'.
 ij> -- PASS:0272 If ERROR, unique constraint, 0 rows inserted?
+
 --0        UPDATE V_WORKS1
 --0        SET HOURS = HOURS - 9;
 -- PASS:0272 If ERROR, view check constraint, 0 rows updated?
+
         SELECT COUNT(*)
         FROM WORKS
         WHERE EMPNUM = 'E7' OR HOURS = 31 OR HOURS = 17;
@@ -84,15 +108,21 @@
 -----------
 0          
 ij> -- PASS:0272 If count = 0?
+
 -- restore
        ROLLBACK WORK;
 ij> -- END TEST >>> 0272 <<< END TEST
+
 -- ****************************************************************
+
+
 -- TEST:0273 SUM, MAX, MIN = NULL for empty arguments  !
+
             UPDATE WORKS
             SET HOURS = NULL;
 12 rows inserted/updated/deleted
 ij> -- PASS:0273 If 12 rows updated?
+
             SELECT SUM(HOURS),MAX(HOURS),MIN(HOURS),MIN(EMPNUM)
                 FROM WORKS;
 1          |2     |3     |4   
@@ -101,27 +131,36 @@
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> -- PASS:0273 If 1 row is selected?
 -- PASS:0273 If SUM(HOURS), MAX(HOURS), and MIN(HOURS) are NULL?
+
 -- restore
     ROLLBACK WORK;
 ij> -- END TEST >>> 0273 <<< END TEST
+
 -- ****************************************************************
+
+
 -- TEST:0277 Computation with NULL value specification!
+
           UPDATE WORKS
           SET HOURS = NULL  WHERE EMPNUM = 'E1';
 6 rows inserted/updated/deleted
 ij> -- PASS:0277 If 6 rows are updated?
+ 
           UPDATE WORKS
           SET HOURS = HOURS - (3 + -17);
 12 rows inserted/updated/deleted
 ij> -- PASS:0277 If 12 rows are updated?
+ 
           UPDATE WORKS
           SET HOURS = 3 / -17 * HOURS;
 12 rows inserted/updated/deleted
 ij> -- PASS:0277 If 12 rows are updated?
+  
           UPDATE WORKS
           SET HOURS = HOURS + 5;
 12 rows inserted/updated/deleted
 ij> -- PASS:0277 If 12 rows are updated?
+  
           SELECT COUNT(*)
           FROM WORKS
           WHERE HOURS IS NULL;
@@ -129,16 +168,22 @@
 -----------
 6          
 ij> -- PASS:0277 If count = 6?
+
 -- restore 
     ROLLBACK WORK;
 ij> -- END TEST >>> 0277 <<< END TEST
+
 -- ****************************************************************
+
+
 -- TEST:0278 IN value list with USER, literal, variable spec.!
+
           UPDATE STAFF
           SET EMPNAME = 'HU'
           WHERE EMPNAME = 'Ed';
 1 row inserted/updated/deleted
 ij> -- PASS:0278 If 1 row is updated?
+
           SELECT COUNT(*)
           FROM STAFF
           WHERE EMPNAME IN (USER,'Betty','Carmen');
@@ -146,9 +191,11 @@
 -----------
 3          
 ij> -- PASS:0278 If count = 3?
+
 -- restore
     ROLLBACK WORK;
 ij> -- END TEST >>> 0278 <<< END TEST
+
 -- *************************************************////END-OF-MODULE
 ;
-ij> 
+ij> 
\ No newline at end of file

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml065.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml065.out?view=diff&rev=468514&r1=468513&r2=468514
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml065.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml065.out Fri Oct 27 13:04:21 2006
@@ -1,8 +1,10 @@
 ij> AUTOCOMMIT OFF;
 ij> -- MODULE DML065
+
 -- SQL Test Suite, V6.0, Interactive SQL, dml065.sql
 -- 59-byte ID
 -- TEd Version #
+
 -- AUTHORIZATION HU
    set schema HU;
 0 rows inserted/updated/deleted
@@ -12,8 +14,11 @@
 --------------------------------------------------------------------------------------------------------------------------------
 HU                                                                                                                              
 ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment
+
 -- date_time print
+
 -- TEST:0284 INSERT, SELECT char. strings with blank!
+
   INSERT INTO STAFF(EMPNUM,EMPNAME)
          VALUES ('E6','Ed');
 1 row inserted/updated/deleted
@@ -33,6 +38,7 @@
 E7 |Ed                  |NULL |NULL           
 E8 |Ed                  |NULL |NULL           
 ij> -- PASS:0284 If count = 4?
+
 --O  SELECT COUNT(*) FROM STAFF
   SELECT * FROM STAFF
                   WHERE EMPNAME = 'Ed ';
@@ -43,6 +49,7 @@
 E7 |Ed                  |NULL |NULL           
 E8 |Ed                  |NULL |NULL           
 ij> -- PASS:0284 If count = 4?
+
 --O  SELECT COUNT(*) FROM STAFF
   SELECT * FROM STAFF
                   WHERE EMPNAME = 'Ed                ';
@@ -53,11 +60,16 @@
 E7 |Ed                  |NULL |NULL           
 E8 |Ed                  |NULL |NULL           
 ij> -- PASS:0284 If count = 4?
+
 -- restore
   ROLLBACK WORK;
 ij> -- END TEST >>> 0284 <<< END TEST
+
 -- *************************************************
+
+
 -- TEST:0285 INSERT, SELECT integer with various formats!
+
   INSERT INTO STAFF(EMPNUM,GRADE)
          VALUES ('E6',25);
 1 row inserted/updated/deleted
@@ -84,12 +96,18 @@
 E8 |NULL                |25   |NULL           
 E9 |NULL                |25   |NULL           
 ij> -- PASS:0285 If count = 4?
+
 -- restore
   ROLLBACK WORK;
 ij> -- END TEST >>> 0285 <<< END TEST
+
 -- *************************************************
+
+
 -- NO_TEST:0286 Compatibility of structures and host variables!
+
 -- Testing host identifiers
+
 -- *************************************************////END-OF-MODULE
 ;
-ij> 
+ij> 
\ No newline at end of file

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml068.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml068.out?view=diff&rev=468514&r1=468513&r2=468514
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml068.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml068.out Fri Oct 27 13:04:21 2006
@@ -1,8 +1,10 @@
 ij> AUTOCOMMIT OFF;
 ij> -- MODULE DML068 
+
 -- SQL Test Suite, V6.0, Interactive SQL, dml068.sql
 -- 59-byte ID
 -- TEd Version #
+
 -- AUTHORIZATION HU 
    set schema HU;
 0 rows inserted/updated/deleted
@@ -12,13 +14,18 @@
 --------------------------------------------------------------------------------------------------------------------------------
 HU                                                                                                                              
 ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment
+
 -- date_time print
+
 -- TEST:0389 95-character graphic subset of ASCII!
 -- NOTE:  OPTIONAL test
 -- NOTE:0389 Collating sequence is implementor defined
+
      DELETE FROM AA;
 0 rows inserted/updated/deleted
+WARNING 02000: No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table.
 ij> -- Making sure the table is empty
+
 -- setup
      INSERT INTO AA VALUES('@ at');
 1 row inserted/updated/deleted
@@ -145,6 +152,8 @@
 -- PASS:0389    description in positions 2-4                      ?
 -- PASS:0389 If ASCII, then ORDER is: space followed by characters?
 -- PASS:0389    !"#$%&'()*+,-./09:;<=>?@AZ[\]^_`az{|}~            ?
+
+
 --O     SELECT COUNT(*)
      SELECT *
           FROM AA;
@@ -190,9 +199,10 @@
   sp                
 ZZZZ                
 ij> -- PASS:0389 If count = 39? 
+
 -- restore
      ROLLBACK WORK;
 ij> -- END TEST >>> 0389 <<< END TEST
 -- *************************************************////END-OF-MODULE
 ;
-ij> 
+ij> 
\ No newline at end of file

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml069.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml069.out?view=diff&rev=468514&r1=468513&r2=468514
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml069.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml069.out Fri Oct 27 13:04:21 2006
@@ -1,8 +1,10 @@
 ij> AUTOCOMMIT OFF;
 ij> -- MODULE DML069 
+
 -- SQL Test Suite, V6.0, Interactive SQL, dml069.sql
 -- 59-byte ID
 -- TEd Version #
+
 -- AUTHORIZATION HU 
    set schema HU;
 0 rows inserted/updated/deleted
@@ -12,18 +14,28 @@
 --------------------------------------------------------------------------------------------------------------------------------
 HU                                                                                                                              
 ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment
+
 -- date_time print
+
 -- NO_TEST:0404 2 FETCHes (different target types) on same cursor!
+
 -- Testing cursors
+
 -- ***************************************************************
+
 -- NO_TEST:0405 2 cursors open from different schemas (coded join)!
+
 -- Testing cursors
+
 -- ***************************************************************
+
 -- TEST:0406 Subquery from different schema!
+ 
 --O     DELETE FROM CUGINI.VTABLE;
      DELETE FROM VTABLE;
 4 rows inserted/updated/deleted
 ij> -- Making sure the table is empty
+
 -- setup 
 --O     INSERT INTO CUGINI.VTABLE VALUES (80, 100, 100, 100, 100.0);
      INSERT INTO VTABLE VALUES (80, 100, 100, 100, 100.0);
@@ -41,17 +53,25 @@
 ---
 P3 
 ij> -- PASS:0406 If PNUM = 'P3'?
+
 -- restore
      ROLLBACK WORK;
 ij> -- END TEST >>> 0406 <<< END TEST
 -- *************************************************************
+
 -- NO_TEST:0407 SELECT INTO :XX ... WHERE :XX = !
+
 -- Testing host variables
+
 -- **************************************************************
+
 -- TEST:0408 UPDATE references column value BEFORE update!
+
      DELETE FROM WORKS1;
 0 rows inserted/updated/deleted
+WARNING 02000: No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table.
 ij> -- Making sure the table is empty
+
 -- setup
      INSERT INTO WORKS1 SELECT * FROM WORKS;
 12 rows inserted/updated/deleted
@@ -72,9 +92,11 @@
 -- PASS:0408 If FOR ROW #2, EMPNO1 = 'P2', PNUM1 = 'E2',HOURS1 = 6640? 
 -- PASS:0408 If FOR ROW #3, EMPNO1 = 'P2', PNUM1 = 'E3', HOURS1 = 460?
 -- PASS:0408 If FOR ROW #4, EMPNO1 = 'P2', PNUM1 = 'E4', HOURS1 = 460?
+ 
+
 -- restore
      ROLLBACK WORK;
 ij> -- END TEST >>> 0408 <<< END TEST
 -- *************************************************////END-OF-MODULE
 ;
-ij> 
+ij> 
\ No newline at end of file

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml070.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml070.out?view=diff&rev=468514&r1=468513&r2=468514
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml070.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml070.out Fri Oct 27 13:04:21 2006
@@ -1,8 +1,10 @@
 ij> AUTOCOMMIT OFF;
 ij> -- MODULE DML070
+
 -- SQL Test Suite, V6.0, Interactive SQL, dml070.sql
 -- 59-byte ID
 -- TEd Version #
+
 -- AUTHORIZATION HU 
    set schema HU;
 0 rows inserted/updated/deleted
@@ -12,8 +14,11 @@
 --------------------------------------------------------------------------------------------------------------------------------
 HU                                                                                                                              
 ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment
+
 -- date_time print
+
 -- TEST:0409 Effective outer join -- with 2 cursors!
+
 -- setup
      INSERT INTO STAFF
            VALUES('E6','Lendle',17,'Potomac');
@@ -39,6 +44,7 @@
 ij> -- PASS:0409 If twelve rows are selected with ROW #9 as follows?
 -- PASS:0409 PNUM   WORKS.EMPNUM   EMPNAME    HOURS?
 -- PASS:0409  P2         E3         Carmen     20?
+
      SELECT 'ZZ', EMPNUM, EMPNAME, -99
            FROM STAFF
            WHERE NOT EXISTS (SELECT * FROM WORKS
@@ -52,11 +58,14 @@
 -- PASS:0409 'ZZ'     STAFF.EMPNUM     EMPNAME     HOURS?
 -- PASS:0409  ZZ          E5              Ed        -99?
 -- PASS:0409  ZZ          E6            Lendle      -99?
+
 -- restore
      ROLLBACK WORK;
 ij> -- END TEST >>> 0409 <<< END TEST
 -- *****************************************************
+
 -- TEST:0411 Effective set difference!
+
      SELECT W1.EMPNUM FROM WORKS W1
            WHERE W1.PNUM = 'P2'
                 AND NOT EXISTS (SELECT * FROM WORKS W2
@@ -70,9 +79,12 @@
 ij> -- PASS:0411 If 2 rows are selected?
 -- PASS:0411 If FOR ROW #1, W1.EMPNUM = 'E3'?
 -- PASS:0411 If FOR ROW #2, W1.EMPNUM = 'E4'?
+
 -- END TEST >>> 0411 <<< END TEST
 -- *************************************************************
+
 -- TEST:0412 Effective set intersection!
+
      SELECT W1.EMPNUM FROM WORKS W1
            WHERE W1.PNUM = 'P2'
                 AND EXISTS (SELECT * FROM WORKS W2
@@ -86,7 +98,10 @@
 ij> -- PASS:0412 If 2 rows are selected?
 -- PASS:0412 If FOR ROW #1, W1.EMPNUM = 'E1'?
 -- PASS:0412 If FOR ROW #2, W1.EMPNUM = 'E2'?
+
 -- END TEST >>> 0412 <<< END TEST
 -- *************************************************////END-OF-MODULE
+
+
 ;
-ij> 
+ij> 
\ No newline at end of file

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml073.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml073.out?view=diff&rev=468514&r1=468513&r2=468514
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml073.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml073.out Fri Oct 27 13:04:21 2006
@@ -1,8 +1,10 @@
 ij> AUTOCOMMIT OFF;
 ij> -- MODULE DML073
+
 -- SQL Test Suite, V6.0, Interactive SQL, dml073.sql
 -- 59-byte ID
 -- TEd Version #
+
 -- AUTHORIZATION HU 
    set schema HU;
 0 rows inserted/updated/deleted
@@ -12,17 +14,23 @@
 --------------------------------------------------------------------------------------------------------------------------------
 HU                                                                                                                              
 ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment
+
 -- date_time print
+
 -- TEST:0393 SUM, MAX on Cartesian product!
+
      SELECT SUM(HOURS), MAX(HOURS)
            FROM  STAFF, WORKS;
 1          |2     
 ------------------
 2320       |80    
 ij> -- PASS:0393 If SUM(HOURS) = 2320 and MAX(HOURS) = 80?
+
 -- END TEST >>> 0393 <<< END TEST
 -- *************************************************************
+
 -- TEST:0394 AVG, MIN on joined table with WHERE without GROUP!
+
      SELECT AVG(HOURS), MIN(HOURS)
            FROM  STAFF, WORKS
            WHERE STAFF.EMPNUM = 'E2'
@@ -31,9 +39,12 @@
 --------------------
 60.0000      |40    
 ij> -- PASS:0394 If AVG(HOURS) = 60 and MIN(HOURS) = 40?
+
 -- END TEST >>> 0394 <<< END TEST
 -- *************************************************************
+
 -- TEST:0395 SUM, MIN on joined table with GROUP without WHERE!
+
      SELECT STAFF.EMPNUM, SUM(HOURS), MIN(HOURS)
            FROM  STAFF, WORKS
            GROUP BY STAFF.EMPNUM
@@ -52,9 +63,12 @@
 -- PASS:0395    'E3'         464          12?
 -- PASS:0395    'E4'         464          12?
 -- PASS:0395    'E5'         464          12?
+
 -- END TEST >>> 0395 <<< END TEST
 -- *************************************************************
+
 -- TEST:0396 SUM, MIN on joined table with WHERE, GROUP BY, HAVING!
+ 
      SELECT STAFF.EMPNUM, AVG(HOURS), MIN(HOURS)
            FROM  STAFF, WORKS
            WHERE STAFF.EMPNUM IN ('E1','E4','E3') AND
@@ -71,12 +85,17 @@
 -- PASS:0396 STAFF.EMPNUM   AVG(HOURS)  MIN(HOURS)?
 -- PASS:0396     'E1'        30 to 31      12?
 -- PASS:0396     'E4'        46 to 47      20?
+
 -- END TEST >>> 0396 <<< END TEST
 -- *************************************************************
+
 -- TEST:0417 Cartesian product GROUP BY 2 columns with NULLs!
+
      DELETE FROM STAFF1;
 0 rows inserted/updated/deleted
+WARNING 02000: No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table.
 ij> -- Making sure the table is empty
+
 -- setup          
      INSERT INTO STAFF VALUES ('E6', 'David', 17, NULL);
 1 row inserted/updated/deleted
@@ -111,11 +130,14 @@
 -- PASS:0417 MAX(STAFF1.GRADE) = 18 and SUM(STAFF1.GRADE) = 70?
 -- PASS:0417 MAX(STAFF1.GRADE) = 18 and SUM(STAFF1.GRADE) = 70?
 -- PASS:0417 MAX(STAFF1.GRADE) = 18 and SUM(STAFF1.GRADE) = 70?
+
 -- restore
      ROLLBACK WORK;
 ij> -- END TEST >>> 0417 <<< END TEST
 -- *************************************************************
+
 -- TEST:0418 AVG, SUM, COUNT on Cartesian product with NULL!
+
      SELECT AVG(T1.COL4), AVG(T1.COL4 + T2.COL4),
            SUM(T2.COL4), COUNT(DISTINCT T1.COL4)
            FROM VTABLE T1, VTABLE T2;
@@ -127,16 +149,20 @@
 -- PASS:0418 If AVG(T1.COL4 + T2.COL4) = 295 or 296?
 -- PASS:0418 If SUM(T2.COL4) = 1772?
 -- PASS:0418 If COUNT(DISTINCT T1.COL4) = 3?
+
 -- END TEST >>> 0418 <<< END TEST
 -- *************************************************************
+
 -- TEST:0419 SUM, MAX, MIN on joined table view!
+
      SELECT SUM(COST), MAX(COST), MIN(COST)
            FROM STAFF_WORKS_DESIGN;
 1                               |2                   |3                   
 --------------------------------------------------------------------------
 3488                            |960                 |288                 
 ij> -- PASS:0419 If SUM(COST) = 3488, MAX(COST) = 960, MIN(COST) = 288?
+
 -- END TEST >>> 0419 <<< END TEST
 -- *************************************************////END-OF-MODULE
 ;
-ij> 
+ij> 
\ No newline at end of file

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml075.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml075.out?view=diff&rev=468514&r1=468513&r2=468514
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml075.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml075.out Fri Oct 27 13:04:21 2006
@@ -1,8 +1,10 @@
 ij> AUTOCOMMIT OFF;
 ij> -- MODULE DML075
+
 -- SQL Test Suite, V6.0, Interactive SQL, dml075.sql
 -- 59-byte ID
 -- TEd Version #
+
 -- AUTHORIZATION HU
    set schema HU;
 0 rows inserted/updated/deleted
@@ -12,8 +14,11 @@
 --------------------------------------------------------------------------------------------------------------------------------
 HU                                                                                                                              
 ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment
+
 -- date_time print
+
 -- TEST:0431 Redundant rows in IN subquery!
+
 --O   SELECT COUNT (*) FROM STAFF
    SELECT * FROM STAFF
        WHERE EMPNUM IN
@@ -25,6 +30,7 @@
 E3 |Carmen              |13   |Vienna         
 E4 |Don                 |12   |Deale          
 ij> -- PASS:0431 If count = 4?
+
    INSERT INTO STAFF1
        SELECT * FROM STAFF;
 5 rows inserted/updated/deleted
@@ -39,11 +45,15 @@
 E3 |Carmen              |13   |Vienna         
 E4 |Don                 |12   |Deale          
 ij> -- PASS:0431 If count = 4?
+
    ROLLBACK WORK;
 ij> -- END TEST >>> 0431 <<< END TEST
 -- *************************************************************
+
 -- TEST:0432 Unknown comparison predicate in ALL, SOME, ANY!
+
 -- setup
+
 UPDATE PROJ SET CITY = NULL 
   WHERE PNUM = 'P3';
 1 row inserted/updated/deleted
@@ -56,6 +66,7 @@
 EM&|EMPNAME             |GRADE|CITY           
 ----------------------------------------------
 ij> -- PASS:0432 If count = 0?
+
 --OSELECT COUNT(*)
 SELECT *
   FROM STAFF
@@ -65,6 +76,7 @@
 EM&|EMPNAME             |GRADE|CITY           
 ----------------------------------------------
 ij> -- PASS:0432 If count = 0?
+
 --OSELECT COUNT(*)
 SELECT *
   FROM STAFF
@@ -76,6 +88,7 @@
 E1 |Alice               |12   |Deale          
 E4 |Don                 |12   |Deale          
 ij> -- PASS:0432 If count = 2?
+
 --OSELECT COUNT(*)
 SELECT *
   FROM STAFF
@@ -88,6 +101,7 @@
 E3 |Carmen              |13   |Vienna         
 E5 |Ed                  |13   |Akron          
 ij> -- PASS:0432 If count = 3?
+
 --OSELECT COUNT(*)
 SELECT *
   FROM STAFF
@@ -99,6 +113,7 @@
 E1 |Alice               |12   |Deale          
 E4 |Don                 |12   |Deale          
 ij> -- PASS:0432 If count = 2?
+
 --OSELECT COUNT(*)
 SELECT *
   FROM STAFF
@@ -111,10 +126,13 @@
 E3 |Carmen              |13   |Vienna         
 E5 |Ed                  |13   |Akron          
 ij> -- PASS:0432 If count = 3?
+
    ROLLBACK WORK;
 ij> -- END TEST >>> 0432 <<< END TEST
 -- *************************************************************
+
 -- TEST:0433 Empty subquery in ALL, SOME, ANY!
+
 --O   SELECT COUNT(*) FROM PROJ
    SELECT * FROM PROJ
         WHERE PNUM = ALL (SELECT PNUM
@@ -128,6 +146,7 @@
 P5 |IRM                 |Test  |10000     |Vienna         
 P6 |PAYR                |Design|50000     |Deale          
 ij> -- PASS:0433 If count = 6?
+
 --O   SELECT COUNT(*) FROM PROJ
    SELECT * FROM PROJ
         WHERE PNUM <> ALL (SELECT PNUM
@@ -141,6 +160,7 @@
 P5 |IRM                 |Test  |10000     |Vienna         
 P6 |PAYR                |Design|50000     |Deale          
 ij> -- PASS:0433 If count = 6?
+
 --O   SELECT COUNT(*) FROM PROJ
    SELECT * FROM PROJ
         WHERE PNUM = ANY (SELECT PNUM
@@ -148,6 +168,7 @@
 PN&|PNAME               |PTYPE |BUDGET    |CITY           
 ----------------------------------------------------------
 ij> -- PASS:0433 If count = 0?
+
 --O   SELECT COUNT(*) FROM PROJ
    SELECT * FROM PROJ
         WHERE PNUM <> ANY (SELECT PNUM
@@ -155,6 +176,7 @@
 PN&|PNAME               |PTYPE |BUDGET    |CITY           
 ----------------------------------------------------------
 ij> -- PASS:0433 If count = 0?
+
 --O   SELECT COUNT(*) FROM PROJ
    SELECT * FROM PROJ
         WHERE PNUM = SOME (SELECT PNUM
@@ -162,6 +184,7 @@
 PN&|PNAME               |PTYPE |BUDGET    |CITY           
 ----------------------------------------------------------
 ij> -- PASS:0433 If count = 0?
+
 --O   SELECT COUNT(*) FROM PROJ
    SELECT * FROM PROJ
         WHERE PNUM <> SOME (SELECT PNUM
@@ -169,9 +192,12 @@
 PN&|PNAME               |PTYPE |BUDGET    |CITY           
 ----------------------------------------------------------
 ij> -- PASS:0433 If count = 0?
+
 -- END TEST >>> 0433 <<< END TEST
 -- *************************************************************
+
 -- TEST:0434 GROUP BY with HAVING EXISTS-correlated set function!
+
    SELECT PNUM, SUM(HOURS) FROM WORKS c
           GROUP BY PNUM
 --O          HAVING EXISTS (SELECT PNAME FROM PROJ
@@ -189,9 +215,12 @@
 ij> -- PASS:0434 If 2 rows selected with values (in any order):?
 -- PASS:0434 PNUM = 'P1', SUM(HOURS) = 80?
 -- PASS:0434 PNUM = 'P5', SUM(HOURS) = 92?
+
 -- END TEST >>> 0434 <<< END TEST
 -- *************************************************************
+
 -- TEST:0442 DISTINCT with GROUP BY, HAVING!
+
    SELECT PTYPE, CITY FROM PROJ
           GROUP BY PTYPE, CITY
           HAVING AVG(BUDGET) > 21000;
@@ -202,6 +231,7 @@
 Test  |Tampa          
 ij> -- PASS:0442 If 3 rows selected with PTYPE/CITY values(in any order):?
 -- PASS:0442 Code/Vienna, Design/Deale, Test/Tampa?
+
    SELECT DISTINCT PTYPE, CITY FROM PROJ
           GROUP BY PTYPE, CITY
           HAVING AVG(BUDGET) > 21000;
@@ -212,6 +242,7 @@
 Test  |Tampa          
 ij> -- PASS:0442 If 3 rows selected with PTYPE/CITY values(in any order):?
 -- PASS:0442 Code/Vienna, Design/Deale, Test/Tampa?
+
    SELECT DISTINCT SUM(BUDGET) FROM PROJ
           GROUP BY PTYPE, CITY
           HAVING AVG(BUDGET) > 21000;
@@ -221,7 +252,8 @@
 80000              
 ij> -- PASS:0442 If 2 rows selected (in any order):?
 -- PASS:0442 with SUM(BUDGET) values 30000 and 80000?
+
 -- END TEST >>> 0442 <<< END TEST
 -- *************************************************////END-OF-MODULE
 ;
-ij> 
+ij> 
\ No newline at end of file

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml076.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml076.out?view=diff&rev=468514&r1=468513&r2=468514
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml076.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml076.out Fri Oct 27 13:04:21 2006
@@ -1,8 +1,10 @@
 ij> AUTOCOMMIT OFF;
 ij> -- MODULE DML076
+
 -- SQL Test Suite, V6.0, Interactive SQL, dml076.sql
 -- 59-byte ID
 -- TEd Version #
+
 -- AUTHORIZATION HU
    set schema HU;
 0 rows inserted/updated/deleted
@@ -12,11 +14,17 @@
 --------------------------------------------------------------------------------------------------------------------------------
 HU                                                                                                                              
 ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment
+
 -- date_time print
+
 -- NO_TEST:0435 Host variables in UPDATE WHERE CURRENT!
+
 -- Testing cursors <update statement:positioned>
+
 -- *************************************************************
+
 -- TEST:0436 NULL values for various SQL data types!
+
     INSERT INTO BB VALUES(NULL);
 1 row inserted/updated/deleted
 ij> INSERT INTO EE VALUES(NULL);
@@ -39,18 +47,24 @@
 ----
 NULL
 ij> -- PASS:0436 If CHARTEST is NULL (Implementor defined print format)?
+
+
     SELECT INTTEST
       FROM EE;
 INTTEST    
 -----------
 NULL       
 ij> -- PASS:0436 If INTTEST is NULL (Implementor defined print format)?
+
+
     SELECT REALTEST 
       FROM GG;
 REALTEST     
 -------------
 NULL         
 ij> -- PASS:0436 If REALTEST is NULL (Implementor defined print format)?
+
+
 --O    SELECT COUNT(*)
     SELECT *
       FROM GG 
@@ -59,18 +73,24 @@
 -------------
 NULL         
 ij> -- PASS:0436 If count = 1?
+
+
     SELECT SMALLTEST 
       FROM HH;
 SMALL&
 ------
 NULL  
 ij> -- PASS:0436 If SMALLTEST is NULL (Implementor defined print format)?
+
+
     SELECT DOUBLETEST 
       FROM II;
 DOUBLETEST            
 ----------------------
 NULL                  
 ij> -- PASS:0436 If DOUBLETEST is NULL (Implementor defined print format)?
+
+
 --O    SELECT COUNT(*) 
     SELECT * 
       FROM II 
@@ -79,12 +99,16 @@
 ----------------------
 NULL                  
 ij> -- PASS:0436 If count = 1?
+
+
     SELECT FLOATTEST 
       FROM JJ;
 FLOATTEST             
 ----------------------
 NULL                  
 ij> -- PASS:0436 If FLOATTEST is NULL (Implementor defined print format)?
+
+
 --O    SELECT COUNT(*) 
     SELECT * 
       FROM JJ 
@@ -93,30 +117,45 @@
 ----------------------
 NULL                  
 ij> -- PASS:0436 If count = 1?
+
+
     SELECT NUMTEST  
       FROM MM;
 NUMTE&
 ------
 NULL  
 ij> -- PASS:0436 If NUMTEST is NULL (Implementor defined print format)?
+
+
     SELECT NUMTEST 
       FROM SS;
 NUMTEST        
 ---------------
 NULL           
 ij> -- PASS:0436 If NUMTEST is NULL (Implementor defined print format)?
+
+
 -- restore
     ROLLBACK WORK;
 ij> -- END TEST >>> 0436 <<< END TEST
 -- *************************************************************
+
 -- NO_TEST:0437 NULL values for various host variable types!
+
 -- Testing Host Variables & Indicator Variables
+
 -- *************************************************************
+
 -- NO_TEST:0410 NULL value in OPEN CURSOR!
+
 -- Testing Cursors & Indicator Variables
+
 -- *************************************************************
+
 -- NO_TEST:0441 NULL value for various predicates!
+
 -- Testing Indicator Variables
+
 -- *************************************************////END-OF-MODULE
 ;
-ij> 
+ij> 
\ No newline at end of file



Mime
View raw message