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

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

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/orderby.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/orderby.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/orderby.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/orderby.out Fri Jul 14 09:04:03 2006
@@ -744,10 +744,10 @@
 ij> insert into tab1 values (2, cast(2 as int), cast(2 as smallint), cast(2 as bigint), '2', '2', '2', cast(2.2 as double precision), cast(2.2 as real), '1995-02-02', '12:12:12', 'xxxxxxFILTERED-TIMESTAMPxxxxx', cast(2.2 as decimal(2,1)));
 1 row inserted/updated/deleted
 ij> select * from tab1 order by 1;
-I          |TN         |S          |L          |C         |V         |LVC       |D                     |R            |DT        |T       |TS                        |DC   
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-1          |1          |1          |1          |1         |1         |1         |1.1                   |1.1          |1996-01-01|11:11:11|xxxxxxFILTERED-TIMESTAMPxxxxx|1.1  
-2          |2          |2          |2          |2         |2         |2         |2.2                   |2.2          |1995-02-02|12:12:12|xxxxxxFILTERED-TIMESTAMPxxxxx|2.2  
+I          |TN         |S          |L          |C         |V         |LVC       |D                     |R            |DT        |T       |TS                        |DC  
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+1          |1          |1          |1          |1         |1         |1         |1.1                   |1.1          |1996-01-01|11:11:11|xxxxxxFILTERED-TIMESTAMPxxxxx|1.1 
+2          |2          |2          |2          |2         |2         |2         |2.2                   |2.2          |1995-02-02|12:12:12|xxxxxxFILTERED-TIMESTAMPxxxxx|2.2 
 ij> rollback;
 ij> -- bug 2769 (correlation columns, group by and order by)
 create table bug2769(c1 int, c2 int);

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/partdml.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/partdml.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/partdml.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/partdml.out Fri Jul 14 09:04:03 2006
@@ -108,20 +108,20 @@
 Bit set of columns fetched={5}
 ij> -- confirm the table is ok
 select ccharForBitData, ctime, cdec, cint, cchar from basic;
-CCH&|CTIME   |CDEC     |CINT       |CCHAR     
-----------------------------------------------
-11  |11:11:11|1.10     |11         |11        
-22  |22:22:22|2.20     |22         |22        
-33  |03:33:33|3.30     |33         |33        
-33  |03:33:33|3.30     |33         |33        
-33  |03:33:33|3.30     |33         |33        
-33  |03:33:33|3.30     |33         |33        
-33  |03:33:33|3.30     |33         |33        
-33  |03:33:33|3.30     |33         |33        
-33  |03:33:33|3.30     |33         |33        
-33  |03:33:33|3.30     |33         |33        
-33  |03:33:33|3.30     |33         |33        
-33  |03:33:33|3.30     |33         |33        
+CCH&|CTIME   |CDEC    |CINT       |CCHAR     
+---------------------------------------------
+11  |11:11:11|1.10    |11         |11        
+22  |22:22:22|2.20    |22         |22        
+33  |03:33:33|3.30    |33         |33        
+33  |03:33:33|3.30    |33         |33        
+33  |03:33:33|3.30    |33         |33        
+33  |03:33:33|3.30    |33         |33        
+33  |03:33:33|3.30    |33         |33        
+33  |03:33:33|3.30    |33         |33        
+33  |03:33:33|3.30    |33         |33        
+33  |03:33:33|3.30    |33         |33        
+33  |03:33:33|3.30    |33         |33        
+33  |03:33:33|3.30    |33         |33        
 ij> values (SYSCS_UTIL.SYSCS_CHECK_TABLE('APP', 'BASIC'));
 1          
 -----------
@@ -176,20 +176,20 @@
 	
 ij> -- confirm the table is ok
 select ccharForBitData, ctime, cdec, cint, cchar from basic;
