Bug #60256 Mac Workbench Export Query: File Path Failed to Open File

Submitted: 25 Feb 2011 17:45 Modified: 16 May 2011 19:21
Reporter: Mike Reid Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.31 OS:MacOS (OSX v10.6.6 / MySQL v5.1.53)
Assigned to: CPU Architecture:Any
Tags: export, file, path, query, workbench

[25 Feb 2011 17:45] Mike Reid 
Description:
When exporting a record set to an external file, the Export will fail if the File Path is not absolute. For example, to manually type the path "~/export.csv" will not resolve the "~" to home directory.

How to repeat:
1. Open Workbench
2. Connect to database
3. Run a query: SELECT VERSION();
4. Click the "export recordset" button
5. Manually enter "~/export.csv" as the file path
6. Click "Export"
7. Get error: Failed to open output file: `~/export.csv`

Suggested fix:
Add support for unix "~" (home directory) in File Path.
[16 May 2011 19:21] Paul DuBois 
Noted in 5.2.34 changelog.

Record set export to a file failed unless the file name was given as
an absolute path name.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.038 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.