[
https://issues.apache.org/jira/browse/CALCITE-7153?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18017806#comment-18017806
]
Yu Xu commented on CALCITE-7153:
--------------------------------
Thanks，this is indeed the case. I agree with this point of view. I would write
a PR based on this to support this simplification.
> Mixed wildcards of _ and % need to be simplified in LIKE operator
> -----------------------------------------------------------------
>
> Key: CALCITE-7153
> URL: https://issues.apache.org/jira/browse/CALCITE-7153
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Affects Versions: 1.40.0
> Reporter: Yu Xu
> Assignee: Yu Xu
> Priority: Minor
>
> Mixed wildcards of _ and % need to be simplified in LIKE operator, such as :
>
> {code:java}
> %_%__ can be simplied to %___
> %__%__%_ can be simplied to %_____{code}
> involving % and _ can be simplified by removing all % except 1
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
