Zhengqiang Duan created CALCITE-6678:
----------------------------------------
Summary: 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
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)
