1--source include/have_sjis.inc
2--source include/have_innodb.inc
3--character_set sjis
4--disable_warnings
5drop table if exists `�s�P`;
6drop table if exists `�s�Q`;
7drop table if exists `�s�R`;
8drop table if exists `�s�S`;
9drop table if exists `�s�T`;
10drop table if exists `�s�U`;
11drop table if exists `�s�V`;
12drop table if exists `�s�W`;
13drop table if exists `�s�X`;
14--enable_warnings
15
16#
17# Test LOCATE() function with Japanese characters in sjis encoding
18#
19
20SET NAMES sjis;
21SET character_set_database = sjis;
22CREATE TABLE `�s�P` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
23CREATE TABLE `�s�Q` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
24CREATE TABLE `�s�R` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
25CREATE TABLE `�s�S` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
26CREATE TABLE `�s�T` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
27CREATE TABLE `�s�U` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
28CREATE TABLE `�s�V` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY;
29CREATE TABLE `�s�W` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY;
30CREATE TABLE `�s�X` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY;
31
32INSERT INTO `�s�P` VALUES ('�����');
33INSERT INTO `�s�Q` VALUES ('����������');
34INSERT INTO `�s�R` VALUES ('�\�\�\�\�\');
35INSERT INTO `�s�S` VALUES ('�����');
36INSERT INTO `�s�T` VALUES ('����������');
37INSERT INTO `�s�U` VALUES ('�\�\�\�\�\');
38INSERT INTO `�s�V` VALUES ('�����');
39INSERT INTO `�s�W` VALUES ('����������');
40INSERT INTO `�s�X` VALUES ('�\�\�\�\�\');
41
42#InnoDB
43SELECT LOCATE('�',`�b�P`) from `�s�P`;
44SELECT LOCATE('�',`�b�P`) from `�s�P`;
45SELECT LOCATE('�',`�b�P`) from `�s�P`;
46SELECT LOCATE('�',`�b�P`) from `�s�P`;
47SELECT LOCATE('�',`�b�P`) from `�s�P`;
48SELECT LOCATE('�',`�b�P`) from `�s�P`;
49SELECT LOCATE('��',`�b�P`) from `�s�Q`;
50SELECT LOCATE('��',`�b�P`) from `�s�Q`;
51SELECT LOCATE('��',`�b�P`) from `�s�Q`;
52SELECT LOCATE('��',`�b�P`) from `�s�Q`;
53SELECT LOCATE('��',`�b�P`) from `�s�Q`;
54SELECT LOCATE('��',`�b�P`) from `�s�Q`;
55SELECT LOCATE('�\',`�b�P`) from `�s�R`;
56SELECT LOCATE('�\',`�b�P`) from `�s�R`;
57SELECT LOCATE('�\',`�b�P`) from `�s�R`;
58SELECT LOCATE('�\',`�b�P`) from `�s�R`;
59SELECT LOCATE('�\',`�b�P`) from `�s�R`;
60SELECT LOCATE('�\',`�b�P`) from `�s�R`;
61
62#MyISAM
63SELECT LOCATE('�',`�b�P`) from `�s�S`;
64SELECT LOCATE('�',`�b�P`) from `�s�S`;
65SELECT LOCATE('�',`�b�P`) from `�s�S`;
66SELECT LOCATE('�',`�b�P`) from `�s�S`;
67SELECT LOCATE('�',`�b�P`) from `�s�S`;
68SELECT LOCATE('�',`�b�P`) from `�s�S`;
69SELECT LOCATE('��',`�b�P`) from `�s�T`;
70SELECT LOCATE('��',`�b�P`) from `�s�T`;
71SELECT LOCATE('��',`�b�P`) from `�s�T`;
72SELECT LOCATE('��',`�b�P`) from `�s�T`;
73SELECT LOCATE('��',`�b�P`) from `�s�T`;
74SELECT LOCATE('��',`�b�P`) from `�s�T`;
75SELECT LOCATE('�\',`�b�P`) from `�s�U`;
76SELECT LOCATE('�\',`�b�P`) from `�s�U`;
77SELECT LOCATE('�\',`�b�P`) from `�s�U`;
78SELECT LOCATE('�\',`�b�P`) from `�s�U`;
79SELECT LOCATE('�\',`�b�P`) from `�s�U`;
80SELECT LOCATE('�\',`�b�P`) from `�s�U`;
81
82
83#MEMORY
84SELECT LOCATE('�',`�b�P`) from `�s�V`;
85SELECT LOCATE('�',`�b�P`) from `�s�V`;
86SELECT LOCATE('�',`�b�P`) from `�s�V`;
87SELECT LOCATE('�',`�b�P`) from `�s�V`;
88SELECT LOCATE('�',`�b�P`) from `�s�V`;
89SELECT LOCATE('�',`�b�P`) from `�s�V`;
90SELECT LOCATE('��',`�b�P`) from `�s�W`;
91SELECT LOCATE('��',`�b�P`) from `�s�W`;
92SELECT LOCATE('��',`�b�P`) from `�s�W`;
93SELECT LOCATE('��',`�b�P`) from `�s�W`;
94SELECT LOCATE('��',`�b�P`) from `�s�W`;
95SELECT LOCATE('��',`�b�P`) from `�s�W`;
96SELECT LOCATE('�\',`�b�P`) from `�s�X`;
97SELECT LOCATE('�\',`�b�P`) from `�s�X`;
98SELECT LOCATE('�\',`�b�P`) from `�s�X`;
99SELECT LOCATE('�\',`�b�P`) from `�s�X`;
100SELECT LOCATE('�\',`�b�P`) from `�s�X`;
101SELECT LOCATE('�\',`�b�P`) from `�s�X`;
102
103
104DROP TABLE `�s�P`;
105DROP TABLE `�s�Q`;
106DROP TABLE `�s�R`;
107DROP TABLE `�s�S`;
108DROP TABLE `�s�T`;
109DROP TABLE `�s�U`;
110DROP TABLE `�s�V`;
111DROP TABLE `�s�W`;
112DROP TABLE `�s�X`;
113