Bug #18709 group by doesn't work
Submitted: 1 Apr 2006 17:23 Modified: 4 Apr 2006 14:48
Reporter: Mircea LUTIC Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.19 OS:Windows (Win32)
Assigned to: CPU Architecture:Any

[1 Apr 2006 17:23] Mircea LUTIC
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)

I am attaching the lot table files 

How to repeat:
create a database and copy the lot table files in there

Suggested fix:
make it work
[1 Apr 2006 18:30] MySQL Verification Team
Thank you for the bug report.
Please create a dump file, then zip the file and attach it using
the Files tab here or upload it at:

ftp://ftp.mysql.com:/pub/mysql/upload

Thanks in advance.
[2 Apr 2006 6:52] Mircea LUTIC
I uploaded a zip file containing the lot table description and data, the index file and the error text

Mircea LUTIC
[3 Apr 2006 14:27] MySQL Verification Team
Thank you for the feedback. I was unable to repeat the behavior
reported.

c:\mysql\bin>mysql -uroot test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.19-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

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.02 sec)

mysql> select stat , count(*) from lot group by stat;
+------+----------+
| stat | count(*) |
+------+----------+
| $F   | 1        |
| $L   | 75       |
| $R   | 10       |
| $S   | 1        |
| $V   | 1        |
| 3D   | 1        |
| AI   | 1        |
| AK   | 78       |
| AP   | 1        |
| PU   | 5        |
| SD   | 1        |
| SP   | 1        |
| XX   | 1        |
| ^K   | 1        |
| ^L   | 1        |
+------+----------+
15 rows in set (0.00 sec)

mysql>

Could you please provide your my.ini file for to test on my side
according your settings? Thanks in advance.
[3 Apr 2006 15:19] Mircea LUTIC
I did a few reinstalls because of the 18737 bug (just posted) and indeed it seems to work now ?!?
I uploaded a zip file with all the my.ini backups.

Thank you
[3 Apr 2006 16:34] MySQL Verification Team
Thank you. What is the name of the zip file you uploaded?.
[4 Apr 2006 10:23] Mircea LUTIC
The zip file with the my.ini backups is called My-ini.zip
[4 Apr 2006 14:48] MySQL Verification Team
Thank you for the feedback. I was unable to repeat using your my.ini
file.