tender wang <tndrwang@gmail.com> writes:
> After a61b1f74823c commit, below query reports error:
> create table perm_test1(a int);
> create table perm_test2(b int);
> select subq.c0
> from (select (select a from perm_test1 order by a limit 1) as c0, b as c1
> from perm_test2 where false order by c0, c1) as subq where false;
> ERROR: permission info at index 1 (with relid=16457) does not match
> provided RTE (with relid=16460)
Yeah, this was also reported by Justin Pryzby [1].
> Below codes can fix this:
Right you are. Pushed, thanks!
regards, tom lane
[1] https://www.postgresql.org/message-id/20230212233711.GA1316%40telsasoft.com