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 1tsdAC-003kYZ-Df for pgsql-committers@arkaria.postgresql.org; Thu, 13 Mar 2025 07:39:32 +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 1tsdAB-006iGi-6l for pgsql-committers@arkaria.postgresql.org; Thu, 13 Mar 2025 07:39:31 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tsd7D-006dxC-Bq for pgsql-committers@lists.postgresql.org; Thu, 13 Mar 2025 07:36:27 +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.96) (envelope-from ) id 1tsd79-002bOc-1N for pgsql-committers@lists.postgresql.org; Thu, 13 Mar 2025 07:36:26 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=y0fQs988cgQz++MZxnbK38XdCcVPEBJfyNsQbHc55G0=; b=5Xy7om8yLJCZ9BMjI+s4CNXViM R7ehR0tV9QWamZIBOPbvyDLeMw54wbVGHtB0DtW595nVnB7pMLm3ZYKJxTaRAsqeM+sSbhPWhzvOM kb1uJ3VX9jOtbt6MVXUHqukrPoSuSCQ4H8LVF2GilcxgNQyrutT8etYRmDJMPpA3ZOJKNWUaJ8I7O EDnPLmVC5qBVjPFq7F0vDZ+TG8ibn4DFEA7Q0lo2PZFYYAxG3oDvMG/u4oGGmOcVSPEaLPH8Gnw0U e/q0QUHsI8c/PK4SBaTK+FJm4pNXFu3YSo/4Odp5N0jtAjO/92yxg2esyRIpJkIGX/3+RbuXxK5fb RlH6qNqg==; 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 1tsd78-006eSd-Vp for pgsql-committers@lists.postgresql.org; Thu, 13 Mar 2025 07:36:22 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1tsd77-002EUQ-3D for pgsql-committers@lists.postgresql.org; Thu, 13 Mar 2025 07:36:22 +0000 Content-Type: multipart/mixed; boundary="===============8800929842476200303==" MIME-Version: 1.0 From: Richard Guo To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix incorrect handling of subquery pullup X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 13 Mar 2025 07:36:21 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8800929842476200303== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IGluY29ycmVjdCBoYW5kbGluZyBvZiBzdWJxdWVyeSBwdWxsdXAKCldoZW4gcHVsbGluZyB1 cCBhIHN1YnF1ZXJ5LCBpZiB0aGUgc3VicXVlcnkncyB0YXJnZXQgbGlzdCBpdGVtcyBhcmUKdXNl ZCBpbiBncm91cGluZyBzZXQgY29sdW1ucywgd2UgbmVlZCB0byB3cmFwIHRoZW0gaW4gUGxhY2VI b2xkZXJWYXJzLgpUaGlzIGVuc3VyZXMgdGhhdCBleHByZXNzaW9ucyByZXRhaW4gdGhlaXIgc2Vw YXJhdGUgaWRlbnRpdHkgc28gdGhhdAp0aGV5IHdpbGwgbWF0Y2ggZ3JvdXBpbmcgc2V0IGNvbHVt bnMgd2hlbiBhcHByb3ByaWF0ZS4KCkluIDkwOTQ3Njc0Ziwgd2UgZGVjaWRlZCB0byB3cmFwIHN1 YnF1ZXJ5IG91dHB1dHMgdGhhdCBhcmUgbm9uLXZhcgpleHByZXNzaW9ucyBpbiBQbGFjZUhvbGRl clZhcnMuICBUaGlzIHByZXZlbnRzIGNvbnN0LXNpbXBsaWZpY2F0aW9uCmZyb20gbWVyZ2luZyB0 aGVtIGludG8gdGhlIHN1cnJvdW5kaW5nIGV4cHJlc3Npb25zIGFmdGVyIHN1YnF1ZXJ5CnB1bGx1 cCwgd2hpY2ggY291bGQgb3RoZXJ3aXNlIGxlYWQgdG8gZmFpbGluZyB0byBtYXRjaCB0aG9zZQpz dWJleHByZXNzaW9ucyB0byBncm91cGluZyBzZXQgY29sdW1ucywgd2l0aCB0aGUgZWZmZWN0IHRo YXQgdGhleSdkCm5vdCBnbyB0byBudWxsIHdoZW4gZXhwZWN0ZWQuCgpIb3dldmVyLCB0aGF0IGxl ZnQgc29tZSBsb29zZSBlbmRzLiAgSWYgdGhlIHN1YnF1ZXJ5J3MgdGFyZ2V0IGxpc3QKY29udGFp bnMgdHdvIG9yIG1vcmUgaWRlbnRpY2FsIFZhciBleHByZXNzaW9ucywgd2UgY2FuIHN0aWxsIGZh aWwgdG8KbWF0Y2ggdGhlIFZhciBleHByZXNzaW9uIHRvIHRoZSBleHBlY3RlZCBncm91cGluZyBz ZXQgZXhwcmVzc2lvbi4KVGhpcyBpcyBub3QgcmVsYXRlZCB0byBjb25zdC1zaW1wbGlmaWNhdGlv biwgYnV0IHJhdGhlciB0byBob3cgd2UKbWF0Y2ggZXhwcmVzc2lvbnMgdG8gbG93ZXIgdGFyZ2V0 IGl0ZW1zIGluIHNldHJlZnMuYy4KCkZvciBzb3J0L2dyb3VwIGV4cHJlc3Npb25zLCB3ZSB1c2Ug cmVzc29ydGdyb3VwcmVmIG1hdGNoaW5nLCB3aGljaAp3b3JrcyB3ZWxsLiAgRm9yIG90aGVyIGV4 cHJlc3Npb25zLCB3ZSBwcmltYXJpbHkgcmVseSBvbiBjb21wYXJpbmcgdGhlCmV4cHJlc3Npb25z IHRvIGRldGVybWluZSBpZiB0aGV5IGFyZSB0aGUgc2FtZS4gIFRoZXJlZm9yZSwgd2UgbmVlZCBh CndheSB0byBwcmV2ZW50IHNldHJlZnMuYyBmcm9tIG1hdGNoaW5nIHRoZSBleHByZXNzaW9uIHRv IHNvbWUgb3RoZXIKaWRlbnRpY2FsIG9uZXMuCgpUbyBmaXgsIHdyYXAgYWxsIHN1YnF1ZXJ5IG91 dHB1dHMgaW4gUGxhY2VIb2xkZXJWYXJzIGlmIHRoZSBwYXJlbnQKcXVlcnkgdXNlcyBncm91cGlu ZyBzZXRzLCBlbnN1cmluZyB0aGF0IHRoZXkgcHJlc2VydmUgdGhlaXIgc2VwYXJhdGUKaWRlbnRp dHkgdGhyb3VnaG91dCB0aGUgd2hvbGUgcGxhbm5pbmcgcHJvY2Vzcy4KClJlcG9ydGVkLWJ5OiBE ZWFuIFJhc2hlZWQgPGRlYW4uYS5yYXNoZWVkQGdtYWlsLmNvbT4KQXV0aG9yOiBSaWNoYXJkIEd1 byA8Z3VvZmVuZ2xpbnV4QGdtYWlsLmNvbT4KUmV2aWV3ZWQtYnk6IERlYW4gUmFzaGVlZCA8ZGVh bi5hLnJhc2hlZWRAZ21haWwuY29tPgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL0NB TWJXczQtbWVTYWhhYW5Lc2twQm4wS0t4ZEhBWEMxX0VKQ1ZXSHhFb2RxaXJyR0pud0BtYWlsLmdt YWlsLmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dp dC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmL2NjNWQ5ODUyNWQ0M2MyMmI5OGYzNjBlZjBm MmM4ZDdkYzU3ZjA0ZGMKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5k L29wdGltaXplci9wcmVwL3ByZXBqb2ludHJlZS5jICB8IDkzICsrKysrKysrKysrKysrKystLS0t LS0tLS0tLS0tLQpzcmMvYmFja2VuZC9yZXdyaXRlL3Jld3JpdGVNYW5pcC5jICAgICAgICAgfCAg MiArLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2dyb3VwaW5nc2V0cy5vdXQgfCAyOSArKysr KysrKysrCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2dyb3VwaW5nc2V0cy5zcWwgICAgICB8IDExICsr KysKc3JjL3Rvb2xzL3BnaW5kZW50L3R5cGVkZWZzLmxpc3QgICAgICAgICAgIHwgIDEgKwo1IGZp bGVzIGNoYW5nZWQsIDkzIGluc2VydGlvbnMoKyksIDQzIGRlbGV0aW9ucygtKQoK --===============8800929842476200303==--