← Back to branch summary

~eday/drizzle/eday-dev

« back to all changes in this revision

Viewing changes to tests/r/subselect_no_mat_and_semi_join.result

  • Committer: Eric Day
  • Date: 2010-01-07 20:02:38 UTC
  • mfrom: (971.3.291 staging)
  • Revision ID: eday@oddments.org-20100107200238-uqw8v6kv9pl7nny5
Merged trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/subselect_no_mat_and_semi_join.result
724
724
Warnings:
725
725
Note    1249    Select 3 was reduced during optimization
726
726
Note    1249    Select 2 was reduced during optimization
727
 
Note    1003    select `test`.`t2`.`id` AS `id` from `test`.`t2` where (`test`.`t2`.`id` = (1 + 1))
 
727
Note    1003    select `test`.`t2`.`id` AS `id` from `test`.`t2` where (`test`.`t2`.`id` = <cache>((1 + 1)))
728
728
EXPLAIN EXTENDED SELECT * FROM t2 WHERE id IN (SELECT 1 UNION SELECT 3);
729
729
id      select_type     table   type    possible_keys   key     key_len ref     rows    filtered        Extra
730
730
1       PRIMARY t2      index   NULL    id      5       NULL    2       100.00  Using where; Using index