mysql-5.0.41 moved back to ready
Elan Ruusamäe
glen at delfi.ee
Fri May 25 16:23:02 CEST 2007
[pldac at ep09-pld .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
More information about the pld-devel-en
mailing list