db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From d..@apache.org
Subject svn commit: r421932 [1/5] - in /db/derby/code/trunk/java: client/org/apache/derby/client/am/ engine/org/apache/derby/iapi/types/ testing/org/apache/derbyTesting/functionTests/master/ testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/ ...
Date Fri, 14 Jul 2006 16:04:05 GMT
Author: djd
Date: Fri Jul 14 09:04:03 2006
New Revision: 421932

URL: http://svn.apache.org/viewvc?rev=421932&view=rev
Log:
DERBY-836 Fix metadata information for DECIMAL columns.
There are 3 possible cases with respect to finding the correct maximum width for DECIMAL type.

1. If scale = 0, only sign should be added to precision to compute max width.
2. scale = precision, in this case 3 should be added to precision for sign, decimal and an additional char '0'.
3. precision > scale > 0, 2 shoud be added to precision for sign and decimal. 

Patch submitted by Mayuresh Nirhali - Mayuresh.Nirhali@Sun.COM


Modified:
    db/derby/code/trunk/java/client/org/apache/derby/client/am/ColumnMetaData.java
    db/derby/code/trunk/java/engine/org/apache/derby/iapi/types/DataTypeUtilities.java
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/metadata.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/metadata.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/odbc_metadata.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/I18NImportExport.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Upgrade_10_1_10_2.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/aggbuiltin.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/aggregate.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/cast.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/casting.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/compressTable.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/consistencyChecker.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ejbql.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/floattypes.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/functions.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ieptests.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/implicitConversions.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/importExportThruIJ.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/lojreorder.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/metadata.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/odbc_metadata.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/orderby.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/partdml.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/resultset.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/specjPlans.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/supersimple.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/triggerGeneral.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/triggerRefClause.out

Modified: db/derby/code/trunk/java/client/org/apache/derby/client/am/ColumnMetaData.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/client/org/apache/derby/client/am/ColumnMetaData.java?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/client/org/apache/derby/client/am/ColumnMetaData.java (original)
+++ db/derby/code/trunk/java/client/org/apache/derby/client/am/ColumnMetaData.java Fri Jul 14 09:04:03 2006
@@ -292,7 +292,13 @@
                 return 22;
             case Types.DECIMAL:
             case java.sql.Types.NUMERIC:
-                return getPrecision(column) + 2;  // add 1 for sign and 1 for decimal
+		// There are 3 possible cases with respect to finding the correct max width for DECIMAL type.
+		// 1. If scale = 0, only sign should be added to precision.
+		// 2. scale = precision, 3 should be added to precision for sign, decimal and an additional char '0'.
+		// 3. precision > scale > 0, 2 should be added to precision for sign and decimal.
+		int scale = getScale(column);
+		int precision = getPrecision(column);
+		return (scale == 0) ? (precision + 1) : ((scale == precision) ? (precision + 3) : (precision + 2));
             case Types.CHAR:
             case Types.VARCHAR:
             case Types.LONGVARCHAR:

Modified: db/derby/code/trunk/java/engine/org/apache/derby/iapi/types/DataTypeUtilities.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/engine/org/apache/derby/iapi/types/DataTypeUtilities.java?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/engine/org/apache/derby/iapi/types/DataTypeUtilities.java (original)
+++ db/derby/code/trunk/java/engine/org/apache/derby/iapi/types/DataTypeUtilities.java Fri Jul 14 09:04:03 2006
@@ -218,7 +218,12 @@
      */
     public static int computeMaxWidth( int precision, int scale)
     {
-        return (scale == 0) ? (precision + 1) : (precision + 3);
+	// There are 3 possible cases with respect to finding the correct max
+	// width for DECIMAL type.
+	// 1. If scale = 0, only sign should be added to precision.
+	// 2. scale=precision, 3 should be added to precision for sign, decimal and an additional char '0'.
+	// 3. precision > scale > 0, 2 should be added to precision for sign and decimal.
+	return (scale ==0) ? (precision +1) : ((scale == precision) ? (precision + 3) : (precision + 2));
     }
 }
 

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/metadata.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/metadata.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/metadata.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/metadata.out Fri Jul 14 09:04:03 2006
@@ -7,8 +7,8 @@
 double precision - dec(10,2) -- precision: 15 scale: 0 display size: 22 type name: DOUBLE
 dec(10,2) - double precision -- precision: 15 scale: 2 display size: 22 type name: DOUBLE
 result row: 11.10 3.3 4.4 14.4 -6.699999999999999 6.699999999999999
-DECIMAL(10,0) -- precision: 10 scale: 0 display size: 12 type name: DECIMAL
-DECIMAL(10,10) -- precision: 10 scale: 10 display size: 12 type name: DECIMAL
+DECIMAL(10,0) -- precision: 10 scale: 0 display size: 11 type name: DECIMAL
+DECIMAL(10,10) -- precision: 10 scale: 10 display size: 13 type name: DECIMAL
 DECIMAL(10,2) -- precision: 10 scale: 2 display size: 12 type name: DECIMAL
 Column result scale after division is: 23
 dc / 2 = 5.55000000000000000000000

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/metadata.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/metadata.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/metadata.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/metadata.out Fri Jul 14 09:04:03 2006
@@ -7,8 +7,8 @@
 double precision - dec(10,2) -- precision: 15 scale: 0 display size: 22 type name: DOUBLE
 dec(10,2) - double precision -- precision: 15 scale: 2 display size: 22 type name: DOUBLE
 result row: 11.10 3.3 4.4 14.4 -6.699999999999999 6.699999999999999
-DECIMAL(10,0) -- precision: 10 scale: 0 display size: 12 type name: DECIMAL
-DECIMAL(10,10) -- precision: 10 scale: 10 display size: 12 type name: DECIMAL
+DECIMAL(10,0) -- precision: 10 scale: 0 display size: 11 type name: DECIMAL
+DECIMAL(10,10) -- precision: 10 scale: 10 display size: 13 type name: DECIMAL
 DECIMAL(10,2) -- precision: 10 scale: 2 display size: 12 type name: DECIMAL
 Column result scale after division is: 23
 dc / 2 = 5.55000000000000000000000

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/odbc_metadata.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/odbc_metadata.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/odbc_metadata.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/odbc_metadata.out Fri Jul 14 09:04:03 2006
@@ -37,8 +37,8 @@
 double precision - dec(10,2) -- precision: 15 scale: 0 display size: 22 type name: DOUBLE
 dec(10,2) - double precision -- precision: 15 scale: 2 display size: 22 type name: DOUBLE
 result row: 11.10 3.3 4.4 14.4 -6.699999999999999 6.699999999999999
-DECIMAL(10,0) -- precision: 10 scale: 0 display size: 12 type name: DECIMAL
-DECIMAL(10,10) -- precision: 10 scale: 10 display size: 12 type name: DECIMAL
+DECIMAL(10,0) -- precision: 10 scale: 0 display size: 11 type name: DECIMAL
+DECIMAL(10,10) -- precision: 10 scale: 10 display size: 13 type name: DECIMAL
 DECIMAL(10,2) -- precision: 10 scale: 2 display size: 12 type name: DECIMAL
 Column result scale after division is: 23
 dc / 2 = 5.55000000000000000000000

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/I18NImportExport.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/I18NImportExport.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/I18NImportExport.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/I18NImportExport.out Fri Jul 14 09:04:03 2006
@@ -19,24 +19,24 @@
 0 rows inserted/updated/deleted
 ij> -- localized display is off
 select * from tab1;
-C1      |C2        |C3                  
-----------------------------------------
-12.345  |2000-05-25|test row 1          
-32.432  |2000-01-14|test row 2          
-54.846  |2000-08-21|test row 3          
-98.214  |2000-12-08|test row 4          
-77.406  |2000-10-19|test row 5          
-50.395  |2000-11-29|test row 6          
+C1     |C2        |C3                  
+---------------------------------------
+12.345 |2000-05-25|test row 1          
+32.432 |2000-01-14|test row 2          
+54.846 |2000-08-21|test row 3          
+98.214 |2000-12-08|test row 4          
+77.406 |2000-10-19|test row 5          
+50.395 |2000-11-29|test row 6          
 ij> LOCALIZEDDISPLAY ON;
 ij> select * from tab1;
