fixed problem with long string results of expressions in UNIONS (BUG#10025)

1 files changed, 11 insertions, 0 deletions

diff --git a/mysql-test/t/union.test b/mysql-test/t/union.test
index b0446e1ea4a..ffc7e718e9d 100644
--- a/mysql-test/t/union.test
+++ b/mysql-test/t/union.test
@@ -742,3 +742,14 @@ create table t2 select a from t1 union select c from t1;
 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;