diff options
| author | bell@sanja.is.com.ua <> | 2005-05-26 18:33:57 +0300 |
|---|---|---|
| committer | bell@sanja.is.com.ua <> | 2005-05-26 18:33:57 +0300 |
| commit | b186d8b4f95c2dcb4255887296f38241c8de114e (patch) | |
| tree | 536889ecee6039bac9f98d66fc242133e71c9961 /mysql-test/t/union.test | |
| parent | 5d0bc0b4826b2f0304faa02381ef8a5d9932b640 (diff) | |
| parent | db2ce1edf6e1f7e322b573f01a86bd18d55f9b59 (diff) | |
| download | mariadb-git-b186d8b4f95c2dcb4255887296f38241c8de114e.tar.gz | |
merge
Diffstat (limited to 'mysql-test/t/union.test')
| -rw-r--r-- | mysql-test/t/union.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/union.test b/mysql-test/t/union.test index ecd98428b5a..3666e3c3127 100644 --- a/mysql-test/t/union.test +++ b/mysql-test/t/union.test @@ -743,6 +743,16 @@ create table t2 select a from t1 union select b from t1; show columns from t2; drop table t2, t1; +# +# correct conversion long string to TEXT (BUG#10025) +# +CREATE TABLE t1 (a mediumtext); +CREATE TABLE t2 (b varchar(20)); +INSERT INTO t1 VALUES ('a'),('b'); +SELECT left(a,100000000) FROM t1 UNION SELECT b FROM t2; +create table t3 SELECT left(a,100000000) FROM t1 UNION SELECT b FROM t2; +show create table t3; +drop tables t1,t2,t3; # # Bug #10032 Bug in parsing UNION with ORDER BY when one node does not use FROM |