~drizzle-trunk/drizzle/development : contents of mysql-test/suite/jp/r/jp_where

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

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`;
drop table if exists `sPP`;
drop table if exists `sPQ`;
SET NAMES sjis;
SET character_set_database = sjis;
CREATE TABLE `sP` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = innodb;
CREATE TABLE `sQ` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = innodb;
CREATE TABLE `sR` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = innodb;
CREATE TABLE `sS` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = myisam;
CREATE TABLE `sT` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = myisam;
CREATE TABLE `sU` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = myisam;
CREATE TABLE `sV` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = heap;
CREATE TABLE `sW` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = heap;
CREATE TABLE `sX` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = heap;
CREATE TABLE `sPO` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = bdb;
CREATE TABLE `sPP` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = bdb;
CREATE TABLE `sPQ` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = bdb;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `sP`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `sQ`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `sR`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `sS`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `sT`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `sU`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `sV`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `sW`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `sX`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `sPO`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `sPP`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `sPQ`;
SELECT * FROM `sP` WHERE `bP` = '°±²³Žµ¶·ž¹º»ŒœŸ¿';
bP
°±²³Žµ¶·ž¹º»ŒœŸ¿
SELECT * FROM `sQ` WHERE `bP` = 'E ¡¢£€¥Š§š©ª«¬­®¯°±';
bP
E ¡¢£€¥Š§š©ª«¬­®¯°±
SELECT * FROM `sR` WHERE `bP` = '\\\\\\\\\\\\\\\\\\\\';
bP
\\\\\\\\\\\\\\\\\\\\
SELECT * FROM `sS` WHERE `bP` = '°±²³Žµ¶·ž¹º»ŒœŸ¿';
bP
°±²³Žµ¶·ž¹º»ŒœŸ¿
SELECT * FROM `sT` WHERE `bP` = 'E ¡¢£€¥Š§š©ª«¬­®¯°±';
bP
E ¡¢£€¥Š§š©ª«¬­®¯°±
SELECT * FROM `sU` WHERE `bP` = '\\\\\\\\\\\\\\\\\\\\';
bP
\\\\\\\\\\\\\\\\\\\\
SELECT * FROM `sV` WHERE `bP` = '°±²³Žµ¶·ž¹º»ŒœŸ¿';
bP
°±²³Žµ¶·ž¹º»ŒœŸ¿
SELECT * FROM `sW` WHERE `bP` = 'E ¡¢£€¥Š§š©ª«¬­®¯°±';
bP
E ¡¢£€¥Š§š©ª«¬­®¯°±
SELECT * FROM `sX` WHERE `bP` = '\\\\\\\\\\\\\\\\\\\\';
bP
\\\\\\\\\\\\\\\\\\\\
SELECT * FROM `sPO` WHERE `bP` = '°±²³Žµ¶·ž¹º»ŒœŸ¿';
bP
°±²³Žµ¶·ž¹º»ŒœŸ¿
SELECT * FROM `sPP` WHERE `bP` = 'E ¡¢£€¥Š§š©ª«¬­®¯°±';
bP
E ¡¢£€¥Š§š©ª«¬­®¯°±
SELECT * FROM `sPQ` WHERE `bP` = '\\\\\\\\\\\\\\\\\\\\';
bP
\\\\\\\\\\\\\\\\\\\\
CREATE TABLE t1(c1 char(1)) default charset = sjis engine=innodb;
CREATE TABLE t2(c1 char(1)) default charset = sjis engine=myisam;
CREATE TABLE t3(c1 char(1)) default charset = sjis engine=heap;
CREATE TABLE t4(c1 char(1)) default charset = sjis engine=bdb;
INSERT INTO t1 VALUES('S'),('s');
INSERT INTO t2 VALUES('S'),('s');
INSERT INTO t3 VALUES('S'),('s');
INSERT INTO t4 VALUES('S'),('s');
SELECT * FROM t1 WHERE c1 = 'S';
c1
S
SELECT * FROM t2 WHERE c1 = 'S';
c1
S
SELECT * FROM t3 WHERE c1 = 'S';
c1
S
SELECT * FROM t4 WHERE c1 = 'S';
c1
S
SELECT * FROM t1 WHERE c1 = 's';
c1
s
SELECT * FROM t2 WHERE c1 = 's';
c1
s
SELECT * FROM t3 WHERE c1 = 's';
c1
s
SELECT * FROM t4 WHERE c1 = 's';
c1
s
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	drop table if exists `sP`;
	2	drop table if exists `sQ`;
	3	drop table if exists `sR`;
	4	drop table if exists `sS`;
	5	drop table if exists `sT`;
	6	drop table if exists `sU`;
	7	drop table if exists `sV`;
	8	drop table if exists `sW`;
	9	drop table if exists `sX`;
	10	drop table if exists `sPO`;
	11	drop table if exists `sPP`;
	12	drop table if exists `sPQ`;
	13	SET NAMES sjis;
	14	SET character_set_database = sjis;
	15	CREATE TABLE `sP` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = innodb;
	16	CREATE TABLE `sQ` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = innodb;
	17	CREATE TABLE `sR` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = innodb;
	18	CREATE TABLE `sS` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = myisam;
	19	CREATE TABLE `sT` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = myisam;
	20	CREATE TABLE `sU` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = myisam;
	21	CREATE TABLE `sV` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = heap;
	22	CREATE TABLE `sW` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = heap;
	23	CREATE TABLE `sX` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = heap;
	24	CREATE TABLE `sPO` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = bdb;
	25	CREATE TABLE `sPP` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = bdb;
	26	CREATE TABLE `sPQ` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = bdb;
	27	LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `sP`;
	28	LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `sQ`;
	29	LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `sR`;
	30	LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `sS`;
	31	LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `sT`;
	32	LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `sU`;
	33	LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `sV`;
	34	LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `sW`;
	35	LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `sX`;
	36	LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `sPO`;
	37	LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `sPP`;
	38	LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `sPQ`;
	39	SELECT * FROM `sP` WHERE `bP` = '°±²³Žµ¶·ž¹º»ŒœŸ¿';
	40	bP
	41	°±²³Žµ¶·ž¹º»ŒœŸ¿
	42	SELECT * FROM `sQ` WHERE `bP` = 'E ¡¢£€¥Š§š©ª«¬®¯°±';
	43	bP
	44	E ¡¢£€¥Š§š©ª«¬®¯°±
	45	SELECT * FROM `sR` WHERE `bP` = '\\\\\\\\\\\\\\\\\\\\';
	46	bP
	47	\\\\\\\\\\\\\\\\\\\\
	48	SELECT * FROM `sS` WHERE `bP` = '°±²³Žµ¶·ž¹º»ŒœŸ¿';
	49	bP
	50	°±²³Žµ¶·ž¹º»ŒœŸ¿
	51	SELECT * FROM `sT` WHERE `bP` = 'E ¡¢£€¥Š§š©ª«¬®¯°±';
	52	bP
	53	E ¡¢£€¥Š§š©ª«¬®¯°±
	54	SELECT * FROM `sU` WHERE `bP` = '\\\\\\\\\\\\\\\\\\\\';
	55	bP
	56	\\\\\\\\\\\\\\\\\\\\
	57	SELECT * FROM `sV` WHERE `bP` = '°±²³Žµ¶·ž¹º»ŒœŸ¿';
	58	bP
	59	°±²³Žµ¶·ž¹º»ŒœŸ¿
	60	SELECT * FROM `sW` WHERE `bP` = 'E ¡¢£€¥Š§š©ª«¬®¯°±';
	61	bP
	62	E ¡¢£€¥Š§š©ª«¬®¯°±
	63	SELECT * FROM `sX` WHERE `bP` = '\\\\\\\\\\\\\\\\\\\\';
	64	bP
65	\\\\\\\\\\\\\\\\\\\\
66	SELECT * FROM `sPO` WHERE `bP` = '°±²³Žµ¶·ž¹º»ŒœŸ¿';
67	bP
68	°±²³Žµ¶·ž¹º»ŒœŸ¿
69	SELECT * FROM `sPP` WHERE `bP` = 'E ¡¢£€¥Š§š©ª«¬®¯°±';
70	bP
71	E ¡¢£€¥Š§š©ª«¬®¯°±
72	SELECT * FROM `sPQ` WHERE `bP` = '\\\\\\\\\\\\\\\\\\\\';
73	bP
74	\\\\\\\\\\\\\\\\\\\\
75	CREATE TABLE t1(c1 char(1)) default charset = sjis engine=innodb;
76	CREATE TABLE t2(c1 char(1)) default charset = sjis engine=myisam;
77	CREATE TABLE t3(c1 char(1)) default charset = sjis engine=heap;
78	CREATE TABLE t4(c1 char(1)) default charset = sjis engine=bdb;
79	INSERT INTO t1 VALUES('S'),('s');
80	INSERT INTO t2 VALUES('S'),('s');
81	INSERT INTO t3 VALUES('S'),('s');
82	INSERT INTO t4 VALUES('S'),('s');
83	SELECT * FROM t1 WHERE c1 = 'S';
84	c1
85	S
86	SELECT * FROM t2 WHERE c1 = 'S';
87	c1
88	S
89	SELECT * FROM t3 WHERE c1 = 'S';
90	c1
91	S
92	SELECT * FROM t4 WHERE c1 = 'S';
93	c1
94	S
95	SELECT * FROM t1 WHERE c1 = 's';
96	c1
97	s
98	SELECT * FROM t2 WHERE c1 = 's';
99	c1
100	s
101	SELECT * FROM t3 WHERE c1 = 's';
102	c1
103	s
104	SELECT * FROM t4 WHERE c1 = 's';
105	c1
106	s
107	DROP TABLE `sP`;
108	DROP TABLE `sQ`;
109	DROP TABLE `sR`;
110	DROP TABLE `sS`;
111	DROP TABLE `sT`;
112	DROP TABLE `sU`;
113	DROP TABLE `sV`;
114	DROP TABLE `sW`;
115	DROP TABLE `sX`;
116	DROP TABLE `sPO`;
117	DROP TABLE `sPP`;
118	DROP TABLE `sPQ`;