Bug with ROLLUP

thomas_w · Post by **thomas_w** » Sun 10 Apr 2011 11:49

devart studie did not show correct result using WITH ROLLUP. NULL row and colums lost. MySQL Console work well.

CREATE TABLE obst (
 anzahl INT NOT NULL,
 art VARCHAR(20) NOT NULL,
 saison VARCHAR(20) NOT NULL
);

INSERT INTO obst VALUES
(1, 'Apfel', 'Sommer'),
(2, 'Apfel', 'Winter'),
(3, 'Bananen', 'Sommer'),
(4, 'Bananen', 'Winter'),
(5, 'Birnen', 'Sommer'),
(6, 'Birnen', 'Winter');

SELECT saison, art, SUM(anzahl) AS anzahl
 FROM obst
GROUP BY saison, art WITH ROLLUP;

devart Professional Editon 4.50.339

===================================================================
|         saison           |        art        |       anzahl     |
===================================================================
|         Sommer           |       Apfel       |        1,0       |
-------------------------------------------------------------------
|         Sommer           |      Bananen      |        3,0       |
-------------------------------------------------------------------
|         Sommer           |       Birnen      |        5,0       |
-------------------------------------------------------------------
|         Winter           |       Apfel       |        2,0       |
-------------------------------------------------------------------
|         Winter           |      Bananen      |        4,0       |
-------------------------------------------------------------------
|         Winter           |       Birnen      |        6,0       |
-------------------------------------------------------------------


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

mysql>

mysql> SELECT saison, art, SUM(anzahl) AS anzahl
    ->  FROM obst
    -> GROUP BY saison, art WITH ROLLUP;
+--------+---------+--------+
| saison | art     | anzahl |
+--------+---------+--------+
| Sommer | Apfel   |      1 |
| Sommer | Bananen |      3 |
| Sommer | Birnen  |      5 |
| Sommer | NULL    |      9 |

with kind regards,
Thomas

Alexz · Post by **Alexz** » Mon 11 Apr 2011 06:55

We fixed this problem. Please download the recent version of the product. dbForge Studio for MySQL v4.50.348 is available for download now.

thomas_w · Post by **thomas_w** » Mon 11 Apr 2011 16:30

Thanks! Work well with 4.50.348.

with kind regards,
Thomas