summaryrefslogtreecommitdiff
path: root/mysql-test/t/create.test
diff options
context:
space:
mode:
authorevgen@moonbone.local <>2005-08-31 21:24:25 +0400
committerevgen@moonbone.local <>2005-08-31 21:24:25 +0400
commitf917803e0c1460325594c55bb5c08587af9c60e0 (patch)
tree62eb1b72cb18e48aa8321b895a841de261dec2f9 /mysql-test/t/create.test
parent341eac5d25e2f48f459956d81c6204850bd8abcd (diff)
parent6ed72554480a0d9ccf2ca92bed8979d4d5d5deac (diff)
downloadmariadb-git-f917803e0c1460325594c55bb5c08587af9c60e0.tar.gz
Manual merged
Diffstat (limited to 'mysql-test/t/create.test')
-rw-r--r--mysql-test/t/create.test9
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/create.test b/mysql-test/t/create.test
index bc281d1e027..5cd92fbc21e 100644
--- a/mysql-test/t/create.test
+++ b/mysql-test/t/create.test
@@ -504,6 +504,15 @@ create table t2(test.t2.name int);
drop table t1,t2;
#
+# Bug #12537: UNION produces longtext instead of varchar
+#
+CREATE TABLE t1 (f1 VARCHAR(255) CHARACTER SET utf8);
+CREATE TABLE t2 AS SELECT LEFT(f1,86) AS f2 FROM t1 UNION SELECT LEFT(f1,86)
+AS f2 FROM t1;
+DESC t2;
+DROP TABLE t1,t2;
+
+#
# Bug#11028: Crash on create table like
#
create database mysqltest;