2007 6:53:17 PM (GMT+0530) Asia/Calcutta
Subject: Re: MySQL slave error when creating view
Sounds like a bug to me. It's likely fixed in newer versions; a lot of
view/function/sproc replication bugs have been fixed. But if not, you should
report it.
Tim Lucia wrote:
> Nobody has any idea
riday, April 06, 2007 7:11 PM
To: [EMAIL PROTECTED]
Subject: MySQL slave error when creating view
I ran the following DDL on our master today:
CREATE OR REPLACE VIEW REF_TRANSFER_PREFERENCE (
IORG_UID, TDISTRICT_NAME, IORGDISPLAY, IORG ) AS
SELECT
0, TDISTRICT_NAME, IORG_UID, IOR
Nobody has any idea(s) on this?
> -Original Message-
> From: Tim Lucia [mailto:[EMAIL PROTECTED]
> Sent: Friday, April 06, 2007 7:11 PM
> To: [EMAIL PROTECTED]
> Subject: MySQL slave error when creating view
>
>
> I ran the following DDL on our master today:
>
I ran the following DDL on our master today:
CREATE OR REPLACE VIEW REF_TRANSFER_PREFERENCE (
IORG_UID, TDISTRICT_NAME, IORGDISPLAY, IORG ) AS
SELECT
0, TDISTRICT_NAME, IORG_UID, IORG_UID
FROM REF_PREFERENCE
;
The master happily created the view. The slave however dies with:
07
