[
https://issues.apache.org/jira/browse/CALCITE-3155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16883295#comment-16883295
]
Julian Hyde commented on CALCITE-3155:
--------------------------------------
As I feared, this has broken stuff, because not all databases have a DUAL
table. I now get an error when running against MySQL.
{noformat}
java.lang.RuntimeException: while executing SQL: SELECT
NULL AS `users.name`
FROM `DUAL`
WHERE 1 = 0, (conn=5) Table 'looker_test.dual' doesn't exist
at ...
Caused by: java.sql.SQLSyntaxErrorException: (conn=5) Table 'looker_test.dual'
doesn't exist
{noformat}
> 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)
