[ https://issues.apache.org/jira/browse/DERBY-2325?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Knut Anders Hatlen closed DERBY-2325. ------------------------------------- Resolution: Fixed Fix Version/s: (was: 10.2.2.0) 10.2.2.1 Changing fix version (10.2.2.1 is listed under "Unreleased Versions") > lang/grantRevokeDDL.sql is failing on wctme5.7_foundation jvm ... > ------------------------------------------------------------------ > > Key: DERBY-2325 > URL: https://issues.apache.org/jira/browse/DERBY-2325 > Project: Derby > Issue Type: Test > Affects Versions: 10.2.2.1 > Environment: Java Version: J2ME Foundation Specification v1.0 > Java Vendor: IBM Corporation > Java home: c:\jartest\wctme5.7\ive > Java classpath: > c:/jartest/classes/derby.jar;c:/jartest/classes/derbyLocale_zh_TW.jar;c:/jartest/classes/derbyLocale_zh_CN.jar;c:/jartest/classes/derbyLocale_ru.jar;c:/jartest/classes/derbyLocale_pt_BR.jar;c:/jartest/classes/derbyLocale_pl.jar;c:/jartest/classes/derbyLocale_ko_KR.jar;c:/jartest/classes/derbyLocale_ja_JP.jar;c:/jartest/classes/derbyLocale_it.jar;c:/jartest/classes/derbyLocale_hu.jar;c:/jartest/classes/derbyLocale_fr.jar;c:/jartest/classes/derbyLocale_es.jar;c:/jartest/classes/derbyLocale_de_DE.jar;c:/jartest/classes/derbyLocale_cs.jar;c:/jartest/classes/derbytools.jar;c:/jartest/classes/derbynet.jar;c:/jartest/classes/derbyclient.jar;;c:/jartest/classes/derbyrun.jar;c:/jartest/classes/derbyTesting.jar;c:/jartest/classes/maps.jar;c:/jartest/classes/functionTests.jar;c:/jartest/classes/csext.jar;c:/jartest/tools/java/junit.jar;c:/jartest/tools/java/jndi/fscontext.jar > OS name: Windows 2000 > OS architecture: x86 > OS version: 5.0 build 2195 Service Pack 4 > Java user name: cloudtest > Java user home: C:\Documents and Settings\cloudtest > Java user dir: C:\jartest\JarResults.2007-01-18\wctme5.7_foundation_derbyall > java.specification.name: J2ME Foundation Specification > java.specification.version: 1.0 > --------- Derby Information -------- > JRE - JDBC: J2ME - JDBC for CDC/FP 1.0 > Reporter: Suresh Thalamati > Assigned To: Myrna van Lunteren > Priority: Minor > Fix For: 10.2.2.1 > > > *** Start: grantRevokeDDL jdkJ2ME Foundation Specification v1.0 > derbyall:derbylang 2007-01-19 03:25:27 *** > 3219 del > < ij(USER1)> > 3219 add > > 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)> > Test Failed. > *** End: grantRevokeDDL jdkJ2ME Foundation Specification v1.0 > derbyall:derbylang 2007-01- -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.