RE: SET FOREIGN_KEY_CHECKS=0 being ignored

2005-07-11 Thread John McCaskey
ts the SET FOREIGN_KEY_CONSTRAINTS as succeeding right before the replace though. John A. McCaskey -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Monday, July 11, 2005 11:42 AM To: John McCaskey Cc: mysql@lists.mysql.com Subject: Re: SET FOREIGN_KEY_CHECKS=0 being ignored Some addit

Re: SET FOREIGN_KEY_CHECKS=0 being ignored

2005-07-11 Thread Michael Stassen
this is some sort of bug with the user being corrupted somehow and permissions checks causing the SET FOREIGN_KEY_CHECKS=0 to not work but still return success? Seems like a mysql bug then right? John A. McCaskey -Original Message- From: John McCaskey Sent: Monday, July 11, 2005 9:51 AM To: John M

RE: SET FOREIGN_KEY_CHECKS=0 being ignored

2005-07-11 Thread John McCaskey
EY_CHECKS=0 to not work but still return success? Seems like a mysql bug then right? John A. McCaskey -Original Message- From: John McCaskey Sent: Monday, July 11, 2005 9:51 AM To: John McCaskey; mysql@lists.mysql.com Subject: RE: SET FOREIGN_KEY_CHECKS=0 being ignored Oh, I should

RE: SET FOREIGN_KEY_CHECKS=0 being ignored

2005-07-11 Thread John McCaskey
Oh, I should also mention we have binary logging on and I verified by looking at the binary log that the commands are being excuted and logged with an error code of 0. So the obvious thought of the codes broken and not running them is unfortunately not the problem. It seems to be some sort of leg