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(s) on this?
-Original Message-
From
, 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, IORG_UID
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:
CREATE OR REPLACE 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, IORG_UID
FROM REF_PREFERENCE
;
The master happily created the view. The slave however dies with: