Julian Hyde created CALCITE-445:
-----------------------------------

             Summary: Pull up filters rejected by a ProjectableFilterableTable 
                 Key: CALCITE-445
                 URL: https://issues.apache.org/jira/browse/CALCITE-445
             Project: Calcite
          Issue Type: Bug
            Reporter: Julian Hyde
            Assignee: Julian Hyde


Suppose that {{t (i, j, k)}} is a table that implements 
ProjectableFilterableTable, we execute the query {{select k from t where j = 
1}}, and {{t}} refuses to evaluate the filter {{j = 1}}.

We should still push the project to the table. But we need to project the extra 
column, {{j}} needed by the filter, and transform it, because it now occurs 
after the project.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to