Re: [BUGS] Combination of ordered-set aggregate function terminates JDBC connection on PostgreSQL 9.6.5 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: [BUGS] Combination of ordered-set aggregate function terminates JDBC connection on PostgreSQL 9.6.5
Date
Msg-id 10402.1507734181@sss.pgh.pa.us
Whole thread Raw
In response to Re: [BUGS] Combination of ordered-set aggregate function terminatesJDBC connection on PostgreSQL 9.6.5  (Pantelis Theodosiou <ypercube@gmail.com>)
List pgsql-bugs
Pantelis Theodosiou <ypercube@gmail.com> writes:
> - it can be seen with only rank and dense_rank, with any order by (asc,
> desc, null):
> select
>   rank(1) within group (order by a),
>   dense_rank(1) within group (order by a)
> from (values (1)) t(a) ;

Check ...

> - but it doesn't happen if   (values (1)) is replaced with a single row
> table.

It did for me.  I'm using a debug-enabled build, which typically helps
to make this sort of thing more reproducible.

regression=# create table t(a int) ;
CREATE TABLE
regression=# insert into t values(1);
INSERT 0 1
regression=# select rank(1) within group (order by a), dense_rank(1) within group (order by a)
from t;                 
server closed the connection unexpectedly
        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

pgsql-bugs by date:

Previous
From: Pantelis Theodosiou
Date:
Subject: Re: [BUGS] Combination of ordered-set aggregate function terminatesJDBC connection on PostgreSQL 9.6.5
Next
From: Tom Lane
Date:
Subject: Re: [BUGS] BUG #14830: Missed NOTIFications, PostgreSQL 9.1.24