-C1      |C2                |C3                  
-------------------------------------------------
-12.345  |May 25, 2000      |test row 1          
-32.432  |January 14, 2000  |test row 2          
-54.846  |August 21, 2000   |test row 3          
-98.214  |December 8, 2000  |test row 4          
-77.406  |October 19, 2000  |test row 5          
-50.395  |November 29, 2000 |test row 6          
+C1     |C2                |C3                  
+-----------------------------------------------
+12.345 |May 25, 2000      |test row 1          
+32.432 |January 14, 2000  |test row 2          
+54.846 |August 21, 2000   |test row 3          
+98.214 |December 8, 2000  |test row 4          
+77.406 |October 19, 2000  |test row 5          
+50.395 |November 29, 2000 |test row 6          
 ij> drop table tab1;
 0 rows inserted/updated/deleted
 ij> create table tab1( c1 decimal(5,3), c2 date, c3 char(20) );
@@ -47,22 +47,22 @@
 ij> -- localized display is off
 LOCALIZEDDISPLAY OFF;
 ij> select * from tab1;
-C1      |C2        |C3                  
-----------------------------------------
-12.345  |2000-05-25|test row 1          
-32.432  |2000-01-14|test row 2          
-54.846  |2000-08-21|test row 3          
-98.214  |2000-12-08|test row 4          
-77.406  |2000-10-19|test row 5          
-50.395  |2000-11-29|test row 6          
+C1     |C2        |C3                  
+---------------------------------------
+12.345 |2000-05-25|test row 1          
+32.432 |2000-01-14|test row 2          
+54.846 |2000-08-21|test row 3          
+98.214 |2000-12-08|test row 4          
+77.406 |2000-10-19|test row 5          
+50.395 |2000-11-29|test row 6          
 ij> LOCALIZEDDISPLAY ON;
 ij> select * from tab1;
-C1      |C2                |C3                  
-------------------------------------------------
-12.345  |May 25, 2000      |test row 1          
-32.432  |January 14, 2000  |test row 2          
-54.846  |August 21, 2000   |test row 3          
-98.214  |December 8, 2000  |test row 4          
-77.406  |October 19, 2000  |test row 5          
-50.395  |November 29, 2000 |test row 6          
+C1     |C2                |C3                  
+-----------------------------------------------
+12.345 |May 25, 2000      |test row 1          
+32.432 |January 14, 2000  |test row 2          
+54.846 |August 21, 2000   |test row 3          
+98.214 |December 8, 2000  |test row 4          
+77.406 |October 19, 2000  |test row 5          
+50.395 |November 29, 2000 |test row 6          
 ij> 

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Upgrade_10_1_10_2.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Upgrade_10_1_10_2.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Upgrade_10_1_10_2.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Upgrade_10_1_10_2.out Fri Jul 14 09:04:03 2006
@@ -716,7 +716,7 @@
 complete caseTriggerVTI - passed true
 Test metadata starting
 Union Result -- precision: 10 scale: 2 display size: 13 type name: DECIMAL
-dec(10,2) -- precision: 10 scale: 2 display size: 13 type name: DECIMAL
+dec(10,2) -- precision: 10 scale: 2 display size: 12 type name: DECIMAL
 real -- precision: 7 scale: 0 display size: 13 type name: REAL
 double -- precision: 15 scale: 0 display size: 22 type name: DOUBLE
 real + dec(10,2) -- precision: 7 scale: 0 display size: 13 type name: REAL
@@ -725,7 +725,7 @@
 result row: 11.10 3.3 4.4 14.4 -6.699999999999999 6.699999999999999
 DECIMAL(10,0) -- precision: 10 scale: 0 display size: 11 type name: DECIMAL
 DECIMAL(10,10) -- precision: 10 scale: 10 display size: 13 type name: DECIMAL
-DECIMAL(10,2) -- precision: 10 scale: 2 display size: 13 type name: DECIMAL
+DECIMAL(10,2) -- precision: 10 scale: 2 display size: 12 type name: DECIMAL
 Column result scale after division is: 23
 dc / 2 = 5.55000000000000000000000
 dc / 2 = 5.55500000000000000000000
@@ -2171,7 +2171,7 @@
 complete caseTriggerVTI - passed true
 Test metadata starting
 Union Result -- precision: 10 scale: 2 display size: 13 type name: DECIMAL
-dec(10,2) -- precision: 10 scale: 2 display size: 13 type name: DECIMAL
+dec(10,2) -- precision: 10 scale: 2 display size: 12 type name: DECIMAL
 real -- precision: 7 scale: 0 display size: 13 type name: REAL
 double -- precision: 15 scale: 0 display size: 22 type name: DOUBLE
 real + dec(10,2) -- precision: 7 scale: 0 display size: 13 type name: REAL
@@ -2180,7 +2180,7 @@
 result row: 11.10 3.3 4.4 14.4 -6.699999999999999 6.699999999999999
 DECIMAL(10,0) -- precision: 10 scale: 0 display size: 11 type name: DECIMAL
 DECIMAL(10,10) -- precision: 10 scale: 10 display size: 13 type name: DECIMAL
-DECIMAL(10,2) -- precision: 10 scale: 2 display size: 13 type name: DECIMAL
+DECIMAL(10,2) -- precision: 10 scale: 2 display size: 12 type name: DECIMAL
 Column result scale after division is: 23
 dc / 2 = 5.55000000000000000000000
 dc / 2 = 5.55500000000000000000000

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/aggbuiltin.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/aggbuiltin.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/aggbuiltin.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/aggbuiltin.out Fri Jul 14 09:04:03 2006
@@ -1880,9 +1880,9 @@
 ----------------
 NULL            
 ij> select max(dc) from empty;
-1       
---------
-NULL    
+1      
+-------
+NULL   
 ij> -- variations
 select max(i), max(b), max(i), max(s) from empty;
 1          |2   |3          |4     
@@ -1930,8 +1930,8 @@
 1               
 ----------------
 ij> select max(dc) from empty group by dc;
-1       
---------
+1      
+-------
 ij> --------------------------------
 -- BASIC ACCEPTANCE TESTS
 --------------------------------
@@ -1996,9 +1996,9 @@
 1111111111111111
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select max(dc) from t;
-1       
---------
-222.22  
+1      
+-------
+222.22 
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select max(i) from t group by i;
 1          
@@ -2085,11 +2085,11 @@
 NULL            
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select max(dc) from t group by dc;
-1       
---------
-111.11  
-222.22  
-NULL    
+1      
+-------
+111.11 
+222.22 
+NULL   
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> -- constants
 select max(1) from t;
@@ -2101,9 +2101,9 @@
 -----
 hello
 ij> select max(1.1) from t;
-1    
------
-1.1  
+1   
+----
+1.1 
 ij> select max(1e1) from t;
 1                     
 ----------------------
@@ -2137,11 +2137,11 @@
 hello
 hello
 ij> select max(1.1) from t group by dc;
-1    
------
-1.1  
-1.1  
-1.1  
+1   
+----
+1.1 
+1.1 
+1.1 
 ij> select max(1e1) from t group by d;
 1                     
 ----------------------
@@ -2409,9 +2409,9 @@
 ----------------
 NULL            
 ij> select min(dc) from empty;
-1       
---------
-NULL    
+1      
+-------
+NULL   
 ij> -- variations
 select min(i), min(b), min(i), min(s) from empty;
 1          |2   |3          |4     
@@ -2459,8 +2459,8 @@
 1               
 ----------------
 ij> select min(dc) from empty group by dc;
-1       
---------
+1      
+-------
 ij> --------------------------------
 -- BASIC ACCEPTANCE TESTS
 --------------------------------
@@ -2525,9 +2525,9 @@
 0000111100001111
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select min(dc) from t;
-1       
---------
-111.11  
+1      
+-------
+111.11 
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select min(i) from t group by i;
 1          
