diff options
| author | unknown <timour@askmonty.org> | 2011-03-01 14:16:28 +0200 |
|---|---|---|
| committer | unknown <timour@askmonty.org> | 2011-03-01 14:16:28 +0200 |
| commit | 7895c35874c76a88d7b1be609f06fbe6f266aab7 (patch) | |
| tree | a1f57cf7c7bb129bb67d0aed5176d0bcaf4b7920 /mysql-test/r/myisam_mrr.result | |
| parent | 39616eb9ef974c69e73bcb80cd7e3c40228910fd (diff) | |
| parent | 759d71eba1842bbde7b44fc42e1098590b136320 (diff) | |
| download | mariadb-git-7895c35874c76a88d7b1be609f06fbe6f266aab7.tar.gz | |
MWL#89
Merge MWL#89 with 5.3.
Diffstat (limited to 'mysql-test/r/myisam_mrr.result')
| -rw-r--r-- | mysql-test/r/myisam_mrr.result | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/r/myisam_mrr.result b/mysql-test/r/myisam_mrr.result index d0f0d12c28e..9a55458d32c 100644 --- a/mysql-test/r/myisam_mrr.result +++ b/mysql-test/r/myisam_mrr.result @@ -347,10 +347,10 @@ WHERE t2.int_key IS NULL GROUP BY t2.pk ); id select_type table type possible_keys key key_len ref rows filtered Extra -1 PRIMARY NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE -2 SUBQUERY t2 ref int_key int_key 5 1 100.00 Using index condition; Using where; Using filesort +1 PRIMARY NULL NULL NULL NULL NULL NULL NULL NULL Select tables optimized away +2 SUBQUERY t2 ref int_key int_key 5 const 1 100.00 Using index condition; Using where; Using filesort Warnings: -Note 1003 select min(`test`.`t1`.`pk`) AS `MIN(t1.pk)` from `test`.`t1` where 0 +Note 1003 select min(`test`.`t1`.`pk`) 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; # # BUG#42048 Discrepancy between MyISAM and Maria's ICP implementation |