← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/select_safe.result

  • Committer: Joseph Daly
  • Date: 2010-08-19 01:17:00 UTC
  • mfrom: (1718 drizzle)
  • mto: (1725.1.2 build)
  • mto: This revision was merged to the branch mainline in revision 1726.
  • Revision ID: jdaly@rx7-20100819011700-zmv90s31dfjex4vu
merge trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/select_safe.result
62
62
explain select STRAIGHT_JOIN * from t1,t1 as t2 where t1.b=t2.b;
63
63
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
64
64
1       SIMPLE  t1      index   b       PRIMARY 4       NULL    20      
65
 
1       SIMPLE  t2      ref     b       b       83      test.t1.b       10      Using index
 
65
1       SIMPLE  t2      ref     b       b       83      test.t1.b       10      Using where; Using index
66
66
set MAX_SEEKS_FOR_KEY=1;
67
67
explain select STRAIGHT_JOIN * from t1,t1 as t2 where t1.b=t2.b;
68
68
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
69
69
1       SIMPLE  t1      index   b       PRIMARY 4       NULL    20      
70
 
1       SIMPLE  t2      ref     b       b       83      test.t1.b       10      Using index
 
70
1       SIMPLE  t2      ref     b       b       83      test.t1.b       10      Using where; Using index
71
71
SET MAX_SEEKS_FOR_KEY=DEFAULT;
72
72
drop table t1;
73
73
create table t1 (a int);