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:
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

[10 Jul 2017 16:45] Nadia -
In last versions (from the upgrade "mysql-installer-web-community-"), 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.
[10 Jul 2017 20:22] MySQL Verification Team
Thank you for the bug report. Please describe step by step how to repeat and would be nice attach screenshots for. Thanks in advance.
[15 Jul 2017 16:58] Nadia -
Search result: last line visible, but no empty line to add a new entry

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

[15 Jul 2017 17:00] Nadia -
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.

[15 Jul 2017 17:01] Nadia -
full list, id 2243 not visible

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

[15 Jul 2017 17:01] Nadia -
full list, id 2243 visible only if I click on it

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

[15 Jul 2017 17:04] Nadia -
Apply change: in "review SQL script..." there is no id for the line changed

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

[15 Jul 2017 17:05] Nadia -
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).

[27 Jul 2017 13:10] Chiranjeevi Battula
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.

[27 Jul 2017 13:11] Chiranjeevi Battula

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