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 1nnqKE-0000Ud-AG for pgsql-bugs@arkaria.postgresql.org; Sun, 08 May 2022 23:28:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nnqKB-0008HD-Cs for pgsql-bugs@arkaria.postgresql.org; Sun, 08 May 2022 23:28:27 +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 1nnp8J-0005Wt-5s for pgsql-bugs@lists.postgresql.org; Sun, 08 May 2022 22:12:07 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nnp8H-0004oB-Jn for pgsql-bugs@lists.postgresql.org; Sun, 08 May 2022 22:12: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=S9Dxc3d7Amb6FgYssPTB6G8eSSfBjAmkodIAFSSaIPE=; b=mR9yDdPfOb8RBvqGVQD0psEVhy cYGnnYtlSB5cv8BwCZGXmKI6rVOaj8e+5kUNJM9CcLzV9digcHZsz2rP4mxV3bOflx0zwMb5DD8YK ApFs/pyao3AGKKsOClAWjeP0GF88DTg5brNsHC4qUgs9IoXLwQfIq0tRwWzYS0Uk/d0KnQHKD3vXe /SJ/S7v+CZpvSDy62AnYmSVG8L0QVx5fvvLSYT3czexnMzGaQuqYJ6KhwM+2Of8ZZDbn5zOUFOfC6 oqsWNs09hDiAR0lA47/RglrKi26Xr3E5GXly76aIw921krnuvB3vI5EmnvqFhxyUSEg1f6JavFR0F D4nDDYeg==; 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 1nnp8F-0007YG-L2 for pgsql-bugs@lists.postgresql.org; Sun, 08 May 2022 22:12: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 1nnp8F-002VWT-ME for pgsql-bugs@lists.postgresql.org; Sun, 08 May 2022 22:12:02 +0000 Content-Type: multipart/mixed; boundary="===============7443584256650994511==" MIME-Version: 1.0 Subject: BUG #17476: ERROR: "variable not found in subplan target list" when running SELECT COUNT(*) To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: milos.urbanek@email.cz Reply-To: milos.urbanek@email.cz, pgsql-bugs@lists.postgresql.org Date: Sun, 08 May 2022 22:11:03 +0000 Message-ID: <17476-cf579fc6b204baa2@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 --===============7443584256650994511== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzQ3NgpMb2dnZWQgYnk6ICAgICAgICAgIE1pbG9zIFVyYmFuZWsKRW1h aWwgYWRkcmVzczogICAgICBtaWxvcy51cmJhbmVrQGVtYWlsLmN6ClBvc3RncmVTUUwgdmVyc2lv bjogMTQuMgpPcGVyYXRpbmcgc3lzdGVtOiAgIFdpbmRvd3MgMjAxMiBSMiBGb3VuZGF0aW9uCkRl c2NyaXB0aW9uOiAgICAgICAgCgpUcnlpbmcgdG8gcnVuIHNpbXBsZSBTRUxFQ1QgQ09VTlQoKikg ZnJvbSBzb21lIHRhYmxlIGdpdmVzIG1lIHRoZSBmb2xsb3dpbmcKZXJyb3IgKGVpdGhlciBydW5u aW5nIGJ5IGhhbmQgb3IgdHJ5aW5nIHRvIHJ1biBFWFBMQUlOIHVzaW5nIHBnYWRtaW4gb3IgYnkK aGFuZCk6DQoNCjIwMjItMDUtMDkgMDA6MDY6MzAuNDI4IENFU1QgWzExOTZdIEVSUk9SOiAgdmFy aWFibGUgbm90IGZvdW5kIGluIHN1YnBsYW4KdGFyZ2V0IGxpc3QNCjIwMjItMDUtMDkgMDA6MDY6 MzAuNDI4IENFU1QgWzExOTZdIFNUQVRFTUVOVDogIFNFTEVDVCBDT1VOVCgqKSBGUk9NCiJkb21p bm9fZWZla3R5X2hhdmFyaWpuaXByb2pldiINCjIwMjItMDUtMDkgMDA6MDY6MzEuODg0IENFU1Qg WzExOTZdIEVSUk9SOiAgdmFyaWFibGUgbm90IGZvdW5kIGluIHN1YnBsYW4KdGFyZ2V0IGxpc3QN CjIwMjItMDUtMDkgMDA6MDY6MzEuODg0IENFU1QgWzExOTZdIFNUQVRFTUVOVDogIEVYUExBSU4g KEZPUk1BVCBKU09OLApBTkFMWVpFIGZhbHNlLCBWRVJCT1NFIGZhbHNlLCBDT1NUUyBmYWxzZSwg VElNSU5HIGZhbHNlLCBCVUZGRVJTIGZhbHNlLApTVU1NQVJZIGZhbHNlLCBTRVRUSU5HUyBmYWxz ZSkgU0VMRUNUIENPVU5UKCopIEZST00KImRvbWlub19lZmVrdHlfaGF2YXJpam5pcHJvamV2Ig0K MjAyMi0wNS0wOSAwMDowNjozOS44MjAgQ0VTVCBbMTE5Nl0gRVJST1I6ICB2YXJpYWJsZSBub3Qg Zm91bmQgaW4gc3VicGxhbgp0YXJnZXQgbGlzdA0KMjAyMi0wNS0wOSAwMDowNjozOS44MjAgQ0VT VCBbMTE5Nl0gU1RBVEVNRU5UOiAgRVhQTEFJTiBTRUxFQ1QgQ09VTlQoKikgRlJPTQoiZG9taW5v X2VmZWt0eV9oYXZhcmlqbmlwcm9qZXYiDQoNCkRpZmZlcmVuY2VzIGFnYWluc3Qgc3RhbmRhcmQg Y29uZmlnOg0Kc2hhcmVkX2J1ZmZlcnMgPSA4MTkyTUINCmVmZmVjdGl2ZV9jYWNoZV9zaXplID0g MTZHQg0KY3Vyc29yX3R1cGxlX2ZyYWN0aW9uID0gMS4wCgo= --===============7443584256650994511==--