Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5
-
None
Description
CREATE OR REPLACE FUNCTION f1() RETURNS INT RETURN SUM(1); |
SELECT f1(); |
ERROR 1111 (HY000): Invalid use of group function
|
CREATE OR REPLACE FUNCTION f1() RETURNS INT RETURN ROW_NUMBER() OVER(); |
SELECT f1(); |
ERROR 4015 (HY000): Window function is allowed only in SELECT list and ORDER BY clause
|
It should report the error at creation rather than execution time.
Attachments
Issue Links
- relates to
-
MDEV-14347 CREATE PROCEDURE returns no error when using an unknown variable
- Closed