MySQL Bugs: #56081: Cannot right mouse click on database view

Bug #56081	Cannot right mouse click on database view
Submitted:	18 Aug 2010 6:05	Modified:	2 Sep 2010 4:22
Reporter:	Robert Gruener	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.2.26 CE	OS:	Windows (Version 7 64-bit)
Assigned to:		CPU Architecture:	Any

Description:
Right mouse click on view does not work. Instead a bug report is given with the the message "Attempted to read or write protected memory".

How to repeat:
Right mouse click on view.

Hello Robert,
in which part of workbench do you right-click on a view to get this error? i cannot reproduce that on our systems.
thanks in advance

I had a further look at this, and the bug is appearing only for the views from one particular database. Here a dump of the view from the database.

mysql> show create view o2reports.wiki_request_list;
+-------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
| View              | Create View                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | character_set_client | collation_connection |
+-------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
| wiki_request_list | CREATE ALGORITHM=UNDEFINED DEFINER=`support`@`%` SQL SECURITY DEFINER VIEW `o2reports`.`wiki_request_list` AS select `sysaid_all_request_details`.`id` AS `Num`,`sysaid_all_request_details`.`title` AS `Title`,`sysaid_all_request_details`.`status` AS `Status`,`sysaid_all_request_details`.`problem_sub_type` AS `Type`,`sysaid_all_request_details`.`insert_time` AS `Started`,`sysaid_all_request_details`.`close_time` AS `Closed`,`sysaid_all_request_details`.`request_user` AS `RequestedBy`,`sysaid_all_request_details`.`company` AS `Customer`,`sysaid_all_request_details`.`ci_name` AS `Device`,`sysaid_all_request_details`.`vendor` AS `Vendor`,`sysaid_all_request_details`.`model` AS `Model` from `o2reports`.`sysaid_all_request_details` order by `sysaid_all_request_details`.`id` | utf8                 | utf8_general_ci      |
+-------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
1 row in set (0.00 sec)

Robert, please provide:

SHOW CREATE TABLE o2reports.sysaid_all_request_details;

mysql> show create table o2reports.sysaid_all_request_details;
+----------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
| View                       | Create View                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      | character_set_client | collation_connection |
+----------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
| sysaid_all_request_details | CREATE ALGORITHM=UNDEFINED DEFINER=`support`@`%` SQL SECURITY DEFINER VIEW `o2reports`.`sysaid_all_request_details` AS select `sysaid_requests`.`id` AS `id`,`sysaid_requests`.`title` AS `title`,`sysaid_requests`.`status` AS `status`,`sysaid_requests`.`problem_type` AS `problem_type`,`sysaid_requests`.`problem_sub_type` AS `problem_sub_type`,`sysaid_requests`.`insert_time` AS `insert_time`,`sysaid_requests`.`close_time` AS `close_time`,timediff(`sysaid_requests`.`close_time`,`sysaid_requests`.`insert_time`) AS `resolve_time`,`sysaid_requests`.`submit_user` AS `submit_user`,`sysaid_requests`.`request_user` AS `request_user`,`sysaid_requests`.`company_name` AS `company`,`sysaid_requests`.`ci_id` AS `ci`,`sysaid_ci_list`.`ci_name` AS `ci_name`,`sysaid_ci_list`.`serial` AS `serial`,`sysaid_ci_list`.`company_name` AS `ci_company`,`sysaid_ci_list`.`model` AS `model`,`sysaid_ci_list`.`vendor` AS `vendor` from (`o2reports`.`sysaid_requests` left join `o2reports`.`sysaid_ci_list` on((`sysaid_requests`.`ci_id` = `sysaid_ci_list`.`id`))) | utf8                 | utf8_general_ci      |
+----------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+

Thank you for the feedback.

Please send us dump which can be loaded: all underlying tables and views for every view referenced. Most easiest way to get such dump is run mysqldump with --no-data option.

Tried to verify using simplified but similar view construction, no result. As Sveta requested, please provide entire schema dump.

How many tables, views and routines do you have in that schema? This sounds like a duplicate of bug #55822 which happened when you clicked on a routine or view with an index larger than the number of tables you have (ie, if you have 4 tables and right click on view or routine #6, it would give the err you describe).

Please, check with a newer version, 5.2.27, and inform about the results.

Yes, this bug has been fixed now with 5.2.27. Thanks for letting me know.