Very slow subselect (parser bug)?

2010-03-15 Thread Pascal Gienger
We're testing a bedework system here with an underlying MySQL Database: Version 5.1.44, Linux x64 (64bit), icc binary from www.mysql.com. This statement uses 1 minute of 100% CPU: select summaries0_.bw_eventid as bw1_1_, summaries0_.bw_strid as bw2_1_, bwstring1_.bw_id as bw1_70_0_,

Re: Very slow subselect (parser bug)?

2010-03-15 Thread Johan De Meersman
On Mon, Mar 15, 2010 at 4:22 PM, Pascal Gienger pascal.gien...@uni-konstanz.de wrote: Using this result to reconstruct the first left outer join from the initial statement, I get this result: Not so much a bug as a missing feature: the parser is currently unable to recognize any subselect as