MDEV-15960 Wrong data type on CREATE..SELECT char_or_enum_or_text_spvar

1 files changed, 69 insertions, 0 deletions

diff --git a/mysql-test/main/sp-vars.result b/mysql-test/main/sp-vars.result
index ac1566d0c6e..0d4d18c577d 100644
--- a/mysql-test/main/sp-vars.result
+++ b/mysql-test/main/sp-vars.result
@@ -1241,3 +1241,72 @@ t1	CREATE TABLE "t1" (
   "a" year(4) DEFAULT NULL
 )
 DROP PROCEDURE p1;
+#
+# MDEV-15960 Wrong data type on CREATE..SELECT char_or_enum_or_text_spvar
+#
+BEGIN NOT ATOMIC
+DECLARE var TINYTEXT CHARACTER SET utf8;
+CREATE TABLE t1 AS SELECT var;
+END;
+$$
+SHOW CREATE TABLE t1;
+Table	Create Table
+t1	CREATE TABLE "t1" (
+  "var" tinytext CHARACTER SET utf8 DEFAULT NULL
+)
+DROP TABLE t1;
+BEGIN NOT ATOMIC
+DECLARE var TEXT CHARACTER SET utf8;
+CREATE TABLE t1 AS SELECT var;
+END;
+$$
+SHOW CREATE TABLE t1;
+Table	Create Table
+t1	CREATE TABLE "t1" (
+  "var" text CHARACTER SET utf8 DEFAULT NULL
+)
+DROP TABLE t1;
+BEGIN NOT ATOMIC
+DECLARE var MEDIUMTEXT CHARACTER SET utf8;
+CREATE TABLE t1 AS SELECT var;
+END;
+$$
+SHOW CREATE TABLE t1;
+Table	Create Table
+t1	CREATE TABLE "t1" (
+  "var" mediumtext CHARACTER SET utf8 DEFAULT NULL
+)
+DROP TABLE t1;
+BEGIN NOT ATOMIC
+DECLARE var LONGTEXT CHARACTER SET utf8;
+CREATE TABLE t1 AS SELECT var;
+END;
+$$
+SHOW CREATE TABLE t1;
+Table	Create Table
+t1	CREATE TABLE "t1" (
+  "var" longtext CHARACTER SET utf8 DEFAULT NULL
+)
+DROP TABLE t1;
+BEGIN NOT ATOMIC
+DECLARE var CHAR(1);
+CREATE TABLE t1 AS SELECT var;
+END;
+$$
+SHOW CREATE TABLE t1;
+Table	Create Table
+t1	CREATE TABLE "t1" (
+  "var" char(1) DEFAULT NULL
+)
+DROP TABLE t1;
+BEGIN NOT ATOMIC
+DECLARE var ENUM('a');
+CREATE TABLE t1 AS SELECT var;
+END;
+$$
+SHOW CREATE TABLE t1;
+Table	Create Table
+t1	CREATE TABLE "t1" (
+  "var" char(1) DEFAULT NULL
+)
+DROP TABLE t1;