mysql-test/main/endspace.result

24 insert into t1 values ('teststring'), ('nothing'), ('teststring\t');
28 select * from t1 ignore key (key1) where text1='teststring' or
31 teststring
32 teststring
33 select * from t1 where text1='teststring' or text1 like 'teststring_%';
35 teststring
36 teststring
37 select * from t1 where text1='teststring' or text1 > 'teststring\t';
39 teststring
43 teststring
44 teststring
52 select * from t1 ignore key (key1) where text1='teststring' or
55 teststring
56 teststring
57 select concat('|', text1, '|') as c from t1 where text1='teststring' or text1 like 'teststring_%' o…
59 |teststring	|
60 |teststring|
61 select concat('|', text1, '|') from t1 where text1='teststring' or text1 > 'teststring\t';
63 |teststring|
67 teststring		11
68 teststring	10
72 teststring	10
73 teststring		11
75 insert into t1 values ('teststring ');
79 |teststring|
80 |teststring	|
81 |teststring |
82 select concat('|', text1, '|') from t1 where text1='teststring' or text1 > 'teststring\t';
84 |teststring|
85 |teststring |
86 select concat('|', text1, '|') from t1 where text1='teststring';
88 |teststring|
89 select concat('|', text1, '|') from t1 where text1='teststring ';
91 |teststring |
93 select concat('|', text1, '|') from t1 where text1='teststring';
95 |teststring|
96 |teststring |
97 select concat('|', text1, '|') from t1 where text1='teststring ';
99 |teststring|
100 |teststring |
101 explain select concat('|', text1, '|') from t1 where text1='teststring ';
106 |teststring	|
107 |teststring |
108 select concat('|', text1, '|') as c from t1 where text1='teststring' or text1 like 'teststring_%' o…
110 |teststring	|
111 |teststring |
112 |teststring|
113 select concat('|', text1, '|') from t1 where text1='teststring' or text1 > 'teststring\t';
115 |teststring|
116 |teststring |
120 |teststring	|
121 |teststring|
122 |teststring |
125 insert into t1 values ('teststring'), ('nothing'), ('teststring\t');
126 select concat('|', text1, '|') as c from t1 where text1='teststring' or text1 like 'teststring_%' o…
128 |teststring	|
129 |teststring|
130 select concat('|', text1, '|') from t1 where text1='teststring' or text1 >= 'teststring\t';
132 |teststring	|
133 |teststring|
136 insert into t1 values ('teststring'), ('nothing'), ('teststring\t');
137 select * from t1 ignore key (key1) where text1='teststring' or
140 teststring
141 teststring
142 select * from t1 where text1='teststring' or text1 like 'teststring_%';
144 teststring
145 teststring
146 select * from t1 where text1='teststring' or text1 >= 'teststring\t';
148 teststring
149 teststring
153 teststring
154 teststring
162 teststring
163 teststring
166 insert into t1 values ('teststring'), ('nothing'), ('teststring\t');
170 select * from t1 where text1='teststring' or text1 like 'teststring_%';
172 teststring
173 teststring
174 select * from t1 where text1='teststring' or text1 > 'teststring\t';
176 teststring
180 teststring
181 teststring
189 teststring
190 teststring
192 insert into t1 values ('teststring ');
196 |teststring|
197 |teststring	|
198 |teststring |
202 teststring
203 teststring
204 select text1, length(text1) from t1 where text1='teststring' or text1 like 'teststring_%';
206 teststring		11
207 teststring	10
208 teststring 	11
209 select text1, length(text1) from t1 where text1='teststring' or text1 >= 'teststring\t';
211 teststring		11
212 teststring	10
213 teststring 	11
217 |teststring	|
218 |teststring|
219 |teststring |