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

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.0(EOL), 10.1(EOL)
Fix Version/s: 10.0.28, 10.1.19
Component/s: Locking
Labels:
None

Sprint:
10.0.28

Description

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();

Attachments

Issue Links

relates to

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

Closed

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

Closed

Activity

Ascending order - Click to sort in descending order

Alexander Barkov created issue - 2016-09-17 09:42

Alexander Barkov made changes - 2016-09-17 09:43

Field	Original Value	New Value
Description	This script crashes the server: {code:sql} 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(); {code} Note, if I replace {{CREATE OR REPLACE}} to a {{DROP}} followed by {{CREATE}}, it works fine: {code:sql} 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(); CREATE OR REPLACE TABLE t1 AS SELECT f1(); {code}	This script crashes the server: {code:sql} 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(); {code} Note, if I replace {{CREATE OR REPLACE}} to a {{DROP}} followed by {{CREATE}}, it works fine: {code:sql} 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(); {code}

Elena Stepanova made changes - 2016-09-19 15:14

Description

This script crashes the server:
{code:sql}
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();
{code}

Note, if I replace {{CREATE OR REPLACE}} to a {{DROP}} followed by {{CREATE}}, it works fine:
{code:sql}
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();
{code}

This script crashes the server:
{code:sql}
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();
{code}

Note, if I replace {{CREATE OR REPLACE}} to a {{DROP}} followed by {{CREATE}}, it works fine:
{code:sql}
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();
{code}

Elena Stepanova made changes - 2016-09-19 15:16

Assignee

Sergey Vojtovich [ svoj ]

Elena Stepanova made changes - 2016-09-19 15:16

Fix Version/s

10.1 [ 16100 ]

Elena Stepanova made changes - 2016-09-19 15:16

Affects Version/s

10.2 [ 14601 ]

Rasmus Johansson (Inactive) made changes - 2016-10-19 14:50

Sprint

10.0.28 [ 107 ]

Rasmus Johansson (Inactive) made changes - 2016-10-19 14:50

Rank

Ranked lower

Sergey Vojtovich made changes - 2016-10-24 11:49

Assignee	Sergey Vojtovich [ svoj ]	Sergei Golubchik [ serg ]
Status	Open [ 1 ]	In Review [ 10002 ]

Sergey Vojtovich made changes - 2016-10-25 09:47

Link

This issue relates to ~~MDEV-11129~~ [ ~~MDEV-11129~~ ]

Sergei Golubchik made changes - 2016-10-26 10:10

Assignee	Sergei Golubchik [ serg ]	Sergey Vojtovich [ svoj ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Sergey Vojtovich made changes - 2016-10-26 10:31

Component/s		OTHER [ 10125 ]
Fix Version/s		10.0.28 [ 22107 ]
Fix Version/s		10.1.19 [ 22111 ]
Fix Version/s	10.0 [ 16000 ]
Fix Version/s	10.1 [ 16100 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2016-11-01 14:32

Component/s		Locking [ 10900 ]
Component/s	OTHER [ 10125 ]

Elena Stepanova made changes - 2018-07-18 08:29

Link

This issue relates to ~~MDEV-9496~~ [ ~~MDEV-9496~~ ]

Sergei Golubchik made changes - 2021-12-06 21:43

Workflow

MariaDB v3 [ 77121 ]

MariaDB v4 [ 150925 ]

People

Assignee:: Sergey Vojtovich

Reporter:: Alexander Barkov

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2016-09-17 09:42

Updated:: 2018-07-18 08:29

Resolved:: 2016-10-26 10:31

Git Integration

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

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration