diff options
| author | monty@hundin.mysql.fi <> | 2001-09-17 22:44:51 +0300 |
|---|---|---|
| committer | monty@hundin.mysql.fi <> | 2001-09-17 22:44:51 +0300 |
| commit | bfc7394ec3780430a6e387f90dabfa350e418c1d (patch) | |
| tree | 84e69c2b39154e624f807c4628e21f3d0fdb1da3 /mysql-test/t/union.test | |
| parent | fe1753de5874fc055a9441c6d815f007e89515ba (diff) | |
| download | mariadb-git-bfc7394ec3780430a6e387f90dabfa350e418c1d.tar.gz | |
Fixed bug in UNION when doing UNION with the same tables
Diffstat (limited to 'mysql-test/t/union.test')
| -rw-r--r-- | mysql-test/t/union.test | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/mysql-test/t/union.test b/mysql-test/t/union.test index 8325e6c7e77..e780e9ec528 100644 --- a/mysql-test/t/union.test +++ b/mysql-test/t/union.test @@ -60,5 +60,6 @@ CREATE TABLE t1 ( ) TYPE=MyISAM; INSERT INTO t1 (pseudo,pseudo1,same) VALUES ('joce', 'testtt', 1),('joce', 'tsestset', 1),('dekad', 'joce', 1); SELECT pseudo FROM t1 WHERE pseudo1='joce' UNION SELECT pseudo FROM t1 WHERE pseudo='joce'; -SELECT * FROM t1 WHERE pseudo1='joce' UNION SELECT * FROM t1 WHERE pseudo='joce'; +SELECT pseudo1 FROM t1 WHERE pseudo1='joce' UNION SELECT pseudo1 FROM t1 WHERE pseudo='joce'; +SELECT * FROM t1 WHERE pseudo1='joce' UNION SELECT * FROM t1 WHERE pseudo='joce' order by pseudo desc; drop table t1; |