@@ -2614,11 +2614,11 @@
 NULL            
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select min(dc) from t group by dc;
-1       
---------
-111.11  
-222.22  
-NULL    
+1      
+-------
+111.11 
+222.22 
+NULL   
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> -- constants
 select min(1) from t;
@@ -2630,9 +2630,9 @@
 -----
 hello
 ij> select min(1.1) from t;
-1    
------
-1.1  
+1   
+----
+1.1 
 ij> select min(1e1) from t;
 1                     
 ----------------------
@@ -2666,11 +2666,11 @@
 hello
 hello
 ij> select min(1.1) from t group by dc;
-1    
------
-1.1  
-1.1  
-1.1  
+1   
+----
+1.1 
+1.1 
+1.1 
 ij> select min(1e1) from t group by d;
 1                     
 ----------------------

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/aggregate.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/aggregate.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/aggregate.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/aggregate.out Fri Jul 14 09:04:03 2006
@@ -639,10 +639,10 @@
 ij> insert into bd values(0.2);
 1 row inserted/updated/deleted
 ij> select * from bd;
-I                                 
-----------------------------------
-0.100000000000000000000000000000  
-0.200000000000000000000000000000  
+I                                
+---------------------------------
+0.100000000000000000000000000000 
+0.200000000000000000000000000000 
 ij> -- should be the same
 select avg(i), sum(i)/count(i) from bd;
 1                                 |2                                 

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/cast.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/cast.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/cast.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/cast.out Fri Jul 14 09:04:03 2006
@@ -232,13 +232,13 @@
 ----------------------
 1.1                   
 ij> values (cast (1.1 as numeric(2,1)));
-1    
------
-1.1  
+1   
+----
+1.1 
 ij> values (cast (1.1 as decimal(2,1)));
-1    
------
-1.1  
+1   
+----
+1.1 
 ij> values (cast (1.1 as numeric(2,0)));
 1   
 ----
@@ -272,13 +272,13 @@
 ----------------------
 1.9                   
 ij> values (cast (1.9 as numeric(2,1)));
-1    
------
-1.9  
+1   
+----
+1.9 
 ij> values (cast (1.9 as decimal(2,1)));
-1    
------
-1.9  
+1   
+----
+1.9 
 ij> values (cast (1.9 as numeric(2,0)));
 1   
 ----
@@ -303,184 +303,184 @@
   cast (
   cast (9223372036854775807 as DECIMAL(24,1)) as BIGINT)
   );
-1                   |2                          |3                   
----------------------------------------------------------------------
-9223372036854775807 |9223372036854775807.0      |9223372036854775807 
+1                   |2                         |3                   
+--------------------------------------------------------------------
+9223372036854775807 |9223372036854775807.0     |9223372036854775807 
 ij> values (
   cast ('9223372036854775807' as DECIMAL(24,1)),
   cast (cast ('9223372036854775807' as DECIMAL(24,1)) as BIGINT)
   );
-1                          |2                   
-------------------------------------------------
-9223372036854775807.0      |9223372036854775807 
+1                         |2                   
+-----------------------------------------------
+9223372036854775807.0     |9223372036854775807 
 ij> values (
   cast ('9223372036854775806' as DECIMAL(24,1)),
   cast (cast ('9223372036854775806' as DECIMAL(24,1)) as BIGINT)
   );
-1                          |2                   
-------------------------------------------------
-9223372036854775806.0      |9223372036854775806 
+1                         |2                   
+-----------------------------------------------
+9223372036854775806.0     |9223372036854775806 
 ij> -- only this should fail
 values (
   cast ('9223372036854775808' as DECIMAL(24,1)),
   cast (cast ('9223372036854775808' as DECIMAL(24,1)) as BIGINT)
   );
-1                          |2                   
-------------------------------------------------
+1                         |2                   
+-----------------------------------------------
 ERROR 22003: The resulting value is outside the range for the data type BIGINT.
 ij> values (
   cast ('9223372036854775807.9' as DECIMAL(24,1)),
   cast (cast ('9223372036854775807.9' as DECIMAL(24,1)) as BIGINT)
   );
-1                          |2                   
-------------------------------------------------
-9223372036854775807.9      |9223372036854775807 
+1                         |2                   
+-----------------------------------------------
+9223372036854775807.9     |9223372036854775807 
 ij> --   -9223372036854775808 is Long::MIN_VALUE
 values (
   cast ('-9223372036854775808' as DECIMAL(24,1)),
   cast (cast ('-9223372036854775808' as DECIMAL(24,1)) as BIGINT)
   );
-1                          |2                   
-------------------------------------------------
--9223372036854775808.0     |-9223372036854775808
+1                         |2                   
+-----------------------------------------------
+-9223372036854775808.0    |-9223372036854775808
 ij> values (
   cast ('-9223372036854775807' as DECIMAL(24,1)),
   cast (cast ('-9223372036854775807' as DECIMAL(24,1)) as BIGINT)
   );
-1                          |2                   
-------------------------------------------------
--9223372036854775807.0     |-9223372036854775807
+1                         |2                   
+-----------------------------------------------
+-9223372036854775807.0    |-9223372036854775807
 ij> -- only this should fail
 values (
   cast ('-9223372036854775809' as DECIMAL(24,1)),
   cast (cast ('-9223372036854775809' as DECIMAL(24,1)) as BIGINT)
   );
-1                          |2                   
-------------------------------------------------
+1                         |2                   
+-----------------------------------------------
 ERROR 22003: The resulting value is outside the range for the data type BIGINT.
 ij> values (
   cast ('-9223372036854775808.9' as DECIMAL(24,1)),
   cast (cast ('-9223372036854775808.9' as DECIMAL(24,1)) as BIGINT)
   );
-1                          |2                   
-------------------------------------------------
--9223372036854775808.9     |-9223372036854775808
+1                         |2                   
+-----------------------------------------------
+-9223372036854775808.9    |-9223372036854775808
 ij> values (
   cast ('32767' as DECIMAL(24,1)),
   cast (cast ('32767' as DECIMAL(24,1)) as SMALLINT)
   );
-1                          |2     
-----------------------------------
-32767.0                    |32767 
+1                         |2     
+---------------------------------
+32767.0                   |32767 
 ij> values (
   cast ('32766' as DECIMAL(24,1)),
   cast (cast ('32766' as DECIMAL(24,1)) as SMALLINT)
   );
-1                          |2     
-----------------------------------
-32766.0                    |32766 
+1                         |2     
+---------------------------------
+32766.0                   |32766 
 ij> values (
   cast ('32768' as DECIMAL(24,1)),
   cast (cast ('32768' as DECIMAL(24,1)) as SMALLINT)
   );
-1                          |2     
-----------------------------------
+1                         |2     
+---------------------------------
 ERROR 22003: The resulting value is outside the range for the data type SMALLINT.
 ij> -- only this should fail
 values (
   cast ('32767.9' as DECIMAL(24,1)),
   cast (cast ('32767.9' as DECIMAL(24,1)) as SMALLINT)
   );
-1                          |2     
-----------------------------------
-32767.9                    |32767 
+1                         |2     
+---------------------------------
+32767.9                   |32767 
 ij> values (
   cast ('-32768' as DECIMAL(24,1)),
   cast (cast ('-32768' as DECIMAL(24,1)) as SMALLINT)
   );
-1                          |2     
-----------------------------------
--32768.0                   |-32768
+1                         |2     
+---------------------------------
+-32768.0                  |-32768
 ij> values (
   cast ('-32767' as DECIMAL(24,1)),
   cast (cast ('-32767' as DECIMAL(24,1)) as SMALLINT)
   );
-1                          |2     
-----------------------------------
--32767.0                   |-32767
+1                         |2     
+---------------------------------
+-32767.0                  |-32767
 ij> -- only this should fail
 values (
   cast ('-32769' as DECIMAL(24,1)),
   cast (cast ('-32769' as DECIMAL(24,1)) as SMALLINT)
   );
-1                          |2     
-----------------------------------
+1                         |2     
+---------------------------------
 ERROR 22003: The resulting value is outside the range for the data type SMALLINT.
 ij> values (
   cast ('-32768.9' as DECIMAL(24,1)),
   cast (cast ('-32768.9' as DECIMAL(24,1)) as SMALLINT)
   );
-1                          |2     
-----------------------------------
--32768.9                   |-32768
+1                         |2     
+---------------------------------
+-32768.9                  |-32768
 ij> values (
   cast ('2147483647' as DECIMAL(24,1)),
   cast (cast ('2147483647' as DECIMAL(24,1)) as INTEGER)
   );
-1                          |2          
----------------------------------------
-2147483647.0               |2147483647 
+1                         |2          
+--------------------------------------
+2147483647.0              |2147483647 
 ij> values (
   cast ('2147483646' as DECIMAL(24,1)),
   cast (cast ('2147483646' as DECIMAL(24,1)) as INTEGER)
   );
-1                          |2          
----------------------------------------
-2147483646.0               |2147483646 
+1                         |2          
+--------------------------------------
+2147483646.0              |2147483646 
 ij> -- only this should fail
 values (
   cast ('2147483648' as DECIMAL(24,1)),
   cast (cast ('2147483648' as DECIMAL(24,1)) as INTEGER)
   );
-1                          |2          
----------------------------------------
+1                         |2          
+--------------------------------------
 ERROR 22003: The resulting value is outside the range for the data type INTEGER.
 ij> values (
   cast ('2147483647.9' as DECIMAL(24,1)),
   cast (cast ('2147483647.9' as DECIMAL(24,1)) as INTEGER)
   );
-1                          |2          
----------------------------------------
-2147483647.9               |2147483647 
+1                         |2          
+--------------------------------------
+2147483647.9              |2147483647 
 ij> values (
   cast ('-2147483647' as DECIMAL(24,1)),
   cast (cast ('-2147483647' as DECIMAL(24,1)) as INTEGER)
   );
-1                          |2          
----------------------------------------
--2147483647.0              |-2147483647
+1                         |2          
+--------------------------------------
+-2147483647.0             |-2147483647
 ij> values (
   cast ('-2147483646' as DECIMAL(24,1)),
   cast (cast ('-2147483646' as DECIMAL(24,1)) as INTEGER)
   );
-1                          |2          
----------------------------------------
--2147483646.0              |-2147483646
+1                         |2          
+--------------------------------------
+-2147483646.0             |-2147483646
 ij> -- only this should fail
 values (
   cast ('-2147483649' as DECIMAL(24,1)),
   cast (cast ('-2147483649' as DECIMAL(24,1)) as INTEGER)
   );
-1                          |2          
----------------------------------------
+1                         |2          
+--------------------------------------
 ERROR 22003: The resulting value is outside the range for the data type INTEGER.
 ij> values (
   cast ('-2147483648.9' as DECIMAL(24,1)),
   cast (cast ('-2147483648.9' as DECIMAL(24,1)) as INTEGER)
   );
-1                          |2          
----------------------------------------
--2147483648.9              |-2147483648
+1                         |2          
+--------------------------------------
+-2147483648.9             |-2147483648
 ij> --numbers to char
 values (cast (1.1 as char(10)));
 1         
@@ -556,13 +556,13 @@
 ij> values (cast ('123.45' as real));
 ERROR 42846: Cannot convert types 'CHAR' to 'REAL'.
 ij> values (cast ('123.45' as numeric(5,1)));
-1       
---------
-123.4   
+1      
+-------
+123.4  
 ij> values (cast ('123.45' as decimal(5,1)));
-1       
---------
-123.4   
+1      
+-------
+123.4  
 ij> values (cast ('123.99' as smallint));
 1     
 ------
@@ -582,13 +582,13 @@
 ij> values (cast ('123.99' as real));
 ERROR 42846: Cannot convert types 'CHAR' to 'REAL'.
 ij> values (cast ('123.99' as numeric(5,1)));
-1       
---------
-123.9   
+1      
+-------
+123.9  
 ij> values (cast ('123.99' as decimal(5,1)));
-1       
---------
-123.9   
+1      
+-------
+123.9  
 ij> --bad
 values (cast (1 as char(2) for bit data));
 ERROR 42846: Cannot convert types 'INTEGER' to 'CHAR () FOR BIT DATA'.
@@ -1410,8 +1410,8 @@
 ij> values cast('asdf' as double precision);
 ERROR 42846: Cannot convert types 'CHAR' to 'DOUBLE'.
 ij> values cast('asdf' as decimal(5,4));
-1       
---------
+1      
+-------
 ERROR 22018: Invalid character string format for type DECIMAL.
 ij> values cast('asdf' as date);
 ERROR 22007: The syntax of the string representation of a datetime value is incorrect.
@@ -1615,8 +1615,8 @@
 ----------------------
 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       
---------
+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 'DECIMAL'.
 ij> select cast (aliasinfo as CHAR(30) FOR BIT DATA) from sys.sysaliases;
 1                                                           

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/casting.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/casting.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/casting.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/casting.out Fri Jul 14 09:04:03 2006
@@ -1073,9 +1073,9 @@
 NULL                
 Test #4
 VALUES CAST (CAST (NULL AS SMALLINT) AS DECIMAL(10,5) )
-1            
--------------
-NULL         
+1           
+------------
+NULL        
 Test #5
 VALUES CAST (CAST (NULL AS SMALLINT) AS REAL )
 1            
@@ -1138,9 +1138,9 @@
 0                   
 Test #21
 VALUES CAST (CAST (0 AS SMALLINT) AS DECIMAL(10,5) )
-1            
--------------
-0.00000      
+1           
+------------
+0.00000     
 Test #22
 VALUES CAST (CAST (0 AS SMALLINT) AS REAL )
 1            
@@ -1203,9 +1203,9 @@
 NULL                
 Test #38
 VALUES CAST (CAST (NULL AS INTEGER) AS DECIMAL(10,5) )
-1            
--------------
-NULL         
+1           
+------------
+NULL        
 Test #39
 VALUES CAST (CAST (NULL AS INTEGER) AS REAL )
 1            
@@ -1268,9 +1268,9 @@
 11                  
 Test #55
 VALUES CAST (CAST (11 AS INTEGER) AS DECIMAL(10,5) )
-1            
--------------
-11.00000     
+1           
+------------
+11.00000    
 Test #56
 VALUES CAST (CAST (11 AS INTEGER) AS REAL )
 1            
@@ -1333,9 +1333,9 @@
 NULL                
 Test #72
 VALUES CAST (CAST (NULL AS BIGINT) AS DECIMAL(10,5) )
-1            
--------------
-NULL         
+1           
+------------
+NULL        
 Test #73
 VALUES CAST (CAST (NULL AS BIGINT) AS REAL )
 1            
@@ -1398,9 +1398,9 @@
 22                  
 Test #89
 VALUES CAST (CAST (22 AS BIGINT) AS DECIMAL(10,5) )
-1            
--------------
-22.00000     
+1           
+------------
+22.00000    
 Test #90
 VALUES CAST (CAST (22 AS BIGINT) AS REAL )
 1            
@@ -1463,9 +1463,9 @@
 NULL                
 Test #106
 VALUES CAST (CAST (NULL AS DECIMAL(10,5)) AS DECIMAL(10,5) )
-1            
--------------
-NULL         
+1           
+------------
+NULL        
 Test #107
 VALUES CAST (CAST (NULL AS DECIMAL(10,5)) AS REAL )
 1            
@@ -1528,9 +1528,9 @@
 3                   
 Test #123
 VALUES CAST (CAST (3.3 AS DECIMAL(10,5)) AS DECIMAL(10,5) )
-1            
--------------
-3.30000      
+1           
+------------
+3.30000     
 Test #124
 VALUES CAST (CAST (3.3 AS DECIMAL(10,5)) AS REAL )
 1            
@@ -1593,9 +1593,9 @@
 NULL                
 Test #140
 VALUES CAST (CAST (NULL AS REAL) AS DECIMAL(10,5) )
-1            
--------------
-NULL         
+1           
+------------
+NULL        
 Test #141
 VALUES CAST (CAST (NULL AS REAL) AS REAL )
 1            
