[EMAIL PROTECTED] .metadata]$ mvpkg updates ready mysql-5.0.41-1.src.rpm.info
it's due nasty bug: mysql> select a.category_id from album a where exists (select album_id from image where album_id=a.id); +-------------+ | category_id | +-------------+ | 5 | | 10 | | 3 | | 8 | | 10 | +-------------+ 5 rows in set (0.00 sec) mysql> select a.category_id,count(*) from album a where exists (select album_id from image where album_id=a.id) group by 1; Empty set (0.00 sec) mysql> select version(); +-----------+ | version() | +-----------+ | 5.0.41 | +-----------+ 1 row in set (0.01 sec) ---- mysql> select a.category_id from album a where exists (select album_id from image where album_id=a.id); +-------------+ | category_id | +-------------+ | 5 | | 10 | | 3 | | 8 | | 10 | +-------------+ 5 rows in set (0.00 sec) mysql> select a.category_id,count(*) from album a where exists (select album_id from image where album_id=a.id) group by 1; +-------------+----------+ | category_id | count(*) | +-------------+----------+ | 3 | 1 | | 5 | 1 | | 8 | 1 | | 10 | 2 | +-------------+----------+ 4 rows in set (0.01 sec) mysql> select version(); +-----------+ | version() | +-----------+ | 5.0.37 | +-----------+ 1 row in set (0.00 sec) -- glen _______________________________________________ pld-devel-en mailing list pld-devel-en@lists.pld-linux.org http://lists.pld-linux.org/mailman/listinfo/pld-devel-en
