Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
11.8, 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL)
-
None
Description
This script:
DROP TABLE IF EXISTS t1; |
CREATE TABLE t1 (id INT); |
INSERT INTO t1 VALUES (1),(2); |
DROP PROCEDURE IF EXISTS p1; |
DELIMITER $$
|
CREATE PROCEDURE p1() |
BEGIN
|
DECLARE v INT DEFAULT 10; |
SELECT id, 10 AS n, COUNT(*) FROM t1 GROUP BY id, n WITH ROLLUP; |
SELECT id, v, COUNT(*) FROM t1 GROUP BY id, v WITH ROLLUP; |
END; |
$$
|
DELIMITER ;
|
CALL p1;
|
produces the following output:
+------+------+----------+
|
| id | n | COUNT(*) |
|
+------+------+----------+
|
| 1 | 10 | 1 |
|
| 1 | NULL | 1 |
|
| 2 | 10 | 1 |
|
| 2 | NULL | 1 |
|
| NULL | NULL | 2 |
|
+------+------+----------+
|
 |
+------+------+----------+
|
| id | v | COUNT(*) |
|
+------+------+----------+
|
| 1 | 10 | 1 |
|
| 1 | 10 | 1 |
|
| 2 | 10 | 1 |
|
| 2 | 10 | 1 |
|
| NULL | 10 | 2 |
|
+------+------+----------+
|
Notice:
- The first query correctly returns NULL in the column n for summary rows 2,4,5
- The second query erroneously returns 10 in the same rows
Attachments
Issue Links
- is duplicated by
-
MDEV-31720 Cursor protocol returns empty string instead of NULL for super-aggregated column for SELECT WITH ROLLUP
-
- Closed
-
- relates to
-
MDEV-28536 Incorrect sequence in view column processing created as select with ROLLUP and repeated columns in GROUP BY
-
- Open
-