[
https://issues.apache.org/jira/browse/CALCITE-7088?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18005032#comment-18005032
]
Yu Xu edited comment on CALCITE-7088 at 7/14/25 2:47 AM:
---------------------------------------------------------
[~julianhyde] Yes, summary is not fitable, and I had changed to "Multiple
consecutive '%' in the string matched by LIKE should simplify to a single '%'",
which seems to be more in line with this issue, and I checked the relevant
logic, it should be very concise now, and all cases should have be covered.
was (Author: JIRAUSER307770):
[~julianhyde] Yes, summary is not fitable, and I had changed to "Multiple
consecutive '%' in the string matched by LIKE should simplify to a single '%'",
which seems to be more in line with this issue, and I checked the relevant
logic, it should be very concise now, and all cases should have be covered now.
> Multiple consecutive '%' in the string matched by LIKE should simplify to a
> single '%'
> --------------------------------------------------------------------------------------
>
> Key: CALCITE-7088
> URL: https://issues.apache.org/jira/browse/CALCITE-7088
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.40.0
> Reporter: Yu Xu
> Assignee: Yu Xu
> Priority: Minor
> Labels: pull-request-available
> Fix For: 1.41.0
>
>
> sql:
> {code:java}
> "select \"net_weight\" like '%' from \"product\""{code}
> would convert as expected:
> {code:java}
> "SELECT NULL OR \"net_weight\" IS NOT NULL\nFROM
> \"foodmart\".\"product\""{code}
> but sql：
> {code:java}
> "select \"net_weight\" like '%%' from \"product\""{code}
> would convert not as expected:
> {code:java}
> "SELECT \"net_weight\" LIKE '%%'\nFROM \"foodmart\".\"product\"" ;{code}
>
> *note: "x = x" simplifies to "null or x is not null"*
>
> LIKE '%%' (with any number of '%') should keep the same with LIKE '%'
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
