diff options
| author | unknown <bell@sanja.is.com.ua> | 2004-06-16 16:06:30 +0300 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2004-06-16 16:06:30 +0300 |
| commit | f0de86e86c07776ff3001a4da951034523fe600f (patch) | |
| tree | 3f53a24eec02fe30a114eaa94e8e6840596cbe92 /mysql-test/t/union.test | |
| parent | 93e9fd0c588aa6efd21ecefd90beb0c543fff64c (diff) | |
| download | mariadb-git-f0de86e86c07776ff3001a4da951034523fe600f.tar.gz | |
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
Diffstat (limited to 'mysql-test/t/union.test')
| -rw-r--r-- | mysql-test/t/union.test | 8 |
1 files changed, 8 insertions, 0 deletions
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; |