[
https://issues.apache.org/jira/browse/CALCITE-1794?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17498195#comment-17498195
]
Julian Hyde edited comment on CALCITE-1794 at 2/25/22, 4:14 PM:
----------------------------------------------------------------
I mean that while unit tests may not pass, it's likely that system tests will
do the right thing, because they use SARGs.
Let me know whether my assumptions are correct. If they're not correct, give
examples of SQL statements that should be optimized but are not.
was (Author: julianhyde):
I mean that while unit tests may not pass, it's likely that system tests will
do the right thing, because they use SARGs.
> Simplify AND numeric comparisons when overlapping
> -------------------------------------------------
>
> Key: CALCITE-1794
> URL: https://issues.apache.org/jira/browse/CALCITE-1794
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Affects Versions: 1.29.0
> Reporter: Remus Rusanu
> Assignee: xiong duan
> Priority: Major
> Labels: pull-request-available
> Time Spent: 20m
> Remaining Estimate: 0h
>
> Expressions such as {{$1<>1 and $1=2}} can be simplified to {{$1=2}}. Similar
> {{$1>10 AND $1>20}} can be simplified to {{$1>20}}. Such expressions are
> produced by the proposed solution for CALCITE-1790 (simplify boolean CASE to
> complex AND/OR).
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
