Re: Bug report

=?koi8-r?B?68nSy8/X08vJyiDhzMXL08HOxNI=?= <alex(dot)kirkouski(at)gmail(dot)com> writes:
> I have a query (it is attached to the letter - bug.script), that do some
> complex calculations using window functions. When the data is stored in
> global tables it works just fine (returns 2711 rows), but when data is in
> temporary tables the query returns 9076 (some rows are duplicated).

I've pushed a fix for this. Many thanks for the reproducible test case!

> I've checked, this bug is not reproduced in PostgreSQL 9.5.2, but I wonder
> if it is coincidence, because the bug is pretty fragile (changing almost any
> join leads to normal behavior), and in 9.5.2 the plan is totally different.

Yeah, it was only accidentally masked in 9.5.

regards, tom lane