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: | |
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
[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.