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