[
https://issues.apache.org/jira/browse/CALCITE-3155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16883437#comment-16883437
]
Julian Hyde commented on CALCITE-3155:
--------------------------------------
Partly my bad - I had overridden {{supportsAliasedValues}} to false in my
dialect object, so the code was assuming that my dialect was Oracle and has a
DUAL table.
But when I fix my dialect, I discover that VALUES unparsing does not work - and
never has - for MySQL. For MySQL we need to use SELECT-without-FROM, because it
does not allow VALUES in a query.
> 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)
