Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL)
-
None
Description
DROP FUNCTION IF EXISTS f1; |
CREATE FUNCTION f1() RETURNS ENUM('a') RETURN 'a'; |
CREATE OR REPLACE TABLE t1 AS SELECT f1(); |
SHOW CREATE TABLE t1; |
+-------+---------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+---------------------------------------------------------------------------------------------+
|
| t1 | CREATE TABLE `t1` (
|
`f1()` varchar(1) DEFAULT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
|
+-------+---------------------------------------------------------------------------------------------+
|
Looks wrong. The expected column type is ENUM('a').