db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John H. Embretsen (JIRA)" <derby-...@db.apache.org>
Subject [jira] Updated: (DERBY-1649) lang/wisconsin.java fails with different cursor names
Date Tue, 08 Aug 2006 13:54:16 GMT
     [ 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

        

Mime
View raw message