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 [2/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
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/floattypes.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/floattypes.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/floattypes.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/floattypes.out Fri Jul 14 09:04:03 2006
@@ -50,13 +50,13 @@
 ------
 1     
 ij> values cast (1.1 as dec(5,3));
-1       
---------
-1.100   
+1      
+-------
+1.100  
 ij> values cast (1.1 as numeric(5,3));
-1       
---------
-1.100   
+1      
+-------
+1.100  
 ij> -- cast to all valid types
 values cast (1.1 as int);
 1          
@@ -393,15 +393,15 @@
 1.0                   
 1.0                   
 ij> select cast(d as dec(10,2)) from tmp;
-1            
--------------
-1.00         
-1.00         
+1           
+------------
+1.00        
+1.00        
 ij> select cast(d as dec(10,8)) from tmp;
-1            
--------------
-1.00000000   
-1.00000000   
+1           
+------------
+1.00000000  
+1.00000000  
 ij> drop table tmp;
 0 rows inserted/updated/deleted
 ij> drop table t;
@@ -440,12 +440,12 @@
 						 );
 1 row inserted/updated/deleted
 ij> select dc from t;
-DC           
--------------
-NULL         
-10.00        
--10.00       
-0.00         
+DC          
+------------
+NULL        
+10.00       
+-10.00      
+0.00        
 ij> select dc + i, dc + s, dc + r, dc + dc from t;
 1               |2             |3            |4             
 ------------------------------------------------------------
@@ -484,11 +484,11 @@
 0.0                   |0.0                   
 ij> -- test null/null, constant/null, null/constant
 select dc, i / dc, 10 / dc, dc / 10e0 from t;
-DC           |2                                 |3                                 |4                     
-----------------------------------------------------------------------------------------------------------
-NULL         |NULL                              |NULL                              |NULL                  
-10.00        |1.0000000000000000000             |1.0000000000000000000             |1.0                   
--10.00       |1.0000000000000000000             |-1.0000000000000000000            |-1.0                  
+DC          |2                                 |3                                 |4                     
+---------------------------------------------------------------------------------------------------------
+NULL        |NULL                              |NULL                              |NULL                  
+10.00       |1.0000000000000000000             |1.0000000000000000000             |1.0                   
+-10.00      |1.0000000000000000000             |-1.0000000000000000000            |-1.0                  
 ERROR 22012: Attempt to divide by zero.
 ij> -- test for divide by 0
 select dc / i from t;
@@ -507,20 +507,20 @@
 1.0                   |1.0                   
 ij> -- test positive/negative, negative/positive and negative/negative
 select dc, dc / -dc, (-dc) / dc, (-dc) / -dc from t;
-DC           |2                                 |3                                 |4                                 
-----------------------------------------------------------------------------------------------------------------------
-NULL         |NULL                              |NULL                              |NULL                              
-10.00        |-1.000000000000000000000          |-1.000000000000000000000          |1.000000000000000000000           
--10.00       |-1.000000000000000000000          |-1.000000000000000000000          |1.000000000000000000000           
+DC          |2                                 |3                                 |4                                 
+---------------------------------------------------------------------------------------------------------------------
+NULL        |NULL                              |NULL                              |NULL                              
+10.00       |-1.000000000000000000000          |-1.000000000000000000000          |1.000000000000000000000           
+-10.00      |-1.000000000000000000000          |-1.000000000000000000000          |1.000000000000000000000           
 ERROR 22012: Attempt to divide by zero.
 ij> -- test some "more complex" expressions
 select dc, dc + 10e0, dc - (10 - 20e0), dc - 10, dc - (20 - 10) from t;
-DC           |2                     |3                     |4               |5               
----------------------------------------------------------------------------------------------
-NULL         |NULL                  |NULL                  |NULL            |NULL            
-10.00        |20.0                  |20.0                  |0.00            |0.00            
--10.00       |0.0                   |0.0                   |-20.00          |-20.00          
-0.00         |10.0                  |10.0                  |-10.00          |-10.00          
+DC          |2                     |3                     |4               |5               
+--------------------------------------------------------------------------------------------
+NULL        |NULL                  |NULL                  |NULL            |NULL            
+10.00       |20.0                  |20.0                  |0.00            |0.00            
+-10.00      |0.0                   |0.0                   |-20.00          |-20.00          
+0.00        |10.0                  |10.0                  |-10.00          |-10.00          
 ij> -- make sure we get the right scale/precision during arithmetic
 values (9.0 + 9.0);
 1     
@@ -621,9 +621,9 @@
 --		 cast(1.7e308 as dec(2147483647))));
 --
 values cast(1 as dec(31, 20));
-1                                 
-----------------------------------
-1.00000000000000000000            
+1                                
+---------------------------------
+1.00000000000000000000           
 ij> -- test the arithmetic operators on a type we know they don't work on
 create table w (x dec, y long varchar);
 0 rows inserted/updated/deleted
@@ -651,314 +651,314 @@
 1 row inserted/updated/deleted
 ij> -- test =
 select dc from t where dc is null;
-DC           
--------------
-NULL         
+DC          
+------------
+NULL        
 ij> select dc from t where dc = 10;
-DC           
--------------
-10.00        
+DC          
+------------
+10.00       
 ij> select dc from t where dc = -10;
-DC           
--------------
--10.00       
+DC          
+------------
+-10.00      
 ij> select dc from t where dc = 0;
-DC           
--------------
-0.00         
+DC          
+------------
+0.00        
 ij> select dc from t where dc = 1234.45;
-DC           
--------------
+DC          
+------------
 ij> select dc from t where dc = i;
-DC           
--------------
-10.00        
--10.00       
-0.00         
+DC          
+------------
+10.00       
+-10.00      
+0.00        
 ij> select dc from t where dc = l;
-DC           
--------------
-10.00        
--10.00       
-0.00         
+DC          
+------------
+10.00       
+-10.00      
+0.00        
 ij> select dc from t where dc = s;
-DC           
--------------
-10.00        
--10.00       
-0.00         
+DC          
+------------
+10.00       
+-10.00      
+0.00        
 ij> select dc from t where dc = r;
-DC           
--------------
-10.00        
--10.00       
-0.00         
-1234.56      
+DC          
+------------
+10.00       
+-10.00      
+0.00        
+1234.56     
 ij> select dc from t where dc = d;
-DC           
--------------
-10.00        
--10.00       
-0.00         
-1234.56      
+DC          
+------------
+10.00       
+-10.00      
+0.00        
+1234.56     
 ij> select dc from t where dc = dc;
