diff options
| author | Sergey Glukhov <Sergey.Glukhov@sun.com> | 2010-09-16 16:20:35 +0400 |
|---|---|---|
| committer | Sergey Glukhov <Sergey.Glukhov@sun.com> | 2010-09-16 16:20:35 +0400 |
| commit | dcad3feb1c4c75633ffa3024d5d2f2ddd1efdb4a (patch) | |
| tree | 65a93d10b2a6623731030885591ad60f8d3bbec3 /mysql-test/include | |
| parent | 327eb7b680f3afbe8e98c2b693a34247fb67e020 (diff) | |
| parent | 86d7cbd450ab53012e4f4f892e4cdb6093a7313b (diff) | |
| download | mariadb-git-dcad3feb1c4c75633ffa3024d5d2f2ddd1efdb4a.tar.gz | |
5.1-bugteam->5.5-merge
Diffstat (limited to 'mysql-test/include')
| -rw-r--r-- | mysql-test/include/index_merge_ror_cpk.inc | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/include/index_merge_ror_cpk.inc b/mysql-test/include/index_merge_ror_cpk.inc index cfc2ed3885e..3912aa34026 100644 --- a/mysql-test/include/index_merge_ror_cpk.inc +++ b/mysql-test/include/index_merge_ror_cpk.inc @@ -126,3 +126,19 @@ WHERE drop table t1; +--echo # +--echo # Bug#50402 Optimizer producing wrong results when using Index Merge on InnoDB +--echo # +CREATE TABLE t1 (f1 INT, PRIMARY KEY (f1)); +INSERT INTO t1 VALUES (2); +CREATE TABLE t2 (f1 INT, f2 INT, f3 char(1), + PRIMARY KEY (f1), KEY (f2), KEY (f3) ); +INSERT INTO t2 VALUES (1, 1, 'h'), (2, 3, 'h'), (3, 2, ''), (4, 2, ''); + +SELECT t1.f1 FROM t1 +WHERE (SELECT COUNT(*) FROM t2 WHERE t2.f3 = 'h' AND t2.f2 = t1.f1) = 0 AND t1.f1 = 2; + +EXPLAIN SELECT t1.f1 FROM t1 +WHERE (SELECT COUNT(*) FROM t2 WHERE t2.f3 = 'h' AND t2.f2 = t1.f1) = 0 AND t1.f1 = 2; + +DROP TABLE t1,t2; |