Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.3, 10.4
-
Component/s: Stored routines
-
Labels:None
Description
This script produces no errors:
CREATE OR REPLACE TABLE t1 (a INT); |
DELIMITER $$
|
BEGIN NOT ATOMIC |
DECLARE row ROW(a INT); |
SELECT * FROM t1 ORDER BY row; |
END; |
$$
|
DELIMITER ;
|
It should return an error.
The same problem is repeatable with HAVING:
CREATE OR REPLACE TABLE t1 (a INT); |
DELIMITER $$
|
BEGIN NOT ATOMIC |
DECLARE row ROW(a INT); |
SELECT * FROM t1 HAVING row; |
END; |
$$
|
DELIMITER ;
|
The same problem is repeatable in LIKE..ESCAPE:
DELIMITER $$
|
BEGIN NOT ATOMIC |
DECLARE a ROW(a INT); |
SELECT 1 LIKE 2 ESCAPE a; |
END; |
$$
|
DELIMITER ;
|
Attachments
Issue Links
- blocks
-
MDEV-4912 Data type plugin API version 1
-
- Closed
-
-
MDEV-16388 Replace member Item::fixed to virtual method is_fixed()
-
- Closed
-