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-Pt 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-001oEE-3G 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 1u18mO-001lMZ-1W for pgsql-committers@lists.postgresql.org; Sat, 05 Apr 2025 19:02:08 +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-003agV-1A for pgsql-committers@lists.postgresql.org; Sat, 05 Apr 2025 19:02:07 +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-000epF-Dz 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-002qny-2g for pgsql-committers@lists.postgresql.org; Sat, 05 Apr 2025 19:01:59 +0000 Content-Type: multipart/mixed; boundary="===============2798146449120347986==" 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 --===============2798146449120347986== 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 cm91Z2g6IDEzCgpCcmFuY2gKLS0tLS0tClJFTF8xNF9TVEFCTEUKCkRldGFpbHMKLS0tLS0tLQpo dHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzc1NGEzZDgyZDc5Y2MzZDcw NDBjZmFkYWY5YzhjZDE1Nzk2ODRlZTYKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNy Yy9iYWNrZW5kL3BhcnNlci9wYXJzZV9jdGUuYyAgICAgfCAxMzkgKysrKysrKysrKysrKysrKysr KysrKysrKy0tLS0tLS0tLS0tLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3dpdGgub3V0IHwg ICA4ICsrKwpzcmMvdGVzdC9yZWdyZXNzL3NxbC93aXRoLnNxbCAgICAgIHwgICA3ICsrCjMgZmls ZXMgY2hhbmdlZCwgMTExIGluc2VydGlvbnMoKyksIDQzIGRlbGV0aW9ucygtKQoK --===============2798146449120347986==--