[MDEV-16311] Server crash when using a NAME_CONST() with a CURSOR - Jira

XML

Word

Printable

This script makes the server crash in a debug build:

SET sql_mode=STRICT_ALL_TABLES;

CREATE OR REPLACE TABLE t1 (a INT);

INSERT INTO t1 VALUES (10);

DELIMITER $$

BEGIN NOT ATOMIC

  DECLARE a INT;

  DECLARE c CURSOR FOR SELECT NAME_CONST('x','y') FROM t1;

  OPEN c;

  FETCH c INTO a;

  CLOSE c;

END;

$$

DELIMITER ;

If I change sql_mode to empty, it works fine:

SET sql_mode='';

CREATE OR REPLACE TABLE t1 (a INT);

INSERT INTO t1 VALUES (10);

DELIMITER $$

BEGIN NOT ATOMIC

  DECLARE a INT;

  DECLARE c CURSOR FOR SELECT NAME_CONST('x','y') FROM t1;

  OPEN c;

  FETCH c INTO a;

  CLOSE c;

END;

$$

DELIMITER ;

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