db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From d..@apache.org
Subject svn commit: r1448002 [2/6] - in /db/derby/code/trunk/java: client/org/apache/derby/client/am/ engine/org/apache/derby/iapi/reference/ engine/org/apache/derby/iapi/types/ testing/org/apache/derbyTesting/functionTests/master/ testing/org/apache/derbyTest...
Date Wed, 20 Feb 2013 04:42:58 GMT
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/desc_index.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/desc_index.out?rev=1448002&r1=1448001&r2=1448002&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/desc_index.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/desc_index.out Wed Feb 20 04:42:57 2013
@@ -55,13 +55,13 @@ ij> call SYSCS_UTIL.SYSCS_SET_RUNTIMESTA
 ij> maximumdisplaywidth 20000;
 ij> -- should use index i4
 select c1, c3 from tab1 where c2 > 40 and c3 <= 5.3;
-C1         |C3                    
-----------------------------------
-34         |2.7                   
-34         |5.3                   
-34         |1.2                   
--78        |-5.6                  
-55         |-9.85                 
+C1         |C3                      
+------------------------------------
+34         |2.7                     
+34         |5.3                     
+34         |1.2                     
+-78        |-5.6                    
+55         |-9.85                   
 ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS();
 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
                                    
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 -----------------------------------
@@ -208,18 +208,18 @@ Source result set:
 			Negate comparison result: false
 ij> -- should use i1
 select c1, c3, c4 from tab1 order by c1, c3;
-C1         |C3                    |C4                            
------------------------------------------------------------------
--100       |9.1                   |egfh                          
--78        |-5.6                  |jakdsfh                       
-8          |5.6                   |dfg                           
-34         |1.2                   |yty                           
-34         |2.7                   |srg                           
-34         |5.3                   |rtgd                          
-55         |-9.85                 |yudd                          
-56         |6.7                   |dfgs                          
-76         |-9.86                 |yudf                          
-100        |9.0                   |34sfg                         
+C1         |C3                      |C4                            
+-------------------------------------------------------------------
+-100       |9.1                     |egfh                          
+-78        |-5.6                    |jakdsfh                       
+8          |5.6                     |dfg                           
+34         |1.2                     |yty                           
+34         |2.7                     |srg                           
+34         |5.3                     |rtgd                          
+55         |-9.85                   |yudd                          
+56         |6.7                     |dfgs                          
+76         |-9.86                   |yudf                          
+100        |9.0                     |34sfg                         
 ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS();
 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
                                    
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 -----------------------------------
@@ -266,18 +266,18 @@ scan information:
 		None
 ij> -- should use i2
 select c1, c3, c4 from tab1 order by c1 desc, c3 desc, c4 desc;
-C1         |C3                    |C4                            
------------------------------------------------------------------
-100        |9.0                   |34sfg                         
-76         |-9.86                 |yudf                          
-56         |6.7                   |dfgs                          
-55         |-9.85                 |yudd                          
-34         |5.3                   |rtgd                          
-34         |2.7                   |srg                           
-34         |1.2                   |yty                           
-8          |5.6                   |dfg                           
--78        |-5.6                  |jakdsfh                       
--100       |9.1                   |egfh                          
+C1         |C3                      |C4                            
+-------------------------------------------------------------------
+100        |9.0                     |34sfg                         
+76         |-9.86                   |yudf                          
+56         |6.7                     |dfgs                          
+55         |-9.85                   |yudd                          
+34         |5.3                     |rtgd                          
+34         |2.7                     |srg                           
+34         |1.2                     |yty                           
+8          |5.6                     |dfg                           
+-78        |-5.6                    |jakdsfh                       
+-100       |9.1                     |egfh                          
 ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS();
 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
                                    
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 -----------------------------------
@@ -324,18 +324,18 @@ scan information:
 		None
 ij> -- should use i3
 select c1, c3, c4 from tab1 order by c1 desc, c3 asc, c4 desc;
