List:General Discussion« Previous MessageNext Message »
From:Michael Stassen Date:March 28 2004 4:00pm
Subject:Re: Bug in MySQL with Correlated Subqueries?
View as plain text  
Are you saying this is a bug which has already been fixed for the next release?

In any case, it may be worth noting that the manual says correlated 
subqueries "are inefficient and likely to be slow. Rewriting the query as a 
join might improve performance." 
<http://www.mysql.com/doc/en/Correlated_subqueries.html>.

   SELECT person.pid, count(*) AS C
   FROM person, phone
   WHERE person.pid=phone.pid
   GROUP BY person.pid;

   +------+---+
   | pid  | C |
   +------+---+
   |    1 | 2 |
   |    2 | 1 |
   +------+---+
   2 rows in set (0.00 sec)

Michael

Miguel Angel Solorzano wrote:
> At 13:59 27/3/2004, Ed Smith wrote:
> Hi,
> 
> Below the results from a server built with BK 4.1 tree 3
> days ago:
> 
<Correct results snipped>
 >
> Miguel Angel Solórzano <miguel@stripped>
> São Paulo - Brazil


Thread
Bug in MySQL with Correlated Subqueries?Ed Smith27 Mar
  • Re: Bug in MySQL with Correlated Subqueries?Miguel Angel Solorzano28 Mar
    • Re: Bug in MySQL with Correlated Subqueries?Michael Stassen28 Mar