[jira] [Closed] (CALCITE-3596) Sql query in javadoc of OverScope class has syntax error

["Wang Yanlin (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CALCITE-3596?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Wang Yanlin closed CALCITE-3596.
--------------------------------
    Resolution: Not A Problem

> 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)