| Bug #32883 | Model Options -> Model Default does not allow %column% in the foreign key name | ||
|---|---|---|---|
| Submitted: | 30 Nov 2007 21:58 | Modified: | 2 Dec 2007 19:57 |
| Reporter: | Mike Willbanks | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Workbench | Severity: | S4 (Feature request) |
| Version: | 5.0.10 SE Beta | OS: | Windows (XP SP2) |
| Assigned to: | Alfredo Kojima | CPU Architecture: | Any |
| Tags: | foreign key | ||
[2 Dec 2007 19:57]
Alfredo Kojima
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.
If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at
http://dev.mysql.com/doc/en/installing-source.html
Description: When you attempt to create a foreign key between 2 tables and set the foreign key name to fk_%dtable%_%column% in Model->Model Options->Model it does not translate %column% to an actual column name. How to repeat: 1. Navigate to Model->Model Options 2. Under Foreign Key Name set the default to fk_%dtable%_%column% 3. Create a table with an id column 4. Create a separate table with an id column 5. Select The 1:n tool ("Place a New 1:n Non-Identifying Relationship") 6. Select the source table (step 3) then select the separate table (step 4) 7. Notice the index name and relationship name has %column% Suggested fix: The %column% would be replaced with the column(s) name(s).