db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "A B (JIRA)" <derby-...@db.apache.org>
Subject [jira] Updated: (DERBY-1109) lang/predicatePushdown.sql fails with wsdd5.6
Date Wed, 15 Mar 2006 18:20:58 GMT
     [ http://issues.apache.org/jira/browse/DERBY-1109?page=all ]

A B updated DERBY-1109:
-----------------------

    Attachment: d1109.patch
                d1109.stat

Based on comments from Satheesh and Mike at this thread:

http://article.gmane.org/gmane.comp.apache.db.derby.devel/16656

it seems like there is agreement that the resolution for this diff is to simply add an "ORDER
BY" clause to the affected queries.  The attached patch does just that.  Note that the diffs
might seem larger than expected, but that's because the order by has added a level of nesting
to the query plan, which affects spacing and hence creates a larger diff.

I ran lang/subquery.sql and lang/predicatePushdown.sql against IBM wsdd5.6, IBM 1.4.2, and
Sun 1.5 and both tests passed for all three JVMs.

There are no code changes in this patch, so if a committer could look it over and commit,
that'd be great. 

Thanks again to Mike for the input/explanation of what was going on here.  I appreciate it.

> lang/predicatePushdown.sql fails with wsdd5.6
> ---------------------------------------------
>
>          Key: DERBY-1109
>          URL: http://issues.apache.org/jira/browse/DERBY-1109
>      Project: Derby
>         Type: Test
>   Components: Regression Test Failure
>     Versions: 10.2.0.0
>  Environment: IBM wsdd5.6 j9_13
>     Reporter: Deepa Remesh
>  Attachments: d1109.patch, d1109.stat
>
> This test fails with the following diff:
> 7507a7508,7509
> > 2          |1          
> > 4          |2          
> 7509,7510d7510
> < 4          |2          
> < 2          |1          
> 7632a7633,7636
> > 2          |1          
> > 2          |1          
> > 4          |2          
> > 4          |2          
> 7635,7638d7638
> < 4          |2          
> < 4          |2          
> < 2          |1          
> < 2          |1     

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message