Dear list,
Replication (between two 4.1.10 servers, Solaris) fails on the following
query with a 1064 error (parse error), but there are no reserved words
in it, and when I run the query from the command line on the master no
errors occur and the table is created.
(binlog)
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
# at 30963303
#051220 10:51:00 server id 30 log_pos 30963303 Query
thread_id=17311 exec_time=0 error_code=0
use sip;
SET TIMESTAMP=1135072260;
DROP TABLE IF EXISTS `tbl_ou`;
CREATE TABLE `tbl_ou` (
`intId` int(11) NOT NULL auto_increment,
`vchName` varchar(100) NOT NULL default '',
`vchDescription` varchar(255) default NULL,
`intParent` int(11) default NULL,
`intType` int(11) NOT NULL default '0',
`tinStatus` tinyint(3) NOT NULL default '1',
PRIMARY KEY (`intId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Orginisational Units';
#
# Dumping data for table tbl_ou
#
[snip]
Output from SHOW SLAVE STATUS:
[...]
Last_Errno: 1064
Last_Error: Error 'You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near ';
CREATE TABLE `tbl_ou` (
`intId` int(11) NOT NULL auto_increment,
`vchNa' at line 1' on query. Default database: 'sip'. Query: 'DROP
TABLE IF EXISTS `tbl_ou`;
CREATE TABLE `tbl_ou` (
`intId` int(11) NOT NULL auto_increment,
`vchName` varchar(100) NOT NULL default '',
`vchDescription` varchar(255) default NULL,
`intParent` int(11) default NULL,
`intType` int(11) NOT NULL default '0',
`tinStatus` tinyint(3) NOT NULL default '1',
PRIMARY KEY (`intId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Orginisational Units';
Where to look, how to fix? It looks like a bug to me, if so I'll add it
to the buglist.
Kind regards,
Martijn
--
The information contained in this communication and any attachments is
confidential and may be privileged, and is for the sole use of the intended
recipient(s). Any unauthorized review, use, disclosure or distribution is
prohibited. If you are not the intended recipient, please notify the sender
immediately by replying to this message and destroy all copies of this message
and any attachments. ASML is neither liable for the proper and complete
transmission of the information contained in this communication, nor for any
delay in its receipt.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
