[
https://issues.apache.org/jira/browse/CALCITE-3155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16883324#comment-16883324
]
Musbah EL FIL commented on CALCITE-3155:
----------------------------------------
I am not sure that this problem is due to my change:
* The query which depends on DUAL was added to a branch in the code that was
already using DUAL. It would generate a "SELECT NULL as X ... from DUAL where
false"
* The commit was modified to account for the cases where the dialect supports
aliased values. It would generate a query of the form "Select * from
VALUES(NULL, NULL ...) where 1=0"
So in summary, my changes should not output a query similar to the one that is
failing.
A stack trace of the exception would help to pinpoint the problem even further.
> AssertionError in RelToSqlConverter when visiting empty Values node
> -------------------------------------------------------------------
>
> Key: CALCITE-3155
> URL: https://issues.apache.org/jira/browse/CALCITE-3155
> Project: Calcite
> Issue Type: Bug
> Components: core
> Reporter: Musbah EL FIL
> Assignee: Danny Chan
> Priority: Minor
> Labels: pull-request-available
> Fix For: 1.21.0
>
> Time Spent: 1h 10m
> Remaining Estimate: 0h
>
> Given the query:
> *select A."department_id" from "foodmart"."employee" A where
> A."department_id" = ( select min( A."department_id") from
> "foodmart"."department" B where 1=2 )*
> The conversion from SqlNode to RelNode is correct, however when going from
> RelNode to SqlNode, an exception was being thrown.
>
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)
