[MDEV-15870] Using aggregate and window function in unexpected places can crash the server - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.2(EOL), 10.3(EOL)
Fix Version/s: 10.2.16, 10.3.8
Component/s: Stored routines
Labels:
None

Description

These examples crash the server:

CREATE OR REPLACE PROCEDURE p1 (a TEXT) BEGIN END;

CALL p1(RANK() OVER (ORDER BY 1));

CREATE OR REPLACE PROCEDURE p1 (a TEXT) BEGIN END;

CALL p1(ROW_NUMBER() OVER ());

CREATE OR REPLACE PROCEDURE p1 (a TEXT) BEGIN END;

CALL p1(SUM(1));

Attachments

Issue Links

relates to

MDEV-11953 support of brackets (parentheses) in UNION/EXCEPT/INTERSECT operations

Closed

MDEV-15057 Crash when using an unknown identifier as an SP parameter

Closed

MDEV-15328 MariaDB 10.2.13 Crashes upon CALL PROCEDURE PARAM LAST_INSERT_ID ()

Closed

Activity

Alexander Barkov added a comment - 2018-04-16 02:16

In 10.1 it works fine:

MariaDB [test]> CALL p1(SUM(1));

ERROR 1111 (HY000): Invalid use of group function

Alexander Barkov added a comment - 2018-04-16 02:16 In 10.1 it works fine: MariaDB [test]> CALL p1( SUM (1)); ERROR 1111 (HY000): Invalid use of group function

People

Assignee:: Alexander Barkov

Reporter:: Alexander Barkov

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2018-04-15 04:27

Updated:: 2018-06-13 07:57

Resolved:: 2018-06-13 07:57

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server