← Back to branch summary

~posulliv/drizzle/optimizer-style-cleanup

« back to all changes in this revision

Viewing changes to tests/r/subselect3.result

  • Committer: Padraig O'Sullivan
  • Date: 2010-03-15 14:05:26 UTC
  • mfrom: (1237.9.99 staging)
  • Revision ID: osullivan.padraig@gmail.com-20100315140526-opbgwdwn6tfecdkq
Merge from trunk.

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.