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
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
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
legitimate mysql setup error on our part or a bug in mysql.
John A. McCaskey
-Original Message-
From: John McCaskey [mailto:[EMAIL PROTECTED]
Sent: Monday, July 11, 2005 9:46 AM
To: mysql@lists.mysql.com
Subject: SET FOREIGN_KEY_CHECKS=0 being ignored
Hey,
I have an application using the
Hey,
I have an application using the C API that is doing a REPLACE command
into an innodb table that has other tables with cascading deletes
relying on it's entries. Rather than use an UPDATE/Check
affected/Insert/Check success/repeat method we have wrapped the REPLACE
query in a SET FOREIGN_KEY
