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 1t8coO-0059EC-PC for pgsql-bugs@arkaria.postgresql.org; Wed, 06 Nov 2024 09:58:52 +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 1t8coL-004scz-CD for pgsql-bugs@arkaria.postgresql.org; Wed, 06 Nov 2024 09:58:49 +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 1t8bre-004btj-05 for pgsql-bugs@lists.postgresql.org; Wed, 06 Nov 2024 08:58:10 +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.94.2) (envelope-from ) id 1t8brZ-000TZT-Fq for pgsql-bugs@lists.postgresql.org; Wed, 06 Nov 2024 08:58: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=Z57fVwKg8Xrnbq3EBJ9/sfiskkDDtLrXoFlIed0jlv4=; b=DE3nE7FJjVkWRE9SQzjyKO4p2v DTa3iSc7h8nBKBpkYnjPqOutCfSfY1opilfzPJANwmGwGuFSBwevXlJtITjJ6YVbgEiMFMOZrJwo9 5hJVzSN1QQojl3zWydc+vIuj93scwL93Fmtor0YVHCsubm4Lnh/Nsx3DDu4dpvrUVn5db3BZGnNBI YV+2GseficL32kttc6tOn8h6aIvEMl5I2k5uEaNBVv6QOWANorwikmSbC2n+mh5IVC360suIIsSW+ KUuEdgaQpTYHnyLkMlRZgOfLVxJ3f8eQSFbSoiBaDchAuNiR+l/GvEu9GwLPZDTY2jsr2UyW7/VxO F/F8WlGw==; 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 1t8brY-001KYu-5K for pgsql-bugs@lists.postgresql.org; Wed, 06 Nov 2024 08:58:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1t8brV-001USz-QU for pgsql-bugs@lists.postgresql.org; Wed, 06 Nov 2024 08:58:02 +0000 Content-Type: multipart/mixed; boundary="===============5292119867840781783==" MIME-Version: 1.0 Subject: BUG #18690: A count function returns wrong value when using FDW To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: aidar@donorbox.org Reply-To: aidar@donorbox.org, pgsql-bugs@lists.postgresql.org Date: Wed, 06 Nov 2024 08:57:20 +0000 Message-ID: <18690-cbb98b56ecb0b130@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 --===============5292119867840781783== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODY5MApMb2dnZWQgYnk6ICAgICAgICAgIEFpZGFyIFVsZGFub3YKRW1h aWwgYWRkcmVzczogICAgICBhaWRhckBkb25vcmJveC5vcmcKUG9zdGdyZVNRTCB2ZXJzaW9uOiAx Ni40Ck9wZXJhdGluZyBzeXN0ZW06ICAgVWJ1bnR1CkRlc2NyaXB0aW9uOiAgICAgICAgCgpNeSBm b2xsb3dpbmcgcXVlcnkgcmV0dXJucyBhIHNpbmdsZSBhdmVyYWdlX2RvbmF0aW9uX3VzZCB2YWx1 ZQ0KDQpgYGANCldJVEggICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICANCiAgICAgICAgdHJh bnNhY3Rpb25zIEFTICggU0VMRUNUICogRlJPTSB0cmFuc2FjdGlvbnNfZndkIFdIRVJFIG9yZ19p ZCA9IDEKKSwNCiAgICAgICAgcmVjdXJyaW5nX3BheW1lbnRzIEFTICggU0VMRUNUICogRlJPTSBy ZWN1cnJpbmdfcGF5bWVudHNfZndkIFdIRVJFCm9yZ19pZCA9IDEgKQ0KU0VMRUNUIEFWRyh0LnVz ZF9hbW91bnRfY2VudHMgLyAxMDApIEFTIGF2ZXJhZ2VfZG9uYXRpb25fdXNkDQpGUk9NIHRyYW5z YWN0aW9ucyB0IA0KSk9JTiByZWN1cnJpbmdfcGF5bWVudHMgciBPTiByLmlkID0gdC5yZWN1cnJp bmdfcGF5bWVudF9pZA0KV0hFUkUgdC5zdGF0dXMgPSAncGFpZCcgQU5EIHQuZGVsZXRlZF9hdCBJ UyBOVUxMIEFORCB0LmFtb3VudF9yZWZ1bmRlZF9jZW50cwo9IDANCmBgYA0KDQpCdXQgd2hlbiBJ IHdyYXAgaXQgdG8gYHNlbGVjdCBjb3VudCgqKSBmcm9tIChteV9xdWVyeSlgIGkgZ2V0IDI4OCBh cyBhCnJlc3VsdCwgYnV0IEkgZXhwZWN0IGl0IHRvIGJlIDEuDQoNCmBgYA0Kc2VsZWN0IGNvdW50 KCopDQpGUk9NICgNCldJVEggICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICANCiAgICAgICAg dHJhbnNhY3Rpb25zIEFTICggU0VMRUNUICogRlJPTSB0cmFuc2FjdGlvbnNfZndkIFdIRVJFIG9y Z19pZCA9IDEKKSwNCiAgICAgICAgcmVjdXJyaW5nX3BheW1lbnRzIEFTICggU0VMRUNUICogRlJP TSByZWN1cnJpbmdfcGF5bWVudHNfZndkIFdIRVJFCm9yZ19pZCA9IDEgKQ0KU0VMRUNUIEFWRyh0 LnVzZF9hbW91bnRfY2VudHMgLyAxMDApIEFTIGF2ZXJhZ2VfZG9uYXRpb25fdXNkDQpGUk9NIHRy YW5zYWN0aW9ucyB0IA0KSk9JTiByZWN1cnJpbmdfcGF5bWVudHMgciBPTiByLmlkID0gdC5yZWN1 cnJpbmdfcGF5bWVudF9pZA0KV0hFUkUgdC5zdGF0dXMgPSAncGFpZCcgQU5EIHQuZGVsZXRlZF9h dCBJUyBOVUxMIEFORCB0LmFtb3VudF9yZWZ1bmRlZF9jZW50cwo9IDANCik7DQpgYGAgDQoNCkkg dHJpZWQgdG8gY3JlYXRlIG1hdGVyaWFsaXplZCB2aWV3cyB0byBzZWUgaXQgdGhpcyBidWcgcmVs YXRlcyB0byB1c2luZyBGV0QKdGFibGVzLg0KDQpgYGANCkNSRUFURSBNQVRFUklBTElaRUQgVklF VyB0cmFuc2FjdGlvbnMgQVMNClNFTEVDVCAqIEZST00gdHJhbnNhY3Rpb25zX2Z3ZCBXSEVSRSBv cmdfaWQgPSAxOw0KDQpDUkVBVEUgTUFURVJJQUxJWkVEIFZJRVcgcmVjdXJyaW5nX3BheW1lbnRz IEFTDQpTRUxFQ1QgKiBGUk9NIHJlY3VycmluZ19wYXltZW50c19md2QgV0hFUkUgb3JnX2lkID0g MTsNCmBgYA0KDQpBbmQgaXQgd29ya2VkIHdlbGwgcmV0dXJuaW5nIG1lIDEgYXMgYSByZXN1bHQu DQoNCmBgYA0Kc2VsZWN0IGNvdW50KCopDQpGUk9NICgNCldJVEggICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAg ICAgICAgICAgICANCiAgICAgICAgdHJhbnNhY3Rpb25zIEFTICggU0VMRUNUICogRlJPTSB0cmFu c2FjdGlvbnMgV0hFUkUgb3JnX2lkID0gMSApLA0KICAgICAgICByZWN1cnJpbmdfcGF5bWVudHMg QVMgKCBTRUxFQ1QgKiBGUk9NIHJlY3VycmluZ19wYXltZW50cyBXSEVSRQpvcmdfaWQgPSAxICkN ClNFTEVDVCBBVkcodC51c2RfYW1vdW50X2NlbnRzIC8gMTAwKSBBUyBhdmVyYWdlX2RvbmF0aW9u X3VzZA0KRlJPTSB0cmFuc2FjdGlvbnMgdCANCkpPSU4gcmVjdXJyaW5nX3BheW1lbnRzIHIgT04g ci5pZCA9IHQucmVjdXJyaW5nX3BheW1lbnRfaWQNCldIRVJFIHQuc3RhdHVzID0gJ3BhaWQnIEFO RCB0LmRlbGV0ZWRfYXQgSVMgTlVMTCBBTkQgdC5hbW91bnRfcmVmdW5kZWRfY2VudHMKPSAwDQop Ow0KDQpgYGANCg0KTXkgT1MgYW5kIFBvc3RncmVzIHZlcnNpb24gKGhvc3RlZCBvbiBoZXJva3Up DQoNCmBgYA0KVXNlciA9PiBzZWxlY3QgdmVyc2lvbigpOw0KICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB2ZXJzaW9uICAgICAgIAog ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICANCi0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tDQogUG9zdGdyZVNRTCAxNi40IChVYnVudHUgMTYuNC0xLnBnZGcyMC4w NCsxKSBvbiB4ODZfNjQtcGMtbGludXgtZ251LApjb21waWxlZCBieSBnY2MgKFVidW50dSA5LjQu MC0xdWJ1bnR1MX4yMC4wNC4yKSA5LjQuMCwgNjQtYml0DQooMSByb3cpDQpgYGAKCg== --===============5292119867840781783==--