-DC           
--------------
-10.00        
--10.00       
-0.00         
-1234.56      
+DC          
+------------
+10.00       
+-10.00      
+0.00        
+1234.56     
 ij> -- test >
 select dc from t where dc > 10;
-DC           
--------------
-1234.56      
+DC          
+------------
+1234.56     
 ij> select dc from t where dc > -10;
-DC           
--------------
-10.00        
-0.00         
-1234.56      
+DC          
+------------
+10.00       
+0.00        
+1234.56     
 ij> select dc from t where dc > 0;
-DC           
--------------
-10.00        
-1234.56      
+DC          
+------------
+10.00       
+1234.56     
 ij> select dc from t where dc > 1234.45;
-DC           
--------------
-1234.56      
+DC          
+------------
+1234.56     
 ij> select dc from t where dc > i;
-DC           
--------------
-1234.56      
+DC          
+------------
+1234.56     
 ij> select dc from t where dc > l;
-DC           
--------------
-1234.56      
+DC          
+------------
+1234.56     
 ij> select dc from t where dc > s;
-DC           
--------------
-1234.56      
+DC          
+------------
+1234.56     
 ij> select dc from t where dc > r;
-DC           
--------------
+DC          
+------------
 ij> select dc from t where dc > d;
-DC           
--------------
+DC          
+------------
 ij> select dc from t where dc > dc;
-DC           
--------------
+DC          
+------------
 ij> -- test >=
 select dc from t where dc >= 10;
-DC           
--------------
-10.00        
-1234.56      
+DC          
+------------
+10.00       
+1234.56     
 ij> select dc from t where dc >= -10;
-DC           
--------------
-10.00        
--10.00       
-0.00         
-1234.56      
+DC          
+------------
+10.00       
+-10.00      
+0.00        
+1234.56     
 ij> select dc from t where dc >= 0;
-DC           
--------------
-10.00        
-0.00         
-1234.56      
+DC          
+------------
+10.00       
+0.00        
+1234.56     
 ij> select dc from t where dc >= 1234.45;
-DC           
--------------
-1234.56      
+DC          
+------------
+1234.56     
 ij> select dc from t where dc >= i;
-DC           
--------------
-10.00        
--10.00       
-0.00         
-1234.56      
+DC          
+------------
+10.00       
+-10.00      
+0.00        
+1234.56     
 ij> select dc from t where dc >= l;
-DC           
--------------
-10.00        
--10.00       
-0.00         
-1234.56      
+DC          
+------------
+10.00       
+-10.00      
+0.00        
+1234.56     
 ij> select dc from t where dc >= s;
-DC           
--------------
-10.00        
--10.00       
-0.00         
-1234.56      
+DC          
+------------
+10.00       
+-10.00      
+0.00        
+1234.56     
 ij> select dc from t where dc >= r;
-DC           
--------------
-10.00        
--10.00       
-0.00         
-1234.56      
+DC          
+------------
+10.00       
+-10.00      
+0.00        
+1234.56     
 ij> select dc from t where dc >= d;
-DC           
--------------
-10.00        
--10.00       
-0.00         
-1234.56      
+DC          
+------------
+10.00       
+-10.00      
+0.00        
+1234.56     
 ij> select dc from t where dc >= dc;
-DC           
--------------
-10.00        
--10.00       
-0.00         
-1234.56      
+DC          
+------------
+10.00       
+-10.00      
+0.00        
+1234.56     
 ij> -- test <
 select dc from t where dc < 10;
-DC           
--------------
--10.00       
-0.00         
+DC          
+------------
+-10.00      
+0.00        
 ij> select dc from t where dc < -10;
-DC           
--------------
+DC          
+------------
 ij> select dc from t where dc < 0;
-DC           
--------------
--10.00       
+DC          
+------------
+-10.00      
 ij> select dc from t where dc < 1234.45;
-DC           
--------------
-10.00        
--10.00       
-0.00         
+DC          
+------------
+10.00       
+-10.00      
+0.00        
 ij> select dc from t where dc < i;
-DC           
--------------
+DC          
+------------
 ij> select dc from t where dc < l;
-DC           
--------------
+DC          
+------------
 ij> select dc from t where dc < s;
-DC           
--------------
+DC          
+------------
 ij> select dc from t where dc < r;
-DC           
--------------
+DC          
+------------
 ij> select dc from t where dc < d;
-DC           
--------------
+DC          
+------------
 ij> select dc from t where dc < dc;
-DC           
--------------
+DC          
+------------
 ij> -- test <=
 select dc from t where dc <= 10;
-DC           
--------------
-10.00        
--10.00       
-0.00         
+DC          
+------------
+10.00       
+-10.00      
+0.00        
 ij> select dc from t where dc <= -10;
-DC           
--------------
--10.00       
+DC          
+------------
+-10.00      
 ij> select dc from t where dc <= 0;
-DC           
--------------
--10.00       
-0.00         
+DC          
+------------
+-10.00      
+0.00        
 ij> select dc from t where dc <= 1234.45;
-DC           
--------------
-10.00        
--10.00       
-0.00         
+DC          
+------------
+10.00       
+-10.00      
+0.00        
 ij> select dc from t where dc <= i;
-DC           
--------------
-10.00        
--10.00       
-0.00         
+DC          
+------------
+10.00       
+-10.00      
+0.00        
 ij> select dc from t where dc <= l;
-DC           
--------------
-10.00        
--10.00       
-0.00         
+DC          
+------------
+10.00       
+-10.00      
+0.00        
 ij> select dc from t where dc <= s;
-DC           
--------------
-10.00        
--10.00       
-0.00         
+DC          
+------------
+10.00       
+-10.00      
+0.00        
 ij> select dc from t where dc <= r;
-DC           
--------------
-10.00        
--10.00       
-0.00         
-1234.56      
+DC          
+------------
+10.00       
+-10.00      
+0.00        
+1234.56     
 ij> select dc from t where dc <= d;
-DC           
--------------
-10.00        
--10.00       
-0.00         
-1234.56      
+DC          
+------------
+10.00       
+-10.00      
+0.00        
+1234.56     
 ij> select dc from t where dc <= dc;
-DC           
--------------
-10.00        
--10.00       
-0.00         
-1234.56      
+DC          
+------------
+10.00       
+-10.00      
+0.00        
+1234.56     
 ij> -- test <>
 select dc from t where dc <> 10;
