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 1orPJp-00034x-I2 for pgsql-committers@arkaria.postgresql.org; Sat, 05 Nov 2022 19:59:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1orPJo-0005uN-Dv for pgsql-committers@arkaria.postgresql.org; Sat, 05 Nov 2022 19:59:04 +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 1orPJo-0005uE-68 for pgsql-committers@lists.postgresql.org; Sat, 05 Nov 2022 19:59:04 +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 1orPJm-0002nc-0a for pgsql-committers@lists.postgresql.org; Sat, 05 Nov 2022 19:59:03 +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 1orPJk-0005Im-Fv for pgsql-committers@lists.postgresql.org; Sat, 05 Nov 2022 19:59:00 +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 1orPJj-000aae-O1 for pgsql-committers@lists.postgresql.org; Sat, 05 Nov 2022 19:58:59 +0000 Content-Type: multipart/mixed; boundary="===============3454640980134803426==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Don't pass down nonnullable_vars while reducing outer joins. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sat, 05 Nov 2022 19:58:59 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3454640980134803426== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 RG9uJ3QgcGFzcyBkb3duIG5vbm51bGxhYmxlX3ZhcnMgd2hpbGUgcmVkdWNpbmcgb3V0ZXIgam9p bnMuCgpXZSB3ZXJlbid0IGFjdHVhbGx5IHVzaW5nIHRoZSBwYXNzZWQtZG93biBsaXN0IGZvciBh bnl0aGluZywgb3RoZXIKdGhhbiBjb21wdXRpbmcgdGhlIG5ldyB2YWx1ZSB0byBiZSBwYXNzZWQg ZG93biBmdXJ0aGVyLiAgSSAodGdsKQpwcm9iYWJseSBoYWQgdGhlIGlkZWEgdGhhdCB3ZSdkIG5l ZWQgdGhpcyBkYXRhIGV2ZW50dWFsbHk7IGJ1dApubyB1c2UtY2FzZSBoYXMgZW1lcmdlZCBpbiBh IGdvb2QgbG9uZyB3aGlsZSwgc28gbGV0J3MganVzdCBzdG9wCmV4cGVuZGluZyB1c2VsZXNzIGN5 Y2xlcyBoZXJlLgoKUmljaGFyZCBHdW8KCkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20v Q0FNYldzNDhLTHk5YUJiPXNaNU1vTm1ucUFjR0hhV19KVEdXTENnb0VfdU1XN1M2Qy1BQG1haWwu Z21haWwuY29tCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8v Z2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvYjBiNzJjNjRhMGNlN2JmNWRkNzhhODBi MzNkODVjODljOTQzYWQwZAoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tl bmQvb3B0aW1pemVyL3ByZXAvcHJlcGpvaW50cmVlLmMgfCAzMyArKysrKystLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tCjEgZmlsZSBjaGFuZ2VkLCA2IGluc2VydGlvbnMoKyksIDI3IGRlbGV0aW9u cygtKQoK --===============3454640980134803426==--