-C1         |C3                    |C4                            
------------------------------------------------------------------
-100        |9.0                   |34sfg                         
-76         |-9.86                 |yudf                          
-56         |6.7                   |dfgs                          
-55         |-9.85                 |yudd                          
-34         |1.2                   |yty                           
-34         |2.7                   |srg                           
-34         |5.3                   |rtgd                          
-8          |5.6                   |dfg                           
--78        |-5.6                  |jakdsfh                       
--100       |9.1                   |egfh                          
+C1         |C3                      |C4                            
+-------------------------------------------------------------------
+100        |9.0                     |34sfg                         
+76         |-9.86                   |yudf                          
+56         |6.7                     |dfgs                          
+55         |-9.85                   |yudd                          
+34         |1.2                     |yty                           
+34         |2.7                     |srg                           
+34         |5.3                     |rtgd                          
+8          |5.6                     |dfg                           
+-78        |-5.6                    |jakdsfh                       
+-100       |9.1                     |egfh                          
 ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS();
 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
                                    
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 -----------------------------------
@@ -382,18 +382,18 @@ scan information:
 		None
 ij> -- should use i4
 select c1, c2, c3 from tab1 order by c2 desc, c3 asc;
-C1         |C2    |C3                    
------------------------------------------
--100       |93    |9.1                   
-34         |68    |2.7                   
-34         |67    |5.3                   
-34         |66    |1.2                   
--78        |45    |-5.6                  
-55         |44    |-9.85                 
-8          |12    |5.6                   
-100        |11    |9.0                   
-76         |2     |-9.86                 
-56         |-3    |6.7                   
+C1         |C2    |C3                      
+-------------------------------------------
+-100       |93    |9.1                     
+34         |68    |2.7                     
+34         |67    |5.3                     
+34         |66    |1.2                     
+-78        |45    |-5.6                    
+55         |44    |-9.85                   
+8          |12    |5.6                     
+100        |11    |9.0                     
+76         |2     |-9.86                   
+56         |-3    |6.7                     
 ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS();
 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
                                    
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 -----------------------------------
@@ -836,18 +836,18 @@ ij> -- test if bulk insert rebuilds desc
 call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'TAB1', 0);
 0 rows inserted/updated/deleted
 ij> select * from tab1 order by c1 desc;
-C1         |C2    |C3                    |C4                            |C5                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  
                                    
+C1         |C2    |C3                      |C4                            |C5                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
                                    
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 -----------------------------------
-100        |11    |9.0                   |34sfg                         |ayupo                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
                                                                                                             
-76         |2     |-9.86                 |yudf                          |45gd                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
                                                                                                             
-56         |-3    |6.7                   |dfgs                          |fds                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
                                                                                                             
-55         |44    |-9.85                 |yudd                          |df89f                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
                                                                                                             
-34         |66    |1.2                   |yty                           |wer                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
                                                                                                             
-34         |68    |2.7                   |srg                           |iur                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
                                                                                                             
-34         |67    |5.3                   |rtgd                          |hds                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
                                                                                                             
-8          |12    |5.6                   |dfg                           |ghji                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
                                                                                                             
--78        |45    |-5.6                  |jakdsfh                       |df89g                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
                                                                                                             
--100       |93    |9.1                   |egfh                          |s6j                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
                                                                                                             
+100        |11    |9.0                     |34sfg                         |ayupo                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
                                                                                                               
+76         |2     |-9.86                   |yudf                          |45gd                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
                                                                                                               
+56         |-3    |6.7                     |dfgs                          |fds                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
                                                                                                               
+55         |44    |-9.85                   |yudd                          |df89f                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
                                                                                                               
+34         |66    |1.2                     |yty                           |wer                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
                                                                                                               
+34         |68    |2.7                     |srg                           |iur                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
                                                                                                               
+34         |67    |5.3                     |rtgd                          |hds                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
                                                                                                               
+8          |12    |5.6                     |dfg                           |ghji                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
                                                                                                               
+-78        |45    |-5.6                    |jakdsfh                       |df89g                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
                                                                                                               
+-100       |93    |9.1                     |egfh                          |s6j                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
                                                                                                               
 ij> -- this tests multiple indexes share one conglomerate if they essentially
 -- are the same
 create table tab2 (c1 int not null primary key, c2 int, c3 int);

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml029.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml029.out?rev=1448002&r1=1448001&r2=1448002&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml029.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml029.out Wed Feb 20 04:42:57 2013
@@ -50,9 +50,9 @@ ij> -- PASS:0130 If 1 row is inserted?
       SELECT *
            FROM JJ
            WHERE FLOATTEST > 123455 AND FLOATTEST < 123457;
