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 "A B (JIRA)" <ji...@apache.org> on 2008/03/05 20:17:44 UTC
[jira] Updated: (DERBY-3479) Changed/unexpected query plan when
running test 'lang/predicatePushdown.sql'
[ https://issues.apache.org/jira/browse/DERBY-3479?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
A B updated DERBY-3479:
-----------------------
Attachment: d3479_1.diff
Per Mike's suggestion in the above email, namely:
"solutions include [...] call compress table on all tables before query which will update all statistics and remove dependency on any outstanding per page row count updates"
I updated predicatePushdown.sql to compress all test tables before running any of the queries which expect a specific query plan. When I did that a lot of diffs showed up for predicatePushdown.out in the form of:
- Number of pages visited=1
+ Number of pages visited=2
I.e. seems we now visit one more page than we did without the compress. That seems a tad counter-intuitive to me (I figured compression would make it so that we visited fewer pages), but given my lack of knowledge here I'm assuming that's an okay diff.
With this change I ran predicatePushdown.sql 10 times using ibm15 and it passed every time. I'm not sure how useful that is, though, since this same machine ran 6 times in a row without failing even without this change...
Nonetheless, I'm posting the change as d3479_1.diff in case anyone has comments. I'll probably commit the patch sometime pretty soon since, even if it doesn't resolve this particular issue, it sounds like it's a good idea to compress the tables anyway (per Mike's email)...
> Changed/unexpected query plan when running test 'lang/predicatePushdown.sql'
> ----------------------------------------------------------------------------
>
> Key: DERBY-3479
> URL: https://issues.apache.org/jira/browse/DERBY-3479
> Project: Derby
> Issue Type: Bug
> Components: Regression Test Failure
> Affects Versions: 10.4.0.0
> Environment: OS: Solaris 10 6/06 s10x_u2wos_09a X86 64bits - SunOS 5.10 Generic_118855-14
> JVM: Sun Microsystems Inc., java version "1.6.0_04", Java(TM) SE Runtime Environment (build 1.6.0_04-b12), Java HotSpot(TM) Client VM (build 10.0-b19, mixed mode)
> Reporter: Ole Solberg
> Attachments: d3479_1.diff
>
>
> Seen in tinderbox since r631930.
> See e.g. http://dbtg.thresher.com/derby/test/tinderbox_trunk16/jvm1.6/testing/testlog/SunOS-5.10_i86pc-i386/631932-derbyall_diff.txt :
> *** Start: predicatePushdown jdk1.6.0_04 derbyall:derbylang 2008-02-28 14:02:49 ***
> 9285 del
> < Rows seen from the left = 20
> 9285a9285
> > Rows seen from the left = 10
> 9297 del
> < Rows seen from the right = 20
> 9297a9297
> > Rows seen from the right = 10
> 9299 del
> < Rows returned = 20
> 9299a9299
> > Rows returned = 10
> .
> .
> .
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.