You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Myrna van Lunteren (JIRA)" <ji...@apache.org> on 2006/11/18 16:51:38 UTC
[jira] Commented: (DERBY-1849) Tests lang/grantRevokeDDL.sql and
lang/grantRevokeDDL2.sql fails on IBM WCTME 5.7 Foundation (jdkJ2ME
Foundation Specification v1.0)
[ http://issues.apache.org/jira/browse/DERBY-1849?page=comments#action_12451032 ]
Myrna van Lunteren commented on DERBY-1849:
-------------------------------------------
merged to 10.2 with http://svn.apache.org/viewvc?view=rev&revision=476541
> Tests lang/grantRevokeDDL.sql and lang/grantRevokeDDL2.sql fails on IBM WCTME 5.7 Foundation (jdkJ2ME Foundation Specification v1.0)
> ------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1849
> URL: http://issues.apache.org/jira/browse/DERBY-1849
> Project: Derby
> Issue Type: Test
> Components: Test
> Affects Versions: 10.3.0.0
> Environment: Windows
> Reporter: Rajesh Kartha
> Assigned To: Myrna van Lunteren
> Fix For: 10.2.2.0, 10.3.0.0
>
> Attachments: grantRevokeDDL.diff, grantRevokeDDL2.diff
>
>
> The diff for grantRevokeDDL.sql is big, hence attaching.
> For lang/grantRevokeDDL2.sql the diff is as follows:
> ********* Diff file derbyall/derbylang/grantRevokeDDL2.diff
> *** Start: grantRevokeDDL2 jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2006-09-10 11:42:23 ***
> 0a1
> > java.lang.reflect.InvocationTargetException: java.lang.NullPointerException
> 99 del
> < ERROR: Failed with SQLSTATE 38001
> 99a100
> > ERROR: Failed with SQLSTATE XJ001
> 119 del
> < ERROR: Failed with SQLSTATE 38002
> 119a120
> > ERROR: Failed with SQLSTATE XJ001
> 139 del
> < ERROR: Failed with SQLSTATE 38002
> 139a140
> > ERROR: Failed with SQLSTATE XJ001
> 158 del
> < 1 row inserted/updated/deleted
> 158a159,160
> > ERROR: Failed with SQLSTATE 38000
> > ERROR: Failed with SQLSTATE XJ001
> 163 del
> < 0 rows selected
> 163a165,166
> > 4 |XYZ
> > 1 row selected
> 168a172,182
> > ERROR: Failed with SQLSTATE 28508
> > ij(USER2)> set connection user1;
> > ij(USER1)> create trigger revoke_select_trig AFTER delete on t1
> > for each STATEMENT mode db2sql call revoke_select_proc1();
> > 0 rows inserted/updated/deleted
> > ij(USER1)> -- should fail
> > delete from t1 where i = 5;
> > ERROR: Failed with SQLSTATE 38000
> > ERROR: Failed with SQLSTATE XJ001
> > ij(USER1)> -- check delete failed
> > select * from t1 where i = 5;
> 171,184d184
> < 1 |XYZ
> < 1 row selected
> < ij(USER2)> set connection user1;
> < ij(USER1)> create trigger revoke_select_trig AFTER delete on t1
> < for each STATEMENT mode db2sql call revoke_select_proc1();
> < 0 rows inserted/updated/deleted
> < ij(USER1)> -- should fail
> < delete from t1 where i = 5;
> < ERROR: Failed with SQLSTATE 38000
> < ERROR: Failed with SQLSTATE 38001
> < ij(USER1)> -- check delete failed
> < select * from t1 where i = 5;
> < I |B
> < ---------------------------
> 191a192,202
> > ERROR: Failed with SQLSTATE 28508
> > ij(USER2)> set connection user1;
> > ij(USER1)> create trigger revoke_select_trig AFTER delete on t1
> > for each STATEMENT mode db2sql call revoke_select_proc2();
> > 0 rows inserted/updated/deleted
> > ij(USER1)> -- should fail
> > delete from t1 where i = 6;
> > ERROR: Failed with SQLSTATE 38000
> > ERROR: Failed with SQLSTATE XJ001
> > ij(USER1)> -- check delete failed
> > select * from t1 where i = 6;
> 194,207d204
> < 1 |XYZ
> < 1 row selected
> < ij(USER2)> set connection user1;
> < ij(USER1)> create trigger revoke_select_trig AFTER delete on t1
> < for each STATEMENT mode db2sql call revoke_select_proc2();
> < 0 rows inserted/updated/deleted
> < ij(USER1)> -- should fail
> < delete from t1 where i = 6;
> < ERROR: Failed with SQLSTATE 38000
> < ERROR: Failed with SQLSTATE 38002
> < ij(USER1)> -- check delete failed
> < select * from t1 where i = 6;
> < I |B
> < ---------------------------
> 214a212,222
> > ERROR: Failed with SQLSTATE 28508
> > ij(USER2)> set connection user1;
> > ij(USER1)> create trigger revoke_select_trig AFTER delete on t1
> > for each STATEMENT mode db2sql call revoke_select_proc3();
> > 0 rows inserted/updated/deleted
> > ij(USER1)> -- should fail
> > delete from t1 where i = 7;
> > ERROR: Failed with SQLSTATE 38000
> > ERROR: Failed with SQLSTATE XJ001
> > ij(USER1)> -- check delete failed
> > select * from t1 where i = 7;
> 217,230d224
> < 1 |XYZ
> < 1 row selected
> < ij(USER2)> set connection user1;
> < ij(USER1)> create trigger revoke_select_trig AFTER delete on t1
> < for each STATEMENT mode db2sql call revoke_select_proc3();
> < 0 rows inserted/updated/deleted
> < ij(USER1)> -- should fail
> < delete from t1 where i = 7;
> < ERROR: Failed with SQLSTATE 38000
> < ERROR: Failed with SQLSTATE 38002
> < ij(USER1)> -- check delete failed
> < select * from t1 where i = 7;
> < I |B
> < ---------------------------
> 237a232,242
> > ERROR: Failed with SQLSTATE 28508
> > ij(USER2)> set connection user1;
> > ij(USER1)> create trigger revoke_select_trig AFTER delete on t1
> > for each STATEMENT mode db2sql call revoke_select_proc4();
> > 0 rows inserted/updated/deleted
> > ij(USER1)> -- ok
> > delete from t1 where i = 8;
> > ERROR: Failed with SQLSTATE 38000
> > ERROR: Failed with SQLSTATE XJ001
> > ij(USER1)> -- check delete
> > select * from t1 where i = 8;
> 240 del
> < 1 |XYZ
> 240a245
> > 8 |XYZ
> 241a247,252
> > ij(USER1)> drop trigger revoke_select_trig;
> > 0 rows inserted/updated/deleted
> > ij(USER1)> set connection user2;
> > ij(USER2)> -- should fail
> > select * from user1.t1 where i = 1;
> > ERROR: Failed with SQLSTATE 28508
> 243,260d253
> < ij(USER1)> create trigger revoke_select_trig AFTER delete on t1
> < for each STATEMENT mode db2sql call revoke_select_proc4();
> < 0 rows inserted/updated/deleted
> < ij(USER1)> -- ok
> < delete from t1 where i = 8;
> < 1 row inserted/updated/deleted
> < ij(USER1)> -- check delete
> < select * from t1 where i = 8;
> < I |B
> < ---------------------------
> < 0 rows selected
> < ij(USER1)> drop trigger revoke_select_trig;
> < 0 rows inserted/updated/deleted
> < ij(USER1)> set connection user2;
> < ij(USER2)> -- should fail
> < select * from user1.t1 where i = 1;
> < ERROR: Failed with SQLSTATE 28508
> < ij(USER2)> set connection user1;
> Test Failed.
> *** End: grantRevokeDDL2 jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2006-09-10 11:42:33 ***
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira