db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rhille...@apache.org
Subject svn commit: r1042675 [1/2] - in /db/derby/code/trunk/java: client/org/apache/derby/client/am/ engine/org/apache/derby/iapi/reference/ engine/org/apache/derby/iapi/types/ engine/org/apache/derby/impl/jdbc/ testing/org/apache/derbyTesting/functionTests/m...
Date Mon, 06 Dec 2010 15:23:33 GMT
Author: rhillegas
Date: Mon Dec  6 15:23:32 2010
New Revision: 1042675

URL: http://svn.apache.org/viewvc?rev=1042675&view=rev
Log:
DERBY-4614: Checkin a warmed-up version of Nirmal's patch, which corrects the JDBC metadata for timestamps.

Modified:
    db/derby/code/trunk/java/client/org/apache/derby/client/am/ColumnMetaData.java
    db/derby/code/trunk/java/engine/org/apache/derby/iapi/reference/DRDAConstants.java
    db/derby/code/trunk/java/engine/org/apache/derby/iapi/types/DataTypeUtilities.java
    db/derby/code/trunk/java/engine/org/apache/derby/iapi/types/TypeId.java
    db/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/metadata.properties
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/aggbuiltin.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/compressTable.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/insert.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/nonreserved.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/specjPlans.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/triggerRefClause.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/DatabaseMetaDataTest.java
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/ParameterMetaDataJdbc30Test.java
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/PrepStmtMetaDataTest.java
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/ResultSetMiscTest.java
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/CoalesceTest.java
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/TableFunctionTest.java

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=1042675&r1=1042674&r2=1042675&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 Mon Dec  6 15:23:32 2010
@@ -318,7 +318,7 @@ public class ColumnMetaData implements j
             case Types.TIME:
                 return 8;
             case Types.TIMESTAMP:
-                return 26;
+                return 29;
             case Types.JAVA_OBJECT:
                 return JDBC30Translation.DEFAULT_COLUMN_DISPLAY_SIZE;
             case Types.BINARY:
@@ -452,7 +452,7 @@ public class ColumnMetaData implements j
             case Types.TIME:
                 return 8;
             case Types.TIMESTAMP:
-                return 26;
+                return 29;
             case Types.JAVA_OBJECT:
                 return JDBC30Translation.UNKNOWN_PRECISION;
             default:
@@ -472,15 +472,6 @@ public class ColumnMetaData implements j
             checkForClosedStatement();
             checkForValidColumnIndex(column);
 
-            // We get the scale from the SQLDA as returned by DERBY, but DERBY does not return the ANSI-defined
-            // value of scale 6 for TIMESTAMP.
-            //
-            //   The JDBC drivers should hardcode this info as a short/near term solution.
-            //
-            if (types_[column - 1] == Types.TIMESTAMP) {
-                return 6;
-            }
-
             return sqlScale_[column - 1];
         }
         catch ( SqlException e )

Modified: db/derby/code/trunk/java/engine/org/apache/derby/iapi/reference/DRDAConstants.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/engine/org/apache/derby/iapi/reference/DRDAConstants.java?rev=1042675&r1=1042674&r2=1042675&view=diff
==============================================================================
--- db/derby/code/trunk/java/engine/org/apache/derby/iapi/reference/DRDAConstants.java (original)
+++ db/derby/code/trunk/java/engine/org/apache/derby/iapi/reference/DRDAConstants.java Mon Dec  6 15:23:32 2010
@@ -228,7 +228,7 @@ public	interface	DRDAConstants
     // nanoseconds precision: yyyy-mm-dd-hh.mm.ss.ffffff
     // In contrast, JDBC supports full nanoseconds precision: yyyy-mm-dd-hh.mm.ss.fffffffff
     //