-FLOATTEST             
-----------------------
-123456.0              
+FLOATTEST               
+------------------------
+123456.0                
 ij> -- PASS:0130 If count = 1 ?
 
 -- restore
@@ -72,9 +72,9 @@ ij> -- PASS:0131 If 1 row is inserted?
       SELECT *
            FROM JJ
            WHERE FLOATTEST > 122 AND FLOATTEST < 124;
-FLOATTEST             
-----------------------
-123.456               
+FLOATTEST               
+------------------------
+123.456                 
 ij> -- PASS:0131 If count = 1 ?
 
 -- restore
@@ -94,9 +94,9 @@ ij> -- PASS:0182 If 1 row is inserted?
      SELECT *
            FROM JJ
            WHERE FLOATTEST > -124 AND FLOATTEST < -122;
-FLOATTEST             
-----------------------
--123.456              
+FLOATTEST               
+------------------------
+-123.456                
 ij> -- PASS:0182 If count = 1 ?
 
 -- restore

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml034.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml034.out?rev=1448002&r1=1448001&r2=1448002&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml034.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml034.out Wed Feb 20 04:42:57 2013
@@ -27,18 +27,18 @@ ij> -- PASS:0088 If 1 row is inserted?
 
      SELECT REALTEST                                                    
           FROM GG;
-REALTEST     
--------------
-1.234567     
+REALTEST       
+---------------
+1.234567       
 ij> -- PASS:0088 If REALTEST = 1.234567 ?
 -- PASS:0088 OR  is between 1.234562 and 1.234572 ?
 
      SELECT * 
         FROM GG    
         WHERE REALTEST > 1.234561 and REALTEST < 1.234573;
-REALTEST     
--------------
-1.234567     
+REALTEST       
+---------------
+1.234567       
 ij> -- PASS:0088 If 1 row selected?
 
 -- restore                                                                 
@@ -56,18 +56,18 @@ ij> -- PASS:0090 If 1 row is inserted?
 
      SELECT DOUBLETEST                                                  
           FROM II;
-DOUBLETEST            
-----------------------
-123456.123456         
+DOUBLETEST              
+------------------------
+123456.123456           
 ij> -- PASS:0090 If DOUBLETEST = 123456.123456 ?
 -- PASS:0090 OR  is between 123456.123451 and 123456.123461 ?
 
      SELECT * 
        FROM II 
        WHERE DOUBLETEST > 123456.123450 and DOUBLETEST < 123456.123462;
-DOUBLETEST            
-----------------------
-123456.123456         
+DOUBLETEST              
+------------------------
+123456.123456           
 ij> -- PASS:0090 If 1 row selected?
 
 -- restore
@@ -85,18 +85,18 @@ ij> -- PASS:0091 If 1 row is inserted?
                                                                                
      SELECT FLOATTEST                                                  
           FROM JJ;
-FLOATTEST             
-----------------------
-12.345678             
+FLOATTEST               
+------------------------
+12.345678               
 ij> -- PASS:0091 If FLOATTEST = 12.345678 ?
 -- PASS:0091 OR  is between 12.345673 and 12.345683 ?
 
      SELECT * 
        FROM JJ
        WHERE FLOATTEST > 12.345672 and FLOATTEST < 12.345684;
-FLOATTEST             
-----------------------
-12.345678             
+FLOATTEST               
+------------------------
+12.345678               
 ij> -- PASS:0091 If 1 row selected?
 
 -- restore
@@ -114,18 +114,18 @@ ij> -- PASS:0092 If 1 row is inserted?
                                                                                 
      SELECT FLOATTEST                                                   
           FROM KK;
-FLOATTEST             
-----------------------
-123456.123456         
+FLOATTEST               
+------------------------
+123456.123456           
 ij> -- PASS:0092 If FLOATTEST = 123456.123456 ?
 -- PASS:0092 OR  is between 123456.1233 and 123456.1236 ?
 
      SELECT * 
        FROM KK
        WHERE FLOATTEST > 123456.123450 and FLOATTEST < 123456.123462;
