diff options
| author | Igor Babaev <igor@askmonty.org> | 2011-10-29 15:36:24 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2011-10-29 15:36:24 -0700 |
| commit | 7bc6a83b027aeddbe1d84ceb6647928d5cfb3bca (patch) | |
| tree | fac26c78c875d41b56489aa8f8f5a4811b0ab428 /mysql-test/r/myisam_icp.result | |
| parent | a8f5b5e866eb5f0cc9f8e01ed88cf56df93f8abf (diff) | |
| download | mariadb-git-7bc6a83b027aeddbe1d84ceb6647928d5cfb3bca.tar.gz | |
Backported the fix and the test case for bug #58816 from mysql-5.6 code line.
Diffstat (limited to 'mysql-test/r/myisam_icp.result')
| -rw-r--r-- | mysql-test/r/myisam_icp.result | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/mysql-test/r/myisam_icp.result b/mysql-test/r/myisam_icp.result index 249b5a73f8b..cd51b0b9c94 100644 --- a/mysql-test/r/myisam_icp.result +++ b/mysql-test/r/myisam_icp.result @@ -443,6 +443,29 @@ pk i set optimizer_switch=@save_optimizer_switch; DROP TABLE t1, t2; # +# Bug #58816 "Extra temporary duplicate rows in result set when +# switching ICP off" +# +set @save_optimizer_switch= @@optimizer_switch; +CREATE TABLE t1 ( +pk INT NOT NULL, +c1 INT NOT NULL, +PRIMARY KEY (pk) +); +INSERT INTO t1 VALUES (1,9),(2,7),(3,6),(4,3),(5,1); +EXPLAIN SELECT pk, c1 FROM t1 WHERE pk <> 3; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 ALL PRIMARY NULL NULL NULL 5 Using where +SET SESSION optimizer_switch='index_condition_pushdown=off'; +SELECT pk, c1 FROM t1 WHERE pk <> 3; +pk c1 +1 9 +2 7 +4 3 +5 1 +DROP TABLE t1; +set optimizer_switch= @save_optimizer_switch; +# # BUG#778434 Wrong result with in_to_exists=on in maria-5.3-mwl89 # CREATE TABLE t1 ( f11 int) ; |