Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.3.13, 10.3
-
None
Description
I want to use several Dynamic Queries in one Variable.
IF we set several dynamic queries in one variable, MariaDB can't execute the Dynamic queries.
However If we use 'IF (1=1)' Then we can use dynamic queries in one variable.
Is this intentional behavior or bug?
IF it is not bug, I want to know there is any problem using like this.
(ex)
## PROCEDURE CREATE |
DROP PROCEDURE IF EXISTS ACCT.MYSQL_MULTI_TEST; |
CREATE PROCEDURE ACCT.`MYSQL_MULTI_TEST`( |
$SQL VARCHAR(8000) |
)
|
BEGIN
|
DECLARE count INT DEFAULT 0; |
|
SET @SQL = $SQL; |
SET @COUNT = 1; |
PREPARE STMT_CONTENT FROM @SQL; |
EXECUTE STMT_CONTENT; |
DEALLOCATE PREPARE STMT_CONTENT; |
|
END; |
## PROCEDURE CALL ( error) |
|
CALL MYSQL_MULTI_TEST(' |
DELETE FROM MYSQL_MULTI_DELETE_1;
|
DELETE FROM MYSQL_MULTI_DELETE_2;
|
DELETE FROM MYSQL_MULTI_DELETE_3;
|
'); |
|
## PROCEDURE CALL ( ok ) |
|
CALL MYSQL_MULTI_TEST(' |
IF( 1 = 1 ) THEN
|
DELETE FROM MYSQL_MULTI_DELETE_1;
|
DELETE FROM MYSQL_MULTI_DELETE_2;
|
DELETE FROM MYSQL_MULTI_DELETE_3;
|
END IF;
|
'); |