[
https://issues.apache.org/jira/browse/CALCITE-6678?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mihai Budiu resolved CALCITE-6678.
----------------------------------
Fix Version/s: 1.39.0
Resolution: Fixed
Fixed in
https://github.com/apache/calcite/commit/f2ec11fe7e23ecf2db903bc02c40609242993aad
Thank you for the contribution [~duanzhengqiang]
Thank you for the review [~caicancai]
> Calcite should support dual table query when db provides this feature
> ---------------------------------------------------------------------
>
> Key: CALCITE-6678
> URL: https://issues.apache.org/jira/browse/CALCITE-6678
> Project: Calcite
> Issue Type: Improvement
> Reporter: Zhengqiang Duan
> Assignee: Zhengqiang Duan
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.39.0
>
>
> Currently, both MySQL and Oracle support SQL like SELECT 1 + 1 FROM DUAL.
> When I tried to execute it in Calcite, the following exception occurred:
> {code:java}
> From line 1, column 19 to line 1, column 22: Object 'DUAL' not found {code}
> DUAL tables are commonly used in Oracle, and since Oracle requires that FROM
> be specified, I think we should support it.
> Here are some documents related to the DUAL table:
> * Oracle:
> [https://docs.oracle.com/en/database/oracle/oracle-database/23/sqlrf/Selecting-from-the-DUAL-Table.html]
> * MySQL: [https://dev.mysql.com/doc/refman/5.7/en/select.html]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
