Bug #5576 Japanese characters in query area make Query Browser crash
Submitted: 14 Sep 2004 18:56 Modified: 1 Dec 2004 13:47
Reporter: Shuichi Tamagawa Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Query Browser Severity:S1 (Critical)
Version:1.0.7-beta OS:Windows (Win XP / SP2)
Assigned to: Assigned Account CPU Architecture:Any

[14 Sep 2004 18:56] Shuichi Tamagawa
Description:
If Japanese characters are inupt from Japanese input system(MS-IME) in the query area(see attached QB1.jpg), 'Invalid pointer operation' exeption occurs(see attached QB2.jpg). And if you keep typing, Query Browser crashes finally.

How to repeat:
In the query area type 3 Japanese characters and hit 'Enter' (See attached files).
[14 Sep 2004 18:57] Shuichi Tamagawa
example 1

Attachment: QB1.JPG (image/pjpeg, text), 53.69 KiB.

[14 Sep 2004 18:57] Shuichi Tamagawa
example 2

Attachment: QB2.JPG (image/pjpeg, text), 53.62 KiB.

[16 Sep 2004 16:49] Michael G. Zinner
Can you copy/paste a SQL statement containing japanese characters into that SQL Memo control? Does this also result in an error?
[16 Sep 2004 18:44] Shuichi Tamagawa
When I copied and pasted a SQL statement containing short (<20) Japanese characters, it was OK.

But, when I copied and pasted a SQL statement containing long (about 50) Japanese characters, it failed with 'Out of memory' exception (see attached file OutOfMemory.jpg) after executing the query. And right after that, Query Browser crashed with many 'Access violation' exceptions. If it contains longer Japanese characters, Query Browser crashes right after pasting without error.

'Out of memoy' and 'Access violation' exceptions are not always repeatable, but at least, it seems that using Japanese character in the query area eats lots of memory.
[16 Sep 2004 18:45] Shuichi Tamagawa
Screen shot of out of memory exception

Attachment: OutOfMemory.JPG (image/pjpeg, text), 67.18 KiB.

[16 Sep 2004 18:45] Shuichi Tamagawa
sample query

Attachment: test.sql (application/octet-stream, text), 283 bytes.