From db2ce1edf6e1f7e322b573f01a86bd18d55f9b59 Mon Sep 17 00:00:00 2001
From: "bell@sanja.is.com.ua" <>
Date: Thu, 26 May 2005 17:30:12 +0300
Subject: fixed problem with long string results of expressions in UNIONS
 (BUG#10025)

---
 mysql-test/t/union.test | 11 +++++++++++
 1 file changed, 11 insertions(+)

(limited to 'mysql-test/t/union.test')

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;
-- 
cgit v1.2.1