Bug #60562 The action pane won't checks the selected database.
Submitted: 21 Mar 2011 7:05 Modified: 23 May 2011 18:14
Reporter: Ivan Cachicatari Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.33 OS:Any
Assigned to: CPU Architecture:Any

[21 Mar 2011 7:05] Ivan Cachicatari
When you click on one option from  action pane (Add table, Add Routine, Add View) Workbench won't check the selected database.

How to repeat:
1. Create a new connection without default schema.
2. Open a connection to start sql querying.
3. Click on action pane (Add table, Add Routine, Add View)
4. Try to save the new table, view or routine. In the case of view or routine you can change the database in SQL script but in the new table you can't and will get the message 
ERROR 1102: Incorrect database name ''.

Suggested fix:
Maybe would great idea show a message like 'You must select a database'
[21 Mar 2011 7:38] Valeriy Kravchuk
Verified on Mac OS X also. The following code is generated without any additional requests:

CREATE  TABLE ``.`new_table` (
  `id` INT NOT NULL ,
  `c1` VARCHAR(45) NULL ,
  PRIMARY KEY (`id`) );

Surely it leads to error.
[23 May 2011 18:14] Paul DuBois
Noted in 5.2.34 changelog.

The SQL statement generated by clicking an item in the action pane
failed to include the qualifying database name.