-DC           
--------------
--10.00       
-0.00         
-1234.56      
+DC          
+------------
+-10.00      
+0.00        
+1234.56     
 ij> select dc from t where dc <> -10;
-DC           
--------------
-10.00        
-0.00         
-1234.56      
+DC          
+------------
+10.00       
+0.00        
+1234.56     
 ij> select dc from t where dc <> 0;
-DC           
--------------
-10.00        
--10.00       
-1234.56      
+DC          
+------------
+10.00       
+-10.00      
+1234.56     
 ij> select dc from t where dc <> 1234.45;
-DC           
--------------
-10.00        
--10.00       
-0.00         
-1234.56      
+DC          
+------------
+10.00       
+-10.00      
+0.00        
+1234.56     
 ij> select dc from t where dc <> i;
-DC           
--------------
-1234.56      
+DC          
+------------
+1234.56     
 ij> select dc from t where dc <> l;
-DC           
--------------
-1234.56      
+DC          
+------------
+1234.56     
 ij> select dc from t where dc <> s;
-DC           
--------------
-1234.56      
+DC          
+------------
+1234.56     
 ij> select dc from t where dc <> r;
-DC           
--------------
+DC          
+------------
 ij> select dc from t where dc <> d;
-DC           
--------------
+DC          
+------------
 ij> select dc from t where dc <> dc;
-DC           
--------------
+DC          
+------------
 ij> --
 -- test a variety of inserts and updates
 --
@@ -982,65 +982,65 @@
 update t2 set dc = dc + 1.1;
 5 rows inserted/updated/deleted
 ij> select dc from t2;
-DC           
--------------
--8.90        
-1.10         
-11.10        
-1235.66      
-NULL         
+DC          
+------------
+-8.90       
+1.10        
+11.10       
+1235.66     
+NULL        
 ij> update t2 set dc = dc - 1.1;
 5 rows inserted/updated/deleted
 ij> select dc from t2;
-DC           
--------------
--10.00       
-0.00         
-10.00        
-1234.56      
-NULL         
+DC          
+------------
+-10.00      
+0.00        
+10.00       
+1234.56     
+NULL        
 ij> update t2 set dc = dc / 1.1;
 5 rows inserted/updated/deleted
 ij> select dc from t2;
-DC           
--------------
--9.09        
-0.00         
-9.09         
-1122.32      
-NULL         
+DC          
+------------
+-9.09       
+0.00        
+9.09        
+1122.32     
+NULL        
 ij> update t2 set dc = dc * 1.1;
 5 rows inserted/updated/deleted
 ij> select dc from t2;
-DC           
--------------
--9.99        
-0.00         
-9.99         
-1234.55      
-NULL         
+DC          
+------------
+-9.99       
+0.00        
+9.99        
+1234.55     
+NULL        
 ij> -- try some deletes
 delete from t2 where dc > 0;
 2 rows inserted/updated/deleted
 ij> select dc from t2;
-DC           
--------------
--9.99        
-0.00         
-NULL         
+DC          
+------------
+-9.99       
+0.00        
+NULL        
 ij> delete from t2 where dc = 0;
 1 row inserted/updated/deleted
 ij> select dc from t2;
-DC           
--------------
--9.99        
-NULL         
+DC          
+------------
+-9.99       
+NULL        
 ij> delete from t2 where dc < 0;
 1 row inserted/updated/deleted
 ij> select dc from t2;
-DC           
--------------
-NULL         
+DC          
+------------
+NULL        
 ij> drop table t2;
 0 rows inserted/updated/deleted
 ij> drop table t;
@@ -1074,33 +1074,33 @@
 ij> insert into t values ('a', 9.123, 'Z');
 1 row inserted/updated/deleted
 ij> select * from t;
-C1  |D                      |C2  
----------------------------------
-a   |1.1230                 |Z   
-a   |11111.1230             |Z   
-a   |11111111.1230          |Z   
-a   |6.1230                 |Z   
-a   |666.1230               |Z   
-a   |0.6000                 |Z   
-a   |0.0000                 |Z   
-a   |666666.1230            |Z   
-a   |99999999999999.1230    |Z   
-a   |9.1230                 |Z   
+C1  |D                     |C2  
+--------------------------------
+a   |1.1230                |Z   
+a   |11111.1230            |Z   
+a   |11111111.1230         |Z   
+a   |6.1230                |Z   
+a   |666.1230              |Z   
+a   |0.6000                |Z   
+a   |0.0000                |Z   
+a   |666666.1230           |Z   
+a   |99999999999999.1230   |Z   
+a   |9.1230                |Z   
 ij> update t set d = d + .0007;
 10 rows inserted/updated/deleted
 ij> select * from t;
-C1  |D                      |C2  
----------------------------------
-a   |1.1237                 |Z   
-a   |11111.1237             |Z   
-a   |11111111.1237          |Z   
-a   |6.1237                 |Z   
-a   |666.1237               |Z   
-a   |0.6007                 |Z   
-a   |0.0007                 |Z   
-a   |666666.1237            |Z   
-a   |99999999999999.1237    |Z   
-a   |9.1237                 |Z   
+C1  |D                     |C2  
+--------------------------------
+a   |1.1237                |Z   
+a   |11111.1237            |Z   
+a   |11111111.1237         |Z   
+a   |6.1237                |Z   
+a   |666.1237              |Z   
+a   |0.6007                |Z   
+a   |0.0007                |Z   
+a   |666666.1237           |Z   
+a   |99999999999999.1237   |Z   
+a   |9.1237                |Z   
 ij> drop table tmp;
 ERROR 42Y55: 'DROP TABLE' cannot be performed on 'TMP' because it does not exist.
 ij> drop table bad;
@@ -2444,87 +2444,87 @@
 ij> insert into tiger values (0.00000001234);
 1 row inserted/updated/deleted
 ij> select d from tiger order by 1;
-D              
----------------
-0.00000001234  
-0.00000001234  
-0.00000012340  
-0.00000123400  
-0.00001234000  
-0.00012340000  
-0.00123400000  
-0.00123400000  
-0.01234000000  
-0.12340000000  
-1.23400000000  
+D             
+--------------
+0.00000001234 
+0.00000001234 
+0.00000012340 
+0.00000123400 
+0.00001234000 
+0.00012340000 
+0.00123400000 
+0.00123400000 
+0.01234000000 
+0.12340000000 
+1.23400000000 
 ij> -- =====================================================
 -- some formatting tests
 values cast ('1e+0' as DECIMAL(6,2));
