MySQL Forums
Forum List  »  MySQL Workbench

MYSQL 8.0.11 window functions - error or bug?
Posted by: Warwick O
Date: July 04, 2018 05:38AM

I've working on MYSQL 8.0.11 and testing window functions but getting what I think is an unexpected error via workbench.

SELECT AVG(Volume) OVER (PARTITION BY `Security` ORDER BY DateValue ROWS 19 PRECEDING) AS MAV20
FROM t_EOD_Dly;

In workbenches query window at the Over( I am getting Syntax error: Unexpected '(' (opening parenthesis)

To my best knowledge, brackets are correct. The SQL statement executes correctly with a green tick in the output window.

Interestingly when I drop the same SQL into a stored procedure it won't apply and generates The object's DDL statement contains syntax errors. when attempting to do so.



Is this a bug in build 8.0.11 or am i missing something really simple?

Options: ReplyQuote


Subject
Views
Written By
Posted
MYSQL 8.0.11 window functions - error or bug?
174
July 04, 2018 05:38AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.