← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/endspace.result

  • Committer: Stewart Smith
  • Date: 2010-12-02 04:36:22 UTC
  • mto: (2021.1.2 build)
  • mto: This revision was merged to the branch mainline in revision 1971.
  • Revision ID: stewart@flamingspork.com-20101202043622-vxiij48ug09z7h1u
EXPLAIN in test result changes due to modified InnoDB stats

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/endspace.result
81
81
|teststring |
82
82
select concat('|', text1, '|') from t1 where text1='teststring' or text1 > 'teststring\t';
83
83
concat('|', text1, '|')
 
84
|teststring|
84
85
|teststring |
85
 
|teststring|
86
86
select concat('|', text1, '|') from t1 where text1='teststring';
87
87
concat('|', text1, '|')
88
88
|teststring|
92
92
alter table t1 modify text1 text not null;
93
93
select concat('|', text1, '|') from t1 where text1='teststring';
94
94
concat('|', text1, '|')
 
95
|teststring|
95
96
|teststring |
96
 
|teststring|
97
97
select concat('|', text1, '|') from t1 where text1='teststring ';
98
98
concat('|', text1, '|')
 
99
|teststring|
99
100
|teststring |
100
 
|teststring|
101
101
explain select concat('|', text1, '|') from t1 where text1='teststring ';
102
102
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
103
103
1       SIMPLE  t1      ref     key1    key1    82      const   2       Using where
108
108
select concat('|', text1, '|') from t1 where text1='teststring' or text1 like 'teststring_%';
109
109
concat('|', text1, '|')
110
110
|teststring     |
111
 
|teststring |
112
111
|teststring|
 
112
|teststring |
113
113
select concat('|', text1, '|') from t1 where text1='teststring' or text1 > 'teststring\t';
114
114
concat('|', text1, '|')
 
115
|teststring|
115
116
|teststring |
116
 
|teststring|
117
117
select concat('|', text1, '|') from t1 order by text1;
118
118
concat('|', text1, '|')
119
119
|nothing|