db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kmars...@apache.org
Subject svn commit: r1466316 [1/3] - in /db/derby/code/branches/10.8.3.1_testcompat: ./ java/testing/org/apache/derbyTesting/functionTests/master/ java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/ java/testing/org/apache/derbyTesting/functionTe...
Date Wed, 10 Apr 2013 02:02:46 GMT
Author: kmarsden
Date: Wed Apr 10 02:02:45 2013
New Revision: 1466316

URL: http://svn.apache.org/r1466316
Log:
DERBY-3398 Support min/max values for Java types float/double in real/double columns

merge tests for revision 1448002 for compat
low risk - limits extended.


Modified:
    db/derby/code/branches/10.8.3.1_testcompat/   (props changed)
    db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/aggbuiltin.out
    db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/aggregate.out
    db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/backupRestore.out
    db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/cast.out
    db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/desc_index.out
    db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml029.out
    db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml034.out
    db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml035.out
    db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml057.out
    db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml076.out
    db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml091.out
    db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml099.out
    db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml106.out
    db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml119.out
    db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml148.out
    db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml165.out
    db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/ejbql.out
    db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/floattypes.out
    db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/iepnegativetests_ES.out
    db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/implicitConversions.out
    db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/insert.out
    db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/orderby.out
    db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/positionedDelUpd.out
    db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/select.out
    db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/triggerRefClause.out
    db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/union.out
    db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/valuesclause.out
    db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/PrepStmtMetaDataTest.java
    db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/ResultSetMiscTest.java
    db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/tests/lang/MathTrigFunctionsTest.java
    db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/tests/lang/floattypes.sql

Propchange: db/derby/code/branches/10.8.3.1_testcompat/
------------------------------------------------------------------------------
  Merged /db/derby/code/trunk:r1448002

Modified: db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/aggbuiltin.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/aggbuiltin.out?rev=1466316&r1=1466315&r2=1466316&view=diff
==============================================================================
--- db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/aggbuiltin.out (original)
+++ db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/aggbuiltin.out Wed Apr 10 02:02:45 2013
@@ -202,7 +202,7 @@ ij> select avg(s) from empty;
 NULL  
 ij> select avg(d) from empty;
 1                     
-----------------------
+------------------------
 NULL                  
 ij> select avg(l) from empty;
 1                   
@@ -210,7 +210,7 @@ ij> select avg(l) from empty;
 NULL                
 ij> select avg(r) from empty;
 1            
--------------
+---------------
 NULL         
 ij> select avg(dc) from empty;
 1          
@@ -219,7 +219,7 @@ NULL       
 ij> -- variations
 select avg(i), avg(s), avg(r), avg(l) from empty;
 1          |2     |3            |4                   
------------------------------------------------------
+-------------------------------------------------------
 NULL       |NULL  |NULL         |NULL                
 ij> select avg(i+1) from empty;
 1          
@@ -234,13 +234,13 @@ ij> select avg(s) from empty group by s;
 ------
 ij> select avg(d) from empty group by d;
 1                     
-----------------------
+------------------------
 ij> select avg(l) from empty group by l;
 1                   
 --------------------
 ij> select avg(r) from empty group by r;
 1            
--------------
+---------------
 ij> select avg(dc) from empty group by dc;
 1          
 -----------
@@ -259,7 +259,7 @@ ij> select avg(s) from t;
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select avg(d) from t;
 1                     
-----------------------
+------------------------
 192.85714285714286    
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select avg(l) from t;
@@ -269,7 +269,7 @@ ij> select avg(l) from t;
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select avg(r) from t;
 1            
--------------
+---------------
 192.85715    
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select avg(dc) from t;
@@ -293,7 +293,7 @@ NULL  
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select avg(d) from t group by d;
 1                     
-----------------------
+------------------------
 100.0                 
 200.0                 
 NULL                  
@@ -306,7 +306,7 @@ NULL                
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select avg(r) from t group by r;
 1            
--------------
+---------------
 100.0        
 200.0        
 NULL         
@@ -329,7 +329,7 @@ ij> select avg(1.1) from t;
 1.1000   
 ij> select avg(1e1) from t;
 1                     
-----------------------
+------------------------
 10.0                  
 ij> select avg(1) from t group by i;
 1          
@@ -345,14 +345,14 @@ ij> select avg(1.1) from t group by r;
 1.1000   
 ij> select avg(1e1) from t group by r;
 1                     
-----------------------
+------------------------
 10.0                  
 10.0                  
 10.0                  
 ij> -- multicolumn grouping
 select avg(i), avg(l), avg(r) from t group by i, dt, b;
 1          |2                   |3            
-----------------------------------------------
+------------------------------------------------
 0          |1000000             |190.90909    
 0          |1000000             |200.0        
 0          |1000000             |200.0        
@@ -361,7 +361,7 @@ NULL       |NULL                |NULL   
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select i, dt, avg(i), avg(r), avg(l), l from t group by i, dt, b, l;
 I          |DT        |3          |4            |5                   |L                   
-------------------------------------------------------------------------------------------
+--------------------------------------------------------------------------------------------
 0          |1992-01-01|0          |190.90909    |1000000             |1000000             
 0          |1992-01-01|0          |200.0        |1000000             |1000000             
 0          |1992-09-09|0          |200.0        |1000000             |1000000             
@@ -372,7 +372,7 @@ ij> -- group by expression
 select avg(expr1), avg(expr2)
 from (select i * s, r * 2 from t) t (expr1, expr2) group by expr2, expr1;
 1          |2            
--------------------------
+---------------------------
 0          |200.0        
 0          |400.0        
 100        |400.0        
@@ -466,81 +466,81 @@ ij> insert into tmp values (1,1);
 1 row inserted/updated/deleted
 ij> execute scalar;
 1                     
-----------------------
+------------------------
 1.0                   
 ij> execute vector;
 1                     
-----------------------
+------------------------
 1.0                   
 ij> insert into tmp values (2,1);
 1 row inserted/updated/deleted
 ij> execute scalar;
 1                     
-----------------------
+------------------------
 1.5                   
 ij> execute vector;
 1                     
-----------------------
+------------------------
 1.5                   
 ij> insert into tmp values (3,1);
 1 row inserted/updated/deleted
 ij> execute scalar;
 1                     
-----------------------
+------------------------
 2.0                   
 ij> execute vector;
 1                     
-----------------------
+------------------------
 2.0                   
 ij> insert into tmp values (4,1);
 1 row inserted/updated/deleted
 ij> execute scalar;
 1                     
-----------------------
+------------------------
 2.5                   
 ij> execute vector;
 1                     
-----------------------
+------------------------
 2.5                   
 ij> insert into tmp values (5,1);
 1 row inserted/updated/deleted
 ij> execute scalar;
 1                     
-----------------------
+------------------------
 3.0                   
 ij> execute vector;
 1                     
-----------------------
+------------------------
 3.0                   
 ij> insert into tmp values (6,1);
 1 row inserted/updated/deleted
 ij> execute scalar;
 1                     
-----------------------
+------------------------
 3.5                   
 ij> execute vector;
 1                     
-----------------------
+------------------------
 3.5                   
 ij> insert into tmp values (7,1);
 1 row inserted/updated/deleted
 ij> execute scalar;
 1                     
-----------------------
+------------------------
 4.0                   
 ij> execute vector;
 1                     
-----------------------
+------------------------
 4.0                   
 ij> insert into tmp values (10000,1);
 1 row inserted/updated/deleted
 ij> execute scalar;
 1                     
-----------------------
+------------------------
 1253.5                
 ij> execute vector;
 1                     
-----------------------
+------------------------
 1253.5                
 ij> remove vector;
 ij> remove scalar;
@@ -1497,7 +1497,7 @@ ij> select sum(s) from empty;
 NULL  
 ij> select sum(d) from empty;
 1                     
-----------------------
+------------------------
 NULL                  
 ij> select sum(l) from empty;
 1                   
@@ -1505,7 +1505,7 @@ ij> select sum(l) from empty;
 NULL                
 ij> select sum(r) from empty;
 1            
--------------
+---------------
 NULL         
 ij> select sum(dc) from empty;
 1          
@@ -1514,7 +1514,7 @@ NULL       
 ij> -- variations
 select sum(i), sum(s), sum(r), sum(l) from empty;
 1          |2     |3            |4                   
------------------------------------------------------
+-------------------------------------------------------
 NULL       |NULL  |NULL         |NULL                
 ij> select sum(i+1) from empty;
 1          
@@ -1529,13 +1529,13 @@ ij> select sum(s) from empty group by s;
 ------
 ij> select sum(d) from empty group by d;
 1                     
-----------------------
+------------------------
 ij> select sum(l) from empty group by l;
 1                   
 --------------------
 ij> select sum(r) from empty group by r;
 1            
--------------
+---------------
 ij> select sum(dc) from empty group by dc;
 1          
 -----------
@@ -1554,7 +1554,7 @@ ij> select sum(s) from t;
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select sum(d) from t;
 1                     
-----------------------
+------------------------
 2900.0                
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select sum(l) from t;
@@ -1564,7 +1564,7 @@ ij> select sum(l) from t;
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select sum(r) from t;
 1            
--------------
+---------------
 2900.0       
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select sum(dc) from t;
@@ -1588,7 +1588,7 @@ NULL  
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select sum(d) from t group by d;
 1                     
-----------------------
+------------------------
 100.0                 
 2800.0                
 NULL                  
@@ -1602,7 +1602,7 @@ NULL                
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select sum(r) from t group by r;
 1            
--------------
+---------------
 100.0        
 2800.0       
 NULL         
@@ -1625,7 +1625,7 @@ ij> select sum(1.1) from t;
 18.7  
 ij> select sum(1e1) from t;
 1                     
-----------------------
+------------------------
 170.0                 
 ij> select sum(1) from t group by i;
 1          
@@ -1641,14 +1641,14 @@ ij> select sum(1.1) from t group by r;
 2.2   
 ij> select sum(1e1) from t group by r;
 1                     
-----------------------
+------------------------
 10.0                  
 140.0                 
 20.0                  
 ij> -- multicolumn grouping
 select sum(i), sum(l), sum(r) from t group by i, dt, b;
 1          |2                   |3            
-----------------------------------------------
+------------------------------------------------
 0          |13000000            |2300.0       
 0          |1000000             |200.0        
 0          |1000000             |200.0        
@@ -1657,7 +1657,7 @@ NULL       |NULL                |NULL   
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select i, dt, sum(i), sum(r), sum(l), l from t group by i, dt, b, l;
 I          |DT        |3          |4            |5                   |L                   
-------------------------------------------------------------------------------------------
+--------------------------------------------------------------------------------------------
 0          |1992-01-01|0          |2100.0       |11000000            |1000000             
 0          |1992-01-01|0          |200.0        |2000000             |2000000             
 0          |1992-01-01|0          |200.0        |1000000             |1000000             
@@ -1669,7 +1669,7 @@ ij> -- group by expression
 select sum(expr1), sum(expr2)
 from (select i * s, r * 2 from t) t (expr1, expr2) group by expr2, expr1;
 1          |2            
--------------------------
+---------------------------
 0          |200.0        
 0          |5200.0       
 100        |400.0        
@@ -1731,7 +1731,7 @@ ij> insert into tmp values (2147483647),
 9 rows inserted/updated/deleted
 ij> select sum(x) from tmp;
 1                     
-----------------------
+------------------------
 1.9327352823E10       
 ij> drop table tmp;
 0 rows inserted/updated/deleted
@@ -1890,11 +1890,11 @@ ij> select max(v) from empty;
 NULL                                              
 ij> select max(d) from empty;
 1                     
-----------------------
+------------------------
 NULL                  
 ij> select max(r) from empty;
 1            
--------------
+---------------
 NULL         
 ij> select max(dt) from empty;
 1         
@@ -1947,10 +1947,10 @@ ij> select max(v) from empty group by v;
 --------------------------------------------------
 ij> select max(d) from empty group by d;
 1                     
-----------------------
+------------------------
 ij> select max(r) from empty group by r;
 1            
--------------
+---------------
 ij> select max(dt) from empty group by dt;
 1         
 ----------
@@ -1999,12 +1999,12 @@ this is duplicated                      
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select max(d) from t;
 1                     
-----------------------
+------------------------
 200.0                 
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select max(r) from t;
 1            
--------------
+---------------
 200.0        
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select max(dt) from t;
@@ -2074,14 +2074,14 @@ NULL                                    
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select max(d) from t group by d;
 1                     
-----------------------
+------------------------
 100.0                 
 200.0                 
 NULL                  
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select max(r) from t group by r;
 1            
--------------
+---------------
 100.0        
 200.0        
 NULL         
@@ -2143,7 +2143,7 @@ ij> select max(1.1) from t;
 1.1 
 ij> select max(1e1) from t;
 1                     
-----------------------
+------------------------
 10.0                  
 ij> select max(X'11') from t;
 1   
@@ -2181,7 +2181,7 @@ ij> select max(1.1) from t group by dc;
 1.1 
 ij> select max(1e1) from t group by d;
 1                     
-----------------------
+------------------------
 10.0                  
 10.0                  
 10.0                  
@@ -2423,11 +2423,11 @@ ij> select min(v) from empty;
 NULL                                              
 ij> select min(d) from empty;
 1                     
-----------------------
+------------------------
 NULL                  
 ij> select min(r) from empty;
 1            
--------------
+---------------
 NULL         
 ij> select min(dt) from empty;
 1         
@@ -2480,10 +2480,10 @@ ij> select min(v) from empty group by v;
 --------------------------------------------------
 ij> select min(d) from empty group by d;
 1                     
-----------------------
+------------------------
 ij> select min(r) from empty group by r;
 1            
--------------
+---------------
 ij> select min(dt) from empty group by dt;
 1         
 ----------
@@ -2532,12 +2532,12 @@ noone is here                           
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select min(d) from t;
 1                     
-----------------------
+------------------------
 100.0                 
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select min(r) from t;
 1            
--------------
+---------------
 100.0        
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select min(dt) from t;
@@ -2607,14 +2607,14 @@ NULL                                    
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select min(d) from t group by d;
 1                     
-----------------------
+------------------------
 100.0                 
 200.0                 
 NULL                  
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select min(r) from t group by r;
 1            
--------------
+---------------
 100.0        
 200.0        
 NULL         
@@ -2676,7 +2676,7 @@ ij> select min(1.1) from t;
 1.1 
 ij> select min(1e1) from t;
 1                     
-----------------------
+------------------------
 10.0                  
 ij> select min(X'11') from t;
 1   
@@ -2714,7 +2714,7 @@ ij> select min(1.1) from t group by dc;
 1.1 
 ij> select min(1e1) from t group by d;
 1                     
-----------------------
+------------------------
 10.0                  
 10.0                  
 10.0                  

