MySQL Bugs: #63900: EDIT mode does not use query filter in right way

Bug #63900	EDIT mode does not use query filter in right way
Submitted:	2 Jan 2012 18:58	Modified:	12 Feb 2012 21:44
Reporter:	Oleg Preobrazhenskyy	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S1 (Critical)
Version:	>5.2.35	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
While table is too big (above 1000 rows which is a defualt limit for query  in MySQL workbench), query filter does not work for rows that are out of those 1000 rows limit.

For example, in earlier versions I could use

EDIT kbposts where postsid=168758;

To achive edit of the row.

Now, as i see this command was removed and there is the only option in context menu to enter in edit mode.

And there is no way to edit the row.

How to repeat:
Create any big table (>1000 rows), use "edit table data" context menu.
Try to apply search filter for row that is out of selected limited rows.

Suggested fix:
1. Or return working EDIT command
2. Or fix filter to seach not only among rows currently LIMITED by default limit but within whole table.

Had you tried to execute:

select * from kbposts where postsid=168758;

and then edit the row in the results and commit changes? It should work, almost as good as EDIT previously...

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Yes it works but It does not help to solve the task originally described.

You can still use SELECT * from kbposts where postsid=168758 and edit the results.

As I understand the developers wouldn't like to revive an EDIT command? right?