Bug #39211 Forward Engineer Sql Script write invalid statements when using two schematas
Submitted: 3 Sep 2008 11:48 Modified: 14 Oct 2008 13:39
Reporter: Lars Monecke Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.0.23 SE OS:Windows (XP 64)
Assigned to: CPU Architecture:Any

[3 Sep 2008 11:48] Lars Monecke 
Description:
When generating a forward sql script from a 2 schemata design. Problems are missing table names for insert statements and triggers for not yet existing tables.

How to repeat:
Try to add attach sql forward skript to a mysql db
[3 Sep 2008 11:48] Lars Monecke 
sql forward script generated form test.mwb

Attachment: test.sql (application/octet-stream, text), 2.23 KiB.
[3 Sep 2008 11:48] Lars Monecke 
the mysql workbench file

Attachment: test.mwb (application/octet-stream, text), 5.56 KiB.
[3 Sep 2008 11:51] Lars Monecke 
again now the correct workbench file

Attachment: test.mwb (application/octet-stream, text), 5.51 KiB.
[3 Sep 2008 12:44] MySQL Verification Team 
Thank you for the bug report. Could you please try release 5.0.24. Thanks in advance.
[3 Sep 2008 13:03] Lars Monecke 
Sorry, because of http://bugs.mysql.com/bug.php?id=38825, we are not using 5.0.24.
[3 Sep 2008 14:23] MySQL Verification Team 
Thank you for the bug report.
[4 Sep 2008 6:11] Lars Monecke 
updated mwb file v3

Attachment: test.mwb (application/octet-stream, text), 6.38 KiB.
[4 Sep 2008 6:11] Lars Monecke 
sql forward script generated form test.mwb v3

Attachment: test.sql (application/octet-stream, text), 2.56 KiB.
[4 Sep 2008 6:16] Lars Monecke 
Sorry, for the updated files, but i want to ensure, that you can see the problem.

In the last test.sql (v3) the script
1. create schema mydb1 and do `use mydb1`
2. create table mydb2.foobar2
3. create trigger after insert on mydb2.foobar2 (which use mydb2.foobar3!)
4a. insert data into foobar2. Which fails because foobar is in mydb2. This could be fix by the schema prefix used before
4b. If you correct 4a., the the trigger created in 3. will fail, because mydb2.foobar3 not created yet.

Thanks, Lars
[8 Oct 2008 16:39] Johannes Taxacher 
this is fixed. fix will be included in 5.0.26
[14 Oct 2008 13:39] Tony Bedford 
An entry was added to the 5.0.26 changelog:

The script generated by the Export, Forward Engineer SQL CREATE Script menu item contained invalid statements when using two schemata.