Laljo John Pullokkaran created CALCITE-993:
----------------------------------------------
Summary: Predicate Pull up on Project enhancement
Key: CALCITE-993
URL: https://issues.apache.org/jira/browse/CALCITE-993
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.5.0
Reporter: Laljo John Pullokkaran
Assignee: Laljo John Pullokkaran
Predicate Pull up on Project can also pull up deterministic functions whose
arguments are all literals.
Ex: select r1.x from (select cast('10' as int) as x, y from r1 where y<10)r1
join r2 on r1.x=r2.x;
Currently deterministic functions involving constants are ignored which results
in missed transitive inference.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
