You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Julian Hyde (Jira)" <ji...@apache.org> on 2019/12/16 21:27:00 UTC
[jira] [Commented] (CALCITE-3596) Sql query in javadoc of OverScope
class has syntax error
[ https://issues.apache.org/jira/browse/CALCITE-3596?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16997655#comment-16997655 ]
Julian Hyde commented on CALCITE-3596:
--------------------------------------
OVER in the FROM clause is a possible extension for streaming SQL. It is not supported by the default parser or validator, and thus OverScope is never instantiated. But extension projects with their own parser could use it.
> Sql query in javadoc of OverScope class has syntax error
> --------------------------------------------------------
>
> Key: CALCITE-3596
> URL: https://issues.apache.org/jira/browse/CALCITE-3596
> Project: Calcite
> Issue Type: Bug
> Reporter: Wang Yanlin
> Priority: Minor
>
> The sql in class of OverScope (https://github.com/apache/calcite/blob/master/core/src/main/java/org/apache/calcite/sql/validate/OverScope.java#L33) has syntax error, cause SqlParseException
> {code:java}
> // SqlToRelConverterTest
> @Test public void testOver() {
> /*
> final String sql = "SELECT * FROM\n"
> + "(SELECT deptno, count(*) OVER (ORDER BY empno RANGE BETWEEN 2 PRECEDING AND 2 FOLLOWING) FROM emp) ";
> */
> final String sql = "SELECT name FROM\n"
> + "(SELECT * FROM\n"
> + "emp OVER (ORDER BY empno RANGE BETWEEN 2 PRECEDING AND 2 FOLLOWING))";
> sql(sql).ok();
> }
> {code}
> got
> {code:java}
> Caused by: org.apache.calcite.sql.parser.impl.ParseException: Encountered "OVER" at line 3, column 5.
> Was expecting one of:
> "AS" ...
> "EXCEPT" ...
> "EXTEND" ...
> "FETCH" ...
> "FOR" ...
> "GROUP" ...
> "HAVING" ...
> "INTERSECT" ...
> "LIMIT" ...
> "MATCH_RECOGNIZE" ...
> "OFFSET" ...
> "ORDER" ...
> "MINUS" ...
> "TABLESAMPLE" ...
> "UNION" ...
> "WHERE" ...
> "WINDOW" ...
> "(" ...
> ")" ...
> <BRACKET_QUOTED_IDENTIFIER> ...
> <QUOTED_IDENTIFIER> ...
> <BACK_QUOTED_IDENTIFIER> ...
> <IDENTIFIER> ...
> <UNICODE_QUOTED_IDENTIFIER> ...
> <HINT_BEG> ...
> "NATURAL" ...
> "JOIN" ...
> "INNER" ...
> "LEFT" ...
> "RIGHT" ...
> "FULL" ...
> "CROSS" ...
> "," ...
> "OUTER" ...
> "." ...
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)