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 1orOmj-0001Ue-Hk for pgsql-committers@arkaria.postgresql.org; Sat, 05 Nov 2022 19:24:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1orOmh-0005Jp-Tl for pgsql-committers@arkaria.postgresql.org; Sat, 05 Nov 2022 19:24:51 +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 1orOmh-0005Jc-MV for pgsql-committers@lists.postgresql.org; Sat, 05 Nov 2022 19:24:51 +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 1orOmf-0006jw-2x for pgsql-committers@lists.postgresql.org; Sat, 05 Nov 2022 19:24:50 +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 1orOme-0004Wa-3q for pgsql-committers@lists.postgresql.org; Sat, 05 Nov 2022 19:24:48 +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 1orOmd-000aOL-Ps for pgsql-committers@lists.postgresql.org; Sat, 05 Nov 2022 19:24:47 +0000 Content-Type: multipart/mixed; boundary="===============5328315923107684888==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Handle SubPlan cases in find_nonnullable_rels/vars. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sat, 05 Nov 2022 19:24:47 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5328315923107684888== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SGFuZGxlIFN1YlBsYW4gY2FzZXMgaW4gZmluZF9ub25udWxsYWJsZV9yZWxzL3ZhcnMuCgpXZSBj YW4gdXNlIHNvbWUgdmFyaWFudHMgb2YgU3ViUGxhbiB0byBkZWR1Y2UgdGhhdCBWYXJzIGFwcGVh cmluZwppbiB0aGUgdGVzdGV4cHIgbXVzdCBiZSBub24tbnVsbC4KClJpY2hhcmQgR3VvCgpEaXNj dXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL0NBTWJXczQtalY9MTk5QTJZXzY9PTk5ZFlucG5t YU9fV3pfUkdrUlRUYUNCPVBpaHcyd0BtYWlsLmdtYWlsLmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0 ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRk aWZmL2ZmOGZhMGJmN2ViOTAwMWYzMjFjMmFmNGJiZTljMGYyYmQ1YzFiZjgKCk1vZGlmaWVkIEZp bGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL29wdGltaXplci91dGlsL2NsYXVzZXMuYyB8 IDM0ICsrKysrKysrKysrKysrKysrKysrKysrKysrKysrKysrKysKc3JjL3Rlc3QvcmVncmVzcy9l eHBlY3RlZC9qb2luLm91dCAgIHwgMjggKysrKysrKysrKysrKysrKysrKysrKysrKysrKwpzcmMv dGVzdC9yZWdyZXNzL3NxbC9qb2luLnNxbCAgICAgICAgfCAxMyArKysrKysrKysrKysrCjMgZmls ZXMgY2hhbmdlZCwgNzUgaW5zZXJ0aW9ucygrKQoK --===============5328315923107684888==--