db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Myrna van Lunteren (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4038) On Z/OS store/access.sql fails with encryptionAES and encryptionDES
Date Fri, 04 Dec 2009 00:31:20 GMT

    [ https://issues.apache.org/jira/browse/DERBY-4038?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12785672#action_12785672
] 

Myrna van Lunteren commented on DERBY-4038:
-------------------------------------------

I've been working on converting access.sql; and I noticed that section testing "partial row
runtime statistics" actually has a section that's not doing what it was meant to do judging
by the comments; it looks as if there's supposed to be 4 iterations
 - no index
 - with index
 - no index, deleted rows
 - with index, deleted rows
But, because the index does not get dropped anywhere, we get an error creating the index for
the fourth iteration, and the 3rd and 4th iterations are exactly the same. 
Perhaps the 4th iteration was copied by mistake, for I see that without index, you don't see
the "deleted rows visited" line in the statistics. 
Still, when running the queries without an index but with deleted rows the statistics show
a different (higher) number of total rows visited, so I'll be modifying the converted test
to exercise that combination too.


> On Z/OS store/access.sql fails with encryptionAES and encryptionDES
> -------------------------------------------------------------------
>
>                 Key: DERBY-4038
>                 URL: https://issues.apache.org/jira/browse/DERBY-4038
>             Project: Derby
>          Issue Type: Bug
>          Components: Test
>    Affects Versions: 10.3.3.0
>         Environment: java version "1.6.0"
> Java(TM) SE Runtime Environment (build pmz6460sr3-20081108_01(SR3))
> IBM J9 VM (build 2.4, J2RE 1.6.0 IBM J9 2.4 z/OS s390x-64 jvmmz6460-20081107_25433 (JIT
enabled, AOT enabled)
> J9VM - 20081105_025433_BHdSMr
> JIT  - r9_20081031_1330
> GC   - 20081027_AB)
> JCL  - 20081106_01
> $ pwd
>            Reporter: Kathey Marsden
>            Priority: Minor
>         Attachments: access.diff, access.out
>
>
> On Z/OS access.sql fails for encryptionAES and encryptionDES. The diff is big but I can't
quite make out what the problem is. Maybe just a change of query plans.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message