[jira] [Created] (CALCITE-3596) Sql in annotation of OverScope class has syntax error

[Wang Yanlin (Jira)]

Wang Yanlin created CALCITE-3596:
------------------------------------

             Summary: Sql in annotation 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


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)