db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-3686) convert predicatePushdown.sql to JUnit
Date Thu, 29 May 2008 18:13:45 GMT

     [ https://issues.apache.org/jira/browse/DERBY-3686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Kathey Marsden updated DERBY-3686:
----------------------------------

    Attachment: derby-3686_rts_diff.txt

Attached is a patch that adds the Runtime Statistics parsing for PredicatePushdownTest.  There
is still one case that I have not figured out how to parse yet.
  // Nested unions with non-join predicates should work as
        // usual (no change with DERBY-805). So should see scalar
        // qualifiers on scans for all instances of T1 and T2.
I marked this with a //RESOLVE comment in the test.

Any tips on how to parse that would be appreciated. Also I would appreciate if someone could
review the test to make sure I am checking the right things for the other queries.  I based
what I checked for on the comments and the predicatePushdown.out master file.  Hopefully the
checks are sufficient.

Kathey




> convert predicatePushdown.sql  to JUnit
> ---------------------------------------
>
>                 Key: DERBY-3686
>                 URL: https://issues.apache.org/jira/browse/DERBY-3686
>             Project: Derby
>          Issue Type: Task
>          Components: Test
>    Affects Versions: 10.5.0.0
>            Reporter: Kathey Marsden
>            Assignee: Kathey Marsden
>            Priority: Minor
>         Attachments: derby-3686_initial_conv_diff.txt, derby-3686_rts_diff.txt
>
>
> predicatePushdown.sql fails intermittently in the nightlies ( DERBY-1902) with a plan
variance. It would be good to convert it to JUnit and extract only the relevant information
from RuntimeStatistics output.  This might make the test more stable.

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