← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/derived.result

  • Committer: Monty Taylor
  • Date: 2008-12-24 19:15:51 UTC
  • mto: This revision was merged to the branch mainline in revision 751.
  • Revision ID: mordred@inaugust.com-20081224191551-21dhl54xpx5uuf3e
Fixed non-deterministic innodb explain output.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/derived.result
146
146
20      20
147
147
explain select count(*) from t1 as tt1, (select * from t1) as tt2;
148
148
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
149
 
1       PRIMARY tt1     index   NULL    a       4       NULL    8995    Using index
150
 
1       PRIMARY <derived2>      ALL     NULL    NULL    NULL    NULL    10000   Using join buffer
151
 
2       DERIVED t1      ALL     NULL    NULL    NULL    NULL    8995    
 
149
1       PRIMARY tt1     index   NULL    a       4       NULL    X       Using index
 
150
1       PRIMARY <derived2>      ALL     NULL    NULL    NULL    NULL    X       Using join buffer
 
151
2       DERIVED t1      ALL     NULL    NULL    NULL    NULL    X       
152
152
drop table t1;
153
153
SELECT * FROM (SELECT (SELECT * FROM (SELECT 1 as a) as a )) as b;
154
154
(SELECT * FROM (SELECT 1 as a) as a )