← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/distinct.result

  • Committer: Brian Aker
  • Date: 2010-02-15 18:29:31 UTC
  • mto: (1273.13.68 build)
  • mto: This revision was merged to the branch mainline in revision 1303.
  • Revision ID: brian@gaz-20100215182931-ooy48h72plspoehy
More removal of show code.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/distinct.result
195
195
a
196
196
1
197
197
2
 
198
show status like 'Handler%';
 
199
Variable_name   Value
 
200
Handler_commit  #
 
201
Handler_delete  #
 
202
Handler_prepare #
 
203
Handler_read_first      #
 
204
Handler_read_key        #
 
205
Handler_read_next       #
 
206
Handler_read_prev       #
 
207
Handler_read_rnd        #
 
208
Handler_read_rnd_next   #
 
209
Handler_rollback        #
 
210
Handler_savepoint       #
 
211
Handler_savepoint_rollback      #
 
212
Handler_update  #
 
213
Handler_write   #
 
214
flush status;
198
215
select distinct 1 from t1,t3 where t1.a=t3.a;
199
216
1
200
217
1
 
218
show status like 'Handler%';
 
219
Variable_name   Value
 
220
Handler_commit  #
 
221
Handler_delete  #
 
222
Handler_prepare #
 
223
Handler_read_first      #
 
224
Handler_read_key        #
 
225
Handler_read_next       #
 
226
Handler_read_prev       #
 
227
Handler_read_rnd        #
 
228
Handler_read_rnd_next   #
 
229
Handler_rollback        #
 
230
Handler_savepoint       #
 
231
Handler_savepoint_rollback      #
 
232
Handler_update  #
 
233
Handler_write   #
201
234
explain SELECT distinct t1.a from t1;
202
235
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
203
236
1       SIMPLE  t1      index   NULL    PRIMARY 4       NULL    4       Using index