Bug #39060 workbench synchronize fails
| Submitted: | 27 Aug 2008 1:48 | Modified: | 15 Oct 2009 9:37 |
|---|---|---|---|
| Reporter: | Michael Tibben | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Workbench | Severity: | S2 (Serious) |
| Version: | 5.0.24 | OS: | Windows |
| Assigned to: | CPU Architecture: | Any |
[27 Aug 2008 1:48]
Michael Tibben
[27 Aug 2008 3:49]
Valeriy Kravchuk
I had tried to generate and run create script with MySQL 5.0.67. The only problem I've got is with the view:
mysql> CREATE OR REPLACE VIEW `cdwow_u`.`u_stock_price` AS
-> SELECT product_code, currency_to, base_price*markup_multiplier*currency_m
ultiplier
-> FROM new_products
-> INNER JOIN `u_dropshipper` USING (`dropshipper_id`)
-> LEFT JOIN `u_currency_conversion` ON `base_price_currency`=`currency_from
`;
ERROR 1054 (42S22): Unknown column 'dropshipper_id' in 'from clause'
I do not see dropshipper_id column in the new_products table, so this error message is expected.
I was not able to identify BOOLEAN(2) or other problems you described with your file uploaded. Please, check if this is really the file that gives you all the problems mentioned.
[27 Aug 2008 23:44]
Michael Tibben
The problem is actually in the synchronize feature, not the create script. Attached is the synchronize file when trying to synchronize with an empty database.
[27 Aug 2008 23:57]
Michael Tibben
When I attempt to synchronize with a db which has been created with the correct create sql generated from workbench (and therefore should not need synchronization), the synch feature produces a buggy SQL file.
[12 Sep 2008 11:31]
Valeriy Kravchuk
Thank you for a problem report. Please, try to repeat with a newer version, 5.0.25, and inform about the results.
[12 Oct 2008 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
[15 Oct 2009 9:37]
Susanne Ebrecht
This is a duplicate of bug #47953. I will set this bug here as duplicate because the other has a better test description.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.058 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
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.