[MDEV-12712] CREATE..SELECT for stored functions returning ENUM/SET does not preserve the exact type - Jira

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').

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server