db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Myrna van Lunteren (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1849) Tests lang/grantRevokeDDL.sql and lang/grantRevokeDDL2.sql fails on IBM WCTME 5.7 Foundation (jdkJ2ME Foundation Specification v1.0)
Date Thu, 28 Sep 2006 07:15:50 GMT
    [ http://issues.apache.org/jira/browse/DERBY-1849?page=comments#action_12438341 ] 
            
Myrna van Lunteren commented on DERBY-1849:
-------------------------------------------

The stack trace of that error:
2006-09-28 06:47:03.307 GMT Thread[main,5,main] (XID = 872), (SESSIONID = 9), (DATABASE =
grantRevokeDDL), (DRDAID = null), Failed Statement is: -- following should fail because not
all the privileges are in place
create trigger tr31t31TriggerTest after insert on t31TriggerTest for each statement mode db2sql
	insert into t32TriggerTest values (select c111 from mamta2.v21ViewTest where c112=1)
ERROR 28508: User 'MAMTA3' does not have select permission on column 'C111' of table 'MAMTA2'.'V21VIEWTEST'.
	at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:396)
	at org.apache.derby.iapi.sql.dictionary.StatementColumnPermission.check(StatementColumnPermission.java:127)
	at org.apache.derby.impl.sql.conn.GenericAuthorizer.authorize(GenericAuthorizer.java:159)
	at org.apache.derby.impl.sql.execute.GenericResultSetFactory.getDDLResultSet(GenericResultSetFactory.java:982)
	at org.apache.derby.impl.sql.execute.ConstantActionActivation.execute(ConstantActionActivation.java:54)
	at org.apache.derby.impl.sql.GenericActivationHolder.execute(GenericActivationHolder.java:327)
	at org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:356)
	at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1182)
	at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:585)
	at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:517)
	at org.apache.derby.impl.tools.ij.ij.executeImmediate(ij.java:321)
	at org.apache.derby.impl.tools.ij.utilMain.doCatch(utilMain.java:517)
	at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(utilMain.java:370)
	at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:268)
	at org.apache.derby.impl.tools.ij.Main.go(Main.java:204)
	at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:170)
	at org.apache.derby.impl.tools.ij.Main.main(Main.java:72)
	at org.apache.derby.tools.ij.main(ij.java:67)
Cleanup action completed
---------------

> 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

        

Mime
View raw message