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