MySQL Bugs: #87001: Last line Hidden and "Rewiew SQL script" missing "id" value

Bug #87001	Last line Hidden and "Rewiew SQL script" missing "id" value
Submitted:	10 Jul 2017 16:45	Modified:	27 Jul 2017 13:10
Reporter:	Nadia -	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	6.3.9	OS:	Microsoft Windows (win7 ultimate SP1 64bit)
Assigned to:		CPU Architecture:	Any
Tags:	Hidden, last line, line hiden

Description:
In last versions (from the upgrade "mysql-installer-web-community-5.7.17.0"), and latest upgrades, both in 32 e 64 bit versions, often (but not always) happens that in the line list (both for all lines or after a search), there is no empty line at the end (to add a new entry) and the last filled line is hidden (it appears only after clicking on it with the mouse).

Moreover (often when the line is not visible, but sometime even when all seems working fine), as I change some field and click on "apply", the "review SQL script" windows reports the modify but rather than "... WHERE 'id'='123';", I read "... WHERE;" and it obviously give an error.

How to repeat:
It happens randomly, but is quite frequent.

Thank you for the bug report. Please describe step by step how to repeat and would be nice attach screenshots for. Thanks in advance.

Search result: last line visible, but no empty line to add a new entry

Attachment: 1.jpg (image/jpeg, text), 173.85 KiB.

Search result: As I click on a line different form the last, the last line desappear (see image before for difference)

Attachment: 2.jpg (image/jpeg, text), 170.67 KiB.

full list, id 2243 not visible

Attachment: 3.jpg (image/jpeg, text), 194.57 KiB.

full list, id 2243 visible only if I click on it

Attachment: 4.jpg (image/jpeg, text), 198.49 KiB.

Apply change: in "review SQL script..." there is no id for the line changed

Attachment: 5.jpg (image/jpeg, text), 198.59 KiB.

As said, it is random... Happens both if I search for some word line in a table and if I just list all the data in the table. I'll attach some screenshot.

If it may help, I often work on a table which is about 2.000 entries (no limit to the result).

Thanks

Hello Nadia,

Thank you for the feedback.
I could not repeat the issue at our end using with MySQL workbench 6.3.9 version.
If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Thanks,
Chiranjeevi.

Screenshot

Attachment: 87001.JPG (image/jpeg, text), 122.21 KiB.