diff options
| author | gkodinov/kgeorge@rakia.gmz <> | 2007-01-22 12:58:14 +0200 |
|---|---|---|
| committer | gkodinov/kgeorge@rakia.gmz <> | 2007-01-22 12:58:14 +0200 |
| commit | c9df1caac83eac107acb0acfecf3b0a950e7ffa5 (patch) | |
| tree | f26f72c7fc4ccfd9a2e0c207aa91436890405bd8 /mysql-test/r/order_by.result | |
| parent | a5a43da10eb3acce08804b649e5ec4e7fc18ee10 (diff) | |
| parent | 9ea140d13ebb5c32b28bec568aebceede53da36e (diff) | |
| download | mariadb-git-c9df1caac83eac107acb0acfecf3b0a950e7ffa5.tar.gz | |
Merge gkodinov@bk-internal.mysql.com:/home/bk/mysql-5.1-opt
into rakia.gmz:/home/kgeorge/mysql/autopush/B16590-5.1-opt
Diffstat (limited to 'mysql-test/r/order_by.result')
| -rw-r--r-- | mysql-test/r/order_by.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/order_by.result b/mysql-test/r/order_by.result index 8d09686b7d3..a056e1244e6 100644 --- a/mysql-test/r/order_by.result +++ b/mysql-test/r/order_by.result @@ -926,3 +926,12 @@ NULL 2 3 DROP TABLE t1,t2,t3,t4; +CREATE TABLE t1 (a INT, b INT, PRIMARY KEY (a), UNIQUE KEY b (b)); +INSERT INTO t1 VALUES (1,1),(2,2); +CREATE TABLE t2 (a INT, b INT, KEY a (a,b)); +INSERT INTO t2 VALUES (1,1),(1,2),(2,1),(2,2); +EXPLAIN SELECT 1 FROM t1,t2 WHERE t1.b=2 AND t1.a=t2.a ORDER BY t2.b; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 const PRIMARY,b b 5 const 1 +1 SIMPLE t2 ref a a 5 const 2 Using where; Using index +DROP TABLE t1,t2; |