-CCH&|CTIME   |CDEC     |CINT       |CCHAR     
-----------------------------------------------
-11  |11:11:11|1.10     |11         |11        
-22  |22:22:22|2.20     |22         |22        
-33  |03:33:33|3.30     |33         |33        
-33  |03:33:33|3.30     |33         |33        
-33  |03:33:33|3.30     |33         |33        
-33  |03:33:33|3.30     |33         |33        
-33  |03:33:33|3.30     |33         |33        
-33  |03:33:33|3.30     |33         |33        
-33  |03:33:33|3.30     |33         |33        
-33  |03:33:33|3.30     |33         |33        
-33  |03:33:33|3.30     |33         |33        
-33  |03:33:33|3.30     |33         |33        
+CCH&|CTIME   |CDEC    |CINT       |CCHAR     
+---------------------------------------------
+11  |11:11:11|1.10    |11         |11        
+22  |22:22:22|2.20    |22         |22        
+33  |03:33:33|3.30    |33         |33        
+33  |03:33:33|3.30    |33         |33        
+33  |03:33:33|3.30    |33         |33        
+33  |03:33:33|3.30    |33         |33        
+33  |03:33:33|3.30    |33         |33        
+33  |03:33:33|3.30    |33         |33        
+33  |03:33:33|3.30    |33         |33        
+33  |03:33:33|3.30    |33         |33        
+33  |03:33:33|3.30    |33         |33        
+33  |03:33:33|3.30    |33         |33        
 ij> values (SYSCS_UTIL.SYSCS_CHECK_TABLE('APP', 'BASIC'));
 1          
 -----------
@@ -231,20 +231,20 @@
 Bit set of columns fetched={0, 1, 2, 3}
 ij> -- confirm the table is ok
 select ccharForBitData, ctime, cdec, cint, cchar from basic;
-CCH&|CTIME   |CDEC     |CINT       |CCHAR     
-----------------------------------------------
-11  |11:11:11|1.10     |11         |11        
-22  |22:22:22|2.20     |22         |22        
-33  |03:33:33|3.30     |33         |33        
-33  |03:33:33|3.30     |33         |33        
-33  |03:33:33|3.30     |33         |33        
-33  |03:33:33|3.30     |33         |33        
-33  |03:33:33|3.30     |33         |33        
-33  |03:33:33|3.30     |33         |33        
-33  |03:33:33|3.30     |33         |33        
-33  |03:33:33|3.30     |33         |33        
-33  |03:33:33|3.30     |33         |33        
-33  |03:33:33|3.30     |33         |33        
+CCH&|CTIME   |CDEC    |CINT       |CCHAR     
+---------------------------------------------
+11  |11:11:11|1.10    |11         |11        
+22  |22:22:22|2.20    |22         |22        
+33  |03:33:33|3.30    |33         |33        
+33  |03:33:33|3.30    |33         |33        
+33  |03:33:33|3.30    |33         |33        
+33  |03:33:33|3.30    |33         |33        
+33  |03:33:33|3.30    |33         |33        
+33  |03:33:33|3.30    |33         |33        
+33  |03:33:33|3.30    |33         |33        
+33  |03:33:33|3.30    |33         |33        
+33  |03:33:33|3.30    |33         |33        
+33  |03:33:33|3.30    |33         |33        
 ij> values (SYSCS_UTIL.SYSCS_CHECK_TABLE('APP', 'BASIC'));
 1          
 -----------
@@ -259,20 +259,20 @@
 Bit set of columns fetched={0, 3}
 ij> -- confirm the table is ok
 select ccharForBitData, ctime, cdec, cint, cchar from basic;
-CCH&|CTIME   |CDEC     |CINT       |CCHAR     
-----------------------------------------------
-11  |11:11:11|11.00    |11         |11        
-22  |22:22:22|22.00    |22         |22        
-33  |03:33:33|33.00    |33         |33        
-33  |03:33:33|33.00    |33         |33        
-33  |03:33:33|33.00    |33         |33        
-33  |03:33:33|33.00    |33         |33        
-33  |03:33:33|33.00    |33         |33        
-33  |03:33:33|33.00    |33         |33        
-33  |03:33:33|33.00    |33         |33        
-33  |03:33:33|33.00    |33         |33        
-33  |03:33:33|33.00    |33         |33        
-33  |03:33:33|33.00    |33         |33        
+CCH&|CTIME   |CDEC    |CINT       |CCHAR     
+---------------------------------------------
+11  |11:11:11|11.00   |11         |11        
+22  |22:22:22|22.00   |22         |22        
+33  |03:33:33|33.00   |33         |33        
+33  |03:33:33|33.00   |33         |33        
+33  |03:33:33|33.00   |33         |33        
+33  |03:33:33|33.00   |33         |33        
+33  |03:33:33|33.00   |33         |33        
+33  |03:33:33|33.00   |33         |33        
+33  |03:33:33|33.00   |33         |33        
+33  |03:33:33|33.00   |33         |33        
+33  |03:33:33|33.00   |33         |33        
+33  |03:33:33|33.00   |33         |33        
 ij> values (SYSCS_UTIL.SYSCS_CHECK_TABLE('APP', 'BASIC'));
 1          
 -----------
