Bug #16779 crash server UNION and SUM
Submitted: 25 Jan 2006 13:23 Modified: 10 Apr 2006 18:20
Reporter: Iemma Luigi Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.0 OS:Microsoft Windows (Windows)
Assigned to: MySQL Verification Team CPU Architecture:Any

[25 Jan 2006 13:23] Iemma Luigi
Description:
this query crash server : (SELECT McoCsog,SUM(McoImpi) FROM Movcon GROUP BY McoCsog) UNION (SELECT McoCccf,SUM(McoImpi) FROM Movcon GROUP BY McoCccf)

How to repeat:
this query crash server : (SELECT McoCsog,SUM(McoImpi) FROM Movcon GROUP BY McoCsog) UNION (SELECT McoCccf,SUM(McoImpi) FROM Movcon GROUP BY McoCccf)
[25 Jan 2006 13:29] MySQL Verification Team
Could you please provide the dump script for table creation and some
inserts if needed for to run the query?

Thanks in advance.
[25 Jan 2006 14:21] Iemma Luigi
attach text file Thanks for help.

Attachment: Movcon.txt (text/plain), 7.91 KiB.

[26 Feb 2006 0: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".
[3 Mar 2006 10:43] Iemma Luigi
Movcon.txt

Attachment: Movcon.txt (text/plain), 7.91 KiB.

[3 Mar 2006 10:45] Iemma Luigi
please help
[10 Apr 2006 18:20] MySQL Verification Team
Works fine on 5.0.19/5.0.20

mysql> (SELECT McoCsog,SUM(McoImpi) FROM Movcon GROUP BY
    -> McoCsog) UNION (SELECT McoCccf,SUM(McoImpi) FROM Movcon GROUP BY McoCccf);
+----------+--------------+
| McoCsog  | SUM(McoImpi) |
+----------+--------------+
| 01010101 | 6000         |
| 03020106 | 12000        |
| 03020301 | 200          |
| 03040301 | 600          |
| 08040101 | 2000         |
| 50010101 | 16000        |
| 51020104 | 1000         |
| C01      | 36000        |
| F01      | 1800         |
|          | 37800        |
| 03020101 | 36000        |
| 08030101 | 1800         |
+----------+--------------+
12 rows in set (0.05 sec)

mysql> select version();
+-----------+
|           |
+-----------+
| 5.0.19-nt |
+-----------+
1 row in set (0.00 sec)