[jira] [Created] (CALCITE-773) Satisfy multiple predicates in a scan-filter query using materializations

["Julian Hyde (JIRA)" <ji...@apache.org>]

Julian Hyde created CALCITE-773:
-----------------------------------

             Summary: Satisfy multiple predicates in a scan-filter query using materializations
                 Key: CALCITE-773
                 URL: https://issues.apache.org/jira/browse/CALCITE-773
             Project: Calcite
          Issue Type: Bug
            Reporter: Julian Hyde
            Assignee: Julian Hyde


In CALCITE-772 we translated a scan-filter query into a join on a scan-project-sort materialization. If there are predicates on multiple columns we need to translate to multiple joins.

For example, if there is an EMP table and indexes I_EMP_DEPTNO and I_EMP_GENDER then the query

{code}SELECT * FROM emp WHERE deptno IN (10, 20) AND gender = 'M'{code}

could be I_EMP_DEPTNO join I_EMP_GENDER join EMP (joining on empno in each case).




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