Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #15758: regr_* return wrong answers for some valid data - Mailing list pgsql-bugs

From Jeff Janes
Subject Re: BUG #15758: regr_* return wrong answers for some valid data
Date
Msg-id CAMkU=1w9kdRPHNCE=gpP1RFbz7Sb7jD_jhGOJ6mZjoJusQURAQ@mail.gmail.com
Whole thread Raw
In response to BUG #15758: regr_* return wrong answers for some valid data  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #15758: regr_* return wrong answers for some valid data  (Dingyuan Wang <gumblex@aosc.io>)
List pgsql-bugs
Tree view
On Tue, Apr 16, 2019 at 3:55 AM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      15758
Logged by:          Dingyuan Wang
Email address:      gumblex@aosc.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.a.rasheed@gmail.com>
Date:   Sat Oct 6 11:20:09 2018 +0100

    Improve the accuracy of floating point statistical aggregates.



Cheers,

Jeff

pgsql-bugs by date:

Previous
From: anup singh
Date:
Subject: Re: BUG #15759: Lot of idle connection created by "SETextra_float_digits = 3"
Next
From: PG Bug reporting form
Date:
Subject: BUG #15761: ODBC: SQLForeignKeys-ResultSet-Column 'deferrablity'