[
https://issues.apache.org/jira/browse/CALCITE-7764?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
krooswu reassigned CALCITE-7764:
--------------------------------
Assignee: krooswu
> Allow explicit tables at top-level, e.g. "TABLE emp"
> ----------------------------------------------------
>
> Key: CALCITE-7764
> URL: https://issues.apache.org/jira/browse/CALCITE-7764
> Project: Calcite
> Issue Type: Bug
> Reporter: Julian Hyde
> Assignee: krooswu
> Priority: Major
>
> Calcite allows explicit tables (e.g. "{{{}TABLE emp{}}}") but not at
> top-level. "\{{SELECT * FROM (TABLE emp)}}" is valid but "\{{TABLE emp}}"
> throws:
> {code:java}
> TABLE emp;
> > java.sql.SQLException: Error while executing SQL "table emp": class
> > org.apache.calcite.sql.SqlBasicCall: TABLE `scott`.`EMP`
> > at org.apache.calcite.avatica.Helper.createException(Helper.java:56)
> ...
> > Caused by: java.lang.UnsupportedOperationException: class
> > org.apache.calcite.sql.SqlBasicCall: TABLE `scott`.`EMP`
> > at org.apache.calcite.util.Util.needToImplement(Util.java:1213)
> > at
> > org.apache.calcite.sql.validate.SqlValidatorImpl.getValidatedNodeType(SqlValidatorImpl.java:2274)
> > at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:279){code}
> Also allow {{TABLE emp ORDER BY deptno}}.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
