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 1rpSjZ-006rFz-9X for pgsql-bugs@arkaria.postgresql.org; Wed, 27 Mar 2024 12:50:26 +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 1rpSjX-00EM50-EO for pgsql-bugs@arkaria.postgresql.org; Wed, 27 Mar 2024 12:50:23 +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 1rpScW-00EJW8-Md for pgsql-bugs@lists.postgresql.org; Wed, 27 Mar 2024 12:43: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 1rpScS-006heX-G7 for pgsql-bugs@lists.postgresql.org; Wed, 27 Mar 2024 12:43: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=hdDeDLE/UP0khQFV/gHeHGVfYkduDM4RMTKgNEX07HA=; b=1V1HEZnF5huvu1NhQK1R7GUDgq mdfMlJ2RIcZdVEmekS1GvMG1AUEkjAgi3xOiTa+6ARG/W+HESWQHMhaGPDs1sF7rji+EfNI1fS4Mi v2CsZuP9vaLsGco4lKf9AlkjrjCRpAczRAGaiJqsdDrpE3vzM5+QC50YTU3z7Ig+v1HUvfLyURoza c3j5PBZcPMXRsfXaa4/VKNgQ+lisiAGd3tkvxxvbutWs7GSPAx3D/fOoP0BXqc67qx3SzqKUw+obe 5mytwayOMSVwxRfn677+ubJrIfD/D/ZCduErG3kZ34ukuGMPtDiv1Xmqk1BTQ1RxZGS9mGXRIgBqW RipxWqqA==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rpScS-0013ud-JM for pgsql-bugs@lists.postgresql.org; Wed, 27 Mar 2024 12:43: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 1rpScP-009qax-U4 for pgsql-bugs@lists.postgresql.org; Wed, 27 Mar 2024 12:43:03 +0000 Content-Type: multipart/mixed; boundary="===============3965365045442987342==" MIME-Version: 1.0 Subject: BUG #18410: SQL Error [XX000]: ERROR: variable not found in subplan target list To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: fernando.asulay@es.abb.com Reply-To: fernando.asulay@es.abb.com, pgsql-bugs@lists.postgresql.org Date: Wed, 27 Mar 2024 12:42:33 +0000 Message-ID: <18410-b6ad04652311ce33@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 --===============3965365045442987342== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODQxMApMb2dnZWQgYnk6ICAgICAgICAgIEZlcm5hbmRvIEFzdWxheQpF bWFpbCBhZGRyZXNzOiAgICAgIGZlcm5hbmRvLmFzdWxheUBlcy5hYmIuY29tClBvc3RncmVTUUwg dmVyc2lvbjogMTYuMgpPcGVyYXRpbmcgc3lzdGVtOiAgIFRpbWVzY2FsZURCIGxpbnV4IERvY2tl ciAgaW1hZ2UKRGVzY3JpcHRpb246ICAgICAgICAKClRoZSBpc3N1ZSB3YXMgZm91bmQgdG8gaGFw cGVuZCBvbiB0aW1lc2NhbGVkYiBleHRlbnNpb24gaHlwZXJ0YWJsZXMgdXNpbmcKcG9zdGdyZXMg MTQgYW5kIGFib3ZlLiBXZSB0ZXN0ZWQgZGlmZmVyZW50IHZlcnNpb24gb2YgdGltZXNjYWxlZGIg YW5kCmRvZXNuJ3Qgc2VlbSB0byB0YWtlIGFueSBlZmZlY3QuIE9ubHkgY2hhbmdpbmcgcGcgdmVy c2lvbiBmcm9tIDEzIHRvIDE0Lg0KDQpUZXN0ZWQgdXNpbmcgaW1hZ2VzIGZyb20KaHR0cHM6Ly9o dWIuZG9ja2VyLmNvbS9yL3RpbWVzY2FsZS90aW1lc2NhbGVkYi90YWdzDQoNClRvIHJlcHJvZHVj ZSB0aGUgZXJyb3I6DQoNClRoZSBmb2xsb3dpbmcgY29tcG9zZSB3YXMgdXNlZDoNCg0KdmVyc2lv bjogIjMuNSINCnNlcnZpY2VzOg0KICB3b3JrczoNCiAgICBpbWFnZTogdGltZXNjYWxlL3RpbWVz Y2FsZWRiOjIuMTQuMi1wZzEzDQogICAgY29udGFpbmVyX25hbWU6IHdvcmtzDQogICAgcmVzdGFy dDogYWx3YXlzDQogICAgZW52aXJvbm1lbnQ6DQogICAgICBQT1NUR1JFU19VU0VSOiBhZG1pbg0K ICAgICAgUE9TVEdSRVNfUEFTU1dPUkQ6IHBhc3N3b3JkDQogICAgcG9ydHM6DQogICAgICAtICI1 NDMyOjU0MzIiDQogIA0KICBkb2VzbnR3b3JrOg0KICAgIGltYWdlOiB0aW1lc2NhbGUvdGltZXNj YWxlZGI6Mi4xNC4yLXBnMTQNCiAgICBjb250YWluZXJfbmFtZTogZG9lc250d29yaw0KICAgIGVu dmlyb25tZW50Og0KICAgICAgUE9TVEdSRVNfVVNFUjogYWRtaW4NCiAgICAgIFBPU1RHUkVTX1BB U1NXT1JEOiBwYXNzd29yZA0KICAgIHBvcnRzOg0KICAgICAgICAtICI1NDMzOjU0MzIiDQoNCiAg ZG9lc250d29ya2VpdGhlcjoNCiAgICBpbWFnZTogdGltZXNjYWxlL3RpbWVzY2FsZWRiOjIuMTQu Mi1wZzE2DQogICAgY29udGFpbmVyX25hbWU6IGRvZXNudHdvcmtlaXRoZXINCiAgICBlbnZpcm9u bWVudDoNCiAgICAgIFBPU1RHUkVTX1VTRVI6IGFkbWluDQogICAgICBQT1NUR1JFU19QQVNTV09S RDogcGFzc3dvcmQNCiAgICBwb3J0czoNCiAgICAgICAgLSAiNTQzNDo1NDMyIg0KDQoNCmNvbm5l Y3QgdG8gImRvZXNudHdvcmsiIG9yICJkb2VzbnR3b3JrZWl0aGVyIiBjb250YWluZXJzIGFuZCBy dW4gdGhlCmZvbGxvd2luZyBTUUw6DQoNCi0tIENyZWF0ZSB0ZXN0IHRhYmxlDQpDUkVBVEUgVEFC TEUgcHVibGljLnRlc3QxKA0KICAgIGlkIHRleHQgTk9UIG51bGwsDQogICAgY3JlYXRlZCB0aW1l c3RhbXB0eiBOT1QgTlVMTA0KKTsNCi0tIE1ha2UgdGhlIHRhYmxlIGFuIHRpbWVzY2FsZWRiIGh5 cGVydGFibGUNClNFTEVDVCBjcmVhdGVfaHlwZXJ0YWJsZSgncHVibGljLnRlc3QxJywgJ2NyZWF0 ZWQnLCBjaHVua190aW1lX2ludGVydmFsID0+CmludGVydmFsJzQgZGF5cycpOw0KLS0gSW5zZXJ0 IHNvbWUgZGF0YQ0KSU5TRVJUIElOVE8gcHVibGljLnRlc3QxIFZBTFVFUyAoMSwgJzIwMjQtMDEt MDEnKTsNCi0tIFZlcmlmeSBkYXRhIGlzIGNvcnJlY2x0eSBpbnNlcnRlZA0KU0VMRUNUICogRlJP TSBwdWJsaWMudGVzdDE7DQotLSBSdW4gdGhlIHF1ZXJ5IHRvIHRyaWdnZXIgdGhlIGVycm9yIA0K REVMRVRFICBGUk9NDQogICAicHVibGljIi50ZXN0MQ0KV0hFUkUgDQogICAoRVhJU1RTIChTRUxF Q1QgMSkpOwoK --===============3965365045442987342==--