MySQL Bugs: #18710: group by doesn't work

Bug #18710	group by doesn't work
Submitted:	1 Apr 2006 17:25	Modified:	1 Apr 2006 17:58
Reporter:	Mircea LUTIC	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.0.19	OS:	Windows (Win32)
Assigned to:		CPU Architecture:	Any

Description:
mysql> select stat  from lot group by stat;
+------+
| stat |
+------+
| $F   |
| $L   |
| $R   |
| $S   |
| $V   |
| 3D   |
| AI   |
| AK   |
| AP   |
| PU   |
| SD   |
| SP   |
| XX   |
| ^K   |
| ^L   |
+------+
15 rows in set (0.00 sec)

mysql> select stat , count(*) from lot group by stat;
+------+----------+
| stat | count(*) |
+------+----------+
| $F   | 179      |
+------+----------+
1 row in set (0.00 sec)

How to repeat:
create a database and copy the lot table files in there
the lot table was created with Mysql 4.1.

I'd like to attach an archive with the table.
There doesn't seem to be a way to do it?

 

Suggested fix:
make it work

Please do not submit the same bug more than once. An existing
bug report already describes this very problem. Even if you feel
that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments
to the original bug instead.

Thank you for your interest in MySQL.

Additional info:

http://bugs.mysql.com/bug.php?id=18709