Bug in optimizer

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi!

Your bug report form on the web doesn't work.


This is very slow:

SELECT urls.id FROM urls WHERE
(
    urls.id <> ALL (SELECT html.urlid FROM html)
);

...while this is quite fast:

SELECT urls.id FROM urls WHERE
(
    NOT (EXISTS (SELECT html.urlid FROM tml WHERE
    (
        html.urlid = urls.id
    )))
);

Regards
Timo
- --
http://nentwig.biz/ (J2EE)
http://nitwit.de/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQFAlm53cmRm71Um+e0RAkJuAKChd+6zoFesZfBY/cGRsSVagnJeswCeMD5s
++Es8hVsFlUpkIIsRfrBp4Y=
=STbS
-----END PGP SIGNATURE-----