Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Duplicate
-
10.5.9, 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5
-
Ubuntu
Description
The following procedure, using the RAND() function, crashes the server when called more than once.
DELIMITER $$
|
|
|
DROP PROCEDURE IF EXISTS sp_test;
|
$$
|
CREATE PROCEDURE sp_test(
|
)
|
BEGIN
|
|
|
SELECT x, y
|
FROM (
|
SELECT x, RAND() y
|
FROM (
|
SELECT 1 x |
UNION
|
SELECT 2 |
) SQ0
|
) SQ1;
|
|
|
END;
|
$$
|
|
|
CALL sp_test();
|
CALL sp_test(); -- this call crashes the server |
|
Attachments
Issue Links
- duplicates
-
-
- Closed
-
- relates to
-
-
- Confirmed
-