Bug #10387 Mysql server crashes for Select statement for 'max',group by and with rollup.
Submitted: 5 May 2005 13:20 Modified: 22 Jul 2005 7:53
Reporter: Disha Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.0.4 Beta-standard OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any

[5 May 2005 13:20] Disha
Description:
When we create a table 't1' and execute the 'select' statement using 'max' ,group by and with rollup.

How to repeat:
Repro Steps:

1. Set delimiter :
        delimiter //

2. Change database to 'test' ie execute the following SQL statement:
        Use test//

3. Create a table 't1' ie execute the following SQL statement:
         create table t1 (c1  INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (c1))// 

4. Execute the 'Select' statement with 'max' and 'rollup'
          select distinct max(t1) as mx from res_t1 group by t1 with rollup//

5 . Observed: Mysql server crashes.
 
Expected Result: The 'select' statement should display an appropriate output.
   
Actual Result: While executing  'select' statement it gives an error 'ERROR 2013 (HY000): Lost connection to MySQL server during query'.

Additional Information: The same behaviour is observed for 'sum',ie following are the steps:

1. Create table 't1' ie execute the following SQL statement:
         create table t1 (c1  INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (c1))// 

2. Execute the 'Select' statement with 'sum' and 'rollup':
          Select distinct sum(t1) as mx from res_t1 group by t1 with rollup//

3. Observed : Mysql server lost connection.
[5 May 2005 13:35] MySQL Verification Team
I was unable to repeat, please see below:

c:\mysql\bin>mysql -uroot test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 5.0.6-beta-debug

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

mysql> delimiter //
mysql> create table t1 (c1  INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (c1))//
Query OK, 0 rows affected (0.10 sec)

mysql> Select distinct sum(t1) as mx from res_t1 group by t1 with rollup//
ERROR 1146 (42S02): Table 'test.res_t1' doesn't exist

mysql> Select distinct sum(c1) as mx from t1 group by c1 with rollup//
Empty set (0.02 sec)
[5 Jun 2005 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[22 Jul 2005 7:53] Disha
We have tried this bug on Build 5.0.9, however it does not repro, so closing the bug.