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:
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:8.0.21 OS:Windows (10 Home V2004)
Assigned to: CPU Architecture:x86

[27 Oct 2020 21:33] Mikey Fordyce
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.
[30 Oct 2020 12:31] MySQL Verification Team
Hello Mikey Fordyce,

Thank you for the bug report.
Verified as described.

Ashwini Patil
[30 Oct 2020 12:32] MySQL Verification Team
8.0.22 test results

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