Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sZMNq-000Tm9-Ul for pgsql-committers@arkaria.postgresql.org; Thu, 01 Aug 2024 03:21:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sZMNp-0016Ng-1S for pgsql-committers@arkaria.postgresql.org; Thu, 01 Aug 2024 03:21:41 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sZMNo-0016NY-Qb for pgsql-committers@lists.postgresql.org; Thu, 01 Aug 2024 03:21:40 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sZMNl-002TrH-S6 for pgsql-committers@lists.postgresql.org; Thu, 01 Aug 2024 03:21:39 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sZMNl-007jh0-6y for pgsql-committers@lists.postgresql.org; Thu, 01 Aug 2024 03:21:37 +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 1sZMNk-00286R-8F for pgsql-committers@lists.postgresql.org; Thu, 01 Aug 2024 03:21:36 +0000 Content-Type: multipart/mixed; boundary="===============5002145288524597239==" MIME-Version: 1.0 From: Andres Freund To: pgsql-committers@lists.postgresql.org Subject: pgsql: Evaluate arguments of correlated SubPlans in the referencing Exp X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 01 Aug 2024 03:21:36 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5002145288524597239== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 RXZhbHVhdGUgYXJndW1lbnRzIG9mIGNvcnJlbGF0ZWQgU3ViUGxhbnMgaW4gdGhlIHJlZmVyZW5j aW5nIEV4cHJTdGF0ZQoKVW50aWwgbm93IHdlIGdlbmVyYXRlZCBhbiBFeHByU3RhdGUgZm9yIGVh Y2ggcGFyYW1ldGVyIHRvIGEgU3ViUGxhbiBhbmQKZXZhbHVhdGVkIHRoZW0gb25lLWJ5LW9uZSBF eGVjU2NhblN1YlBsYW4uIFRoYXQncyBzdWItb3B0aW1hbCBhcyBjcmVhdGluZyBsb3RzCm9mIHNt YWxsIEV4cHJTdGF0ZXMKYSkgbWFrZXMgSklUIGNvbXBpbGF0aW9uIG1vcmUgZXhwZW5zaXZlCmIp IHdhc3RlcyBtZW1vcnkKYykgaXMgYSBiaXQgc2xvd2VyIHRvIGV4ZWN1dGUKClRoaXMgY29tbWl0 IGFycmFuZ2VzIHRvIGV2YWx1YXRlIHBhcmFtZXRlcnMgdG8gYSBTdWJQbGFuIGFzIHBhcnQgb2Yg dGhlCkV4cHJTdGF0ZSByZWZlcmVuY2luZyBhIFN1YlBsYW4sIHVzaW5nIHRoZSBuZXcgRUVPUF9Q QVJBTV9TRVQgZXhwcmVzc2lvbgpzdGVwLiBXZSBlbWl0IG9uZSBFRU9QX1BBUkFNX1NFVCBmb3Ig ZWFjaCBhcmd1bWVudCB0byBhIHN1YnBsYW4sIGp1c3QgYmVmb3JlCnRoZSBFRU9QX1NVQlBMQU4g c3RlcC4KCkl0IGxpa2VseSBpcyB3b3J0aCB1c2luZyBFRU9QX1BBUkFNX1NFVCBpbiBvdGhlciBw bGFjZXMgYXMgd2VsbCwgZS5nLiBmb3IKU3ViUGxhbiBvdXRwdXRzLCBuZXN0bG9vcCBwYXJhbWV0 ZXJzIGFuZCAtIG1vcmUgYW1iaXRpb3VzbHkgLSB0byBnZXQgcmlkIG9mCkV4cHJDb250ZXh0LT5k b21haW5WYWx1ZS9jYXNlVmFsdWUvZWN4dF9hZ2cqLiAgQnV0IHRoYXQncyBmb3IgbGF0ZXIuCgpB dXRob3I6IEFuZHJlcyBGcmV1bmQgPGFuZHJlc0BhbmFyYXplbC5kZT4KUmV2aWV3ZWQtYnk6IFRv bSBMYW5lIDx0Z2xAc3NzLnBnaC5wYS51cz4KUmV2aWV3ZWQtYnk6IEFsZW5hIFJ5YmFraW5hIDxs ZW5hLnJpYmFja2luYUB5YW5kZXgucnU+CkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20v MjAyMzAyMjUyMTQ0MDEuMzQ2YW5jZ2pxYzN6bXZla0Bhd29yazMuYW5hcmF6ZWwuZGUKCkJyYW5j aAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5v cmcvcGcvY29tbWl0ZGlmZi9hN2YxMDdkZjJiNzAwYzg1OWU0ZDlhZDJjYTY2YjA3YTQ2NWQ2MjIz CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9leGVjdXRvci9leGVj RXhwci5jICAgICAgIHwgMTAzICsrKysrKysrKysrKysrKysrKysrKysrLS0tLS0tLS0tLS0Kc3Jj L2JhY2tlbmQvZXhlY3V0b3IvZXhlY0V4cHJJbnRlcnAuYyB8ICAyNiArKysrKysrKysKc3JjL2Jh Y2tlbmQvZXhlY3V0b3IvZXhlY1Byb2Nub2RlLmMgICB8ICAgNSArKwpzcmMvYmFja2VuZC9leGVj dXRvci9ub2RlU3VicGxhbi5jICAgIHwgIDI5ICsrKystLS0tLS0Kc3JjL2JhY2tlbmQvaml0L2xs dm0vbGx2bWppdF9leHByLmMgICB8ICAgNiArKwpzcmMvYmFja2VuZC9qaXQvbGx2bS9sbHZtaml0 X3R5cGVzLmMgIHwgICAxICsKc3JjL2luY2x1ZGUvZXhlY3V0b3IvZXhlY0V4cHIuaCAgICAgICB8 ICAgNiArLQpzcmMvaW5jbHVkZS9ub2Rlcy9leGVjbm9kZXMuaCAgICAgICAgIHwgICAxIC0KOCBm aWxlcyBjaGFuZ2VkLCAxMjUgaW5zZXJ0aW9ucygrKSwgNTIgZGVsZXRpb25zKC0pCgo= --===============5002145288524597239==--