[ https://issues.apache.org/jira/browse/CALCITE-2206?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16438883#comment-16438883 ]
Julian Hyde commented on CALCITE-2206: -------------------------------------- I had an error in my script. It was looking for lines like {{[ERROR] Tests run: 4388, Failures: 16, Errors: 0, Skipped: 109}} but was not expecting to see the {{[ERROR]}} prefix because previous versions of maven did not have it. > JDBC adapter incorrectly pushes windowed aggregates down to HSQLDB > ------------------------------------------------------------------ > > Key: CALCITE-2206 > URL: https://issues.apache.org/jira/browse/CALCITE-2206 > Project: Calcite > Issue Type: Bug > Components: jdbc-adapter > Affects Versions: 1.15.0 > Reporter: Pavel Gubin > Assignee: Julian Hyde > Priority: Major > Fix For: 1.17.0 > > > JDBC adapter incorrectly pushes windowed aggregates down to HSQLDB. Queries > containing window functions fail when using HSQLDB (or any other DB that does > not support window functions) because the optimizer converts them to native > SQL with window functions which are not supported by HSQLDB. For example: > {code:sql} > select "store_id", "product_id", sum("unit_sales") unit_sales, row_number() > over ( > partition by "store_id" order by sum("unit_sales") desc > ) row_num > from "sales_fact_1998" > group by "store_id", "product_id" > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)