Bug #74672 Drag and drop a file.sql into the SQL editor not working when name has spaces
Submitted: 3 Nov 2014 11:27 Modified: 3 Nov 2014 12:26
Reporter: Abel Flórez Loranca Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:6.2.3.12321 OS:Linux (Ubuntu 14.04 LTS)
Assigned to: CPU Architecture:Any
Tags: drag & drop, spaces, sql editor, ubuntu

[3 Nov 2014 11:27] Abel Flórez Loranca
Description:
When I drag and drop a file from the file manager it works. But when I drop this file:

/home/abel/Documents/Ericsson/Bugs Management/Bug Priority.sql

it raises an error: 

<<<<
Could not open file /home/abel/Documents/Ericsson/Bugs%20Management/Bug%20Priority.sql

Failed to open file '/home/abel/Documents/Ericsson/Bugs%20Management/Bug%20Priority.sql':  No such file or directory
>>>>

How to repeat:
As explained before.

Ubuntu 14.04 LTS
Workbench 6.2.3.12321

Suggested fix:
Make it works!
[3 Nov 2014 12:26] Umesh Shastry
Hello Abel,

Thank you for the bug report.
Verified as described.

Thanks,
Umesh
[3 Nov 2014 12:28] Umesh Shastry
// Easy to reproduce
// Create a file with space in it and try to open it from SQL Editor
Pop up in GUI - 
Could not open file /home/ushastry/Desktop/Bug%20File.sql
Failed to open file '/home/ushastry/Desktop/Bug%20File.sql': No such file or directory

-- In logs

[ERR][ SqlEditorPanel]: Could not read file /home/ushastry/Desktop/Bug%20File.sql: 
Failed to open file '/home/ushastry/Desktop/Bug%20File.sql': No such file or directory 
17:49:33 [ERR][ SqlEditor]: Cannot open file /home/ushastry/Desktop/Bug%20File.sql: 
Failed to open file '/home/ushastry/Desktop/Bug%20File.sql': No such file or directory 1

MySQL Workbench Community (GPL) for Linux/Unix version 6.2.3  revision 12312 build 2280 (64 bit)
Configuration Directory: /home/ushastry/.mysql/workbench
Data Directory: /usr/share/mysql-workbench
Cairo Version: 1.13.1
OS: Linux 3.13.0-37-generic
CPU: Intel(R) Core(TM)2 Duo CPU     E8400  @ 3.00GHz (2964.081MHz) - 2.94GiB RAM
Distribution: Ubuntu 14.04.1 LTS