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
• Status: Verified
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 6.3.6, 6.3.9
• OS: MacOS (10.12.4 Beta (16E163f))
• CPU Architecture: Any
• Tags: WBBugReporter

[24 Feb 2017 17:54] Knight Yoshi

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

Thanks,
Umesh

[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.

Cheers!