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)
