[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-bugs
Subject:    Re: [BUGS] Bug report
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2016-04-30 0:20:59
Message-ID: 5806.1461975659 () sss ! pgh ! pa ! us
[Download RAW message or body]

=?koi8-r?B?68nSy8/X08vJyiDhzMXL08HOxNI=?= <alex.kirkouski@gmail.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


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
[prev in list] [next in list] [prev in thread] [next in thread]