[
https://issues.apache.org/jira/browse/CALCITE-2833?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16774660#comment-16774660
]
Julian Hyde commented on CALCITE-2833:
--------------------------------------
The DUAL table is an Oracle-specific hack. So, let's not mention it in
RelToSqlConverter or in the dialect. Let's just pretend that Oracle can
implement SELECT without FROM, and when the time comes to generate SQL, the
Oracle dialect will generate "SELECT ... FROM dual" rather than "SELECT ...".
If a dialect supports VALUES, we should use that in preference to
SELECT-without-FROM. (Maybe the code already does that.)
Please tidy up your comments so that they look like the rest of the code (e.g.
spaces after '//').
> Support for SELECT without FROM for different dialects
> ------------------------------------------------------
>
> Key: CALCITE-2833
> URL: https://issues.apache.org/jira/browse/CALCITE-2833
> Project: Calcite
> Issue Type: Improvement
> Components: jdbc-adapter
> Reporter: Stuti Gupta
> Priority: Major
> Labels: pull-request-available
> Time Spent: 0.5h
> Remaining Estimate: 0h
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
