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 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: > > 070405 10:48:23 [ERROR] Slave: Error 'Duplicate column name 'IORG_UID'' on > query. Default database: 'pildb'. Query: 'CREATE OR REPLACE > ALGORITHM=UNDEFINED [EMAIL PROTECTED] SQL SECURITY DEFINER VIEW > `REF_TRANSFER_PREFERENCE` AS SELECT 0, TDISTRICT_NAME, IORG_UID, IORG_UID > FROM REF_PREFERENCE', Error_code: 1060 > > I can work around it by redefining the view DDL as: > > CREATE OR REPLACE VIEW REF_TRANSFER_PREFERENCE ( > IORG_UID, TDISTRICT_NAME, IORGDISPLAY, IORG ) AS > SELECT > 0 as IORG_UID, TDISTRICT_NAME, IORG_UID as IORGDISPLAY, IORG_UID as > IORG > FROM REF_PREFERENCE > ; > > And the slave is happy. Is this a bug? Anyone care to comment? > > CONFIGURATION: > storage_engine MyISAM > table_type MyISAM > updatable_views_with_limit YES > version 5.0.24-standard-log > version_comment MySQL Community Edition - Standard (GPL) > version_compile_machine x86_64 > version_compile_os unknown-linux-gnu > > Thanks, > Tim > > > > > > -- > MySQL Replication Mailing List > For list archives: http://lists.mysql.com/replication > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
