diff options
| author | gkodinov/kgeorge@magare.gmz <> | 2007-05-04 17:46:13 +0300 |
|---|---|---|
| committer | gkodinov/kgeorge@magare.gmz <> | 2007-05-04 17:46:13 +0300 |
| commit | 19b9c7a8cda743d45464c5b1fbd571de073e26ea (patch) | |
| tree | 6d7efb7e612974c99c5eeebafa8d78a6ce9ee97b /mysql-test/r/join.result | |
| parent | 5b4448ef704fedf9d6cbb15a6fec0261717dec0e (diff) | |
| parent | cead246f7a0fe90405f4137930137c00af652a8c (diff) | |
| download | mariadb-git-19b9c7a8cda743d45464c5b1fbd571de073e26ea.tar.gz | |
Merge magare.gmz:/home/kgeorge/mysql/work/B27531-5.0-opt
into magare.gmz:/home/kgeorge/mysql/work/B27531-5.1-opt-after-merge
Diffstat (limited to 'mysql-test/r/join.result')
| -rw-r--r-- | mysql-test/r/join.result | 50 |
1 files changed, 50 insertions, 0 deletions
diff --git a/mysql-test/r/join.result b/mysql-test/r/join.result index b132c8b2e4c..07035a12483 100644 --- a/mysql-test/r/join.result +++ b/mysql-test/r/join.result @@ -391,6 +391,56 @@ i i i 2 NULL 4 2 2 2 drop table t1,t2,t3; +CREATE TABLE t1 (a int, b int default 0, c int default 1); +INSERT INTO t1 (a) VALUES (1),(2),(3),(4),(5),(6),(7),(8); +INSERT INTO t1 (a) SELECT a + 8 FROM t1; +INSERT INTO t1 (a) SELECT a + 16 FROM t1; +CREATE TABLE t2 (a int, d int, e int default 0); +INSERT INTO t2 (a, d) VALUES (1,1),(2,2),(3,3),(4,4); +INSERT INTO t2 (a, d) SELECT a+4, a+4 FROM t2; +INSERT INTO t2 (a, d) SELECT a+8, a+8 FROM t2; +EXPLAIN +SELECT STRAIGHT_JOIN t2.e FROM t1,t2 WHERE t2.d=1 AND t1.b=t2.e +ORDER BY t1.b, t1.c; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 ALL NULL NULL NULL NULL 32 Using temporary; Using filesort +1 SIMPLE t2 ALL NULL NULL NULL NULL 16 Using where +SELECT STRAIGHT_JOIN t2.e FROM t1,t2 WHERE t2.d=1 AND t1.b=t2.e +ORDER BY t1.b, t1.c; +e +0 +0 +0 +0 +0 +0 +0 +0 +0 +0 +0 +0 +0 +0 +0 +0 +0 +0 +0 +0 +0 +0 +0 +0 +0 +0 +0 +0 +0 +0 +0 +0 +DROP TABLE t1,t2; create table t1 (c int, b int); create table t2 (a int, b int); create table t3 (b int, c int); |