pg-mem
pg-mem copied to clipboard
subquery not work
Describe the bug
Hi, @oguimbal I came across this bug. Could you please take a look?
It can be reproduced in playground too.
Thanks in advance.
column "foo.bar_id" does not exist
To Reproduce
create table foo(
id uuid not null,
bar_id uuid,
version integer
);
select foo.* from foo where foo.version=(select Max(foo2.version) from foo foo2 where foo2.bar_id=foo.bar_id);
pg-mem version
2.6.8