db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jim Reynolds" <jreyno...@perfExperts.com>
Subject query with subquery problem
Date Sun, 06 Sep 2009 21:01:55 GMT
This query seems to go into an infinite loop. It runs for hours but never
completes. The sub query runs in a few milliseconds when is not a sub query.


 

Is this a bug or have I missed something fundamental.

 

SELECT BFNAME FROM BFTABLE

WHERE BFNUMBER IN

(              SELECT BFNUMBER

                FROM BFDETAILTABLE

                GROUP BY BFNUMBER

                HAVING COUNT(*) > 1 

)

 

 

Thanks


Mime
View raw message