Bug #49153 don't export views when "Omit Scheme Qualifier" option is checked
Submitted: 26 Nov 2009 21:57 Modified: 1 Dec 2009 10:33
Reporter: Lionel Garcia Alvarado Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:5.2.8 Beta OS:Windows (XP SP3)
Assigned to: Alexander Musienko CPU Architecture:Any
Tags: export sql, Views

[26 Nov 2009 21:57] Lionel Garcia Alvarado 
Description:
The "export" tool is no't working properly with views when I select the option "Omit Scheme Qualifier"

How to repeat:
Create a simeple table:
CREATE TABLE `table1` (
  `id` INT(8) NOT NULL ,
  `name` VARCHAR(64) NULL ,
  PRIMARY KEY (`id`) )
ENGINE = InnoDB;

then create a view:
CREATE VIEW `view1` AS
SELECT
    nombre
FROM
    table1;

Now export "SQL CREATE Script..." with the option "Omit Scheme Qualifier" checked
[1 Dec 2009 0:59] Johannes Taxacher 
fixed in repository. will be included in 5.2.10
[1 Dec 2009 10:33] Tony Bedford 
An entry was added to the 5.2.10 changelog:

When using the Forward Engineer SQL CREATE Script wizard, if the checkbox Omit Schema Qualifier in Object Names was selected, then the script code for views was omitted.