-1        
----------
-1.00     
+1       
+--------
+1.00    
 ij> values cast ('+-1e+1' as DECIMAL(6,2));
-1        
----------
+1       
+--------
 ERROR 22018: Invalid character string format for type DECIMAL.
 ij> values cast ('-1e+1' as DECIMAL(6,2));
-1        
----------
--10.00   
+1       
+--------
+-10.00  
 ij> values cast ('-1e-1' as DECIMAL(6,2));
-1        
----------
--0.10    
+1       
+--------
+-0.10   
 ij> values cast ('-1e-+1' as DECIMAL(6,2));
-1        
----------
+1       
+--------
 ERROR 22018: Invalid character string format for type DECIMAL.
 ij> values cast ('-1e--1' as DECIMAL(6,2));
-1        
----------
+1       
+--------
 ERROR 22018: Invalid character string format for type DECIMAL.
 ij> values cast ('-1e+-1' as DECIMAL(6,2));
-1        
----------
+1       
+--------
 ERROR 22018: Invalid character string format for type DECIMAL.
 ij> values cast ('-1e+-1' as DECIMAL(6,2));
-1        
----------
+1       
+--------
 ERROR 22018: Invalid character string format for type DECIMAL.
 ij> values cast ('1.0e' as DECIMAL(6,2));
-1        
----------
+1       
+--------
 ERROR 22018: Invalid character string format for type DECIMAL.
 ij> values cast ('1.0e+' as DECIMAL(6,2));
-1        
----------
+1       
+--------
 ERROR 22018: Invalid character string format for type DECIMAL.
 ij> values cast ('1.0e-' as DECIMAL(6,2));
-1        
----------
+1       
+--------
 ERROR 22018: Invalid character string format for type DECIMAL.
 ij> values cast ('1.0ee' as DECIMAL(6,2));
-1        
----------
+1       
+--------
 ERROR 22018: Invalid character string format for type DECIMAL.
 ij> values cast ('123.' as DECIMAL(6,2));
-1        
----------
-123.00   
+1       
+--------
+123.00  
 ij> values cast ('1e' as DECIMAL(6,2));
-1        
----------
+1       
+--------
 ERROR 22018: Invalid character string format for type DECIMAL.
 ij> values cast ('1e1.0' as DECIMAL(6,2));
-1        
----------
+1       
+--------
 ERROR 22018: Invalid character string format for type DECIMAL.
 ij> values cast ('.3' as DECIMAL(6,2));
-1        
----------
-0.30     
+1       
+--------
+0.30    
 ij> values cast ('' as DECIMAL(6,2));
-1        
----------
+1       
+--------
 ERROR 22018: Invalid character string format for type DECIMAL.
 ij> 

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/functions.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/functions.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/functions.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/functions.out Fri Jul 14 09:04:03 2006
@@ -551,36 +551,36 @@
 0 rows inserted/updated/deleted
 ij> -- Test cases for DERBY-479
 VALUES CAST( RN_COS(RN_RADIANS(null)) AS DECIMAL(3,2));
-1     
-------
-NULL  
+1    
+-----
+NULL 
 ij> VALUES CAST( RN_COS(RN_RADIANS(90.0)) AS DECIMAL(3,2));
-1     
-------
-0.00  
+1    
+-----
+0.00 
 ij> VALUES CAST( CALL_COS(CALL_RADIANS(90.0)) AS DECIMAL(3,2));
-1     
-------
-0.00  
+1    
+-----
+0.00 
 ij> VALUES CAST( CALL_COS(CALL_RADIANS(null)) AS DECIMAL(3,2));
-1     
-------
+1    
+-----
 ERROR 39004: A NULL value cannot be passed to a method which takes a parameter of primitive type 'double'.
 ij> VALUES CAST( CALL_COS(RN_RADIANS(null)) AS DECIMAL(3,2));
-1     
-------
+1    
+-----
 ERROR 39004: A NULL value cannot be passed to a method which takes a parameter of primitive type 'double'.
 ij> VALUES CAST( CALL_COS(RN_RADIANS(90.0)) AS DECIMAL(3,2));
-1     
-------
-0.00  
+1    
+-----
+0.00 
 ij> VALUES CAST( RN_COS(CALL_RADIANS(90.0)) AS DECIMAL(3,2));
-1     
-------
-0.00  
+1    
+-----
+0.00 
 ij> VALUES CAST( RN_COS(CALL_RADIANS(null)) AS DECIMAL(3,2));
-1     
-------
+1    
+-----
 ERROR 39004: A NULL value cannot be passed to a method which takes a parameter of primitive type 'double'.
 ij> DROP FUNCTION RN_COS;
 0 rows inserted/updated/deleted
@@ -609,96 +609,96 @@
 ----------------------
 3.141592653589793     
 ij> select cast (ACOS(d) as DECIMAL(6,3)) AS ACOS FROM SYSFUN_MATH_TEST;
-ACOS     
----------
-NULL     
-0.836    
+ACOS    
+--------
+NULL    
+0.836   
 ERROR 22003: The resulting value is outside the range for the data type DOUBLE.
 ij> select cast (ASIN(d) as DECIMAL(6,3)) AS ASIN FROM SYSFUN_MATH_TEST;
-ASIN     
----------
-NULL     
-0.734    
+ASIN    
+--------
+NULL    
+0.734   
 ERROR 22003: The resulting value is outside the range for the data type DOUBLE.
 ij> select cast (ATAN(d) as DECIMAL(6,3)) AS ATAN FROM SYSFUN_MATH_TEST;
-ATAN     
----------
-NULL     
-0.590    
-0.929    
+ATAN    
+--------
+NULL    
+0.590   
+0.929   
 ij> select cast (COS(d) as DECIMAL(6,3)) AS COS FROM SYSFUN_MATH_TEST;
-COS      
----------
-NULL     
-0.783    
-0.228    
+COS     
+--------
+NULL    
+0.783   
+0.228   
 ij> select cast (SIN(d) as DECIMAL(6,3)) AS SIN FROM SYSFUN_MATH_TEST;
-SIN      
----------
-NULL     
-0.620    
-0.973    
+SIN     
+--------
+NULL    
+0.620   
+0.973   
 ij> select cast (TAN(d) as DECIMAL(6,3)) AS TAN FROM SYSFUN_MATH_TEST;
-TAN      
----------
-NULL     
-0.792    
-4.255    
+TAN     
+--------
+NULL    
+0.792   
+4.255   
 ij> select cast (DEGREES(d) as DECIMAL(6,3)) AS DEGREES FROM SYSFUN_MATH_TEST;
