Bug #57378 Forward Enginner SQL Create Script generates an ";" before sentence"create user"
| Submitted: | 11 Oct 2010 16:02 | Modified: | 11 Nov 2010 14:26 |
|---|---|---|---|
| Reporter: | Gerardo Palma | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Workbench: Modeling | Severity: | S3 (Non-critical) |
| Version: | 5.2.28 CE, 5.2.29 | OS: | Any (Windows, Mac OS X) |
| Assigned to: | Alexander Musienko | CPU Architecture: | Any |
| Tags: | Export Forward Engineer SQL Create Script | ||
[11 Oct 2010 16:02]
Gerardo Palma
[11 Oct 2010 16:16]
Valeriy Kravchuk
It is easy to repeat. Just create one role (with no privileges) and one user in the model. This is the result of forward engineering: SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL'; ; CREATE USER `user1`; SET SQL_MODE=@OLD_SQL_MODE; SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
[8 Nov 2010 19:50]
Johannes Taxacher
fix confirmed in repository
[11 Nov 2010 14:26]
Tony Bedford
An entry has been added to the 5.2.30 changelog: When a model was forward engineered with File, Export, Forward Engineer SQL CREATE Script, the generated script contained a statement that consisted of a single delimiter, “;”.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.054 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.