From f0de86e86c07776ff3001a4da951034523fe600f Mon Sep 17 00:00:00 2001 From: unknown Date: Wed, 16 Jun 2004 16:06:30 +0300 Subject: new length detection for non-string in UNION (BUG#4067) mysql-test/r/subselect.result: new length in UNION mysql-test/r/union.result: new length in UNION test of int with wrong display length mysql-test/t/union.test: test of int with wrong display length sql/item.cc: new length detection for non-string sql/item.h: new length detection for non-string --- mysql-test/t/union.test | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'mysql-test/t/union.test') diff --git a/mysql-test/t/union.test b/mysql-test/t/union.test index f6006a87d47..b21f635162f 100644 --- a/mysql-test/t/union.test +++ b/mysql-test/t/union.test @@ -527,3 +527,11 @@ CREATE TABLE t2 (i int(11) default NULL,c char(1) default NULL,KEY i (i)); --error 1054 explain (select * from t1) union (select * from t2) order by not_existing_column; drop table t1, t2; + +# +# length detecting +# +CREATE TABLE t1 (uid int(1)); +INSERT INTO t1 SELECT 150; +SELECT 'a' UNION SELECT uid FROM t1; +drop table t1; -- cgit v1.2.1