[
https://issues.apache.org/jira/browse/CALCITE-1668?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde updated CALCITE-1668:
---------------------------------
Description:
The {{RexUtil.simplify}} method should handle literal comparison
simplification. From [an
email|http://mail-archives.apache.org/mod_mbox/calcite-dev/201702.mbox/%3CCAJU9nmidm%3DiXNG46YhSthXaBG0CGfmtPraxU9MxEOxnCTTLa_A%40mail.gmail.com%3E]
on the calcite-dev mailing list:
{quote}
Calcite doesn't seem to optimize away the literal comparison literal case
with RexUtil.simplify. In my understanding any literal comparison literal
results in a simple TRUE/FALSE result.
I'm not sure this is valid in the general case, but I put together a simple
example of doing this on the RexUtil simplifyCall.
{quote}
https://github.com/apache/calcite/pull/376
was:
>From the calcite-dev mailing list:
Calcite doesn't seem to optimize away the literal comparison literal case
with RexUtil.simplify. In my understanding any literal comparison literal
results in a simple TRUE/FALSE result.
I'm not sure this is valid in the general case, but I put together a simple
example of doing this on the RexUtil simplifyCall.
https://github.com/apache/calcite/pull/376
Reference:
http://mail-archives.apache.org/mod_mbox/calcite-dev/201702.mbox/%3CCAJU9nmidm%3DiXNG46YhSthXaBG0CGfmtPraxU9MxEOxnCTTLa_A%40mail.gmail.com%3E
> Simplify "1 = 1" to true, "1 > 2" to false
> ------------------------------------------
>
> Key: CALCITE-1668
> URL: https://issues.apache.org/jira/browse/CALCITE-1668
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Reporter: Kevin Risden
> Assignee: Julian Hyde
> Priority: Minor
> Fix For: 1.12.0
>
>
> The {{RexUtil.simplify}} method should handle literal comparison
> simplification. From [an
> email|http://mail-archives.apache.org/mod_mbox/calcite-dev/201702.mbox/%3CCAJU9nmidm%3DiXNG46YhSthXaBG0CGfmtPraxU9MxEOxnCTTLa_A%40mail.gmail.com%3E]
> on the calcite-dev mailing list:
> {quote}
> Calcite doesn't seem to optimize away the literal comparison literal case
> with RexUtil.simplify. In my understanding any literal comparison literal
> results in a simple TRUE/FALSE result.
> I'm not sure this is valid in the general case, but I put together a simple
> example of doing this on the RexUtil simplifyCall.
> {quote}
> https://github.com/apache/calcite/pull/376
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)