Bug #85178 Unable to set table when exporting data from a JOIN
Submitted: 24 Feb 2017 17:54 Modified: 5 Apr 2017 14:18
Reporter: Knight Yoshi Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:6.3.6, 6.3.9 OS:MacOS (10.12.4 Beta (16E163f))
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[24 Feb 2017 17:54] Knight Yoshi
When exporting data that includes a JOIN, the table name cannot be changed from TABLE to the desired table name

How to repeat:
Run a  select statement like this: 

   SELECT * 
   FROM topic_post_text
   JOIN topic_posts ON topic_posts.post_id = topic_post_text.post_id
   JOIN topics ON topics.topic_id = topic_posts.topic_id
   WHERE topics.topic_id = 7007

In the results grid, use the export feature
Select/set the file to save as using "SQL INSERT statements" format

Try to change the table name in the popup that says, "Export options for SQL INSERT statements". The field cannot be selected/edited
[24 Feb 2017 17:55] Knight Yoshi
Added macOS version
[5 Apr 2017 9:24] MySQL Verification Team
Hello Charles Reffett,

Thank you for the report.
On Win7, export button is visible and allows customize table name and to export.

[5 Apr 2017 9:28] MySQL Verification Team
Workaround - try to enlarge "Export Recordset" dialog box but agree that still "export" button is partially visible.
[5 Apr 2017 14:18] Knight Yoshi
Umesh, I'm on macOS. 

Anyway, this appears to now be fixed on 6.3.9 build 10690321.