From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: lukas.eder@gmail.com
Subject: BUG #15262: "unexpected end of tuplestore" error when using new GROUPS window function clause
Date: Fri, 06 Jul 2018 09:04:46 +0000
Message-ID: <153086788677.17476.8002640580496698831@wrigleys.postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 15262
Logged by: Lukas Eder
Email address: lukas.eder@gmail.com
PostgreSQL version: 11beta2
Operating system: Debian 6.3.0-18+deb9u1
Description:
This error can be reproduced easily as follows
postgres=# SELECT count(*) OVER (GROUPS 1 PRECEDING) FROM (VALUES (1),
(2), (2)) t(v);
ERROR: unexpected end of tuplestore
Notice the missing ORDER BY clause in the window specification. This works
as expected:
postgres=# SELECT count(*) OVER (ORDER BY v GROUPS 1 PRECEDING) FROM
(VALUES (1), (2), (2)) t(v);
count
-------
1
3
3
(3 rows)
I used the latest 11 beta 2 version on Docker:
postgres=# select version();
version
-----------------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 11beta2 (Debian 11~beta2-1.pgdg90+1) on x86_64-pc-linux-gnu,
compiled by gcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516, 64-bit
(1 row)
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: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, lukas.eder@gmail.com
Subject: Re: BUG #15262: "unexpected end of tuplestore" error when using new GROUPS window function clause
In-Reply-To: <153086788677.17476.8002640580496698831@wrigleys.postgresql.org>
* 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