rpl_charset.result 10 KB
Newer Older
1 2 3 4 5 6
stop slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
reset master;
reset slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
start slave;
serg@serg.mylan's avatar
serg@serg.mylan committed
7
set timestamp=1000000000;
8 9 10
drop database if exists mysqltest2;
drop database if exists mysqltest3;
create database mysqltest2 character set latin2;
11
set @@character_set_server=latin5;
12
create database mysqltest3;
13 14

--- --master--
15
show create database mysqltest2;
16
Database	Create Database
17 18
mysqltest2	CREATE DATABASE `mysqltest2` /*!40100 DEFAULT CHARACTER SET latin2 */
show create database mysqltest3;
19
Database	Create Database
20
mysqltest3	CREATE DATABASE `mysqltest3` /*!40100 DEFAULT CHARACTER SET latin5 */
21 22

--- --slave--
23
show create database mysqltest2;
24
Database	Create Database
25 26
mysqltest2	CREATE DATABASE `mysqltest2` /*!40100 DEFAULT CHARACTER SET latin2 */
show create database mysqltest3;
27
Database	Create Database
28
mysqltest3	CREATE DATABASE `mysqltest3` /*!40100 DEFAULT CHARACTER SET latin5 */
29
set @@collation_server=armscii8_bin;
30 31
drop database mysqltest3;
create database mysqltest3;
32 33

--- --master--
34
show create database mysqltest3;
35
Database	Create Database
36
mysqltest3	CREATE DATABASE `mysqltest3` /*!40100 DEFAULT CHARACTER SET armscii8 COLLATE armscii8_bin */
37 38

--- --slave--
39
show create database mysqltest3;
40
Database	Create Database
41 42
mysqltest3	CREATE DATABASE `mysqltest3` /*!40100 DEFAULT CHARACTER SET armscii8 COLLATE armscii8_bin */
use mysqltest2;
43 44 45 46 47 48 49 50 51 52 53 54
create table t1 (a int auto_increment primary key, b varchar(100));
set character_set_client=cp850, collation_connection=latin2_croatian_ci;
insert into t1 (b) values(@@character_set_server);
insert into t1 (b) values(@@collation_server);
insert into t1 (b) values(@@character_set_client);
insert into t1 (b) values(@@character_set_connection);
insert into t1 (b) values(@@collation_connection);

--- --master--
select * from t1 order by a;
a	b
1	armscii8
55
2	armscii8_bin
56 57 58 59 60
3	cp850
4	latin2
5	latin2_croatian_ci

--- --slave--
61
select * from mysqltest2.t1 order by a;
62 63
a	b
1	armscii8
64
2	armscii8_bin
65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84
3	cp850
4	latin2
5	latin2_croatian_ci
set character_set_client=latin1, collation_connection=latin1_german1_ci;
truncate table t1;
insert into t1 (b) values(@@collation_connection);
insert into t1 (b) values(LEAST("Mller","Muffler"));
set collation_connection=latin1_german2_ci;
insert into t1 (b) values(@@collation_connection);
insert into t1 (b) values(LEAST("Mller","Muffler"));

--- --master--
select * from t1 order by a;
a	b
1	latin1_german1_ci
2	Muffler
3	latin1_german2_ci
4	Mller

--- --slave--
85
select * from mysqltest2.t1 order by a;
86 87 88 89 90 91 92 93 94 95 96 97 98 99 100
a	b
1	latin1_german1_ci
2	Muffler
3	latin1_german2_ci
4	Mller
set @a= _cp850 'Mller' collate cp850_general_ci;
truncate table t1;
insert into t1 (b) values(collation(@a));

--- --master--
select * from t1 order by a;
a	b
1	cp850_general_ci

