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: | |
Category: | MySQL Server | Severity: | S1 (Critical) |
Version: | 5.0 | OS: | Windows (Windows) |
Assigned to: | MySQL Verification Team | CPU Architecture: | Any |
[25 Jan 2006 13:23]
Iemma Luigi
[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)