diff options
author | unknown <lars@mysql.com> | 2005-02-22 22:40:34 +0100 |
---|---|---|
committer | unknown <lars@mysql.com> | 2005-02-22 22:40:34 +0100 |
commit | 2c1e12c2c225500e064de05cf6b772235b93799a (patch) | |
tree | 0baf9c8bea10509b4a2502b0730211c623c1365d /mysql-test/t/rpl_charset.test | |
parent | bf46e486bb35c2edb0284b49c64cfe1609016a6b (diff) | |
parent | 100f79260259603d1a9f1cb9e1c052217f828dc2 (diff) | |
download | mariadb-git-2c1e12c2c225500e064de05cf6b772235b93799a.tar.gz |
Merge 4.1->5.0
client/mysqldump.c:
Auto merged
mysql-test/r/mysqldump.result:
Auto merged
mysql-test/r/rpl_charset.result:
Auto merged
sql/mysql_priv.h:
Auto merged
sql/mysqld.cc:
Auto merged
sql/set_var.cc:
Auto merged
mysql-test/t/rpl_charset.test:
Manual merge
sql/log_event.cc:
Manual merge
Diffstat (limited to 'mysql-test/t/rpl_charset.test')
-rw-r--r-- | mysql-test/t/rpl_charset.test | 20 |
1 files changed, 16 insertions, 4 deletions
diff --git a/mysql-test/t/rpl_charset.test b/mysql-test/t/rpl_charset.test index c61df09fdcc..92582f9d748 100644 --- a/mysql-test/t/rpl_charset.test +++ b/mysql-test/t/rpl_charset.test @@ -63,10 +63,10 @@ connection master; 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")); +insert into t1 (b) values(LEAST("Müller","Muffler")); set collation_connection=latin1_german2_ci; insert into t1 (b) values(@@collation_connection); -insert into t1 (b) values(LEAST("Mller","Muffler")); +insert into t1 (b) values(LEAST("Müller","Muffler")); --disable_query_log select "--- --master--" as ""; --enable_query_log @@ -90,7 +90,7 @@ select * from mysqltest2.t1 order by a; # which provokes error messages (like 'Illegal mix of collation') when # we replay the master's INSERT/etc statements. connection master; -set @a= _cp850 'Mller' collate cp850_general_ci; +set @a= _cp850 'Müller' collate cp850_general_ci; truncate table t1; insert into t1 (b) values(collation(@a)); --disable_query_log @@ -145,7 +145,7 @@ 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 (', ',', '); +INSERT INTO t1 (c1, c2) VALUES ('îÕ, ÚÁ ÒÙÂÁÌËÕ','îÕ, ÚÁ ÒÙÂÁÌËÕ'); select hex(c1), hex(c2) from t1; sync_slave_with_master; select hex(c1), hex(c2) from t1; @@ -157,3 +157,15 @@ connection master; drop table t1; sync_slave_with_master; +# +# BUG#6676: Derivation of variables must be correct on slave +# +connection master; +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; +sync_slave_with_master; |