@@ -294,20 +294,20 @@
 Bit set of columns fetched={0, 1, 2, 3, 4}
 ij> -- confirm the table is ok
 select ccharForBitData, ctime, cdec, cint, cchar from basic;
-CCH&|CTIME   |CDEC     |CINT       |CCHAR     
-----------------------------------------------
-11  |11:11:11|1.10     |11         |11        
-22  |22:22:22|2.20     |22         |22        
-33  |03:33:33|3.30     |33         |33        
-33  |03:33:33|3.30     |33         |33        
-33  |03:33:33|3.30     |33         |33        
-33  |03:33:33|3.30     |33         |33        
-33  |03:33:33|3.30     |33         |33        
-33  |03:33:33|3.30     |33         |33        
-33  |03:33:33|3.30     |33         |33        
-33  |03:33:33|3.30     |33         |33        
-33  |03:33:33|3.30     |33         |33        
-33  |03:33:33|3.30     |33         |33        
+CCH&|CTIME   |CDEC    |CINT       |CCHAR     
+---------------------------------------------
+11  |11:11:11|1.10    |11         |11        
+22  |22:22:22|2.20    |22         |22        
+33  |03:33:33|3.30    |33         |33        
+33  |03:33:33|3.30    |33         |33        
+33  |03:33:33|3.30    |33         |33        
+33  |03:33:33|3.30    |33         |33        
+33  |03:33:33|3.30    |33         |33        
+33  |03:33:33|3.30    |33         |33        
+33  |03:33:33|3.30    |33         |33        
+33  |03:33:33|3.30    |33         |33        
+33  |03:33:33|3.30    |33         |33        
+33  |03:33:33|3.30    |33         |33        
 ij> values (SYSCS_UTIL.SYSCS_CHECK_TABLE('APP', 'BASIC'));
 1          
 -----------

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/resultset.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/resultset.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/resultset.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/resultset.out Fri Jul 14 09:04:03 2006
@@ -177,7 +177,7 @@
 isCurrency(10): true
 isNullable(10): 1
 isSigned(10): true
-getColumnDisplaySize(10): 13
+getColumnDisplaySize(10): 12
 getColumnLabel(10): DC
 getColumnName(10): DC
 getTableName(10): T

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/specjPlans.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/specjPlans.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/specjPlans.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/specjPlans.out Fri Jul 14 09:04:03 2006
@@ -637,8 +637,8 @@
 ij> maximumdisplaywidth 3500;
 ij> SELECT T1.O_STATUS, T1.O_SHIP_DATE, T1.O_ENTRY_DATE, T1.O_TOTAL, T1.O_DISCOUNT, T1.O_OL_CNT, T1.O_C_ID, T1.O_ID 
  FROM O_ORDERS  T1 WHERE o_c_id = 0 FOR UPDATE ;
-O_STATUS   |O_SHIP_DA&|O_ENTRY_DATE              |O_TOTAL     |O_DISC&|O_OL_CNT   |O_C_ID     |O_ID       
-----------------------------------------------------------------------------------------------------------
+O_STATUS   |O_SHIP_DA&|O_ENTRY_DATE              |O_TOTAL    |O_DIS&|O_OL_CNT   |O_C_ID     |O_ID       
+--------------------------------------------------------------------------------------------------------
 ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS();
 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
                                    
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 -----------------------------------
@@ -1538,8 +1538,8 @@
 Unknown return value: true
 Negate comparison result: true
 ij> SELECT T1.I_DISCOUNT, T1.I_DESC, T1.I_NAME, T1.I_PRICE, T1.I_ID FROM O_ITEM  T1 WHERE T1.I_ID = 'abcdefghijk';
