[
https://issues.apache.org/jira/browse/CALCITE-7153?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated CALCITE-7153:
------------------------------------
Labels: pull-request-available (was: )
> 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
> Labels: pull-request-available
>
> 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)
