[
https://issues.apache.org/jira/browse/CALCITE-7153?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mihai Budiu resolved CALCITE-7153.
----------------------------------
Fix Version/s: 1.41.0
Resolution: Fixed
Fixed in
https://github.com/apache/calcite/commit/e352e933059ae4d895d8e943604ef40fb2a43e40
Thank you for your contribution [~xuzifu666]
> 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
> Fix For: 1.41.0
>
>
> 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)