@@ -1656,9 +1656,9 @@
 4                   
 Test #157
 VALUES CAST (CAST (4.4 AS REAL) AS DECIMAL(10,5) )
-1            
--------------
-4.40000      
+1           
+------------
+4.40000     
 Test #158
 VALUES CAST (CAST (4.4 AS REAL) AS REAL )
 1            
@@ -1719,9 +1719,9 @@
 NULL                
 Test #174
 VALUES CAST (CAST (NULL AS DOUBLE) AS DECIMAL(10,5) )
-1            
--------------
-NULL         
+1           
+------------
+NULL        
 Test #175
 VALUES CAST (CAST (NULL AS DOUBLE) AS REAL )
 1            
@@ -1782,9 +1782,9 @@
 5                   
 Test #191
 VALUES CAST (CAST (5.5 AS DOUBLE) AS DECIMAL(10,5) )
-1            
--------------
-5.50000      
+1           
+------------
+5.50000     
 Test #192
 VALUES CAST (CAST (5.5 AS DOUBLE) AS REAL )
 1            
@@ -1845,9 +1845,9 @@
 NULL                
 Test #208
 VALUES CAST (CAST (NULL AS CHAR(60)) AS DECIMAL(10,5) )
-1            
--------------
-NULL         
+1           
+------------
+NULL        
 Test #209
 VALUES CAST (CAST (NULL AS CHAR(60)) AS REAL )
 EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'REAL'.
@@ -1918,9 +1918,9 @@
 22                  
 Test #225
 VALUES CAST (CAST ('3.3' AS CHAR(60)) AS DECIMAL(10,5) )
-1            
--------------
-3.30000      
+1           
+------------
+3.30000     
 Test #226
 VALUES CAST (CAST ('4.4' AS CHAR(60)) AS REAL )
 EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'REAL'.
@@ -1991,9 +1991,9 @@
 NULL                
 Test #242
 VALUES CAST (CAST (NULL AS VARCHAR(60)) AS DECIMAL(10,5) )
-1            
--------------
-NULL         
+1           
+------------
+NULL        
 Test #243
 VALUES CAST (CAST (NULL AS VARCHAR(60)) AS REAL )
 EXPECTED CASTING EXCEPTION: Cannot convert types 'VARCHAR' to 'REAL'.
@@ -2064,9 +2064,9 @@
 22                  
 Test #259
 VALUES CAST (CAST ('3.3' AS VARCHAR(60)) AS DECIMAL(10,5) )
-1            
--------------
-3.30000      
+1           
+------------
+3.30000     
 Test #260
 VALUES CAST (CAST ('4.4' AS VARCHAR(60)) AS REAL )
 EXPECTED CASTING EXCEPTION: Cannot convert types 'VARCHAR' to 'REAL'.
@@ -3181,9 +3181,9 @@
 --------------------
 22                  
 SELECT distinct c FROM DECIMAL_TAB WHERE c = 3.3
-C            
--------------
-3.30000      
+C           
+------------
+3.30000     
 SELECT distinct c FROM REAL_TAB WHERE c = 4.4
 C            
 -------------
@@ -3238,8 +3238,8 @@
 C                   
 --------------------
 select c from DECIMAL_TAB WHERE c = CAST(NULL AS SMALLINT)
-C            
--------------
+C           
+------------
 select c from REAL_TAB WHERE c = CAST(NULL AS SMALLINT)
 C            
 -------------
@@ -3278,8 +3278,8 @@
 C                   
 --------------------
 select c from DECIMAL_TAB WHERE c = CAST(NULL AS INTEGER)
-C            
--------------
+C           
+------------
 select c from REAL_TAB WHERE c = CAST(NULL AS INTEGER)
 C            
 -------------
@@ -3318,8 +3318,8 @@
 C                   
 --------------------
 select c from DECIMAL_TAB WHERE c = CAST(NULL AS BIGINT)
-C            
--------------
+C           
+------------
 select c from REAL_TAB WHERE c = CAST(NULL AS BIGINT)
 C            
 -------------
@@ -3358,8 +3358,8 @@
 C                   
 --------------------
 select c from DECIMAL_TAB WHERE c = CAST(NULL AS DECIMAL(10,5))
-C            
--------------
+C           
+------------
 select c from REAL_TAB WHERE c = CAST(NULL AS DECIMAL(10,5))
 C            
 -------------
@@ -3398,8 +3398,8 @@
 C                   
 --------------------
 select c from DECIMAL_TAB WHERE c = CAST(NULL AS REAL)
-C            
--------------
+C           
+------------
 select c from REAL_TAB WHERE c = CAST(NULL AS REAL)
 C            
 -------------
@@ -3438,8 +3438,8 @@
 C                   
 --------------------
 select c from DECIMAL_TAB WHERE c = CAST(NULL AS DOUBLE)
-C            
--------------
+C           
+------------
 select c from REAL_TAB WHERE c = CAST(NULL AS DOUBLE)
 C            
 -------------
@@ -3875,8 +3875,8 @@
 C                   
 --------------------
 select c from DECIMAL_TAB WHERE c = CAST(0 AS SMALLINT)
-C            
--------------
+C           
+------------
 select c from REAL_TAB WHERE c = CAST(0 AS SMALLINT)
 C            
 -------------
@@ -3915,8 +3915,8 @@
 C                   
 --------------------
 select c from DECIMAL_TAB WHERE c = CAST(11 AS INTEGER)
-C            
--------------
+C           
+------------
 select c from REAL_TAB WHERE c = CAST(11 AS INTEGER)
 C            
 -------------
@@ -3955,8 +3955,8 @@
 C                   
 --------------------
 select c from DECIMAL_TAB WHERE c = CAST(22 AS BIGINT)
-C            
--------------
+C           
+------------
 select c from REAL_TAB WHERE c = CAST(22 AS BIGINT)
 C            
 -------------
@@ -3995,8 +3995,8 @@
 C                   
 --------------------
 select c from DECIMAL_TAB WHERE c = CAST(3.3 AS DECIMAL(10,5))
-C            
--------------
+C           
+------------
 select c from REAL_TAB WHERE c = CAST(3.3 AS DECIMAL(10,5))
 C            
 -------------
@@ -4035,8 +4035,8 @@
 C                   
 --------------------
 select c from DECIMAL_TAB WHERE c = CAST(4.4 AS REAL)
-C            
--------------
+C           
+------------
 select c from REAL_TAB WHERE c = CAST(4.4 AS REAL)
 C            
 -------------
@@ -4075,8 +4075,8 @@
 C                   
 --------------------
 select c from DECIMAL_TAB WHERE c = CAST(5.5 AS DOUBLE)
-C            
--------------
+C           
+------------
 select c from REAL_TAB WHERE c = CAST(5.5 AS DOUBLE)
 C            
 -------------

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/compressTable.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/compressTable.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/compressTable.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/compressTable.out Fri Jul 14 09:04:03 2006
@@ -58,8 +58,8 @@
 -----------
 1          
 ij> select * from noindexes;
-C1         |C2                            |C3      
----------------------------------------------------
+C1         |C2                            |C3     
+--------------------------------------------------
 ij> -- do consistency check on scans, etc.
 values ConsistencyChecker();
 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
@@ -74,15 +74,15 @@
 ij> call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'NOINDEXES', 0);
 0 rows inserted/updated/deleted
 ij> select * from noindexes;
-C1         |C2                            |C3      
----------------------------------------------------
-1          |1                             |1.10    
-2          |2                             |2.20    
-3          |3                             |3.30    
-4          |4                             |4.40    
-5          |5                             |5.50    
-6          |6                             |6.60    
-7          |7                             |7.70    
+C1         |C2                            |C3     
+--------------------------------------------------
+1          |1                             |1.10   
+2          |2                             |2.20   
+3          |3                             |3.30   
+4          |4                             |4.40   
+5          |5                             |5.50   
+6          |6                             |6.60   
+7          |7                             |7.70   
 ij> insert into noindexes values (8, '8', 8.8), (8, '8', 8.8), (9, '9', 9.9),
      (10, '10', 10.10), (11, '11', 11.11), (12, '12', 12.12), (13, '13', 13.13),
      (14, '14', 14.14), (15, '15', 15.15), (16, '16', 16.16);
