Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.11, 11.4, 11.8, 12.3, 11.4.10
-
None
-
Not for Release Notes
Description
Under semantic-equivalent rewriting, extracting a grouped aggregate into a view causes a stable row-count mismatch on MariaDB.
The source and mutated queries are logically equivalent, but produce different results.
CREATE TABLE t3 (c1 INT, c6 INT, c14 SET('a')); |
INSERT INTO t3 VALUES (1, 1, 'a'); |
|
|
-- Source Original SQL
|
SELECT SUM(DISTINCT c1) AS col_1 |
FROM t3 |
GROUP BY c1, c6 |
HAVING MIN(c14) >= 1 |
ORDER BY c6; |
|
|
-- View SQL
|
CREATE VIEW v AS |
SELECT SUM(DISTINCT c1) AS col_1, c6 |
FROM t3 |
GROUP BY c1, c6 |
HAVING MIN(c14) >= 1; |
|
|
-- Mutated SQL
|
SELECT col_1 FROM v ORDER BY c6; |
Observed result - Query A (original):
| col_1 |
|---|
| 1 |
Observed result - Query B (mutated):
Empty set
Attachments
Issue Links
- duplicates
-
MDEV-39580 CREATE VIEW extraction causes row loss in CROSS JOIN + GROUP BY/HAVING query
-
- Confirmed
-