[mysql 4.0.14-nt] MySQL eats my CPU with speical SELECT statement

Frank Schönheit <[email protected]>
Newsgroups gmane.comp.db.mysql.bugs
Organization StarOffice Software Entwicklungs GmbH; Sun Microsystems, Inc.
Message-ID <[email protected]>
Hi,

During using OpenOffice.org with MySQL, it seems a user discovered a bug
in MySQL.
The details are described in
http://www.openoffice.org/issues/show_bug.cgi?id=18039.

In short: If a sample SELECT statement (attached to the issue above) is
executed against MySQL, with the sample data also attached to the above
issue, then the CPU usage of the mysdqld-nt process jumps to 100%, and
the query doesn't return.

The original bug problem was discovered while using OpenOffice.org to
access the MySQL database, but it persists if the MySQL console is used
to execute the statement, so this is clearly a MySQL problem.

Any hints anybody?

Thanks & Ciao
Frank

-- 
- Frank Schönheit, Software Engineer, OpenOffice.org Database Access -
- [email protected]                    http://dba.openoffice.org/FAQ -
-                                                                    -
- - - - -  disclaimer: working for Sun, speaking for myself  - - - - -


-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.