@@ -90,51 +90,51 @@
 ij> call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'NOINDEXES', 0);
 0 rows inserted/updated/deleted
 ij> select * from noindexes;
-C1         |C2                            |C3      
----------------------------------------------------
-1          |1                             |1.10    
-2          |2                             |2.20    
-3          |3                             |3.30    
-4          |4                             |4.40    
-5          |5                             |5.50    
-6          |6                             |6.60    
-7          |7                             |7.70    
-8          |8                             |8.80    
-8          |8                             |8.80    
-9          |9                             |9.90    
-10         |10                            |10.10   
-11         |11                            |11.11   
-12         |12                            |12.12   
-13         |13                            |13.13   
-14         |14                            |14.14   
-15         |15                            |15.15   
-16         |16                            |16.16   
+C1         |C2                            |C3     
+--------------------------------------------------
+1          |1                             |1.10   
+2          |2                             |2.20   
+3          |3                             |3.30   
+4          |4                             |4.40   
+5          |5                             |5.50   
+6          |6                             |6.60   
+7          |7                             |7.70   
+8          |8                             |8.80   
+8          |8                             |8.80   
+9          |9                             |9.90   
+10         |10                            |10.10  
+11         |11                            |11.11  
+12         |12                            |12.12  
+13         |13                            |13.13  
+14         |14                            |14.14  
+15         |15                            |15.15  
+16         |16                            |16.16  
 ij> insert into noindexes values (17, '17', 17.17), (18, '18', 18.18);
 2 rows inserted/updated/deleted
 ij> call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'NOINDEXES', 0);
 0 rows inserted/updated/deleted
 ij> select * from noindexes;
-C1         |C2                            |C3      
----------------------------------------------------
-1          |1                             |1.10    
-2          |2                             |2.20    
-3          |3                             |3.30    
-4          |4                             |4.40    
-5          |5                             |5.50    
-6          |6                             |6.60    
-7          |7                             |7.70    
-8          |8                             |8.80    
-8          |8                             |8.80    
-9          |9                             |9.90    
-10         |10                            |10.10   
-11         |11                            |11.11   
-12         |12                            |12.12   
-13         |13                            |13.13   
-14         |14                            |14.14   
-15         |15                            |15.15   
-16         |16                            |16.16   
-17         |17                            |17.17   
-18         |18                            |18.18   
+C1         |C2                            |C3     
+--------------------------------------------------
+1          |1                             |1.10   
+2          |2                             |2.20   
+3          |3                             |3.30   
+4          |4                             |4.40   
+5          |5                             |5.50   
+6          |6                             |6.60   
+7          |7                             |7.70   
+8          |8                             |8.80   
+8          |8                             |8.80   
+9          |9                             |9.90   
+10         |10                            |10.10  
+11         |11                            |11.11  
+12         |12                            |12.12  
+13         |13                            |13.13  
+14         |14                            |14.14  
+15         |15                            |15.15  
+16         |16                            |16.16  
+17         |17                            |17.17  
+18         |18                            |18.18  
 ij> -- do consistency check on scans, etc.
 values ConsistencyChecker();
 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
@@ -168,8 +168,8 @@
 -----------
 6          
 ij> select * from indexes;
-C1         |C2                            |C3      
----------------------------------------------------
+C1         |C2                            |C3     
+--------------------------------------------------
 ij> -- do consistency check on scans, etc.
 values ConsistencyChecker();
 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
@@ -184,15 +184,15 @@
 ij> call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'INDEXES', 0);
 0 rows inserted/updated/deleted
 ij> select * from indexes;
-C1         |C2                            |C3      
----------------------------------------------------
-1          |1                             |1.10    
-2          |2                             |2.20    
-3          |3                             |3.30    
-4          |4                             |4.40    
-5          |5                             |5.50    
-6          |6                             |6.60    
-7          |7                             |7.70    
+C1         |C2                            |C3     
+--------------------------------------------------
+1          |1                             |1.10   
+2          |2                             |2.20   
+3          |3                             |3.30   
+4          |4                             |4.40   
+5          |5                             |5.50   
+6          |6                             |6.60   
+7          |7                             |7.70   
 ij> insert into indexes values (8, '8', 8.8), (8, '8', 8.8), (9, '9', 9.9),
      (10, '10', 10.10), (11, '11', 11.11), (12, '12', 12.12), (13, '13', 13.13),
      (14, '14', 14.14), (15, '15', 15.15), (16, '16', 16.16);
@@ -200,51 +200,51 @@
 ij> call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'INDEXES', 0);
 0 rows inserted/updated/deleted
 ij> select * from indexes;
-C1         |C2                            |C3      
----------------------------------------------------
-1          |1                             |1.10    
-2          |2                             |2.20    
-3          |3                             |3.30    
-4          |4                             |4.40    
-5          |5                             |5.50    
-6          |6                             |6.60    
-7          |7                             |7.70    
-8          |8                             |8.80    
-8          |8                             |8.80    
-9          |9                             |9.90    
-10         |10                            |10.10   
-11         |11                            |11.11   
-12         |12                            |12.12   
-13         |13                            |13.13   
-14         |14                            |14.14   
-15         |15                            |15.15   
-16         |16                            |16.16   
+C1         |C2                            |C3     
+--------------------------------------------------
+1          |1                             |1.10   
+2          |2                             |2.20   
+3          |3                             |3.30   
+4          |4                             |4.40   
+5          |5                             |5.50   
+6          |6                             |6.60   
+7          |7                             |7.70   
+8          |8                             |8.80   
+8          |8                             |8.80   
+9          |9                             |9.90   
+10         |10                            |10.10  
+11         |11                            |11.11  
+12         |12                            |12.12  
+13         |13                            |13.13  
+14         |14                            |14.14  
+15         |15                            |15.15  
+16         |16                            |16.16  
 ij> insert into indexes values (17, '17', 17.17), (18, '18', 18.18);
 2 rows inserted/updated/deleted
 ij> call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'INDEXES', 0);
 0 rows inserted/updated/deleted
 ij> select * from indexes;
-C1         |C2                            |C3      
----------------------------------------------------
-1          |1                             |1.10    
-2          |2                             |2.20    
-3          |3                             |3.30    
-4          |4                             |4.40    
-5          |5                             |5.50    
-6          |6                             |6.60    
-7          |7                             |7.70    
-8          |8                             |8.80    
-8          |8                             |8.80    
-9          |9                             |9.90    
-10         |10                            |10.10   
-11         |11                            |11.11   
-12         |12                            |12.12   
-13         |13                            |13.13   
-14         |14                            |14.14   
-15         |15                            |15.15   
-16         |16                            |16.16   
-17         |17                            |17.17   
-18         |18                            |18.18   
+C1         |C2                            |C3     
+--------------------------------------------------
+1          |1                             |1.10   
+2          |2                             |2.20   
+3          |3                             |3.30   
+4          |4                             |4.40   
+5          |5                             |5.50   
+6          |6                             |6.60   
+7          |7                             |7.70   
+8          |8                             |8.80   
+8          |8                             |8.80   
+9          |9                             |9.90   
+10         |10                            |10.10  
+11         |11                            |11.11  
+12         |12                            |12.12  
+13         |13                            |13.13  
+14         |14                            |14.14  
+15         |15                            |15.15  
+16         |16                            |16.16  
+17         |17                            |17.17  
+18         |18                            |18.18  
 ij> -- do consistency check on scans, etc.
 values ConsistencyChecker();
 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
@@ -392,8 +392,8 @@
 call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'NOINDEXES', 1);
 0 rows inserted/updated/deleted
 ij> select * from v_noindexes;
-C1         |C2                            |C3      
----------------------------------------------------
+C1         |C2                            |C3     
+--------------------------------------------------
 ij> -- full table
 insert into noindexes values (1, '1', 1.1), (2, '2', 2.2), (3, '3', 3.3),
      (4, '4', 4.4), (5, '5', 5.5), (6, '6', 6.6), (7, '7', 7.7);
