[
https://issues.apache.org/jira/browse/CALCITE-3960?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17093806#comment-17093806
]
Julian Hyde commented on CALCITE-3960:
--------------------------------------
I believe that Oracle will fail with 'select dummy from dual as d' but will
succeed with 'select dummy from dual d'.
Oracle allows (but does not require) 'as' in the SELECT clause but does not
allow or require 'as' in the FROM clause.
So, I think {{allowsAs()}} should continue to return false.
I don't know about Spark dialect.
> Oracle and SparkSql dialect allow as
> ------------------------------------
>
> Key: CALCITE-3960
> URL: https://issues.apache.org/jira/browse/CALCITE-3960
> Project: Calcite
> Issue Type: Wish
> Reporter: xzh_dz
> Priority: Major
> Time Spent: 10m
> Remaining Estimate: 0h
>
> In Oracle SqlDialect and SparkSql SqlDialect allowsAs() method should return
> true.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
