MySQL Bugs: #24967: syncing an empty schema with an empty db = oddness

Bug #24967	syncing an empty schema with an empty db = oddness
Submitted:	11 Dec 2006 18:21	Modified:	12 Dec 2006 15:27
Reporter:	Carl Karsten (Silver Quality Contributor)	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Workbench Preview	Severity:	S3 (Non-critical)
Version:	1.1.7alpha	OS:	Linux (linux)
Assigned to:		CPU Architecture:	Any

Description:
Another "I shouldn't be doing this" but think it is worth looking at.

I did get an error, but I think the error is a well handled user error. but the "drop/add" worries me.

How to repeat:
mysql> create database op7;
mysql> grant all on op7.* to opadmin identified by 'abc';

carl@asus17:~$ mysql-workbench

menu: Database, Synchronize, MySql, enter "host, user, pass, default schema", hit ShowMore, Next

Note: the "default schema" option (both label and textbox") are not always there. This should be a seperate bug report, but I don't have time to find the cause, so ignore this line if you must :)

Fetching schemata...
Schemata fetched.

hit Next,

select op7, next

Reverse engineering schema...
Changes list fetched.

hit Next,

See this 'chart':

Database Object Action Model Object
q default Update DB default
_ op7 Drop Object _
_ _ Create Object test

um... OK, test server, so lets hit Next....

DROP DATABASE IF EXISTS `op7`;
CREATE DATABASE IF NOT EXISTS `test`
CHARACTER SET latin1;

Yeah, that is very not good. but tesing, so Next

[x] Apply changes to database
Synchronization completed successfully
Access denied for user 'opadmin'@'%' to database 'test'

Doubting the "successfully"

Somewhere in doing these steps I got these message on the console:

** (mysql-workbench-bin:20412): CRITICAL **: myx_grt_bridge_dict_item_set_value: assertion `dict!=NULL' failed

** (mysql-workbench-bin:20412): CRITICAL **: myx_grt_dict_struct_get_name: assertion `dict != NULL' failed

connection options w/default schema

Attachment: wb1a.png (image/png, text), 33.77 KiB.

connection options wo/default schema

Attachment: wb1b.png (image/png, text), 29.72 KiB.

drop/create

Attachment: wb2.png (image/png, text), 28.98 KiB.

successfully denied

Attachment: wb2.png (image/png, text), 28.98 KiB.

Thank you for the bug report.

miguel@light:~> mysql-workbench

** (mysql-workbench-bin:8065): CRITICAL **: myx_grt_bridge_dict_item_set_value: assertion `dict!=NULL' failed

** (mysql-workbench-bin:8065): CRITICAL **: myx_grt_dict_struct_get_name: assertion `dict != NULL' failed