Bug #78280 "Copy All Field Names" feature adds extra fields to clipboard
Submitted: 31 Aug 2015 1:20 Modified: 7 Dec 2015 22:35
Reporter: michael plavins Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:6.3.4.0 OS:Windows
Assigned to: CPU Architecture:Any

[31 Aug 2015 1:20] michael plavins 
Description:
In the Query Browser, if you right-click the column headings of a resultset you get the option to "Copy All Field Names" - however when you do it adds extra column names - usually the first 1 or 2 columns repeated then one called "id" even if it doesn't exist.

How to repeat:
Example:

CREATE TABLE `alertactionedby` (
  `AlertID` int(10) unsigned NOT NULL DEFAULT '0',
  `ActionedOperatorID` int(10) NOT NULL DEFAULT '0',
  `ReadDate` datetime DEFAULT '0000-00-00 00:00:00',
  `ActionPerformed` varchar(256) DEFAULT NULL,
  `ModifyDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`AlertID`,`ActionedOperatorID`),
  KEY `Index_ActionedOperatorID` (`ActionedOperatorID`,`ReadDate`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

SELECT * FROM alertactionedby;

Right-click, "Copy All Field Names", Paste:

AlertID, ActionedOperatorID, ReadDate, ActionPerformed, ModifyDate, AlertID, ActionedOperatorID, id

Note that "AlertID" and "ActionedOperatorID" are repeated, and "id" does not exist in the table at all.
[31 Aug 2015 4:43] MySQL Verification Team 
Hello michael plavins,

Thank you for the report.
Verified as described on Win7 with WB 6.3.4.

Thanks,
Umesh
[7 Dec 2015 22:35] Philip Olson 
Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 6.3.6 release, and here's the changelog entry:

The "Copy All Field Names" action would insert extra (repeated) column
names.

Thank you for the bug report.