MySQL Bugs: #10982: A query from olap.test returns a wrong result set

Bug #10982	A query from olap.test returns a wrong result set
Submitted:	31 May 2005 12:02	Modified:	1 Jun 2005 3:49
Reporter:	Igor Babaev	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.0	OS:	Any (all)
Assigned to:	Igor Babaev	CPU Architecture:	Any

Description:
The following query from olap.test
SELECT a+SUM(a) FROM t1 GROUP BY a WITH ROLLUP;
returns a wrong result set:
mysql> SELECT a+SUM(a) FROM t1 GROUP BY a WITH ROLLUP;
+----------+
| a+SUM(a) |
+----------+
| 3        |
| 4        |
| NULL     |
+----------+

Must be:

mysql> SELECT a+SUM(a) FROM t1 GROUP BY a WITH ROLLUP;
+----------+
| a+SUM(a) |
+----------+
| 2        |
| 4        |
| NULL     |
+----------+

 

How to repeat:
CREATE TABLE t1 (a int(11));
INSERT INTO t1 VALUES (1),(2);
SELECT a+SUM(a) FROM t1 GROUP BY a WITH ROLLUP;

Bear in mind that the result set for the reported query in 4.1 is correct.

ChangeSet
  1.1937 05/05/31 05:56:22 igor@rurik.mysql.com +2 -0
  olap.result:
    Fixed bug #10982.
  item.cc:
    Fixed bug #10982. In the function Item_ref::val_decimal
    by mistake the method Item_ref::val_decimal was used
    instead of Item_ref::val_decimal_result.

The fix will appear in 5.0.7

Noted in 5.0.7 changelog.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/25508