db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From myrn...@apache.org
Subject svn commit: r476541 [3/3] - in /db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests: master/j9_foundation/grantRevokeDDL.out master/j9_foundation/grantRevokeDDL2.out tests/lang/grantRevokeDDL2_app.properties
Date Sat, 18 Nov 2006 15:47:33 GMT
Copied: db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/grantRevokeDDL2.out
(from r476425, db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/grantRevokeDDL2.out)
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/grantRevokeDDL2.out?view=diff&rev=476541&p1=db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/grantRevokeDDL2.out&r1=476425&p2=db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/grantRevokeDDL2.out&r2=476541
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/grantRevokeDDL2.out
(original)
+++ db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/grantRevokeDDL2.out
Sat Nov 18 07:47:33 2006
@@ -113,7 +113,7 @@
 0 rows inserted/updated/deleted
 ij(USER1)> -- tests
 create trigger grant_select_trig AFTER delete on t1 
-	for each STATEMENT call grant_select_proc1();
+	for each STATEMENT mode db2sql call grant_select_proc1();
 0 rows inserted/updated/deleted
 ij(USER1)> -- should fail
 delete from t1 where i = 1;
@@ -133,7 +133,7 @@
 ERROR: Failed with SQLSTATE 28508
 ij(USER2)> set connection user1;
 ij(USER1)> create trigger grant_select_trig AFTER delete on t1 
-	for each STATEMENT call grant_select_proc2();
+	for each STATEMENT mode db2sql call grant_select_proc2();
 0 rows inserted/updated/deleted
 ij(USER1)> -- should fail
 delete from t1 where i = 2;
@@ -153,7 +153,7 @@
 ERROR: Failed with SQLSTATE 28508
 ij(USER2)> set connection user1;
 ij(USER1)> create trigger grant_select_trig AFTER delete on t1 
-	for each STATEMENT call grant_select_proc3();
+	for each STATEMENT mode db2sql call grant_select_proc3();
 0 rows inserted/updated/deleted
 ij(USER1)> -- should fail
 delete from t1 where i = 3;
@@ -173,7 +173,7 @@
 ERROR: Failed with SQLSTATE 28508
 ij(USER2)> set connection user1;
 ij(USER1)> create trigger grant_select_trig AFTER delete on t1 
-	for each STATEMENT call grant_select_proc4();
+	for each STATEMENT mode db2sql call grant_select_proc4();
 0 rows inserted/updated/deleted
 ij(USER1)> -- ok
 delete from t1 where i = 4;
@@ -193,7 +193,7 @@
 ERROR: Failed with SQLSTATE 28508
 ij(USER2)> set connection user1;
 ij(USER1)> create trigger revoke_select_trig AFTER delete on t1 
-	for each STATEMENT call revoke_select_proc1();
+	for each STATEMENT mode db2sql call revoke_select_proc1();
 0 rows inserted/updated/deleted
 ij(USER1)> -- should fail
 delete from t1 where i = 5;
@@ -213,7 +213,7 @@
 ERROR: Failed with SQLSTATE 28508
 ij(USER2)> set connection user1;
 ij(USER1)> create trigger revoke_select_trig AFTER delete on t1 
-	for each STATEMENT call revoke_select_proc2();
+	for each STATEMENT mode db2sql call revoke_select_proc2();
 0 rows inserted/updated/deleted
 ij(USER1)> -- should fail
 delete from t1 where i = 6;
@@ -233,7 +233,7 @@
 ERROR: Failed with SQLSTATE 28508
 ij(USER2)> set connection user1;
 ij(USER1)> create trigger revoke_select_trig AFTER delete on t1 
-	for each STATEMENT call revoke_select_proc3();
+	for each STATEMENT mode db2sql call revoke_select_proc3();
 0 rows inserted/updated/deleted
 ij(USER1)> -- should fail
 delete from t1 where i = 7;
@@ -253,7 +253,7 @@
 ERROR: Failed with SQLSTATE 28508
 ij(USER2)> set connection user1;
 ij(USER1)> create trigger revoke_select_trig AFTER delete on t1 
-	for each STATEMENT call revoke_select_proc4();
+	for each STATEMENT mode db2sql call revoke_select_proc4();
 0 rows inserted/updated/deleted
 ij(USER1)> -- ok
 delete from t1 where i = 8;
@@ -352,7 +352,7 @@
 create table t2 (c1 int primary key not null, c2 int references user1.t1);
 ERROR: Failed with SQLSTATE 28508
 ij(USER2)> -- test TRIGGER privilege, expect error
-create trigger trigger1 after update on user1.t1 for each statement values integer('123');
+create trigger trigger1 after update on user1.t1 for each statement mode db2sql values integer('123');
 ERROR: Failed with SQLSTATE 28506
 ij(USER2)> -- try to DROP user1.idx1 index, expect error
 drop index user1.idx1;
@@ -1708,10 +1708,10 @@
 -- -------------------------------------------------------------------
 set connection user1;
 ij(USER1)> -- expect error
-create trigger tt0a after insert on t1 for each statement grant select on t1 to user2;
+create trigger tt0a after insert on t1 for each statement mode db2sql grant select on t1
to user2;
 ERROR: Failed with SQLSTATE 42X01
 ij(USER1)> -- expect error
