Hello guys! I've encountered really strange error with usage of window functions inside CTE. When i include window function field into CTE and OVER() clause is empty it works correctly, but when I try to add ORDER BY/PARTITION BY inside the OVER() clause i'm encountering following error : '[42000][42000] Syntax error in SQL statement "WITH statement supports only SELECT, TABLE, VALUES, CREATE TABLE, INSERT, UPDATE, MERGE or DELETE statements" ' One clarification : when i run statements using windows functions with PARTITION BY\ORDER BY parts *not *inside CTE it works well.
-- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/78cfbd72-24ae-498e-ac17-ac6c81d8bd0dn%40googlegroups.com.
