mysql-test/t/endspace.test

17 insert into t1 values ('teststring'), ('nothing'), ('teststring\t');
22 select * from t1 ignore key (key1) where text1='teststring' or
24 select * from t1 where text1='teststring' or text1 like 'teststring_%';
25 select * from t1 where text1='teststring' or text1 > 'teststring\t';
31 select * from t1 ignore key (key1) where text1='teststring' or
33 select concat('|', text1, '|') as c from t1 where text1='teststring' or text1 like 'teststring_%' o…
34 select concat('|', text1, '|') from t1 where text1='teststring' or text1 > 'teststring\t';
39 insert into t1 values ('teststring ');
41 select concat('|', text1, '|') from t1 where text1='teststring' or text1 > 'teststring\t';
42 select concat('|', text1, '|') from t1 where text1='teststring';
43 select concat('|', text1, '|') from t1 where text1='teststring ';
49 select concat('|', text1, '|') from t1 where text1='teststring';
50 select concat('|', text1, '|') from t1 where text1='teststring ';
51 explain select concat('|', text1, '|') from t1 where text1='teststring ';
53 select concat('|', text1, '|') as c from t1 where text1='teststring' or text1 like 'teststring_%' o…
54 select concat('|', text1, '|') from t1 where text1='teststring' or text1 > 'teststring\t';
59 insert into t1 values ('teststring'), ('nothing'), ('teststring\t');
60 select concat('|', text1, '|') as c from t1 where text1='teststring' or text1 like 'teststring_%' o…
61 select concat('|', text1, '|') from t1 where text1='teststring' or text1 >= 'teststring\t';
67 insert into t1 values ('teststring'), ('nothing'), ('teststring\t');
68 select * from t1 ignore key (key1) where text1='teststring' or
70 select * from t1 where text1='teststring' or text1 like 'teststring_%';
71 select * from t1 where text1='teststring' or text1 >= 'teststring\t';
84 insert into t1 values ('teststring'), ('nothing'), ('teststring\t');
89 select * from t1 where text1='teststring' or text1 like 'teststring_%';
90 select * from t1 where text1='teststring' or text1 > 'teststring\t';
98 insert into t1 values ('teststring ');
105 select text1, length(text1) from t1 where text1='teststring' or text1 like 'teststring_%';
106 select text1, length(text1) from t1 where text1='teststring' or text1 >= 'teststring\t';