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

Reply via email to