← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/distinct.result

  • Committer: Padraig O'Sullivan
  • Date: 2009-09-13 00:53:34 UTC
  • mto: (1126.9.2 captain-20090915-01)
  • mto: This revision was merged to the branch mainline in revision 1133.
  • Revision ID: osullivan.padraig@gmail.com-20090913005334-6wio2sbjugskfbm3
Added calls to the connection start/end dtrace probes.

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;
215
198
select distinct 1 from t1,t3 where t1.a=t3.a;
216
199
1
217
200
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   #
234
201
explain SELECT distinct t1.a from t1;
235
202
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
236
203
1       SIMPLE  t1      index   NULL    PRIMARY 4       NULL    4       Using index