MySQL Bugs: #25780: Program crashes after two characters of the query are entered

Bug #25780	Program crashes after two characters of the query are entered
Submitted:	23 Jan 2007 13:48	Modified:	31 Jan 2007 15:30
Reporter:	Jack Levy	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S2 (Serious)
Version:	1.2.9rc	OS:	MacOS (Mac OSX)
Assigned to:	Vladimir Kolesnikov	CPU Architecture:	Any

Description:
MySQL Query Browser starts OK and connects to my database.  Then simply typing two characters into the Query box makes the program crash with "The application MySQL Query Browser quit unexpectedly". The console shows the following:

2007-01-23 10:05:57.500 MySQL Query Browser[666] Error loading bookmarks from /Users/jacklevy/Library/Application Support/MySQL/QueryBrowser/bookmarks.xml: 1
Jan 23 10:07:20 jack-levys-computer crashdump[669]: MySQL Query Browser crashed
Jan 23 10:07:21 jack-levys-computer crashdump[669]: crash report written to: /Users/jacklevy/Library/Logs/CrashReporter/MySQL Query Browser.crash.log

The crash log report starts:

Host Name:      jack-levys-computer
Date/Time:      2007-01-23 10:56:08.743 +0000
OS Version:     10.4.8 (Build 8L2127)
Report Version: 4

Command: MySQL Query Browser
Path:    /Applications/MySQL Tools/MySQL Query Browser.app/Contents/MacOS/MySQL Query Browser
Parent:  WindowServer [59]

Version: ??? (1.2.9rc)

PID:    700
Thread: 0

Exception:  EXC_BAD_ACCESS (0x0001)
Codes:      KERN_PROTECTION_FAILURE (0x0002) at 0x00000008

The full report is very long - I can supply it if required.

How to repeat:
See the description above.  I am using an Intel iMac running OSX 10.4.8.  The server I'm connecting to is version 5.0.24a-standard-log running on Linux x86 (Slackware).

Crash log

Attachment: MySQL Query Browser.crash.log (application/octet-stream, text), 15.39 KiB.

Just to add that I've now tried this on a PowerPC Mac (G4 iMac running OSX 10.4.8), and the same problem occurs.

Thank you for the report.

Please indicate 2 characters causes the crash.

Also please provide file /Users/jacklevy/Library/Application Support/MySQL/QueryBrowser/bookmarks.xml

I just typed the first two characters of "show status".  The "s" was reflected on the screen, then the "h" caused the crash. The same seems to happen with any characters.

The folder '/Users/jacklevy/Library/Application Support/MySQL/QueryBrowser' is empty.

Thank you for the report.

I was unable repeat described behaviour on Intel Mac connecting to solaris server.

Please provide also output of ls -lad /Users/jacklevy/Library/Application Support/MySQL/QueryBrowser

[mac-172:~] jacklevy% ls -lad '/Users/jacklevy/Library/Application Support/MySQL/QueryBrowser'
drwxr-xr-x   2 jacklevy  jacklevy  68 Jan 23 10:05 /Users/jacklevy/Library/Application Support/MySQL/QueryBrowser

I'm logged in as jacklevy, which has admin privilege.

I think I've found how to reproduce the problem.  It only seems to occur if the default schema used when starting the program contains a table whose name includes a hyphen character.  When I renamed that table, the problem went away.  I renamed 'people-new' to 'people_new' and it fixed the problem.

I have confirmed this on my home G4 iMac, using a locally-installed MySQL server.  Simply renaming one of the tables, adding a hyphen into the name, causes the problem to occur.

Thank you for the report.

Verified as described.

Bug is repeatable only if connection to remote machine.

Additionally application crashes when one tries to edit any table located on remote machine.

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html

There is similar bug #26187.