Details
-
Bug
-
Status: Needs Feedback (View Workflow)
-
Major
-
Resolution: Unresolved
-
N/A
-
None
-
None
-
Q4/2026 Server Maintenance
Description
MySQL rejects DISTINCT for ANY_VALUE, while in pr - it is silently accepted, even though DISTINCT there is meaningless
CREATE TABLE t (g INT, v INT); |
INSERT INTO t VALUES (1,5),(1,5),(1,7),(2,9); |
|
|
SELECT ANY_VALUE(DISTINCT v) FROM t; |
|
|
SELECT g, ANY_VALUE(DISTINCT v), |
ANY_VALUE(v),
|
COUNT(DISTINCT v) |
FROM t GROUP BY g ORDER BY g; |
DROP TABLE t; |
Attachments
Issue Links
- is caused by
-
MDEV-10426 ANY_VALUE function
-
- In Testing
-