Yu Xu created CALCITE-7153:
------------------------------
Summary: 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
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)
