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 1ucMuc-00C92W-UT for pgsql-bugs@arkaria.postgresql.org; Thu, 17 Jul 2025 11:36:31 +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 1ucMua-001fmZ-Tv for pgsql-bugs@arkaria.postgresql.org; Thu, 17 Jul 2025 11:36:29 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ucMpV-001Sy1-7h for pgsql-bugs@lists.postgresql.org; Thu, 17 Jul 2025 11:31:13 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1ucMpQ-008F0c-1C for pgsql-bugs@lists.postgresql.org; Thu, 17 Jul 2025 11:31:13 +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=47Fsoh5rWGT/7QSPvv9MiCOjDD1kK8cYl0t6v7Vxy1A=; b=LPVOXVXq+dE8RA1xhNQ/K9g8p8 SBo9aKfQkOkyJFTpOJ3PR+5HEg5g/KvXOGKCqQ62kyY0k97K9zqdcdzze+9e+awupZVUAEtTg43Rj wQG9G6Ig3X5QlNA3+YNIwUsHeHlW8oJOWbtyHAa1yNQ8CTBl8e4rt4QuLGWnY2OkMTEcjMFHKNa5q yWNMW4Yvc6dZrfx1JrrHNbH2JK/prb6N5qAB7CeV3DcEqv+S1p1qve/Gw9vAgykiTBKU20vZJYiVB 4xFDQLQxJkv74JOIfDvTXmC2i3xipbc96xhAG/+INtAV9RJv42gciB+aIgo65kmdV9arkgNhcqdRq W3W4nmtw==; 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 1ucMpM-0042IZ-7r for pgsql-bugs@lists.postgresql.org; Thu, 17 Jul 2025 11:31:06 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1ucMpK-008Zfh-1C for pgsql-bugs@lists.postgresql.org; Thu, 17 Jul 2025 11:31:02 +0000 Content-Type: multipart/mixed; boundary="===============0002722178898317414==" MIME-Version: 1.0 Subject: BUG #18990: The results of equivalent queries are inconsistent (one returns 0, another returns -0) To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: jinhui-lai@foxmail.com Reply-To: jinhui-lai@foxmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 17 Jul 2025 11:30:40 +0000 Message-ID: <18990-a8cecf16fb02d7b0@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 --===============0002722178898317414== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODk5MApMb2dnZWQgYnk6ICAgICAgICAgIEppbmh1aQpFbWFpbCBhZGRy ZXNzOiAgICAgIGppbmh1aS1sYWlAZm94bWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAxNy41 Ck9wZXJhdGluZyBzeXN0ZW06ICAgdWJ1bnR1IDIyLjA0CkRlc2NyaXB0aW9uOiAgICAgICAgCgpI aSwgUEcgZGV2ZWxvcGVycwoKVGhhbmtzIGZvciByZWFkaW5nIG15IHJlcG9ydCEKCllvdSBjYW4g cmVwcm9kdWNlIGl0IGFzIGZvbGxvd3M6CgpTRUxFQ1QgRElTVElOQ1QgdDEuYzAgRlJPTSB0MSBX SEVSRSBOT1QgRVhJU1RTIChTRUxFQ1QgMSBGUk9NIHQwIFdIRVJFIHQxLmMwCj4gdDAuYzApClVO SU9OClNFTEVDVCBESVNUSU5DVCB0MS5jMCBGUk9NIHQxIFdIRVJFIEVYSVNUUyAoU0VMRUNUIDEg RlJPTSB0MCBXSEVSRSB0MS5jMCA+CnQwLmMwKTsKYzAKLS0tLQogLTQKIC0zCiAtMgogLTEKIC0w CiAgMQoKU0VMRUNUIERJU1RJTkNUIHQxLmMwIEZST00gdDE7CiBjMAotLS0tCiAgMAogLTIKIC0x CiAtNAogLTMKICAxCgpUaGFua3Mgb25jZSBhZ2FpbiBmb3IgeW91ciBwcmVjaW91cyB0aW1lLgoK QmVzdCByZWdhcmQsCgpKaW5odWkKCg== --===============0002722178898317414==--