~drizzle-trunk/drizzle/development

1 by brian
clean slate
1
--character_set sjis
2
--disable_warnings
3
drop table if exists `‚s‚P`;
4
drop table if exists `‚s‚Q`;
5
drop table if exists `‚s‚R`;
6
drop table if exists `‚s‚S`;
7
drop table if exists `‚s‚T`;
8
drop table if exists `‚s‚U`;
9
drop table if exists `‚s‚V`;
10
drop table if exists `‚s‚W`;
11
drop table if exists `‚s‚X`;
12
drop table if exists `‚s‚P‚O`;
13
drop table if exists `‚s‚P‚P`;
14
drop table if exists `‚s‚P‚Q`;
15
--enable_warnings
16
17
#
18
# Test RPAD() function with Japanese character in sjis encoding
19
#
20
21
SET NAMES sjis;
22
SET character_set_database = sjis;
23
24
CREATE TABLE `‚s‚P` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = innodb;
25
CREATE TABLE `‚s‚Q` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = innodb;
26
CREATE TABLE `‚s‚R` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = innodb;
27
CREATE TABLE `‚s‚S` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = myisam;
28
CREATE TABLE `‚s‚T` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = myisam;
29
CREATE TABLE `‚s‚U` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = myisam;
30
CREATE TABLE `‚s‚V` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = heap;
31
CREATE TABLE `‚s‚W` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = heap;
32
CREATE TABLE `‚s‚X` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = heap;
33
CREATE TABLE `‚s‚P‚O` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = bdb;
34
CREATE TABLE `‚s‚P‚P` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = bdb;
35
CREATE TABLE `‚s‚P‚Q` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = bdb;
36
37
INSERT INTO `‚s‚P` VALUES ('±²³Žµ'),('±²³Ž'),('±²³'),('±²'),('±'),('');
38
INSERT INTO `‚s‚Q` VALUES ('‚ ‚¢‚€‚Š‚š'),('‚ ‚¢‚€‚Š'),('‚ ‚¢‚€'),('‚ ‚¢'),('‚ '),('');
39
INSERT INTO `‚s‚R` VALUES ('ƒ\\•\—\\'),('ƒ\\•\—\'),('ƒ\\•\'),('ƒ\\'),('ƒ\'),('');
40
INSERT INTO `‚s‚S` VALUES ('±²³Žµ'),('±²³Ž'),('±²³'),('±²'),('±'),('');
41
INSERT INTO `‚s‚T` VALUES ('‚ ‚¢‚€‚Š‚š'),('‚ ‚¢‚€‚Š'),('‚ ‚¢‚€'),('‚ ‚¢'),('‚ '),('');
42
INSERT INTO `‚s‚U` VALUES ('ƒ\\•\—\\'),('ƒ\\•\—\'),('ƒ\\•\'),('ƒ\\'),('ƒ\'),('');
43
INSERT INTO `‚s‚V` VALUES ('±²³Žµ'),('±²³Ž'),('±²³'),('±²'),('±'),('');
44
INSERT INTO `‚s‚W` VALUES ('‚ ‚¢‚€‚Š‚š'),('‚ ‚¢‚€‚Š'),('‚ ‚¢‚€'),('‚ ‚¢'),('‚ '),('');
45
INSERT INTO `‚s‚X` VALUES ('ƒ\\•\—\\'),('ƒ\\•\—\'),('ƒ\\•\'),('ƒ\\'),('ƒ\'),('');
46
INSERT INTO `‚s‚P‚O` VALUES ('±²³Žµ'),('±²³Ž'),('±²³'),('±²'),('±'),('');
47
INSERT INTO `‚s‚P‚P` VALUES ('‚ ‚¢‚€‚Š‚š'),('‚ ‚¢‚€‚Š'),('‚ ‚¢‚€'),('‚ ‚¢'),('‚ '),('');
48
INSERT INTO `‚s‚P‚Q` VALUES ('ƒ\\•\—\\'),('ƒ\\•\—\'),('ƒ\\•\'),('ƒ\\'),('ƒ\'),('');
49
50
#InnoDB
51
SELECT `‚b‚P`, RPAD(`‚b‚P`,5,'¡') FROM `‚s‚P`;
52
SELECT `‚b‚P`, RPAD(`‚b‚P`,5,'‚w') FROM `‚s‚Q`;
53
SELECT `‚b‚P`, RPAD(`‚b‚P`,5,'–\') FROM `‚s‚R`;
54
55
#MyISAM
56
SELECT `‚b‚P`, RPAD(`‚b‚P`,5,'¡') FROM `‚s‚S`;
57
SELECT `‚b‚P`, RPAD(`‚b‚P`,5,'‚w') FROM `‚s‚T`;
58
SELECT `‚b‚P`, RPAD(`‚b‚P`,5,'–\' ) FROM `‚s‚U`;
59
60
#HEAP
61
SELECT `‚b‚P`, RPAD(`‚b‚P`,5,'¡') FROM `‚s‚V`;
62
SELECT `‚b‚P`, RPAD(`‚b‚P`,5,'‚w') FROM `‚s‚W`;
63
SELECT `‚b‚P`, RPAD(`‚b‚P`,5,'–\' ) FROM `‚s‚X`;
64
65
#BDB
66
SELECT `‚b‚P`, RPAD(`‚b‚P`,5,'¡') FROM `‚s‚P‚O`;
67
SELECT `‚b‚P`, RPAD(`‚b‚P`,5,'‚w') FROM `‚s‚P‚P`;
68
SELECT `‚b‚P`, RPAD(`‚b‚P`,5,'–\' ) FROM `‚s‚P‚Q`;
69
70
DROP TABLE `‚s‚P`;
71
DROP TABLE `‚s‚Q`;
72
DROP TABLE `‚s‚R`;
73
DROP TABLE `‚s‚S`;
74
DROP TABLE `‚s‚T`;
75
DROP TABLE `‚s‚U`;
76
DROP TABLE `‚s‚V`;
77
DROP TABLE `‚s‚W`;
78
DROP TABLE `‚s‚X`;
79
DROP TABLE `‚s‚P‚O`;
80
DROP TABLE `‚s‚P‚P`;
81
DROP TABLE `‚s‚P‚Q`;