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 |

+-------+---------------------------------------------------------------------------------------------+