Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL)
-
None
Description
DROP PROCEDURE IF EXISTS p1; |
DROP TABLE IF EXISTS t1; |
CREATE PROCEDURE p1(OUT v YEAR) SET v = 2010; |
CALL p1(@a);
|
PREPARE stmt FROM 'CALL p1(?)'; |
EXECUTE stmt USING @b; |
DEALLOCATE PREPARE stmt; |
CREATE TABLE t1 AS SELECT @a AS a, @b AS b; |
SHOW CREATE TABLE t1; |
+-------+----------------------------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+----------------------------------------------------------------------------------------------------------------------------------+
|
| t1 | CREATE TABLE `t1` (
|
`a` bigint(20) unsigned DEFAULT NULL,
|
`b` bigint(20) DEFAULT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
|
+-------+----------------------------------------------------------------------------------------------------------------------------------+
|
Notice, the column b is missing the unsigned flag.