-I_DISCOU&|I_DESC                                                                                              |I_NAME              |I_PRICE     |I_ID           
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
+I_DISCO&|I_DESC                                                                                              |I_NAME              |I_PRICE    |I_ID           
+--------------------------------------------------------------------------------------------------------------------------------------------------------------
 ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS();
 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
                                    
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 -----------------------------------
@@ -1803,8 +1803,8 @@
 		qualifiers:
 None
 ij> SELECT T1.SC_P_ID, T1.SC_SUPP_ID, T1.SC_PRICE, T1.SC_QTY, T1.SC_DISCOUNT, T1.SC_DEL_DATE FROM S_SUPP_COMPONENT  T1 WHERE T1.SC_P_ID = 'abcdefgjikl' AND T1.SC_SUPP_ID = 1;
-SC_P_ID        |SC_SUPP_ID |SC_PRICE    |SC_QTY     |SC_DISCO&|SC_DEL_DATE
---------------------------------------------------------------------------
+SC_P_ID        |SC_SUPP_ID |SC_PRICE   |SC_QTY     |SC_DISC&|SC_DEL_DATE
+------------------------------------------------------------------------
 ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS();
 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
                                    
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 -----------------------------------
@@ -1860,8 +1860,8 @@
 		qualifiers:
 None
 ij> SELECT T1.O_STATUS, T1.O_SHIP_DATE, T1.O_ENTRY_DATE, T1.O_TOTAL, T1.O_DISCOUNT, T1.O_OL_CNT, T1.O_C_ID, T1.O_ID FROM O_ORDERS  T1 WHERE T1.O_ID = 1 FOR UPDATE;
-O_STATUS   |O_SHIP_DA&|O_ENTRY_DATE              |O_TOTAL     |O_DISC&|O_OL_CNT   |O_C_ID     |O_ID       
-----------------------------------------------------------------------------------------------------------
+O_STATUS   |O_SHIP_DA&|O_ENTRY_DATE              |O_TOTAL    |O_DIS&|O_OL_CNT   |O_C_ID     |O_ID       
+--------------------------------------------------------------------------------------------------------
 ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS();
 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
                                    
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 -----------------------------------
@@ -2450,8 +2450,8 @@
 					qualifiers:
 None
 ij> SELECT T1.COMP_ID, T1.COMP_NAME, T1.COMP_DESC, T1.COMP_UNIT, T1.COMP_COST, T1.QTY_ON_ORDER, T1.QTY_DEMANDED, T1.LEAD_TIME, T1.CONTAINER_SIZE FROM S_COMPONENT  T1 WHERE T1.COMP_ID = 'abcdefghijk' FOR UPDATE;
-COMP_ID        |COMP_NAME |COMP_DESC                                                                                           |COMP_UNIT |COMP_COST   |QTY_ON_ORD&|QTY_DEMAND&|LEAD_TIME  |CONTAINER_&
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+COMP_ID        |COMP_NAME |COMP_DESC                                                                                           |COMP_UNIT |COMP_COST  |QTY_ON_ORD&|QTY_DEMAND&|LEAD_TIME  |CONTAINER_&
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS();
 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
                                    
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 -----------------------------------
@@ -3261,8 +3261,8 @@
 					qualifiers:
 None
 ij> SELECT T1.POL_NUMBER, T1.POL_PO_ID, T1.POL_P_ID, T1.POL_QTY, T1.POL_BALANCE, T1.POL_DELDATE, T1.POL_MESSAGE FROM S_PURCHASE_ORDERLINE  T1 WHERE T1.POL_NUMBER = 100 AND T1.POL_PO_ID = 200 FOR UPDATE;
-POL_NUMBER |POL_PO_ID  |POL_P_ID       |POL_QTY    |POL_BALANCE |POL_DELDA&|POL_MESSAGE                                                                                         
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+POL_NUMBER |POL_PO_ID  |POL_P_ID       |POL_QTY    |POL_BALANCE|POL_DELDA&|POL_MESSAGE                                                                                         
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS();
 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
                                    
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 -----------------------------------
@@ -3401,8 +3401,8 @@
 				qualifiers:
 None
 ij> SELECT T1.POL_NUMBER, T1.POL_PO_ID, T1.POL_P_ID, T1.POL_QTY, T1.POL_BALANCE, T1.POL_DELDATE, T1.POL_MESSAGE FROM S_PURCHASE_ORDERLINE  T1 WHERE pol_po_id = 11 FOR UPDATE;
