diff options
| author | gkodinov/kgeorge@macbook.gmz <> | 2007-03-09 15:20:06 +0200 |
|---|---|---|
| committer | gkodinov/kgeorge@macbook.gmz <> | 2007-03-09 15:20:06 +0200 |
| commit | 6bea442d269478810611c1ea9f56b2a76b5ecb07 (patch) | |
| tree | 709ccaff88ce0d930c23fdbf0044d218ca6f92d8 /mysql-test/r | |
| parent | 47c044e418464e7dcd1ef043af2a979b61358605 (diff) | |
| download | mariadb-git-6bea442d269478810611c1ea9f56b2a76b5ecb07.tar.gz | |
WL#3527: Extend IGNORE INDEX so places where index is ignored can
be specified
5.0 part of the fix. Implements IGNORE INDEX FOR JOIN as a synonym
of IGNORE INDEX for backward compatibility with the 5.1 fix.
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/select.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/select.result b/mysql-test/r/select.result index 44063c1e890..6fbe0a3b9df 100644 --- a/mysql-test/r/select.result +++ b/mysql-test/r/select.result @@ -3611,3 +3611,12 @@ id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t2 range si,ai si 5 NULL 2 Using where 1 SIMPLE t3 eq_ref PRIMARY,ci PRIMARY 4 test.t2.a 1 Using where DROP TABLE t1,t2,t3; +CREATE TABLE t1 (a INT, b INT, KEY (a)); +INSERT INTO t1 VALUES (1,1),(2,2); +EXPLAIN SELECT 1 FROM t1 WHERE a = 1; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 ref a a 5 const 1 Using where; Using index +EXPLAIN SELECT 1 FROM t1 IGNORE INDEX FOR JOIN (a) WHERE a = 1; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 ALL NULL NULL NULL NULL 2 Using where +DROP TABLE t1; |