~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/explain.result

  • Committer: Brian Aker
  • Date: 2010-03-31 19:14:14 UTC
  • Revision ID: brian@gaz-20100331191414-9yv44mmpvf0tb7l1
Updated to use show schemas specific table.

Show diffs side-by-side

added added

removed removed

Lines of Context:
49
49
insert into ☃ (☢) values (2);
50
50
explain select ☢ from ☃ where ☢=1;
51
51
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
52
 
1       SIMPLE  ☃       ref     ☢,☣     ☢       5       const   1       Using where; Using index
 
52
1       SIMPLE  ☃       ref     ☢,☣     ☢       5       const   1       Using index
53
53
drop table ☃;
54
54
select 3 into @v1;
55
55
explain select 3 into @v1;