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

1 files changed, 67 insertions, 0 deletions

diff --git a/mysql-test/main/sp-vars.test b/mysql-test/main/sp-vars.test
index 57d5563e609..ba8cd4f5ca8 100644
--- a/mysql-test/main/sp-vars.test
+++ b/mysql-test/main/sp-vars.test
@@ -1536,3 +1536,70 @@ $$
 DELIMITER ;$$
 CALL p1;
 DROP PROCEDURE p1;
+
+
+--echo #
+--echo # MDEV-15960 Wrong data type on CREATE..SELECT char_or_enum_or_text_spvar
+--echo #
+
+DELIMITER $$;
+BEGIN NOT ATOMIC
+  DECLARE var TINYTEXT CHARACTER SET utf8;
+  CREATE TABLE t1 AS SELECT var;
+END;
+$$
+DELIMITER ;$$
+SHOW CREATE TABLE t1;
+DROP TABLE t1;
+
+DELIMITER $$;
+BEGIN NOT ATOMIC
+  DECLARE var TEXT CHARACTER SET utf8;
+  CREATE TABLE t1 AS SELECT var;
+END;
+$$
+DELIMITER ;$$
+SHOW CREATE TABLE t1;
+DROP TABLE t1;
+
+DELIMITER $$;
+BEGIN NOT ATOMIC
+  DECLARE var MEDIUMTEXT CHARACTER SET utf8;
+  CREATE TABLE t1 AS SELECT var;
+END;
+$$
+DELIMITER ;$$
+SHOW CREATE TABLE t1;
+DROP TABLE t1;
+
+DELIMITER $$;
+BEGIN NOT ATOMIC
+  DECLARE var LONGTEXT CHARACTER SET utf8;
+  CREATE TABLE t1 AS SELECT var;
+END;
+$$
+DELIMITER ;$$
+SHOW CREATE TABLE t1;
+DROP TABLE t1;
+
+
+DELIMITER $$;
+BEGIN NOT ATOMIC
+  DECLARE var CHAR(1);
+  CREATE TABLE t1 AS SELECT var;
+END;
+$$
+DELIMITER ;$$
+SHOW CREATE TABLE t1;
+DROP TABLE t1;
+
+
+DELIMITER $$;
+BEGIN NOT ATOMIC
+  DECLARE var ENUM('a');
+  CREATE TABLE t1 AS SELECT var;
+END;
+$$
+DELIMITER ;$$
+SHOW CREATE TABLE t1;
+DROP TABLE t1;