Pavel Gubin created CALCITE-2206:
------------------------------------
Summary: Window functions pushed to JDBC databases regardless of
their support
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
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)
