db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kahat...@apache.org
Subject svn commit: r1341046 [2/6] - in /db/derby/code/trunk/java: drda/org/apache/derby/impl/drda/ engine/org/apache/derby/iapi/services/io/ engine/org/apache/derby/iapi/sql/ engine/org/apache/derby/iapi/types/ engine/org/apache/derby/impl/sql/execute/ shared...
Date Mon, 21 May 2012 14:30:25 GMT
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=1341046&r1=1341045&r2=1341046&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 May 21 14:30:24 2012
@@ -25,18 +25,19 @@ ij> --
 
 -- shrink/grow bit and char
 -- no exceptions should be raised.
--- once we have warnings we'll expect
--- a warning when shrinking non space/zeros
+-- expect a warning when shrinking non-space
 
 -- shrink
 values (cast ('hell' as char(2)));
 1 
 --
 he
+WARNING 01004: Data truncation
 ij> values (cast ('hell' as varchar(2)));
 1 
 --
 he
+WARNING 01004: Data truncation
 ij> -- shrink, whitespace only
 values (cast ('he  ' as char(2)));
 1 
@@ -67,11 +68,13 @@ values (cast (X'1111' as char(1) for bit
 1 
 --
 11
+WARNING 01004: Data truncation
 ij> -- shrink, zero only
 values (cast (X'1100' as char(1) for bit data));
 1 
 --
 11
+WARNING 01004: Data truncation
 ij> -- expand
 values (cast (X'1111' as char(2) for bit data));
 1   
@@ -87,150 +90,187 @@ values cast (X'11111111' as char(1) for 
 1 
 --
 11
+WARNING 01004: Data truncation
 ij> values cast (X'01111111' as char(1) for bit data);
 1 
 --
 01
+WARNING 01004: Data truncation
 ij> values cast (X'11111111' as char(1) for bit data);
 1 
 --
 11
+WARNING 01004: Data truncation
 ij> values cast (X'01111111' as char(1) for bit data);
 1 
 --
 01
+WARNING 01004: Data truncation
 ij> values cast (X'00111111' as char(1) for bit data);
 1 
 --
 00
+WARNING 01004: Data truncation
 ij> values cast (X'11111111' as char(1) for bit data);
 1 
 --
 11
+WARNING 01004: Data truncation
 ij> values cast (X'01111111' as char(1) for bit data);
 1 
 --
 01
+WARNING 01004: Data truncation
 ij> values cast (X'00111111' as char(1) for bit data);
 1 
 --
 00
+WARNING 01004: Data truncation
 ij> values cast (X'00011111' as char(1) for bit data);
 1 
 --
 00
+WARNING 01004: Data truncation
 ij> values cast (X'11111111' as char(1) for bit data);
 1 
 --
 11
+WARNING 01004: Data truncation
 ij> values cast (X'01111111' as char(1) for bit data);
 1 
 --
 01
+WARNING 01004: Data truncation
 ij> values cast (X'00111111' as char(1) for bit data);
 1 
 --
 00
+WARNING 01004: Data truncation
 ij> values cast (X'00011111' as char(1) for bit data);
 1 
 --
 00
+WARNING 01004: Data truncation
 ij> values cast (X'00001111' as char(1) for bit data);
 1 
 --
 00
+WARNING 01004: Data truncation
 ij> values cast (X'11111111' as char(1) for bit data);
 1 
 --
 11
+WARNING 01004: Data truncation
 ij> values cast (X'01111111' as char(1) for bit data);
 1 
 --
 01
+WARNING 01004: Data truncation
 ij> values cast (X'00111111' as char(1) for bit data);
 1 
 --
 00
+WARNING 01004: Data truncation
 ij> values cast (X'00011111' as char(1) for bit data);
 1 
 --
 00
+WARNING 01004: Data truncation
 ij> values cast (X'00001111' as char(1) for bit data);
 1 
 --
 00
+WARNING 01004: Data truncation
 ij> values cast (X'00000111' as char(1) for bit data);
 1 
 --
 00
+WARNING 01004: Data truncation
 ij> values cast (X'11111111' as char(1) for bit data);
 1 
 --
 11
+WARNING 01004: Data truncation
 ij> values cast (X'01111111' as char(1) for bit data);
 1 
 --
 01
+WARNING 01004: Data truncation
 ij> values cast (X'00111111' as char(1) for bit data);
 1 
 --
 00
+WARNING 01004: Data truncation
 ij> values cast (X'00011111' as char(1) for bit data);
 1 
 --
 00
+WARNING 01004: Data truncation
 ij> values cast (X'00001111' as char(1) for bit data);
 1 
 --
 00
+WARNING 01004: Data truncation
 ij> values cast (X'00000111' as char(1) for bit data);
 1 
 --
 00
+WARNING 01004: Data truncation
 ij> values cast (X'00000011' as char(1) for bit data);
 1 
 --
 00
+WARNING 01004: Data truncation
 ij> values cast (X'11111111' as char(1) for bit data);
 1 
 --
 11
+WARNING 01004: Data truncation
 ij> values cast (X'01111111' as char(1) for bit data);
 1 
 --
 01
+WARNING 01004: Data truncation
 ij> values cast (X'00111111' as char(1) for bit data);
 1 
 --
 00
+WARNING 01004: Data truncation
 ij> values cast (X'00011111' as char(1) for bit data);
 1 
 --
 00
+WARNING 01004: Data truncation
 ij> values cast (X'00001111' as char(1) for bit data);
 1 
 --
 00
+WARNING 01004: Data truncation
 ij> values cast (X'00000111' as char(1) for bit data);
 1 
 --
 00
+WARNING 01004: Data truncation
 ij> values cast (X'00000011' as char(1) for bit data);
 1 
 --
 00
+WARNING 01004: Data truncation
 ij> values cast (X'00000001' as char(1) for bit data);
 1 
 --
 00
+WARNING 01004: Data truncation
 ij> values cast (X'0011111111111111' as char(1) for bit data);
 1 
 --
 00
+WARNING 01004: Data truncation
 ij> values cast (X'1111111100111111' as char(2) for bit data);
 1   
 ----
 1111
+WARNING 01004: Data truncation
 ij> ---------
 --numbers
 ---------
@@ -1369,8 +1409,10 @@ create table x(c1 char(1));
 ij> prepare param1 as 'insert into x values cast(? as char(1))';
 ij> insert into x values cast('12' as char(1));
 1 row inserted/updated/deleted
+WARNING 01004: Data truncation
 ij> execute param1 using 'values ''34''';
 1 row inserted/updated/deleted
+WARNING 01004: Data truncation
 ij> select * from x;
 C1  
 ----
@@ -1382,6 +1424,7 @@ ij> insert into x values cast(12 as char
 ERROR 22001: A truncation error was encountered trying to shrink CHAR '12' to length 1.
 ij> execute param1 using 'values 34';
 1 row inserted/updated/deleted
+WARNING 01004: Data truncation
 ij> select * from x;
 C1  
 ----
@@ -1392,6 +1435,7 @@ ij> insert into x values cast(time('12:1
 ERROR 22001: A truncation error was encountered trying to shrink CHAR '12:12:12' to length
1.
 ij> execute param1 using 'values time(''21:12:12'')';
 1 row inserted/updated/deleted
+WARNING 01004: Data truncation
 ij> select * from x;
 C1  
 ----
@@ -1513,6 +1557,7 @@ ij> values (char('abcde', 4));
 1   
 ----
 abcd
+WARNING 01004: Data truncation
 ij> values (varchar('', 20));
 1                   
 --------------------

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml083.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml083.out?rev=1341046&r1=1341045&r2=1341046&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml083.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml083.out
Mon May 21 14:30:24 2012
@@ -115,6 +115,7 @@ ij> -- PASS:0500 If WARNING, null value 
          SELECT MAX(GRADE) 
                FROM HU.STAFF;
 1 row inserted/updated/deleted
+WARNING 01003: Null values were eliminated from the argument of a column function.
 ij> -- PASS:0500 If WARNING, null value eliminated in set function?
 -- PASS:0500 OR SQLSTATE = 01003?
 

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml149.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml149.out?rev=1341046&r1=1341045&r2=1341046&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml149.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml149.out
Mon May 21 14:30:24 2012
@@ -166,6 +166,7 @@ ij> -- PASS:0846 If 1 row selected and O
 1    
 -----
 -12.0
+WARNING 01004: Data truncation
 ij> -- PASS:0846 If ERROR, string data, right truncation, 0 rows selected?
 
    UPDATE NO_DUCK

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/heapscan.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/heapscan.out?rev=1341046&r1=1341045&r2=1341046&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/heapscan.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/heapscan.out
Mon May 21 14:30:24 2012
@@ -69,7 +69,7 @@ ij(SCANNER)> --
 create view lock_table as
 select 
     cast(username as char(8)) as username,
-    cast(t.type as char(8)) as trantype,
+    cast(t.type as char(15)) as trantype,
     cast(l.type as char(8)) as type,
     cast(lockcount as char(3)) as cnt,
     mode,
@@ -173,10 +173,11 @@ KEYCOL     
 -----------
 0          
 ij(SCANNER)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IS  |DATA        |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|TABLE   |1   |X   |JUST_TO_BLOC|Tablelock |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IS  |DATA        |Tablelock |GRANT|ACTIVE  
+WARNING 01004: Data truncation
+APP     |UserTransaction|TABLE   |1   |X   |JUST_TO_BLOC|Tablelock |GRANT|ACTIVE  
 ij(SCANNER)> -- now delete all rows but the last one, space should be reclaimed before
 -- the scanner gets a chance to run.
 set connection deleter;
@@ -193,19 +194,20 @@ ij(DELETER)> commit;
 ij(DELETER)> delete from data where keycol < 80;
 8 rows inserted/updated/deleted
 ij(DELETER)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IS  |DATA        |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|TABLE   |2   |IX  |DATA        |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |DATA        |(1,7)     |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |DATA        |(2,6)     |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |DATA        |(3,6)     |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |DATA        |(4,6)     |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |DATA        |(5,6)     |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |DATA        |(6,6)     |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |DATA        |(7,6)     |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |DATA        |(8,6)     |GRANT|ACTIVE  
-APP     |UserTran|TABLE   |1   |X   |JUST_TO_BLOC|Tablelock |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IS  |DATA        |Tablelock |GRANT|ACTIVE  
+WARNING 01004: Data truncation
+APP     |UserTransaction|TABLE   |2   |IX  |DATA        |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |DATA        |(1,7)     |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |DATA        |(2,6)     |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |DATA        |(3,6)     |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |DATA        |(4,6)     |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |DATA        |(5,6)     |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |DATA        |(6,6)     |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |DATA        |(7,6)     |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |DATA        |(8,6)     |GRANT|ACTIVE  
+APP     |UserTransaction|TABLE   |1   |X   |JUST_TO_BLOC|Tablelock |GRANT|ACTIVE  
 ij(DELETER)> commit;
 ij(DELETER)> -- give post commit a chance to run, by hanging on a lock.
 drop table just_to_block_on;

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/lockTable.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/lockTable.out?rev=1341046&r1=1341045&r2=1341046&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/lockTable.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/lockTable.out
Mon May 21 14:30:24 2012
@@ -55,7 +55,7 @@ ij(C1)> --
 --
 select 
     cast(username as char(8)) as username,
-    cast(t.type as char(8)) as trantype,
+    cast(t.type as char(15)) as trantype,
     cast(l.type as char(8)) as type,
     cast(lockcount as char(3)) as cnt,
     mode,
@@ -68,9 +68,9 @@ from 
 on l.xid = t.xid where l.tableType <> 'S' 
 order by 
     tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-U1      |UserTran|TABLE   |1   |X   |T1          |Tablelock |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+U1      |UserTransaction|TABLE   |1   |X   |T1          |Tablelock |GRANT|ACTIVE  
 ij(C1)> -- verify that we can insert into the table
 insert into t1 values 2;
 1 row inserted/updated/deleted
@@ -108,7 +108,7 @@ ij(C1)> --
 --
 select 
     cast(username as char(8)) as username,
-    cast(t.type as char(8)) as trantype,
+    cast(t.type as char(15)) as trantype,
     cast(l.type as char(8)) as type,
     cast(lockcount as char(3)) as cnt,
     mode,
@@ -121,9 +121,9 @@ from 
 on l.xid = t.xid where l.tableType <> 'S' 
 order by 
     tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-U1      |UserTran|TABLE   |1   |X   |T1          |Tablelock |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+U1      |UserTransaction|TABLE   |1   |X   |T1          |Tablelock |GRANT|ACTIVE  
 ij(C1)> -- verify that we can insert into the table
 insert into t1 values 3;
 1 row inserted/updated/deleted
@@ -162,7 +162,7 @@ ij(C1)> --
 --
 select 
     cast(username as char(8)) as username,
-    cast(t.type as char(8)) as trantype,
+    cast(t.type as char(15)) as trantype,
     cast(l.type as char(8)) as type,
     cast(lockcount as char(3)) as cnt,
     mode,
@@ -175,9 +175,9 @@ from 
 on l.xid = t.xid where l.tableType <> 'S' 
 order by 
     tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-U1      |UserTran|TABLE   |1   |S   |T1          |Tablelock |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+U1      |UserTransaction|TABLE   |1   |S   |T1          |Tablelock |GRANT|ACTIVE  
 ij(C1)> -- verify that we can insert into the table
 insert into t1 values 4;
 1 row inserted/updated/deleted
@@ -216,7 +216,7 @@ ij(C1)> --
 --
 select 
     cast(username as char(8)) as username,
-    cast(t.type as char(8)) as trantype,
+    cast(t.type as char(15)) as trantype,
     cast(l.type as char(8)) as type,
     cast(lockcount as char(3)) as cnt,
     mode,
@@ -229,10 +229,10 @@ from 
 on l.xid = t.xid where l.tableType <> 'S' 
 order by 
     tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-U2      |UserTran|TABLE   |1   |S   |T1          |Tablelock |GRANT|ACTIVE  
-U1      |UserTran|TABLE   |1   |S   |T1          |Tablelock |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+U2      |UserTransaction|TABLE   |1   |S   |T1          |Tablelock |GRANT|ACTIVE  
+U1      |UserTransaction|TABLE   |1   |S   |T1          |Tablelock |GRANT|ACTIVE  
 ij(C1)> -- verify that we cannot insert into the table
 insert into t1 values 5;
 ERROR 40XL1: A lock could not be obtained within the time requested
@@ -281,7 +281,7 @@ ij(C1)> --
 --
 select 
     cast(username as char(8)) as username,
-    cast(t.type as char(8)) as trantype,
+    cast(t.type as char(15)) as trantype,
     cast(l.type as char(8)) as type,
     cast(lockcount as char(3)) as cnt,
     mode,
@@ -294,10 +294,10 @@ from 
 on l.xid = t.xid where l.tableType <> 'S' 
 order by 
     tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-U1      |UserTran|TABLE   |1   |S   |T1          |Tablelock |GRANT|ACTIVE  
-U2      |UserTran|TABLE   |1   |S   |T2          |Tablelock |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+U1      |UserTransaction|TABLE   |1   |S   |T1          |Tablelock |GRANT|ACTIVE  
+U2      |UserTransaction|TABLE   |1   |S   |T2          |Tablelock |GRANT|ACTIVE  
 ij(C1)> commit;
 ij(C1)> disconnect;
 ij> set connection C2;



Mime
View raw message