Re: BUG #15758: regr_* return wrong answers for some valid data

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: gumblex(at)aosc(dot)io, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15758: regr_* return wrong answers for some valid data
Date: 2019-04-16 13:41:45
Message-ID: CAMkU=1w9kdRPHNCE=gpP1RFbz7Sb7jD_jhGOJ6mZjoJusQURAQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Tue, Apr 16, 2019 at 3:55 AM PG Bug reporting form <
noreply(at)postgresql(dot)org> wrote:

> The following bug has been logged on the website:
>
> Bug reference: 15758
> Logged by: Dingyuan Wang
> Email address: gumblex(at)aosc(dot)io
> PostgreSQL version: 11.2
> Operating system: Debian
> Description:
>
> This can reproduce on at least version 10 or 11, on Debian amd64.
> Given the following data:
>

This will be improved in version 12 when that is released later this year.
See the below commit:

commit e954a727f0c8872bf5203186ad0f5312f6183746
Author: Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>
Date: Sat Oct 6 11:20:09 2018 +0100

Improve the accuracy of floating point statistical aggregates.

Cheers,

Jeff

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2019-04-16 14:10:27 BUG #15761: ODBC: SQLForeignKeys-ResultSet-Column 'deferrablity'
Previous Message anup singh 2019-04-16 13:35:21 Re: BUG #15759: Lot of idle connection created by "SET extra_float_digits = 3"