From: Tom Lane <tgl@sss.pgh.pa.us>
To: Кирковский Александр <alex.kirkouski@gmail.com>
Cc: pgsql-bugs@postgresql.org
Subject: Re: Bug report
Date: Fri, 29 Apr 2016 20:20:59 -0400
Message-ID: <5806.1461975659@sss.pgh.pa.us> (raw)
In-Reply-To: <5721b901.52ad1c0a.c220c.1be4@mx.google.com>
References: <5721b901.52ad1c0a.c220c.1be4@mx.google.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-bugs>
=?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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, alex.kirkouski@gmail.com
Subject: Re: Bug report
In-Reply-To: <5806.1461975659@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox