MySQL Bugs: #73363: Double menu info in schema right click

Bug #73363	Double menu info in schema right click
Submitted:	23 Jul 2014 8:43	Modified:	3 Feb 2015 5:14
Reporter:	Oka Putra	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S5 (Performance)
Version:	6.1.7	OS:	Windows (Microsoft Datacenter Edition build 9200, 64-bit)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\Administrator\AppData\Roaming\MySQL\Workbench/log/wb.log]

when right click in schema there was double menu view

How to repeat:
right click in any schema

double menu in schema right click

Attachment: mysql bug1.png (image/png, text), 214.04 KiB.

Thank you for the bug report. I couldn't repeat on my own test. Is there a
specific sequence of steps to make it repeatable or disregarding what you did
happens at anytime?. Thanks.

now become triple info in menu,
i just design err diagram
and sync model, and error occurred, i fix that error and sync model again
after that refresh schema in local instance MySQL
and right click

i think this will occurs when repeated design (like add tables, column, edit table name, column name, and delete table name and column name) in ERR diagram and Sync model

triple info menu right click schema

Attachment: mysql bug2.png (image/png, text), 122.58 KiB.

and now become four

and i now know how to repeat this bug
this bug is cleared when mysql workbench is closed and start again

start mysql workbench
i click local instance in mysql connection
and now in the position local instance mysql tab
and i open (double clicked) saved model files at desktop
and new tab will open in mysql workbench : MySQL Model (name) and ERR Diagram

after this when selected Local instance MySQL tab and right click at SCHEMAS will occur double menu info

and when opened again saved model data from file at desktop (without closing workbench) after that selected Local instance and right click on schemas it will occur triple menu info and soon

Thank you for the feedback and steps.
Verified as described on Win7 with WB 6.1.7.

Thanks,
Umesh

How to repeat:

I'm able to reproduce this step using below steps(same as reporter)

1. Open WB
2. Connect to an instance using stored connection(tried with remote instance)
3. Double click an existing model( don't try from WB home, instead locate the dir in which existing model file exists..in my case used shipped sample sakila model)
   MySQL Workbench 6.1.7\extras\sakila_full.mwb
4. Return to opened connection in step 2.
5. Navigate to an existing schema, expand tables and right click on any one table

^^ Last step triggers, subsequent clicks triggers more context menus

Screenshot..

Attachment: 2_pop.png (image/png, text), 41.41 KiB.

Screenshot..

Attachment: 3_pop.png (image/png, text), 162.38 KiB.

http://bugs.mysql.com/bug.php?id=73375http://bugs.mysql.com/bug.php?id=73375 marked as duplicate of this one.

http://bugs.mysql.com/bug.php?id=74489 marked as duplicate of this one.

Posted by developer:
 
Background

The SQLIDE context menu is created on demand (when an element is right clicked), for that there's some code that is called based on a notification system which broadcast events to the registered listeners. The code that creates the menu is one of those listeners.

Problem

The listeners were bing registered on WB startup, but also every time a document was added by double clicking on it, the latter case should not be done so a validation was added to prevent such additional registering.

This fix will prevent this issue to happen, it will be available on 6.2.5

Thanks for submitting the bug report!

Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 6.2.5 release, and here's the changelog entry:

Opening a model from the operating system's file explorer (and not from
within MySQL Workbench itself) would add duplicate entries to each table's
context menu in the schema explorer.

Thank you for the bug report.