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 1u18pT-00EoBm-JR for pgsql-committers@arkaria.postgresql.org; Sat, 05 Apr 2025 19:05:19 +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 1u18pS-001oE8-1b for pgsql-committers@arkaria.postgresql.org; Sat, 05 Apr 2025 19:05:18 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u18mM-001l2L-0c for pgsql-committers@lists.postgresql.org; Sat, 05 Apr 2025 19:02:06 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u18mJ-003agU-0w for pgsql-committers@lists.postgresql.org; Sat, 05 Apr 2025 19:02:05 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u18mG-000epC-H1 for pgsql-committers@lists.postgresql.org; Sat, 05 Apr 2025 19:02:00 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1u18mF-002qnr-2V for pgsql-committers@lists.postgresql.org; Sat, 05 Apr 2025 19:01:59 +0000 Content-Type: multipart/mixed; boundary="===============4177845371794224062==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix parse_cte.c's failure to examine sub-WITHs in DML statements X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sat, 05 Apr 2025 19:01:59 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4177845371794224062== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IHBhcnNlX2N0ZS5jJ3MgZmFpbHVyZSB0byBleGFtaW5lIHN1Yi1XSVRIcyBpbiBETUwgc3Rh dGVtZW50cy4KCm1ha2VEZXBlbmRlbmN5R3JhcGhXYWxrZXIgdGhvdWdodCB0aGF0IG9ubHkgU2Vs ZWN0U3RtdCBub2RlcyBjb3VsZApjb250YWluIGEgV2l0aENsYXVzZS4gIFdoaWNoIHdhcyB0cnVl IGluIG91ciBvcmlnaW5hbCBpbXBsZW1lbnRhdGlvbgpvZiBXSVRILCBidXQgYXN0b25pc2hpbmds eSB3ZSBtaXNzZWQgdXBkYXRpbmcgdGhpcyBjb2RlIHdoZW4gd2UgYWRkZWQKdGhlIGFiaWxpdHkg dG8gYXR0YWNoIFdJVEggdG8gSU5TRVJUL1VQREFURS9ERUxFVEUgKGFuZCBsYXRlciBNRVJHRSku Ck1vcmVvdmVyLCBzaW5jZSBpdCB3YXMgY29kZWQgdG8gZGVsaWJlcmF0ZWx5IGJsb2NrIHJlY3Vy c2lvbiB0byBhCldpdGhDbGF1c2UsIGV2ZW4gdXBkYXRpbmcgcmF3X2V4cHJlc3Npb25fdHJlZV93 YWxrZXIgZGlkbid0IHNhdmUgaXQuCgpUaGUgdXBzaG90IG9mIHRoaXMgd2FzIHRoYXQgd2UgZGlk bid0IHNlZSByZWZlcmVuY2VzIHRvIG91dGVyIENURQpuYW1lcyBhcHBlYXJpbmcgd2l0aGluIGFu IGlubmVyIFdJVEgsIGFuZCB3b3VsZCBuZWl0aGVyIGNvbXBsYWluIGFib3V0CmRpc2FsbG93ZWQg cmVjdXJzaW9uIG5vciBhY2NvdW50IGZvciBzdWNoIHJlZmVyZW5jZXMgd2hlbiBzb3J0aW5nIENU RXMKaW50byBhIHVzYWJsZSBvcmRlci4gIFRoZSBsYWNrIG9mIGNvbXBsYWludHMgYWJvdXQgdGhp cyBpcyBwZXJoYXBzIG5vdApzbyBzdXJwcmlzaW5nLCBiZWNhdXNlIHR5cGljYWwgdXNhZ2Ugb2Yg V0lUSCB3b3VsZG4ndCBoaXQgZWl0aGVyIGNhc2UuClN0aWxsLCBpdCdzIHByZXR0eSBicm9rZW47 IGZhaWxpbmcgdG8gZGV0ZWN0IHJlY3Vyc2lvbiBoZXJlIGxlYWRzIHRvCmFzc2VydCBmYWlsdXJl cyBvciB3b3JzZSBsYXRlciBvbi4KCkZpeCBieSBmYWN0b3Jpbmcgb3V0IHRoZSBwcm9jZXNzaW5n IG9mIHN1Yi1XSVRIcyBpbnRvIGEgbmV3IGZ1bmN0aW9uCldhbGtJbm5lcldpdGgsIGFuZCBpbnZv a2luZyB0aGF0IGZvciBhbGwgdGhlIHN0YXRlbWVudCB0eXBlcyB0aGF0CmNhbiBoYXZlIFdJVEgu CgpCdWc6ICMxODg3OApSZXBvcnRlZC1ieTogWXUgTGlhbmcgPGx1eTcwQHBzdS5lZHU+CkF1dGhv cjogVG9tIExhbmUgPHRnbEBzc3MucGdoLnBhLnVzPgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rn ci5lcy9tLzE4ODc4LWEyNmZhNWFiNmJlMmYyY2ZAcG9zdGdyZXNxbC5vcmcKQmFja3BhdGNoLXRo cm91Z2g6IDEzCgpCcmFuY2gKLS0tLS0tClJFTF8xN19TVEFCTEUKCkRldGFpbHMKLS0tLS0tLQpo dHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzVlN2JlNDNmNGI4YmZlNzc1 NzBlNTY2Yjg5ZjIzZmM3M2VhNjI1ZGMKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNy Yy9iYWNrZW5kL3BhcnNlci9wYXJzZV9jdGUuYyAgICAgfCAxNTIgKysrKysrKysrKysrKysrKysr KysrKysrKystLS0tLS0tLS0tLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3dpdGgub3V0IHwg ICA4ICsrCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL3dpdGguc3FsICAgICAgfCAgIDcgKysKMyBmaWxl cyBjaGFuZ2VkLCAxMjQgaW5zZXJ0aW9ucygrKSwgNDMgZGVsZXRpb25zKC0pCgo= --===============4177845371794224062==--