1
drop table if exists `T1`;
2
drop table if exists `T2`;
3
drop table if exists `T3`;
4
drop table if exists `T4`;
5
drop table if exists `T5`;
6
drop table if exists `T6`;
7
drop table if exists `T7`;
8
drop table if exists `T8`;
9
drop table if exists `T9`;
10
CREATE TABLE `T1` (`C1` char(5), INDEX(`C1`)) engine = innodb;
11
CREATE TABLE `T2` (`C1` char(5), INDEX(`C1`)) engine = innodb;
12
CREATE TABLE `T3` (`C1` char(5), INDEX(`C1`)) engine = innodb;
13
CREATE TEMPORARY TABLE `T4` (`C1` char(5), INDEX(`C1`)) engine = myisam;
14
CREATE TEMPORARY TABLE `T5` (`C1` char(5), INDEX(`C1`)) engine = myisam;
15
CREATE TEMPORARY TABLE `T6` (`C1` char(5), INDEX(`C1`)) engine = myisam;
16
CREATE TEMPORARY TABLE `T7` (`C1` char(5), INDEX(`C1`)) engine = MEMORY;
17
CREATE TEMPORARY TABLE `T8` (`C1` char(5), INDEX(`C1`)) engine = MEMORY;
18
CREATE TEMPORARY TABLE `T9` (`C1` char(5), INDEX(`C1`)) engine = MEMORY;
19
INSERT INTO `T1` VALUES ('アイウエオ');
20
INSERT INTO `T2` VALUES ('あいうえお');
21
INSERT INTO `T3` VALUES ('龔龖龗龞龡');
22
INSERT INTO `T4` VALUES ('アイウエオ');
23
INSERT INTO `T5` VALUES ('あいうえお');
24
INSERT INTO `T6` VALUES ('龔龖龗龞龡');
25
INSERT INTO `T7` VALUES ('アイウエオ');
26
INSERT INTO `T8` VALUES ('あいうえお');
27
INSERT INTO `T9` VALUES ('龔龖龗龞龡');
28
SELECT LOCATE('ア',`C1`) from `T1`;
31
SELECT LOCATE('イ',`C1`) from `T1`;
34
SELECT LOCATE('ウ',`C1`) from `T1`;
37
SELECT LOCATE('エ',`C1`) from `T1`;
40
SELECT LOCATE('オ',`C1`) from `T1`;
43
SELECT LOCATE('ン',`C1`) from `T1`;
46
SELECT LOCATE('あ',`C1`) from `T2`;
49
SELECT LOCATE('い',`C1`) from `T2`;
52
SELECT LOCATE('う',`C1`) from `T2`;
55
SELECT LOCATE('え',`C1`) from `T2`;
58
SELECT LOCATE('お',`C1`) from `T2`;
61
SELECT LOCATE('ん',`C1`) from `T2`;
64
SELECT LOCATE('龔',`C1`) from `T3`;
67
SELECT LOCATE('龖',`C1`) from `T3`;
70
SELECT LOCATE('龗',`C1`) from `T3`;
73
SELECT LOCATE('龞',`C1`) from `T3`;
76
SELECT LOCATE('龡',`C1`) from `T3`;
79
SELECT LOCATE('丂',`C1`) from `T3`;
82
SELECT LOCATE('ア',`C1`) from `T4`;
85
SELECT LOCATE('イ',`C1`) from `T4`;
88
SELECT LOCATE('ウ',`C1`) from `T4`;
91
SELECT LOCATE('エ',`C1`) from `T4`;
94
SELECT LOCATE('オ',`C1`) from `T4`;
97
SELECT LOCATE('ン',`C1`) from `T4`;
100
SELECT LOCATE('あ',`C1`) from `T5`;
103
SELECT LOCATE('い',`C1`) from `T5`;
106
SELECT LOCATE('う',`C1`) from `T5`;
109
SELECT LOCATE('え',`C1`) from `T5`;
112
SELECT LOCATE('お',`C1`) from `T5`;
115
SELECT LOCATE('ん',`C1`) from `T5`;
118
SELECT LOCATE('龔',`C1`) from `T6`;
121
SELECT LOCATE('龖',`C1`) from `T6`;
124
SELECT LOCATE('龗',`C1`) from `T6`;
127
SELECT LOCATE('龞',`C1`) from `T6`;
130
SELECT LOCATE('龡',`C1`) from `T6`;
133
SELECT LOCATE('丂',`C1`) from `T6`;
136
SELECT LOCATE('ア',`C1`) from `T7`;
139
SELECT LOCATE('イ',`C1`) from `T7`;
142
SELECT LOCATE('ウ',`C1`) from `T7`;
145
SELECT LOCATE('エ',`C1`) from `T7`;
148
SELECT LOCATE('オ',`C1`) from `T7`;
151
SELECT LOCATE('ン',`C1`) from `T7`;
154
SELECT LOCATE('あ',`C1`) from `T8`;
157
SELECT LOCATE('い',`C1`) from `T8`;
160
SELECT LOCATE('う',`C1`) from `T8`;
163
SELECT LOCATE('え',`C1`) from `T8`;
166
SELECT LOCATE('お',`C1`) from `T8`;
169
SELECT LOCATE('ん',`C1`) from `T8`;
172
SELECT LOCATE('龔',`C1`) from `T9`;
175
SELECT LOCATE('龖',`C1`) from `T9`;
178
SELECT LOCATE('龗',`C1`) from `T9`;
181
SELECT LOCATE('龞',`C1`) from `T9`;
184
SELECT LOCATE('龡',`C1`) from `T9`;
187
SELECT LOCATE('丂',`C1`) from `T9`;