Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <17547799.1155045256030.JavaMail.jira@brutus>
Date: Tue, 8 Aug 2006 06:54:16 -0700 (PDT)
From: "John H. Embretsen (JIRA)" <derby-dev@db.apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Updated: (DERBY-1649) lang/wisconsin.java   fails with
 different cursor names
In-Reply-To: <10563673.1154737573869.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

     [ http://issues.apache.org/jira/browse/DERBY-1649?page=all ]

John H. Embretsen updated DERBY-1649:
-------------------------------------

    Attachment: derby-1649-sed_v1.diff

Attatching patch 'derby-1649-sed_v1.diff', which modifies the following file:

M      java/testing/org/apache/derbyTesting/functionTests/tests/lang/wisconsin_sed.properties


The problem was that the last digit in the cursor name represented by 

SQL_CURLH000C6 

in the wisconsin_sed.properties file is varying between platforms (frameworks, jvm versions, OS,etc.). I have seen both 2, 5, 6 and 7 as the last digit when running this test, or in diffs from the daily/nightly regression tests.

With revision 428252, the last digit to be accepted for filtering by the test harness was changed from 1 to 6.

My patch allows cursor names with last digits varying from 1 through 9 to be filtered out:

SQL_CURLH000C[1-9];C

I don't know much about cursor names or which values should not be allowed, if any, so if you feel that this solution is not adequate, feel free to reassign the issue and/or to make informative comments.

On my desktop, this test failed with wrong cursor name with sun's JVM 1.4.2, but not with 1.5.0 or 1.6.0 (beta). I have tested the patch by running the wisconsin test in those three JVMs in embedded and DerbyNetClient frameworks. Tests were successful.

Please review/commit this patch.

Thanks!


> lang/wisconsin.java   fails with different cursor names
> -------------------------------------------------------
>
>                 Key: DERBY-1649
>                 URL: http://issues.apache.org/jira/browse/DERBY-1649
>             Project: Derby
>          Issue Type: Bug
>          Components: Test, Regression Test Failure
>    Affects Versions: 10.2.0.0
>         Environment: ------------------ Java Information ------------------
> Java Version:    1.5.0_06
> Java Vendor:     Sun Microsystems Inc.
> Java home:       /local1/cloudtst/dev/src/jdk15/jre
> Java classpath: [Line-breaks inserted to improve Jira readability] 
> /local1/cloudtst/dev/src/jars/insane/derby.jar:
> /local1/cloudtst/dev/src/jars/insane/derbytools.jar:
> /local1/cloudtst/dev/src/jars/insane/derbynet.jar:
> /local1/cloudtst/dev/src/jars/insane/derbyclient.jar:
> /local1/cloudtst/dev/src/jars/insane/derbyTesting.jar:
> /local1/cloudtst/dev/src/jcc/db2jcc.jar:
> /local1/cloudtst/dev/src/jcc/db2jcc_license_c.jar:
> /local1/cloudtst/dev/src/jars/insane/derbyTesting.jar:
> /local1/cloudtst/dev/src/tools/java/jakarta-oro-2.0.8.jar:
> /local1/cloudtst/dev/src/tools/java/junit.jar:
> /local1/cloudtst/dev/src/jars/insane/derbyLocale_de_DE.jar:
> /local1/cloudtst/dev/src/jars/insane/derbyLocale_es.jar:
> /local1/cloudtst/dev/src/jars/insane/derbyLocale_fr.jar:
> /local1/cloudtst/dev/src/jars/insane/derbyLocale_it.jar:
> /local1/cloudtst/dev/src/jars/insane/derbyLocale_ja_JP.jar:
> /local1/cloudtst/dev/src/jars/insane/derbyLocale_ko_KR.jar:
> /local1/cloudtst/dev/src/jars/insane/derbyLocale_pt_BR.jar:
> /local1/cloudtst/dev/src/jars/insane/derbyLocale_zh_CN.jar:
> /local1/cloudtst/dev/src/jars/insane/derbyLocale_zh_TW.jar:
> /local1/cloudtst/dev/src/jars/insane/derbyrun.jar:
> OS name:         Linux
> OS architecture: i386
> OS version:      2.6.5-7.257-bigsmp
> Java user name:  cloudtst
> Java user home:  /u/cloudtst
> Java user dir:   /local1/cloudtst/dev/src/NightlyBuildResults.2006-08-03/jdk15_derbyall
> java.specification.name: Java Platform API Specification
> java.specification.version: 1.5
> --------- Derby Information --------
> JRE - JDBC: J2SE 5.0 - JDBC 3.0
> [/local1/cloudtst/dev/src/jars/insane/derby.jar] 10.2.0.5 alpha - (428586)
> [/local1/cloudtst/dev/src/jars/insane/derbytools.jar] 10.2.0.5 alpha - (428586)
> [/local1/cloudtst/dev/src/jars/insane/derbynet.jar] 10.2.0.5 alpha - (428586)
> [/local1/cloudtst/dev/src/jars/insane/derbyclient.jar] 10.2.0.5 alpha - (428586)
> [/local1/cloudtst/dev/src/jcc/db2jcc.jar] 2.6 - (90)
> [/local1/cloudtst/dev/src/jcc/db2jcc_license_c.jar] 2.6 - (90)
> ------------------------------------------------------
> ----------------- Locale Information -----------------
>            Reporter: Sunitha Kambhampati
>         Assigned To: John H. Embretsen
>             Fix For: 10.2.0.0
>
>         Attachments: derby-1649-sed_v1.diff
>
>
> *** Start: wisconsin jdk1.5.0_06 DerbyNetClient derbynetmats:derbynetmats 2006-08-04 00:47:14 ***
> 41 del
> < 	C
> 41a41
> > 	SQL_CURLH000C7
> 102 del
> ....
> -----------------------------
> This diff first started occurring on Aug 3 nightly run.change between (428211)
>  and 10.2.0.5 alpha - (428586)
> My first guess is, this may be related to this checkin
> ------------------------------------------------------------------------
> r428252 | djd | 2006-08-02 22:58:44 -0700 (Wed, 02 Aug 2006) | 3 lines
> DERBY-1609 (partial) Change the lang/wisconsin.java test to use the new ij.runScript method
> rather than its previous use of the utilMain.go method. Change the sed commands because the
> cursor names are different in the output due to the use of a connection in a different state.
> ------------------------------------------------------------------------

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira