On 2019-08-22 18:19, Tom Lane wrote:
> What I suggest doing is reducing extra_float_digits to -1 for this
> specific test. Changing the contents of circle_tbl seems like it'd have
> more consequences than we want, in particular there's no guarantee that
> we'd not hit similar issues in other tests if they're given different
> inputs.
I agree that reducing the output precision is better than adjusting the
code.
The circle.sql file already has SET extra_float_digits TO 0, and a few
other files have other settings with different values. Are we content
to use various numbers until it works in each case, or should we try to
use some consistency?
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services