diff options
| author | timour/timka@lamia.home <> | 2006-08-23 18:22:53 +0300 |
|---|---|---|
| committer | timour/timka@lamia.home <> | 2006-08-23 18:22:53 +0300 |
| commit | 70f76e457fcde4017e813e2a9b0b06ec5d194cff (patch) | |
| tree | b8e88eb53fa7d7f799c39b7d4fe13bb628d27676 /mysql-test/t/distinct.test | |
| parent | 64092ca93b0c898b668af2f4b27f61ab354f511d (diff) | |
| parent | de723f2998b48b6815239e15b2c92d3e38ee8c15 (diff) | |
| download | mariadb-git-70f76e457fcde4017e813e2a9b0b06ec5d194cff.tar.gz | |
Merge lamia.home:/home/timka/mysql/src/4.1-bug-21456
into lamia.home:/home/timka/mysql/src/5.0-bug-21456
Diffstat (limited to 'mysql-test/t/distinct.test')
| -rw-r--r-- | mysql-test/t/distinct.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/distinct.test b/mysql-test/t/distinct.test index 61250a7105e..e517380ba9b 100644 --- a/mysql-test/t/distinct.test +++ b/mysql-test/t/distinct.test @@ -385,6 +385,17 @@ insert into t1 values (1, "line number one"), (2, "line number two"), (3, "line select distinct id, IFNULL(dsc, '-') from t1; drop table t1; +# +# Bug 21456: SELECT DISTINCT(x) produces incorrect results when using order by +# +CREATE TABLE t1 (a int primary key, b int); + +INSERT INTO t1 (a,b) values (1,1), (2,3), (3,2); + +explain SELECT DISTINCT a, b FROM t1 ORDER BY b; +SELECT DISTINCT a, b FROM t1 ORDER BY b; +DROP TABLE t1; + # End of 4.1 tests |