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
Priority: Minor
*** 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.
