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_mrr.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_mrr.result')
| -rw-r--r-- | mysql-test/r/myisam_mrr.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/myisam_mrr.result b/mysql-test/r/myisam_mrr.result index f98504bbcda..bf513779dc0 100644 --- a/mysql-test/r/myisam_mrr.result +++ b/mysql-test/r/myisam_mrr.result @@ -350,7 +350,7 @@ GROUP BY t2.pk ); id select_type table type possible_keys key key_len ref rows filtered Extra 1 PRIMARY t1 system NULL NULL NULL NULL 1 100.00 -2 SUBQUERY t2 ref int_key int_key 5 const 1 100.00 Using index condition; Using where; Using filesort +2 SUBQUERY t2 ref int_key int_key 5 const 1 100.00 Using where; Using filesort Warnings: Note 1003 select min(1) AS `MIN(t1.pk)` from `test`.`t1` where exists(select `test`.`t2`.`pk` from `test`.`t2` where isnull(`test`.`t2`.`int_key`) group by `test`.`t2`.`pk`) DROP TABLE t1, t2; |