[ https://issues.apache.org/jira/browse/CALCITE-2206?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16433281#comment-16433281 ]
Julian Hyde commented on CALCITE-2206: -------------------------------------- Reviewing and testing now. Will commit when tests pass. > Queries with window functions fail when using 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 > > Queries containing window functions fail when using HSQLDB (or any other DB > that does not support window functions) because optimiser 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)