~drizzle-trunk/drizzle/development : contents of mysql-test/suite/jp/t/jp_locate

~drizzle-trunk/drizzle/development : (revision 33)

--character_set sjis
--disable_warnings
drop table if exists `sP`;
drop table if exists `sQ`;
drop table if exists `sR`;
drop table if exists `sS`;
drop table if exists `sT`;
drop table if exists `sU`;
drop table if exists `sV`;
drop table if exists `sW`;
drop table if exists `sX`;
drop table if exists `sPO`;
--enable_warnings

#
# Test LOCATE() function with Japanese characters in sjis encoding
#

SET NAMES sjis;
SET character_set_database = sjis;
CREATE TABLE `sP` (`bP` char(5), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = innodb;
CREATE TABLE `sQ` (`bP` char(5), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = innodb;
CREATE TABLE `sR` (`bP` char(5), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = innodb;
CREATE TABLE `sS` (`bP` char(5), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = myisam;
CREATE TABLE `sT` (`bP` char(5), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = myisam;
CREATE TABLE `sU` (`bP` char(5), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = myisam;
CREATE TABLE `sV` (`bP` char(5), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = heap;
CREATE TABLE `sW` (`bP` char(5), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = heap;
CREATE TABLE `sX` (`bP` char(5), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = heap;
CREATE TABLE `sPO` (`bP` char(5), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = bdb;
CREATE TABLE `sPP` (`bP` char(5), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = bdb;
CREATE TABLE `sPQ` (`bP` char(5), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = bdb;

INSERT INTO `sP` VALUES ('±²³Žµ');
INSERT INTO `sQ` VALUES (' ¢€Šš');
INSERT INTO `sR` VALUES ('\\\\\');
INSERT INTO `sS` VALUES ('±²³Žµ');
INSERT INTO `sT` VALUES (' ¢€Šš');
INSERT INTO `sU` VALUES ('\\\\\');
INSERT INTO `sV` VALUES ('±²³Žµ');
INSERT INTO `sW` VALUES (' ¢€Šš');
INSERT INTO `sX` VALUES ('\\\\\');
INSERT INTO `sPO` VALUES ('±²³Žµ');
INSERT INTO `sPP` VALUES (' ¢€Šš');
INSERT INTO `sPQ` VALUES ('\\\\\');

#InnoDB
SELECT LOCATE('±',`bP`) from `sP`;
SELECT LOCATE('²',`bP`) from `sP`;
SELECT LOCATE('³',`bP`) from `sP`;
SELECT LOCATE('Ž',`bP`) from `sP`;
SELECT LOCATE('µ',`bP`) from `sP`;
SELECT LOCATE('Ý',`bP`) from `sP`;
SELECT LOCATE(' ',`bP`) from `sQ`;
SELECT LOCATE('¢',`bP`) from `sQ`;
SELECT LOCATE('€',`bP`) from `sQ`;
SELECT LOCATE('Š',`bP`) from `sQ`;
SELECT LOCATE('š',`bP`) from `sQ`;
SELECT LOCATE('ñ',`bP`) from `sQ`;
SELECT LOCATE('\',`bP`) from `sR`;
SELECT LOCATE('\',`bP`) from `sR`;
SELECT LOCATE('\',`bP`) from `sR`;
SELECT LOCATE('\',`bP`) from `sR`;
SELECT LOCATE('\',`bP`) from `sR`;
SELECT LOCATE('\',`bP`) from `sR`;

#MyISAM
SELECT LOCATE('±',`bP`) from `sS`;
SELECT LOCATE('²',`bP`) from `sS`;
SELECT LOCATE('³',`bP`) from `sS`;
SELECT LOCATE('Ž',`bP`) from `sS`;
SELECT LOCATE('µ',`bP`) from `sS`;
SELECT LOCATE('Ý',`bP`) from `sS`;
SELECT LOCATE(' ',`bP`) from `sT`;
SELECT LOCATE('¢',`bP`) from `sT`;
SELECT LOCATE('€',`bP`) from `sT`;
SELECT LOCATE('Š',`bP`) from `sT`;
SELECT LOCATE('š',`bP`) from `sT`;
SELECT LOCATE('ñ',`bP`) from `sT`;
SELECT LOCATE('\',`bP`) from `sU`;
SELECT LOCATE('\',`bP`) from `sU`;
SELECT LOCATE('\',`bP`) from `sU`;
SELECT LOCATE('\',`bP`) from `sU`;
SELECT LOCATE('\',`bP`) from `sU`;
SELECT LOCATE('\',`bP`) from `sU`;


#HEAP
SELECT LOCATE('±',`bP`) from `sV`;
SELECT LOCATE('²',`bP`) from `sV`;
SELECT LOCATE('³',`bP`) from `sV`;
SELECT LOCATE('Ž',`bP`) from `sV`;
SELECT LOCATE('µ',`bP`) from `sV`;
SELECT LOCATE('Ý',`bP`) from `sV`;
SELECT LOCATE(' ',`bP`) from `sW`;
SELECT LOCATE('¢',`bP`) from `sW`;
SELECT LOCATE('€',`bP`) from `sW`;
SELECT LOCATE('Š',`bP`) from `sW`;
SELECT LOCATE('š',`bP`) from `sW`;
SELECT LOCATE('ñ',`bP`) from `sW`;
SELECT LOCATE('\',`bP`) from `sX`;
SELECT LOCATE('\',`bP`) from `sX`;
SELECT LOCATE('\',`bP`) from `sX`;
SELECT LOCATE('\',`bP`) from `sX`;
SELECT LOCATE('\',`bP`) from `sX`;
SELECT LOCATE('\',`bP`) from `sX`;


#BDB
SELECT LOCATE('±',`bP`) from `sPO`;
SELECT LOCATE('²',`bP`) from `sPO`;
SELECT LOCATE('³',`bP`) from `sPO`;
SELECT LOCATE('Ž',`bP`) from `sPO`;
SELECT LOCATE('µ',`bP`) from `sPO`;
SELECT LOCATE('Ý',`bP`) from `sPO`;
SELECT LOCATE(' ',`bP`) from `sPP`;
SELECT LOCATE('¢',`bP`) from `sPP`;
SELECT LOCATE('€',`bP`) from `sPP`;
SELECT LOCATE('Š',`bP`) from `sPP`;
SELECT LOCATE('š',`bP`) from `sPP`;
SELECT LOCATE('ñ',`bP`) from `sPP`;
SELECT LOCATE('\',`bP`) from `sPQ`;
SELECT LOCATE('\',`bP`) from `sPQ`;
SELECT LOCATE('\',`bP`) from `sPQ`;
SELECT LOCATE('\',`bP`) from `sPQ`;
SELECT LOCATE('\',`bP`) from `sPQ`;
SELECT LOCATE('\',`bP`) from `sPQ`;


DROP TABLE `sP`;
DROP TABLE `sQ`;
DROP TABLE `sR`;
DROP TABLE `sS`;
DROP TABLE `sT`;
DROP TABLE `sU`;
DROP TABLE `sV`;
DROP TABLE `sW`;
DROP TABLE `sX`;
DROP TABLE `sPO`;
DROP TABLE `sPP`;
DROP TABLE `sPQ`;

1 by brian clean slate	1	--character_set sjis
	2	--disable_warnings
	3	drop table if exists `sP`;
	4	drop table if exists `sQ`;
	5	drop table if exists `sR`;
	6	drop table if exists `sS`;
	7	drop table if exists `sT`;
	8	drop table if exists `sU`;
	9	drop table if exists `sV`;
	10	drop table if exists `sW`;
	11	drop table if exists `sX`;
	12	drop table if exists `sPO`;
	13	--enable_warnings
	14
	15	#
	16	# Test LOCATE() function with Japanese characters in sjis encoding
	17	#
	18
	19	SET NAMES sjis;
	20	SET character_set_database = sjis;
	21	CREATE TABLE `sP` (`bP` char(5), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = innodb;
	22	CREATE TABLE `sQ` (`bP` char(5), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = innodb;
	23	CREATE TABLE `sR` (`bP` char(5), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = innodb;
	24	CREATE TABLE `sS` (`bP` char(5), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = myisam;
	25	CREATE TABLE `sT` (`bP` char(5), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = myisam;
	26	CREATE TABLE `sU` (`bP` char(5), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = myisam;
	27	CREATE TABLE `sV` (`bP` char(5), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = heap;
	28	CREATE TABLE `sW` (`bP` char(5), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = heap;
	29	CREATE TABLE `sX` (`bP` char(5), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = heap;
	30	CREATE TABLE `sPO` (`bP` char(5), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = bdb;
	31	CREATE TABLE `sPP` (`bP` char(5), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = bdb;
	32	CREATE TABLE `sPQ` (`bP` char(5), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = bdb;
	33
	34	INSERT INTO `sP` VALUES ('±²³Žµ');
	35	INSERT INTO `sQ` VALUES (' ¢€Šš');
	36	INSERT INTO `sR` VALUES ('\\\\\');
	37	INSERT INTO `sS` VALUES ('±²³Žµ');
	38	INSERT INTO `sT` VALUES (' ¢€Šš');
	39	INSERT INTO `sU` VALUES ('\\\\\');
	40	INSERT INTO `sV` VALUES ('±²³Žµ');
	41	INSERT INTO `sW` VALUES (' ¢€Šš');
	42	INSERT INTO `sX` VALUES ('\\\\\');
	43	INSERT INTO `sPO` VALUES ('±²³Žµ');
	44	INSERT INTO `sPP` VALUES (' ¢€Šš');
	45	INSERT INTO `sPQ` VALUES ('\\\\\');
	46
	47	#InnoDB
	48	SELECT LOCATE('±',`bP`) from `sP`;
	49	SELECT LOCATE('²',`bP`) from `sP`;
	50	SELECT LOCATE('³',`bP`) from `sP`;
	51	SELECT LOCATE('Ž',`bP`) from `sP`;
	52	SELECT LOCATE('µ',`bP`) from `sP`;
	53	SELECT LOCATE('Ý',`bP`) from `sP`;
	54	SELECT LOCATE(' ',`bP`) from `sQ`;
	55	SELECT LOCATE('¢',`bP`) from `sQ`;
	56	SELECT LOCATE('€',`bP`) from `sQ`;
	57	SELECT LOCATE('Š',`bP`) from `sQ`;
	58	SELECT LOCATE('š',`bP`) from `sQ`;
	59	SELECT LOCATE('ñ',`bP`) from `sQ`;
	60	SELECT LOCATE('\',`bP`) from `sR`;
	61	SELECT LOCATE('\',`bP`) from `sR`;
	62	SELECT LOCATE('\',`bP`) from `sR`;
	63	SELECT LOCATE('\',`bP`) from `sR`;
	64	SELECT LOCATE('\',`bP`) from `sR`;
65	SELECT LOCATE('\',`bP`) from `sR`;
66
67	#MyISAM
68	SELECT LOCATE('±',`bP`) from `sS`;
69	SELECT LOCATE('²',`bP`) from `sS`;
70	SELECT LOCATE('³',`bP`) from `sS`;
71	SELECT LOCATE('Ž',`bP`) from `sS`;
72	SELECT LOCATE('µ',`bP`) from `sS`;
73	SELECT LOCATE('Ý',`bP`) from `sS`;
74	SELECT LOCATE(' ',`bP`) from `sT`;
75	SELECT LOCATE('¢',`bP`) from `sT`;
76	SELECT LOCATE('€',`bP`) from `sT`;
77	SELECT LOCATE('Š',`bP`) from `sT`;
78	SELECT LOCATE('š',`bP`) from `sT`;
79	SELECT LOCATE('ñ',`bP`) from `sT`;
80	SELECT LOCATE('\',`bP`) from `sU`;
81	SELECT LOCATE('\',`bP`) from `sU`;
82	SELECT LOCATE('\',`bP`) from `sU`;
83	SELECT LOCATE('\',`bP`) from `sU`;
84	SELECT LOCATE('\',`bP`) from `sU`;
85	SELECT LOCATE('\',`bP`) from `sU`;
86
87
88	#HEAP
89	SELECT LOCATE('±',`bP`) from `sV`;
90	SELECT LOCATE('²',`bP`) from `sV`;
91	SELECT LOCATE('³',`bP`) from `sV`;
92	SELECT LOCATE('Ž',`bP`) from `sV`;
93	SELECT LOCATE('µ',`bP`) from `sV`;
94	SELECT LOCATE('Ý',`bP`) from `sV`;
95	SELECT LOCATE(' ',`bP`) from `sW`;
96	SELECT LOCATE('¢',`bP`) from `sW`;
97	SELECT LOCATE('€',`bP`) from `sW`;
98	SELECT LOCATE('Š',`bP`) from `sW`;
99	SELECT LOCATE('š',`bP`) from `sW`;
100	SELECT LOCATE('ñ',`bP`) from `sW`;
101	SELECT LOCATE('\',`bP`) from `sX`;
102	SELECT LOCATE('\',`bP`) from `sX`;
103	SELECT LOCATE('\',`bP`) from `sX`;
104	SELECT LOCATE('\',`bP`) from `sX`;
105	SELECT LOCATE('\',`bP`) from `sX`;
106	SELECT LOCATE('\',`bP`) from `sX`;
107
108
109	#BDB
110	SELECT LOCATE('±',`bP`) from `sPO`;
111	SELECT LOCATE('²',`bP`) from `sPO`;
112	SELECT LOCATE('³',`bP`) from `sPO`;
113	SELECT LOCATE('Ž',`bP`) from `sPO`;
114	SELECT LOCATE('µ',`bP`) from `sPO`;
115	SELECT LOCATE('Ý',`bP`) from `sPO`;
116	SELECT LOCATE(' ',`bP`) from `sPP`;
117	SELECT LOCATE('¢',`bP`) from `sPP`;
118	SELECT LOCATE('€',`bP`) from `sPP`;
119	SELECT LOCATE('Š',`bP`) from `sPP`;
120	SELECT LOCATE('š',`bP`) from `sPP`;
121	SELECT LOCATE('ñ',`bP`) from `sPP`;
122	SELECT LOCATE('\',`bP`) from `sPQ`;
123	SELECT LOCATE('\',`bP`) from `sPQ`;
124	SELECT LOCATE('\',`bP`) from `sPQ`;
125	SELECT LOCATE('\',`bP`) from `sPQ`;
126	SELECT LOCATE('\',`bP`) from `sPQ`;
127	SELECT LOCATE('\',`bP`) from `sPQ`;
128
129
130	DROP TABLE `sP`;
131	DROP TABLE `sQ`;
132	DROP TABLE `sR`;
133	DROP TABLE `sS`;
134	DROP TABLE `sT`;
135	DROP TABLE `sU`;
136	DROP TABLE `sV`;
137	DROP TABLE `sW`;
138	DROP TABLE `sX`;
139	DROP TABLE `sPO`;
140	DROP TABLE `sPP`;
141	DROP TABLE `sPQ`;