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

[24 Feb 2017 17:54] Charles Reffett

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] Charles Reffett

Added macOS version

[5 Apr 2017 9:24] Umesh Shastry

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] Umesh Shastry

Workaround - try to enlarge "Export Recordset" dialog box but agree that still "export" button is partially visible.

[5 Apr 2017 14:18] Charles Reffett

Umesh, I'm on macOS. 

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

Cheers!