Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <4055636.1179164656240.JavaMail.jira@brutus>
Date: Mon, 14 May 2007 10:44:16 -0700 (PDT)
From: "Myrna van Lunteren (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Reopened: (DERBY-2325) lang/grantRevokeDDL.sql is failing on
  wctme5.7_foundation jvm ...
In-Reply-To: <25424140.1171332306068.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/DERBY-2325?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Myrna van Lunteren reopened DERBY-2325:
---------------------------------------


> 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
>          Components: 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.