* Frederik Eaton <frederik@stripped> [06/07/11 00:43]:
> mysql Ver 14.12 Distrib 5.0.22, for pc-linux-gnu (i486) using readline 5.1
>
> mysql> select avg(keyval) from nodes where keyval <= 0.6158;
> +------------------+
> | avg(keyval) |
> +------------------+
> | 0.38034999370575 |
> +------------------+
> 1 row in set (0.00 sec)
>
> mysql> select max(keyval) from nodes where keyval <= 0.6158;
> Empty set (0.00 sec)
This is repeatable in 5.0 as well.
Reported as Bug#20954 "avg(keyval) retuns 0.38 but max(keyval)
returns an empty set"
--
Konstantin Osipov, Software Developer
MySQL AB, www.mysql.com
