Commented by: @pavel-zotov

One more sample, but in this case the 'dummy condition' like WHERE 0=0 does not help.
the problem is in PARTITION BY clause in sum()over():

DDL:

recreate table tv(id int primary key); commit;
recreate table tb(vid int references tv, qid int); commit;

insert into tv values(10);
insert into tv values(20);
insert into tv values(30);
insert into tv values(40);
commit;
insert into tb values(20,100);
insert into tb values(20,200);
insert into tb values(20,300);
insert into tb values(30,400);
commit;

QUERY:

select id,max(qid) qid_max
from(
select v.*, b.*
from tv v
left join(
select b.*
,sum(1)over(partition by qid) dummy -- this lead to WRONG result (no rows)
--,sum(qid)over() dummy -- this is OK
from tb b
) b on v.id=b.vid
)
--where 0=0 -- does NOT help in this case!
group by id
having max(qid) is null;

RESULT: no rows (wrong!).

Correct result:
ID QID_MAX
=== ============
10 <null>
40 <null>

PS. No effect if we remove FOREIGN KEY constraint.

Commented by: @pavel-zotov

Both effects disappeared, I've checked scripts on LI-T3.0.0.30792.
Perhaps this was side-effect of other bugs.