Bug #18525 Source code path names contain spaces and cause significant pain

• Submitted: 26 Mar 2006 22:41
• Modified: 12 Sep 2006 13:47
• Reporter: Greg Lehey
• Status: Won't fix
• Category: MySQL Query Browser
• Severity: S3 (Non-critical)
• OS: Any UNIX
• Assigned to: Alfredo Kojima
• CPU Architecture: Any
• Tags: Engineering

[26 Mar 2006 22:41] Greg Lehey

Description:
The source files for MySQL query browser contain spaces.  This in non-portable and makes it extremely difficult to use UNIX tools on the source code.

How to repeat:
Many different ways; once I have got past this problem, there will be many more.  Note the use of the -X flag to find (

# tar zxf /usr/ports/distfiles/mysql-query-browser-1.1.18.tar.gz 
# find -X work  |  xargs chown grog
find: work/mysql-query-browser-1.1.18/mysql-gui-common/tools/Execute batch file build tool.reg: illegal path
find: work/mysql-query-browser-1.1.18/mysql-gui-common/res/MySQL GUI licence.rtf: illegal path
find: work/mysql-query-browser-1.1.18/mysql-gui-common/res/MySQL GUI licence.txt: illegal path

Suggested fix:
Replace all blank characters in the file name by underscores.  For example, "Execute batch file build tool.reg" would become "Execute_batch_file_build_tool.reg".

[6 Apr 2006 9:54] Valeriy Kravchuk

Thank you for a problem report. Have you used current source code from SVN? I was not able to find files with spaces in pathnames in latest mysql-query-browser-1.1.18.tar.gz sources at http://dev.mysql.com/downloads/query-browser/1.1.html.

[7 Apr 2006 4:03] Greg Lehey

I was using the source code downloaded from the web site, as you specified.  I have repeated the download and found the same problems.  You may find it easier to find this information with the following command:

$ tar tzvf mysql-query-browser-1.1.18.tar.gz  | sed 's:.* mysql-query-browser-1.1.18/::' | grep ' '
mysql-gui-common/tools/Execute batch file build tool.reg
mysql-gui-common/res/MySQL GUI licence.rtf
(etc)

You can count the files with blanks in them with:

$ tar tzvf mysql-query-browser-1.1.18.tar.gz  | sed 's:.* mysql-query-browser-1.1.18/::' | grep ' ' | wc -l
     290

[7 Apr 2006 20:10] MySQL Verification Team

Thank you for the bug report.
miguel@hegel:~/mysql-query-browser-1.1.18/mysql-gui-common/res> ls MySQL*
MySQLEULA.rtf  MySQLEULA.txt  MySQL GUI licence.rtf  MySQL GUI licence.txt

[12 Sep 2006 13:47] Alfredo Kojima

This is a problem because of the source code for other platforms, which contain
several folders and files with spaces in them. It would cause a lot of work
to update all the projects to have that fixed, so we will mark it as Won't fix.
As a workaround, I would suggest using scripts with IFS=<newline> or
find . -exec chown grog '{}'