[MDEV-10824] Crash in CREATE OR REPLACE TABLE t1 AS SELECT spfunc() - Jira

XML

Word

Printable

This script crashes the server:

CREATE TABLE IF NOT EXISTS t1 (i INT);

DROP FUNCTION IF EXISTS f1;

DELIMITER $$

CREATE FUNCTION f1() RETURNS VARCHAR(16383)

BEGIN

  RETURN 'test';

END;

$$

DELIMITER ;

CREATE OR REPLACE TABLE t1 AS SELECT f1();

Note, if I replace CREATE OR REPLACE to a DROP followed by CREATE, it works fine:

CREATE TABLE IF NOT EXISTS t1 (i INT);

DROP FUNCTION IF EXISTS f1;

DELIMITER $$

CREATE FUNCTION f1() RETURNS VARCHAR(16383)

BEGIN

  RETURN 'test';

END;

$$

DELIMITER ;

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 AS SELECT f1();

relates to

MDEV-11129 CREATE OR REPLACE TABLE t1 AS SELECT spfunc() crashes if spfunc() references t1

MDEV-9496 Crash in CREATE OR REPLACE TABLE t1 AS SELECT stored_function()

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