Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.1(EOL), 10.2(EOL)
-
None
Description
DROP TABLE IF EXISTS t1;
|
DROP PROCEDURE IF EXISTS p1;
|
CREATE PROCEDURE p1(a INT) CREATE TABLE t1 SELECT a;
|
CALL p1(1);
|
DESC t1;
|
returns
+-------+------------+------+-----+---------+-------+
|
| Field | Type | Null | Key | Default | Extra |
|
+-------+------------+------+-----+---------+-------+
|
| a | bigint(11) | YES | | NULL | |
|
+-------+------------+------+-----+---------+-------+
|
int(11) would be enough.
Attachments
Issue Links
- relates to
-
MDEV-4912 Data type plugin API version 1
-
- Closed
-
Activity
A similar problem:
CREATE OR REPLACE TABLE t1 AS SELECT 999999999 AS a,2147483647 AS b;
|
returns
+-------+------------+------+-----+---------+-------+
|
| Field | Type | Null | Key | Default | Extra |
|
+-------+------------+------+-----+---------+-------+
|
| a | int(9) | NO | | NULL | |
|
| b | bigint(10) | NO | | NULL | |
|
+-------+------------+------+-----+---------+-------+
|
int(10) for b should be enough.
A similar problem:
CREATE OR REPLACE TABLE t1 (a int);CREATE OR REPLACE VIEW v1 AS SELECT COALESCE(a) AS a FROM t1;DESC v1;returns
+-------+------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |+-------+------------+------+-----+---------+-------+| a | bigint(11) | YES | | NULL | |+-------+------------+------+-----+---------+-------+int(11) should be ok.