diff options
| author | unknown <serg@serg.mylan> | 2005-05-28 01:28:18 +0200 |
|---|---|---|
| committer | unknown <serg@serg.mylan> | 2005-05-28 01:28:18 +0200 |
| commit | 260bfacaa9104290c77f9742a9fa871a643a922c (patch) | |
| tree | 80915f4cb7be15d9964fb93e81281b658ce0961c /mysql-test/t/union.test | |
| parent | b4859c59d51baa12e6ee9f6950c024af3ef2a6fd (diff) | |
| parent | 755d2018ada199005b70b4836f6fbb56e2e7b892 (diff) | |
| download | mariadb-git-260bfacaa9104290c77f9742a9fa871a643a922c.tar.gz | |
merged
innobase/row/row0mysql.c:
Auto merged
sql/hash_filo.h:
Auto merged
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 af548074aa9..4da19622dcb 100644 --- a/mysql-test/t/union.test +++ b/mysql-test/t/union.test @@ -773,6 +773,16 @@ alter table t2 ROW_FORMAT=fixed; show create table t2; drop table t1,t2; +# +# 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 |