diff options
| author | unknown <gkodinov/kgeorge@magare.gmz> | 2007-03-09 16:30:44 +0200 |
|---|---|---|
| committer | unknown <gkodinov/kgeorge@magare.gmz> | 2007-03-09 16:30:44 +0200 |
| commit | 81beab69a4aae6097bea5e8a8a20c75340f03323 (patch) | |
| tree | f9a9c42b2d295c888edd7b7d83806cb6bd278077 /mysql-test/t/select.test | |
| parent | 52fb60dadf767690227afc6b7a7ec540e5b78be9 (diff) | |
| parent | ff79cd687090ec4afcdaaaf44c85849f057402c8 (diff) | |
| download | mariadb-git-81beab69a4aae6097bea5e8a8a20c75340f03323.tar.gz | |
Merge bk-internal:/home/bk/mysql-5.0-opt
into magare.gmz:/home/kgeorge/mysql/work/WL3527-5.0-opt-merge
sql/sql_yacc.yy:
Auto merged
mysql-test/r/select.result:
merge
mysql-test/t/select.test:
merge
Diffstat (limited to 'mysql-test/t/select.test')
| -rw-r--r-- | mysql-test/t/select.test | 11 |
1 files changed, 10 insertions, 1 deletions
diff --git a/mysql-test/t/select.test b/mysql-test/t/select.test index ea5fadb2e1b..39769dada60 100644 --- a/mysql-test/t/select.test +++ b/mysql-test/t/select.test @@ -3103,7 +3103,16 @@ SELECT t3.a FROM t1,t2,t3 t3.c IN ('bb','ee'); DROP TABLE t1,t2,t3; - + +# +# WL3527: Extend IGNORE INDEX so places where index is ignored can +# be specified +# +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; +EXPLAIN SELECT 1 FROM t1 IGNORE INDEX FOR JOIN (a) WHERE a = 1; +DROP TABLE t1; + # # Bug#25172: Not checked buffer size leads to a server crash # |