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 1mdtLO-0001Qj-Mw for pgsql-bugs@arkaria.postgresql.org; Fri, 22 Oct 2021 12:08:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mdtLN-0007mB-6g for pgsql-bugs@arkaria.postgresql.org; Fri, 22 Oct 2021 12:08:17 +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 1mdilB-0005AD-BO for pgsql-bugs@lists.postgresql.org; Fri, 22 Oct 2021 00:50:13 +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 1mdil4-0001sf-Ku for pgsql-bugs@lists.postgresql.org; Fri, 22 Oct 2021 00:50:13 +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=uQ386sksCIh897v3O5rI9qCe/M6nCMtsY4NRNeHyULw=; b=lqlgHC5Sd9zd5JSb8YZpSvwQS8 UZXQYqb4YhKxS2CpiMsostlUkMdFrGXInOmacpjw7NBoju8LQjN6zH0ju/TZMVB6KWU0y+HKu7PMY V6TpweHUk7bG/J8BNfX5Kce3+PyFEJnQS2qjLiHS1YVe2oxchSevsmucYxbDcyX/VUAwgNwlmU6H1 tpgp97vVxcGRozBeJFMlNpwDWNH0mdzgQ6XJuBsVcJo90rReG1mIJecdR80EHlu5x2GVdq1zeRa54 s4diF6F5NoxOO+gZlevE3PpNMa9uYjAX/G/m//wEcIvuzG82IIEmGpYgbIpySnnO5TtmXqKLW2fqE YL0g+Kew==; 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 1mdil3-0003yo-7E for pgsql-bugs@lists.postgresql.org; Fri, 22 Oct 2021 00:50:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mdil0-0007C9-7m for pgsql-bugs@lists.postgresql.org; Fri, 22 Oct 2021 00:50:02 +0000 Content-Type: multipart/mixed; boundary="===============8540430454683225165==" MIME-Version: 1.0 Subject: BUG #17243: explain wtih recursive cte error? To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: mark.a.sloan@gmail.com Reply-To: mark.a.sloan@gmail.com, pgsql-bugs@lists.postgresql.org Date: Fri, 22 Oct 2021 00:49:41 +0000 Message-ID: <17243-45ee0e3a03063b9b@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 --===============8540430454683225165== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzI0MwpMb2dnZWQgYnk6ICAgICAgICAgIG1hcmsgc2xvYW4KRW1haWwg YWRkcmVzczogICAgICBtYXJrLmEuc2xvYW5AZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjog MTQuMApPcGVyYXRpbmcgc3lzdGVtOiAgIE1hY09TCkRlc2NyaXB0aW9uOiAgICAgICAgCgpTZWVp bmcgYSBpc3N1ZSB3aXRoICdFWFBMQUlOJyB0aHJvd2luZyBhbiBlcnJvciBvbiBhIHF1ZXJ5IHRo YXQgb3RoZXJ3aXNlCnJ1bnMgd2l0aG91dCBpc3N1ZS4gDQoNCmV4YW1wbGUgcXVlcnkgY2FzZS4g DQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCnNlbGVjdCB4 LnYgaW50byBleHBsYWluY3RlYnVnIGZyb20gKHZhbHVlcygnZm9vJyksKCdiYXInKSwoJ2Jheicp KSBhcwp4KHYpOw0KDQpxdWVyeToNCg0Kd2l0aCByZWN1cnNpdmUgYSBhcyANCigNCiAgICBzZWxl Y3QgdiwgJycgYXMgeCwgMCBhcyBuIGZyb20gZXhwbGFpbmN0ZWJ1ZyANCiAgICB1bmlvbiBhbGwN CiAgICBzZWxlY3Qgdiwgc3Vic3RyaW5nKHYsbisxLDEpIGFzIHgsIG4rMSBhcyBuIGZyb20gYSB3 aGVyZSBuIDwgbGVuZ3RoKHYpDQopDQpzZWxlY3QgeCwgY291bnQoKikgZnJvbSBhIHdoZXJlIG4g PiAwDQpncm91cCBieSB4IG9yZGVyIGJ5IGNvdW50KCopIGRlc2M7DQoNCg0KcmV0dXJucy4gDQoN CiB4IHwgY291bnQgDQotLS0rLS0tLS0tLQ0KIGEgfCAgICAgMg0KIGIgfCAgICAgMg0KIG8gfCAg ICAgMg0KIHIgfCAgICAgMQ0KIHogfCAgICAgMQ0KIGYgfCAgICAgMQ0KKDYgcm93cykNCg0KLS0t LS0tLS0NCg0KIEVYUExBSU4gdmVyYm9zZSB3aXRoIHJlY3Vyc2l2ZSBhIGFzIA0KKA0KICAgIHNl bGVjdCB2LCAnJyBhcyB4LCAwIGFzIG4gZnJvbSBleHBsYWluY3RlYnVnIA0KICAgIHVuaW9uIGFs bA0KICAgIHNlbGVjdCB2LCBzdWJzdHJpbmcodixuKzEsMSkgYXMgeCwgbisxIGFzIG4gZnJvbSBh IHdoZXJlIG4gPCBsZW5ndGgodikNCikNCnNlbGVjdCB4LCBjb3VudCgqKSBmcm9tIGEgd2hlcmUg biA+IDANCmdyb3VwIGJ5IHggb3JkZXIgYnkgY291bnQoKikgZGVzYyA7DQoNCg0KcmV0dXJucyAN Cg0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgUVVFUlkgUExBTiAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgIA0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tDQogU29ydCAgKGNvc3Q9NTgzNS4zNi4uNTgzNS44NiByb3dzPTIwMCB3aWR0aD00MCkN CiAgIE91dHB1dDogYS54LCAoY291bnQoKikpDQogICBTb3J0IEtleTogKGNvdW50KCopKSBERVND DQogICBDVEUgYQ0KICAgICAtPiAgUmVjdXJzaXZlIFVuaW9uICAoY29zdD0wLjAwLi40Njk3LjM3 IHJvd3M9NDY2OTAgd2lkdGg9NjgpDQogICAgICAgICAgIC0+ICBTZXEgU2NhbiBvbiBwdWJsaWMu ZXhwbGFpbmN0ZWJ1ZyAgKGNvc3Q9MC4wMC4uMjMuNjAgcm93cz0xMzYwCndpZHRoPTY4KQ0KICAg ICAgICAgICAgICAgICBPdXRwdXQ6IGV4cGxhaW5jdGVidWcudiwgJyc6OnRleHQsIDANCiAgICAg ICAgICAgLT4gIFdvcmtUYWJsZSBTY2FuIG9uIGEgYV8xICAoY29zdD0wLjAwLi4zNzQuMDAgcm93 cz00NTMzCndpZHRoPTY4KQ0KICAgICAgICAgICAgICAgICBPdXRwdXQ6IGFfMS52LCAic3Vic3Ry aW5nIihhXzEudiwgKGFfMS5uICsgMSksIDEpLCAoYV8xLm4gKwoxKQ0KICAgICAgICAgICAgICAg ICBGaWx0ZXI6IChhXzEubiA8IGxlbmd0aChhXzEudikpDQogICAtPiAgSGFzaEFnZ3JlZ2F0ZSAg KGNvc3Q9MTEyOC4zNC4uMTEzMC4zNCByb3dzPTIwMCB3aWR0aD00MCkNCiAgICAgICAgIE91dHB1 dDogYS54LCBjb3VudCgqKQ0KICAgICAgICAgR3JvdXAgS2V5OiBhLngNCiAgICAgICAgIC0+ICBD VEUgU2NhbiBvbiBhICAoY29zdD0wLjAwLi4xMDUwLjUyIHJvd3M9MTU1NjMgd2lkdGg9MzIpDQog ICAgICAgICAgICAgICBPdXRwdXQ6IGEudiwgYS54LCBhLm4NCiAgICAgICAgICAgICAgIEZpbHRl cjogKGEubiA+IDApDQooMTYgcm93cykNCg0KDQoNCkVYUExBSU4gIHdpdGggcmVjdXJzaXZlIGEg YXMgDQooDQogICAgc2VsZWN0IHYsICcnIGFzIHgsIDAgYXMgbiBmcm9tIGV4cGxhaW5jdGVidWcg DQogICAgdW5pb24gYWxsDQogICAgc2VsZWN0IHYsIHN1YnN0cmluZyh2LG4rMSwxKSBhcyB4LCBu KzEgYXMgbiBmcm9tIGEgd2hlcmUgbiA8IGxlbmd0aCh2KQ0KKQ0Kc2VsZWN0IHgsIGNvdW50KCop IGZyb20gYSB3aGVyZSBuID4gMA0KZ3JvdXAgYnkgeCBvcmRlciBieSBjb3VudCgqKSBkZXNjIDsN Cg0KcmV0dXJucy4gDQoNCkVSUk9SOiAgY291bGQgbm90IGZpbmQgUmVjdXJzaXZlVW5pb24gZm9y IFdvcmtUYWJsZVNjYW4gd2l0aCB3dFBhcmFtIDANCg0KDQoNCnRoaXMgc2VlbXMgbGlrZSBpdCBt aWdodCBiZSBhIGJ1Zz8NCg0KIFBvc3RncmVTUUwgMTQuMCBvbiB4ODZfNjQtYXBwbGUtZGFyd2lu MjAuNi4wLCBjb21waWxlZCBieSBBcHBsZSBjbGFuZwp2ZXJzaW9uIDEzLjAuMCAoY2xhbmctMTMw MC4wLjI5LjMpLCA2NC1iaXQKCg== --===============8540430454683225165==--