Bug #95667 Copy Multiple Table Rows (Design) to Another Table Overwrites Source Rows
Submitted: 6 Jun 2019 0:46 Modified: 6 Jun 2019 5:31
Reporter: Patrick Loftus Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:8.0.16 OS:Windows
Assigned to: CPU Architecture:Any

[6 Jun 2019 0:46] Patrick Loftus 
Description:
If you open a table to view properties (columns, etc.) and then copy 2+ rows to another table, when you come back to the original table, the first row will have overwritten then second row (and more rows if more than 2 rows).

How to repeat:
Right-click source table, click WRENCH icon.  From Columns view, highlight 2+ rows.  Right-click and select Copy.

Right-click destination table, click WRENCH icon.  From Columns view, select new row at bottom of design, right-click and select Paste.  Column definitions are pasted properly.

Return to source table.  Notice that all rows copied now have the name of the first row copied.

For example, copy:

rowName1
rowName2
rowName3

When you return to source table, rows are renamed:

rowName1
rowName1
rowName1

You have to revert to undo the changes.

Suggested fix:
Don't disturb source rows when pasting.  The copy function is not the culprit.
[6 Jun 2019 5:31] MySQL Verification Team 
Hello Patrick Loftus,

Thank you for the report.

regards,
Umesh