-POL_NUMBER |POL_PO_ID  |POL_P_ID       |POL_QTY    |POL_BALANCE |POL_DELDA&|POL_MESSAGE                                                                                         
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+POL_NUMBER |POL_PO_ID  |POL_P_ID       |POL_QTY    |POL_BALANCE|POL_DELDA&|POL_MESSAGE                                                                                         
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS();
 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
                                    
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 -----------------------------------
@@ -3694,8 +3694,8 @@
 				qualifiers:
 None
 ij> SELECT T1.C_ID, T1.C_SINCE, T1.C_BALANCE, T1.C_CREDIT, T1.C_CREDIT_LIMIT, T1.C_YTD_PAYMENT FROM C_CUSTOMER  T1 WHERE T1.C_ID = 1111 FOR UPDATE;
-C_ID       |C_SINCE   |C_BALANCE   |C_C&|C_CREDIT_LI&|C_YTD_PAYME&
-------------------------------------------------------------------
+C_ID       |C_SINCE   |C_BALANCE  |C_C&|C_CREDIT_L&|C_YTD_PAYM&
+---------------------------------------------------------------
 ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS();
 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
                                    
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 -----------------------------------

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/supersimple.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/supersimple.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/supersimple.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/supersimple.out Fri Jul 14 09:04:03 2006
@@ -21,12 +21,12 @@
 ij> insert into b values(32767,2147483647, 9223372036854775807 ,1.4 , 3.4028235E38 ,3.4028235E38  ,999.99, 9999999.999,'one','one','one',cast(X'01ABCD' as blob(1000)), 'one');
 1 row inserted/updated/deleted
 ij> select * from b;
-SI    |I          |BI                  |R            |F                     |D                     |N5_2    |DEC10_3      |CH20                |VC                  |LVC                                                                                                                             |BLOBCOL                                                                                                                         |CLOBCOL                                                                                                                         
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-2     |3          |4                   |5.3          |5.3                   |5.3                   |31.13   |123456.123   |one                 |one                 |one                                                                                                                             |01abcd                                                                                                                          |one                                                                                                                             
--32768|-2147483648|-9223372036854775808|1.2E-37      |2.225E-307            |2.225E-307            |-56.12  |-123456.123  |one                 |one                 |one                                                                                                                             |01abcd                                                                                                                          |one                                                                                                                             
-NULL  |NULL       |NULL                |NULL         |NULL                  |NULL                  |NULL    |NULL         |NULL                |NULL                |NULL                                                                                                                            |NULL                                                                                                                            |NULL                                                                                                                            
-32767 |2147483647 |9223372036854775807 |1.4          |3.4028235E38          |3.4028235E38          |999.99  |9999999.999  |one                 |one                 |one                                                                                                                             |01abcd                                                                                                                          |one                                                                                                                             
+SI    |I          |BI                  |R            |F                     |D                     |N5_2   |DEC10_3     |CH20                |VC                  |LVC                                                                                                                             |BLOBCOL                                                                                                                         |CLOBCOL                                                                                                                         
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+2     |3          |4                   |5.3          |5.3                   |5.3                   |31.13  |123456.123  |one                 |one                 |one                                                                                                                             |01abcd                                                                                                                          |one                                                                                                                             
+-32768|-2147483648|-9223372036854775808|1.2E-37      |2.225E-307            |2.225E-307            |-56.12 |-123456.123 |one                 |one                 |one                                                                                                                             |01abcd                                                                                                                          |one                                                                                                                             
+NULL  |NULL       |NULL                |NULL         |NULL                  |NULL                  |NULL   |NULL        |NULL                |NULL                |NULL                                                                                                                            |NULL                                                                                                                            |NULL                                                                                                                            
+32767 |2147483647 |9223372036854775807 |1.4          |3.4028235E38          |3.4028235E38          |999.99 |9999999.999 |one                 |one                 |one                                                                                                                             |01abcd                                                                                                                          |one                                                                                                                             
 ij> drop table b;
 0 rows inserted/updated/deleted
 ij> create table c (si smallint not null,i int not null , bi bigint not null, r real not null, f float not null, d double precision not null, n5_2 numeric(5,2) not null , dec10_3 decimal(10,3) not null, ch20 char(20) not null ,vc varchar(20) not null, lvc long varchar not null,  blobCol blob(1000) not null,  clobCol clob(1000) not null);
