← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/bug588408.result

  • Committer: Stewart Smith
  • Date: 2010-06-04 05:06:08 UTC
  • mto: This revision was merged to the branch mainline in revision 1594.
  • Revision ID: stewart@flamingspork.com-20100604050608-42p0t0jinjtqxln6
update bug lp:588408 for Drizzle EXPLAIN results

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/bug588408.result
118
118
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
119
119
1       PRIMARY <derived2>      system  NULL    NULL    NULL    NULL    0       const row not found
120
120
3       SUBQUERY        t2      ALL     NULL    NULL    NULL    NULL    2       
121
 
2       DERIVED NULL    NULL    NULL    NULL    NULL    NULL    NULL    no matching row in const table
 
121
2       DERIVED empty1  ALL     NULL    NULL    NULL    NULL    1       
122
122
 
123
123
#
124
124
# 5) Test that subquery materialization is setup for query with
142
142
SELECT v
143
143
FROM t2);
144
144
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
145
 
1       PRIMARY NULL    NULL    NULL    NULL    NULL    NULL    NULL    Impossible WHERE noticed after reading const tables
 
145
1       PRIMARY t1      index   NULL    PRIMARY 4       NULL    2       Using where; Using index
146
146
3       SUBQUERY        t2      ALL     NULL    NULL    NULL    NULL    2       
 
147
2       SUBQUERY        t3      index   PRIMARY PRIMARY 4       NULL    1       Using where; Using index
147
148
#
148
149
# Cleanup for BUG#46680
149
150
#