[MDEV-10212] Local routine MEDIUMBLOB variable overwritten while asigning value to another MEDIUMBLOB variable using SELECT INTO - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 5.5.47-galera
Fix Version/s: 5.5.48
Component/s: Data Definition - Procedure
Labels:
- assignment
- blob
- mediumblob
- subroutine
- upstream
- variable
Environment:
Centos 7

Description

Using SELECT INTO local routine variable, value is assigned to two distinct variables.

Test cast to reproduce issue;

Two tables with one row with different values

CREATE TABLE `test`.`A`(

  `idA` BIGINT NOT NULL AUTO_INCREMENT,

  `messageA` MEDIUMBLOB,

  PRIMARY KEY (`idA`)

);

CREATE TABLE `test`.`B`(

  `idB` BIGINT NOT NULL AUTO_INCREMENT,

  `messageB` MEDIUMBLOB,

  PRIMARY KEY (`idB`)

);

INSERT INTO A(messageA) VALUES (COMPRESS('messageA'));

INSERT INTO B(messageB) VALUES (COMPRESS('messageB'));

Stored procedure:

DELIMITER $$

CREATE PROCEDURE `procC`()

BEGIN

	DECLARE pA MEDIUMBLOB;

	DECLARE pB MEDIUMBLOB;

	SElect messageA

	into pA

	FROM A;

	SELECT messageB

	into pB

	from B;

	select UNCOMPRESS(pA), UNCOMPRESS(pB);

    END$$

DELIMITER ;

Calling procedure:

CALL procC();

Expected result:

messageA, messageB

Result:

messageB, messageB

Attachments

Activity

Ascending order - Click to sort in descending order

Ljubomir Đokić created issue - 2016-06-10 11:31

Ljubomir Đokić made changes - 2016-06-10 11:32

Field	Original Value	New Value
Description	Using SELECT INTO local routine variable, value is assigned to two distinct variables. Test cast to reproduce issue; Two tables with one row with different values {{ CREATE TABLE `test`.`A`( `idA` BIGINT NOT NULL AUTO_INCREMENT, `messageA` MEDIUMBLOB, PRIMARY KEY (`idA`) ); CREATE TABLE `test`.`B`( `idB` BIGINT NOT NULL AUTO_INCREMENT, `messageB` MEDIUMBLOB, PRIMARY KEY (`idB`) ); INSERT INTO A(messageA) VALUES (COMPRESS('messageA')); INSERT INTO B(messageB) VALUES (COMPRESS('messageB')); }} Stored procedure: {{ DELIMITER $$ CREATE PROCEDURE `procC`() BEGIN DECLARE pA MEDIUMBLOB; DECLARE pB MEDIUMBLOB; SElect messageA into pA FROM A; SELECT messageB into pB from B; select UNCOMPRESS(pA), UNCOMPRESS(pB); END$$ DELIMITER ; }} Calling procedure: {{CALL procC();}} Expected result: {{messageA, messageB}} Result: {{messageB, messageB}}	Using SELECT INTO local routine variable, value is assigned to two distinct variables. Test cast to reproduce issue; Two tables with one row with different values {{CREATE TABLE `test`.`A`( `idA` BIGINT NOT NULL AUTO_INCREMENT, `messageA` MEDIUMBLOB, PRIMARY KEY (`idA`) ); CREATE TABLE `test`.`B`( `idB` BIGINT NOT NULL AUTO_INCREMENT, `messageB` MEDIUMBLOB, PRIMARY KEY (`idB`) ); INSERT INTO A(messageA) VALUES (COMPRESS('messageA')); INSERT INTO B(messageB) VALUES (COMPRESS('messageB'));}} Stored procedure: {{ DELIMITER $$ CREATE PROCEDURE `procC`() BEGIN DECLARE pA MEDIUMBLOB; DECLARE pB MEDIUMBLOB; SElect messageA into pA FROM A; SELECT messageB into pB from B; select UNCOMPRESS(pA), UNCOMPRESS(pB); END$$ DELIMITER ; }} Calling procedure: {{CALL procC();}} Expected result: {{messageA, messageB}} Result: {{messageB, messageB}}

