Bug #42237 Character ü (u with diaeresis) not replicated correctly when used in view name
| Submitted: | 21 Jan 2009 11:34 | Modified: | 23 Jan 2009 12:17 |
|---|---|---|---|
| Reporter: | Vemund Østgaard | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server: Replication | Severity: | S3 (Non-critical) |
| Version: | 5.0, 5.1.30, 5.1, 6.0 bzr | OS: | Any |
| Assigned to: | CPU Architecture: | Any |
[21 Jan 2009 11:34]
Vemund Østgaard
[22 Jan 2009 10:28]
Sveta Smirnova
Thank you for the report. Verified as described. Most likely duplicate of bug #32200, but I live it separate, so developers can decide.
[22 Jan 2009 10:35]
Sveta Smirnova
test case
Attachment: rpl_bug42237.test (application/octet-stream, text), 231 bytes.
[22 Jan 2009 21:12]
Sveta Smirnova
Character set settings are same on slave and master. Also please note table name is not corrupted: 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; show variables like '%char%'; Variable_name Value character_set_client latin1 character_set_connection latin1 character_set_database latin1 character_set_filesystem binary character_set_results latin1 character_set_server latin1 character_set_system utf8 character_sets_dir /Users/apple/bzr/mysql-5.1/sql/share/charsets/ set names latin1; create view `###### as select 1; create table `######`(f1 int); set names utf8; show full tables; Tables_in_test Table_type ütest VIEW ütest2 BASE TABLE flush logs; show variables like '%char%'; Variable_name Value character_set_client latin1 character_set_connection latin1 character_set_database latin1 character_set_filesystem binary character_set_results latin1 character_set_server latin1 character_set_system utf8 character_sets_dir /Users/apple/bzr/mysql-5.1/sql/share/charsets/ set names utf8; show full tables; Tables_in_test Table_type ã¼test VIEW ütest2 BASE TABLE
[23 Jan 2009 12:17]
Valeriy Kravchuk
So, looks like this is, indeed, a duplicate of bug #32200.
[23 Jan 2009 12:37]
Vemund Østgaard
Why is this a duplicate of 32200? 32200 Describes the SQL thread stopping, while this report is about inconsistency between master and slave. I don't deny it is the same cause, but the symptoms seem different. The symptoms from 32200 might not reproduce on the latest versions.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.042 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.