Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uOHLB-000ak5-D3 for pgsql-bugs@arkaria.postgresql.org; Sun, 08 Jun 2025 14:49:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uOHL8-001aio-4C for pgsql-bugs@arkaria.postgresql.org; Sun, 08 Jun 2025 14:49:38 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uOHB0-001Yby-Ee for pgsql-bugs@lists.postgresql.org; Sun, 08 Jun 2025 14:39:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uOHAz-000vAR-02 for pgsql-bugs@lists.postgresql.org; Sun, 08 Jun 2025 14:39:10 +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=FY35sl6uubs+RbwtmHFs4pWMPbJOf3I6HP3lAFUoeyE=; b=OP99COuRDJlVQ4qw/i+LdI4iqy LIZZ9cFQ3AZr2GgHO6xzDvuej7qOZwld0aynWqUsVgqx1aV7QHCYi79WXiwNMGp3RHgRMGQlmabnK Q6NYFeCZR7x3r3NpTYkGZaKh1a5PofuHPrCA5Z8HfUHz4XVYx7znhXNpFgQdTC2v5tP12S8NJ9ta7 OijZ8U9llvHjB2wQNpf/ESsVGruJ90B8N3e8s69TpR+td6n8Icishoae4Y9hLBK92N9U/W2VIUIlM r+seBaCrL3DTjNF+zwRtk+MOYwGXk6I1jg3uta4NSrNFNaabsuI5cG5R105PsUyAEzf8KP8QHGqzE KAUT04mA==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uOHAu-0034Tr-9H for pgsql-bugs@lists.postgresql.org; Sun, 08 Jun 2025 14:39:08 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1uOHAt-00Fcds-1s for pgsql-bugs@lists.postgresql.org; Sun, 08 Jun 2025 14:39:03 +0000 Content-Type: multipart/mixed; boundary="===============3727988015403066738==" MIME-Version: 1.0 Subject: BUG #18951: Precision loss in inner join while using SUM aggregate function To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: bingyanli@email.ncu.edu.cn Reply-To: bingyanli@email.ncu.edu.cn, pgsql-bugs@lists.postgresql.org Date: Sun, 08 Jun 2025 14:38:55 +0000 Message-ID: <18951-3092d80beab3d2ef@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 --===============3727988015403066738== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODk1MQpMb2dnZWQgYnk6ICAgICAgICAgIGJpbmd5YW4gbGkKRW1haWwg YWRkcmVzczogICAgICBiaW5neWFubGlAZW1haWwubmN1LmVkdS5jbgpQb3N0Z3JlU1FMIHZlcnNp b246IDE3LjQKT3BlcmF0aW5nIHN5c3RlbTogICB1YnVudHUgMjIuMDQKRGVzY3JpcHRpb246ICAg ICAgICAKCkRhdGFiYXNlIHZlcnNpb246IDE3LjQgKERlYmlhbiAxNy40LTEucGdkZzEyMCsyKQpE Uk9QIFRBQkxFIHQwLCB0MTsKQ1JFQVRFIFVOTE9HR0VEIFRBQkxFIHQwIChjMCBib29sZWFuLCBj MSBkb3VibGUgcHJlY2lzaW9uLCBDT05TVFJBSU5UCnQwX3BrZXkgUFJJTUFSWSBLRVkgKGMxKSk7 CkNSRUFURSBUQUJMRSB0MSAoYzAgbnVtZXJpYyk7CklOU0VSVCBJTlRPIHQwIChjMCwgYzEpIFZB TFVFUyhmYWxzZSwgMTU2MTYwMTEyKSwgKGZhbHNlLCAwLjc4OTgzNDMpOwpJTlNFUlQgSU5UTyB0 MSAoYzApIFZBTFVFUygwLjA5NjYyMDkzMzI3NTM5NTQ1KSwKKDAuMDYyMjE5Mzc1ODc3ODU0MDkp LCgwLjYyNTQ1MTkzMzA2NjIzNjcpOwotLSBqdWRnZW1lbnQ6IHMxID0gczIgKyBzMywgSG93ZXZl ciwgczIgaXMgbm90IGNvcnJlY3RseSBjb21wdXRlZApTRUxFQ1QgU1VNKHQwLmMxKSBBUyBzMSBG Uk9NIE9OTFkgdDAgSU5ORVIgSk9JTiBPTkxZIHQxIE9OIHQwLmMxICE9IHQxLmMwCkdST1VQIEJZ IHQwLmMwOwogICAgICAgICBzMQotLS0tLS0tLS0tLS0tLS0tLS0tLQogNDY4NDgwMzM4LjM2OTUw Mjk2CigxIHJvdykKU0VMRUNUIFNVTSh0MC5jMSkgQVMgczIgRlJPTSBPTkxZIHQwIElOTkVSIEpP SU4gT05MWSB0MSBPTiB0MC5jMSA+IHQxLmMwCkdST1VQIEJZIHQwLmMwOwogICAgICAgIHMyCi0t LS0tLS0tLS0tLS0tLS0tLS0KIDQ2ODQ4MDMzOC4zNjk1MDI5CigxIHJvdykKU0VMRUNUIFNVTSh0 MC5jMSkgQVMgczMgRlJPTSBPTkxZIHQwIElOTkVSIEpPSU4gT05MWSB0MSBPTiB0MC5jMSA8IHQx LmMwCkdST1VQIEJZIHQwLmMwOwogczMKLS0tLQooMCByb3dzKQotLSBmdXJ0aGVyIGFuYWx5c2lz OiBzMiBpcyBub3QgY29ycmVjdGx5IGNvbXB1dGVkLCBpdCBzaG91bGQgYmUKNDY4NDgwMzM4LjM2 OTUwMjk2CmRhdGFiYXNlNzY9IyBTRUxFQ1QgdDAuYzEgQVMgczIgRlJPTSB0MCBJTk5FUiBKT0lO IHQxIE9OIHQwLmMxID4gdDEuYzA7CiAgICBzMgotLS0tLS0tLS0tLQogMC43ODk4MzQzCiAxNTYx NjAxMTIKIDAuNzg5ODM0MwogMTU2MTYwMTEyCiAwLjc4OTgzNDMKIDE1NjE2MDExMgooNiByb3dz KQoK --===============3727988015403066738==--