Ljubomir Đokić made changes - 2016-06-10 11:34

Description

Using SELECT INTO local routine variable, value is assigned to two distinct variables.

Test cast to reproduce issue;

Two tables with one row with different values

{{CREATE TABLE `test`.`A`(
  `idA` BIGINT NOT NULL AUTO_INCREMENT,
  `messageA` MEDIUMBLOB,
  PRIMARY KEY (`idA`)
);

CREATE TABLE `test`.`B`(
  `idB` BIGINT NOT NULL AUTO_INCREMENT,
  `messageB` MEDIUMBLOB,
  PRIMARY KEY (`idB`)
);

INSERT INTO A(messageA) VALUES (COMPRESS('messageA'));
INSERT INTO B(messageB) VALUES (COMPRESS('messageB'));}}

Stored procedure:
{{
DELIMITER $$

CREATE PROCEDURE `procC`()
BEGIN
DECLARE pA MEDIUMBLOB;
DECLARE pB MEDIUMBLOB;

SElect messageA
into pA
FROM A;

SELECT messageB
into pB
from B;

select UNCOMPRESS(pA), UNCOMPRESS(pB);
    END$$

DELIMITER ;
}}

Calling procedure:
{{CALL procC();}}

Expected result:
{{messageA, messageB}}

Result:
{{messageB, messageB}}

Using SELECT INTO local routine variable, value is assigned to two distinct variables.

Test cast to reproduce issue;

Two tables with one row with different values

{color:#707070}
{code:java}
CREATE TABLE `test`.`A`(
  `idA` BIGINT NOT NULL AUTO_INCREMENT,
  `messageA` MEDIUMBLOB,
  PRIMARY KEY (`idA`)
);

CREATE TABLE `test`.`B`(
  `idB` BIGINT NOT NULL AUTO_INCREMENT,
  `messageB` MEDIUMBLOB,
  PRIMARY KEY (`idB`)
);

INSERT INTO A(messageA) VALUES (COMPRESS('messageA'));
INSERT INTO B(messageB) VALUES (COMPRESS('messageB'));

{code}
{color}
Stored procedure:

{color:#707070}
{code:java}
DELIMITER $$

CREATE PROCEDURE `procC`()
BEGIN
DECLARE pA MEDIUMBLOB;
DECLARE pB MEDIUMBLOB;

SElect messageA
into pA
FROM A;

SELECT messageB
into pB
from B;

select UNCOMPRESS(pA), UNCOMPRESS(pB);
    END$$

DELIMITER ;

{code}
{color}

Calling procedure:
{color:#707070}
{code:java}
CALL procC();

{code}
{color}
Expected result:

{code:java}
messageA, messageB
{code}

Result:

{code:java}
messageB, messageB
{code}

Sergei Golubchik made changes - 2016-06-10 11:54

Component/s		Data Definition - Procedure [ 10119 ]
Component/s	Scripts & Clients [ 11002 ]

Elena Stepanova made changes - 2016-06-10 13:04

Fix Version/s		5.5.48 [ 21000 ]
Labels	assignment blob mediumblob subroutine variable	assignment blob mediumblob subroutine upstream variable

Elena Stepanova made changes - 2016-06-10 13:05

Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Closed [ 6 ]

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

Workflow

MariaDB v3 [ 75953 ]

MariaDB v4 [ 150505 ]

People

Assignee:: Unassigned

Reporter:: Ljubomir Đokić

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2016-06-10 11:31

Updated:: 2016-06-10 13:05

Resolved:: 2016-06-10 13:05

Git Integration

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

MariaDB Server

Details

Description

Attachments

Activity

People

Dates

Git Integration