MySQL Bugs: #17862: Replication (not always reproducable) breaks when view column != select column

Bug #17862	Replication (not always reproducable) breaks when view column != select column
Submitted:	2 Mar 2006 14:59	Modified:	2 Apr 2006 15:13
Reporter:	Sebastian Nohn	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.0.18-standard	OS:	Linux (Linux)
Assigned to:		CPU Architecture:	Any

Description:
If view column names and real column names do not match, view column names sometimes do not get replicated correctly.

If a select on the view is involved into insert/update queries, replication breaks in that case, the view definition is not replicated correctly.

How to repeat:
-----------------------------------------------------------
create or replace view my_view(CUSTOMER_DATE_ENTRY) as select

DATE(c.DATE_ENTRY)

from customer c;
-----------------------------------------------------------

*Sometimes* does not get replicated correct while

-----------------------------------------------------------
create or replace view my_view(CUSTOMER_DATE_ENTRY) as select

DATE(c.DATE_ENTRY) AS CUSTOMER_DATE_ENTRY

from customer c;
-----------------------------------------------------------

always gets replicated correct.

Thank you for a problem report. Can you, please, send a table definition and a binlog with this CREATE VIEW statements (being replicated and NOT replicated)? Do you have anything unusual in the error logs of both master and slave?

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".