[
https://issues.apache.org/jira/browse/CALCITE-7328?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated CALCITE-7328:
------------------------------------
Labels: pull-request-available (was: )
> Support SCALAR_QUERY in RelMdExpressionLineage
> ----------------------------------------------
>
> Key: CALCITE-7328
> URL: https://issues.apache.org/jira/browse/CALCITE-7328
> Project: Calcite
> Issue Type: Bug
> Reporter: xiong duan
> Priority: Major
> Labels: pull-request-available
>
> The SQL1:
> {code:java}
> select
> (select max(productid) from products_temporal) as maxValue,
> (select min(productid) from products_temporal) as minValue {code}
> The ExpressionLineage of this SQL is NULL.
> The SQL2:
> {code:java}
> select
> productid > (select max(productid) from products_temporal) as productidValues
> from products_temporal {code}
> The ExpressionLineage of this SQL is :
> {code:java}
> [>([CATALOG, SALES, PRODUCTS_TEMPORAL].#0.$0,
> $SCALAR_QUERY({\nLogicalAggregate(group=[{}], EXPR$0=[MAX($0)])\r\n
> LogicalProject(PRODUCTID=[$0])\r\n LogicalTableScan(table=[[CATALOG,
> SALES, PRODUCTS_TEMPORAL]])\r\n}))]{code}
> There are two issues here:
> # SQL1 should return result.
> # Whether or not to unwrap the SCALAR_QUERY. For example in SQL2 like this:
> {code:java}
> [>([CATALOG, SALES, PRODUCTS_TEMPORAL].#0.$0,MAX[CATALOG, SALES,
> PRODUCTS_TEMPORAL].#0.$0{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
