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 1pOkdr-0002RG-JV for pgsql-committers@arkaria.postgresql.org; Sun, 05 Feb 2023 19:25:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pOkdo-0007oz-H4 for pgsql-committers@arkaria.postgresql.org; Sun, 05 Feb 2023 19:25:32 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pOkdo-0007op-9y for pgsql-committers@lists.postgresql.org; Sun, 05 Feb 2023 19:25:32 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pOkdk-0007Je-9Q for pgsql-committers@lists.postgresql.org; Sun, 05 Feb 2023 19:25:30 +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 1pOkdi-0005nL-By for pgsql-committers@lists.postgresql.org; Sun, 05 Feb 2023 19:25:26 +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 1pOkdf-001kX6-Tp for pgsql-committers@lists.postgresql.org; Sun, 05 Feb 2023 19:25:25 +0000 Content-Type: multipart/mixed; boundary="===============9004086964035396169==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix over-optimistic updating of info about commutable outer join X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sun, 05 Feb 2023 19:25:25 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============9004086964035396169== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IG92ZXItb3B0aW1pc3RpYyB1cGRhdGluZyBvZiBpbmZvIGFib3V0IGNvbW11dGFibGUgb3V0 ZXIgam9pbnMuCgptYWtlX291dGVyam9pbmluZm8gd2FzIHNldCB1cCB0byB1cGRhdGUgU3BlY2lh bEpvaW5JbmZvJ3MKY29tbXV0ZV9iZWxvdywgY29tbXV0ZV9hYm92ZV9sLCBjb21tdXRlX2Fib3Zl X3IgZmllbGRzIGFzIHNvb24gYXMKaXQgZm91bmQgYSBwYWlyIG9mIG91dGVyIGpvaW5zIHRoYXQg bG9vayBsaWtlIHRoZXkgY2FuIGNvbW11dGUuCkhvd2V2ZXIsIHRoaXMgZGVjaXNpb24gY291bGQg YmUgbmVnYXRlZCBsYXRlciBpbiB0aGUgc2FtZSBsb29wIGR1ZQp0byBmaW5kaW5nIGFuIGludGVy bWVkaWF0ZSBvdXRlciBqb2luIHRoYXQgcHJldmVudHMgY29tbXV0YXRpb24uClRoYXQgbGVmdCB1 cyB3aXRoIGNvbW11dGVfeHh4IGZpZWxkcyB0aGF0IHdlcmUgY29udHJhZGljdG9yeSB0byB0aGUK am9pbiBvcmRlciByZXN0cmljdGlvbnMgZXhwcmVzc2VkIGluIG1pbl9sZWZ0aGFuZC9taW5fcmln aHRoYW5kLgpUaGUgbGF0dGVyIGZpZWxkcyB3b3VsZCBrZWVwIHVzIGZyb20gYWN0dWFsbHkgY2hv b3NpbmcgYSBiYWQgam9pbgpvcmRlcjsgYnV0IHRoZSBpbmNvbnNpc3RlbnQgY29tbXV0ZV94eHgg ZmllbGRzIGNvdWxkIGJvbGxpeCBkZXRhaWxzCnN1Y2ggYXMgdGhlIHZhcm51bGxpbmdyZWxzIHZh bHVlcyBjcmVhdGVkIGZvciBpbnRlcm1lZGlhdGUgam9pbgpyZWxhdGlvbiB0YXJnZXRsaXN0cywg ZW5kaW5nIGluIGFuIGFzc2VydGlvbiBmYWlsdXJlIGluIHNldHJlZnMuYy4KClRvIGZpeCwgd2Fp dCB0aWxsIHRoZSBlbmQgb2YgbWFrZV9vdXRlcmpvaW5pbmZvIHdoZXJlIHdlIGhhdmUKYWNjdXJh dGUgdmFsdWVzIGZvciBtaW5fbGVmdGhhbmQvbWluX3JpZ2h0aGFuZCwgYW5kIHRoZW4gaW5zZXJ0 Cm9ubHkgcmVsaWRzIG5vdCBwcmVzZW50IGluIHRob3NlIHNldHMgaW50byB0aGUgY29tbXV0ZV94 eHggZmllbGRzLgoKUGVyIFNRTFNtaXRoIHRlc3RpbmcgYnkgUm9iaW5zIFRoYXJha2FuLiAgTm90 ZSB0aGF0IHdoaWxlIFJvYmlucwpiaXNlY3RlZCB0aGUgZmFpbHVyZSB0byBjb21taXQgYjQ0OGYx YzhkLCBpdCdzIHJlYWxseSB0aGUgZmF1bHQgb2YKMjQ4OWQ3NmM0LiAgVGhlIG91dGVyam9pbl9k ZWxheWVkIGxvZ2ljIHJlbW92ZWQgaW4gdGhlIGxhdGVyIGNvbW1pdAp3YXMga2VlcGluZyB1cyBm cm9tIGRlY2lkaW5nIHRoYXQgdHJvdWJsZXNvbWUgam9pbiBwYWlycyBjb21tdXRlLAphdCBsZWFz dCBpbiB0aGUgc3BlY2lmaWMgZXhhbXBsZSBzZWVuIGhlcmUuCgpEaXNjdXNzaW9uOiBodHRwczov L3Bvc3Rnci5lcy9tL0NBRVA0bkF5QU9SZ0U4S19SSFNtdldiRTlVYUNoaGpiRUwxUnJEVTNuZWVQ d3dSVUI9QUBtYWlsLmdtYWlsLmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0t LS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmL2IyZDBlMTNhMGE0 YzMxMTY3ZDAxZTk4NzFmOTA3MDYwYzgwYjhmYWUKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0t LS0tCnNyYy9iYWNrZW5kL29wdGltaXplci9wbGFuL2luaXRzcGxhbi5jIHwgNzQgKysrKysrKysr KysrKysrKysrKysrKysrKystLS0tLS0tLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2pvaW4u b3V0ICAgICB8IDMwICsrKysrKysrKysrKysrCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2pvaW4uc3Fs ICAgICAgICAgIHwgMTEgKysrKysKMyBmaWxlcyBjaGFuZ2VkLCA5OSBpbnNlcnRpb25zKCspLCAx NiBkZWxldGlvbnMoLSkKCg== --===============9004086964035396169==--