diff options
| author | bell@sanja.is.com.ua <> | 2004-06-16 16:06:30 +0300 |
|---|---|---|
| committer | bell@sanja.is.com.ua <> | 2004-06-16 16:06:30 +0300 |
| commit | 002364c20f6b888b8c22ea18b371e0cb8ebb61ca (patch) | |
| tree | 3f53a24eec02fe30a114eaa94e8e6840596cbe92 /mysql-test/t/union.test | |
| parent | 5f8ef7a38d6e649c127029c44357f2c1fed5ee73 (diff) | |
| download | mariadb-git-002364c20f6b888b8c22ea18b371e0cb8ebb61ca.tar.gz | |
new length detection for non-string in UNION (BUG#4067)
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; |