MySQL Bugs: #101349: SQL result grid, Export Dialog Filename extension and Save as type do not match

Bug #101349	SQL result grid, Export Dialog Filename extension and Save as type do not match
Submitted:	27 Oct 2020 21:33	Modified:	30 Oct 2020 12:31
Reporter:	Mikey Fordyce	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	8.0.21	OS:	Windows (10 Home V2004)
Assigned to:		CPU Architecture:	x86

Description:
When I export grid results via the button titled "Export:", it remembers the last exported filename, but not the selection for "Save as type". The "Save as type" is always set to CSV. 

How to repeat:
I export grid results to a file named Temp.xml and select Save as type "Excel Spreadsheet (*.xml)". It saves the file as an XML spreadsheet file with the name Temp.xml--as it should. 

If I then immediately, or any time there after, click the button to export a result set (same result set or a different one), the filename is set prefilled to the last file I saved, Temp.xml, but the "Save as type" is set to CSV (*.csv). If I leave at that and click save, a Temp.xml file is created, but it's contents are in CSV format. 

Suggested fix:
To remember the filename but not the "save as type" is not helpful and bad form. Its an extra step that I have to remember that I have to do. I can't imagine how many folks might have missed the mismatch, exported incorrectly and then wondered what happened when the file content didn't match the file name.

Suggested fix is to either not remember BOTH, or remember BOTH the file name and "save as type" selection.

Hello Mikey Fordyce,

Thank you for the bug report.
Verified as described.

Regards,
Ashwini Patil

8.0.22 test results

Attachment: 101349_test_results.png (image/png, text), 53.84 KiB.