Modified: db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/aggregate.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/aggregate.out?rev=1466316&r1=1466315&r2=1466316&view=diff
==============================================================================
--- db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/aggregate.out (original)
+++ db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/aggregate.out Wed Apr 10 02:02:45 2013
@@ -770,7 +770,7 @@ ij> insert into ovf_real values (+3.402E
 1 row inserted/updated/deleted
 ij> select avg(i) from ovf_real;
 1            
--------------
+---------------
 3.402E38     
 ij> drop table ovf_real;
 0 rows inserted/updated/deleted
@@ -786,7 +786,7 @@ ij> insert into ovf_double values (+1.79
 1 row inserted/updated/deleted
 ij> select avg(i) from ovf_double;
 1                     
-----------------------
+------------------------
 1.79769E308           
 ij> drop table ovf_double;
 0 rows inserted/updated/deleted
@@ -917,4 +917,4 @@ ij> select i from tmax where substr('abc
 ERROR 42903: Invalid use of an aggregate function.
 ij> drop table tmax;
 0 rows inserted/updated/deleted
-ij> 
+ij> 
\ No newline at end of file

Modified: db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/backupRestore.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/backupRestore.out?rev=1466316&r1=1466315&r2=1466316&view=diff
==============================================================================
--- db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/backupRestore.out (original)
+++ db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/backupRestore.out Wed Apr 10 02:02:45 2013
@@ -101,7 +101,7 @@ ij> ---perform a rollforward recovery
 connect 'wombat;rollForwardRecoveryFrom=extinout/mybackup/wombat';
 ij> select * from x;
 X                     |Y          
-----------------------------------
+------------------------------------
 1.0                   |1          
 10.0                  |1          
 20.0                  |1          

Modified: db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/cast.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/cast.out?rev=1466316&r1=1466315&r2=1466316&view=diff
==============================================================================
--- db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/cast.out (original)
+++ db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/cast.out Wed Apr 10 02:02:45 2013
@@ -288,7 +288,7 @@ ij> values (cast (1.1 as bigint));
 1                   
 ij> values (cast (1.1 as double precision));
 1                     
-----------------------
+------------------------
 1.1                   
 ij> values (cast (1.1 as numeric(2,1)));
 1   
@@ -308,11 +308,11 @@ ij> values (cast (1.1 as decimal(2,0)));
 1  
 ij> values (cast (1.1 as float));
 1                     
-----------------------
+------------------------
 1.1                   
 ij> values (cast (1.1 as real));
 1            
--------------
+---------------
 1.1          
 ij> values (cast (1.9 as int));
 1          
@@ -328,7 +328,7 @@ ij> values (cast (1.9 as bigint));
 1                   
 ij> values (cast (1.9 as double precision));
 1                     
-----------------------
+------------------------
 1.9                   
 ij> values (cast (1.9 as numeric(2,1)));
 1   
@@ -348,11 +348,11 @@ ij> values (cast (1.9 as decimal(2,0)));
 1  
 ij> values (cast (1.9 as float));
 1                     
-----------------------
+------------------------
 1.9                   
 ij> values (cast (1.9 as real));
 1            
--------------
+---------------
 1.9          
 ij> -- bug 4352,4358 loss of precision on casts
 --   9223372036854775807 is Long::MAX_VALUE
@@ -884,12 +884,12 @@ varchar   
 NULL      
 ij> select cast(d as double precision) from tab1;
 1                     
-----------------------
+------------------------
 1.1                   
 NULL                  
 ij> select cast(r as float) from tab1;
 1                     
-----------------------
+------------------------
 1.100000023841858     
 NULL                  
 ij> select cast(dt as date) from tab1;
@@ -937,12 +937,12 @@ ij> select cast(i as char varying(10)) f
 ERROR 42846: Cannot convert types 'INTEGER' to 'VARCHAR'.
 ij> select cast(i as double precision) from tab1;
 1                     
-----------------------
+------------------------
 1.0                   
 NULL                  
 ij> select cast(i as float) from tab1;
 1                     
-----------------------
+------------------------
 1.0                   
 NULL                  
 ij> select cast(i as date) from tab1;
@@ -1096,7 +1096,7 @@ ij> insert into t1 (lvc) values cast(nul
 ij> -- expect 10 rows of nulls
 select * from t1;
 BT  |BTV |C                             |D                     |I          |R            |S     |DC                 |NUM                |DT        |T       |TS                           |V                             |LVC                                                                                                                             
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                         |NULL                          |NULL                                                                                                                            
 NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                         |NULL                          |NULL                                                                                                                            
 NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                         |NULL                          |NULL                                                                                                                            
@@ -1165,7 +1165,7 @@ NULL                          
 NULL                          
 ij> select cast (d as double precision) from t1;
 1                     
-----------------------
+------------------------
 NULL                  
 NULL                  
 NULL                  
@@ -1182,7 +1182,7 @@ NULL                  
 NULL                  
 ij> select cast (r as real) from t1;
 1            
--------------
+---------------
 NULL         
 NULL         
 NULL         
@@ -1382,7 +1382,7 @@ ij> execute q16 using 'values char(98765
 1 row inserted/updated/deleted
 ij> select * from t1;
 BT  |BTV |C                             |D                     |I          |R            |S     |DC                 |NUM                |DT        |T       |TS                           |V                             |LVC                                                                                                                             
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 aa  |NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                         |NULL                          |NULL                                                                                                                            
 NULL|aa  |NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                         |NULL                          |NULL                                                                                                                            
 NULL|NULL|123456                        |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                         |NULL                          |NULL                                                                                                                            
@@ -1686,11 +1686,11 @@ ij> select cast (aliasinfo as BIGINT) fr
 ERROR XCL12: An attempt was made to put a data value of type 'org.apache.derby.catalog.types.RoutineAliasInfo' into a data value of type 'BIGINT'.
 ij> select cast (aliasinfo as REAL) from sys.sysaliases;
 1            
--------------
+---------------
 ERROR XCL12: An attempt was made to put a data value of type 'org.apache.derby.catalog.types.RoutineAliasInfo' into a data value of type 'REAL'.
 ij> select cast (aliasinfo as DOUBLE) from sys.sysaliases;
 1                     
-----------------------
+------------------------
 ERROR XCL12: An attempt was made to put a data value of type 'org.apache.derby.catalog.types.RoutineAliasInfo' into a data value of type 'DOUBLE'.
 ij> select cast (aliasinfo as DECIMAL(5,4)) from sys.sysaliases;
 1      
@@ -1729,4 +1729,4 @@ ij> select cast (aliasinfo as LONG VARCH
 1                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------
 INSTALL_JAR(IN "URL" VARCHAR(256),IN "JAR" VARCHAR(128),IN "DEPLOY" INTEGER) LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DA&
-ij> 
+ij> 
\ No newline at end of file

Modified: db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/desc_index.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/desc_index.out?rev=1466316&r1=1466315&r2=1466316&view=diff
==============================================================================
--- db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/desc_index.out (original)
+++ db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/desc_index.out Wed Apr 10 02:02:45 2013
@@ -56,7 +56,7 @@ 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                   
@@ -209,7 +209,7 @@ Source result set:
 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                           
@@ -267,7 +267,7 @@ scan information:
 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                          
@@ -325,7 +325,7 @@ scan information:
 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                          
@@ -383,7 +383,7 @@ scan information:
 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                   

Modified: db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml029.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml029.out?rev=1466316&r1=1466315&r2=1466316&view=diff
==============================================================================
--- db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml029.out (original)
+++ db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml029.out Wed Apr 10 02:02:45 2013
@@ -51,7 +51,7 @@ ij> -- PASS:0130 If 1 row is inserted?
            FROM JJ
            WHERE FLOATTEST > 123455 AND FLOATTEST < 123457;
 FLOATTEST             
-----------------------
+------------------------
 123456.0              
 ij> -- PASS:0130 If count = 1 ?
 
@@ -73,7 +73,7 @@ ij> -- PASS:0131 If 1 row is inserted?
            FROM JJ
            WHERE FLOATTEST > 122 AND FLOATTEST < 124;
 FLOATTEST             
-----------------------
+------------------------
 123.456               
 ij> -- PASS:0131 If count = 1 ?
 
@@ -95,7 +95,7 @@ ij> -- PASS:0182 If 1 row is inserted?
            FROM JJ
            WHERE FLOATTEST > -124 AND FLOATTEST < -122;
 FLOATTEST             
-----------------------
+------------------------
 -123.456              
 ij> -- PASS:0182 If count = 1 ?
 

Modified: db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml034.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml034.out?rev=1466316&r1=1466315&r2=1466316&view=diff
==============================================================================
--- db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml034.out (original)
+++ db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml034.out Wed Apr 10 02:02:45 2013
@@ -28,7 +28,7 @@ ij> -- PASS:0088 If 1 row is inserted?
      SELECT REALTEST                                                    
           FROM GG;
 REALTEST     
--------------
+---------------
 1.234567     
 ij> -- PASS:0088 If REALTEST = 1.234567 ?
 -- PASS:0088 OR  is between 1.234562 and 1.234572 ?
@@ -37,7 +37,7 @@ ij> -- PASS:0088 If REALTEST = 1.234567 
         FROM GG    
         WHERE REALTEST > 1.234561 and REALTEST < 1.234573;
 REALTEST     
--------------
+---------------
 1.234567     
 ij> -- PASS:0088 If 1 row selected?
 
@@ -57,7 +57,7 @@ ij> -- PASS:0090 If 1 row is inserted?
      SELECT DOUBLETEST                                                  
           FROM II;
 DOUBLETEST            
-----------------------
+------------------------
 123456.123456         
 ij> -- PASS:0090 If DOUBLETEST = 123456.123456 ?
 -- PASS:0090 OR  is between 123456.123451 and 123456.123461 ?
@@ -66,7 +66,7 @@ ij> -- PASS:0090 If DOUBLETEST = 123456.
        FROM II 
        WHERE DOUBLETEST > 123456.123450 and DOUBLETEST < 123456.123462;
 DOUBLETEST            
-----------------------
+------------------------
 123456.123456         
 ij> -- PASS:0090 If 1 row selected?
 
@@ -86,7 +86,7 @@ ij> -- PASS:0091 If 1 row is inserted?
      SELECT FLOATTEST                                                  
           FROM JJ;
 FLOATTEST             
-----------------------
+------------------------
 12.345678             
 ij> -- PASS:0091 If FLOATTEST = 12.345678 ?
 -- PASS:0091 OR  is between 12.345673 and 12.345683 ?
@@ -95,7 +95,7 @@ ij> -- PASS:0091 If FLOATTEST = 12.34567
        FROM JJ
        WHERE FLOATTEST > 12.345672 and FLOATTEST < 12.345684;
 FLOATTEST             
-----------------------
+------------------------
 12.345678             
 ij> -- PASS:0091 If 1 row selected?
 
@@ -115,7 +115,7 @@ ij> -- PASS:0092 If 1 row is inserted?
      SELECT FLOATTEST                                                   
           FROM KK;
 FLOATTEST             
-----------------------
+------------------------
 123456.123456         
 ij> -- PASS:0092 If FLOATTEST = 123456.123456 ?
 -- PASS:0092 OR  is between 123456.1233 and 123456.1236 ?
@@ -124,7 +124,7 @@ ij> -- PASS:0092 If FLOATTEST = 123456.1
        FROM KK
        WHERE FLOATTEST > 123456.123450 and FLOATTEST < 123456.123462;
 FLOATTEST             
-----------------------
+------------------------
 123456.123456         
 ij> -- PASS:0092 If 1 row selected?
 

Modified: db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml035.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml035.out?rev=1466316&r1=1466315&r2=1466316&view=diff
==============================================================================
--- db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml035.out (original)
+++ db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml035.out Wed Apr 10 02:02:45 2013
@@ -43,7 +43,7 @@ ij> -- PASS:0157 If 1 row is inserted?
           FROM JJ
           ORDER BY FLOATTEST DESC;
 FLOATTEST             
-----------------------
+------------------------
 66.3                  
 66.2                  
 0.2222                

Modified: db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml057.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml057.out?rev=1466316&r1=1466315&r2=1466316&view=diff
==============================================================================
--- db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml057.out (original)
+++ db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml057.out Wed Apr 10 02:02:45 2013
@@ -34,7 +34,7 @@ ij> -- PASS:0248 If 1 row is inserted?
      SELECT FLOATTEST
           FROM JJ;
 FLOATTEST             
-----------------------
+------------------------
 0.1048575             
 ij> -- PASS:0248 If FLOATTEST = 0.1048575 ?
 -- PASS:0248 OR  is between 0.1048574 and 0.1048576 ?
@@ -43,7 +43,7 @@ ij> -- PASS:0248 If FLOATTEST = 0.104857
      SELECT * FROM JJ
        WHERE FLOATTEST > 0.1048574 AND FLOATTEST < 0.1048576;
 FLOATTEST             
-----------------------
+------------------------
 0.1048575             
 ij> -- PASS:0248 If count = 1?
 
@@ -60,7 +60,7 @@ ij> -- PASS:0248 If 1 row is inserted?
      SELECT FLOATTEST
           FROM JJ;
 FLOATTEST             
-----------------------
+------------------------
 -0.1048575            
 ij> -- PASS:0248 If FLOATTEST = -0.1048575 ?
 -- PASS:0248 OR  is between -0.1048576 and -0.1048574 ?
@@ -69,7 +69,7 @@ ij> -- PASS:0248 If FLOATTEST = -0.10485
      SELECT * FROM JJ
        WHERE FLOATTEST > -0.1048576 AND FLOATTEST < -0.1048574;
 FLOATTEST             
-----------------------
+------------------------
 -0.1048575            
 ij> -- PASS:0248 If count = 1?
 
@@ -96,7 +96,7 @@ ij> -- PASS:0249 If 1 row is inserted?
      SELECT REALTEST
           FROM GG;
 REALTEST     
--------------
+---------------
 0.1048575    
 ij> -- PASS:0249 If REALTEST =  0.1048575 ?
 -- PASS:0249 OR  is between 0.1048574 and 0.1048576 ?
@@ -105,7 +105,7 @@ ij> -- PASS:0249 If REALTEST =  0.104857
      SELECT * FROM GG
        WHERE REALTEST > 0.1048574 AND REALTEST < 0.1048576;
 REALTEST     
--------------
+---------------
 0.1048575    
 ij> -- PASS:0249 If count = 1?
 
@@ -122,7 +122,7 @@ ij> -- PASS:0249 If 1 row is inserted?
      SELECT REALTEST
           FROM GG;
 REALTEST     
--------------
+---------------
 -0.1048575   
 ij> -- PASS:0249 If REALTEST =  -0.1048575 ?
 -- PASS:0249 OR  is between -0.1048576 and -0.1048574 ?
@@ -131,7 +131,7 @@ ij> -- PASS:0249 If REALTEST =  -0.10485
      SELECT * FROM GG
        WHERE REALTEST > -0.1048576 AND REALTEST < -0.1048574;
 REALTEST     
--------------
+---------------
 -0.1048575   
 ij> -- PASS:0249 If count = 1?
 
@@ -158,7 +158,7 @@ ij> -- PASS:0250 If 1 row is inserted?
      SELECT DOUBLETEST
           FROM II;
 DOUBLETEST            
-----------------------
+------------------------
 0.1073741823          
 ij> -- PASS:0250 If DOUBLETEST = 0.1073741823 ?
 -- PASS:0250 OR  is between  0.1073741822 and 0.1073741824 ?
@@ -167,7 +167,7 @@ ij> -- PASS:0250 If DOUBLETEST = 0.10737
      SELECT * FROM II
        WHERE DOUBLETEST > 0.1073741822 AND DOUBLETEST < 0.1073741824;
 DOUBLETEST            
-----------------------
+------------------------
 0.1073741823          
 ij> -- PASS:0250 If count = 1?
 
@@ -184,7 +184,7 @@ ij> -- PASS:0250 If 1 row is inserted?
      SELECT DOUBLETEST
           FROM II;
 DOUBLETEST            
-----------------------
+------------------------
 -0.1073741823         
 ij> -- PASS:0250 If DOUBLETEST = -0.1073741823 ?
 -- PASS:0250 OR  is between  -0.1073741824 and -0.1073741822 ?
@@ -193,7 +193,7 @@ ij> -- PASS:0250 If DOUBLETEST = -0.1073
      SELECT * FROM II
        WHERE DOUBLETEST > -0.1073741824 AND DOUBLETEST < -0.1073741822;
 DOUBLETEST            
-----------------------
+------------------------
 -0.1073741823         
 ij> -- PASS:0250 If count = 1?
 

Modified: db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml076.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml076.out?rev=1466316&r1=1466315&r2=1466316&view=diff
==============================================================================
--- db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml076.out (original)
+++ db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml076.out Wed Apr 10 02:02:45 2013
@@ -60,7 +60,7 @@ ij> -- PASS:0436 If INTTEST is NULL (Imp
     SELECT REALTEST 
       FROM GG;
 REALTEST     
--------------
+---------------
 NULL         
 ij> -- PASS:0436 If REALTEST is NULL (Implementor defined print format)?
 
@@ -70,7 +70,7 @@ ij> -- PASS:0436 If REALTEST is NULL (Im
       FROM GG 
       WHERE REALTEST IS NULL;
 REALTEST     
--------------
+---------------
 NULL         
 ij> -- PASS:0436 If count = 1?
 
@@ -86,7 +86,7 @@ ij> -- PASS:0436 If SMALLTEST is NULL (I
     SELECT DOUBLETEST 
       FROM II;
 DOUBLETEST            
-----------------------
+------------------------
 NULL                  
 ij> -- PASS:0436 If DOUBLETEST is NULL (Implementor defined print format)?
 
@@ -96,7 +96,7 @@ ij> -- PASS:0436 If DOUBLETEST is NULL (
       FROM II 
       WHERE DOUBLETEST IS NULL;
 DOUBLETEST            
-----------------------
+------------------------
 NULL                  
 ij> -- PASS:0436 If count = 1?
 
@@ -104,7 +104,7 @@ ij> -- PASS:0436 If count = 1?
     SELECT FLOATTEST 
       FROM JJ;
 FLOATTEST             
-----------------------
+------------------------
 NULL                  
 ij> -- PASS:0436 If FLOATTEST is NULL (Implementor defined print format)?
 
@@ -114,7 +114,7 @@ ij> -- PASS:0436 If FLOATTEST is NULL (I
       FROM JJ 
       WHERE FLOATTEST IS NULL;
 FLOATTEST             
-----------------------
+------------------------
 NULL                  
 ij> -- PASS:0436 If count = 1?
 

Modified: db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml091.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml091.out?rev=1466316&r1=1466315&r2=1466316&view=diff
==============================================================================
--- db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml091.out (original)
+++ db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml091.out Wed Apr 10 02:02:45 2013
@@ -160,7 +160,7 @@ ij> -- NOTE:0497 If we have not inserted
  
    SELECT SUM(T_REAL) FROM FOUR_TYPES;
 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/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml099.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml099.out?rev=1466316&r1=1466315&r2=1466316&view=diff
==============================================================================
--- db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml099.out (original)
+++ db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml099.out Wed Apr 10 02:02:45 2013
@@ -36,7 +36,7 @@ ij> -- PASS:0582 If 1 row is inserted?
 
    SELECT C1, C2, C3 FROM ICAST2;
 C1         |C2                    |C3     
-------------------------------------------
+--------------------------------------------
 3          |3.0                   |3.142  
 ij> -- PASS:0582 If 1 row is selected with C1 = 3 and C3 = 3.142?
 
@@ -46,7 +46,7 @@ ij> -- PASS:0582 If 1 row is updated?
 
    SELECT C1, C2, C3 FROM ICAST2;
 C1         |C2                    |C3     
-------------------------------------------
+--------------------------------------------
 5          |5.0                   |5.241  
 ij> -- PASS:0582 If 1 row is selected with C1 = 5 and C3 = 5.241?
 
@@ -60,7 +60,7 @@ ij> -- PASS:0582 If 1 row is updated?
 
    SELECT C1, C2, C3 FROM ICAST2;
 C1         |C2                    |C3     
-------------------------------------------
+--------------------------------------------
 2          |2.1                   |9.100  
 ij> -- PASS:0582 If 1 row is selected with C1 = 2 and C3 = 9.100?
 

Modified: db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml106.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml106.out?rev=1466316&r1=1466315&r2=1466316&view=diff
==============================================================================
--- db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml106.out (original)
+++ db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml106.out Wed Apr 10 02:02:45 2013
@@ -257,7 +257,7 @@ ij> -- PASS:0611 If 1 row is inserted?
    SELECT SECOND( FIPS2)
   * 1000000 - 999990 FROM TSFIPS;
 1                     
-----------------------
+------------------------
 9.0                   
 ij> -- PASS:0611 If 1 row selected and value is 9?
 

Modified: db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml119.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml119.out?rev=1466316&r1=1466315&r2=1466316&view=diff
==============================================================================
--- db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml119.out (original)
+++ db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml119.out Wed Apr 10 02:02:45 2013
@@ -80,7 +80,7 @@ ij> -- PASS:0647 If 1 row is updated?
    SELECT SUM (USER_INPUT) * 100, SUM (RECEIVABLE)
   FROM STANDARD_INPUT;
 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/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml148.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml148.out?rev=1466316&r1=1466315&r2=1466316&view=diff
==============================================================================
--- db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml148.out (original)
+++ db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml148.out Wed Apr 10 02:02:45 2013
@@ -254,7 +254,7 @@ ij> -- PASS:0844 If 5 rows selected with
        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                  

Modified: db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml165.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml165.out?rev=1466316&r1=1466315&r2=1466316&view=diff
==============================================================================
--- db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml165.out (original)
+++ db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/dml165.out Wed Apr 10 02:02:45 2013
@@ -56,7 +56,7 @@ 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  

Modified: db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/ejbql.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/ejbql.out?rev=1466316&r1=1466315&r2=1466316&view=diff
==============================================================================
--- db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/ejbql.out (original)
+++ db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/ejbql.out Wed Apr 10 02:02:45 2013
@@ -427,14 +427,14 @@ create table myreal( a real );
 0 rows inserted/updated/deleted
 ij> select abs(a) from myreal;
 1            
--------------
+---------------
 ij> insert into myreal values (null), (+0), (-0), (+1), (-1), (null), (100000000), (-100000000),
 (3.402E+38), (-3.402E+38),
 (1.175E-37), (-1.175E-37);
 12 rows inserted/updated/deleted
 ij> select a from myreal;
 A            
--------------
+---------------
 NULL         
 0.0          
 0.0          
@@ -449,7 +449,7 @@ NULL         
 -1.175E-37   
 ij> select -a from myreal;
 1            
--------------
+---------------
 NULL         
 0.0          
 0.0          
@@ -464,7 +464,7 @@ NULL         
 1.175E-37    
 ij> select abs(a) from myreal;
 1            
--------------
+---------------
 NULL         
 0.0          
 0.0          
@@ -479,7 +479,7 @@ NULL         
 1.175E-37    
 ij> select abs(-a) from myreal;
 1            
--------------
+---------------
 NULL         
 0.0          
 0.0          
@@ -494,7 +494,7 @@ NULL         
 1.175E-37    
 ij> select -abs(a) from myreal;
 1            
--------------
+---------------
 NULL         
 0.0          
 0.0          
@@ -509,7 +509,7 @@ NULL         
 -1.175E-37   
 ij> select abs(abs(-abs(-abs(a)))) from myreal;
 1            
--------------
+---------------
 NULL         
 0.0          
 0.0          
@@ -524,7 +524,7 @@ NULL         
 1.175E-37    
 ij> SELECT ABSVAL(ABSVAL(-ABSVAL(-ABSVAL(A)))) FROM MYREAL;
 1            
--------------
+---------------
 NULL         
 0.0          
 0.0          
@@ -539,7 +539,7 @@ NULL         
 1.175E-37    
 ij> select distinct abs(a) from myreal;
 1            
--------------
+---------------
 0.0          
 1.175E-37    
 1.0          
@@ -551,11 +551,11 @@ ij> ---- There is nothing wrong with ret
 -- since contant numbers are (parsed as) doubles
 select abs(-abs(a)) + 1 from myreal where a=1.175E-37;
 1            
--------------
+---------------
 ij> -- when casted to a real, it is found
 select abs(-abs(a)) + 1 from myreal where a=cast(1.175E-37 as real);
 1            
--------------
+---------------
 1.0          
 ij> -- Error
 insert into myreal values ( 3.402E+38 *2);
@@ -573,14 +573,14 @@ create table mydoubleprecision( a double
 0 rows inserted/updated/deleted
 ij> select abs(a) from mydoubleprecision;
 1                     
-----------------------
+------------------------
 ij> insert into mydoubleprecision values (null), (+0), (-0), (+1), (-1), (100000000), (-100000000), (null),
 (1.79769E+308), (-1.79769E+308),
 (2.225E-307), (-2.225E-307);
 12 rows inserted/updated/deleted
 ij> select a from mydoubleprecision;
 A                     
-----------------------
+------------------------
 NULL                  
 0.0                   
 0.0                   
@@ -595,7 +595,7 @@ NULL                  
 -2.225E-307           
 ij> select -a from mydoubleprecision;
 1                     
-----------------------
+------------------------
 NULL                  
 0.0                   
 0.0                   
@@ -610,7 +610,7 @@ NULL                  
 2.225E-307            
 ij> select abs(a) from mydoubleprecision;
 1                     
-----------------------
+------------------------
 NULL                  
 0.0                   
 0.0                   
@@ -625,7 +625,7 @@ NULL                  
 2.225E-307            
 ij> select abs(-a) from mydoubleprecision;
 1                     
-----------------------
+------------------------
 NULL                  
 0.0                   
 0.0                   
@@ -640,7 +640,7 @@ NULL                  
 2.225E-307            
 ij> select -abs(a) from mydoubleprecision;
 1                     
-----------------------
+------------------------
 NULL                  
 0.0                   
 0.0                   
@@ -655,7 +655,7 @@ NULL                  
 -2.225E-307           
 ij> select abs(abs(-abs(-abs(a)))) from mydoubleprecision;
 1                     
-----------------------
+------------------------
 NULL                  
 0.0                   
 0.0                   
@@ -670,7 +670,7 @@ NULL                  
 2.225E-307            
 ij> SELECT ABSVAL(ABSVAL(-ABSVAL(-ABSVAL(A)))) FROM MYDOUBLEPRECISION;
 1                     
-----------------------
+------------------------
 NULL                  
 0.0                   
 0.0                   
@@ -685,7 +685,7 @@ NULL                  
 2.225E-307            
 ij> select distinct abs(a) from mydoubleprecision;
 1                     
-----------------------
+------------------------
 0.0                   
 2.225E-307            
 1.0                   
@@ -695,7 +695,7 @@ NULL                  
 ij> -- There is nothing wrong with returning 1.0.  The double overflows and this is just the way it behaves.
 select abs(-abs(a)) + 1 from mydoubleprecision where a=2.225E-307;
 1                     
-----------------------
+------------------------
 1.0                   
 ij> -- Error
 insert into mydoubleprecision values ( 1.79769E+308 *2);
@@ -713,7 +713,7 @@ create table myfloat( a float, b float(2
 0 rows inserted/updated/deleted
 ij> select abs(a), abs(b) from myfloat;
 1                     |2            
-------------------------------------
+----------------------------------------
 ij> select columnname, columndatatype
 from sys.syscolumns c, sys.systables t where c.referenceid = t.tableid and CAST(t.tablename AS VARCHAR(128)) ='MYFLOAT';
 COLUMNNAME                                                                                                                      |COLUMNDATATYPE 
@@ -729,7 +729,7 @@ ij> insert into myfloat values (null, nu
 12 rows inserted/updated/deleted
 ij> select a, b from myfloat;
 A                     |B            
-------------------------------------
+----------------------------------------
 NULL                  |NULL         
 0.0                   |0.0          
 0.0                   |0.0          
@@ -744,7 +744,7 @@ NULL                  |NULL         
 -2.225E-307           |-1.175E-37   
 ij> select -a, -b from myfloat;
 1                     |2            
-------------------------------------
+----------------------------------------
 NULL                  |NULL         
 0.0                   |0.0          
 0.0                   |0.0          
@@ -759,7 +759,7 @@ NULL                  |NULL         
 2.225E-307            |1.175E-37    
 ij> select abs(a), abs(b) from myfloat;
 1                     |2            
-------------------------------------
+----------------------------------------
 NULL                  |NULL         
 0.0                   |0.0          
 0.0                   |0.0          
@@ -774,7 +774,7 @@ NULL                  |NULL         
 2.225E-307            |1.175E-37    
 ij> select abs(-a), abs(-b) from myfloat;
 1                     |2            
-------------------------------------
+----------------------------------------
 NULL                  |NULL         
 0.0                   |0.0          
 0.0                   |0.0          
@@ -789,7 +789,7 @@ NULL                  |NULL         
 2.225E-307            |1.175E-37    
 ij> select -abs(a), -abs(b) from myfloat;
 1                     |2            
-------------------------------------
+----------------------------------------
 NULL                  |NULL         
 0.0                   |0.0          
 0.0                   |0.0          
@@ -804,7 +804,7 @@ NULL                  |NULL         
 -2.225E-307           |-1.175E-37   
 ij> select abs(abs(-abs(-abs(a)))), abs(abs(-abs(-abs(b)))) from myfloat;
 1                     |2            
-------------------------------------
+----------------------------------------
 NULL                  |NULL         
 0.0                   |0.0          
 0.0                   |0.0          
@@ -819,7 +819,7 @@ NULL                  |NULL         
 2.225E-307            |1.175E-37    
 ij> SELECT ABSVAL(ABSVAL(-ABSVAL(-ABSVAL(A)))), ABSVAL(ABSVAL(-ABSVAL(-ABSVAL(B)))) FROM MYFLOAT;
 1                     |2            
-------------------------------------
+----------------------------------------
 NULL                  |NULL         
 0.0                   |0.0          
 0.0                   |0.0          
@@ -834,7 +834,7 @@ NULL                  |NULL         
 2.225E-307            |1.175E-37    
 ij> select distinct abs(a) from myfloat;
 1                     
-----------------------
+------------------------
 0.0                   
 2.225E-307            
 1.0                   
@@ -845,22 +845,22 @@ ij> -- -- There is nothing wrong with re
 -- this used to work in CS, but no more, = on floating point values isn't really useful
 select abs(-abs(a)) + 1, abs(-abs(b)) + 1 from myfloat where a=2.225E-307 AND b=1.175E-37;
 1                     |2            
-------------------------------------
+----------------------------------------
 ij> select abs(-abs(a)) + 1, abs(-abs(b)) + 1 from myfloat where b=3.402E+38;
 1                     |2            
-------------------------------------
+----------------------------------------
 ij> -- 'real =' works on DB2 and DB2 Cloudscape
 select abs(-abs(a)) + 1, abs(-abs(b)) + 1 from myfloat where b=cast(3.402E+38 as real);
 1                     |2            
-------------------------------------
+----------------------------------------
 1.79769E308           |3.402E38     
 ij> select abs(-abs(a)) + 1, abs(-abs(b)) + 1 from myfloat where a=2.225E-307 AND b=cast(1.175E-37 as real);
 1                     |2            
-------------------------------------
+----------------------------------------
 1.0                   |1.0          
 ij> select abs(-abs(a)) + 1, abs(-abs(b)) + 1 from myfloat where a=2.225E-307;
 1                     |2            
-------------------------------------
+----------------------------------------
 1.0                   |1.0          
 ij> -- Error
 insert into myfloat values ( 1.79769E+308 *2, 3.402E+38 *2);
@@ -1623,51 +1623,55 @@ ij> -- Double Precision/Double
 -- beetle 5803 - support DOUBLE_[PRECISION] built-in function
 values{fn abs( DOUBLE( 0)                      )};
 1                     
-----------------------
+------------------------
 0.0                   
 ij> values{fn abs( DOUBLE(-0)                      )};
 1                     
-----------------------
+------------------------
 0.0                   
 ij> values{fn abs( DOUBLE( 1)                      )};
 1                     
-----------------------
+------------------------
 1.0                   
 ij> values{fn abs( DOUBLE(-1)                      )};
 1                     
-----------------------
+------------------------
 1.0                   
 ij> values{fn abs( DOUBLE( 1000000.001)            )};
 1                     
-----------------------
+------------------------
 1000000.001           
 ij> values{fn abs( DOUBLE(-1000000.001)            )};
 1                     
-----------------------
+------------------------
 1000000.001           
 ij> values{fn abs( DOUBLE(-1.79769E+308)           )};
 1                     
-----------------------
+------------------------
 1.79769E308           
 ij> values{fn abs( DOUBLE( 1.79769E+308) + 1       )};
 1                     
-----------------------
+------------------------
 1.79769E308           
 ij> values{fn abs( DOUBLE( 2.225E-307 + 1)         )};
 1                     
-----------------------
+------------------------
 1.0                   
 ij> -- Error
 values{fn abs( DOUBLE( 1.79769E+308 * 2)       )};
 1                     
-----------------------
+------------------------
 ERROR 22003: The resulting value is outside the range for the data type DOUBLE.
 ij> values{fn abs(-DOUBLE( NaN)                    )};
 ERROR 42X04: Column 'NAN' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'NAN' is not a column in the target table.
 ij> values{fn abs( DOUBLE( 4.9E-324)               )};
-ERROR 22003: The resulting value is outside the range for the data type DOUBLE.
+1                       
+------------------------
+4.9E-324                
 ij> values{fn abs( DOUBLE( 1.7976931348623157E308) )};
-ERROR 22003: The resulting value is outside the range for the data type DOUBLE.
+1                       
+------------------------
+1.7976931348623157E308  
 ij> -- Decimal/Numeric
 -- Basic
 -- beetle 5802 - support DEC[IMAL] built-in function
@@ -3124,13 +3128,13 @@ create table myreal( a real );
 0 rows inserted/updated/deleted
 ij> select sqrt(a) from myreal;
 1                     
-----------------------
+------------------------
 ij> insert into myreal values (null), (+0), (-0), (+1), (null), (100000000),
 (3.402E+38), (1.175E-37);
 8 rows inserted/updated/deleted
 ij> select a from myreal;
 A            
--------------
+---------------
 NULL         
 0.0          
 0.0          
@@ -3141,7 +3145,7 @@ NULL         
 1.175E-37    
 ij> select sqrt(a) from myreal;
 1                     
-----------------------
+------------------------
 NULL                  
 0.0                   
 0.0                   
@@ -3152,7 +3156,7 @@ NULL                  
 3.427827260414494E-19 
 ij> select -sqrt(a) from myreal;
 1                     
-----------------------
+------------------------
 NULL                  
 0.0                   
 0.0                   
@@ -3160,24 +3164,24 @@ NULL                  
 NULL                  
 -10000.0              
 -1.844451138023282E19 
--3.427827260414494E-19
+-3.427827260414494E-19  
 ij> select sqrt(sqrt(-sqrt(-sqrt(a)))) from myreal;
 1                     
-----------------------
+------------------------
 NULL                  
 0.0                   
 0.0                   
 ERROR 22013: Attempt to take the square root of a negative number, '-1.0'.
 ij> SELECT SQRT(SQRT(-SQRT(-SQRT(A)))) FROM MYREAL;
 1                     
-----------------------
+------------------------
 NULL                  
 0.0                   
 0.0                   
 ERROR 22013: Attempt to take the square root of a negative number, '-1.0'.
 ij> select sqrt(sqrt(sqrt(sqrt(a)))) from myreal;
 1                     
-----------------------
+------------------------
 NULL                  
 0.0                   
 0.0                   
@@ -3188,7 +3192,7 @@ NULL                  
 0.004919006155611499  
 ij> select distinct sqrt(a) from myreal;
 1                     
-----------------------
+------------------------
 0.0                   
 3.427827260414494E-19 
 1.0                   
@@ -3206,13 +3210,13 @@ create table mydoubleprecision( a double
 0 rows inserted/updated/deleted
 ij> select sqrt(a) from mydoubleprecision;
 1                     
-----------------------
+------------------------
 ij> insert into mydoubleprecision values (null), (+0), (-0), (+1), (100000000), (null),
 (1.79769E+308), (2.225E-307);
 8 rows inserted/updated/deleted
 ij> select a from mydoubleprecision;
 A                     
-----------------------
+------------------------
 NULL                  
 0.0                   
 0.0                   
@@ -3223,43 +3227,43 @@ NULL                  
 2.225E-307            
 ij> select sqrt(a) from mydoubleprecision;
 1                     
-----------------------
+------------------------
 NULL                  
 0.0                   
 0.0                   
 1.0                   
 10000.0               
 NULL                  
-1.3407796239501852E154
-4.716990566028302E-154
+1.3407796239501852E154  
+4.716990566028302E-154  
 ij> select -sqrt(a) from mydoubleprecision;
 1                     
-----------------------
+------------------------
 NULL                  
 0.0                   
 0.0                   
 -1.0                  
 -10000.0              
 NULL                  
--1.3407796239501852E1&
--4.716990566028302E-1&
+-1.3407796239501852E154 
+-4.716990566028302E-154 
 ij> select sqrt(sqrt(-sqrt(-sqrt(a)))) from mydoubleprecision;
 1                     
-----------------------
+------------------------
 NULL                  
 0.0                   
 0.0                   
 ERROR 22013: Attempt to take the square root of a negative number, '-1.0'.
 ij> SELECT SQRT(SQRT(-SQRT(-SQRT(A)))) FROM MYDOUBLEPRECISION;
 1                     
-----------------------
+------------------------
 NULL                  
 0.0                   
 0.0                   
 ERROR 22013: Attempt to take the square root of a negative number, '-1.0'.
 ij> select sqrt(sqrt(sqrt(sqrt(a)))) from mydoubleprecision;
 1                     
-----------------------
+------------------------
 NULL                  
 0.0                   
 0.0                   
@@ -3270,12 +3274,12 @@ NULL                  
 6.826657681281494E-20 
 ij> select distinct sqrt(a) from mydoubleprecision;
 1                     
-----------------------
+------------------------
 0.0                   
-4.716990566028302E-154
+4.716990566028302E-154  
 1.0                   
 10000.0               
-1.3407796239501852E154
+1.3407796239501852E154  
 NULL                  
 ij> drop table mydoubleprecision;
 0 rows inserted/updated/deleted
@@ -3288,7 +3292,7 @@ create table myfloat( a float, b float(2
 0 rows inserted/updated/deleted
 ij> select sqrt(a), sqrt(b) from myfloat;
 1                     |2                     
----------------------------------------------
+-------------------------------------------------
 ij> select columnname, columndatatype
 from sys.syscolumns c, sys.systables t where c.referenceid = t.tableid and CAST(t.tablename AS VARCHAR(128)) = 'MYFLOAT';
 COLUMNNAME                                                                                                                      |COLUMNDATATYPE 
@@ -3301,7 +3305,7 @@ ij> insert into myfloat values (null, nu
 8 rows inserted/updated/deleted
 ij> select a, b from myfloat;
 A                     |B            
-------------------------------------
+----------------------------------------
 NULL                  |NULL         
 0.0                   |0.0          
 0.0                   |0.0          
@@ -3312,43 +3316,43 @@ NULL                  |NULL         
 2.225E-307            |1.175E-37    
 ij> select sqrt(a), sqrt(b) from myfloat;
 1                     |2                     
----------------------------------------------
+-------------------------------------------------
 NULL                  |NULL                  
 0.0                   |0.0                   
 0.0                   |0.0                   
 1.0                   |1.0                   
 10000.0               |10000.0               
 NULL                  |NULL                  
-1.3407796239501852E154|1.844451138023282E19  
-4.716990566028302E-154|3.427827260414494E-19 
+1.3407796239501852E154  |1.844451138023282E19    
+4.716990566028302E-154  |3.427827260414494E-19   
 ij> select -sqrt(a), -sqrt(b) from myfloat;
 1                     |2                     
----------------------------------------------
+-------------------------------------------------
 NULL                  |NULL                  
 0.0                   |0.0                   
 0.0                   |0.0                   
 -1.0                  |-1.0                  
 -10000.0              |-10000.0              
 NULL                  |NULL                  
--1.3407796239501852E1&|-1.844451138023282E19 
--4.716990566028302E-1&|-3.427827260414494E-19
+-1.3407796239501852E154 |-1.844451138023282E19   
+-4.716990566028302E-154 |-3.427827260414494E-19  
 ij> select sqrt(sqrt(-sqrt(-sqrt(a)))), sqrt(sqrt(-sqrt(-sqrt(b)))) from myfloat;
 1                     |2                     
----------------------------------------------
+-------------------------------------------------
 NULL                  |NULL                  
 0.0                   |0.0                   
 0.0                   |0.0                   
 ERROR 22013: Attempt to take the square root of a negative number, '-1.0'.
 ij> SELECT SQRT(SQRT(-SQRT(-SQRT(A)))), SQRT(SQRT(-SQRT(-SQRT(B)))) FROM MYFLOAT;
 1                     |2                     
----------------------------------------------
+-------------------------------------------------
 NULL                  |NULL                  
 0.0                   |0.0                   
 0.0                   |0.0                   
 ERROR 22013: Attempt to take the square root of a negative number, '-1.0'.
 ij> select sqrt(sqrt(sqrt(sqrt(a)))), sqrt(sqrt(sqrt(sqrt(b)))) from myfloat;
 1                     |2                     
----------------------------------------------
+-------------------------------------------------
 NULL                  |NULL                  
 0.0                   |0.0                   
 0.0                   |0.0                   
@@ -3359,16 +3363,16 @@ NULL                  |NULL             
 6.826657681281494E-20 |0.004919006155611499  
 ij> select distinct sqrt(a) from myfloat;
 1                     
-----------------------
+------------------------
 0.0                   
-4.716990566028302E-154
+4.716990566028302E-154  
 1.0                   
 10000.0               
-1.3407796239501852E154
+1.3407796239501852E154  
 NULL                  
 ij> select distinct sqrt(b) from myfloat;
 1                     
-----------------------
+------------------------
 0.0                   
 3.427827260414494E-19 
 1.0                   
@@ -3420,12 +3424,12 @@ ij> prepare p1 as 'select a from foo';
 ij> prepare p2 as 'insert into foo select a*(-1) from foo';
 ij> execute p1;
 A                     
-----------------------
+------------------------
 ij> execute p2;
 0 rows inserted/updated/deleted
 ij> execute p1;
 A                     
-----------------------
+------------------------
 ij> insert into foo values ( sqrt(FLOAT( 6)));
 ERROR 42X01: Syntax error: Encountered "FLOAT" at line 1, column 31.
 Issue the 'help' command for general information on IJ command syntax.
@@ -3462,16 +3466,16 @@ ij> prepare p3 as 'select sqrt(a) from f
 ij> -- executing p3 should fail
 execute p3;
 1                     
-----------------------
+------------------------
 ij> -- these should pass
 execute p1;
 A                     
-----------------------
+------------------------
 ij> execute p2;
 0 rows inserted/updated/deleted
 ij> execute p1;
 A                     
-----------------------
+------------------------
 ij> rollback;
 ij> commit;
 ij> autocommit on;
@@ -3515,20 +3519,20 @@ ij> -- these should pass
 autocommit off;
 ij> execute p1;
 A                     
-----------------------
+------------------------
 ij> execute p3;
 1                     
-----------------------
+------------------------
 ij> execute p1;
 A                     
-----------------------
+------------------------
 ij> -- executing p2 should fail
 execute p2;
 0 rows inserted/updated/deleted
 ij> autocommit on;
 ij> select * from foo;
 A                     
-----------------------
+------------------------
 ij> drop table foo;
 0 rows inserted/updated/deleted
 ij> -- End of SQRT test.  For all valid types.  Un-escaped function.
@@ -3543,10 +3547,10 @@ ij> create table myinteger( a Integer );
 0 rows inserted/updated/deleted
 ij> select sqrt(a) from myint;
 1                     
-----------------------
+------------------------
 ij> select sqrt(a) from myinteger;
 1                     
-----------------------
+------------------------
 ij> drop table myint;
 0 rows inserted/updated/deleted
 ij> drop table myinteger;
@@ -3555,21 +3559,21 @@ ij> create table mysmallint( a smallint 
 0 rows inserted/updated/deleted
 ij> select sqrt(a) from mysmallint;
 1                     
-----------------------
+------------------------
 ij> drop table mysmallint;
 0 rows inserted/updated/deleted
 ij> create table mybigint( a bigint );
 0 rows inserted/updated/deleted
 ij> select sqrt(a) from mybigint;
 1                     
-----------------------
+------------------------
 ij> drop table mybigint;
 0 rows inserted/updated/deleted
 ij> create table mydecimal( a decimal );
 0 rows inserted/updated/deleted
 ij> select sqrt(a) from mydecimal;
 1                     
-----------------------
+------------------------
 ij> drop table mydecimal;
 0 rows inserted/updated/deleted
 ij> -- For escape function.
@@ -3579,21 +3583,21 @@ ij> -- For escape function.
 -- Basic
 values{ fn sqrt(INT('0'))};
 1                     
-----------------------
+------------------------
 0.0                   
 ij> -- Smallint
 -- Basic
 -- beetle 5805 - support INT[EGER] built-in function
 values{ fn sqrt(SMALLINT('0'))};
 1                     
-----------------------
+------------------------
 0.0                   
 ij> -- Bigint
 -- Basic
 -- beetle 5809 - support BIGINT built-in function
 values{ fn sqrt(BIGINT('0'))};
 1                     
-----------------------
+------------------------
 0.0                   
 ij> -- Real
 -- Basic
@@ -3664,15 +3668,15 @@ ij> -- Double Precision/Double
 -- beetle 5803 - support DOUBLE_[PRECISION] built-in function
 values{fn  sqrt( DOUBLE( 0)                      )};
 1                     
-----------------------
+------------------------
 0.0                   
 ij> values{fn  sqrt( DOUBLE(-0)                      )};
 1                     
-----------------------
+------------------------
 0.0                   
 ij> values{fn  sqrt( DOUBLE( 1)                      )};
 1                     
-----------------------
+------------------------
 1.0                   
 ij> values{fn -sqrt( DOUBLE(1)                       )};
 ERROR 42X01: Syntax error: Encountered "-" at line 1, column 11.
@@ -3681,7 +3685,7 @@ Any unrecognized commands are treated as
 Consult your DBMS server reference documentation for details of the SQL syntax supported by your server.
 ij> values{fn  sqrt( DOUBLE( 1000000.001)            )};
 1                     
-----------------------
+------------------------
 1000.0000005          
 ij> values{fn -sqrt( DOUBLE(1000000.001)             )};
 ERROR 42X01: Syntax error: Encountered "-" at line 1, column 11.
@@ -3695,35 +3699,39 @@ Any unrecognized commands are treated as
 Consult your DBMS server reference documentation for details of the SQL syntax supported by your server.
 ij> values{fn  sqrt( DOUBLE( 1.79769E+308) + 1       )};
 1                     
-----------------------
-1.3407796239501852E154
+------------------------
+1.3407796239501852E154  
 ij> values{fn  sqrt( DOUBLE( 2.225E-307 + 1)         )};
 1                     
-----------------------
+------------------------
 1.0                   
 ij> -- Error
 values{fn  sqrt( DOUBLE(-1)                      )};
 1                     
-----------------------
+------------------------
 ERROR 22013: Attempt to take the square root of a negative number, '-1.0'.
 ij> values{fn  sqrt( DOUBLE(-1000000.001)            )};
 1                     
-----------------------
+------------------------
 ERROR 22013: Attempt to take the square root of a negative number, '-1000000.001'.
 ij> values{fn  sqrt( DOUBLE(-1.79769E+308)           )};
 1                     
-----------------------
+------------------------
 ERROR 22013: Attempt to take the square root of a negative number, '-1.79769E308'.
 ij> values{fn  sqrt( DOUBLE( 1.79769E+308 * 2)       )};
 1                     
-----------------------
+------------------------
 ERROR 22003: The resulting value is outside the range for the data type DOUBLE.
 ij> values{fn  sqrt(-DOUBLE( NaN)                    )};
 ERROR 42X04: Column 'NAN' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'NAN' is not a column in the target table.
 ij> values{fn  sqrt( DOUBLE( 4.9E-324)               )};
-ERROR 22003: The resulting value is outside the range for the data type DOUBLE.
+1                       
+------------------------
+2.2227587494850775E-162 
 ij> values{fn  sqrt( DOUBLE( 1.7976931348623157E308) )};
-ERROR 22003: The resulting value is outside the range for the data type DOUBLE.
+1                       
+------------------------
+1.3407807929942596E154  
 ij> -- Decimal/Numeric
 -- Basic
 -- beetle 5802 - support DEC[IMAL] built-in function
@@ -3735,27 +3743,27 @@ Consult your DBMS server reference docum
 ij> -- More generic test
 values{ fn sqrt( 0+1+.1 ) };
 1                     
-----------------------
+------------------------
 1.0488088481701516    
 ij> values{ fn sqrt( +0+1.000000001 ) };
 1                     
-----------------------
+------------------------
 1.0000000005          
 ij> VALUES{ FN sqrt( 100+200+300 ) };
 1                     
-----------------------
+------------------------
 24.49489742783178     
 ij> values{ fn sqrt( 0-1-.1 ) };
 1                     
-----------------------
+------------------------
 ERROR 22013: Attempt to take the square root of a negative number, '-1.1'.
 ij> values{ fn sqrt( -0-1.000000001 ) };
 1                     
-----------------------
+------------------------
 ERROR 22013: Attempt to take the square root of a negative number, '-1.000000001'.
 ij> VALUES{ FN sqrt( 100-200-300 ) };
 1                     
-----------------------
+------------------------
 ERROR 22013: Attempt to take the square root of a negative number, '-400.0'.
 ij> -- Error
 values{ fn sqrt('null') };
@@ -3771,12 +3779,12 @@ create table myreal( a real );
 0 rows inserted/updated/deleted
 ij> select sqrt(a) from myreal;
 1                     
-----------------------
+------------------------
 ij> insert into myreal values ( 3.402E+38 );
 1 row inserted/updated/deleted
 ij> select a from myreal;
 A            
--------------
+---------------
 3.402E38     
 ij> -- Prepare Statements, should pass
 -- beetle 5806 - support REAL built-in function
@@ -4530,7 +4538,7 @@ ij> insert into n values (2, 2.2, date('
 1 row inserted/updated/deleted
 ij> select * from n where u like 'haha______';
 I          |R            |D         |U         
------------------------------------------------
+-------------------------------------------------
 2          |2.2          |2222-02-02|haha      
 ij> -- now, with an index
 create table m (i int, r real, d date, u varchar(10));
@@ -4539,19 +4547,19 @@ ij> insert into m select * from n;
 2 rows inserted/updated/deleted
 ij> select * from m where u like 'haha';
 I          |R            |D         |U         
------------------------------------------------
+-------------------------------------------------
 ij> select * from m where u like 'haha______';
 I          |R            |D         |U         
------------------------------------------------
+-------------------------------------------------
 2          |2.2          |2222-02-02|haha      
 ij> create index i1 on m(u);
 0 rows inserted/updated/deleted
 ij> select * from m where u like 'haha';
 I          |R            |D         |U         
------------------------------------------------
+-------------------------------------------------
 ij> select * from m where u like 'haha______';
 I          |R            |D         |U         
------------------------------------------------
+-------------------------------------------------
 2          |2.2          |2222-02-02|haha      
 ij> -- tests for column like constant optimization
 create table u (c char(10), vc varchar(10));



Mime
View raw message