From: Tom Lane <tgl@sss.pgh.pa.us>
To: =?koi8-r?B?68nSy8/X08vJyiDhzMXL08HOxNI=?= <alex.kirkouski@gmail.com>
cc: pgsql-bugs@postgresql.org
Subject: Re: Bug report
In-reply-to: <5721b901.52ad1c0a.c220c.1be4@mx.google.com>
References: <5721b901.52ad1c0a.c220c.1be4@mx.google.com>
Comments: In-reply-to =?koi8-r?B?68nSy8/X08vJyiDhzMXL08HOxNI=?=
 <alex.kirkouski@gmail.com>
	message dated "Thu, 28 Apr 2016 10:17:16 +0300"
Date: Fri, 29 Apr 2016 20:20:59 -0400
Message-ID: <5806.1461975659@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-bugs-owner@postgresql.org

=?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