pg-mem icon indicating copy to clipboard operation
pg-mem copied to clipboard

subquery not work

Open jaassoon opened this issue 1 year ago • 2 comments

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

jaassoon avatar Apr 06 '23 08:04 jaassoon