Re: Strange error message on GROUP BY in MySQL-4.1

Hi!

On Mon, Nov 25, 2002 at 09:38:30AM -0000, Jocelyn Fournier wrote:
> Hi,
>
> How-to-repeat :
>
> mysql> SELECT 1 FROM (SELECT 1) GROUP BY SUM(1);
> ERROR 1056: Can't group on '???'
>
> I don't know whether it's a bug or not (MySQL-4.0.6 displays "ERROR 1111:
> Invalid use of group function" for a similar query).

It was bug. Thank you for bugreport. It fixed now (patched is committed &
pushed)

--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Oleksandr Byelkin
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Lugansk, Ukraine
<___/ www.mysql.com

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13096@lists.mysql.com
To unsubscribe, e-mail

Strange error message on GROUP BY in MySQL-4.1

Hi,

How-to-repeat :

mysql> SELECT 1 FROM (SELECT 1) GROUP BY SUM(1);
ERROR 1056: Can't group on '???'

I don't know whether it's a bug or not (MySQL-4.0.6 displays "ERROR 1111:
Invalid use of group function" for a similar query).

Regards,
Jocelyn


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13094@lists.mysql.com
To unsubscribe, e-mail