Bug #66269 VIEW shows up in object browser under TABLE list after using SELECT ROWS feature
Submitted: 8 Aug 2012 22:03 Modified: 9 Jan 2015 9:51
Reporter: Bob Dankert Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.41 OS:Windows (W7 32)
Assigned to: CPU Architecture:Any
Tags: Object Browser, select rows, table, VIEW

[8 Aug 2012 22:03] Bob Dankert 
Description:
After using the SELECT ROWS - LIMIT 1000 function from the context menu of a View in the object browser, the View gets added to the Table list.  The View then appears twice - once in the Table list and once in the View list.  You have to close out of the connection to correct this.

How to repeat:
1. Right click on a View in the object browser, click Select Rows - Limit nnnn
2. Notice that the View is now at the bottom of the Tables list in the object browser.

Suggested fix:
Don't put the view in the table list, leave it as a view
[9 Aug 2012 0:00] MySQL Verification Team 
Thank you for the bug report.
[16 Aug 2012 12:41] MySQL Verification Team 
http://bugs.mysql.com/bug.php?id=66418 marked as duplicate of this one.