Combination of ordered-set aggregate function terminates JDBC connection on PostgreSQL 9.6.5

From: Lukas Eder <lukas(dot)eder(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Combination of ordered-set aggregate function terminates JDBC connection on PostgreSQL 9.6.5
Date: 2017-10-11 08:49:19
Message-ID: CAB4ELO5RZhOamuT9Xsf72ozbenDLLXZKSk07FiSVsuJNZB861A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

When running the following query:

select
cume_dist(1) within group (order by a desc),
rank(1) within group (order by a desc),
dense_rank(1) within group (order by a asc),
percent_rank(1) within group (order by a asc)
from (values(1)) t(a);

My JDBC connection is immediately terminated:

SQL Error [08006]: An I/O error occurred while sending to the backend.
An I/O error occurred while sending to the backend.
Connection reset

The issue depends on a certain set of combinations of the above function
calls. Each function can be called individually without problems. Some
functions can be combined without problems as well.

The issue can be reproduced in pgAdmin III and pgAdmin 4.

I'm using PostgreSQL 9.6.5 on Windows 10 x86-64

SELECT version();

version |
------------------------------------------------------------|
PostgreSQL 9.6.5, compiled by Visual C++ build 1800, 64-bit |

Thanks,
Lukas

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message kes-kes 2017-10-11 10:35:12 BUG #14850: Implement optinal additinal parameter for 'justify' date/time function
Previous Message marko 2017-10-11 02:00:58 BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much