Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1(EOL), 10.2(EOL), 10.3(EOL)
Description
DROP PROCEDURE IF EXISTS p1; |
DELIMITER $$
|
CREATE PROCEDURE p1() |
BEGIN
|
DECLARE a INT; |
DECLARE b FLOAT; |
CREATE OR REPLACE TABLE t1 AS SELECT a, b; |
END; |
$$
|
DELIMITER ;
|
CALL p1;
|
DESCRIBE t1;
|
+-------+------------+------+-----+---------+-------+
|
| Field | Type | Null | Key | Default | Extra |
|
+-------+------------+------+-----+---------+-------+
|
| a | bigint(11) | YES | | NULL | |
|
| b | double | YES | | NULL | |
|
+-------+------------+------+-----+---------+-------+
|
The expected data types would be INT and FLOAT.
Attachments
Issue Links
- blocks
-
MDEV-4912 Data type plugin API version 1
- Closed
- is duplicated by
-
MDEV-12917 Wrong data type for CREATE..SELECT year_sp_variable
- Closed