1SET DEFAULT_STORAGE_ENGINE='tokudb'; 2set names ascii; 3select 'e'='`'; 4'e'='`' 50 6select 'y'='~'; 7'y'='~' 80 9create table t1 (a char(1) character set ascii); 10insert into t1 (a) values (' '), ('a'), ('b'), ('c'), ('d'), ('e'), ('f'), ('g'), ('h'), ('i'), ('j'), ('k'), ('l'), ('m'), ('n'), ('o'), ('p'), ('q'), ('r'), ('s'), ('t'), ('u'), ('v'), ('w'), ('x'), ('y'), ('z'), ('A'), ('B'), ('C'), ('D'), ('E'), ('F'), ('G'), ('H'), ('I'), ('J'), ('K'), ('L'), ('M'), ('N'), ('O'), ('P'), ('Q'), ('R'), ('S'), ('T'), ('U'), ('V'), ('W'), ('X'), ('Y'), ('Z'), ('!'), ('@'), ('#'), ('$'), ('%'), ('^'), ('&'), ('*'), ('('), (')'), ('_'), ('+'), ('`'), ('~'), ('1'), ('2'), ('3'), ('4'), ('5'), ('6'), ('7'), ('8'), ('9'), ('0'), ('['), (']'), ('\\'), ('|'), ('}'), ('{'), ('"'), (':'), (''''), (';'), ('/'), ('.'), (','), ('?'), ('>'), ('<'), ('\n'), ('\t'), ('\a'), ('\f'), ('\v'); 11select t1a.a, t1b.a from t1 as t1a, t1 as t1b where t1a.a=t1b.a order by binary t1a.a, binary t1b.a; 12a a 13 14 15 16 17 18! ! 19" " 20# # 21$ $ 22% % 23& & 24' ' 25( ( 26) ) 27* * 28+ + 29, , 30. . 31/ / 320 0 331 1 342 2 353 3 364 4 375 5 386 6 397 7 408 8 419 9 42: : 43; ; 44< < 45> > 46? ? 47@ @ 48A A 49A a 50A a 51B B 52B b 53C C 54C c 55D D 56D d 57E E 58E e 59F F 60F f 61F f 62G G 63G g 64H H 65H h 66I I 67I i 68J J 69J j 70K K 71K k 72L L 73L l 74M M 75M m 76N N 77N n 78O O 79O o 80P P 81P p 82Q Q 83Q q 84R R 85R r 86S S 87S s 88T T 89T t 90U U 91U u 92V V 93V v 94V v 95W W 96W w 97X X 98X x 99Y Y 100Y y 101Z Z 102Z z 103[ [ 104\ \ 105] ] 106^ ^ 107_ _ 108` ` 109a A 110a A 111a a 112a a 113a a 114a a 115b B 116b b 117c C 118c c 119d D 120d d 121e E 122e e 123f F 124f F 125f f 126f f 127f f 128f f 129g G 130g g 131h H 132h h 133i I 134i i 135j J 136j j 137k K 138k k 139l L 140l l 141m M 142m m 143n N 144n n 145o O 146o o 147p P 148p p 149q Q 150q q 151r R 152r r 153s S 154s s 155t T 156t t 157u U 158u u 159v V 160v V 161v v 162v v 163v v 164v v 165w W 166w w 167x X 168x x 169y Y 170y y 171z Z 172z z 173{ { 174| | 175} } 176~ ~ 177drop table t1; 178End of 5.0 tests. 179