← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/subselect3.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/subselect3.result
59
59
0
60
60
show status like 'Handler_read_rnd_next';
61
61
Variable_name   Value
62
 
Handler_read_rnd_next   11
 
62
Handler_read_rnd_next   #
63
63
select ' ^ This must show 11' Z;
64
64
Z
65
65
 ^ This must show 11
99
99
1       1
100
100
show status like '%Handler_read_rnd_next';
101
101
Variable_name   Value
102
 
Handler_read_rnd_next   5
 
102
Handler_read_rnd_next   #
103
103
delete from t2;
104
104
insert into t2 values (NULL, 0),(NULL, 0), (NULL, 0), (NULL, 0);
105
105
flush status;
111
111
0       NULL    0
112
112
show status like '%Handler_read%';
113
113
Variable_name   Value
114
 
Handler_read_first      5
115
 
Handler_read_key        10
116
 
Handler_read_next       0
117
 
Handler_read_prev       0
118
 
Handler_read_rnd        0
119
 
Handler_read_rnd_next   29
 
114
Handler_read_first      #
 
115
Handler_read_key        #
 
116
Handler_read_next       #
 
117
Handler_read_prev       #
 
118
Handler_read_rnd        #
 
119
Handler_read_rnd_next   #
120
120
select 'No key lookups, seq reads: 29= 5 reads from t2 + 4 * 6 reads from t1.' Z;
121
121
Z
122
122
No key lookups, seq reads: 29= 5 reads from t2 + 4 * 6 reads from t1.