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