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 1pMZdu-0001eT-JW for pgsql-committers@arkaria.postgresql.org; Mon, 30 Jan 2023 19:16:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pMZdt-0002vH-Cr for pgsql-committers@arkaria.postgresql.org; Mon, 30 Jan 2023 19:16:37 +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 1pMZax-0001D5-Gs for pgsql-committers@lists.postgresql.org; Mon, 30 Jan 2023 19:13:35 +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 1pMZas-00048v-KS for pgsql-committers@lists.postgresql.org; Mon, 30 Jan 2023 19:13:34 +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 1pMZaq-0001kO-RF for pgsql-committers@lists.postgresql.org; Mon, 30 Jan 2023 19:13:28 +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 1pMZao-000l3w-P9 for pgsql-committers@lists.postgresql.org; Mon, 30 Jan 2023 19:13:28 +0000 Content-Type: multipart/mixed; boundary="===============1870523271885284958==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Make Vars be outer-join-aware. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 30 Jan 2023 19:13:28 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1870523271885284958== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 TWFrZSBWYXJzIGJlIG91dGVyLWpvaW4tYXdhcmUuCgpUcmFkaXRpb25hbGx5IHdlIHVzZWQgdGhl IHNhbWUgVmFyIHN0cnVjdCB0byByZXByZXNlbnQgdGhlIHZhbHVlCm9mIGEgdGFibGUgY29sdW1u IGV2ZXJ5d2hlcmUgaW4gcGFyc2UgYW5kIHBsYW4gdHJlZXMuICBUaGlzIGNob2ljZQpwcmVkYXRl cyBvdXIgc3VwcG9ydCBmb3IgU1FMIG91dGVyIGpvaW5zLCBhbmQgaXQncyByZWFsbHkgYSBwcmV0 dHkKYmFkIGlkZWEgd2l0aCBvdXRlciBqb2lucywgYmVjYXVzZSB0aGUgVmFyJ3MgdmFsdWUgY2Fu IGRlcGVuZCBvbgp3aGVyZSBpdCBpcyBpbiB0aGUgdHJlZTogaXQgbWlnaHQgZ28gdG8gTlVMTCBh Ym92ZSBhbiBvdXRlciBqb2luLgpTbyBleHByZXNzaW9uIG5vZGVzIHRoYXQgYXJlIGVxdWFsKCkg cGVyIGVxdWFsZnVuY3MuYyBtaWdodCBub3QKcmVwcmVzZW50IHRoZSBzYW1lIHZhbHVlLCB3aGlj aCBpcyBhIGh1Z2UgY29ycmVjdG5lc3MgaGF6YXJkIGZvcgp0aGUgcGxhbm5lci4KClRvIGltcHJv dmUgdGhpcywgZGVjb3JhdGUgVmFyIG5vZGVzIHdpdGggYSBiaXRtYXBzZXQgc2hvd2luZwp3aGlj aCBvdXRlciBqb2lucyAoaWRlbnRpZmllZCBieSBSVEUgaW5kZXhlcykgbWF5IGhhdmUgbnVsbGVk CnRoZW0gYXQgdGhlIHBvaW50IGluIHRoZSBwYXJzZSB0cmVlIHdoZXJlIHRoZSBWYXIgYXBwZWFy cy4KVGhpcyBhbGxvd3MgdXMgdG8gdHJ1c3QgdGhhdCBlcXVhbCgpIFZhcnMgcmVwcmVzZW50IHRo ZSBzYW1lIHZhbHVlLgpBIGNlcnRhaW4gYW1vdW50IG9mIGtsdWdlcnkgaXMgc3RpbGwgbmVlZGVk IHRvIGNvcGUgd2l0aCBjYXNlcwp3aGVyZSB3ZSByZS1vcmRlciB0d28gb3V0ZXIgam9pbnMsIGJ1 dCBpdCdzIHBvc3NpYmxlIHRvIG1ha2UgaXQKd29yayB3aXRob3V0IHNhY3JpZmljaW5nIHRoYXQg Y29yZSBwcmluY2lwbGUuICBQbGFjZUhvbGRlclZhcnMKcmVjZWl2ZSBzaW1pbGFyIGRlY29yYXRp b24gZm9yIHRoZSBzYW1lIHJlYXNvbi4KCkluIHRoZSBwbGFubmVyLCB3ZSBpbmNsdWRlIHRoZXNl IG91dGVyIGpvaW4gYml0bWFwc2V0cyBpbnRvIHRoZSByZWxpZHMKdGhhdCBhbiBleHByZXNzaW9u IGlzIGNvbnNpZGVyZWQgdG8gZGVwZW5kIG9uLCBhbmQgaW4gY29uc2VxdWVuY2UgYWxzbwphZGQg b3V0ZXItam9pbiByZWxpZHMgdG8gdGhlIHJlbGlkcyBvZiBqb2luIFJlbE9wdEluZm9zLiAgVGhp cyBhbGxvd3MKdXMgdG8gY29ycmVjdGx5IHBlcmNlaXZlIHdoZXRoZXIgYW4gZXhwcmVzc2lvbiBj YW4gYmUgY2FsY3VsYXRlZCBhYm92ZQpvciBiZWxvdyBhIHBhcnRpY3VsYXIgb3V0ZXIgam9pbi4K ClRoaXMgY2hhbmdlIGFmZmVjdHMgRkRXcyB0aGF0IHdhbnQgdG8gcGxhbiBmb3JlaWduIGpvaW5z LiAgVGhleSAqbXVzdCoKZm9sbG93IHN1aXQgd2hlbiBsYWJlbGluZyBmb3JlaWduIGpvaW5zIGlu IG9yZGVyIHRvIG1hdGNoIHdpdGggdGhlCmNvcmUgcGxhbm5lciwgYnV0IGZvciBtYW55IHB1cnBv c2VzIChpZiBwb3N0Z3Jlc19mZHcgaXMgYW55IGd1aWRlKQp0aGV5J2QgcHJlZmVyIHRvIGNvbnNp ZGVyIG9ubHkgYmFzZSByZWxhdGlvbnMgd2l0aGluIHRoZSBqb2luLgpUbyBzdXBwb3J0IGJvdGgg cmVxdWlyZW1lbnRzLCByZWRlZmluZSBGb3JlaWduU2Nhbi5mc19yZWxpZHMgYXMKYmFzZStPSiBy ZWxpZHMsIGFuZCBhZGQgYSBuZXcgZmllbGQgZnNfYmFzZV9yZWxpZHMgdGhhdCdzIHNldCB1cCBi eQp0aGUgY29yZSBwbGFubmVyLgoKTGFyZ2UgdGhvdWdoIGl0IGlzLCB0aGlzIGNvbW1pdCBqdXN0 IGRvZXMgdGhlIG1pbmltdW0gbmVjZXNzYXJ5IHRvCmluc3RhbGwgdGhlIG5ldyBtZWNoYW5pc21z IGFuZCBnZXQgY2hlY2std29ybGQgcGFzc2luZyBhZ2Fpbi4KRm9sbG93LXVwIHBhdGNoZXMgd2ls bCBwZXJmb3JtIHNvbWUgY2xlYW51cC4gIChUaGUgUkVBRE1FIGFkZGl0aW9ucwphbmQgY29tbWVu dHMgbWVudGlvbiBzb21lIHN0dWZmIHRoYXQgd2lsbCBhcHBlYXIgaW4gdGhlIGZvbGxvdy11cC4p CgpQYXRjaCBieSBtZTsgdGhhbmtzIHRvIFJpY2hhcmQgR3VvIGZvciByZXZpZXcuCgpEaXNjdXNz aW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzgzMDI2OS4xNjU2NjkzNzQ3QHNzcy5wZ2gucGEudXMK CkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdy ZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi8yNDg5ZDc2YzQ5MDZmNDQ2MWEzNjRjYThhZDdlMDc1MWVh ZDhhYTBkCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpjb250cmliL3Bvc3RncmVzX2Zk dy9kZXBhcnNlLmMgICAgICAgICAgICAgICB8ICAgMTIgKy0KY29udHJpYi9wb3N0Z3Jlc19mZHcv cG9zdGdyZXNfZmR3LmMgICAgICAgICAgfCAgIDEyICstCmRvYy9zcmMvc2dtbC9mZHdoYW5kbGVy LnNnbWwgICAgICAgICAgICAgICAgIHwgICAxMSArCnNyYy9iYWNrZW5kL2NvbW1hbmRzL2V4cGxh aW4uYyAgICAgICAgICAgICAgIHwgICAgMiArLQpzcmMvYmFja2VuZC9leGVjdXRvci9leGVjU2Nh bi5jICAgICAgICAgICAgICB8ICAgIDIgKy0Kc3JjL2JhY2tlbmQvbm9kZXMvbWFrZWZ1bmNzLmMg ICAgICAgICAgICAgICAgfCAgIDEwICstCnNyYy9iYWNrZW5kL25vZGVzL25vZGVGdW5jcy5jICAg ICAgICAgICAgICAgIHwgICAgMyArLQpzcmMvYmFja2VuZC9ub2Rlcy9xdWVyeWp1bWJsZWZ1bmNz LmMgICAgICAgICB8ICAgIDUgKwpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvUkVBRE1FICAgICAgICAg ICAgICAgICB8ICA0MzMgKysrKysrKystLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvZ2Vxby9nZXFv X2V2YWwuYyAgICAgICB8ICAgIDIgKy0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3BhdGgvYWxscGF0 aHMuYyAgICAgICAgfCAgIDM2ICstCnNyYy9iYWNrZW5kL29wdGltaXplci9wYXRoL2NsYXVzZXNl bC5jICAgICAgIHwgICA0NSArLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGF0aC9jb3N0c2l6ZS5j ICAgICAgICB8ICAgIDggKwpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGF0aC9lcXVpdmNsYXNzLmMg ICAgICB8ICAxMzIgKystCnNyYy9iYWNrZW5kL29wdGltaXplci9wYXRoL2luZHhwYXRoLmMgICAg ICAgIHwgICAgOSArLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGF0aC9qb2lucGF0aC5jICAgICAg ICB8ICAgNjUgKy0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3BhdGgvam9pbnJlbHMuYyAgICAgICAg fCAgIDMwICstCnNyYy9iYWNrZW5kL29wdGltaXplci9wYXRoL3RpZHBhdGguYyAgICAgICAgIHwg ICAgMSArCnNyYy9iYWNrZW5kL29wdGltaXplci9wbGFuL2FuYWx5emVqb2lucy5jICAgIHwgICA2 MSArLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGxhbi9jcmVhdGVwbGFuLmMgICAgICB8ICAgMTcg Ky0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3BsYW4vaW5pdHNwbGFuLmMgICAgICAgfCAxMTIxICsr KysrKysrKysrKysrKysrKysrLS0tLS0tCnNyYy9iYWNrZW5kL29wdGltaXplci9wbGFuL3BsYW5u ZXIuYyAgICAgICAgIHwgICAgNyArLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGxhbi9zZXRyZWZz LmMgICAgICAgICB8ICAyMzQgKysrKy0tCnNyYy9iYWNrZW5kL29wdGltaXplci9wcmVwL3ByZXBq b2ludHJlZS5jICAgIHwgIDU0NCArKysrKysrLS0tLS0tCnNyYy9iYWNrZW5kL29wdGltaXplci91 dGlsL2FwcGVuZGluZm8uYyAgICAgIHwgICA1OSArLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvdXRp bC9jbGF1c2VzLmMgICAgICAgICB8ICAgIDYgKy0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3V0aWwv am9pbmluZm8uYyAgICAgICAgfCAgIDE5ICstCnNyYy9iYWNrZW5kL29wdGltaXplci91dGlsL29y Y2xhdXNlcy5jICAgICAgIHwgICAgNCArCnNyYy9iYWNrZW5kL29wdGltaXplci91dGlsL3BhdGhu b2RlLmMgICAgICAgIHwgICAxNSArLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvdXRpbC9wbGFjZWhv bGRlci5jICAgICB8ICAxMjMgKystCnNyYy9iYWNrZW5kL29wdGltaXplci91dGlsL3JlbG5vZGUu YyAgICAgICAgIHwgIDM4OSArKysrKysrLS0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3V0aWwvcmVz dHJpY3RpbmZvLmMgICAgfCAgIDkzICsrLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvdXRpbC92YXIu YyAgICAgICAgICAgICB8ICAyNTIgKysrKystCnNyYy9iYWNrZW5kL3BhcnNlci9hbmFseXplLmMg ICAgICAgICAgICAgICAgIHwgICAgMyArLQpzcmMvYmFja2VuZC9wYXJzZXIvcGFyc2VfYWdnLmMg ICAgICAgICAgICAgICB8ICAgIDggKy0Kc3JjL2JhY2tlbmQvcGFyc2VyL3BhcnNlX2NsYXVzZS5j ICAgICAgICAgICAgfCAgMjM1ICsrKystLQpzcmMvYmFja2VuZC9wYXJzZXIvcGFyc2VfY29lcmNl LmMgICAgICAgICAgICB8ICAgIDIgKy0Kc3JjL2JhY2tlbmQvcGFyc2VyL3BhcnNlX2V4cHIuYyAg ICAgICAgICAgICAgfCAgICA1ICsKc3JjL2JhY2tlbmQvcGFyc2VyL3BhcnNlX3JlbGF0aW9uLmMg ICAgICAgICAgfCAgIDQwICstCnNyYy9iYWNrZW5kL3BhcnNlci9wYXJzZV90YXJnZXQuYyAgICAg ICAgICAgIHwgICAgMiArLQpzcmMvYmFja2VuZC9yZXdyaXRlL3Jld3JpdGVNYW5pcC5jICAgICAg ICAgICB8ICAyMjcgKysrKystCnNyYy9iYWNrZW5kL3V0aWxzL2FkdC9zZWxmdW5jcy5jICAgICAg ICAgICAgIHwgICAgMiArLQpzcmMvaW5jbHVkZS9jYXRhbG9nL2NhdHZlcnNpb24uaCAgICAgICAg ICAgICB8ICAgIDIgKy0Kc3JjL2luY2x1ZGUvbm9kZXMvcGFyc2Vub2Rlcy5oICAgICAgICAgICAg ICAgfCAgICA4ICsKc3JjL2luY2x1ZGUvbm9kZXMvcGF0aG5vZGVzLmggICAgICAgICAgICAgICAg fCAgMjE2ICsrKy0tCnNyYy9pbmNsdWRlL25vZGVzL3BsYW5ub2Rlcy5oICAgICAgICAgICAgICAg IHwgICAgNCArLQpzcmMvaW5jbHVkZS9ub2Rlcy9wcmltbm9kZXMuaCAgICAgICAgICAgICAgICB8 ICAgMTAgKwpzcmMvaW5jbHVkZS9vcHRpbWl6ZXIvb3B0aW1pemVyLmggICAgICAgICAgICB8ICAg IDIgKy0Kc3JjL2luY2x1ZGUvb3B0aW1pemVyL3BhdGhub2RlLmggICAgICAgICAgICAgfCAgICA0 ICstCnNyYy9pbmNsdWRlL29wdGltaXplci9wbGFjZWhvbGRlci5oICAgICAgICAgIHwgICAgNSAr LQpzcmMvaW5jbHVkZS9vcHRpbWl6ZXIvcHJlcC5oICAgICAgICAgICAgICAgICB8ICAgIDMgKy0K c3JjL2luY2x1ZGUvb3B0aW1pemVyL3Jlc3RyaWN0aW5mby5oICAgICAgICAgfCAgICAzICsKc3Jj L2luY2x1ZGUvcGFyc2VyL3BhcnNlX25vZGUuaCAgICAgICAgICAgICAgfCAgICA4ICsKc3JjL2lu Y2x1ZGUvcGFyc2VyL3BhcnNlX3JlbGF0aW9uLmggICAgICAgICAgfCAgICAzICstCnNyYy9pbmNs dWRlL3Jld3JpdGUvcmV3cml0ZU1hbmlwLmggICAgICAgICAgIHwgICAgNyArCnNyYy90ZXN0L3Jl Z3Jlc3MvZXhwZWN0ZWQvYWdncmVnYXRlcy5vdXQgICAgIHwgICAyMCArLQpzcmMvdGVzdC9yZWdy ZXNzL2V4cGVjdGVkL2pvaW4ub3V0ICAgICAgICAgICB8ICAxNjMgKysrLQpzcmMvdGVzdC9yZWdy ZXNzL2V4cGVjdGVkL3BhcnRpdGlvbl9qb2luLm91dCB8ICAgMTQgKy0Kc3JjL3Rlc3QvcmVncmVz cy9zcWwvYWdncmVnYXRlcy5zcWwgICAgICAgICAgfCAgIDE0ICstCnNyYy90ZXN0L3JlZ3Jlc3Mv c3FsL2pvaW4uc3FsICAgICAgICAgICAgICAgIHwgICA3MiArKwo2MCBmaWxlcyBjaGFuZ2VkLCAz ODc4IGluc2VydGlvbnMoKyksIDk2NiBkZWxldGlvbnMoLSkKCg== --===============1870523271885284958==--