@@ -36,10 +36,10 @@
 ij> insert into c values(-32768,-2147483648, -9223372036854775808 ,1.2E-37, 2.225E-307, +2.225E-307,-56.12, -123456.123,'one','one','one', cast(X'01ABCD' as blob(1000)),'one');
 1 row inserted/updated/deleted
 ij> select * from c;
-SI    |I          |BI                  |R            |F                     |D                     |N5_2    |DEC10_3      |CH20                |VC                  |LVC                                                                                                                             |BLOBCOL                                                                                                                         |CLOBCOL                                                                                                                         
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-2     |3          |4                   |5.3          |5.3                   |5.3                   |31.13   |123456.123   |one                 |one                 |one                                                                                                                             |01abcd                                                                                                                          |one                                                                                                                             
--32768|-2147483648|-9223372036854775808|1.2E-37      |2.225E-307            |2.225E-307            |-56.12  |-123456.123  |one                 |one                 |one                                                                                                                             |01abcd                                                                                                                          |one                                                                                                                             
+SI    |I          |BI                  |R            |F                     |D                     |N5_2   |DEC10_3     |CH20                |VC                  |LVC                                                                                                                             |BLOBCOL                                                                                                                         |CLOBCOL                                                                                                                         
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+2     |3          |4                   |5.3          |5.3                   |5.3                   |31.13  |123456.123  |one                 |one                 |one                                                                                                                             |01abcd                                                                                                                          |one                                                                                                                             
+-32768|-2147483648|-9223372036854775808|1.2E-37      |2.225E-307            |2.225E-307            |-56.12 |-123456.123 |one                 |one                 |one                                                                                                                             |01abcd                                                                                                                          |one                                                                                                                             
 ij> values(10);
 1          
 -----------
@@ -49,9 +49,9 @@
 -----
 hello
 ij> values(1.2);
-1    
------
-1.2  
+1   
+----
+1.2 
 ij> drop table c;
 0 rows inserted/updated/deleted
 ij> -- bug 4430 aliasinfo nullability problem

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/triggerGeneral.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/triggerGeneral.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/triggerGeneral.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/triggerGeneral.out Fri Jul 14 09:04:03 2006
@@ -973,19 +973,19 @@
 ij> insert into t438 values (2, 22.21, cast (X'aa' as blob));
 1 row inserted/updated/deleted
 ij> select id, cost, length(bl) from t438 order by 1;
-ID         |COST     |3          
----------------------------------
-0          |95.32    |NULL       
-1          |34.53    |14         
-2          |22.21    |1          
+ID         |COST    |3          
+--------------------------------
+0          |95.32   |NULL       
+1          |34.53   |14         
+2          |22.21   |1          
 ij> update t438 set cost = cost + 1.23;
 3 rows inserted/updated/deleted
 ij> select id, length(bl), l, nc, oc from t438_t order by 1,5,4;
-ID         |2          |L          |NC       |OC       
--------------------------------------------------------
-0          |NULL       |NULL       |96.55    |95.32    
-1          |14         |14         |35.76    |34.53    
-2          |1          |1          |23.44    |22.21    
+ID         |2          |L          |NC      |OC      
+-----------------------------------------------------
+0          |NULL       |NULL       |96.55   |95.32   
+1          |14         |14         |35.76   |34.53   
+2          |1          |1          |23.44   |22.21   
 ij> select id, cast (bl as blob(20)) from t438 order by 1;
 ID         |2                                       
 ----------------------------------------------------
@@ -1020,19 +1020,19 @@
 ij> insert into t438 values (2, 22.21, cast ('free' as clob));
 1 row inserted/updated/deleted
 ij> select id, cost, length(cl) from t438 order by 1;
-ID         |COST     |3          
----------------------------------
-0          |95.32    |NULL       
-1          |34.53    |107        
-2          |22.21    |4          
+ID         |COST    |3          
+--------------------------------
+0          |95.32   |NULL       
+1          |34.53   |107        
+2          |22.21   |4          
 ij> update t438 set cost = cost + 1.23;
 3 rows inserted/updated/deleted
 ij> select id, length(cl), l, nc, oc from t438_t order by 1,5,4;
-ID         |2          |L          |NC       |OC       
--------------------------------------------------------
-0          |NULL       |NULL       |96.55    |95.32    
-1          |107        |107        |35.76    |34.53    
-2          |4          |4          |23.44    |22.21    
+ID         |2          |L          |NC      |OC      
+-----------------------------------------------------
+0          |NULL       |NULL       |96.55   |95.32   
+1          |107        |107        |35.76   |34.53   
+2          |4          |4          |23.44   |22.21   
 ij> select id, cast (cl as clob(60)) from t438 order by 1;
 ID         |2                                                           
 ------------------------------------------------------------------------

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/triggerRefClause.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/triggerRefClause.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/triggerRefClause.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/triggerRefClause.out Fri Jul 14 09:04:03 2006
@@ -124,13 +124,13 @@
 					  X'12af', X'0F0F', X'1234', 111.11, 222.2);
 1 row inserted/updated/deleted
 ij> select * from allTypes1;
-I          |TN    |S     |L                   |C         |V                                                 |LVC                                                                                                                             |D                     |R            |F                     |DT        |T       |TS                        |B   |BV  |LBV                                                                                                                             |DC      |N          
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-0          |10    |100   |1000000             |duplicate |this is duplicated                                |also duplicated                                                                                                                 |200.0                 |200.0        |200.0                 |1992-01-01|12:30:30|xxxxxxFILTERED-TIMESTAMPxxxxx|12af|0f0f|1234                                                                                                                            |111.11  |222.2000   
+I          |TN    |S     |L                   |C         |V                                                 |LVC                                                                                                                             |D                     |R            |F                     |DT        |T       |TS                        |B   |BV  |LBV                                                                                                                             |DC     |N         
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+0          |10    |100   |1000000             |duplicate |this is duplicated                                |also duplicated                                                                                                                 |200.0                 |200.0        |200.0                 |1992-01-01|12:30:30|xxxxxxFILTERED-TIMESTAMPxxxxx|12af|0f0f|1234                                                                                                                            |111.11 |222.2000  
 ij> select * from allTypes2;
-I          |TN    |S     |L                   |C         |V                                                 |LVC                                                                                                                             |D                     |R            |F                     |DT        |T       |TS                        |B   |BV  |LBV                                                                                                                             |DC      |N          
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-0          |10    |100   |1000000             |duplicate |this is duplicated                                |also duplicated                                                                                                                 |200.0                 |200.0        |200.0                 |1992-01-01|12:30:30|xxxxxxFILTERED-TIMESTAMPxxxxx|12af|0f0f|1234                                                                                                                            |111.11  |222.2000   
+I          |TN    |S     |L                   |C         |V                                                 |LVC                                                                                                                             |D                     |R            |F                     |DT        |T       |TS                        |B   |BV  |LBV                                                                                                                             |DC     |N         
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+0          |10    |100   |1000000             |duplicate |this is duplicated                                |also duplicated                                                                                                                 |200.0                 |200.0        |200.0                 |1992-01-01|12:30:30|xxxxxxFILTERED-TIMESTAMPxxxxx|12af|0f0f|1234                                                                                                                            |111.11 |222.2000  
 ij> commit;
 ij> drop trigger t1;
 0 rows inserted/updated/deleted
@@ -271,14 +271,14 @@
 ij> insert into x values 1234.1234, null, 1234.123;
 3 rows inserted/updated/deleted
 ij> select * from x;
+X        
+---------
+1234.123 
+NULL     
+1234.123 
+ij> select * from y;
 X         
 ----------
-1234.123  
-NULL      
-1234.123  
-ij> select * from y;
-X          
------------
 ij> create table t1 (col1 int not null primary key, col2 char(20));
 0 rows inserted/updated/deleted
 ij> create table s_t1(col1 int not null primary key, chgType char(20));



Mime
View raw message