@@ -401,15 +401,15 @@
 ij> call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'NOINDEXES', 1);
 0 rows inserted/updated/deleted
 ij> select * from v_noindexes;
-C1         |C2                            |C3      
----------------------------------------------------
-1          |1                             |1.10    
-2          |2                             |2.20    
-3          |3                             |3.30    
-4          |4                             |4.40    
-5          |5                             |5.50    
-6          |6                             |6.60    
-7          |7                             |7.70    
+C1         |C2                            |C3     
+--------------------------------------------------
+1          |1                             |1.10   
+2          |2                             |2.20   
+3          |3                             |3.30   
+4          |4                             |4.40   
+5          |5                             |5.50   
+6          |6                             |6.60   
+7          |7                             |7.70   
 ij> insert into noindexes values (8, '8', 8.8), (8, '8', 8.8), (9, '9', 9.9),
      (10, '10', 10.10), (11, '11', 11.11), (12, '12', 12.12), (13, '13', 13.13),
      (14, '14', 14.14), (15, '15', 15.15), (16, '16', 16.16);
@@ -417,51 +417,51 @@
 ij> call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'NOINDEXES', 1);
 0 rows inserted/updated/deleted
 ij> select * from v_noindexes;
-C1         |C2                            |C3      
----------------------------------------------------
-1          |1                             |1.10    
-2          |2                             |2.20    
-3          |3                             |3.30    
-4          |4                             |4.40    
-5          |5                             |5.50    
-6          |6                             |6.60    
-7          |7                             |7.70    
-8          |8                             |8.80    
-8          |8                             |8.80    
-9          |9                             |9.90    
-10         |10                            |10.10   
-11         |11                            |11.11   
-12         |12                            |12.12   
-13         |13                            |13.13   
-14         |14                            |14.14   
-15         |15                            |15.15   
-16         |16                            |16.16   
+C1         |C2                            |C3     
+--------------------------------------------------
+1          |1                             |1.10   
+2          |2                             |2.20   
+3          |3                             |3.30   
+4          |4                             |4.40   
+5          |5                             |5.50   
+6          |6                             |6.60   
+7          |7                             |7.70   
+8          |8                             |8.80   
+8          |8                             |8.80   
+9          |9                             |9.90   
+10         |10                            |10.10  
+11         |11                            |11.11  
+12         |12                            |12.12  
+13         |13                            |13.13  
+14         |14                            |14.14  
+15         |15                            |15.15  
+16         |16                            |16.16  
 ij> insert into noindexes values (17, '17', 17.17), (18, '18', 18.18);
 2 rows inserted/updated/deleted
 ij> call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'NOINDEXES', 1);
 0 rows inserted/updated/deleted
 ij> select * from v_noindexes;
-C1         |C2                            |C3      
----------------------------------------------------
-1          |1                             |1.10    
-2          |2                             |2.20    
-3          |3                             |3.30    
-4          |4                             |4.40    
-5          |5                             |5.50    
-6          |6                             |6.60    
-7          |7                             |7.70    
-8          |8                             |8.80    
-8          |8                             |8.80    
-9          |9                             |9.90    
-10         |10                            |10.10   
-11         |11                            |11.11   
-12         |12                            |12.12   
-13         |13                            |13.13   
-14         |14                            |14.14   
-15         |15                            |15.15   
-16         |16                            |16.16   
-17         |17                            |17.17   
-18         |18                            |18.18   
+C1         |C2                            |C3     
+--------------------------------------------------
+1          |1                             |1.10   
+2          |2                             |2.20   
+3          |3                             |3.30   
+4          |4                             |4.40   
+5          |5                             |5.50   
+6          |6                             |6.60   
+7          |7                             |7.70   
+8          |8                             |8.80   
+8          |8                             |8.80   
+9          |9                             |9.90   
+10         |10                            |10.10  
+11         |11                            |11.11  
+12         |12                            |12.12  
+13         |13                            |13.13  
+14         |14                            |14.14  
+15         |15                            |15.15  
+16         |16                            |16.16  
+17         |17                            |17.17  
+18         |18                            |18.18  
 ij> rollback;
 ij> -- 1 index
 drop index i_c2;
@@ -476,8 +476,8 @@
 call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'INDEXES', 1);
 0 rows inserted/updated/deleted
 ij> select * from indexes;
-C1         |C2                            |C3      
----------------------------------------------------
+C1         |C2                            |C3     
+--------------------------------------------------
 ij> -- full table
 insert into indexes values (1, '1', 1.1), (2, '2', 2.2), (3, '3', 3.3),
      (4, '4', 4.4), (5, '5', 5.5), (6, '6', 6.6), (7, '7', 7.7);
@@ -485,15 +485,15 @@
 ij> call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'INDEXES', 1);
 0 rows inserted/updated/deleted
 ij> select * from indexes;
-C1         |C2                            |C3      
----------------------------------------------------
-1          |1                             |1.10    
-2          |2                             |2.20    
-3          |3                             |3.30    
-4          |4                             |4.40    
-5          |5                             |5.50    
-6          |6                             |6.60    
-7          |7                             |7.70    
+C1         |C2                            |C3     
+--------------------------------------------------
+1          |1                             |1.10   
+2          |2                             |2.20   
+3          |3                             |3.30   
+4          |4                             |4.40   
+5          |5                             |5.50   
+6          |6                             |6.60   
+7          |7                             |7.70   
 ij> insert into indexes values (8, '8', 8.8), (8, '8', 8.8), (9, '9', 9.9),
      (10, '10', 10.10), (11, '11', 11.11), (12, '12', 12.12), (13, '13', 13.13),
      (14, '14', 14.14), (15, '15', 15.15), (16, '16', 16.16);
@@ -501,59 +501,59 @@
 ij> call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'INDEXES', 1);
 0 rows inserted/updated/deleted
 ij> select * from indexes;
-C1         |C2                            |C3      
----------------------------------------------------
-1          |1                             |1.10    
-2          |2                             |2.20    
-3          |3                             |3.30    
-4          |4                             |4.40    
-5          |5                             |5.50    
-6          |6                             |6.60    
-7          |7                             |7.70    
-8          |8                             |8.80    
-8          |8                             |8.80    
-9          |9                             |9.90    
-10         |10                            |10.10   
-11         |11                            |11.11   
-12         |12                            |12.12   
-13         |13                            |13.13   
-14         |14                            |14.14   
-15         |15                            |15.15   
-16         |16                            |16.16   
+C1         |C2                            |C3     
+--------------------------------------------------
+1          |1                             |1.10   
+2          |2                             |2.20   
+3          |3                             |3.30   
+4          |4                             |4.40   
+5          |5                             |5.50   
+6          |6                             |6.60   
+7          |7                             |7.70   
+8          |8                             |8.80   
+8          |8                             |8.80   
+9          |9                             |9.90   
+10         |10                            |10.10  
+11         |11                            |11.11  
+12         |12                            |12.12  
+13         |13                            |13.13  
+14         |14                            |14.14  
+15         |15                            |15.15  
+16         |16                            |16.16  
 ij> insert into indexes values (17, '17', 17.17), (18, '18', 18.18);
 2 rows inserted/updated/deleted
 ij> call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'INDEXES', 1);
 0 rows inserted/updated/deleted
 ij> select * from indexes;
