[CALCITE-7088] Multiple consecutive '%' in the string matched by LIKE should simplify to a single '%' - ASF JIRA

XML

Word

Printable

JSON

sql:

"select \"net_weight\" like '%' from \"product\""

would convert as expected:

"SELECT NULL OR \"net_weight\" IS NOT NULL\nFROM \"foodmart\".\"product\""

but sql：

"select \"net_weight\" like '%%' from \"product\""

would convert not as expected:

"SELECT \"net_weight\" LIKE '%%'\nFROM \"foodmart\".\"product\"" ;

note: "x = x" simplifies to "null or x is not null"

LIKE '%%' (with any number of '%') should keep the same with LIKE '%'

Blocked

CALCITE-4159 RexSimplify should simplify more always true OR expressions

links to

GitHub Pull Request #4460