[
https://issues.apache.org/jira/browse/CALCITE-935?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde resolved CALCITE-935.
---------------------------------
Resolution: Fixed
Fixed in
http://git-wip-us.apache.org/repos/asf/incubator-calcite/commit/690faa55.
Thanks for the patch, [~pxiong]!
> Improve how ReduceExpressionsRule handles duplicate constraints
> ---------------------------------------------------------------
>
> Key: CALCITE-935
> URL: https://issues.apache.org/jira/browse/CALCITE-935
> Project: Calcite
> Issue Type: Bug
> Reporter: Pengcheng Xiong
> Assignee: Pengcheng Xiong
> Fix For: 1.5.0
>
> Attachments: CALCITE-935.01.patch
>
>
> We need to improve ReduceExpressionRule to deal with multiple "equals to
> literal" in predicate. In ReduceExpressionRule.java, L396-397:
> {code}final ImmutableMap<RexNode, RexLiteral> constants =
> predicateConstants(predicates);{code}
> The query is {code}select * from src where (key='12' and key is null);{code}
> Here 'key' is a string type and it is one of the columns of 'src' table.
> Then we will have predicates {noformat}[=($0, '12'),
> isnull($0)]{noformat}which is the input of the
> predicateConstants, and the function will return "{$0='12'}"
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
