Index: ndb-work/mysql-test/r/rpl_ndb_ctype_ucs2_def.result =================================================================== --- /dev/null 1970-01-01 00:00:00.000000000 +0000 +++ ndb-work/mysql-test/r/rpl_ndb_ctype_ucs2_def.result 2007-06-07 18:26:44.547837750 +1000 @@ -0,0 +1,9 @@ +show variables like 'collation_server'; +Variable_name Value +collation_server ucs2_unicode_ci +show variables like "%character_set_ser%"; +Variable_name Value +character_set_server ucs2 +DROP TABLE IF EXISTS t1; +create table t1 (a int); +drop table t1; Index: ndb-work/mysql-test/t/rpl_ndb_ctype_ucs2_def.test =================================================================== --- /dev/null 1970-01-01 00:00:00.000000000 +0000 +++ ndb-work/mysql-test/t/rpl_ndb_ctype_ucs2_def.test 2007-06-07 19:07:23.196243750 +1000 @@ -0,0 +1,42 @@ +--source include/have_ucs2.inc +--source include/have_ndb.inc +--source include/master-slave.inc + +# +# MySQL Bug#15276: MySQL ignores collation-server +# +show variables like 'collation_server'; + +# +# Check that NDB replication doesn't explode with default charset +# being multibyte. +# +# Theorised that this could be a problem when dealing with: +# Bug #27404 util thd mysql_parse sig11 when mysqld default multibyte charset +# +# Sort of related to: +# Bug#18004 Connecting crashes server when default charset is UCS2 +# +# +show variables like "%character_set_ser%"; +--disable_warnings +DROP TABLE IF EXISTS t1; +--enable_warnings +create table t1 (a int) ENGINE=NDB; +drop table t1; + +--connection master +CREATE TABLE `t1` ( `nid` int(11) NOT NULL default '0', + `nom` char(4) default NULL, + `prenom` char(4) default NULL, + PRIMARY KEY (`nid`)) + ENGINE=ndbcluster; + +INSERT INTO t1 VALUES(1,"XYZ1","ABC1"); +select * from t1 order by nid; + +--sync_slave_with_master +# connect to slave and ensure data it there. +--connection slave +select * from t1 order by nid; + Index: ndb-work/mysql-test/t/rpl_ndb_ctype_ucs2_def-master.opt =================================================================== --- /dev/null 1970-01-01 00:00:00.000000000 +0000 +++ ndb-work/mysql-test/t/rpl_ndb_ctype_ucs2_def-master.opt 2007-06-07 18:26:44.547837750 +1000 @@ -0,0 +1 @@ +--default-collation=ucs2_unicode_ci --default-character-set=ucs2,latin1