-    public   static final int DRDA_TIMESTAMP_LENGTH = 26;
+    public   static final int DRDA_TIMESTAMP_LENGTH = 29;
     public   static final int JDBC_TIMESTAMP_LENGTH = 29;
 
     // Values for the EXTDTA stream status byte.

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=1042675&r1=1042674&r2=1042675&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 Mon Dec  6 15:23:32 2010
@@ -156,7 +156,7 @@ public abstract class DataTypeUtilities 
 		switch (typeId)
 		{
 			case Types.TIMESTAMP:
-				size = 26;
+				size = 29;
 				break;
 			case Types.DATE:
 				size = 10;

Modified: db/derby/code/trunk/java/engine/org/apache/derby/iapi/types/TypeId.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/engine/org/apache/derby/iapi/types/TypeId.java?rev=1042675&r1=1042674&r2=1042675&view=diff
==============================================================================
--- db/derby/code/trunk/java/engine/org/apache/derby/iapi/types/TypeId.java (original)
+++ db/derby/code/trunk/java/engine/org/apache/derby/iapi/types/TypeId.java Mon Dec  6 15:23:32 2010
@@ -119,16 +119,16 @@ public final class TypeId
         public static final int DATE_MAXWIDTH           = 10;	// yyyy-mm-dd
         public static final int TIME_MAXWIDTH           = 8;	// hh:mm:ss
 
-        // I believe that the following is wrong. The format of java.sql.Timestamp.toString()
+        // The format of java.sql.Timestamp.toString()
         // is yyyy-mm-dd hh:mm:ss.fffffffff
-        public static final int TIMESTAMP_MAXWIDTH      = DRDAConstants.DRDA_TIMESTAMP_LENGTH;	// yyyy-mm-dd hh:mm:ss.ffffff
+        public static final int TIMESTAMP_MAXWIDTH      = DRDAConstants.DRDA_TIMESTAMP_LENGTH;	// yyyy-mm-dd hh:mm:ss.fffffffff
 
         // Scale DOES exist for time values.  For a TIMESTAMP value,
-        // it's 6 ('ffffff'); for a TIME value, it's 0 (because there
+        // it's 9 ('fffffffff'); for a TIME value, it's 0 (because there
         // are no fractional seconds).  Note that date values do
         // not have a scale.
         public static final int TIME_SCALE           = 0;
-        public static final int TIMESTAMP_SCALE      = 6;
+        public static final int TIMESTAMP_SCALE      = 9;
 
         /* These define all the type names for SQL92 and JDBC 
          * NOTE: boolean is SQL3

Modified: db/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/metadata.properties
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/metadata.properties?rev=1042675&r1=1042674&r2=1042675&view=diff
==============================================================================
--- db/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/metadata.properties (original)
+++ db/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/metadata.properties Mon Dec  6 15:23:32 2010
@@ -800,8 +800,8 @@ getTypeInfo=\
 			1,FALSE,2,TRUE,FALSE,FALSE,0,0,10),\
 		('TIME',92,8,'TIME''','''',CAST (NULL AS CHAR), \
 			1,FALSE,2,TRUE,FALSE,FALSE,0,0,10),\
-		('TIMESTAMP',93,26,'TIMESTAMP''','''',CAST (NULL AS CHAR), \
-			1,FALSE,2,TRUE,FALSE,FALSE,0,6,10),\
+		('TIMESTAMP',93,29,'TIMESTAMP''','''',CAST (NULL AS CHAR), \
+			1,FALSE,2,TRUE,FALSE,FALSE,0,9,10),\
 		('OBJECT',2000,CAST (NULL AS INTEGER),CAST (NULL AS CHAR),CAST (NULL AS CHAR),CAST (NULL AS CHAR), \
 			1,FALSE,2,TRUE,FALSE,FALSE,CAST (NULL AS INTEGER),CAST (NULL AS INTEGER),CAST (NULL AS INTEGER)),\
 		('BLOB',2004,2147483647,CAST (NULL AS CHAR),CAST (NULL AS CHAR),'length', \

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=1042675&r1=1042674&r2=1042675&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 Mon Dec  6 15:23:32 2010
@@ -1899,9 +1899,9 @@ ij> select max(t) from empty;
 --------
 NULL    
 ij> select max(ts) from empty;
-1                         
---------------------------
-NULL                      
+1                            
+-----------------------------
+NULL                         
 ij> select max(b) from empty;
 1   
 ----
@@ -1952,8 +1952,8 @@ ij> select max(t) from empty group by t;
 1       
 --------
 ij> select max(ts) from empty group by ts;
-1                         
---------------------------
+1                            
+-----------------------------
 ij> select max(b) from empty group by b;
 1   
 ----
@@ -2012,9 +2012,9 @@ ij> select max(t) from t;
 12:55:55
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select max(ts) from t;
-1                         
---------------------------
-1992-01-01 12:55:55.0     
+1                            
+-----------------------------
+1992-01-01 12:55:55.0        
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select max(b) from t;
 1   
@@ -2095,11 +2095,11 @@ ij> select max(t) from t group by t;
 NULL    
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select max(ts) from t group by ts;
-1                         
---------------------------
-1992-01-01 12:30:30.0     
-1992-01-01 12:55:55.0     
-NULL                      
+1                            
+-----------------------------
+1992-01-01 12:30:30.0        
+1992-01-01 12:55:55.0        
+NULL                         
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select max(b) from t group by b;
 1   
@@ -2152,9 +2152,9 @@ ij> select max(time('12:30:30')) from t;
 --------
 12:30:30
 ij> select max(timestamp('1999-06-06 12:30:30')) from t;
-1                         
---------------------------
-1999-06-06 12:30:30.0     
+1                            
+-----------------------------
+1999-06-06 12:30:30.0        
 ij> select max(1) from t group by i;
 1          
 -----------
@@ -2198,11 +2198,11 @@ ij> select max(time('12:30:30')) from t 
 12:30:30
 12:30:30
 ij> select max(timestamp('1999-06-06 12:30:30')) from t group by ts;
-1                         
---------------------------
-1999-06-06 12:30:30.0     
-1999-06-06 12:30:30.0     
-1999-06-06 12:30:30.0     
+1                            
+-----------------------------
+1999-06-06 12:30:30.0        
+1999-06-06 12:30:30.0        
+1999-06-06 12:30:30.0        
 ij> -- multicolumn grouping
 select max(i), max(dt), max(b) from t group by i, dt, b;
 1          |2         |3   
@@ -2430,9 +2430,9 @@ ij> select min(t) from empty;
 --------
 NULL    
 ij> select min(ts) from empty;
-1                         
---------------------------
-NULL                      
+1                            
+-----------------------------
+NULL                         
 ij> select min(b) from empty;
 1   
 ----
@@ -2483,8 +2483,8 @@ ij> select min(t) from empty group by t;
 1       
 --------
 ij> select min(ts) from empty group by ts;
-1                         
---------------------------
+1                            
+-----------------------------
 ij> select min(b) from empty group by b;
 1   
 ----
@@ -2543,9 +2543,9 @@ ij> select min(t) from t;
 12:30:30
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select min(ts) from t;
-1                         
---------------------------
-1992-01-01 12:30:30.0     
+1                            
+-----------------------------
+1992-01-01 12:30:30.0        
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select min(b) from t;
 1   
@@ -2626,11 +2626,11 @@ ij> select min(t) from t group by t;
 NULL    
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select min(ts) from t group by ts;
-1                         
---------------------------
-1992-01-01 12:30:30.0     
-1992-01-01 12:55:55.0     
-NULL                      
+1                            
+-----------------------------
+1992-01-01 12:30:30.0        
+1992-01-01 12:55:55.0        
+NULL                         
 WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> select min(b) from t group by b;
 1   
@@ -2683,9 +2683,9 @@ ij> select min(time('12:30:30')) from t;
 --------
 12:30:30
 ij> select min(timestamp('1999-06-06 12:30:30')) from t;
-1                         
---------------------------
-1999-06-06 12:30:30.0     
+1                            
+-----------------------------
+1999-06-06 12:30:30.0        
 ij> select min(1) from t group by i;
 1          
 -----------
@@ -2729,11 +2729,11 @@ ij> select min(time('12:30:30')) from t 
 12:30:30
 12:30:30
 ij> select min(timestamp('1999-06-06 12:30:30')) from t group by ts;
-1                         
---------------------------
-1999-06-06 12:30:30.0     
-1999-06-06 12:30:30.0     
-1999-06-06 12:30:30.0     
+1                            
+-----------------------------
+1999-06-06 12:30:30.0        
+1999-06-06 12:30:30.0        
+1999-06-06 12:30:30.0        
 ij> -- multicolumn grouping
 select min(i), min(dt), min(b) from t group by i, dt, b;
 1          |2         |3   

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=1042675&r1=1042674&r2=1042675&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 Mon Dec  6 15:23:32 2010
@@ -636,9 +636,9 @@ ij> values (cast ('1999-09-09' as date))
 ij> values (cast ('TIMESTAMP''1999-09-09 11:11:11''' as timestamp));
 ERROR 22007: The syntax of the string representation of a datetime value is incorrect.
 ij> values (cast ('1999-09-09 11:11:11' as timestamp));
-1                         
---------------------------
-1999-09-09 11:11:11.0     
+1                            
+-----------------------------
+1999-09-09 11:11:11.0        
 ij> ------------------
 --date/time ->other
 ------------------
@@ -710,9 +710,9 @@ ij> values (cast (TIMESTAMP('1999-09-09 
 --------
 11:11:11
 ij> values (cast (TIMESTAMP('1999-09-09 11:11:11' )as timestamp));
-1                         
---------------------------
-1999-09-09 11:11:11.0     
+1                            
+-----------------------------
+1999-09-09 11:11:11.0        
 ij> --bad
 values (cast (TIMESTAMP('1999-09-09 11:11:11' )as int));
 ERROR 42846: Cannot convert types 'TIMESTAMP' to 'INTEGER'.
@@ -863,10 +863,10 @@ ij> select cast(t as time) from tab1;
 11:11:11
 NULL    
 ij> select cast(ts as timestamp) from tab1;
-1                         
---------------------------
-1990-11-11 11:11:11.0     
-NULL                      
+1                            
+-----------------------------
+1990-11-11 11:11:11.0        
+NULL                         
 ij> select cast(dc as dec) from tab1;
 1     
 ------
@@ -952,8 +952,8 @@ ij> select cast(c as time) from tab1;
 --------
 ERROR 22007: The syntax of the string representation of a datetime value is incorrect.
 ij> select cast(c as timestamp) from tab1;
-1                         
---------------------------
+1                            
+-----------------------------
 ERROR 22007: The syntax of the string representation of a datetime value is incorrect.
 ij> select cast(c as dec) from tab1;
 1     
@@ -1055,22 +1055,22 @@ ij> insert into t1 (lvc) values cast(nul
 1 row inserted/updated/deleted
 ij> -- expect 10 rows of nulls
 select * from t1;
-BT  |BTV |C                             |D                     |I          |R            |S     |DC                 |NUM                |DT        |T       |TS                        |V                             |LVC                                                                                                                             
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                      |NULL                          |NULL                                                                                                                            
-NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                      |NULL                          |NULL                                                                                                                            
-NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                      |NULL                          |NULL                                                                                                                            
-NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                      |NULL                          |NULL                                                                                                                            
-NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                      |NULL                          |NULL                                                                                                                            
-NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                      |NULL                          |NULL                                                                                                                            
-NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                      |NULL                          |NULL                                                                                                                            
-NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                      |NULL                          |NULL                                                                                                                            
-NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                      |NULL                          |NULL                                                                                                                            
-NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                      |NULL                          |NULL                                                                                                                            
-NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                      |NULL                          |NULL                                                                                                                            
-NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                      |NULL                          |NULL                                                                                                                            
-NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                      |NULL                          |NULL                                                                                                                            
-NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                      |NULL                          |NULL                                                                                                                            
+BT  |BTV |C                             |D                     |I          |R            |S     |DC                 |NUM                |DT        |T       |TS                           |V                             |LVC                                                                                                                             
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                         |NULL                          |NULL                                                                                                                            
+NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                         |NULL                          |NULL                                                                                                                            
+NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                         |NULL                          |NULL                                                                                                                            
+NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                         |NULL                          |NULL                                                                                                                            
+NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                         |NULL                          |NULL                                                                                                                            
+NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                         |NULL                          |NULL                                                                                                                            
+NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                         |NULL                          |NULL                                                                                                                            
+NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                         |NULL                          |NULL                                                                                                                            
+NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                         |NULL                          |NULL                                                                                                                            
+NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                         |NULL                          |NULL                                                                                                                            
+NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                         |NULL                          |NULL                                                                                                                            
+NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                         |NULL                          |NULL                                                                                                                            
+NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                         |NULL                          |NULL                                                                                                                            
+NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                         |NULL                          |NULL                                                                                                                            
 ij> -- make sure casting works correctly on nulls
 select cast (bt as char(1) for bit data) from t1;
 1   
@@ -1243,22 +1243,22 @@ NULL    
 NULL    
 NULL    
 ij> select cast (ts as timestamp) from t1;
-1                         
---------------------------
-NULL                      
-NULL                      
-NULL                      
-NULL                      
-NULL                      
-NULL                      
-NULL                      
-NULL                      
-NULL                      
-NULL                      
-NULL                      
-NULL                      
-NULL                      
-NULL                      
+1                            
+-----------------------------
+NULL                         
+NULL                         
+NULL                         
+NULL                         
+NULL                         
+NULL                         
+NULL                         
+NULL                         
+NULL                         
+NULL                         
+NULL                         
+NULL                         
+NULL                         
+NULL                         
 ij> select cast (v as varchar(30)) from t1;
 1                             
 ------------------------------
@@ -1341,21 +1341,21 @@ ij> execute q15 using 'values char(65432
 ij> execute q16 using 'values char(987654)';
 1 row inserted/updated/deleted
 ij> select * from t1;
-BT  |BTV |C                             |D                     |I          |R            |S     |DC                 |NUM                |DT        |T       |TS                        |V                             |LVC                                                                                                                             
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-aa  |NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                      |NULL                          |NULL                                                                                                                            
-NULL|aa  |NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                      |NULL                          |NULL                                                                                                                            
-NULL|NULL|123456                        |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                      |NULL                          |NULL                                                                                                                            
-NULL|NULL|NULL                          |123456.78             |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                      |NULL                          |NULL                                                                                                                            
-NULL|NULL|NULL                          |NULL                  |4321       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                      |NULL                          |NULL                                                                                                                            
-NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |12321 |NULL               |NULL               |NULL      |NULL    |NULL                      |NULL                          |NULL                                                                                                                            
-NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |123456             |NULL      |NULL    |NULL                      |NULL                          |NULL                                                                                                                            
-NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |123456             |NULL               |NULL      |NULL    |NULL                      |NULL                          |NULL                                                                                                                            
-NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |9876-05-04|NULL    |NULL                      |NULL                          |NULL                                                                                                                            
-NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |01:02:34|NULL                      |NULL                          |NULL                                                                                                                            
-NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |9876-05-04 01:02:34.0     |NULL                          |NULL                                                                                                                            
-NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                      |654321                        |NULL                                                                                                                            
-NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                      |NULL                          |987654                                                                                                                          
+BT  |BTV |C                             |D                     |I          |R            |S     |DC                 |NUM                |DT        |T       |TS                           |V                             |LVC                                                                                                                             
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+aa  |NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                         |NULL                          |NULL                                                                                                                            
+NULL|aa  |NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                         |NULL                          |NULL                                                                                                                            
+NULL|NULL|123456                        |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                         |NULL                          |NULL                                                                                                                            
+NULL|NULL|NULL                          |123456.78             |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                         |NULL                          |NULL                                                                                                                            
+NULL|NULL|NULL                          |NULL                  |4321       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                         |NULL                          |NULL                                                                                                                            
+NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |12321 |NULL               |NULL               |NULL      |NULL    |NULL                         |NULL                          |NULL                                                                                                                            
+NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |123456             |NULL      |NULL    |NULL                         |NULL                          |NULL                                                                                                                            
+NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |123456             |NULL               |NULL      |NULL    |NULL                         |NULL                          |NULL                                                                                                                            
+NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |9876-05-04|NULL    |NULL                         |NULL                          |NULL                                                                                                                            
+NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |01:02:34|NULL                         |NULL                          |NULL                                                                                                                            
+NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |9876-05-04 01:02:34.0        |NULL                          |NULL                                                                                                                            
+NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                         |654321                        |NULL                                                                                                                            
+NULL|NULL|NULL                          |NULL                  |NULL       |NULL         |NULL  |NULL               |NULL               |NULL      |NULL    |NULL                         |NULL                          |987654                                                                                                                          
 ij> -- clean up t1
 delete from t1;
 13 rows inserted/updated/deleted
@@ -1497,9 +1497,9 @@ values (cast ('08.08.08' as TIME));
 --------
 08:08:08
 ij> values (cast ('2001-01-01-08.08.08.123456' as TIMESTAMP));
-1                         
---------------------------
-2001-01-01 08:08:08.123456
+1                            
+-----------------------------
+2001-01-01 08:08:08.123456   
 ij> -- char, varchar
 values (char('abcde', 5));
 1    
@@ -1524,15 +1524,15 @@ ij> insert into t1 values ('2003-09-10',
 ij> insert into t1 values ('2005-09-10', '18.44.02', '2004-09-08-12.20.30.123456', 'cba', 'c');
 1 row inserted/updated/deleted
 ij> select char(c5), char(c6), char(c7), char(c8), char(c9) from t1;
-1         |2       |3                         |4    |5    
-----------------------------------------------------------
-2003-09-10|16:44:02|2003-09-08 12:20:30.123456|abc  |abcde
-2005-09-10|18:44:02|2004-09-08 12:20:30.123456|cba  |c    
+1         |2       |3                            |4    |5    
+-------------------------------------------------------------
+2003-09-10|16:44:02|2003-09-08 12:20:30.123456   |abc  |abcde
+2005-09-10|18:44:02|2004-09-08 12:20:30.123456   |cba  |c    
 ij> select varchar(c5), varchar(c6), varchar(c7), varchar(c8), varchar(c9) from t1;
-1         |2       |3                         |4    |5    
-----------------------------------------------------------
-2003-09-10|16:44:02|2003-09-08 12:20:30.123456|abc  |abcde
-2005-09-10|18:44:02|2004-09-08 12:20:30.123456|cba  |c    
+1         |2       |3                            |4    |5    
+-------------------------------------------------------------
+2003-09-10|16:44:02|2003-09-08 12:20:30.123456   |abc  |abcde
+2005-09-10|18:44:02|2004-09-08 12:20:30.123456   |cba  |c    
 ij> select char(c8, 10), varchar(c9, 9) from t1;
 1         |2        
 --------------------

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=1042675&r1=1042674&r2=1042675&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 Mon Dec  6 15:23:32 2010
@@ -1231,21 +1231,21 @@ ij> -- end derby-1854 test case. 
 create table derby737table1 (c1 int, c2 int);
 0 rows inserted/updated/deleted
 ij> select * from sys.sysstatistics;
-STATID                              |REFERENCEID                         |TABLEID                             |CREATIONTIMESTAMP         |&|VALID|COLCOUNT   |STATISTICS     
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+STATID                              |REFERENCEID                         |TABLEID                             |CREATIONTIMESTAMP            |&|VALID|COLCOUNT   |STATISTICS     
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ij> -- create index on the table when the table is empty. No statistics will be
 --  generated for that index
 create index t1i1 on derby737table1(c1);
 0 rows inserted/updated/deleted
 ij> select * from sys.sysstatistics;
-STATID                              |REFERENCEID                         |TABLEID                             |CREATIONTIMESTAMP         |&|VALID|COLCOUNT   |STATISTICS     
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+STATID                              |REFERENCEID                         |TABLEID                             |CREATIONTIMESTAMP            |&|VALID|COLCOUNT   |STATISTICS     
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ij> -- the insert above will not add a row into sys.sysstatistics for index t1i1
 insert into derby737table1 values(1,1);
 1 row inserted/updated/deleted
 ij> select * from sys.sysstatistics;
-STATID                              |REFERENCEID                         |TABLEID                             |CREATIONTIMESTAMP         |&|VALID|COLCOUNT   |STATISTICS     
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+STATID                              |REFERENCEID                         |TABLEID                             |CREATIONTIMESTAMP            |&|VALID|COLCOUNT   |STATISTICS     
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ij> -- now compress the table and as part of the compress, Derby should generate
 --  statistics for all the indexes provided the table is not empty
 call syscs_util.syscs_compress_table('APP','DERBY737TABLE1',1);
@@ -1253,8 +1253,8 @@ call syscs_util.syscs_compress_table('AP
 ij> -- Will find statistics for index t1i1 on derby737table1 because compress
 --  table created it.
 select * from sys.sysstatistics;
-STATID                              |REFERENCEID                         |TABLEID                             |CREATIONTIMESTAMP         |&|VALID|COLCOUNT   |STATISTICS     
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+STATID                              |REFERENCEID                         |TABLEID                             |CREATIONTIMESTAMP            |&|VALID|COLCOUNT   |STATISTICS     
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 xxxxFILTERED-UUIDxxxx|xxxxFILTERED-UUIDxxxx|xxxxFILTERED-UUIDxxxx|xxxxxxFILTERED-TIMESTAMPxxxxx|I|true |1          |numunique= 1 n&
 ij> drop table derby737table1;
 0 rows inserted/updated/deleted
@@ -1264,50 +1264,50 @@ create table derby737table2 (c1 int, c2 
 ij> insert into derby737table2 values(1,1),(2,2);
 2 rows inserted/updated/deleted
 ij> select * from sys.sysstatistics;
-STATID                              |REFERENCEID                         |TABLEID                             |CREATIONTIMESTAMP         |&|VALID|COLCOUNT   |STATISTICS     
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+STATID                              |REFERENCEID                         |TABLEID                             |CREATIONTIMESTAMP            |&|VALID|COLCOUNT   |STATISTICS     
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ij> -- since there is data in derby737table2 when index is getting created, 
 --   statistics will be created for that index 
 create index t2i1 on derby737table2(c1);
 0 rows inserted/updated/deleted
 ij> select * from sys.sysstatistics;
-STATID                              |REFERENCEID                         |TABLEID                             |CREATIONTIMESTAMP         |&|VALID|COLCOUNT   |STATISTICS     
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+STATID                              |REFERENCEID                         |TABLEID                             |CREATIONTIMESTAMP            |&|VALID|COLCOUNT   |STATISTICS     
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 xxxxFILTERED-UUIDxxxx|xxxxFILTERED-UUIDxxxx|xxxxFILTERED-UUIDxxxx|xxxxxxFILTERED-TIMESTAMPxxxxx|I|true |1          |numunique= 2 n&
 ij> -- deleting all the rows in table will not drop the index statistics
 delete from derby737table2;
 2 rows inserted/updated/deleted
 ij> select * from sys.sysstatistics;
-STATID                              |REFERENCEID                         |TABLEID                             |CREATIONTIMESTAMP         |&|VALID|COLCOUNT   |STATISTICS     
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+STATID                              |REFERENCEID                         |TABLEID                             |CREATIONTIMESTAMP            |&|VALID|COLCOUNT   |STATISTICS     
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 xxxxFILTERED-UUIDxxxx|xxxxFILTERED-UUIDxxxx|xxxxFILTERED-UUIDxxxx|xxxxxxFILTERED-TIMESTAMPxxxxx|I|true |1          |numunique= 2 n&
 ij> -- dropping index will drop the index statistics, if they exist
 drop index t2i1;
 0 rows inserted/updated/deleted
 ij> select * from sys.sysstatistics;
-STATID                              |REFERENCEID                         |TABLEID                             |CREATIONTIMESTAMP         |&|VALID|COLCOUNT   |STATISTICS     
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+STATID                              |REFERENCEID                         |TABLEID                             |CREATIONTIMESTAMP            |&|VALID|COLCOUNT   |STATISTICS     
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ij> -- Next Test : Male sure that compress table will drop the existing statistics
 --  and will not recreate them if the table is empty
 insert into derby737table2 values(1,1),(2,2);
 2 rows inserted/updated/deleted
 ij> select * from sys.sysstatistics;
-STATID                              |REFERENCEID                         |TABLEID                             |CREATIONTIMESTAMP         |&|VALID|COLCOUNT   |STATISTICS     
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+STATID                              |REFERENCEID                         |TABLEID                             |CREATIONTIMESTAMP            |&|VALID|COLCOUNT   |STATISTICS     
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ij> -- since there is data in derby737table2 when index is getting created, 
 --   statistics will be created for that index 
 create index t2i1 on derby737table2(c1);
 0 rows inserted/updated/deleted
 ij> select * from sys.sysstatistics;
-STATID                              |REFERENCEID                         |TABLEID                             |CREATIONTIMESTAMP         |&|VALID|COLCOUNT   |STATISTICS     
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+STATID                              |REFERENCEID                         |TABLEID                             |CREATIONTIMESTAMP            |&|VALID|COLCOUNT   |STATISTICS     
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 xxxxFILTERED-UUIDxxxx|xxxxFILTERED-UUIDxxxx|xxxxFILTERED-UUIDxxxx|xxxxxxFILTERED-TIMESTAMPxxxxx|I|true |1          |numunique= 2 n&
 ij> -- deleting all the rows in table will not drop the index statistics
 delete from derby737table2;
 2 rows inserted/updated/deleted
 ij> select * from sys.sysstatistics;
-STATID                              |REFERENCEID                         |TABLEID                             |CREATIONTIMESTAMP         |&|VALID|COLCOUNT   |STATISTICS     
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+STATID                              |REFERENCEID                         |TABLEID                             |CREATIONTIMESTAMP            |&|VALID|COLCOUNT   |STATISTICS     
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 xxxxFILTERED-UUIDxxxx|xxxxFILTERED-UUIDxxxx|xxxxFILTERED-UUIDxxxx|xxxxxxFILTERED-TIMESTAMPxxxxx|I|true |1          |numunique= 2 n&
 ij> -- now compress the table and as part of the compress, Derby should drop
 --  statistics for all the indexes and should not recreate them if the
@@ -1315,8 +1315,8 @@ ij> -- now compress the table and as par
 call syscs_util.syscs_compress_table('APP','DERBY737TABLE2',1);
 0 rows inserted/updated/deleted
 ij> select * from sys.sysstatistics;
-STATID                              |REFERENCEID                         |TABLEID                             |CREATIONTIMESTAMP         |&|VALID|COLCOUNT   |STATISTICS     
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+STATID                              |REFERENCEID                         |TABLEID                             |CREATIONTIMESTAMP            |&|VALID|COLCOUNT   |STATISTICS     
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ij> --end derby-737 related test cases.
 -- DERBY-2057
 -- Use non-zero args other than 1s.

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=1042675&r1=1042674&r2=1042675&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 Mon Dec  6 15:23:32 2010
@@ -202,27 +202,27 @@ ij> values cast('11:11:11' as varchar(8)
 ij> values cast('11:11:11' as long varchar), time('12:12:12');
 ERROR 42X61: Types 'LONG VARCHAR' and 'TIME' are not UNION compatible.
 ij> values timestamp('1996-09-09 12:12:12.5'), '1996-08-08 11:11:11.1';
-1                         
---------------------------
-1996-09-09 12:12:12.5     
-1996-08-08 11:11:11.1     
+1                            
+-----------------------------
+1996-09-09 12:12:12.5        
+1996-08-08 11:11:11.1        
 ij> values timestamp('1996-09-09 12:12:12.5'), cast('1996-08-08 11:11:11.1' as varchar(30));
-1                         
---------------------------
-1996-09-09 12:12:12.5     
-1996-08-08 11:11:11.1     
+1                            
+-----------------------------
+1996-09-09 12:12:12.5        
+1996-08-08 11:11:11.1        
 ij> values timestamp('1996-09-09 12:12:12.5'), cast('1996-08-08 11:11:11.1' as long varchar);
 ERROR 42X61: Types 'TIMESTAMP' and 'LONG VARCHAR' are not UNION compatible.
 ij> values '1996-08-08 11:11:11.1', timestamp('1996-09-09 12:12:12.5');
-1                         
---------------------------
-1996-08-08 11:11:11.1     
-1996-09-09 12:12:12.5     
+1                            
+-----------------------------
+1996-08-08 11:11:11.1        
+1996-09-09 12:12:12.5        
 ij> values cast('1996-08-08 11:11:11.1' as varchar(30)), timestamp('1996-09-09 12:12:12.5');
-1                         
---------------------------
-1996-08-08 11:11:11.1     
-1996-09-09 12:12:12.5     
+1                            
+-----------------------------
+1996-08-08 11:11:11.1        
+1996-09-09 12:12:12.5        
 ij> values cast('1996-08-08 11:11:11.1' as long varchar), timestamp('1996-09-09 12:12:12.5');
 ERROR 42X61: Types 'LONG VARCHAR' and 'TIMESTAMP' are not UNION compatible.
 ij> -- comparisons at the language level
@@ -2228,8 +2228,8 @@ ij> select b, c_b, bv, vc_bv, lbv, vc_lb
 B   |C_B     |BV  |VC_BV           |LBV                                                                                                                             |VC_LBV          |DT        |C_DT      
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ij> select tm, c_tm, tms, c_tms, c, c_c from all1, all_c1;
-TM      |C_TM            |TMS                       |C_TMS                |C   |C_C                           
---------------------------------------------------------------------------------------------------------------
+TM      |C_TM            |TMS                          |C_TMS                |C   |C_C                           
+-----------------------------------------------------------------------------------------------------------------
 ij> select vc, vc_vc, lvc, c_lvc from all1, all_c1;
 VC  |VC_VC                         |LVC                                                                                                                             |C_LVC                         
 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -2251,8 +2251,8 @@ ij> select b, c_b, bv, vc_bv, lbv, vc_lb
 B   |C_B     |BV  |VC_BV           |LBV                                                                                                                             |VC_LBV          |DT        |C_DT      
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ij> select tm, c_tm, tms, c_tms, c, c_c from all1, all_c1;
-TM      |C_TM            |TMS                       |C_TMS                |C   |C_C                           
---------------------------------------------------------------------------------------------------------------
+TM      |C_TM            |TMS                          |C_TMS                |C   |C_C                           
+-----------------------------------------------------------------------------------------------------------------
 ij> select vc, vc_vc, lvc, c_lvc from all1, all_c1;
 VC  |VC_VC                         |LVC                                                                                                                             |C_LVC                         
 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -2275,9 +2275,9 @@ ij> alter table all1 add column vc30 var
 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|1996-09-09 12:12:12.5     |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|1996-09-09 12:12:12.5        |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';
@@ -2307,9 +2307,9 @@ ij> update all1 set tms = '1990-01-01 08
 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|1990-01-01 08:08:08.6     |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|1990-01-01 08:08:08.6        |1   |2   |44444444                                                                                                                        |NULL                          |NULL                          |NULL                                                                                                                            
 ij> select c30, vc30, lvc2 from all1;
 C30                           |VC30                          |LVC2                                                                                                                            
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -2635,13 +2635,13 @@ ij> values 'a', time('11:11:11');
 --------
 ERROR 22007: The syntax of the string representation of a datetime value is incorrect.
 ij> values timestamp('1996-09-09 11:11:11.5'), 'a';
-1                         
---------------------------
-1996-09-09 11:11:11.5     
+1                            
+-----------------------------
+1996-09-09 11:11:11.5        
 ERROR 22007: The syntax of the string representation of a datetime value is incorrect.
 ij> values 'a', timestamp('1996-09-09 11:11:11.5');
-1                         
---------------------------
+1                            
+-----------------------------
 ERROR 22007: The syntax of the string representation of a datetime value is incorrect.
 ij> -- comparisons at the language level
 select si from all1 where cast(1 as smallint) = 'a';
@@ -3871,26 +3871,26 @@ where b.si = a.lvc;
 ERROR 42818: Comparisons between 'SMALLINT' and 'LONG VARCHAR (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')
 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 (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')
 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