db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From d..@apache.org
Subject svn commit: r393869 - in /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests: master/triggerGeneral.out tests/lang/triggerGeneral.sql
Date Thu, 13 Apr 2006 17:58:07 GMT
Author: djd
Date: Thu Apr 13 10:58:05 2006
New Revision: 393869

URL: http://svn.apache.org/viewcvs?rev=393869&view=rev
Log:
DERBY-438 (partial) Add to triggerGeneral to display the value of BLOBs inserted by a trigger.

Modified:
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/triggerGeneral.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/triggerGeneral.sql

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/triggerGeneral.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/triggerGeneral.out?rev=393869&r1=393868&r2=393869&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
Thu Apr 13 10:58:05 2006
@@ -986,4 +986,16 @@
 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                                       
+----------------------------------------------------
+0          |NULL                                    
+1          |124594322143423214ab35f2e34c            
+2          |aa                                      
+ij> select id, cast (bl as blob(20)) from t438_t order by 1;
+ID         |2                                       
+----------------------------------------------------
+0          |NULL                                    
+1          |124594322143423214ab35f2e34c            
+2          |aa                                      
 ij> 

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/triggerGeneral.sql
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/triggerGeneral.sql?rev=393869&r1=393868&r2=393869&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/triggerGeneral.sql
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/triggerGeneral.sql
Thu Apr 13 10:58:05 2006
@@ -554,3 +554,6 @@
 update t438 set cost = cost + 1.23;
 select id, length(bl), l, nc, oc from t438_t order by 1,5,4;
 
+select id, cast (bl as blob(20)) from t438 order by 1;
+select id, cast (bl as blob(20)) from t438_t order by 1;
+



Mime
View raw message