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 1rMxzE-0083s7-5Z for pgsql-bugs@arkaria.postgresql.org; Mon, 08 Jan 2024 22:20:48 +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 1rMxzC-007yZ9-TD for pgsql-bugs@arkaria.postgresql.org; Mon, 08 Jan 2024 22:20:46 +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 1rMwsp-007lFa-RE for pgsql-bugs@lists.postgresql.org; Mon, 08 Jan 2024 21:10:07 +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 1rMwsn-000XiP-Ay for pgsql-bugs@lists.postgresql.org; Mon, 08 Jan 2024 21:10:06 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=/Tp5iMBcnMf3mt81k90hkBepBQ3OXwzdT1iA2qCdt/c=; b=NrB2UHylIr5WqW7eZAo5cmJvyI oyu/7rklI1RFNAo6j9NfT+pzlj/1jWtJuGntX37VjlOQXJVMwpB4Z6mFT4/NYWfKODQheAJouku8r V02gg5gWfJzH1AV4ijcGuhNZInRrAica/lnQXs7pXvAar3LOAz5Fsbzc7lp/LauE3uLktjEgJb/n/ 2qwlMSfNkOQebdXmw4IUhdiBj7kN5H7tK+0c9X2eD1uqeoDPiAm3YXU7EKH9N9KhX99CgMpS19Ntt fdF5Wr0pOM6ITmVr7d6FgWs/Mprvks7L3laDw/rUhzjwhgx8K90so3Z/vvvnbLy/gh3C6zSIDT2PV 3LqMTr5Q==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rMwsl-001gyP-99 for pgsql-bugs@lists.postgresql.org; Mon, 08 Jan 2024 21:10:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rMwsj-003X6b-Vu for pgsql-bugs@lists.postgresql.org; Mon, 08 Jan 2024 21:10:02 +0000 Content-Type: multipart/mixed; boundary="===============1237917174619788482==" MIME-Version: 1.0 Subject: BUG #18277: Unexpected error: "WindowFunc not found in subplan target lists" triggered by JOIN and Window Func To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: zuming.jiang@inf.ethz.ch Reply-To: zuming.jiang@inf.ethz.ch, pgsql-bugs@lists.postgresql.org Date: Mon, 08 Jan 2024 21:09:16 +0000 Message-ID: <18277-089ead83b329a2fd@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1237917174619788482== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODI3NwpMb2dnZWQgYnk6ICAgICAgICAgIFp1bWluZyBKaWFuZwpFbWFp bCBhZGRyZXNzOiAgICAgIHp1bWluZy5qaWFuZ0BpbmYuZXRoei5jaApQb3N0Z3JlU1FMIHZlcnNp b246IDE2LjEKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMjAuMDQKRGVzY3JpcHRpb246ICAg ICAgICAKCk15IGZ1enplciBmaW5kcyBhIGJ1ZyBpbiBQb3N0Z3JlcyAxN2RldmVsLCB3aGljaCB0 cmlnZ2VycyBhbiB1bmV4cGVjdGVkCmVycm9yICJFUlJPUjogV2luZG93RnVuYyBub3QgZm91bmQg aW4gc3VicGxhbiB0YXJnZXQgbGlzdHMiLg0KDQotLS0gU2V0IHVwIGRhdGFiYXNlIC0tLQ0KY3Jl YXRlIHRhYmxlIGV4ZWV0X3QxODQgKHZrZXkgaW50NCk7DQpjcmVhdGUgdmlldyBleGVldF90MTg4 IGFzDQpzZWxlY3QNCiAgICBudGlsZShyZWZfMS52a2V5KSBvdmVyIHcwIGFzIGNfMQ0KICBmcm9t DQogICAgKGV4ZWV0X3QxODQgYXMgcmVmXzANCiAgICAgIGxlZnQgb3V0ZXIgam9pbiBleGVldF90 MTg0IGFzIHJlZl8xDQogICAgICBvbiAocmVmXzAudmtleSA9IHJlZl8xLnZrZXkpKQ0KICB3aGVy ZSByZWZfMC52a2V5IDw+IHJlZl8xLnZrZXkNCiAgd2luZG93IHcwIGFzIChwYXJ0aXRpb24gYnkg cmVmXzAudmtleSk7DQoNClRoZSBmdXp6ZXIgZ2VuZXJhdGVzIGEgdGVzdCBjYXNlOg0KDQotLS0g VGVzdCBjYXNlIC0tLQ0Kc2VsZWN0DQogIChjYXNlIHdoZW4gKCdmYWxzZScgPD4gKFNFTEVDVCBu dW1tdWx0aXJhbmdlKCkgJiYgJ2VtcHR5Jzo6bnVtcmFuZ2UpKSB0aGVuCihjYXNlIHdoZW4gKDEg aW4gKA0KICAgICAgICAgICAgICAgIHNlbGVjdA0KICAgICAgICAgICAgICAgICAgMSBhcyBjXzAN CiAgICAgICAgICAgICAgICBmcm9tDQogICAgICAgICAgICAgICAgICBleGVldF90MTg4IGFzIHJl Zl8xMg0KICAgICAgICAgICAgICAgIHdoZXJlIDEgYmV0d2VlbiByZWZfMTIuY18xIGFuZCAxKSkg dGhlbiAxIGVsc2UgMSBlbmQNCiAgICAgICAgKSBlbHNlIDEgZW5kKSBhcyBjXzU7DQoNCi0tLSBF eHBlY3RlZCBiZWhhdmlvciAtLS0NClRoZSB0ZXN0IGNhc2Ugc2hvdWxkIG5vdCB0cmlnZ2VyIGFu eSBlcnJvci4NCg0KLS0tIEFjdHVhbCBiZWhhdmlvciAtLS0NClRoZSB0ZXN0IGNhc2UgdHJpZ2dl ciBhbiBlcnJvcjogDQoNCkVSUk9SOiAgV2luZG93RnVuYyBub3QgZm91bmQgaW4gc3VicGxhbiB0 YXJnZXQgbGlzdHMNCg0KLS0tIFBvc3RncmVzIHZlcnNpb24gLS0tDQpHaXRodWIgY29tbWl0OiBk M2M1ZjM3ZGQ1NDM0OThjYzdjNjc4ODE1ZDM5MjE4MjNiZWVjOWU5DQpWZXJzaW9uOiBQb3N0Z3Jl U1FMIDE3ZGV2ZWwgb24geDg2XzY0LXBjLWxpbnV4LWdudSwgY29tcGlsZWQgYnkgZ2NjIChVYnVu dHUKOS40LjAtMXVidW50dTF+MjAuMDQuMikgOS40LjAsIDY0LWJpdA0KDQotLS0gUGxhdGZvcm0g aW5mb3JtYXRpb24gLS0tDQpQbGF0Zm9ybTogVWJ1bnR1IDIwLjA0DQpLZXJuZWw6IExpbnV4IDUu NC4wLTE0Ny1nZW5lcmljCgo= --===============1237917174619788482==--