Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.11, 11.4, 11.8, 12.3, 12.1.2, 12.3.2
-
Can result in unexpected behaviour
Description
CREATE TABLE b (id BIGINT, name VARCHAR(255)); |
INSERT INTO b VALUES (NULL, NULL), (2, 'abc'), (2, 'o''brien'); |
CREATE VIEW t AS SELECT * FROM b; |
 |
SELECT MIN(name) OVER (PARTITION BY id), MIN(id) OVER (ORDER BY name) |
FROM t |
GROUP BY id, name; |
-- ERROR 1052 (23000): Column 'id' in GROUP BY is ambiguous |
However, querying the base table succeeds:
SELECT MIN(name) OVER (PARTITION BY id), MIN(id) OVER (ORDER BY name) |
FROM b |
GROUP BY id, name; |