[
http://issues.apache.org/jira/browse/DERBY-1849?page=comments#action_12439311 ]
Myrna van Lunteren commented on DERBY-1849:
-------------------------------------------
I'm not sure I was clear in my previous comment.
I think currently there are 2 problems with these tests:
- NullPointerException at the start of grantRevokeDDL2 when run with foundation
this may be a test setup issue - not sure - where some essential property
is not
set when running with DataSource only.
- create Trigger fails with foundation because something in the Derby source
code accessed in this statement finds a call to BigDecimal, which we should not
be doing to support JSR169. So this is a problem.
> 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
> 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
