db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "A B (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-3479) Changed/unexpected query plan when running test 'lang/predicatePushdown.sql'
Date Wed, 05 Mar 2008 22:31:40 GMT

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

A B commented on DERBY-3479:
----------------------------

Thanks for the insight, Knut.  I don't know much about how it all works, but your theory seems
reasonable to me...for what very little that may be worth.

> Aren't all of these tables so small that they should fit on a single page?

I would think so, at least for the first part of the test.  I have no idea why that's not
the case--nor why compression appears to lead to an *extra* page...

I went ahead and committed d3479_1.diff with svn # 634064:

  URL: http://svn.apache.org/viewvc?rev=634064&view=rev

If it turns out the extra page is undesirable and/or the change is not a good one, then the
commit can always be backed out.

> 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.


Mime
View raw message