Update in select result is null

[jy2156121]

update a set value=1 where a.id in (select aid from b where b.id='2')
table b is apply for path_man

[funbringer]

Hello, @jy2156121!

Please take a look at our FAQ in order to improve your bug report.

[funbringer]

As far as I can understand, you're having trouble with something like this:

create table a (value int4, id int4);
create table b (aid int4, id int4 not null);
select create_range_partitions('b', 'id', 1, 100, 10);

/* this query doesn't work */
update a set value = 1 where a.id in (select aid from b where b.id = 2);

This is a known problem, and we'll try to fix it as soon as possible.

[funbringer]

Could you try master branch?

[funbringer]

Release 1.4.2 is out.
Feel free to add a comment here if anything's wrong.