-FLOATTEST             
-----------------------
-123456.123456         
+FLOATTEST               
+------------------------
+123456.123456           
 ij> -- PASS:0092 If 1 row selected?
 
 -- restore

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml035.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml035.out?rev=1448002&r1=1448001&r2=1448002&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml035.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml035.out Wed Feb 20 04:42:57 2013
@@ -42,14 +42,14 @@ ij> -- PASS:0157 If 1 row is inserted?
      SELECT FLOATTEST
           FROM JJ
           ORDER BY FLOATTEST DESC;
-FLOATTEST             
-----------------------
-66.3                  
-66.2                  
-0.2222                
--44.5                 
--66.25                
--87.0                 
+FLOATTEST               
+------------------------
+66.3                    
+66.2                    
+0.2222                  
+-44.5                   
+-66.25                  
+-87.0                   
 ij> -- PASS:0157 If 6 rows are selected ?
 -- PASS:0157 If last FLOATTEST = -87 OR  is between -87.5 and -86.5 ?
 

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?rev=1448002&r1=1448001&r2=1448002&view=diff
==============================================================================
--- 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 Wed Feb 20 04:42:57 2013
@@ -33,18 +33,18 @@ ij> -- PASS:0248 If 1 row is inserted?
 
      SELECT FLOATTEST
           FROM JJ;
-FLOATTEST             
-----------------------
-0.1048575             
+FLOATTEST               
+------------------------
+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;
-FLOATTEST             
-----------------------
-0.1048575             
+FLOATTEST               
+------------------------
+0.1048575               
 ij> -- PASS:0248 If count = 1?
 
      DELETE FROM JJ;
@@ -59,18 +59,18 @@ ij> -- PASS:0248 If 1 row is inserted?
 
      SELECT FLOATTEST
           FROM JJ;
-FLOATTEST             
-----------------------
--0.1048575            
+FLOATTEST               
+------------------------
+-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;
-FLOATTEST             
-----------------------
--0.1048575            
+FLOATTEST               
+------------------------
+-0.1048575              
 ij> -- PASS:0248 If count = 1?
 
 -- restore
@@ -95,18 +95,18 @@ ij> -- PASS:0249 If 1 row is inserted?
 
      SELECT REALTEST
           FROM GG;
-REALTEST     
--------------
-0.1048575    
+REALTEST       
+---------------
+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;
-REALTEST     
--------------
-0.1048575    
+REALTEST       
+---------------
+0.1048575      
 ij> -- PASS:0249 If count = 1?
 
      DELETE FROM GG;
@@ -121,18 +121,18 @@ ij> -- PASS:0249 If 1 row is inserted?
 
      SELECT REALTEST
           FROM GG;
-REALTEST     
--------------
--0.1048575   
+REALTEST       
+---------------
+-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;
-REALTEST     
--------------
--0.1048575   
+REALTEST       
+---------------
+-0.1048575     
 ij> -- PASS:0249 If count = 1?
 
 -- restore
@@ -157,18 +157,18 @@ ij> -- PASS:0250 If 1 row is inserted?
 
      SELECT DOUBLETEST
           FROM II;
-DOUBLETEST            
-----------------------
-0.1073741823          
+DOUBLETEST              
+------------------------
+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;
-DOUBLETEST            
-----------------------
-0.1073741823          
+DOUBLETEST              
+------------------------
+0.1073741823            
 ij> -- PASS:0250 If count = 1?
 
      DELETE FROM II;
@@ -183,18 +183,18 @@ ij> -- PASS:0250 If 1 row is inserted?
 
      SELECT DOUBLETEST
           FROM II;
