CREATE TABLE tab(
c1 INT NOT NULL,
c2 INT NOT NULL
);
INSERT INTO tab VALUES (1, 2);
INSERT INTO tab VALUES (2, 1);
INSERT INTO tab VALUES (1, 2);
case 1:
SELECT c.c1, c.c2 from tab C WHERE c.c2 = ANY (
SELECT 1 FROM tab A WHERE a.c2 IN (
SELECT 1 FROM tab B WHERE a.c1 = c.c1
GROUP BY rollup(a.c1)
)
GROUP BY cube(c.c2)
)
GROUP BY grouping sets(c.c1, c.c2)
ORDER BY 1, 2 DESC;
ERROR: ORDER/GROUP BY expression not found in targetlist
case 2:
create sequence s;
SELECT setval('s', max(100)) from tab;
ERROR: ORDER/GROUP BY expression not found in targetlist
Looking further I found that error started coming with below commit:
commit aeb9ae6457865c8949641d71a9523374d843a418
Date: Thu May 26 14:52:24 2016 -0400
Disable physical tlist if any Var would need multiple sortgroupref labels.
as expected.