You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by dj...@apache.org on 2006/04/13 19:58:07 UTC
svn commit: r393869 - in
/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests:
master/triggerGeneral.out tests/lang/triggerGeneral.sql
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;
+