db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-4650) Predicates in HAVING clause should be pushed down to restricted VTIs
Date Tue, 11 May 2010 11:28:41 GMT

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

Knut Anders Hatlen updated DERBY-4650:

    Attachment: test.diff

The attached patch adds a test case to RestrictedVTITest that shows that the predicate is
not pushed in the following query:

    select s_r, count(*) from table(integerList()) t group by s_r having s_r > 1

Only the rows with s_r > 1 have to be returned by the table function integerList, so pushing
the predicate could be useful.

Committed the new test case to trunk with revision 943088.

> Predicates in HAVING clause should be pushed down to restricted VTIs
> --------------------------------------------------------------------
>                 Key: DERBY-4650
>                 URL: https://issues.apache.org/jira/browse/DERBY-4650
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions:
>            Reporter: Knut Anders Hatlen
>            Priority: Minor
>         Attachments: test.diff
> If you perform a query with an aggregate function against a restricted table function,
the predicates in the HAVING clause are not pushed down to the table function.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message