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 1pzIrG-0004Qj-Fo for pgsql-committers@arkaria.postgresql.org; Wed, 17 May 2023 15:14:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pzIrF-0001FK-EF for pgsql-committers@arkaria.postgresql.org; Wed, 17 May 2023 15:14:29 +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 1pzIrF-0001F5-7J for pgsql-committers@lists.postgresql.org; Wed, 17 May 2023 15:14:29 +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 1pzIr3-000Mg0-M6 for pgsql-committers@lists.postgresql.org; Wed, 17 May 2023 15:14:28 +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 1pzIr3-0002M3-6k for pgsql-committers@lists.postgresql.org; Wed, 17 May 2023 15:14:17 +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 1pzIr2-000Lux-Tc for pgsql-committers@lists.postgresql.org; Wed, 17 May 2023 15:14:16 +0000 Content-Type: multipart/mixed; boundary="===============0718111855758610904==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix some issues with improper placement of outer join clauses. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 17 May 2023 15:14:16 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0718111855758610904== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IHNvbWUgaXNzdWVzIHdpdGggaW1wcm9wZXIgcGxhY2VtZW50IG9mIG91dGVyIGpvaW4gY2xh dXNlcy4KCkFmdGVyIGFwcGx5aW5nIG91dGVyLWpvaW4gaWRlbnRpdHkgMyBpbiB0aGUgZm9yd2Fy ZCBkaXJlY3Rpb24sCml0IHdhcyBwb3NzaWJsZSBmb3IgdGhlIHBsYW5uZXIgdG8gbWlzdGFrZW5s eSBhcHBseSBhIHF1YWwgY2xhdXNlCmZyb20gYWJvdmUgdGhlIHR3byBvdXRlciBqb2lucyBhdCB0 aGUgbm93LWxvd2VyIGpvaW4gbGV2ZWwuClRoaXMgY2FuIGdpdmUgdGhlIHdyb25nIGFuc3dlciwg c2luY2UgYSB2YWx1ZSB0aGF0IHdvdWxkIGdldCBudWxsZWQKYnkgdGhlIG5vdy11cHBlciBqb2lu IG1pZ2h0IG5vdCB5ZXQgYmUgbnVsbC4KClRvIGZpeCwgd2hlbiB3ZSBwZXJmb3JtIHN1Y2ggYSB0 cmFuc2Zvcm1hdGlvbiwgY29uc2lkZXIgdGhhdCB0aGUKbm93LWxvd2VyIGpvaW4gaGFzbid0IHJl YWxseSBjb21wbGV0ZWQgdGhlIG91dGVyIGpvaW4gaXQncyBub21pbmFsbHkKcmVzcG9uc2libGUg Zm9yIGFuZCB0aHVzIGl0cyByZWxpZCBzZXQgc2hvdWxkIG5vdCBpbmNsdWRlIHRoYXQgT0oncwpy ZWxpZCAobm9yIHNob3VsZCBpdHMgb3V0cHV0IFZhcnMgaGF2ZSB0aGF0IG51bGxpbmdyZWwgYml0 IHNldCkuCkluc3RlYWQgd2UgYWRkIHRob3NlIGJpdHMgd2hlbiB0aGUgbm93LXVwcGVyIGpvaW4g aXMgcGVyZm9ybWVkLgpUaGUgZXhpc3RpbmcgcnVsZXMgZm9yIHF1YWwgcGxhY2VtZW50IHRoZW4g c3VmZmljZSB0byBwcmV2ZW50CmhpZ2hlciBxdWFsIGNsYXVzZXMgZnJvbSBkcm9wcGluZyBiZWxv dyB0aGUgbm93LXVwcGVyIGpvaW4uClRoZXJlIGFyZSBhIGZldyBjb21wbGljYXRpb25zIGZyb20g bmVlZGluZyB0byBjb25zaWRlciB0cmFuc2l0aXZlCmNsb3N1cmVzIGluIGNhc2UgbXVsdGlwbGUg cHVzaGRvd25zIGhhdmUgaGFwcGVuZWQsIGJ1dCBhbGwgaW4gYWxsCml0J3Mgbm90IGEgdmVyeSBj b21wbGV4IHBhdGNoLgoKVGhpcyBpcyBhbGwgbmV3IGxvZ2ljIChmcm9tIDI0ODlkNzZjNCkgc28g bm8gbmVlZCB0byBiYWNrLXBhdGNoLgpUaGUgYWRkZWQgdGVzdCBjYXNlcyBhbGwgaGF2ZSB0aGUg c2FtZSByZXN1bHRzIGFzIGluIHYxNS4KClRvbSBMYW5lIGFuZCBSaWNoYXJkIEd1bwoKRGlzY3Vz c2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8wYjgxOTIzMi00YjUwLWYyNDUtMWM3ZC1jOGM2MWJm NDE4MjdAcG9zdGdyZXNwcm8ucnUKCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0t LS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi85ZGY4ZjkwM2ViNjc1 OGJlNWExOWU2NmNkZjc3ZTkyMmU5MzI5YzMxCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0t LQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvUkVBRE1FICAgICAgICAgICAgICB8ICAyMSArKysrKwpz cmMvYmFja2VuZC9vcHRpbWl6ZXIvcGF0aC9jb3N0c2l6ZS5jICAgICB8ICAgNiArLQpzcmMvYmFj a2VuZC9vcHRpbWl6ZXIvcGF0aC9lcXVpdmNsYXNzLmMgICB8ICAyMSArKystLQpzcmMvYmFja2Vu ZC9vcHRpbWl6ZXIvcGF0aC9pbmR4cGF0aC5jICAgICB8ICAgMiArLQpzcmMvYmFja2VuZC9vcHRp bWl6ZXIvcGF0aC9qb2lucmVscy5jICAgICB8IDEyMyArKysrKysrKysrKysrKysrKysrKysrKy0t CnNyYy9iYWNrZW5kL29wdGltaXplci9wbGFuL2FuYWx5emVqb2lucy5jIHwgIDE2ICsrLS0Kc3Jj L2JhY2tlbmQvb3B0aW1pemVyL3BsYW4vaW5pdHNwbGFuLmMgICAgfCAgNjAgKysrKysrLS0tLS0t LQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvdXRpbC9vcmNsYXVzZXMuYyAgICB8ICAgMyArLQpzcmMv YmFja2VuZC9vcHRpbWl6ZXIvdXRpbC9yZWxub2RlLmMgICAgICB8ICA3MSArKysrKysrKysrKy0t LS0Kc3JjL2luY2x1ZGUvbm9kZXMvcGF0aG5vZGVzLmggICAgICAgICAgICAgfCAgMTcgKystLQpz cmMvaW5jbHVkZS9vcHRpbWl6ZXIvcGF0aG5vZGUuaCAgICAgICAgICB8ICAgMSArCnNyYy9pbmNs dWRlL29wdGltaXplci9wYXRocy5oICAgICAgICAgICAgIHwgICA1ICstCnNyYy90ZXN0L3JlZ3Jl c3MvZXhwZWN0ZWQvam9pbi5vdXQgICAgICAgIHwgMTQzICsrKysrKysrKysrKysrKysrKysrKysr KysrKysrKwpzcmMvdGVzdC9yZWdyZXNzL3NxbC9qb2luLnNxbCAgICAgICAgICAgICB8ICA0NyAr KysrKysrKysrCjE0IGZpbGVzIGNoYW5nZWQsIDQ1MCBpbnNlcnRpb25zKCspLCA4NiBkZWxldGlv bnMoLSkKCg== --===============0718111855758610904==--