Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <4305721.1159427570557.JavaMail.jira@brutus>
Date: Thu, 28 Sep 2006 00:12:50 -0700 (PDT)
From: "Myrna van Lunteren (JIRA)" <derby-dev@db.apache.org>
To: derby-dev@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)
In-Reply-To: <22219542.1158196282302.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

    [ http://issues.apache.org/jira/browse/DERBY-1849?page=comments#action_12438340 ] 
            
Myrna van Lunteren commented on DERBY-1849:
-------------------------------------------

I do not think this is a simple master update. There are some really odd diffs, for instance, the section in grantRevokeDDL.sql where a trigger tr31t31TriggerTest is created:
-------------
ij(MAMTA3)> -- 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);
------------
With foundation results in: 
                  ERROR: Failed with SQLSTATE 28508
But it should just succeed.
(this then of course causes more diffs because there is no trigger to get fired)

There may be some other genuine problem further down, it's hard to say because of the various inter-dependencies of objects in the test.

I wonder if the same problems would show up with just DataSource testing (i.e. irrespective of j9_foundation)?


> 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