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 1oRyPT-0000wK-8D for pgsql-committers@arkaria.postgresql.org; Sat, 27 Aug 2022 16:11:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oRyPR-0008IO-Vu for pgsql-committers@arkaria.postgresql.org; Sat, 27 Aug 2022 16:11:45 +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 1oRyPR-0008IF-PI for pgsql-committers@lists.postgresql.org; Sat, 27 Aug 2022 16:11:45 +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 1oRyPP-0003Qt-E1 for pgsql-committers@lists.postgresql.org; Sat, 27 Aug 2022 16:11:44 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oRyPO-00037n-Hu for pgsql-committers@lists.postgresql.org; Sat, 27 Aug 2022 16:11:42 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1oRyPN-0009tN-5I for pgsql-committers@lists.postgresql.org; Sat, 27 Aug 2022 16:11:41 +0000 Content-Type: multipart/mixed; boundary="===============2932020065471336802==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Repair rare failure of MULTIEXPR_SUBLINK subplans in inherited u X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sat, 27 Aug 2022 16:11:41 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2932020065471336802== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 UmVwYWlyIHJhcmUgZmFpbHVyZSBvZiBNVUxUSUVYUFJfU1VCTElOSyBzdWJwbGFucyBpbiBpbmhl cml0ZWQgdXBkYXRlcy4KClByaW9yIHRvIHYxNCwgaWYgd2UgaGF2ZSBhIE1VTFRJRVhQUiBTdWJQ bGFuICh0aGF0IGlzLCB1c2Ugb2YgdGhlIHN5bnRheApVUERBVEUgLi4uIFNFVCAoYzEsIC4uLikg PSAoU0VMRUNUIC4uLikpIGluIGFuIFVQREFURSB3aXRoIGFuIGluaGVyaXRlZApvciBwYXJ0aXRp b25lZCB0YXJnZXQgdGFibGUsIGluaGVyaXRhbmNlX3BsYW5uZXIoKSB3aWxsIGNsb25lIHRoZQp0 YXJnZXRsaXN0IGFuZCB0aGVyZWZvcmUgYWxzbyB0aGUgTVVMVElFWFBSIFN1YlBsYW4gYW5kIHRo ZSBQYXJhbSBub2RlcwpyZWZlcmVuY2luZyBpdCBmb3IgZWFjaCBjaGlsZCB0YXJnZXQgdGFibGUu ICBVcCB0byBub3csIHdlJ3ZlIGFsbG93ZWQKYWxsIHRoZSBjbG9uZXMgdG8gc2hhcmUgdGhlIHVu ZGVybHlpbmcgc3VicGxhbiBhcyB3ZWxsIGFzIHRoZSBvdXRwdXQKcGFyYW1ldGVyIElEcyAtLSB0 aGF0IGlzLCB0aGUgcnVudGltZSBQYXJhbUV4ZWNEYXRhIHNsb3RzLiAgVGhhdAp0ZWNobmlxdWUg aXMgYm9ycm93ZWQgZnJvbSB0aGUgZmFyIG9sZGVyIGNvZGUgdGhhdCBzdXBwb3J0cyBpbml0cGxh bnMsCmFuZCBpdCB3b3JrcyBva2F5IGluIHRoYXQgY2FzZSBiZWNhdXNlIHRoZSBjbG9uZWQgU3Vi UGxhbiBub2RlcyBhcmUKZXNzZW50aWFsbHkgaWRlbnRpY2FsLiAgU28gaXQgZG9lc24ndCBtYXR0 ZXIgd2hpY2ggb25lIG9mIHRoZSBjbG9uZXMKdGhlIHNoYXJlZCBQYXJhbUV4ZWNEYXRhLmV4ZWNQ bGFuIGZpZWxkIG1pZ2h0IHBvaW50IHRvLgoKSG93ZXZlciwgdGhpcyBmYWlscyB0byBob2xkIGZv ciBNVUxUSUVYUFIgU3ViUGxhbnMsIGJlY2F1c2UgdGhleSBjYW4KaGF2ZSBub25lbXB0eSAiYXJn cyIgbGlzdHMgKHZhbHVlcyB0byBiZSBwYXNzZWQgaW50byB0aGUgc3VicGxhbiksIGFuZAp0aG9z ZSBsaXN0cyBjb3VsZCBnZXQgbXV0YXRlZCB0byBkaWZmZXJlbnQgc3RhdGVzIGluIHRoZSB2YXJp b3VzIGNsb25lcy4KSW4gdGhlIHN1Ym1pdHRlZCByZXByb2R1Y2VyLCBhcyB3ZWxsIGFzIHRoZSB0 ZXN0IGNhc2UgYWRkZWQgaGVyZSwgb25lCmNsb25lIGNvbnRhaW5zIFZhcnMgd2l0aCB2YXJubyBP VVRFUl9WQVIgd2hlcmUgYW5vdGhlciBoYXMgSU5ORVJfVkFSLApiZWNhdXNlIHRoZSBjaGlsZCB0 YWJsZXMgYXJlIHJlc3BlY3RpdmVseSBvbiB0aGUgb3V0ZXIgb3IgaW5uZXIgc2lkZSBvZgp0aGUg am9pbi4gIFNoYXJpbmcgdGhlIGV4ZWNQbGFuIHBvaW50ZXIgY2FuIHJlc3VsdCBpbiB0cnlpbmcg dG8gZXZhbHVhdGUKYW4gYXJncyBsaXN0IHRoYXQgZG9lc24ndCBtYXRjaCB0aGUgbG9jYWwgZXhl Y3V0aW9uIHN0YXRlLCB3aXRoIG1heWhlbQplbnN1aW5nLiAgVGhlIHJlc3VsdCBvZnRlbiBpcyB0 byB0cmlnZ2VyIGNvbnNpc3RlbmN5IGNoZWNrcyBpbiB0aGUKZXhlY3V0b3IsIGJ1dCBJIGJlbGll dmUgdGhpcyBjb3VsZCBlbmQgaW4gYSBjcmFzaCBvciBpbmNvcnJlY3QgdXBkYXRlcy4KClRvIGZp eCwgYXNzaWduIG5ldyBQYXJhbSBJRHMgdG8gZWFjaCBvZiB0aGUgY2xvbmVkIFN1YlBsYW5zLCBz byB0aGF0CnRoZXkgZG9uJ3Qgc2hhcmUgUGFyYW1FeGVjRGF0YSBzbG90cyBhdCBydW50aW1lLiAg SXQgc3RpbGwgc2VlbXMgZmluZQpmb3IgdGhlIGNsb25lcyB0byBzaGFyZSB0aGUgdW5kZXJseWlu ZyBzdWJwbGFuLCBhbmQgZXh0cmEgUGFyYW1FeGVjRGF0YQpzbG90cyBhcmUgY2hlYXAgZW5vdWdo IHRoYXQgdGhpcyBmaXggc2hvdWxkbid0IGNvc3QgbXVjaC4KClRoaXMgaGFzIGJlZW4gYnVzdGVk IHNpbmNlIHdlIGludmVudGVkIE1VTFRJRVhQUiBTdWJQbGFucyBpbiA5LjUuClByb2JhYmx5IHRo ZSBsYWNrIG9mIHByZXZpb3VzIHJlcG9ydHMgaXMgYmVjYXVzZSBxdWVyeSBwbGFucyBpbiB3aGlj aAp0aGUgZGlmZmVyZW50IGNsb25lcyBvZiBhIE1VTFRJRVhQUiBtdXRhdGUgdG8gZWZmZWN0aXZl bHktZGlmZmVyZW50CnN0YXRlcyBhcmUgcHJldHR5IHJhcmUuICBUaGVyZSdzIG5vIGlzc3VlIGlu IHYxNCBhbmQgbGF0ZXIsIGJlY2F1c2UKd2l0aG91dCBpbmhlcml0YW5jZV9wbGFubmVyKCkgdGhl cmUncyBuZXZlciBhIHJlYXNvbiB0byBjbG9uZQpNVUxUSUVYUFIgU3ViUGxhbnMuCgpQZXIgYnVn ICMxNzU5NiBmcm9tIEFuZHJlIExpbi4gIFBhdGNoIHYxMC12MTMgb25seS4KCkRpc2N1c3Npb246 IGh0dHBzOi8vcG9zdGdyLmVzL20vMTc1OTYtYzUzNTdmNjE0MjdhODFkY0Bwb3N0Z3Jlc3FsLm9y ZwoKQnJhbmNoCi0tLS0tLQpSRUxfMTJfU1RBQkxFCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9n aXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi9mOGU3MGNmYjhmZDQ4ZTg1N2Q4OGY3Y2Ex MzA1ZmY2OWIyNWYxM2EzCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2Vu ZC9leGVjdXRvci9ub2RlU3VicGxhbi5jICAgICB8IDE1ICsrKysrKwpzcmMvYmFja2VuZC9vcHRp bWl6ZXIvcGxhbi9wbGFubmVyLmMgICB8ICA0ICsrCnNyYy9iYWNrZW5kL29wdGltaXplci9wbGFu L3N1YnNlbGVjdC5jIHwgOTUgKysrKysrKysrKysrKysrKysrKysrKysrKysrKysrKysrKwpzcmMv aW5jbHVkZS9vcHRpbWl6ZXIvc3Vic2VsZWN0LmggICAgICB8ICAxICsKc3JjL3Rlc3QvcmVncmVz cy9leHBlY3RlZC9pbmhlcml0Lm91dCAgfCA0OSArKysrKysrKysrKysrKysrKysKc3JjL3Rlc3Qv cmVncmVzcy9zcWwvaW5oZXJpdC5zcWwgICAgICAgfCAyMCArKysrKysrCjYgZmlsZXMgY2hhbmdl ZCwgMTg0IGluc2VydGlvbnMoKykKCg== --===============2932020065471336802==--