[DERBY-2325] lang/grantRevokeDDL.sql is failing on wctme5.7_foundation jvm ...

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.2.2.1
• Fix Version/s: 10.2.2.1
• Component/s: Test

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

• Assignee: Myrna van Lunteren
• Reporter: Suresh Thalamati
• Created: 13/Feb/07 02:04
• Updated: 01/Jul/09 00:09
• Resolved: 14/May/07 17:43

Description

• • • 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-