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 1r0haF-007Fmm-5v for pgsql-bugs@arkaria.postgresql.org; Wed, 08 Nov 2023 12:22:59 +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 1r0haD-0030QP-LR for pgsql-bugs@arkaria.postgresql.org; Wed, 08 Nov 2023 12:22:57 +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 1r0PVk-00AMqA-Je for pgsql-bugs@lists.postgresql.org; Tue, 07 Nov 2023 17:05:08 +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 1r0PVh-004Qjt-WB for pgsql-bugs@lists.postgresql.org; Tue, 07 Nov 2023 17:05:07 +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=9OC0+LbF14yMk2PIdEfrcObxUofw3Mw4WSg2GxIm54E=; b=OvaPMn+LID+e65lGmslaPy0TFL lOHfInrtTlICVLnvJ6NgUoGxfJWKrFaPHGWsnYSFzNg2DdNUMTO+Br5YxtYG7jlaUYGC9GOAt1r+a Jl/GC6/V71lqAcn9N0G7A0No4gnxOFwzf9AccLEfURIYS+7/ReVpLs+kP7yTl0kjh5wRokO1dqNNq Ph0i7bWQDI2akvK87PqyE0UErOkPNZfQbSDgiugreAWN/LErFANK/oSlEwCWOw9kfvejUqc0brw0H L9muZNhpdVAM7U01QPUsD1hB0Bl/syu+QmKIiTni3z9M93m/fdGbSudY+TqGIdl7qn37Xf+V085z3 ewE6ABMw==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1r0PVg-0007Ks-EW for pgsql-bugs@lists.postgresql.org; Tue, 07 Nov 2023 17:05:05 +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 1r0PVd-00Gsr8-Oa for pgsql-bugs@lists.postgresql.org; Tue, 07 Nov 2023 17:05:02 +0000 Content-Type: multipart/mixed; boundary="===============5178855144404293390==" MIME-Version: 1.0 Subject: BUG #18187: Unexpected error: "variable not found in subplan target lists" triggered by JOIN 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: Tue, 07 Nov 2023 17:04:23 +0000 Message-ID: <18187-831da249cbd2ff8e@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 --===============5178855144404293390== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODE4NwpMb2dnZWQgYnk6ICAgICAgICAgIFp1bWluZyBKaWFuZwpFbWFp bCBhZGRyZXNzOiAgICAgIHp1bWluZy5qaWFuZ0BpbmYuZXRoei5jaApQb3N0Z3JlU1FMIHZlcnNp b246IDE2LjAKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMjAuMDQKRGVzY3JpcHRpb246ICAg ICAgICAKCk15IGZ1enplciBmaW5kcyBhIGJ1ZyBpbiBQb3N0Z3JlcyAxN2RldmVsLCB3aGljaCB0 cmlnZ2VycyBhbiB1bmV4cGVjdGVkCmVycm9yLg0KDQotLS0gU2V0IHVwIGRhdGFiYXNlIC0tLQ0K Y3JlYXRlIHRhYmxlIHQyICh2a2V5IGludDQsIGM5IHRleHQsIHByaW1hcnkga2V5KHZrZXkpKTsN CmNyZWF0ZSB2aWV3IHQ0IGFzIHNlbGVjdCAxIGFzIGNfMiwgMSBhcyBjXzM7DQpjcmVhdGUgdmll dyB0NSBhcyANCnNlbGVjdCAgDQogICAgMSBhcyBjXzAsIA0KICAgIGNhc2Ugd2hlbiAnMScgfjw9 fiByZWZfMC5jOSB0aGVuIDEgZWxzZSAxIGVuZCBhcyBjXzMgDQogIGZyb20gDQogICAgKCh0MiBh cyByZWZfMA0KICAgICAgICBpbm5lciBqb2luIHQyIGFzIHJlZl8xDQogICAgICAgIG9uIChyZWZf MC52a2V5ID0gcmVmXzEudmtleSkpDQogICAgICByaWdodCBvdXRlciBqb2luIHQyIGFzIHJlZl8y DQogICAgICBvbiAocmVmXzEudmtleSA9IHJlZl8yLnZrZXkgKSk7DQotLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0NCg0KVGhlIGZ1enplciBnZW5lcmF0ZXMgYSB0ZXN0IGNhc2U6DQoNCi0tLSBUZXN0 IGNhc2UgLS0tDQpzZWxlY3QgIA0KICByZWZfNS5jXzMNCmZyb20gDQogICgoKHNlbGVjdCByZWZf MS5jXzMgYXMgY18wIGZyb20gdDQgYXMgcmVmXzEpIGFzIHN1YnFfMA0KICAgICAgcmlnaHQgb3V0 ZXIgam9pbiB0NSBhcyByZWZfNQ0KICAgICAgb24gKHN1YnFfMC5jXzAgPSByZWZfNS5jXzApKQ0K ICAgIHJpZ2h0IG91dGVyIGpvaW4gdDQgYXMgcmVmXzYNCiAgICBvbiAoc3VicV8wLmNfMCA9IHJl Zl82LmNfMikpOw0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQoNCi0tLSBFeHBlY3RlZCBiZWhh dmlvciAtLS0NClRoZSB0ZXN0IGNhc2Ugc2hvdWxkIG5vdCB0cmlnZ2VyIGFueSBlcnJvci4NCg0K LS0tIEFjdHVhbCBiZWhhdmlvciAtLS0NClRoZSB0ZXN0IGNhc2UgdHJpZ2dlciBhbiBlcnJvcjog DQoNCkVSUk9SOiAgdmFyaWFibGUgbm90IGZvdW5kIGluIHN1YnBsYW4gdGFyZ2V0IGxpc3RzDQoN Ci0tLSBQb3N0Z3JlcyB2ZXJzaW9uIC0tLQ0KR2l0aHViIGNvbW1pdDogM2M1NTFlYmVkZTQ2MTk0 MjM3ZjgyMDYyYjU0YjkyZTQ3NGI1Yzc0Mw0KVmVyc2lvbjogUG9zdGdyZVNRTCAxN2RldmVsIG9u IHg4Nl82NC1wYy1saW51eC1nbnUsIGNvbXBpbGVkIGJ5IGdjYyAoVWJ1bnR1CjkuNC4wLTF1YnVu dHUxfjIwLjA0LjEpIDkuNC4wLCA2NC1iaXQNCg0KLS0tIFBsYXRmb3JtIGluZm9ybWF0aW9uIC0t LQ0KUGxhdGZvcm06IFVidW50dSAyMC4wNA0KS2VybmVsOiBMaW51eCA1LjQuMC0xNDctZ2VuZXJp YwoK --===============5178855144404293390==--