-create trigger tt0b after insert on t1 for each statement revoke select on t1 from user2;
+create trigger tt0b after insert on t1 for each statement mode db2sql revoke select on t1
from user2;
 ERROR: Failed with SQLSTATE 42X01
 ij(USER1)> -- same schema in trigger action
 drop table t6;
@@ -1727,9 +1727,9 @@
 0 rows inserted/updated/deleted
 ij(USER2)> insert into t7 values (1,1,1);
 1 row inserted/updated/deleted
-ij(USER2)> create trigger tt1 after insert on user1.t6 for each statement update user2.t7
set c2 = 888;
+ij(USER2)> create trigger tt1 after insert on user1.t6 for each statement mode db2sql
update user2.t7 set c2 = 888;
 0 rows inserted/updated/deleted
-ij(USER2)> create trigger tt2 after insert on user1.t6 for each statement insert into
user2.t7 values (2,2,2);
+ij(USER2)> create trigger tt2 after insert on user1.t6 for each statement mode db2sql
insert into user2.t7 values (2,2,2);
 0 rows inserted/updated/deleted
 ij(USER2)> set connection user1;
 ij(USER1)> insert into t6 values (1, 10);
@@ -1760,9 +1760,9 @@
 ij(USER1)> grant update(c2, c1), insert on t9 to user2;
 0 rows inserted/updated/deleted
 ij(USER1)> set connection user2;
-ij(USER2)> create trigger tt3 after insert on user1.t8 for each statement update user1.t9
set c2 = 888;
+ij(USER2)> create trigger tt3 after insert on user1.t8 for each statement mode db2sql
update user1.t9 set c2 = 888;
 0 rows inserted/updated/deleted
-ij(USER2)> create trigger tt4 after insert on user1.t8 for each statement insert into
user1.t9 values (2,2,2);
+ij(USER2)> create trigger tt4 after insert on user1.t8 for each statement mode db2sql
insert into user1.t9 values (2,2,2);
 0 rows inserted/updated/deleted
 ij(USER2)> set connection user1;
 ij(USER1)> -- expect error
@@ -1794,11 +1794,11 @@
 0 rows inserted/updated/deleted
 ij(USER1)> set connection user2;
 ij(USER2)> -- ok
-create trigger tt5 after update on user1.t10 for each statement insert into user1.t11 values
1;
+create trigger tt5 after update on user1.t10 for each statement mode db2sql insert into user1.t11
values 1;
 0 rows inserted/updated/deleted
-ij(USER2)> create trigger tt6 after update of i on user1.t10 for each statement insert
into user1.t11 values 2;
+ij(USER2)> create trigger tt6 after update of i on user1.t10 for each statement mode db2sql
insert into user1.t11 values 2;
 0 rows inserted/updated/deleted
-ij(USER2)> create trigger tt7 after update of j on user1.t10 for each statement insert
into user1.t11 values 3;
+ij(USER2)> create trigger tt7 after update of j on user1.t10 for each statement mode db2sql
insert into user1.t11 values 3;
 0 rows inserted/updated/deleted
 ij(USER2)> update user1.t10 set i=10;
 2 rows inserted/updated/deleted
@@ -1837,7 +1837,7 @@
 ij(USER1)> grant trigger on t10 to user2;
 0 rows inserted/updated/deleted
 ij(USER1)> set connection user2;
-ij(USER2)> create trigger tt8 after update of j on user1.t10 for each statement delete
from user1.t11;
+ij(USER2)> create trigger tt8 after update of j on user1.t10 for each statement mode db2sql
delete from user1.t11;
 0 rows inserted/updated/deleted
 ij(USER2)> update user1.t10 set j=100;
 2 rows inserted/updated/deleted
@@ -1878,9 +1878,9 @@
 ij(USER1)> grant select on v to user5;
 0 rows inserted/updated/deleted
 ij(USER1)> set connection user5;
-ij(USER5)> create trigger tt9 after insert on user1.t10 for each statement insert into
user1.t11 values (user1.F_ABS1(-5));
+ij(USER5)> create trigger tt9 after insert on user1.t10 for each statement mode db2sql
insert into user1.t11 values (user1.F_ABS1(-5));
 0 rows inserted/updated/deleted
-ij(USER5)> create trigger tt10 after insert on user1.t10 for each statement insert into
user1.t11 select * from user1.v;
+ij(USER5)> create trigger tt10 after insert on user1.t10 for each statement mode db2sql
insert into user1.t11 select * from user1.v;
 0 rows inserted/updated/deleted
 ij(USER5)> insert into user1.t10 values (1,1);
 1 row inserted/updated/deleted

Propchange: db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/grantRevokeDDL2.out
------------------------------------------------------------------------------
    svn:eol-style = native

Modified: db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/lang/grantRevokeDDL2_app.properties
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/lang/grantRevokeDDL2_app.properties?view=diff&rev=476541&r1=476540&r2=476541
==============================================================================
--- db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/lang/grantRevokeDDL2_app.properties
(original)
+++ db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/lang/grantRevokeDDL2_app.properties
Sat Nov 18 07:47:33 2006
@@ -8,4 +8,6 @@
 derby.locks.deadlockTimeout=5
 derby.locks.waitTimeout=2
 
-
+# DataSource properties, only used if ij.dataSource is set
+ij.dataSource.databaseName=wombat
+ij.dataSource.createDatabase=create



Mime
View raw message