[MDEV-20803] IF NOT EXISTS AND NOT EXISTS crash DB server - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Duplicate
Affects Version/s: 10.4.7, 10.4(EOL), 10.5
Fix Version/s: 10.4.13, 10.5.4
Component/s: PL/SQL, Stored routines
Labels:
- crash
Environment:
Redhat Enterprise Linux 7

Description

Call stored procedure with IF NOT EXISTS AND NOT EXISTS condition crash the DB server.

The case can be reproduced as follows:

1. Create tables 'test' and 'test2' and insert values into them:

CREATE TABLE `test` (

  `name` varchar(100) NOT NULL,

  `address` varchar(100) DEFAULT NULL,

  PRIMARY KEY (`name`));

CREATE TABLE `test2` (

  `name` varchar(100) NOT NULL,

  `address` varchar(100) DEFAULT NULL,

  PRIMARY KEY (`name`));

INSERT INTO test VALUES ('a', 'aaa');

INSERT INTO test2 VALUES ('a', 'aaa');

2. Create stored procedure 'test_if':

DELIMITER ;;

DROP PROCEDURE IF EXISTS `test_if` ;

CREATE  PROCEDURE `test_if`(

        IN in_name NVARCHAR(20)

BEGIN

    If NOT EXISTS (select name from test where name = name)

    AND NOT EXISTS (select name from test2 where name = name)

    THEN

       select "NOT EXISTS";

    ELSE

       select "EXISTS";

    END IF;

    SELECT * FROM test;

END ;;

DELIMITER ;

3. Run: call test_if('a'); (OK, no error)
4. Run again: call test_if('a'); , it will crash the DB server

The error message 'error.txt' is attached for your reference.

Please investigate.

Thanks,

Chow King Tak

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

error.txt
6 kB
2019-10-11 08:48

Issue Links

is duplicated by

MDEV-21199 Segfault

Closed

MDEV-21729 Triggeraufruf führt zu Crash des Servers

Closed

relates to

MDEV-20284 Some pointers may be invalid and cause the dump to abort.

Closed

MDEV-20290 Server crash in st_select_lex::cleanup or Assertion `sl->join == 0' failed in reinit_stmt_before_use

Closed

MDEV-20858 Function crash server

Closed

MDEV-21315 Server 10.4 sporadically crashes when issuing simple INSERT commands

Closed

(1 relates to)

Activity

Ascending order - Click to sort in descending order

Chow King Tak created issue - 2019-10-11 08:54

Elena Stepanova made changes - 2019-10-12 18:28

Field	Original Value	New Value
Component/s		Stored routines [ 13905 ]
Component/s	Server [ 13907 ]
Fix Version/s		10.4 [ 22408 ]

Elena Stepanova made changes - 2019-10-12 18:28

Status

Open [ 1 ]

Confirmed [ 10101 ]

Elena Stepanova made changes - 2019-10-12 18:44

Link

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

Elena Stepanova made changes - 2019-10-12 18:45

Assignee

Oleksandr Byelkin [ sanja ]

Elena Stepanova made changes - 2019-10-28 17:10

Link

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

Alice Sherepa made changes - 2019-12-03 08:50

Link

This issue is duplicated by ~~MDEV-21199~~ [ ~~MDEV-21199~~ ]

Alice Sherepa made changes - 2019-12-16 18:27

Link

This issue is duplicated by ~~MDEV-21315~~ [ ~~MDEV-21315~~ ]

Alice Sherepa made changes - 2019-12-16 18:29

Link

This issue is duplicated by ~~MDEV-21315~~ [ ~~MDEV-21315~~ ]

Alice Sherepa made changes - 2019-12-16 18:29

Link

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

Alice Sherepa made changes - 2020-02-13 11:42

Link

This issue is duplicated by ~~MDEV-21729~~ [ ~~MDEV-21729~~ ]

Alice Sherepa made changes - 2020-02-13 11:43

Link

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

Alice Sherepa made changes - 2020-02-13 11:46

Affects Version/s

10.4 [ 22408 ]

Sergei Golubchik made changes - 2020-02-14 19:09

Description

Call stored procedure with IF NOT EXISTS AND NOT EXISTS condition crash the DB server.

The case can be reproduced as follows:

1. Create tables 'test' and 'test2' and insert values into them:
CREATE TABLE `test` (
  `name` varchar(100) NOT NULL,
  `address` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`name`));

CREATE TABLE `test2` (
  `name` varchar(100) NOT NULL,
  `address` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`name`));

INSERT INTO test VALUES ('a', 'aaa');
INSERT INTO test2 VALUES ('a', 'aaa');

2. Create stored procedure 'test_if':

DELIMITER ;;
DROP PROCEDURE IF EXISTS `test_if` ;
CREATE PROCEDURE `test_if`(
        IN in_name NVARCHAR(20)
)
BEGIN

    If NOT EXISTS (select name from test where name = name)
    AND NOT EXISTS (select name from test2 where name = name)
    THEN
       select "NOT EXISTS";
    ELSE
       select "EXISTS";
    END IF;

    SELECT * FROM test;
END ;;
DELIMITER ;

3. Run: call test_if('a'); (OK, no error)
4. Run again: call test_if('a'); , it will crash the DB server

The error message 'error.txt' is attached for your reference.

Please investigate.

Thanks,

Chow King Tak

Call stored procedure with IF NOT EXISTS AND NOT EXISTS condition crash the DB server.

The case can be reproduced as follows:

1. Create tables 'test' and 'test2' and insert values into them:
{code:sql}
CREATE TABLE `test` (
  `name` varchar(100) NOT NULL,
  `address` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`name`));

CREATE TABLE `test2` (
  `name` varchar(100) NOT NULL,
  `address` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`name`));

INSERT INTO test VALUES ('a', 'aaa');
INSERT INTO test2 VALUES ('a', 'aaa');
{code}
2. Create stored procedure 'test_if':
{code:sql}
DELIMITER ;;
DROP PROCEDURE IF EXISTS `test_if` ;
CREATE PROCEDURE `test_if`(
        IN in_name NVARCHAR(20)
)
BEGIN

    If NOT EXISTS (select name from test where name = name)
    AND NOT EXISTS (select name from test2 where name = name)
    THEN
       select "NOT EXISTS";
    ELSE
       select "EXISTS";
    END IF;

    SELECT * FROM test;
END ;;
DELIMITER ;
{code}

3. Run: call test_if('a'); (OK, no error)
4. Run again: call test_if('a'); , it will crash the DB server

The error message 'error.txt' is attached for your reference.

Please investigate.

Thanks,

Chow King Tak

Alice Sherepa made changes - 2020-08-05 07:31

Affects Version/s

10.5 [ 23123 ]

Alice Sherepa made changes - 2020-08-05 07:31

Fix Version/s

10.5 [ 23123 ]

Oleksandr Byelkin made changes - 2020-10-08 09:35

Fix Version/s		10.5.4 [ 24264 ]
Fix Version/s		10.4.13 [ 24223 ]
Fix Version/s	10.4 [ 22408 ]
Fix Version/s	10.5 [ 23123 ]
Resolution		Duplicate [ 3 ]
Status	Confirmed [ 10101 ]	Closed [ 6 ]

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

Workflow

MariaDB v3 [ 100349 ]

MariaDB v4 [ 156847 ]

Jira Automation (IT) made changes - 2024-07-04 03:32

Zendesk Related Tickets

169530 128337

People

Assignee:: Oleksandr Byelkin

Reporter:: Chow King Tak

Votes:: 2 Vote for this issue

Watchers:: 9 Start watching this issue

Dates

Created:: 2019-10-11 08:54

Updated:: 2024-07-07 22:33

Resolved:: 2020-10-08 09:35

Git Integration

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

MariaDB Server

Details

Description

Attachments

Attachments

Issue Links

Activity

People

Dates

Git Integration