Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5, 10.3(EOL), 10.4(EOL)
-
None
Description
DELIMITER $$
|
CREATE OR REPLACE PROCEDURE p1() |
BEGIN
|
SET GLOBAL max_allowed_packet=16000000, max_error_count=60; |
SELECT @@GLOBAL.max_allowed_packet, @@GLOBAL.max_error_count; |
END; |
$$
|
DELIMITER ;
|
SHOW PROCEDURE CODE p1; |
+-----+---------------------------------------------------+
|
| Pos | Instruction |
|
+-----+---------------------------------------------------+
|
| 0 | stmt 31 "SET GLOBAL max_allowed_packet=16000000" |
|
| 1 | stmt 31 "SET max_error_count=60" |
|
| 2 | stmt 0 "SELECT @@GLOBAL.max_allowed_packet, @..." |
|
+-----+---------------------------------------------------+
|
Notice, the second "stmt" instruction is missing the GLOBAL keyword.
Attachments
Issue Links
- blocks
-
MDEV-5816 MySQL WL#4179 - Stored programs: validation of stored program statements
- Closed