db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rajesh Kartha (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-1849) Tests lang/grantRevokeDDL.sql and lang/grantRevokeDDL2.sql fails on IBM WCTME 5.7 Foundation (jdkJ2ME Foundation Specification v1.0)
Date Thu, 14 Sep 2006 01:11:22 GMT
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