-C1         |C2                            |C3      
----------------------------------------------------
-1          |1                             |1.10    
-2          |2                             |2.20    
-3          |3                             |3.30    
-4          |4                             |4.40    
-5          |5                             |5.50    
-6          |6                             |6.60    
-7          |7                             |7.70    
-8          |8                             |8.80    
-8          |8                             |8.80    
-9          |9                             |9.90    
-10         |10                            |10.10   
-11         |11                            |11.11   
-12         |12                            |12.12   
-13         |13                            |13.13   
-14         |14                            |14.14   
-15         |15                            |15.15   
-16         |16                            |16.16   
-17         |17                            |17.17   
-18         |18                            |18.18   
+C1         |C2                            |C3     
+--------------------------------------------------
+1          |1                             |1.10   
+2          |2                             |2.20   
+3          |3                             |3.30   
+4          |4                             |4.40   
+5          |5                             |5.50   
+6          |6                             |6.60   
+7          |7                             |7.70   
+8          |8                             |8.80   
+8          |8                             |8.80   
+9          |9                             |9.90   
+10         |10                            |10.10  
+11         |11                            |11.11  
+12         |12                            |12.12  
+13         |13                            |13.13  
+14         |14                            |14.14  
+15         |15                            |15.15  
+16         |16                            |16.16  
+17         |17                            |17.17  
+18         |18                            |18.18  
 ij> rollback;
 ij> -- multiple indexes
 -- empty table
 call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'INDEXES', 1);
 0 rows inserted/updated/deleted
 ij> select * from indexes;
-C1         |C2                            |C3      
----------------------------------------------------
+C1         |C2                            |C3     
+--------------------------------------------------
 ij> -- full table
 insert into indexes values (1, '1', 1.1), (2, '2', 2.2), (3, '3', 3.3),
      (4, '4', 4.4), (5, '5', 5.5), (6, '6', 6.6), (7, '7', 7.7);
@@ -561,15 +561,15 @@
 ij> call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'INDEXES', 1);
 0 rows inserted/updated/deleted
 ij> select * from indexes;
-C1         |C2                            |C3      
----------------------------------------------------
-1          |1                             |1.10    
-2          |2                             |2.20    
-3          |3                             |3.30    
-4          |4                             |4.40    
-5          |5                             |5.50    
-6          |6                             |6.60    
-7          |7                             |7.70    
+C1         |C2                            |C3     
+--------------------------------------------------
+1          |1                             |1.10   
+2          |2                             |2.20   
+3          |3                             |3.30   
+4          |4                             |4.40   
+5          |5                             |5.50   
+6          |6                             |6.60   
+7          |7                             |7.70   
 ij> insert into indexes values (8, '8', 8.8), (8, '8', 8.8), (9, '9', 9.9),
      (10, '10', 10.10), (11, '11', 11.11), (12, '12', 12.12), (13, '13', 13.13),
      (14, '14', 14.14), (15, '15', 15.15), (16, '16', 16.16);
@@ -577,51 +577,51 @@
 ij> call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'INDEXES', 1);
 0 rows inserted/updated/deleted
 ij> select * from indexes;
-C1         |C2                            |C3      
----------------------------------------------------
-1          |1                             |1.10    
-2          |2                             |2.20    
-3          |3                             |3.30    
-4          |4                             |4.40    
-5          |5                             |5.50    
-6          |6                             |6.60    
-7          |7                             |7.70    
-8          |8                             |8.80    
-8          |8                             |8.80    
-9          |9                             |9.90    
-10         |10                            |10.10   
-11         |11                            |11.11   
-12         |12                            |12.12   
-13         |13                            |13.13   
-14         |14                            |14.14   
-15         |15                            |15.15   
-16         |16                            |16.16   
+C1         |C2                            |C3     
+--------------------------------------------------
+1          |1                             |1.10   
+2          |2                             |2.20   
+3          |3                             |3.30   
+4          |4                             |4.40   
+5          |5                             |5.50   
+6          |6                             |6.60   
+7          |7                             |7.70   
+8          |8                             |8.80   
+8          |8                             |8.80   
+9          |9                             |9.90   
+10         |10                            |10.10  
+11         |11                            |11.11  
+12         |12                            |12.12  
+13         |13                            |13.13  
+14         |14                            |14.14  
+15         |15                            |15.15  
+16         |16                            |16.16  
 ij> insert into indexes values (17, '17', 17.17), (18, '18', 18.18);
 2 rows inserted/updated/deleted
 ij> call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'INDEXES', 1);
 0 rows inserted/updated/deleted
 ij> select * from indexes;
-C1         |C2                            |C3      
----------------------------------------------------
-1          |1                             |1.10    
-2          |2                             |2.20    
-3          |3                             |3.30    
-4          |4                             |4.40    
-5          |5                             |5.50    
-6          |6                             |6.60    
-7          |7                             |7.70    
-8          |8                             |8.80    
-8          |8                             |8.80    
-9          |9                             |9.90    
-10         |10                            |10.10   
-11         |11                            |11.11   
-12         |12                            |12.12   
-13         |13                            |13.13   
-14         |14                            |14.14   
-15         |15                            |15.15   
-16         |16                            |16.16   
-17         |17                            |17.17   
-18         |18                            |18.18   
+C1         |C2                            |C3     
+--------------------------------------------------
+1          |1                             |1.10   
+2          |2                             |2.20   
+3          |3                             |3.30   
+4          |4                             |4.40   
+5          |5                             |5.50   
+6          |6                             |6.60   
+7          |7                             |7.70   
+8          |8                             |8.80   
+8          |8                             |8.80   
+9          |9                             |9.90   
+10         |10                            |10.10  
+11         |11                            |11.11  
+12         |12                            |12.12  
+13         |13                            |13.13  
+14         |14                            |14.14  
+15         |15                            |15.15  
+16         |16                            |16.16  
+17         |17                            |17.17  
+18         |18                            |18.18  
 ij> rollback;
 ij> --table with multiple indexes, indexes share columns
 --table has more than 4 rows

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/consistencyChecker.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/consistencyChecker.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/consistencyChecker.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/consistencyChecker.out Fri Jul 14 09:04:03 2006
@@ -141,21 +141,21 @@
 1          
 ij> -- set 1st row from heap to all nulls
 select * from t1;
-I          |S     |C10       |VC10      |DC      
--------------------------------------------------
-2          |22    |2 2       |2 2 2     |222.22  
-3          |33    |3 3       |3 3 3     |333.33  
-4          |44    |4 4       |4 4 4     |444.44  
-1          |11    |1 1       |1 1 1     |111.11  
+I          |S     |C10       |VC10      |DC     
+------------------------------------------------
+2          |22    |2 2       |2 2 2     |222.22 
+3          |33    |3 3       |3 3 3     |333.33 
+4          |44    |4 4       |4 4 4     |444.44 
+1          |11    |1 1       |1 1 1     |111.11 
 ij> call NFHR('APP', 'T1');
 0 rows inserted/updated/deleted
 ij> select * from t1;
-I          |S     |C10       |VC10      |DC      
--------------------------------------------------
-NULL       |NULL  |NULL      |NULL      |NULL    
-3          |33    |3 3       |3 3 3     |333.33  
-4          |44    |4 4       |4 4 4     |444.44  
-1          |11    |1 1       |1 1 1     |111.11  
+I          |S     |C10       |VC10      |DC     
+------------------------------------------------
+NULL       |NULL  |NULL      |NULL      |NULL   
+3          |33    |3 3       |3 3 3     |333.33 
+4          |44    |4 4       |4 4 4     |444.44 
+1          |11    |1 1       |1 1 1     |111.11 
 ij> values SYSCS_UTIL.SYSCS_CHECK_TABLE('APP', 'T1');
 1          
 -----------

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ejbql.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ejbql.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ejbql.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ejbql.out Fri Jul 14 09:04:03 2006
@@ -1633,13 +1633,13 @@
 -----------
 4          
 ij> values absval( 4.4 );
-1    
------
-4.4  
+1   
+----
+4.4 
 ij> values absval( -4.4 );
-1    
------
-4.4  
+1   
+----
+4.4 
 ij> values {fn abs( 4 )};
 1          
 -----------
@@ -1649,17 +1649,17 @@
 -----------
 4          
 ij> values {fn abs( 4.4 )};
-1    
------
-4.4  
+1   
+----
+4.4 
 ij> values {fn abs( -4.4 )};
-1    
------
-4.4  
+1   
+----
+4.4 
 ij> values {fn abs( -4.44444444444444444444444 )};
-1                          
----------------------------
-4.44444444444444444444444  
+1                         
+--------------------------
+4.44444444444444444444444 
 ij> autocommit on;
 ij> drop table myint;
 0 rows inserted/updated/deleted



Mime
View raw message