Re: A bug with MAX and ENUM type - Sinisa Milivojevic - com.mysql.lists.bugs

3 messages in com.mysql.lists.bugsRe: A bug with MAX and ENUM type

From	Sent On	Attachments
Nicola	01 Sep 2002 05:19
Michael Widenius	04 Sep 2002 02:47
Sinisa Milivojevic	04 Sep 2002 11:26

Subject:	Re: A bug with MAX and ENUM type
From:	Sinisa Milivojevic (sin...@mysql.com)
Date:	09/04/2002 11:26:28 AM
List:	com.mysql.lists.bugs

Nicola writes:

Probably there is a bug with MAX function and ENUM field type.

MySQL: 3.23.52 OS: Linux 2.2.20

How-To-Repeat:

Consider the following table with its values:

[skip]

SELECT id, item, MAX(property) FROM test GROUP BY item;

the result will be: +----+--------+---------------+ | id | item | MAX(property) | +----+--------+---------------+ | 2 | blue | three | | 1 | orange | two | | 3 | yellow | two | +----+--------+---------------+

but it should be: +----+--------+---------------+ | id | item | MAX(property) | +----+--------+---------------+ | 2 | blue | four | | 4 | orange | three | | 3 | yellow | two | +----+--------+---------------+

That's all. Thank you, Nico

Hi!

Thank you for your bug report.

Unfortunately, this behaviour is not as easy to fix as we thought it would be.

To make it properly our code base would have a feature to distingish a manner in which column values are represented from the manner in which they are compared.

This will require some major changes in the code and we are planning to make those changes in version 4.1.