summaryrefslogtreecommitdiff
path: root/mysql-test/t/rpl_charset.test
diff options
context:
space:
mode:
authorunknown <lars@mysql.com>2005-02-22 22:40:34 +0100
committerunknown <lars@mysql.com>2005-02-22 22:40:34 +0100
commit2c1e12c2c225500e064de05cf6b772235b93799a (patch)
tree0baf9c8bea10509b4a2502b0730211c623c1365d /mysql-test/t/rpl_charset.test
parentbf46e486bb35c2edb0284b49c64cfe1609016a6b (diff)
parent100f79260259603d1a9f1cb9e1c052217f828dc2 (diff)
downloadmariadb-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.test20
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;