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 1oL4ec-0007lM-Uj for pgsql-bugs@arkaria.postgresql.org; Mon, 08 Aug 2022 15:26:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oL4eb-0001Gw-Qs for pgsql-bugs@arkaria.postgresql.org; Mon, 08 Aug 2022 15:26:53 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oL4eb-0001Gi-CV for pgsql-bugs@lists.postgresql.org; Mon, 08 Aug 2022 15:26:53 +0000 Received: from mail.postgrespro.ru ([93.174.131.139]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oL4eZ-0006xg-5f for pgsql-bugs@lists.postgresql.org; Mon, 08 Aug 2022 15:26:53 +0000 Received: from mail.postgrespro.ru (cyclops.postgrespro.ru [93.174.131.138]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client did not present a certificate) by mail.postgrespro.ru (Postfix) with ESMTPSA id 9504821C5AC7 for ; Mon, 8 Aug 2022 18:26:44 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mail; t=1659972409; bh=NTKI16ZbpKTFDs3KrYPlMGCZpck4yClNEKcNUY6tE6g=; h=Date:From:To:Subject; b=p80x7OX/EiG5xoS/jT+rFzbNNDMthKQ7Wd4o+X2h8tKDHNxXuM9zQ3mFS7rZm1Ce6 4ck/M1pon4o5EvpuFHYg04BKdgC0qH004TmPhhANEI+0qBSmJu72Jbq+8+hfhlE7Gb 3kPB/jHaovPgtt6pvCQ7Z0eykxykiWf/jy+OH9ZQ= MIME-Version: 1.0 Date: Mon, 08 Aug 2022 18:26:44 +0300 From: Alexander Pyhalov To: pgsql-bugs@lists.postgresql.org Subject: foreign join error "variable not found in subplan target list" User-Agent: Roundcube Webmail/1.4.11 Message-ID: X-Sender: a.pyhalov@postgrespro.ru Content-Type: multipart/mixed; boundary="=_f6db2fcd6c178286eaf174cd746e5bb2" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=_f6db2fcd6c178286eaf174cd746e5bb2 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; format=flowed Hi. Using the following patch I'm able to get "ERROR: variable not found in subplan target list" on foreign join pushdown for update returning. It seems that we generate Result node which has 7 vars in targetlist over Sort plan node, which has only 6 vars in targetlist. So far not sure what causes this. -- Best regards, Alexander Pyhalov, Postgres Professional --=_f6db2fcd6c178286eaf174cd746e5bb2 Content-Transfer-Encoding: base64 Content-Type: text/x-diff; name=costs_tweaks.diff Content-Disposition: attachment; filename=costs_tweaks.diff; size=1162 ZGlmZiAtLWdpdCBhL2NvbnRyaWIvcG9zdGdyZXNfZmR3L3NxbC9wb3N0Z3Jlc19mZHcuc3FsIGIv Y29udHJpYi9wb3N0Z3Jlc19mZHcvc3FsL3Bvc3RncmVzX2Zkdy5zcWwKaW5kZXggNDI3MzVhZTc4 YTkuLjVlYjM4N2VmMTRmIDEwMDY0NAotLS0gYS9jb250cmliL3Bvc3RncmVzX2Zkdy9zcWwvcG9z dGdyZXNfZmR3LnNxbAorKysgYi9jb250cmliL3Bvc3RncmVzX2Zkdy9zcWwvcG9zdGdyZXNfZmR3 LnNxbApAQCAtMTM1NSw2ICsxMzU1LDkgQEAgSU5TRVJUIElOVE8gZnQyIChjMSxjMixjMykKIEVY UExBSU4gKHZlcmJvc2UsIGNvc3RzIG9mZikKIFVQREFURSBmdDIgU0VUIGMzID0gJ2JhcicgV0hF UkUgcG9zdGdyZXNfZmR3X2FicyhjMSkgPiAyMDAwIFJFVFVSTklORyAqOyAgICAgICAgICAgIC0t IGNhbid0IGJlIHB1c2hlZCBkb3duCiBVUERBVEUgZnQyIFNFVCBjMyA9ICdiYXInIFdIRVJFIHBv c3RncmVzX2Zkd19hYnMoYzEpID4gMjAwMCBSRVRVUk5JTkcgKjsKK0FMVEVSIFNFUlZFUiBsb29w YmFjayBPUFRJT05TIChhZGQgZmR3X3N0YXJ0dXBfY29zdCAnMTAwMDAuMCcpOworQUxURVIgU0VS VkVSIGxvb3BiYWNrIE9QVElPTlMgKGFkZCBmZHdfdHVwbGVfY29zdCAnMS4wJyk7CitTRVQgZW5h YmxlX25lc3Rsb29wIFRPIGZhbHNlOwogRVhQTEFJTiAodmVyYm9zZSwgY29zdHMgb2ZmKQogVVBE QVRFIGZ0MiBTRVQgYzMgPSAnYmF6JwogICBGUk9NIGZ0NCBJTk5FUiBKT0lOIGZ0NSBPTiAoZnQ0 LmMxID0gZnQ1LmMxKQpAQCAtMTM2NCw2ICsxMzY3LDkgQEAgVVBEQVRFIGZ0MiBTRVQgYzMgPSAn YmF6JwogICBGUk9NIGZ0NCBJTk5FUiBKT0lOIGZ0NSBPTiAoZnQ0LmMxID0gZnQ1LmMxKQogICBX SEVSRSBmdDIuYzEgPiAyMDAwIEFORCBmdDIuYzIgPT09IGZ0NC5jMQogICBSRVRVUk5JTkcgZnQy LiosIGZ0NC4qLCBmdDUuKjsKK1JFU0VUIGVuYWJsZV9uZXN0bG9vcDsKK0FMVEVSIFNFUlZFUiBs b29wYmFjayBPUFRJT05TIChkcm9wIGZkd19zdGFydHVwX2Nvc3QpOworQUxURVIgU0VSVkVSIGxv b3BiYWNrIE9QVElPTlMgKGRyb3AgZmR3X3R1cGxlX2Nvc3QpOwogRVhQTEFJTiAodmVyYm9zZSwg Y29zdHMgb2ZmKQogREVMRVRFIEZST00gZnQyCiAgIFVTSU5HIGZ0NCBJTk5FUiBKT0lOIGZ0NSBP TiAoZnQ0LmMxID09PSBmdDUuYzEpCg== --=_f6db2fcd6c178286eaf174cd746e5bb2--