ZheHu created CALCITE-6070:
------------------------------
Summary: Missing column alia after RelFieldTrimmer
Key: CALCITE-6070
URL: https://issues.apache.org/jira/browse/CALCITE-6070
Project: Calcite
Issue Type: Wish
Components: core
Affects Versions: 1.35.0
Reporter: ZheHu
Run the following SQL in SqlToRelConverterTest:
{code}
select ename as did from emp where ename='a' limit 10
{code}
Got planA without RelFieldTrimmer:
{code}
LogicalSort(fetch=[10])
LogicalProject(DID=[$1])
LogicalFilter(condition=[=($1, 'a')])
LogicalTableScan(table=[[CATALOG, SALES, EMP]])
{code}
Got planB with RelFieldTrimmer:
{code}
LogicalSort(fetch=[10])
LogicalFilter(condition=[=($0, 'a')])
LogicalProject(ENAME=[$1])
LogicalTableScan(table=[[CATALOG, SALES, EMP]])
{code}
However, the column alia DID for ENAME is missing in planB.
Maybe we can do something about the trimmer when we have other
purposes(renaming column is the only purpose for this case).
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
