tags 299099 - forwarded thanks hi roland,
On Tue, Mar 15, 2005 at 07:50:40PM +0100, Roland Ulbricht wrote:
> I don't believe that mysql-bug 5574 is associated with my situation. It
> reports a bug where a table with foreign keys is created, then altered
> to MyIsam, and then the re-creation does not work anymore.
ah, sorry. was looking for bugs related to foreign keys that produced
the error code you mentioned (i am able to reproduce it too), and
thought that might be related.
> My problem however is that the "ALTER TABLE ADD CONSTRAINT"-Syntax seems
> to not work sometimes. This might either be a problem with the
> mysql-server which does not execute it correctly or with mysql-admin
> which might be producing incorrect queries.
could you post the output of "show innodb status" immediately after
getting this error?
> "ALTER TABLE ADD FOREIGN KEY" does work however. I am no sql-expert, so
> I am not sure if I need the constraint if I have successfully set a
> foreign key...
i can't say i'm too familiar with this either. the last time i read
a book on mysql they didn't even support foreign keys outside of
accepting the syntax...
it might be worth posting this bug to some large mysql user group to
see if someone with a bit more experience could provide insight.
sean
--
signature.asc
Description: Digital signature
