~drizzle-trunk/drizzle/development

1 by brian
clean slate
1
--source include/have_ujis.inc
2
3
--disable_warnings
4
drop table if exists `£Ô£±`;
5
drop table if exists `£Ô£²`;
6
drop table if exists `£Ô£³`;
7
drop table if exists `£Ô£Ž`;
8
drop table if exists `£Ô£µ`;
9
drop table if exists `£Ô£¶`;
10
drop table if exists `£Ô£·`;
11
drop table if exists `£Ô£ž`;
12
drop table if exists `£Ô£¹`;
13
drop table if exists `£Ô£±£°`;
14
drop table if exists `£Ô£±£±`;
15
drop table if exists `£Ô£±£²`;
16
--enable_warnings
17
18
#
19
# Test REPLACE() function with Japanese characters in ujis encoding
20
#
21
22
SET NAMES ujis;
23
SET character_set_database = ujis;
24
25
CREATE TABLE `£Ô£±` (`£Ã£±` char(5)) DEFAULT CHARSET = ujis engine = innodb;
26
CREATE TABLE `£Ô£²` (`£Ã£±` char(5)) DEFAULT CHARSET = ujis engine = innodb;
27
CREATE TABLE `£Ô£³` (`£Ã£±` char(5)) DEFAULT CHARSET = ujis engine = innodb;
28
CREATE TABLE `£Ô£Ž` (`£Ã£±` char(5)) DEFAULT CHARSET = ujis engine = myisam;
29
CREATE TABLE `£Ô£µ` (`£Ã£±` char(5)) DEFAULT CHARSET = ujis engine = myisam;
30
CREATE TABLE `£Ô£¶` (`£Ã£±` char(5)) DEFAULT CHARSET = ujis engine = myisam;
31
CREATE TABLE `£Ô£·` (`£Ã£±` char(5)) DEFAULT CHARSET = ujis engine = heap;
32
CREATE TABLE `£Ô£ž` (`£Ã£±` char(5)) DEFAULT CHARSET = ujis engine = heap;
33
CREATE TABLE `£Ô£¹` (`£Ã£±` char(5)) DEFAULT CHARSET = ujis engine = heap;
34
CREATE TABLE `£Ô£±£°` (`£Ã£±` char(5)) DEFAULT CHARSET = ujis engine = bdb;
35
CREATE TABLE `£Ô£±£±` (`£Ã£±` char(5)) DEFAULT CHARSET = ujis engine = bdb;
36
CREATE TABLE `£Ô£±£²` (`£Ã£±` char(5)) DEFAULT CHARSET = ujis engine = bdb;
37
38
INSERT INTO `£Ô£±` VALUES ('Ž±Ž²Ž³ŽŽŽµ');
39
INSERT INTO `£Ô£²` VALUES ('€¢€€€Š€š€ª');
40
INSERT INTO `£Ô£³` VALUES ('í܏íݏíޏíߏíà');
41
INSERT INTO `£Ô£Ž` VALUES ('Ž±Ž²Ž³ŽŽŽµ');
42
INSERT INTO `£Ô£µ` VALUES ('€¢€€€Š€š€ª');
43
INSERT INTO `£Ô£¶` VALUES ('í܏íݏíޏíߏíà');
44
INSERT INTO `£Ô£·` VALUES ('Ž±Ž²Ž³ŽŽŽµ');
45
INSERT INTO `£Ô£ž` VALUES ('€¢€€€Š€š€ª');
46
INSERT INTO `£Ô£¹` VALUES ('í܏íݏíޏíߏíà');
47
INSERT INTO `£Ô£±£°` VALUES ('Ž±Ž²Ž³ŽŽŽµ');
48
INSERT INTO `£Ô£±£±` VALUES ('€¢€€€Š€š€ª');
49
INSERT INTO `£Ô£±£²` VALUES ('í܏íݏíޏíߏíà');
50
51
#InnoDB
52
SELECT REPLACE(`£Ã£±`,'Ž±','Ž±Ž±') FROM `£Ô£±`;
53
SELECT REPLACE(`£Ã£±`,'Ž²','Ž²Ž²') FROM `£Ô£±`;
54
SELECT REPLACE(`£Ã£±`,'Ž³','Ž³Ž³') FROM `£Ô£±`;
55
SELECT REPLACE(`£Ã£±`,'ŽŽ','ŽŽŽŽ') FROM `£Ô£±`;
56
SELECT REPLACE(`£Ã£±`,'Žµ','ŽµŽµ') FROM `£Ô£±`;
57
SELECT REPLACE(`£Ã£±`,'€¢','€¢€¢') FROM `£Ô£²`;
58
SELECT REPLACE(`£Ã£±`,'€€','€€€€') FROM `£Ô£²`;
59
SELECT REPLACE(`£Ã£±`,'€Š','€Š€Š') FROM `£Ô£²`;
60
SELECT REPLACE(`£Ã£±`,'€š','€š€š') FROM `£Ô£²`;
61
SELECT REPLACE(`£Ã£±`,'€ª','€ª€ª') FROM `£Ô£²`;
62
SELECT REPLACE(`£Ã£±`,'íÜ','í܏íÜ') FROM `£Ô£³`;
63
SELECT REPLACE(`£Ã£±`,'íÝ','íݏíÝ') FROM `£Ô£³`;
64
SELECT REPLACE(`£Ã£±`,'íÞ','íޏíÞ') FROM `£Ô£³`;
65
SELECT REPLACE(`£Ã£±`,'íß','íߏíß') FROM `£Ô£³`;
66
SELECT REPLACE(`£Ã£±`,'íà','íàíà') FROM `£Ô£³`;
67
68
#MyISAM
69
SELECT REPLACE(`£Ã£±`,'Ž±','Ž±Ž±') FROM `£Ô£Ž`;
70
SELECT REPLACE(`£Ã£±`,'Ž²','Ž²Ž²') FROM `£Ô£Ž`;
71
SELECT REPLACE(`£Ã£±`,'Ž³','Ž³Ž³') FROM `£Ô£Ž`;
72
SELECT REPLACE(`£Ã£±`,'ŽŽ','ŽŽŽŽ') FROM `£Ô£Ž`;
73
SELECT REPLACE(`£Ã£±`,'Žµ','ŽµŽµ') FROM `£Ô£Ž`;
74
SELECT REPLACE(`£Ã£±`,'€¢','€¢€¢') FROM `£Ô£µ`;
75
SELECT REPLACE(`£Ã£±`,'€€','€€€€') FROM `£Ô£µ`;
76
SELECT REPLACE(`£Ã£±`,'€Š','€Š€Š') FROM `£Ô£µ`;
77
SELECT REPLACE(`£Ã£±`,'€š','€š€š') FROM `£Ô£µ`;
78
SELECT REPLACE(`£Ã£±`,'€ª','€ª€ª') FROM `£Ô£µ`;
79
SELECT REPLACE(`£Ã£±`,'íÜ','í܏íÜ') FROM `£Ô£¶`;
80
SELECT REPLACE(`£Ã£±`,'íÝ','íݏíÝ') FROM `£Ô£¶`;
81
SELECT REPLACE(`£Ã£±`,'íÞ','íޏíÞ') FROM `£Ô£¶`;
82
SELECT REPLACE(`£Ã£±`,'íß','íߏíß') FROM `£Ô£¶`;
83
SELECT REPLACE(`£Ã£±`,'íà','íàíà') FROM `£Ô£¶`;
84
85
#HEAP
86
SELECT REPLACE(`£Ã£±`,'Ž±','Ž±Ž±') FROM `£Ô£·`;
87
SELECT REPLACE(`£Ã£±`,'Ž²','Ž²Ž²') FROM `£Ô£·`;
88
SELECT REPLACE(`£Ã£±`,'Ž³','Ž³Ž³') FROM `£Ô£·`;
89
SELECT REPLACE(`£Ã£±`,'ŽŽ','ŽŽŽŽ') FROM `£Ô£·`;
90
SELECT REPLACE(`£Ã£±`,'Žµ','ŽµŽµ') FROM `£Ô£·`;
91
SELECT REPLACE(`£Ã£±`,'€¢','€¢€¢') FROM `£Ô£ž`;
92
SELECT REPLACE(`£Ã£±`,'€€','€€€€') FROM `£Ô£ž`;
93
SELECT REPLACE(`£Ã£±`,'€Š','€Š€Š') FROM `£Ô£ž`;
94
SELECT REPLACE(`£Ã£±`,'€š','€š€š') FROM `£Ô£ž`;
95
SELECT REPLACE(`£Ã£±`,'€ª','€ª€ª') FROM `£Ô£ž`;
96
SELECT REPLACE(`£Ã£±`,'íÜ','í܏íÜ') FROM `£Ô£¹`;
97
SELECT REPLACE(`£Ã£±`,'íÝ','íݏíÝ') FROM `£Ô£¹`;
98
SELECT REPLACE(`£Ã£±`,'íÞ','íޏíÞ') FROM `£Ô£¹`;
99
SELECT REPLACE(`£Ã£±`,'íß','íߏíß') FROM `£Ô£¹`;
100
SELECT REPLACE(`£Ã£±`,'íà','íàíà') FROM `£Ô£¹`;
101
102
#BDB
103
SELECT REPLACE(`£Ã£±`,'Ž±','Ž±Ž±') FROM `£Ô£±£°`;
104
SELECT REPLACE(`£Ã£±`,'Ž²','Ž²Ž²') FROM `£Ô£±£°`;
105
SELECT REPLACE(`£Ã£±`,'Ž³','Ž³Ž³') FROM `£Ô£±£°`;
106
SELECT REPLACE(`£Ã£±`,'ŽŽ','ŽŽŽŽ') FROM `£Ô£±£°`;
107
SELECT REPLACE(`£Ã£±`,'Žµ','ŽµŽµ') FROM `£Ô£±£°`;
108
SELECT REPLACE(`£Ã£±`,'€¢','€¢€¢') FROM `£Ô£±£±`;
109
SELECT REPLACE(`£Ã£±`,'€€','€€€€') FROM `£Ô£±£±`;
110
SELECT REPLACE(`£Ã£±`,'€Š','€Š€Š') FROM `£Ô£±£±`;
111
SELECT REPLACE(`£Ã£±`,'€š','€š€š') FROM `£Ô£±£±`;
112
SELECT REPLACE(`£Ã£±`,'€ª','€ª€ª') FROM `£Ô£±£±`;
113
SELECT REPLACE(`£Ã£±`,'íÜ','í܏íÜ') FROM `£Ô£±£²`;
114
SELECT REPLACE(`£Ã£±`,'íÝ','íݏíÝ') FROM `£Ô£±£²`;
115
SELECT REPLACE(`£Ã£±`,'íÞ','íޏíÞ') FROM `£Ô£±£²`;
116
SELECT REPLACE(`£Ã£±`,'íß','íߏíß') FROM `£Ô£±£²`;
117
SELECT REPLACE(`£Ã£±`,'íà','íàíà') FROM `£Ô£±£²`;
118
119
DROP TABLE `£Ô£±`;
120
DROP TABLE `£Ô£²`;
121
DROP TABLE `£Ô£³`;
122
DROP TABLE `£Ô£Ž`;
123
DROP TABLE `£Ô£µ`;
124
DROP TABLE `£Ô£¶`;
125
DROP TABLE `£Ô£·`;
126
DROP TABLE `£Ô£ž`;
127
DROP TABLE `£Ô£¹`;
128
DROP TABLE `£Ô£±£°`;
129
DROP TABLE `£Ô£±£±`;
130
DROP TABLE `£Ô£±£²`;