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