You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by "Yu Xu (Jira)" <ji...@apache.org> on 2025/08/30 16:15:00 UTC

[jira] [Created] (CALCITE-7153) Mixed wildcards of _ and % need to be simplified in LIKE operator

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)