MySQL Forums
Forum List  »  MySQL Workbench

Re: Foreign Keys in *.SQL File
Posted by: gavin Greenwalt
Date: February 11, 2008 10:20PM

I went through the SQL Command and found the source of the problem. It seems to have been a small bug.

One of the foreign keys was displayed correctly in the workbench. But in the interpretor it didn't get written. I deleted the foreign key and recreated it exactly as before and it worked perfectly.

I can't reproduce but it involved:
Adding Foreign Key.
Renaming Table
Exporting SQL File.

The syntax was something like FOREIGN KEY ('') REFERENCES ''.('') even though the workbench version had entries.

Oh one bug I *can* reproduce:
If I zoom out past the pages in either the OpenGL or software version the viewport goes crazy and is unusable until you zoom in to 100% or closer.

Edited 2 time(s). Last edit at 02/11/2008 10:24PM by gavin Greenwalt.

Options: ReplyQuote

Written By
February 11, 2008 08:38PM
Re: Foreign Keys in *.SQL File
February 11, 2008 10:20PM
February 12, 2008 04:20AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.