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 1riB6K-00FYmP-Ao for pgsql-bugs@arkaria.postgresql.org; Thu, 07 Mar 2024 10:35:49 +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 1riB6I-004CJg-T8 for pgsql-bugs@arkaria.postgresql.org; Thu, 07 Mar 2024 10:35:47 +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 1riAu6-0046Fn-Ho for pgsql-bugs@lists.postgresql.org; Thu, 07 Mar 2024 10:23:11 +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 1riAu3-003FE5-II for pgsql-bugs@lists.postgresql.org; Thu, 07 Mar 2024 10:23: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=aDxNBiHXpIEOrPgaiZrMPSSpPFE7ELT+wlYN1/uyHV4=; b=ipfiK27Tu3ZgHk7skn8jYpBWch ZV+RpKC4Z/iebUjJG50oEQv+KIH6Pzn5ph4wo2mMRU+NWnTivveg+ytpTLucXjmLXAt7QVO0Nnd+k UM/qlk4/Q1C95ML2ZGHcxs7QVU8Dfl3agUEiBGgvDQA44McwnupjiYGJFemWii+8hN8oUFYcvqTcP m4jYepF9DmAu7tL3jki0ECdbpv/u0xUlP0w87phqvi6tlAq2CiWxnIKCsAdVCG2TjXKXlLFMKkijL foZm7BJCmse/Sj69zXJ8QzlLCUzF9/hm21PbOULSwn4fTjjatgjh22P8ZG7YGfEud/9bn9l24Vuy9 7siVmv/A==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1riAu1-0081vH-JD for pgsql-bugs@lists.postgresql.org; Thu, 07 Mar 2024 10:23:06 +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 1riAty-004VcW-4Q for pgsql-bugs@lists.postgresql.org; Thu, 07 Mar 2024 10:23:02 +0000 Content-Type: multipart/mixed; boundary="===============6669958899213942329==" MIME-Version: 1.0 Subject: BUG #18381: Invalid query generated by postgres_fdw with UNION ALL and ORDER BY To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: michal@kleczek.org Reply-To: michal@kleczek.org, pgsql-bugs@lists.postgresql.org Date: Thu, 07 Mar 2024 10:22:33 +0000 Message-ID: <18381-137456acd168bf93@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 --===============6669958899213942329== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODM4MQpMb2dnZWQgYnk6ICAgICAgICAgIE1pY2hhbCBLbGVjemVrCkVt YWlsIGFkZHJlc3M6ICAgICAgbWljaGFsQGtsZWN6ZWsub3JnClBvc3RncmVTUUwgdmVyc2lvbjog MTYuMgpPcGVyYXRpbmcgc3lzdGVtOiAgIExpbnV4CkRlc2NyaXB0aW9uOiAgICAgICAgCgpUaGUg Zm9sbG93aW5nIHF1ZXJ5Og0KDQpTRUxFQ1QgKiBGUk9NICgNCiAgU0VMRUNUIDIwMjMgQVMgeWVh ciwgKiBGUk9NIHJlbW90ZV90YWJsZV8xDQogIFVOSU9OIEFMTA0KICBTRUxFQ1QgMjAyMiBBUyB5 ZWFyLCAqIEZST00gcmVtb3RlX3RhYmxlXzINCikNCk9SREVSIEJZIHllYXIgREVTQzsNCg0KeWll bGRzIHRoZSBmb2xsb3dpbmcgcmVtb3RlIHF1ZXJ5Og0KDQpTRUxFQ1QgW2NvbHVtbnNdIEZST00g cmVtb3RlX3RhYmxlXzEgT1JERVIgQlkgMjAyMyBERVNDDQoNCmFuZCBzdWJzZXF1ZW50bHkgZmFp bHMgcmVtb3RlIGV4ZWN1dGlvbi4NCg0KDQpOb3QgcmVhbGx5IHN1cmUgd2hlcmUgdGhlIHByb2Js ZW0gaXMgLSB0aGUgcGxhbm5lciBvciBwb3N0Z3Jlc19mZHcuDQpJIGd1ZXNzIGl0IGlzIHBvc3Rn cmVzX2ZkdyBub3QgZmlsdGVyaW5nIG91dCBvcmRlcmluZyBrZXlzLg0KDQpUaGlzIGZpbHRlcmlu ZyB3b3VsZCBhbHNvIGJlIHByZXR0eSB1c2VmdWwgaW4gdGhlIGZvbGxvd2luZyBzY2VuYXJpbyAo d2hpY2gKaXMgYWxzbyB3aHkgSSB3ZW50IHRocm91Z2ggVU5JT04gQUxMIHJvdXRlIGFuZCBkaXNj b3ZlcmVkIHRoaXMgaXNzdWUpOg0KDQpJIGhhdmUgYSB0YWJsZSBwYXJ0aXRpb25lZCBieSB5ZWFy LCBwYXJ0aXRpb25zIGFyZSByZW1vdGUgdGFibGVzLg0KT24gcmVtb3RlIHNlcnZlcnMgSSBoYXZl IGEgR0lTVCBpbmRleCB0aGF0IGRvZXMgbm90IHN1cHBvcnQgb3JkZXJpbmcgKFsxXSkKc28gSSB3 b3VsZCBsaWtlIHRvIGF2b2lkIHNlbmRpbmcgT1JERVIgQlkgeWVhciB0byByZW1vdGUgc2VydmVy cy4NCklkZWFsbHkgcmVkdW5kYW50IG9yZGVyaW5nIHNob3VsZCBiZSBmaWx0ZXJlZCBvdXQuDQoN ClsxXQpodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9tZXNzYWdlLWlkL0IyQUMxM0Y5LTY2NTUt NEUyNy1CRkQzLTA2ODg0NEU1REM5MSU0MGtsZWN6ZWsub3JnCgo= --===============6669958899213942329==--