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.
MySQL 4.1.1-alpha incorrectly computes select-list
correlated subqueries. See the explanation of the
problem below. Is this a known problem?
Thanks!
Consider the following schema and data:
CREATE TABLE person (pid INTEGER, name CHAR(5));
CREATE TABLE phone (pid INTEGER, num CHAR(10));
INSERT
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:
C:\mysql\binmysqld --standalone --console --ansi --default-table-type=innodb
040328 0:36:59 InnoDB: Started; log sequence number 0 43634
mysqld: ready for connections.
Version: