[ https://issues.apache.org/jira/browse/CALCITE-993?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Julian Hyde resolved CALCITE-993. --------------------------------- Resolution: Fixed Fix Version/s: 1.6.0 Fixed in http://git-wip-us.apache.org/repos/asf/calcite/commit/9be2bdb9, with some clean up in http://git-wip-us.apache.org/repos/asf/calcite/commit/8281668f. > Predicate Pull up above 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 > Fix For: 1.6.0 > > > 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)