You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by my...@apache.org on 2007/03/14 23:29:51 UTC
svn commit: r518362 -
/db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/grantRevokeDDL.out
Author: myrnavl
Date: Wed Mar 14 15:29:50 2007
New Revision: 518362
URL: http://svn.apache.org/viewvc?view=rev&rev=518362
Log:
DERBY-2325; forgotten master-canon update for j9_foundation related to new
test for DERBY-1847.
Modified:
db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/grantRevokeDDL.out
Modified: db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/grantRevokeDDL.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/grantRevokeDDL.out?view=diff&rev=518362&r1=518361&r2=518362
==============================================================================
--- db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/grantRevokeDDL.out (original)
+++ db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/grantRevokeDDL.out Wed Mar 14 15:29:50 2007
@@ -3216,4 +3216,32 @@
IJ ERROR: Unable to establish cursor
ij(USER2)> autocommit on;
ij(USER2)> set connection user1;
+ij(USER1)> -- Another test for DERBY-1847: verify that columns field is updated
+-- correctly when adding a column to a table:
+create table d1847_c (a int, b int, c int);
+0 rows inserted/updated/deleted
+ij(USER1)> grant select (a) on d1847_c to first_user;
+0 rows inserted/updated/deleted
+ij(USER1)> grant update (b) on d1847_c to second_user;
+0 rows inserted/updated/deleted
+ij(USER1)> grant select (c) on d1847_c to third_user;
+0 rows inserted/updated/deleted
+ij(USER1)> select c.grantee, c.type, c.columns from sys.syscolperms c, sys.systables t
+ where c.tableid = t.tableid and t.tablename='D1847_C';
+GRANTEE |&|COLUMNS
+--------------------------------------------------------------------------------------------------------------------------------------------------
+FIRST_USER |s|{0}
+SECOND_USER |u|{1}
+THIRD_USER |s|{2}
+3 rows selected
+ij(USER1)> alter table d1847_c add column d int;
+0 rows inserted/updated/deleted
+ij(USER1)> select c.grantee, c.type, c.columns from sys.syscolperms c, sys.systables t
+ where c.tableid = t.tableid and t.tablename='D1847_C';
+GRANTEE |&|COLUMNS
+--------------------------------------------------------------------------------------------------------------------------------------------------
+FIRST_USER |s|{0}
+SECOND_USER |u|{1}
+THIRD_USER |s|{2}
+3 rows selected
ij(USER1)>