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 1mO06w-00088f-3d for pgsql-committers@arkaria.postgresql.org; Wed, 08 Sep 2021 16:07:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mO06v-0001gu-3j for pgsql-committers@arkaria.postgresql.org; Wed, 08 Sep 2021 16:07:41 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mO05j-0006tw-Dh for pgsql-committers@lists.postgresql.org; Wed, 08 Sep 2021 16:06:27 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mO05f-0000QC-82 for pgsql-committers@lists.postgresql.org; Wed, 08 Sep 2021 16:06:26 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mO05c-0000j1-Q3 for pgsql-committers@lists.postgresql.org; Wed, 08 Sep 2021 16:06:20 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mO05c-0000N1-80 for pgsql-committers@lists.postgresql.org; Wed, 08 Sep 2021 16:06:20 +0000 Content-Type: multipart/mixed; boundary="===============6736533926952175747==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix rewriter to set hasModifyingCTE correctly on rewritten queri X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 08 Sep 2021 16:06:20 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6736533926952175747== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IHJld3JpdGVyIHRvIHNldCBoYXNNb2RpZnlpbmdDVEUgY29ycmVjdGx5IG9uIHJld3JpdHRl biBxdWVyaWVzLgoKSWYgd2UgY29weSBkYXRhLW1vZGlmeWluZyBDVEVzIGZyb20gdGhlIG9yaWdp bmFsIHF1ZXJ5IHRvIGEgcmVwbGFjZW1lbnQKcXVlcnkgKGZyb20gYSBETyBJTlNURUFEIHJ1bGUp LCB3ZSBtdXN0IHNldCBoYXNNb2RpZnlpbmdDVEUgcHJvcGVybHkKaW4gdGhlIHJlcGxhY2VtZW50 IHF1ZXJ5LiAgRmFpbHVyZSB0byBkbyB0aGlzIGNhbiBjYXVzZSB2YXJpb3VzCnVucGxlYXNhbnRu ZXNzLCBzdWNoIGFzIHVuc2FmZSB1c2FnZSBvZiBwYXJhbGxlbCBwbGFucy4gIFRoZSBjb2RlIGFs c28KbmVnbGVjdGVkIHRvIHByb3BhZ2F0ZSBoYXNSZWN1cnNpdmUsIHRob3VnaCB0aGF0J3Mgb25s eSBjb3NtZXRpYyBhdAp0aGUgbW9tZW50LgoKQSBkaWZmaWN1bHR5IGFyaXNlcyBpZiB0aGUgcnVs ZSBhY3Rpb24gaXMgYW4gSU5TRVJULi4uU0VMRUNULiAgV2UKYXR0YWNoIHRoZSBvcmlnaW5hbCBx dWVyeSdzIFJURXMgYW5kIENURXMgdG8gdGhlIHN1Yi1TRUxFQ1QgUXVlcnksIGJ1dApkYXRhLW1v ZGlmeWluZyBDVEVzIGFyZSBvbmx5IGFsbG93ZWQgdG8gYXBwZWFyIGluIHRoZSB0b3Btb3N0IFF1 ZXJ5LgpGb3IgdGhlIG1vbWVudCwgdGhyb3cgYW4gZXJyb3IgaW4gc3VjaCBjYXNlcy4gIEl0IHdv dWxkIHByb2JhYmx5IGJlCnBvc3NpYmxlIHRvIGF2b2lkIHRoaXMgZXJyb3IgYnkgYXR0YWNoaW5n IHRoZSBDVEVzIHRvIHRoZSB0b3AgSU5TRVJUClF1ZXJ5IGluc3RlYWQ7IGJ1dCB0aGF0IHdvdWxk IHJlcXVpcmUgYSBidW5jaCBvZiBuZXcgY29kZSB0byBhZGp1c3QKY3RlbGV2ZWxzdXAgcmVmZXJl bmNlcy4gIEdpdmVuIHRoZSBuYXJyb3duZXNzIG9mIHRoZSB1c2UtY2FzZSwgYW5kCnRoZSBuZWVk IHRvIGJhY2stcGF0Y2ggdGhpcyBmaXgsIGl0IGRvZXMgbm90IHNlZW0gd29ydGggdGhlIHRyb3Vi bGUKZm9yIG5vdy4gIFdlIGNhbiByZXZpc2l0IHRoaXMgaWYgd2UgZ2V0IGZpZWxkIGNvbXBsYWlu dHMuCgpQZXIgcmVwb3J0IGZyb20gR3JlZyBOYW5jYXJyb3cuICBCYWNrLXBhdGNoIHRvIGFsbCBz dXBwb3J0ZWQgYnJhbmNoZXMuCihUaGUgdGVzdCBjYXNlIGFkZGVkIGhlcmUgZG9lcyBub3QgZmFp bCBiZWZvcmUgdjEwLCBidXQgdGhlcmUgYXJlCnBsZW50eSBvZiBwbGFjZXMgY2hlY2tpbmcgdG9w LWxldmVsIGhhc01vZGlmeWluZ0NURSBpbiA5LjYsIHNvIEkgaGF2ZQpubyBkb3VidCB0aGF0IHRo aXMgY29kZSBjaGFuZ2UgaXMgbmVjZXNzYXJ5IHRoZXJlIHRvby4pCgpHcmVnIE5hbmNhcnJvdyBh bmQgVG9tIExhbmUKCkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vQ0FKY09mLWY2OERU PTI2WUFNel9pMCtBdTNUY0xPNW9pSFk1PWZMNlNmdWl0czZyK193QG1haWwuZ21haWwuY29tCkRp c2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vQ0FKY09mLWZBZGo9bkRLTXNSaFF6bmRtLU8x M05ZNGRMNnhHY0V2ZFg1WHZiYmkwVjdnQG1haWwuZ21haWwuY29tCgpCcmFuY2gKLS0tLS0tClJF TF8xMV9TVEFCTEUKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9w Zy9jb21taXRkaWZmLzg4MmI3ZTcyODgzNTNhZDA3ZTk0MTlmZmU2Mjc0M2M1NTJiODAwOGQKCk1v ZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL3Jld3JpdGUvcmV3cml0ZUhh bmRsZXIuYyB8IDIzICsrKysrKysrKysrKysrKysrKysrKysKc3JjL3Rlc3QvcmVncmVzcy9leHBl Y3RlZC93aXRoLm91dCAgIHwgMzcgKysrKysrKysrKysrKysrKysrKysrKysrKysrKysrKysrKyst CnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL3dpdGguc3FsICAgICAgICB8IDI3ICsrKysrKysrKysrKysr KysrKysrKysrKystCjMgZmlsZXMgY2hhbmdlZCwgODUgaW5zZXJ0aW9ucygrKSwgMiBkZWxldGlv bnMoLSkKCg== --===============6736533926952175747==--