BUG #14913: Test for aggregates fails

From: jens(dot)with(at)t-online(dot)de
To: pgsql-bugs(at)postgresql(dot)org
Cc: jens(dot)with(at)t-online(dot)de
Subject: BUG #14913: Test for aggregates fails
Date: 2017-11-16 22:44:01
Message-ID: 20171116224401.1466.68649@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14913
Logged by: Jens With
Email address: jens(dot)with(at)t-online(dot)de
PostgreSQL version: 10.1
Operating system: OEL 4.9
Description:

./configure --enable-static --enable-shared --with-includes=$IMPROOT/include
--with-libraries=$IMPLIB --exec_prefix=$IMPROOT --bindir=$IMPBIN
--libdir=$IMPLIB --prefix=$IMPROOT --with-pgport=$port

parallel group (20 tests): select_into select_distinct select_distinct_on
select_implicit select_having subselect case aggregates transactions random
portals arrays btree_index union update join namespace delete hash_index
prepared_xacts
select_into ... ok
select_distinct ... ok
select_distinct_on ... ok
select_implicit ... ok
select_having ... ok
subselect ... ok
union ... ok
case ... ok
join ... ok
aggregates ... FAILED
transactions ... ok
random ... ok
portals ... ok
arrays ... ok
btree_index ... ok
hash_index ... ok
update ... ok
namespace ... ok
prepared_xacts ... ok
delete ... ok

***
/imphome/imppg/.install/impmake/postgresql/postgresql-10.1/src/test/regress/expected/aggregates.out Tue
Nov 7 01:46:52 2017
---
/imphome/imppg/.install/impmake/postgresql/postgresql-10.1/src/test/regress/results/aggregates.out Thu
Nov 16 22:26:48 2017
***************
*** 1575,1583 ****

select percentile_disc(array[0,0.1,0.25,0.5,0.75,0.9,1]) within group
(order by thousand)
from tenk1;
! percentile_disc
! ----------------------------
! {0,99,249,499,749,899,999}
(1 row)

select percentile_cont(array[0,0.25,0.5,0.75,1]) within group (order by
thousand)
--- 1575,1583 ----

select percentile_disc(array[0,0.1,0.25,0.5,0.75,0.9,1]) within group
(order by thousand)
from tenk1;
! percentile_disc
! -----------------------------
! {0,100,249,499,749,900,999}
(1 row)

select percentile_cont(array[0,0.25,0.5,0.75,1]) within group (order by
thousand)

======================================================================

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2017-11-16 23:32:49 Re: BUG #14913: Test for aggregates fails
Previous Message David G. Johnston 2017-11-16 21:27:06 Re: BUG #14912: Undocumented: 'psql -l' assumes database 'postgresql' not $USER