MySQL Bugs: #67001: Right-click options on tables not available when schemas are filtered

Bug #67001	Right-click options on tables not available when schemas are filtered
Submitted:	28 Sep 2012 7:29	Modified:	31 May 2018 17:44
Reporter:	Darren Miller	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	5.2.43	OS:	Linux (Linux 3.2.0-31-generic)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
When multiple schemas are available, the right-click options on tables are different if the schemas are filtered.
For example, with all schemas viewed I can drill down to an individual table, right-click and select 'Select top 1000 rows'.
If I filter to a schema that option is no longer available.

----- Developer Notes -----

MySQL Workbench CE for Linux/Unix version 5.2.43  revision 9869
Configuration Directory: /home/darren/.mysql/workbench
Data Directory: /usr/share/mysql-workbench
Cairo Version: 1.10.2
OS: Linux 3.2.0-31-generic
CPU: 8x Intel(R) Core(TM) i7 CPU         860  @ 2.80GHz 1200.000 MHz, 15.7 GB RAM
Distribution: Ubuntu 12.04.1 LTS

How to repeat:
Open a SQL Editor to a connection with multiple databases.
Do not filter the schema.
Drill down to a database table and right click - note options
Now pick one database and filter to that schema
Now drill down again to a database table and right-click - note lack of options

Thank you for the bug report. Please provide screen-shot before/after?. Thanks.

my OS won't let me screen grab with the right-click menu visible, but here are the two lists.

With all db schemas visible, right-clicking on a table name gives these options:

  Select Row - Limit 1000
  Edit table data
  Copy to Clipboard >
  Send to SQL Editor >
  ---------------------
  Alter table
  Drop table
  ---------------------
  Refresh all

When filtered to one DB schema, right-clicking on a table name gives these options:

  Set as default schema
  Filter to this schema
  ---------------------
  Copy to Clipboard >
  Send to SQL Editor >
  ---------------------
  Alter table
  Drop table
  ---------------------
  Refresh all

Thank you for the feedback.

Bug #66994 is a duplicate

Problem does not occur for me in 6.3.4.0 on Microsoft Windows 7 Home Premium SP 1, 64-bit.

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

The context menus associated with tables in the schema tree did not
function when the schema list was filtered.

Thank you for the bug report.