-DEGREES  
----------
-NULL     
-38.388   
-76.776   
+DEGREES 
+--------
+NULL    
+38.388  
+76.776  
 ij> select cast (RADIANS(d) as DECIMAL(6,3)) AS RADIANS FROM SYSFUN_MATH_TEST;
-RADIANS  
----------
-NULL     
-0.011    
-0.023    
+RADIANS 
+--------
+NULL    
+0.011   
+0.023   
 ij> select cast (LN(d) as DECIMAL(6,3)) AS LN,
        cast (LOG(d) as DECIMAL(6,3)) AS LOG
                        FROM SYSFUN_MATH_TEST;
-LN       |LOG      
--------------------
-NULL     |NULL     
--0.400   |-0.400   
-0.292    |0.292    
+LN      |LOG     
+-----------------
+NULL    |NULL    
+-0.400  |-0.400  
+0.292   |0.292   
 ij> select cast (EXP(d) as DECIMAL(6,3)) AS EXP FROM SYSFUN_MATH_TEST;
-EXP      
----------
-NULL     
-1.954    
-3.819    
+EXP     
+--------
+NULL    
+1.954   
+3.819   
 ij> select cast (LOG10(d) as DECIMAL(6,3)) AS LOG10 FROM SYSFUN_MATH_TEST;
-LOG10    
----------
-NULL     
--0.173   
-0.127    
+LOG10   
+--------
+NULL    
+-0.173  
+0.127   
 ij> select cast (CEIL(d) as DECIMAL(6,3)) AS CEIL FROM SYSFUN_MATH_TEST;
-CEIL     
----------
-NULL     
-1.000    
-2.000    
+CEIL    
+--------
+NULL    
+1.000   
+2.000   
 ij> select cast (CEILING(d) as DECIMAL(6,3)) AS CEILING FROM SYSFUN_MATH_TEST;
-CEILING  
----------
-NULL     
-1.000    
-2.000    
+CEILING 
+--------
+NULL    
+1.000   
+2.000   
 ij> select cast (FLOOR(d) as DECIMAL(6,3)) AS FLOOR FROM SYSFUN_MATH_TEST;
-FLOOR    
----------
-NULL     
-0.000    
-1.000    
+FLOOR   
+--------
+NULL    
+0.000   
+1.000   
 ij> select cast (SYSFUN.ACOS(d) as DECIMAL(6,3)) AS SYSFUN_ACOS FROM SYSFUN_MATH_TEST;
-SYSFUN_A&
----------
-NULL     
-0.836    
+SYSFUN_&
+--------
+NULL    
+0.836   
 ERROR 22003: The resulting value is outside the range for the data type DOUBLE.
 ij> drop table SYSFUN_MATH_TEST;
 0 rows inserted/updated/deleted

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ieptests.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ieptests.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ieptests.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ieptests.out Fri Jul 14 09:04:03 2006
@@ -49,32 +49,32 @@
                                       null, null, null, 0) ;
 0 rows inserted/updated/deleted
 ij> select * from ex_emp;
-ID         |NAME   |SKILLS                                                                                                                          |SALARY       
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-99         |smith  |tennis"p,l,ayer"                                                                                                                |190.55       
-100        |smith  |tennis"player"                                                                                                                  |190.55       
-101        |smith  |tennis"player                                                                                                                   |190.55       
-102        |smith  |"tennis"player                                                                                                                  |190.55       
-103        |smith  |"tennis"player"                                                                                                                 |190.55       
-104        |smith  |"tennis"""""""""""""""""""""""""""""""""""""player"                                                                             |NULL         
-105        |smith  |""                                                                                                                              |190.55       
-106        |smith  |"""""""""""""""""""                                                                                                             |190.55       
-107        |smith" |NULL                                                                                                                            |190.55       
-108        |NULL   |NULL                                                                                                                            |NULL         
+ID         |NAME   |SKILLS                                                                                                                          |SALARY      
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------
+99         |smith  |tennis"p,l,ayer"                                                                                                                |190.55      
+100        |smith  |tennis"player"                                                                                                                  |190.55      
+101        |smith  |tennis"player                                                                                                                   |190.55      
+102        |smith  |"tennis"player                                                                                                                  |190.55      
+103        |smith  |"tennis"player"                                                                                                                 |190.55      
+104        |smith  |"tennis"""""""""""""""""""""""""""""""""""""player"                                                                             |NULL        
+105        |smith  |""                                                                                                                              |190.55      
+106        |smith  |"""""""""""""""""""                                                                                                             |190.55      
+107        |smith" |NULL                                                                                                                            |190.55      
+108        |NULL   |NULL                                                                                                                            |NULL        
 ij> select * from imp_emp;
-ID         |NAME   |SKILLS                                                                                                                          |SALARY       
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-99         |smith  |tennis"p,l,ayer"                                                                                                                |190.55       
-99         |smith  |tennis"p,l,ayer"                                                                                                                |190.55       
-100        |smith  |tennis"player"                                                                                                                  |190.55       
-101        |smith  |tennis"player                                                                                                                   |190.55       
-102        |smith  |"tennis"player                                                                                                                  |190.55       
-103        |smith  |"tennis"player"                                                                                                                 |190.55       
-104        |smith  |"tennis"""""""""""""""""""""""""""""""""""""player"                                                                             |NULL         
-105        |smith  |""                                                                                                                              |190.55       
-106        |smith  |"""""""""""""""""""                                                                                                             |190.55       
-107        |smith" |NULL                                                                                                                            |190.55       
-108        |NULL   |NULL                                                                                                                            |NULL         
+ID         |NAME   |SKILLS                                                                                                                          |SALARY      
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------
+99         |smith  |tennis"p,l,ayer"                                                                                                                |190.55      
+99         |smith  |tennis"p,l,ayer"                                                                                                                |190.55      
+100        |smith  |tennis"player"                                                                                                                  |190.55      
+101        |smith  |tennis"player                                                                                                                   |190.55      
+102        |smith  |"tennis"player                                                                                                                  |190.55      
+103        |smith  |"tennis"player"                                                                                                                 |190.55      
+104        |smith  |"tennis"""""""""""""""""""""""""""""""""""""player"                                                                             |NULL        
+105        |smith  |""                                                                                                                              |190.55      
+106        |smith  |"""""""""""""""""""                                                                                                             |190.55      
+107        |smith" |NULL                                                                                                                            |190.55      
+108        |NULL   |NULL                                                                                                                            |NULL        
 ij> --checking query
 select count(*) from imp_emp, ex_emp
       where ex_emp.id = imp_emp.id and
