Bug #19736 | VIEW: column names not quoted properly when view is replicated | ||
---|---|---|---|
Submitted: | 11 May 2006 18:10 | Modified: | 9 Nov 2006 14:58 |
Reporter: | Timothy Smith | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Replication | Severity: | S2 (Serious) |
Version: | 5.0.22 | OS: | Linux (linux, any) |
Assigned to: | Ramil Kalimullin | CPU Architecture: | Any |
[11 May 2006 18:10]
Timothy Smith
[11 May 2006 18:59]
Timothy Smith
I tested this on MySQL 5.1, and it did not have the problem. The .frm file is still not the same on the master and the slave, but at least the troublesome column name is being quoted: $ diff -u {m,s}/data/rep1/repl_br*.frm --- m/data/rep1/repl_breaker_v.frm Thu May 11 12:55:16 2006 +++ s/data/rep1/repl_breaker_v.frm Thu May 11 12:55:16 2006 @@ -1,6 +1,6 @@ TYPE=VIEW -query=select `t`.`id` AS `id`,`t`.`data` AS `data` from `rep1`.`test` `t` where not(exists(select 1 AS `1` from `rep1`.`test` `t1`)) -md5=daa58b592b8ce1c450340187a5f6f197 +query=select t.id AS id,t.`data` AS `data` from rep1.test t where not(exists(select 1 AS `1` from rep1.test t1)) +md5=505b30b9e46f72e8e79523f6a544d956 updatable=0 algorithm=0 definer_user=tim mysql> show variables like 'version%'; +-------------------------+---------------------------------------------------+ | Variable_name | Value | +-------------------------+---------------------------------------------------+ | version | 5.1.10-beta-debug | | version_comment | Latest delta: 2006/05/05 1.2382 jmiller@mysql.com | | version_compile_machine | i386 | | version_compile_os | unknown-freebsd6.1 | +-------------------------+---------------------------------------------------+
[3 Nov 2006 8:42]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/14788 ChangeSet@1.2348, 2006-11-03 12:42:55+04:00, ramil@mysql.com +2 -0 Fix for bug #19736 VIEW: column names not quoted properly when view is replicated When we write 'query=...' string to a frm file for views on a slave, indentifiers are not properly quoted due to missing OPTION_QUOTE_SHOW_CREATE flag in the thd->options. Fix: properly set thd->options for the slave thread.
[3 Nov 2006 11:26]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/14797 ChangeSet@1.2348, 2006-11-03 15:27:37+04:00, ramil@mysql.com +2 -0 Fix for bug #19736 VIEW: column names not quoted properly when view is replicated When we write 'query=...' string to a frm file for views on a slave, indentifiers are not properly quoted due to missing OPTION_QUOTE_SHOW_CREATE flag in the thd->options. Fix: properly set thd->options for the slave thread.
[9 Nov 2006 14:58]
Paul DuBois
Noted in 5.0.30, 5.1.13 changelogs.