-DOUBLETEST            
-----------------------
--0.1073741823         
+DOUBLETEST              
+------------------------
+-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;
-DOUBLETEST            
-----------------------
--0.1073741823         
+DOUBLETEST              
+------------------------
+-0.1073741823           
 ij> -- PASS:0250 If count = 1?
 
 -- restore 

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?rev=1448002&r1=1448001&r2=1448002&view=diff
==============================================================================
--- 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 Wed Feb 20 04:42:57 2013
@@ -59,9 +59,9 @@ ij> -- PASS:0436 If INTTEST is NULL (Imp
 
     SELECT REALTEST 
       FROM GG;
-REALTEST     
--------------
-NULL         
+REALTEST       
+---------------
+NULL           
 ij> -- PASS:0436 If REALTEST is NULL (Implementor defined print format)?
 
 
@@ -69,9 +69,9 @@ ij> -- PASS:0436 If REALTEST is NULL (Im
     SELECT *
       FROM GG 
       WHERE REALTEST IS NULL;
-REALTEST     
--------------
-NULL         
+REALTEST       
+---------------
+NULL           
 ij> -- PASS:0436 If count = 1?
 
 
@@ -85,9 +85,9 @@ ij> -- PASS:0436 If SMALLTEST is NULL (I
 
     SELECT DOUBLETEST 
       FROM II;
-DOUBLETEST            
-----------------------
-NULL                  
+DOUBLETEST              
+------------------------
+NULL                    
 ij> -- PASS:0436 If DOUBLETEST is NULL (Implementor defined print format)?
 
 
@@ -95,17 +95,17 @@ ij> -- PASS:0436 If DOUBLETEST is NULL (
     SELECT * 
       FROM II 
       WHERE DOUBLETEST IS NULL;
-DOUBLETEST            
-----------------------
-NULL                  
+DOUBLETEST              
+------------------------
+NULL                    
 ij> -- PASS:0436 If count = 1?
 
 
     SELECT FLOATTEST 
       FROM JJ;
-FLOATTEST             
-----------------------
-NULL                  
+FLOATTEST               
+------------------------
+NULL                    
 ij> -- PASS:0436 If FLOATTEST is NULL (Implementor defined print format)?
 
 
@@ -113,9 +113,9 @@ ij> -- PASS:0436 If FLOATTEST is NULL (I
     SELECT * 
       FROM JJ 
       WHERE FLOATTEST IS NULL;
-FLOATTEST             
-----------------------
-NULL                  
+FLOATTEST               
+------------------------
+NULL                    
 ij> -- PASS:0436 If count = 1?
 
 

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml091.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml091.out?rev=1448002&r1=1448001&r2=1448002&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml091.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml091.out Wed Feb 20 04:42:57 2013
@@ -159,8 +159,8 @@ ij> -- NOTE:0497 If we have not inserted
 -- NOTE:0497 If that is not enough, add more INSERTs.
  
    SELECT SUM(T_REAL) FROM FOUR_TYPES;
-1            
--------------
+1              
+---------------
 ERROR 22003: The resulting value is outside the range for the data type REAL.
 ij> -- PASS:0497 If ERROR, data exception/numeric value out of range?
 -- PASS:0497 OR 0 rows selected OR SQLSTATE = 22003 OR SQLCODE < 0?

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml099.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml099.out?rev=1448002&r1=1448001&r2=1448002&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml099.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml099.out Wed Feb 20 04:42:57 2013
@@ -35,9 +35,9 @@ ij> INSERT INTO ICAST2 VALUES (.31416E+1
 ij> -- PASS:0582 If 1 row is inserted?
 
    SELECT C1, C2, C3 FROM ICAST2;
-C1         |C2                    |C3     
-------------------------------------------
-3          |3.0                   |3.142  
+C1         |C2                      |C3     
+--------------------------------------------
+3          |3.0                     |3.142  
 ij> -- PASS:0582 If 1 row is selected with C1 = 3 and C3 = 3.142?
 
    UPDATE ICAST2 SET C1 = 5.2413E+0, C2 = 5, C3 = 5.2413E+0;
@@ -45,9 +45,9 @@ ij> -- PASS:0582 If 1 row is selected wi
 ij> -- PASS:0582 If 1 row is updated?
 
    SELECT C1, C2, C3 FROM ICAST2;
-C1         |C2                    |C3     
-------------------------------------------
-5          |5.0                   |5.241  
+C1         |C2                      |C3     
+--------------------------------------------
+5          |5.0                     |5.241  
 ij> -- PASS:0582 If 1 row is selected with C1 = 5 and C3 = 5.241?
 
    UPDATE ICAST2 SET C1 = 6.28E+0, C2 = 2.1E+0, C3 = .07E+2;
@@ -59,9 +59,9 @@ ij> -- PASS:0582 If 1 row is updated?
 ij> -- PASS:0582 If 1 row is updated?
 
    SELECT C1, C2, C3 FROM ICAST2;
-C1         |C2                    |C3     
-------------------------------------------
-2          |2.1                   |9.100  
+C1         |C2                      |C3     
+--------------------------------------------
+2          |2.1                     |9.100  
 ij> -- PASS:0582 If 1 row is selected with C1 = 2 and C3 = 9.100?
 
    ROLLBACK WORK;

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml106.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml106.out?rev=1448002&r1=1448001&r2=1448002&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml106.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml106.out Wed Feb 20 04:42:57 2013
@@ -256,9 +256,9 @@ ij> -- PASS:0611 If 1 row is inserted?
 
    SELECT SECOND( FIPS2)
   * 1000000 - 999990 FROM TSFIPS;
-1                     
-----------------------
-9.0                   
+1                       
+------------------------
+9.0                     
 ij> -- PASS:0611 If 1 row selected and value is 9?
 
 --0   SELECT YEAR( FIPS3),

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml119.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml119.out?rev=1448002&r1=1448001&r2=1448002&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml119.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml119.out Wed Feb 20 04:42:57 2013
@@ -79,9 +79,9 @@ ij> -- PASS:0647 If 1 row is updated?
 
    SELECT SUM (USER_INPUT) * 100, SUM (RECEIVABLE)
   FROM STANDARD_INPUT;
-1                    |2            
------------------------------------
--95301.00            |-453.02      
+1                    |2              
+-------------------------------------
+-95301.00            |-453.02        
 ij> -- PASS:0647 If 1 row selected and first value is -95301 +- 4?
 -- PASS:0647 AND second value is -453.02 +- 0.04?
 

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml148.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml148.out?rev=1448002&r1=1448001&r2=1448002&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml148.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml148.out Wed Feb 20 04:42:57 2013
@@ -253,13 +253,13 @@ ij> -- PASS:0844 If 5 rows selected with
        ON GRADE * -40 > T7.T_FLOAT
        OR (T_DOUBLE -542.5 < GRADE AND T_DOUBLE -541.5 > GRADE)
    ORDER BY GRADE;
-GRADE|T_FLOAT               |T_DOUBLE              
----------------------------------------------------
-10   |-444.0                |-55.0                 
-12   |NULL                  |NULL                  
-12   |NULL                  |NULL                  
-13   |44.0                  |555.0                 
-13   |44.0                  |555.0                 
+GRADE|T_FLOAT                 |T_DOUBLE                
+-------------------------------------------------------
+10   |-444.0                  |-55.0                   
+12   |NULL                    |NULL                    
+12   |NULL                    |NULL                    
+13   |44.0                    |555.0                   
+13   |44.0                    |555.0                   
 ij> -- PASS:0844 If 5 rows selected with ordered rows and column values ?
 -- PASS:0844    10 -444 (approximately)  -55 (approximately) ?
 -- PASS:0844    12 NULL                 NULL                 ?

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml165.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml165.out?rev=1448002&r1=1448001&r2=1448002&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml165.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml165.out Wed Feb 20 04:42:57 2013
@@ -55,12 +55,12 @@ ij> -- PASS:0870 If 1 row inserted succe
 
    SELECT * FROM APPLES UNION ALL SELECT * FROM ORANGES
      ORDER BY 1;
-1                     |2              
---------------------------------------
-1.0                   |Granny Smith   
-1.5                   |Navel          
-2.0                   |Red Delicious  
-2.5                   |Florida        
+1                       |2              
+----------------------------------------
+1.0                     |Granny Smith   
+1.5                     |Navel          
+2.0                     |Red Delicious  
+2.5                     |Florida        
 ij> -- PASS:0870 If 4 rows returned in the following order?
 --                col1                 col2
 --                ====                 ====



Mime
View raw message