Yu Xu created CALCITE-7042:
------------------------------
Summary: Trim function does not have idempotency simplification
Key: CALCITE-7042
URL: https://issues.apache.org/jira/browse/CALCITE-7042
Project: Calcite
Issue Type: Improvement
Components: core
Affects Versions: 1.39.0
Reporter: Yu Xu
Assignee: Yu Xu
Trim function does not have idempotency simplification currently,
trim(...trim(' aa ')) should be convert to trim(' aa ').
sql:
{code:java}
select trim(trim(' aa ')); {code}
plan:
{code:java}
EnumerableCalc(expr#0=[{inputs}], expr#1=[FLAG(BOTH)], expr#2=[' '], expr#3=['
aa '], expr#4=[TRIM($t1, $t2, $t3)], expr#5=[TRIM($t1, $t2, $t4)],
EXPR$0=[$t5]) {code}
should convert to plan:
{code:java}
EnumerableCalc(expr#0=[{inputs}], expr#1=[FLAG(BOTH)], expr#2=[' '], expr#3=['
aa '], expr#4=[TRIM($t1, $t2, $t3)], EXPR$0=[$t4])
EnumerableValues(tuples=[[{ 0 }]]) {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
