db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lily Wei (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-4641) aggregateOptimization.sql fails on z/os with pmz3160sr5 with double quote and question mark output in runtime statistics
Date Thu, 17 Feb 2011 17:21:24 GMT

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

Lily Wei updated DERBY-4641:
----------------------------

    Urgency: Normal
     Labels: derby_triage10_8  (was: )

> aggregateOptimization.sql fails on z/os with  pmz3160sr5 with double quote and question
mark output in runtime statistics
> -------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-4641
>                 URL: https://issues.apache.org/jira/browse/DERBY-4641
>             Project: Derby
>          Issue Type: Bug
>          Components: Tools
>         Environment: $ java -version
> java version "1.6.0"
> Java(TM) SE Runtime Environment (build pmz3160sr5-20090604_01(SR5))
> IBM J9 VM (build 2.4, J2RE 1.6.0 IBM J9 2.4 z/OS s390-31 jvmmz3160sr5-20090519_3
> 5743 (JIT enabled, AOT enabled)
> J9VM - 20090519_035743_bHdSMr
> JIT  - r9_20090518_2017
> GC   - 20090417_AA)
> JCL  - 20090529_01
> $
>            Reporter: Kathey Marsden
>            Priority: Minor
>              Labels: derby_triage10_8
>         Attachments: aggregateOptimizationOutputAfterAsciiFtp.zip, aggregateOptimizationOutputAsOnZos.zip
>
>
> With this one test and  pmz3160sr5-20090604_01(SR5) the output  of runtime statistics
has double quote and question mark garbage, e.g
> Source result set:
> """"????"Scalar Aggregate ResultSet:
> """"????"Number of opens = 1
> """"????"Rows input = 1
> "       ""????"constructor time (milliseconds) = 0
> "       ""????"open time (milliseconds) = 0
> "       ""????"next time (milliseconds) = 0
> "       ""????"close time (milliseconds) = 0
> "       ""????"optimizer estimated row count:           15.00
> "       ""????"optimizer estimated cost:           21.13
> """"????"Index Key Optimization = true
> """"????"Source result set:
> Looking manually at the plans, they look fine.  I  think this is likely a JVM issue,
but don't know actually if it is impacting the test harness, ij, or derby itself.   I did
not see this with the 64 bit sr5 jvm, nor did I see it in 10.5 runs with earlier versions
of the jvm.  

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message