@@ -149,18 +149,18 @@
                                     null, '''', null, 1) ;
 0 rows inserted/updated/deleted
 ij> select * from imp_emp ;
-ID         |NAME   |SKILLS                                                                                                                          |SALARY       
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-99         |smith  |tennis"p,l,ayer"                                                                                                                |190.55       
-100        |smith  |tennis"player"                                                                                                                  |190.55       
-101        |smith  |tennis"player                                                                                                                   |190.55       
-102        |smith  |"tennis"player                                                                                                                  |190.55       
-103        |smith  |"tennis"player"                                                                                                                 |190.55       
-104        |smith  |"tennis"""""""""""""""""""""""""""""""""""""player"                                                                             |NULL         
-105        |smith  |""                                                                                                                              |190.55       
-106        |smith  |"""""""""""""""""""                                                                                                             |190.55       
-107        |smith" |NULL                                                                                                                            |190.55       
-108        |NULL   |NULL                                                                                                                            |NULL         
+ID         |NAME   |SKILLS                                                                                                                          |SALARY      
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------
+99         |smith  |tennis"p,l,ayer"                                                                                                                |190.55      
+100        |smith  |tennis"player"                                                                                                                  |190.55      
+101        |smith  |tennis"player                                                                                                                   |190.55      
+102        |smith  |"tennis"player                                                                                                                  |190.55      
+103        |smith  |"tennis"player"                                                                                                                 |190.55      
+104        |smith  |"tennis"""""""""""""""""""""""""""""""""""""player"                                                                             |NULL        
+105        |smith  |""                                                                                                                              |190.55      
+106        |smith  |"""""""""""""""""""                                                                                                             |190.55      
+107        |smith" |NULL                                                                                                                            |190.55      
+108        |NULL   |NULL                                                                                                                            |NULL        
 ij> -- single quote(') as column delimiter
 call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'EX_EMP' , 'extinout/emp.dat' , 
                                     '''',null, null) ;
@@ -171,18 +171,18 @@
                                     '''', null, null, 0) ;
 0 rows inserted/updated/deleted
 ij> select * from imp_emp;
-ID         |NAME   |SKILLS                                                                                                                          |SALARY       
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-99         |smith  |tennis"p,l,ayer"                                                                                                                |190.55       
-100        |smith  |tennis"player"                                                                                                                  |190.55       
-101        |smith  |tennis"player                                                                                                                   |190.55       
-102        |smith  |"tennis"player                                                                                                                  |190.55       
-103        |smith  |"tennis"player"                                                                                                                 |190.55       
-104        |smith  |"tennis"""""""""""""""""""""""""""""""""""""player"                                                                             |NULL         
-105        |smith  |""                                                                                                                              |190.55       
-106        |smith  |"""""""""""""""""""                                                                                                             |190.55       
-107        |smith" |NULL                                                                                                                            |190.55       
-108        |NULL   |NULL                                                                                                                            |NULL         
+ID         |NAME   |SKILLS                                                                                                                          |SALARY      
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------
+99         |smith  |tennis"p,l,ayer"                                                                                                                |190.55      
+100        |smith  |tennis"player"                                                                                                                  |190.55      
+101        |smith  |tennis"player                                                                                                                   |190.55      
+102        |smith  |"tennis"player                                                                                                                  |190.55      
+103        |smith  |"tennis"player"                                                                                                                 |190.55      
+104        |smith  |"tennis"""""""""""""""""""""""""""""""""""""player"                                                                             |NULL        
+105        |smith  |""                                                                                                                              |190.55      
+106        |smith  |"""""""""""""""""""                                                                                                             |190.55      
+107        |smith" |NULL                                                                                                                            |190.55      
+108        |NULL   |NULL                                                                                                                            |NULL        
 ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'EX_EMP' , 'extinout/emp.dat' , 
                                  '*', '%', null) ;
 0 rows inserted/updated/deleted
@@ -190,18 +190,18 @@
                                  '*', '%', null, 1) ;
 0 rows inserted/updated/deleted
 ij> select * from imp_emp ;
-ID         |NAME   |SKILLS                                                                                                                          |SALARY       
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-99         |smith  |tennis"p,l,ayer"                                                                                                                |190.55       
-100        |smith  |tennis"player"                                                                                                                  |190.55       
-101        |smith  |tennis"player                                                                                                                   |190.55       
-102        |smith  |"tennis"player                                                                                                                  |190.55       
-103        |smith  |"tennis"player"                                                                                                                 |190.55       
-104        |smith  |"tennis"""""""""""""""""""""""""""""""""""""player"                                                                             |NULL         
-105        |smith  |""                                                                                                                              |190.55       
-106        |smith  |"""""""""""""""""""                                                                                                             |190.55       
-107        |smith" |NULL                                                                                                                            |190.55       
-108        |NULL   |NULL                                                                                                                            |NULL         
+ID         |NAME   |SKILLS                                                                                                                          |SALARY      
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------
+99         |smith  |tennis"p,l,ayer"                                                                                                                |190.55      
+100        |smith  |tennis"player"                                                                                                                  |190.55      
+101        |smith  |tennis"player                                                                                                                   |190.55      
+102        |smith  |"tennis"player                                                                                                                  |190.55      
+103        |smith  |"tennis"player"                                                                                                                 |190.55      
+104        |smith  |"tennis"""""""""""""""""""""""""""""""""""""player"                                                                             |NULL        
+105        |smith  |""                                                                                                                              |190.55      
+106        |smith  |"""""""""""""""""""                                                                                                             |190.55      
+107        |smith" |NULL                                                                                                                            |190.55      
+108        |NULL   |NULL                                                                                                                            |NULL        
 ij> --cases for identity columns
 --create table emp1(id int generated always as identity (start with 100), name char(7), 
 --              skills varchar(200), salary decimal(10,2),skills varchar(200));
@@ -540,14 +540,14 @@
                                  null, null, null, 0) ;
 0 rows inserted/updated/deleted
 ij> select * from alltypes ;
-CHARTYPE            |BIGINTTYPE          |DATETYPE  |DECIMALTYPE  |DOUBLETYPE            |INTTYPE    |LVARTYPE                                                                                                                        |REALTYPE     |SMINT&|TIMETYPE|TSTAMPTYPE                |VARTYPE                                           
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-chartype string     |9223372036854775807 |1993-10-29|12345.54321  |1.0E308               |2147483647 |long varchar testing                                                                                                            |10000.0      |32767 |09:39:43|xxxxxxFILTERED-TIMESTAMPxxxxx|varchar testing                                   
-chartype string     |-9223372036854775808|1993-10-29|0.00000      |-1.0E308              |-2147483647|long varchar testing                                                                                                            |-10000.0     |32767 |09:39:43|xxxxxxFILTERED-TIMESTAMPxxxxx|varchar testing                                   
-"chartype" string   |9223372036854775807 |1993-10-29|-12345.54321 |1.0E308               |2147483647 |long "varchar" testing                                                                                                          |10000.0      |32767 |09:39:43|xxxxxxFILTERED-TIMESTAMPxxxxx|"varchar" testing                                 
-chartype string     |9223372036854775807 |1993-10-29|12345.54321  |1.0E308               |2147483647 |long varchar testing                                                                                                            |10000.0      |32767 |09:39:43|xxxxxxFILTERED-TIMESTAMPxxxxx|varchar testing                                   
-chartype string     |-9223372036854775808|1993-10-29|0.00000      |-1.0E308              |-2147483647|long varchar testing                                                                                                            |-10000.0     |32767 |09:39:43|xxxxxxFILTERED-TIMESTAMPxxxxx|varchar testing                                   
-"chartype" string   |9223372036854775807 |1993-10-29|-12345.54321 |1.0E308               |2147483647 |long "varchar" testing                                                                                                          |10000.0      |32767 |09:39:43|xxxxxxFILTERED-TIMESTAMPxxxxx|"varchar" testing                                 
+CHARTYPE            |BIGINTTYPE          |DATETYPE  |DECIMALTYPE |DOUBLETYPE            |INTTYPE    |LVARTYPE                                                                                                                        |REALTYPE     |SMINT&|TIMETYPE|TSTAMPTYPE                |VARTYPE                                           
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+chartype string     |9223372036854775807 |1993-10-29|12345.54321 |1.0E308               |2147483647 |long varchar testing                                                                                                            |10000.0      |32767 |09:39:43|xxxxxxFILTERED-TIMESTAMPxxxxx|varchar testing                                   
+chartype string     |-9223372036854775808|1993-10-29|0.00000     |-1.0E308              |-2147483647|long varchar testing                                                                                                            |-10000.0     |32767 |09:39:43|xxxxxxFILTERED-TIMESTAMPxxxxx|varchar testing                                   
+"chartype" string   |9223372036854775807 |1993-10-29|-12345.54321|1.0E308               |2147483647 |long "varchar" testing                                                                                                          |10000.0      |32767 |09:39:43|xxxxxxFILTERED-TIMESTAMPxxxxx|"varchar" testing                                 
+chartype string     |9223372036854775807 |1993-10-29|12345.54321 |1.0E308               |2147483647 |long varchar testing                                                                                                            |10000.0      |32767 |09:39:43|xxxxxxFILTERED-TIMESTAMPxxxxx|varchar testing                                   
+chartype string     |-9223372036854775808|1993-10-29|0.00000     |-1.0E308              |-2147483647|long varchar testing                                                                                                            |-10000.0     |32767 |09:39:43|xxxxxxFILTERED-TIMESTAMPxxxxx|varchar testing                                   
+"chartype" string   |9223372036854775807 |1993-10-29|-12345.54321|1.0E308               |2147483647 |long "varchar" testing                                                                                                          |10000.0      |32767 |09:39:43|xxxxxxFILTERED-TIMESTAMPxxxxx|"varchar" testing                                 
 ij> delete from alltypes;
 6 rows inserted/updated/deleted
 ij> --import should work with trigger enabled on append and should not work on replace

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/implicitConversions.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/implicitConversions.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/implicitConversions.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/implicitConversions.out Fri Jul 14 09:04:03 2006
@@ -2205,8 +2205,8 @@
 LI                  |C_LI                          |R            |C_R                                               |DP                    |C_DP                                              
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ij> select dc, c_dc, num, c_num, c_bool from all1, all_c1;
-DC      |C_DC      |NUM     |C_NUM                                             |C_BO&
--------------------------------------------------------------------------------------
+DC     |C_DC      |NUM    |C_NUM                                             |C_BO&
+-----------------------------------------------------------------------------------
 ij> select b, c_b, bv, vc_bv, lbv, vc_lbv, dt, c_dt from all1, all_c1;
 B   |C_B     |BV  |VC_BV           |LBV                                                                                                                             |VC_LBV          |DT        |C_DT      
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -2228,8 +2228,8 @@
 LI                  |C_LI                          |R            |C_R                                               |DP                    |C_DP                                              
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ij> select dc, c_dc, num, c_num, c_bool from all1, all_c1;
-DC      |C_DC      |NUM     |C_NUM                                             |C_BO&
--------------------------------------------------------------------------------------
+DC     |C_DC      |NUM    |C_NUM                                             |C_BO&
+-----------------------------------------------------------------------------------
 ij> select b, c_b, bv, vc_bv, lbv, vc_lbv, dt, c_dt from all1, all_c1;
 B   |C_B     |BV  |VC_BV           |LBV                                                                                                                             |VC_LBV          |DT        |C_DT      
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -2247,8 +2247,8 @@
 insert into t5_2 values ('11.95', '95.11');
 ERROR 42821: Columns of type 'DECIMAL' cannot hold values of type 'CHAR'. 
 ij> select * from t5_2;
-DC      |NUM     
------------------
+DC     |NUM    
+---------------
 ij> rollback;
 ij> -- update tests
 alter table all1 add column c30 char(30) ;
@@ -2258,9 +2258,9 @@
 ij> alter table all1 add column lvc2 long varchar ;
 0 rows inserted/updated/deleted
 ij> select * from all1;
-SI    |I          |LI                  |R            |DP                    |DC      |NUM     |B   |BV  |LBV                                                                                                                             |DT        |TM      |TMS                       |C   |VC  |LVC                                                                                                                             |C30                           |VC30                          |LVC2                                                                                                                            
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-2     |3          |4                   |5.5          |6.6                   |7.7     |8.8     |0020|0020|0020                                                                                                                            |1996-09-09|12:12:12|xxxxxxFILTERED-TIMESTAMPxxxxx|1   |2   |33333333                                                                                                                        |NULL                          |NULL                          |NULL                                                                                                                            
+SI    |I          |LI                  |R            |DP                    |DC     |NUM    |B   |BV  |LBV                                                                                                                             |DT        |TM      |TMS                       |C   |VC  |LVC                                                                                                                             |C30                           |VC30                          |LVC2                                                                                                                            
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+2     |3          |4                   |5.5          |6.6                   |7.7    |8.8    |0020|0020|0020                                                                                                                            |1996-09-09|12:12:12|xxxxxxFILTERED-TIMESTAMPxxxxx|1   |2   |33333333                                                                                                                        |NULL                          |NULL                          |NULL                                                                                                                            
 ij> update all1 set si = '11';
 ERROR 42821: Columns of type 'SMALLINT' cannot hold values of type 'CHAR'. 
 ij> update all1 set i = '11';
@@ -2290,9 +2290,9 @@
 ij> update all1 set lvc = '44444444';
 1 row inserted/updated/deleted
 ij> select * from all1;
-SI    |I          |LI                  |R            |DP                    |DC      |NUM     |B   |BV  |LBV                                                                                                                             |DT        |TM      |TMS                       |C   |VC  |LVC                                                                                                                             |C30                           |VC30                          |LVC2                                                                                                                            
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-2     |3          |4                   |5.5          |6.6                   |7.7     |8.8     |2120|21  |21                                                                                                                              |1900-01-01|08:08:08|xxxxxxFILTERED-TIMESTAMPxxxxx|1   |2   |44444444                                                                                                                        |NULL                          |NULL                          |NULL                                                                                                                            
+SI    |I          |LI                  |R            |DP                    |DC     |NUM    |B   |BV  |LBV                                                                                                                             |DT        |TM      |TMS                       |C   |VC  |LVC                                                                                                                             |C30                           |VC30                          |LVC2                                                                                                                            
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+2     |3          |4                   |5.5          |6.6                   |7.7    |8.8    |2120|21  |21                                                                                                                              |1900-01-01|08:08:08|xxxxxxFILTERED-TIMESTAMPxxxxx|1   |2   |44444444                                                                                                                        |NULL                          |NULL                          |NULL                                                                                                                            
 ij> select c30, vc30, lvc2 from all1;
 C30                           |VC30                          |LVC2                                                                                                                            
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -3860,26 +3860,26 @@
 ERROR 42818: Comparisons between 'SMALLINT' and 'LONG VARCHAR' are not supported.
 ij> select * from all1 a, all1 b 
 where a.dt = b.c;
-SI    |I          |LI                  |R            |DP                    |DC      |NUM     |B   |BV  |LBV                                                                                                                             |DT        |TM      |TMS                       |C   |VC  |LVC                                                                                                                             |SI    |I          |LI                  |R            |DP                    |DC      |NUM     |B   |BV  |LBV                                                                                                                             |DT        |TM      |TMS                       |C   |VC  |LVC                                                                                                                             
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+SI    |I          |LI                  |R            |DP                    |DC     |NUM    |B   |BV  |LBV                                                                                                                             |DT        |TM      |TMS                       |C   |VC  |LVC                                                                                                                             |SI    |I          |LI                  |R            |DP                    |DC     |NUM    |B   |BV  |LBV                                                                                                                             |DT        |TM      |TMS                       |C   |VC  |LVC                                                                                                                             
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ERROR 22007: The syntax of the string representation of a datetime value is incorrect.
 ij> select * from all1 a, all1 b 
 where a.dt = b.vc;
-SI    |I          |LI                  |R            |DP                    |DC      |NUM     |B   |BV  |LBV                                                                                                                             |DT        |TM      |TMS                       |C   |VC  |LVC                                                                                                                             |SI    |I          |LI                  |R            |DP                    |DC      |NUM     |B   |BV  |LBV                                                                                                                             |DT        |TM      |TMS                       |C   |VC  |LVC                                                                                                                             
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+SI    |I          |LI                  |R            |DP                    |DC     |NUM    |B   |BV  |LBV                                                                                                                             |DT        |TM      |TMS                       |C   |VC  |LVC                                                                                                                             |SI    |I          |LI                  |R            |DP                    |DC     |NUM    |B   |BV  |LBV                                                                                                                             |DT        |TM      |TMS                       |C   |VC  |LVC                                                                                                                             
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ERROR 22007: The syntax of the string representation of a datetime value is incorrect.
 ij> select * from all1 a, all1 b 
 where a.dt = b.lvc;
 ERROR 42818: Comparisons between 'DATE' and 'LONG VARCHAR' are not supported.
 ij> select * from all1 a, all1 b 
 where b.dt = a.c;
-SI    |I          |LI                  |R            |DP                    |DC      |NUM     |B   |BV  |LBV                                                                                                                             |DT        |TM      |TMS                       |C   |VC  |LVC                                                                                                                             |SI    |I          |LI                  |R            |DP                    |DC      |NUM     |B   |BV  |LBV                                                                                                                             |DT        |TM      |TMS                       |C   |VC  |LVC                                                                                                                             
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+SI    |I          |LI                  |R            |DP                    |DC     |NUM    |B   |BV  |LBV                                                                                                                             |DT        |TM      |TMS                       |C   |VC  |LVC                                                                                                                             |SI    |I          |LI                  |R            |DP                    |DC     |NUM    |B   |BV  |LBV                                                                                                                             |DT        |TM      |TMS                       |C   |VC  |LVC                                                                                                                             
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ERROR 22007: The syntax of the string representation of a datetime value is incorrect.
 ij> select * from all1 a, all1 b 
 where b.dt = a.vc;
-SI    |I          |LI                  |R            |DP                    |DC      |NUM     |B   |BV  |LBV                                                                                                                             |DT        |TM      |TMS                       |C   |VC  |LVC                                                                                                                             |SI    |I          |LI                  |R            |DP                    |DC      |NUM     |B   |BV  |LBV                                                                                                                             |DT        |TM      |TMS                       |C   |VC  |LVC                                                                                                                             
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+SI    |I          |LI                  |R            |DP                    |DC     |NUM    |B   |BV  |LBV                                                                                                                             |DT        |TM      |TMS                       |C   |VC  |LVC                                                                                                                             |SI    |I          |LI                  |R            |DP                    |DC     |NUM    |B   |BV  |LBV                                                                                                                             |DT        |TM      |TMS                       |C   |VC  |LVC                                                                                                                             
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ERROR 22007: The syntax of the string representation of a datetime value is incorrect.
 ij> select * from all1 a, all1 b 
 where b.dt = a.lvc;



Mime
View raw message