Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mv4Xu-0004PH-Cg for pgsql-bugs@arkaria.postgresql.org; Wed, 08 Dec 2021 21:32:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mv4XN-0003F7-El for pgsql-bugs@arkaria.postgresql.org; Wed, 08 Dec 2021 21:31:41 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mv45m-0006dj-Ff for pgsql-bugs@lists.postgresql.org; Wed, 08 Dec 2021 21:03:10 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mv45h-0008RQ-6W for pgsql-bugs@lists.postgresql.org; Wed, 08 Dec 2021 21:03:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=vqMsU6E9eC/xx1qMmgS9Kx+JRMgG3YFuLgAcQ0Dz3UA=; b=JXnLdwtkvTvuBrPbDyKIKe0fsw 6a2RK6rtqEsOA/HrvdJgyG8+omZuPMzYKbABPELcBrpj3pOyY1lxZhQ8OY9IlCo8Tv3O0chG+5MPs ii4dVImCg4cKExssncHZN6M+Er0fbvtKHhKTKF14St0b4ymSbhSkFSiN9vCNtrrVRaiFIHX+tlyJr IfrOntV5C+fKWdOByFn6DYwlIcUER3rsT9ESdiQ32b6nfVnHG5szYRfXRMkiKiByN6o51JPTFMBRn UVwAynAfGnOmPINX9P2Fp/rQ3A1ZOmdK9MXAENG+xDEREML6oc6whW0v/BpO9PCpDTl7cb3GDbP4+ mRHOQcFw==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mv45g-0000Z3-LP for pgsql-bugs@lists.postgresql.org; Wed, 08 Dec 2021 21:03:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mv45e-0002yq-1h for pgsql-bugs@lists.postgresql.org; Wed, 08 Dec 2021 21:03:02 +0000 Content-Type: multipart/mixed; boundary="===============5991097108770957550==" MIME-Version: 1.0 Subject: BUG #17329: Aggregate Functions Precision Error To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: neverov.max@gmail.com Reply-To: neverov.max@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 08 Dec 2021 21:02:56 +0000 Message-ID: <17329-8c3b204b1716bd24@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5991097108770957550== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzMyOQpMb2dnZWQgYnk6ICAgICAgICAgIE1heCBOZXZlcm92CkVtYWls IGFkZHJlc3M6ICAgICAgbmV2ZXJvdi5tYXhAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjog MTMuMwpPcGVyYXRpbmcgc3lzdGVtOiAgIEFscGluZSAxMC4zLjFfZ2l0MjAyMTA0MjQKRGVzY3Jp cHRpb246ICAgICAgICAKCkFnZ3JlZ2F0ZSBmdW5jdGlvbnMgKGRlc2NyaWJlZCBoZXJlCmh0dHBz Oi8vd3d3LnBvc3RncmVzcWwub3JnL2RvY3MvY3VycmVudC9mdW5jdGlvbnMtYWdncmVnYXRlLmh0 bWwjRlVOQ1RJT05TLUFHR1JFR0FURS1TVEFUSVNUSUNTLVRBQkxFKQp0aGF0IGFyZSBkZWZpbmVk IGZvciBkb3VibGUgcHJlY2lzaW9uIHR5cGUgc3VmZmVyIGZyb20gbG9zcyBvZgpzaWduaWZpY2Fu Y2UuDQpDb3JyZXNwb25kaW5nIGNvZGUgc2VlCmh0dHBzOi8vZ2l0aHViLmNvbS9wb3N0Z3Jlcy9w b3N0Z3Jlcy9ibG9iLzQ5NDA3ZGMzMmEyOTMxNTUwZTRmZjFkZWEzMTRiNmEyNWFmZGZjMzUvc3Jj L2JhY2tlbmQvdXRpbHMvYWR0L2Zsb2F0LmMjTDM0MDEuDQoNCkNvbnNpZGVyIHRoZSBmb2xsb3dp bmc6DQpkcm9wIHRhYmxlIGlmIGV4aXN0cyB0ZXN0Ow0KY3JlYXRlIHRhYmxlIHRlc3QoeSBudW1l cmljLCB4IG51bWVyaWMpOw0KaW5zZXJ0IGludG8gdGVzdCB2YWx1ZXMNCigxLCAzKSwNCigyLCAz LjBlKzIyKSwNCigzLCAtMyk7DQpzZWxlY3QgY292YXJfcG9wKHksIHgpIGZyb20gdGVzdDsNCiAg ICAgY292YXJfcG9wDQotLS0tLS0tLS0tLS0tLS0tLS0tDQogNjk5MDUwLjY2NjY2NjY2NjYNCigx IHJvdykNCg0KdHJ1bmNhdGUgdGFibGUgdGVzdDsNCg0KaW5zZXJ0IGludG8gdGVzdCB2YWx1ZXMN CigxLCAzKSwNCigzLCAtMyksDQooMiwgMy4wZSsyMik7DQpzZWxlY3QgY292YXJfcG9wKHksIHgp IGZyb20gdGVzdDsNCiBjb3Zhcl9wb3ANCi0tLS0tLS0tLS0tDQogICAgICAgIC0yDQooMSByb3cp DQoNCnRydW5jYXRlIHRhYmxlIHRlc3Q7DQoNCmluc2VydCBpbnRvIHRlc3QgdmFsdWVzDQooMiwg My4wZSsyMiksDQooMywgLTMpLA0KKDEsIDMpOw0Kc2VsZWN0IGNvdmFyX3BvcCh5LCB4KSBmcm9t IHRlc3Q7DQogICAgIGNvdmFyX3BvcA0KLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiAtNjk5MDUwLjY2 NjY2NjY2NjYNCigxIHJvdykNCg0KVGhlIGV4cGVjdGVkIHJlc3VsdCBpcyAtMi4gDQpUaGUgcmVz dWx0IGRlcGVuZHMgb24gdGhlIG9yZGVyIG9mIHZhbHVlcyBhbHRob3VnaCBpdCBzaG91bGRuJ3Qu IFRoaXMKaGFwcGVucyBiZWNhdXNlIG9wZXJhdGlvbnMgd2l0aCAzLjBlKzIyIGxlYWQgdG8gdGhl IGxvc3Mgb2YgcHJlY2lzaW9uIHNpbmNlCnRoZSB0eXBlIGNhbiBob2xkIG9ubHkgMTUgZGVjaW1h bCBkaWdpdHMgcHJlY2lzaW9uLiANCkV2ZW4gaWYgdGhlIGZ1bmN0aW9ucyBkZWZpbmVkIGZvciBk b3VibGUgcHJlY2lzaW9uIHR5cGUgSSB3b3VsZCBleHBlY3QKUG9zdGdyZXMgZWl0aGVyIHRvIHJl cG9ydCBhbiBlcnJvciBvciB0byByZXR1cm4gdGhlIGNvcnJlY3QgcmVzdWx0LgoK --===============5991097108770957550==--