--- --slave--
101
select * from mysqltest2.t1 order by a;
102 103
a	b
1	cp850_general_ci
104 105
drop database mysqltest2;
drop database mysqltest3;
106
show binlog events from 98;
107
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
monty@mysql.com's avatar
monty@mysql.com committed
108 109 110 111 112 113
master-bin.000001	#	Query	1	#	drop database if exists mysqltest2
master-bin.000001	#	Query	1	#	drop database if exists mysqltest3
master-bin.000001	#	Query	1	#	create database mysqltest2 character set latin2
master-bin.000001	#	Query	1	#	create database mysqltest3
master-bin.000001	#	Query	1	#	drop database mysqltest3
master-bin.000001	#	Query	1	#	create database mysqltest3
114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137
master-bin.000001	#	Query	1	#	use `mysqltest2`; create table t1 (a int auto_increment primary key, b varchar(100))
master-bin.000001	#	Intvar	1	#	INSERT_ID=1
master-bin.000001	#	Query	1	#	use `mysqltest2`; insert into t1 (b) values(@@character_set_server)
master-bin.000001	#	Intvar	1	#	INSERT_ID=2
master-bin.000001	#	Query	1	#	use `mysqltest2`; insert into t1 (b) values(@@collation_server)
master-bin.000001	#	Intvar	1	#	INSERT_ID=3
master-bin.000001	#	Query	1	#	use `mysqltest2`; insert into t1 (b) values(@@character_set_client)
master-bin.000001	#	Intvar	1	#	INSERT_ID=4
master-bin.000001	#	Query	1	#	use `mysqltest2`; insert into t1 (b) values(@@character_set_connection)
master-bin.000001	#	Intvar	1	#	INSERT_ID=5
master-bin.000001	#	Query	1	#	use `mysqltest2`; insert into t1 (b) values(@@collation_connection)
master-bin.000001	#	Query	1	#	use `mysqltest2`; truncate table t1
master-bin.000001	#	Intvar	1	#	INSERT_ID=1
master-bin.000001	#	Query	1	#	use `mysqltest2`; insert into t1 (b) values(@@collation_connection)
master-bin.000001	#	Intvar	1	#	INSERT_ID=2
master-bin.000001	#	Query	1	#	use `mysqltest2`; insert into t1 (b) values(LEAST("Mller","Muffler"))
master-bin.000001	#	Intvar	1	#	INSERT_ID=3
master-bin.000001	#	Query	1	#	use `mysqltest2`; insert into t1 (b) values(@@collation_connection)
master-bin.000001	#	Intvar	1	#	INSERT_ID=4
master-bin.000001	#	Query	1	#	use `mysqltest2`; insert into t1 (b) values(LEAST("Mller","Muffler"))
master-bin.000001	#	Query	1	#	use `mysqltest2`; truncate table t1
master-bin.000001	#	Intvar	1	#	INSERT_ID=1
master-bin.000001	#	User var	1	#	@`a`=_cp850 0x4DFC6C6C6572 COLLATE cp850_general_ci
master-bin.000001	#	Query	1	#	use `mysqltest2`; insert into t1 (b) values(collation(@a))
monty@mysql.com's avatar
monty@mysql.com committed
138
master-bin.000001	#	Query	1	#	drop database mysqltest2
139
master-bin.000001	#	Query	1	#	drop database mysqltest3
140
set global character_set_server=latin2;
serg@serg.mylan's avatar
serg@serg.mylan committed
141
set global character_set_server=latin1;
142
set global character_set_server=latin2;
serg@serg.mylan's avatar
serg@serg.mylan committed
143
set global character_set_server=latin1;
144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159
set one_shot @@character_set_server=latin5;
set @@max_join_size=1000;
select @@character_set_server;
@@character_set_server
latin5
select @@character_set_server;
@@character_set_server
latin1
set @@character_set_server=latin5;
select @@character_set_server;
@@character_set_server
latin5
select @@character_set_server;
@@character_set_server
latin5
set one_shot max_join_size=10;
160
ERROR HY000: The 'SET ONE_SHOT' syntax is reserved for purposes internal to the MySQL server
161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176
set character_set_client=9999999;
ERROR 42000: Unknown character set: '9999999'
set collation_server=9999998;
ERROR HY000: Unknown collation: '9999998'
use test;
CREATE TABLE t1 (c1 VARBINARY(255), c2 VARBINARY(255));
SET CHARACTER_SET_CLIENT=koi8r,
CHARACTER_SET_CONNECTION=cp1251, 
CHARACTER_SET_RESULTS=koi8r;
INSERT INTO t1 (c1, c2) VALUES (',  ',',  ');
select hex(c1), hex(c2) from t1;
hex(c1)	hex(c2)
CDF32C20E7E020F0FBE1E0EBEAF3	CDF32C20E7E020F0FBE1E0EBEAF3
select hex(c1), hex(c2) from t1;
hex(c1)	hex(c2)
CDF32C20E7E020F0FBE1E0EBEAF3	CDF32C20E7E020F0FBE1E0EBEAF3
serg@serg.mylan's avatar
serg@serg.mylan committed
177
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
178
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
179 180 181 182 183 184 185
DELIMITER /*!*/;
ROLLBACK/*!*/;
SET TIMESTAMP=1000000000/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1/*!*/;
SET @@session.sql_mode=0/*!*/;
/*!\C latin1 *//*!*/;
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
186 187
drop database if exists mysqltest2
/*!*/;
188
SET TIMESTAMP=1000000000/*!*/;
189 190
drop database if exists mysqltest3
/*!*/;
191
SET TIMESTAMP=1000000000/*!*/;
192 193
create database mysqltest2 character set latin2
/*!*/;
194 195 196
SET TIMESTAMP=1000000000/*!*/;
/*!\C latin1 *//*!*/;
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=30/*!*/;
197 198
create database mysqltest3
/*!*/;
199 200 201
SET TIMESTAMP=1000000000/*!*/;
/*!\C latin1 *//*!*/;
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=64/*!*/;
202 203
drop database mysqltest3
/*!*/;
204
SET TIMESTAMP=1000000000/*!*/;
205 206
create database mysqltest3
/*!*/;
207 208
use mysqltest2/*!*/;
SET TIMESTAMP=1000000000/*!*/;
209 210
create table t1 (a int auto_increment primary key, b varchar(100))
/*!*/;
211 212 213 214
SET INSERT_ID=1/*!*/;
SET TIMESTAMP=1000000000/*!*/;
/*!\C cp850 *//*!*/;
SET @@session.character_set_client=4,@@session.collation_connection=27,@@session.collation_server=64/*!*/;
215 216
insert into t1 (b) values(@@character_set_server)
/*!*/;
217 218
SET INSERT_ID=2/*!*/;
SET TIMESTAMP=1000000000/*!*/;
219 220
insert into t1 (b) values(@@collation_server)
/*!*/;
221 222
SET INSERT_ID=3/*!*/;
SET TIMESTAMP=1000000000/*!*/;
223 224
insert into t1 (b) values(@@character_set_client)
/*!*/;
225 226
SET INSERT_ID=4/*!*/;
SET TIMESTAMP=1000000000/*!*/;
227 228
insert into t1 (b) values(@@character_set_connection)
/*!*/;
229 230
SET INSERT_ID=5/*!*/;
SET TIMESTAMP=1000000000/*!*/;
231 232
insert into t1 (b) values(@@collation_connection)
/*!*/;
233 234 235
SET TIMESTAMP=1000000000/*!*/;
/*!\C latin1 *//*!*/;
SET @@session.character_set_client=8,@@session.collation_connection=5,@@session.collation_server=64/*!*/;
236 237
truncate table t1
/*!*/;
238 239
SET INSERT_ID=1/*!*/;
SET TIMESTAMP=1000000000/*!*/;
240 241
insert into t1 (b) values(@@collation_connection)
/*!*/;
242 243
SET INSERT_ID=2/*!*/;
SET TIMESTAMP=1000000000/*!*/;
244 245
insert into t1 (b) values(LEAST("Mller","Muffler"))
/*!*/;
246 247 248 249
SET INSERT_ID=3/*!*/;
SET TIMESTAMP=1000000000/*!*/;
/*!\C latin1 *//*!*/;
SET @@session.character_set_client=8,@@session.collation_connection=31,@@session.collation_server=64/*!*/;
250 251
insert into t1 (b) values(@@collation_connection)
/*!*/;
252 253
SET INSERT_ID=4/*!*/;
SET TIMESTAMP=1000000000/*!*/;
254 255
insert into t1 (b) values(LEAST("Mller","Muffler"))
/*!*/;
256
SET TIMESTAMP=1000000000/*!*/;
257 258
truncate table t1
/*!*/;
259 260 261
SET INSERT_ID=1/*!*/;
SET @`a`:=_cp850 0x4DFC6C6C6572 COLLATE `cp850_general_ci`/*!*/;
SET TIMESTAMP=1000000000/*!*/;
262 263
insert into t1 (b) values(collation(@a))
/*!*/;
264
SET TIMESTAMP=1000000000/*!*/;
265 266
drop database mysqltest2
/*!*/;
267
SET TIMESTAMP=1000000000/*!*/;
268 269
drop database mysqltest3
/*!*/;
270 271 272 273
use test/*!*/;
SET TIMESTAMP=1000000000/*!*/;
/*!\C latin1 *//*!*/;
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=30/*!*/;
274 275
CREATE TABLE t1 (c1 VARBINARY(255), c2 VARBINARY(255))
/*!*/;
276 277 278
SET TIMESTAMP=1000000000/*!*/;
/*!\C koi8r *//*!*/;
SET @@session.character_set_client=7,@@session.collation_connection=51,@@session.collation_server=30/*!*/;
279 280
INSERT INTO t1 (c1, c2) VALUES (',  ',',  ')
/*!*/;
281
DELIMITER ;
282
# End of log file
283
ROLLBACK /* added by mysqlbinlog */;
284
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
285
drop table t1;
286 287 288 289 290 291 292
create table `t1` (
`pk` varchar(10) not null default '', 
primary key (`pk`)
) engine=myisam default charset=latin1;
set @p=_latin1 'test';
update t1 set pk='test' where pk=@p;
drop table t1;