diff options
| author | unknown <sergefp@mysql.com> | 2007-04-19 03:04:23 +0400 |
|---|---|---|
| committer | unknown <sergefp@mysql.com> | 2007-04-19 03:04:23 +0400 |
| commit | 1b8ecd274e2a3f20b45c8b96831758757582f4fd (patch) | |
| tree | 2b2aa2b9fc008b77ea52d7e165721541d4e67717 /mysql-test/r/join.result | |
| parent | 3e8252ffc6ff28df8b0dbadcfea6ca506a731cbf (diff) | |
| download | mariadb-git-1b8ecd274e2a3f20b45c8b96831758757582f4fd.tar.gz | |
BUG#27939: Early NULLs filtering doesn't work for eq_ref access
- Turn it on for JT_EQ_REF access method
mysql-test/r/join.result:
BUG#27939: Testcase
mysql-test/t/join.test:
BUG#27939: Testcase
Diffstat (limited to 'mysql-test/r/join.result')
| -rw-r--r-- | mysql-test/r/join.result | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/mysql-test/r/join.result b/mysql-test/r/join.result index af2d4bed592..c785c3be379 100644 --- a/mysql-test/r/join.result +++ b/mysql-test/r/join.result @@ -779,4 +779,32 @@ Field Type Null Key Default Extra Name varchar(50) YES NULL DROP VIEW v1; DROP TABLE t1,t2,tv1,tv2; +create table t1 (a int, b int); +insert into t1 values +(NULL, 1), +(NULL, 2), +(NULL, 3), +(NULL, 4); +create table t2 (a int not null, primary key(a)); +insert into t2 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); +create table t3 (a int not null, primary key(a)); +insert into t3 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); +flush status; +select * from t1, t2, t3 where t3.a=t1.a and t2.a=t1.b; +a b a a +explain select * from t1, t2, t3 where t3.a=t1.a and t2.a=t1.b; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 ALL NULL NULL NULL NULL 4 +1 SIMPLE t2 eq_ref PRIMARY PRIMARY 4 test.t1.b 1 Using index +1 SIMPLE t3 eq_ref PRIMARY PRIMARY 4 test.t1.a 1 Using index +We expect rnd_next=5, and read_key must be 0 because of short-cutting: +show status like 'Handler_read%'; +Variable_name Value +Handler_read_first 0 +Handler_read_key 0 +Handler_read_next 0 +Handler_read_prev 0 +Handler_read_rnd 0 +Handler_read_rnd_next 5 +drop table t1, t2, t3; End of 5.0 tests. |