diff options
| author | evgen@moonbone.local <> | 2005-08-30 23:29:47 +0400 |
|---|---|---|
| committer | evgen@moonbone.local <> | 2005-08-30 23:29:47 +0400 |
| commit | 6ed72554480a0d9ccf2ca92bed8979d4d5d5deac (patch) | |
| tree | 2eec44168d9216c78f967e51c6830acdd67025a6 /mysql-test/t/create.test | |
| parent | 16e30aaf68012e4c4b0a7e7beb65dec4cfa60e3b (diff) | |
| parent | d76f9471cbc6e6916b4124320afa60a1dc92ef5a (diff) | |
| download | mariadb-git-6ed72554480a0d9ccf2ca92bed8979d4d5d5deac.tar.gz | |
manual merge of bug fix#12537
Diffstat (limited to 'mysql-test/t/create.test')
| -rw-r--r-- | mysql-test/t/create.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/create.test b/mysql-test/t/create.test index 3b4b86a3df3..55321a81f5e 100644 --- a/mysql-test/t/create.test +++ b/mysql-test/t/create.test @@ -493,6 +493,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; |