diff options
| author | unknown <timour/timka@lamia.home> | 2006-08-29 16:39:09 +0300 |
|---|---|---|
| committer | unknown <timour/timka@lamia.home> | 2006-08-29 16:39:09 +0300 |
| commit | 2592d4a1399bc1d5a05c8184c19fcddfa661e141 (patch) | |
| tree | 7fdd514b21c469056458913aa4a76cfcb7ca6d46 /mysql-test/r/distinct.result | |
| parent | e454fb0c9dd768ff7198d177253d9e6fe95511b2 (diff) | |
| parent | e3181c59e7962657bf6a273db68e0649d5372bba (diff) | |
| download | mariadb-git-2592d4a1399bc1d5a05c8184c19fcddfa661e141.tar.gz | |
Merge lamia.home:/home/timka/mysql/src/5.0-bug-21456
into lamia.home:/home/timka/mysql/src/5.1-bug-21456
mysql-test/r/distinct.result:
Auto merged
sql/sql_select.cc:
Auto merged
Diffstat (limited to 'mysql-test/r/distinct.result')
| -rw-r--r-- | mysql-test/r/distinct.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/distinct.result b/mysql-test/r/distinct.result index fab0bc18a09..72c040cb25f 100644 --- a/mysql-test/r/distinct.result +++ b/mysql-test/r/distinct.result @@ -563,6 +563,17 @@ id IFNULL(dsc, '-') 2 line number two 3 line number three drop table t1; +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; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 ALL NULL NULL NULL NULL 3 Using filesort +SELECT DISTINCT a, b FROM t1 ORDER BY b; +a b +1 1 +3 2 +2 3 +DROP TABLE t1; CREATE TABLE t1 ( ID int(11) NOT NULL auto_increment, x varchar(20) default NULL, |