1include/master-slave.inc 2[connection master] 3set timestamp=1000000000; 4create database mysqltest2 character set latin2; 5set @@character_set_server=latin5; 6create database mysqltest3; 7show create database mysqltest2; 8Database Create Database 9mysqltest2 CREATE DATABASE `mysqltest2` /*!40100 DEFAULT CHARACTER SET latin2 */ 10show create database mysqltest3; 11Database Create Database 12mysqltest3 CREATE DATABASE `mysqltest3` /*!40100 DEFAULT CHARACTER SET latin5 */ 13connection slave; 14show create database mysqltest2; 15Database Create Database 16mysqltest2 CREATE DATABASE `mysqltest2` /*!40100 DEFAULT CHARACTER SET latin2 */ 17show create database mysqltest3; 18Database Create Database 19mysqltest3 CREATE DATABASE `mysqltest3` /*!40100 DEFAULT CHARACTER SET latin5 */ 20connection master; 21set @@collation_server=armscii8_bin; 22drop database mysqltest3; 23create database mysqltest3; 24show create database mysqltest3; 25Database Create Database 26mysqltest3 CREATE DATABASE `mysqltest3` /*!40100 DEFAULT CHARACTER SET armscii8 COLLATE armscii8_bin */ 27connection slave; 28show create database mysqltest3; 29Database Create Database 30mysqltest3 CREATE DATABASE `mysqltest3` /*!40100 DEFAULT CHARACTER SET armscii8 COLLATE armscii8_bin */ 31connection master; 32use mysqltest2; 33create table t1 (a int auto_increment primary key, b varchar(100)); 34set character_set_client=cp850, collation_connection=latin2_croatian_ci; 35insert into t1 (b) values(@@character_set_server); 36insert into t1 (b) values(@@collation_server); 37insert into t1 (b) values(@@character_set_client); 38insert into t1 (b) values(@@character_set_connection); 39insert into t1 (b) values(@@collation_connection); 40select * from t1 order by a; 41a b 421 armscii8 432 armscii8_bin 443 cp850 454 latin2 465 latin2_croatian_ci 47connection slave; 48select * from mysqltest2.t1 order by a; 49a b 501 armscii8 512 armscii8_bin 523 cp850 534 latin2 545 latin2_croatian_ci 55connection master; 56set character_set_client=latin1, collation_connection=latin1_german1_ci; 57truncate table t1; 58insert into t1 (b) values(@@collation_connection); 59insert into t1 (b) values(LEAST("M�ller","Muffler")); 60set collation_connection=latin1_german2_ci; 61insert into t1 (b) values(@@collation_connection); 62insert into t1 (b) values(LEAST("M�ller","Muffler")); 63select * from t1 order by a; 64a b 651 latin1_german1_ci 662 Muffler 673 latin1_german2_ci 684 M�ller 69connection slave; 70select * from mysqltest2.t1 order by a; 71a b 721 latin1_german1_ci 732 Muffler 743 latin1_german2_ci 754 M�ller 76connection master; 77set @a= _cp850 'M�ller' collate cp850_general_ci; 78truncate table t1; 79insert into t1 (b) values(collation(@a)); 80select * from t1 order by a; 81a b 821 cp850_general_ci 83connection slave; 84select * from mysqltest2.t1 order by a; 85a b 861 cp850_general_ci 87connection master; 88drop database mysqltest2; 89drop database mysqltest3; 90connection slave; 91set global character_set_server=latin2; 92set global character_set_server=latin1; 93connection master; 94set global character_set_server=latin2; 95set global character_set_server=latin1; 96set character_set_client=9999999; 97ERROR 42000: Unknown character set: '9999999' 98set collation_server=9999998; 99ERROR HY000: Unknown collation: '9999998' 100use test; 101CREATE TABLE t1 (c1 VARBINARY(255), c2 VARBINARY(255)); 102SET CHARACTER_SET_CLIENT=koi8r, 103CHARACTER_SET_CONNECTION=cp1251, 104CHARACTER_SET_RESULTS=koi8r; 105INSERT INTO t1 (c1, c2) VALUES ('��, �� �������','��, �� �������'); 106select hex(c1), hex(c2) from t1; 107hex(c1) hex(c2) 108CDF32C20E7E020F0FBE1E0EBEAF3 CDF32C20E7E020F0FBE1E0EBEAF3 109connection slave; 110select hex(c1), hex(c2) from t1; 111hex(c1) hex(c2) 112CDF32C20E7E020F0FBE1E0EBEAF3 CDF32C20E7E020F0FBE1E0EBEAF3 113connection master; 114drop table t1; 115connection slave; 116connection master; 117create table `t1` ( 118`pk` varchar(10) not null default '', 119primary key (`pk`) 120) engine=myisam default charset=latin1; 121set @p=_latin1 'test'; 122update t1 set pk='test' where pk=@p; 123drop table t1; 124# 125# Start of 10.3 tests 126# 127# 128# MDEV-12685 Oracle-compatible function CHR() 129# 130connection master; 131CREATE DATABASE db1 DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; 132USE db1; 133CREATE TABLE t1 AS SELECT CHR(0x60); 134connection slave; 135SHOW CREATE TABLE db1.t1; 136Table Create Table 137t1 CREATE TABLE `t1` ( 138 `CHR(0x60)` varchar(4) COLLATE latin1_bin DEFAULT NULL 139) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_bin 140connection master; 141USE test; 142DROP DATABASE db1; 143connection slave; 144# 145# End of 10.3 tests 146# 147include/rpl_end.inc 148