You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Myrna van Lunteren (JIRA)" <ji...@apache.org> on 2009/12/04 01:31:20 UTC
[jira] Commented: (DERBY-4038) On Z/OS store/access.sql fails with
encryptionAES and encryptionDES
[ 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.