db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From d..@apache.org
Subject svn commit: r397576 - in /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests: master/triggerGeneral.out tests/lang/triggerGeneral.sql
Date Thu, 27 Apr 2006 16:03:51 GMT
Author: djd
Date: Thu Apr 27 09:03:31 2006
New Revision: 397576

URL: http://svn.apache.org/viewcvs?rev=397576&view=rev
Log: (empty)

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=397576&r1=397575&r2=397576&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 27 09:03:31 2006
@@ -1045,4 +1045,33 @@
 0          |NULL                                                        
 1          |Italy's centre-left leader Romano Prodi insists his poll vic
 2          |free                                                        
+ij> drop table t438;
+0 rows inserted/updated/deleted
+ij> drop table t438_t;
+0 rows inserted/updated/deleted
+ij> -- Testcase showing DERBY-1258
+create table tsn (I integer, "i" integer);
+0 rows inserted/updated/deleted
+ij> create table tsn_t (a integer, b integer);
+0 rows inserted/updated/deleted
+ij> create trigger tr_sn after insert on tsn
+referencing new as n
+for each row mode db2sql
+insert into tsn_t(a, b) values (n.I, n."i");
+0 rows inserted/updated/deleted
+ij> insert into tsn values (1, 234);
+1 row inserted/updated/deleted
+ij> select * from tsn;
+I          |i          
+-----------------------
+1          |234        
+ij> -- Should have 1,234 as data in tsn_t
+select * from tsn_t;
+A          |B          
+-----------------------
+1          |1          
+ij> drop table tsn;
+0 rows inserted/updated/deleted
+ij> drop table tsn_t;
+0 rows inserted/updated/deleted
 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=397576&r1=397575&r2=397576&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 27 09:03:31 2006
@@ -579,3 +579,20 @@
 
 select id, cast (cl as clob(60)) from t438 order by 1;
 select id, cast (cl as clob(60)) from t438_t order by 1;
+
+drop table t438;
+drop table t438_t;
+
+-- Testcase showing DERBY-1258
+create table tsn (I integer, "i" integer);
+create table tsn_t (a integer, b integer);
+create trigger tr_sn after insert on tsn
+referencing new as n
+for each row mode db2sql
+insert into tsn_t(a, b) values (n.I, n."i");
+insert into tsn values (1, 234);
+select * from tsn;
+-- Should have 1,234 as data in tsn_t
+select * from tsn_t;
+drop table tsn;
+drop table tsn_t;



Mime
View raw message