← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/subselect_no_mat.result

Merged with trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/subselect_no_mat.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