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 1q96c4-0006Xw-Bv for pgsql-bugs@arkaria.postgresql.org; Tue, 13 Jun 2023 16:11:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q96c2-0003er-O7 for pgsql-bugs@arkaria.postgresql.org; Tue, 13 Jun 2023 16:11:18 +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 1q96RE-000699-9y for pgsql-bugs@lists.postgresql.org; Tue, 13 Jun 2023 16:00:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1q96RB-00202H-Kt for pgsql-bugs@lists.postgresql.org; Tue, 13 Jun 2023 16:00:07 +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=KYAVXaWivQsRftXLwnrBTlElcR5L1wW7vUIXkmEpgpQ=; b=nk6/VZRLhJUpWnzI/WPCe0+qO3 KtMI7wqygCaFfCCMSJlhGwrrFzbucF0xr++cZh4G5ET6oCAj3ya0d5O/k/t8asAlHB+SDV6xBoNBY ESzzlUdwJz32lE3cRyOMJlOhfu3bYZlGcgR+5+q23IybrdEXyeoEWZJL3WJNtrFoWcOmNIjB37IvU tRsfF+ooCRGnMhJyLPzLL8Arl6mC1tBqWwgAj5COplo4WhE9cBBB/MlsWW2Z8OyPcvjk+uNfq3Qwf tPcIzeu+6OemWgo+bURNZrqqDedSF16n8u/9WRYy9D68UF86B9f17SlkAf++NJUB3UtbVsvywaX48 FHhteSbw==; 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 1q96RA-0000Mo-TQ for pgsql-bugs@lists.postgresql.org; Tue, 13 Jun 2023 16:00:05 +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 1q96R8-005aLp-06 for pgsql-bugs@lists.postgresql.org; Tue, 13 Jun 2023 16:00:03 +0000 Content-Type: multipart/mixed; boundary="===============3038717673285615335==" MIME-Version: 1.0 Subject: BUG #17972: Assert failed in pull_varattnos_walker() for view with subquery and security qual To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: exclusion@gmail.com Reply-To: exclusion@gmail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 13 Jun 2023 16:00:01 +0000 Message-ID: <17972-f422c094237847d0@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 --===============3038717673285615335== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzk3MgpMb2dnZWQgYnk6ICAgICAgICAgIEFsZXhhbmRlciBMYWtoaW4K RW1haWwgYWRkcmVzczogICAgICBleGNsdXNpb25AZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTZiZXRhMQpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAyMi4wNApEZXNjcmlwdGlvbjog ICAgICAgIAoKVGhlIGZvbGxvd2luZyBzY3JpcHQ6DQpDUkVBVEUgVEFCTEUgdDEoYSBpbnQpOw0K Q1JFQVRFIFZJRVcgdjEgV0lUSCAoc2VjdXJpdHlfYmFycmllciA9IHRydWUpIEFTIFNFTEVDVCBh IEZST00gdDE7DQpDUkVBVEUgUlVMRSB2MV91cGRfcnVsZSBBUyBPTiBVUERBVEUgVE8gdjEgRE8g SU5TVEVBRCBVUERBVEUgdDEgU0VUIGEgPQpORVcuYSBXSEVSRSBhID0gT0xELmE7DQpDUkVBVEUg VklFVyB2MiBXSVRIIChzZWN1cml0eV9iYXJyaWVyID0gdHJ1ZSkgQVMgU0VMRUNUIGEgRlJPTSB2 MSBXSEVSRQpFWElTVFMgKFNFTEVDVCAxKTsNCg0KVVBEQVRFIHYyIFNFVCBhID0gMTsNCg0KbGVh ZHMgdG8gYSBmYWlsZWQgYXNzZXJ0aW9uIHdpdGggdGhlIHN0YWNrIHRyYWNlOg0KQ29yZSB3YXMg Z2VuZXJhdGVkIGJ5IGBwb3N0Z3JlczogbGF3IHJlZ3Jlc3Npb24gW2xvY2FsXSBVUERBVEUgICAg ICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAnLg0KUHJvZ3JhbSB0ZXJtaW5hdGVk IHdpdGggc2lnbmFsIFNJR0FCUlQsIEFib3J0ZWQuDQoNCndhcm5pbmc6IFNlY3Rpb24gYC5yZWct eHN0YXRlLzMzMTQyODEnIGluIGNvcmUgZmlsZSB0b28gc21hbGwuDQojMCAgX19wdGhyZWFkX2tp bGxfaW1wbGVtZW50YXRpb24gKG5vX3RpZD0wLCBzaWdubz02LAp0aHJlYWRpZD0xNDAyODkxMTEw MjU2MDApIGF0IC4vbnB0bC9wdGhyZWFkX2tpbGwuYzo0NA0KNDQgICAgICAuL25wdGwvcHRocmVh ZF9raWxsLmM6IE5vIHN1Y2ggZmlsZSBvciBkaXJlY3RvcnkuDQooZ2RiKSBidA0KIzAgIF9fcHRo cmVhZF9raWxsX2ltcGxlbWVudGF0aW9uIChub190aWQ9MCwgc2lnbm89NiwKdGhyZWFkaWQ9MTQw Mjg5MTExMDI1NjAwKSBhdCAuL25wdGwvcHRocmVhZF9raWxsLmM6NDQNCiMxICBfX3B0aHJlYWRf a2lsbF9pbnRlcm5hbCAoc2lnbm89NiwgdGhyZWFkaWQ9MTQwMjg5MTExMDI1NjAwKSBhdAouL25w dGwvcHRocmVhZF9raWxsLmM6NzgNCiMyICBfX0dJX19fcHRocmVhZF9raWxsICh0aHJlYWRpZD0x NDAyODkxMTEwMjU2MDAsIHNpZ25vPXNpZ25vQGVudHJ5PTYpIGF0Ci4vbnB0bC9wdGhyZWFkX2tp bGwuYzo4OQ0KIzMgIDB4MDAwMDdmOTc5OWVlZTQ3NiBpbiBfX0dJX3JhaXNlIChzaWc9c2lnQGVu dHJ5PTYpIGF0Ci4uL3N5c2RlcHMvcG9zaXgvcmFpc2UuYzoyNg0KIzQgIDB4MDAwMDdmOTc5OWVk NDdmMyBpbiBfX0dJX2Fib3J0ICgpIGF0IC4vc3RkbGliL2Fib3J0LmM6NzkNCiM1ICAweDAwMDA1 NWU4YzliYzlhMjkgaW4gRXhjZXB0aW9uYWxDb25kaXRpb24gKGNvbmRpdGlvbk5hbWU9MHg1NWU4 Y2E0N2VjNDAKIiFJc0Eobm9kZSwgUXVlcnkpIiwgDQogICAgZmlsZU5hbWU9MHg1NWU4Y2E0N2Vi ZTAgInZhci5jIiwgbGluZU51bWJlcj0zMjApIGF0IGFzc2VydC5jOjY2DQojNiAgMHgwMDAwNTVl OGM5MDQ1ODY1IGluIHB1bGxfdmFyYXR0bm9zX3dhbGtlciAobm9kZT0weDYyOTAwMDAzNWRhMCwK Y29udGV4dD0weDdmZmUzZGZkZDgwMCkgYXQgdmFyLmM6MzIwDQojNyAgMHgwMDAwNTVlOGM4YzE5 NGIxIGluIGV4cHJlc3Npb25fdHJlZV93YWxrZXJfaW1wbCAobm9kZT0weDYyZDAwMDA2ZjNkMCwK DQogICAgd2Fsa2VyPTB4NTVlOGM5MDQ1NGI5IDxwdWxsX3ZhcmF0dG5vc193YWxrZXI+LCBjb250 ZXh0PTB4N2ZmZTNkZmRkODAwKQphdCBub2RlRnVuY3MuYzoyMTQ0DQojOCAgMHgwMDAwNTVlOGM5 MDQ1ODdmIGluIHB1bGxfdmFyYXR0bm9zX3dhbGtlciAobm9kZT0weDYyZDAwMDA2ZjNkMCwKY29u dGV4dD0weDdmZmUzZGZkZDgwMCkgYXQgdmFyLmM6MzIyDQojOSAgMHgwMDAwNTVlOGM5MDQ1NDEw IGluIHB1bGxfdmFyYXR0bm9zIChub2RlPTB4NjJkMDAwMDZmM2QwLCB2YXJubz0yLAp2YXJhdHRu b3M9MHg3ZmZlM2RmZGQ4YjApIGF0IHZhci5jOjI5OA0KIzEwIDB4MDAwMDU1ZThjOGRhMmRhNyBp biByZW1vdmVfdW51c2VkX3N1YnF1ZXJ5X291dHB1dHMKKHN1YnF1ZXJ5PTB4NjJkMDAwMDZmYTU4 LCByZWw9MHg2MjUwMDAwMDYwNzAsIA0KICAgIGV4dHJhX3VzZWRfYXR0cnM9MHgwKSBhdCBhbGxw YXRocy5jOjQxMDUNCiMxMSAweDAwMDA1NWU4YzhkOTgzMDAgaW4gc2V0X3N1YnF1ZXJ5X3BhdGhs aXN0IChyb290PTB4NjI1MDAwMDViOTU4LApyZWw9MHg2MjUwMDAwMDYwNzAsIHJ0aT0yLCANCiAg ICBydGU9MHg2MjkwMDAwMzVjNDApIGF0IGFsbHBhdGhzLmM6MjYyNg0KIzEyIDB4MDAwMDU1ZThj OGQ4YTAwOCBpbiBzZXRfcmVsX3NpemUgKHJvb3Q9MHg2MjUwMDAwNWI5NTgsCnJlbD0weDYyNTAw MDAwNjA3MCwgcnRpPTIsIHJ0ZT0weDYyOTAwMDAzNWM0MCkNCiAgICBhdCBhbGxwYXRocy5jOjQy NA0KIzEzIDB4MDAwMDU1ZThjOGQ4OTdhMSBpbiBzZXRfYmFzZV9yZWxfc2l6ZXMgKHJvb3Q9MHg2 MjUwMDAwNWI5NTgpIGF0CmFsbHBhdGhzLmM6MzI1DQojMTQgMHgwMDAwNTVlOGM4ZDg4ODFiIGlu IG1ha2Vfb25lX3JlbCAocm9vdD0weDYyNTAwMDA1Yjk1OCwKam9pbmxpc3Q9MHg2MmQwMDAwNmZl NDApIGF0IGFsbHBhdGhzLmM6MTg2DQojMTUgMHgwMDAwNTVlOGM4ZWI1MDczIGluIHF1ZXJ5X3Bs YW5uZXIgKHJvb3Q9MHg2MjUwMDAwNWI5NTgsIA0KICAgIHFwX2NhbGxiYWNrPTB4NTVlOGM4ZWQ1 MGIwIDxzdGFuZGFyZF9xcF9jYWxsYmFjaz4sCnFwX2V4dHJhPTB4N2ZmZTNkZmRkZWYwKSBhdCBw bGFubWFpbi5jOjI3OA0KIzE2IDB4MDAwMDU1ZThjOGVjM2YxMCBpbiBncm91cGluZ19wbGFubmVy IChyb290PTB4NjI1MDAwMDViOTU4LAp0dXBsZV9mcmFjdGlvbj0wKSBhdCBwbGFubmVyLmM6MTQ5 Mw0KIzE3IDB4MDAwMDU1ZThjOGVjMTU3NCBpbiBzdWJxdWVyeV9wbGFubmVyIChnbG9iPTB4NjJk MDAwMDZlZGYwLApwYXJzZT0weDYyOTAwMDAzNTc0MCwgcGFyZW50X3Jvb3Q9MHgwLCANCiAgICBo YXNSZWN1cnNpb249ZmFsc2UsIHR1cGxlX2ZyYWN0aW9uPTApIGF0IHBsYW5uZXIuYzoxMDYyDQoj MTggMHgwMDAwNTVlOGM4ZWI3MGE0IGluIHN0YW5kYXJkX3BsYW5uZXIgKHBhcnNlPTB4NjI5MDAw MDM1NzQwLCANCiAgICBxdWVyeV9zdHJpbmc9MHg2MjUwMDAwMDUyMTggIlVQREFURSB2MiBTRVQg YSA9IDE7IiwgY3Vyc29yT3B0aW9ucz0yMDQ4LApib3VuZFBhcmFtcz0weDApIGF0IHBsYW5uZXIu Yzo0MTENCiMxOSAweDAwMDA1NWU4YzhlYjVmZDAgaW4gcGxhbm5lciAocGFyc2U9MHg2MjkwMDAw MzU3NDAsCnF1ZXJ5X3N0cmluZz0weDYyNTAwMDAwNTIxOCAiVVBEQVRFIHYyIFNFVCBhID0gMTsi LCANCiAgICBjdXJzb3JPcHRpb25zPTIwNDgsIGJvdW5kUGFyYW1zPTB4MCkgYXQgcGxhbm5lci5j OjI4MQ0KIzIwIDB4MDAwMDU1ZThjOTQ1MzM5ZSBpbiBwZ19wbGFuX3F1ZXJ5IChxdWVyeXRyZWU9 MHg2MjkwMDAwMzU3NDAsIA0KICAgIHF1ZXJ5X3N0cmluZz0weDYyNTAwMDAwNTIxOCAiVVBEQVRF IHYyIFNFVCBhID0gMTsiLCBjdXJzb3JPcHRpb25zPTIwNDgsCmJvdW5kUGFyYW1zPTB4MCkgYXQg cG9zdGdyZXMuYzo5MDQNCiMyMSAweDAwMDA1NWU4Yzk0NTNjYTQgaW4gcGdfcGxhbl9xdWVyaWVz IChxdWVyeXRyZWVzPTB4NjJkMDAwMDZlN2M4LCANCiAgICBxdWVyeV9zdHJpbmc9MHg2MjUwMDAw MDUyMTggIlVQREFURSB2MiBTRVQgYSA9IDE7IiwgY3Vyc29yT3B0aW9ucz0yMDQ4LApib3VuZFBh cmFtcz0weDApIGF0IHBvc3RncmVzLmM6OTk2DQojMjIgMHgwMDAwNTVlOGM5NDU0NTU1IGluIGV4 ZWNfc2ltcGxlX3F1ZXJ5IChxdWVyeV9zdHJpbmc9MHg2MjUwMDAwMDUyMTgKIlVQREFURSB2MiBT RVQgYSA9IDE7IikNCiAgICBhdCBwb3N0Z3Jlcy5jOjExOTMNCiMyMyAweDAwMDA1NWU4Yzk0NjFl NTYgaW4gUG9zdGdyZXNNYWluIChkYm5hbWU9MHg2MjkwMDAwMWIzNTggInJlZ3Jlc3Npb24iLAp1 c2VybmFtZT0weDYyNTAwMDAwMjBmOCAibGF3IikNCiAgICBhdCBwb3N0Z3Jlcy5jOjQ2MzINCiMy NCAweDAwMDA1NWU4YzkwZDQ0OWQgaW4gQmFja2VuZFJ1biAocG9ydD0weDYxNDAwMDAwMDQ0MCkg YXQKcG9zdG1hc3Rlci5jOjQ0NjENCiMyNSAweDAwMDA1NWU4YzkwZDJkMjMgaW4gQmFja2VuZFN0 YXJ0dXAgKHBvcnQ9MHg2MTQwMDAwMDA0NDApIGF0CnBvc3RtYXN0ZXIuYzo0MTg5DQojMjYgMHgw MDAwNTVlOGM5MGM5NDFkIGluIFNlcnZlckxvb3AgKCkgYXQgcG9zdG1hc3Rlci5jOjE3NzkNCiMy NyAweDAwMDA1NWU4YzkwYzdhMDUgaW4gUG9zdG1hc3Rlck1haW4gKGFyZ2M9MywgYXJndj0weDYw MzAwMDAwMDY3MCkgYXQKcG9zdG1hc3Rlci5jOjE0NjMNCiMyOCAweDAwMDA1NWU4YzhhZjUzNmYg aW4gbWFpbiAoYXJnYz0zLCBhcmd2PTB4NjAzMDAwMDAwNjcwKSBhdCBtYWluLmM6MTk4DQoNCihn ZGIpIGZyYW1lIDkNCiM5ICAweDAwMDA1NWU4YzkwNDU0MTAgaW4gcHVsbF92YXJhdHRub3MgKG5v ZGU9MHg2MmQwMDAwNmYzZDAsIHZhcm5vPTIsCnZhcmF0dG5vcz0weDdmZmUzZGZkZDhiMCkgYXQg dmFyLmM6Mjk4DQoyOTggICAgICAgICAgICAgKHZvaWQpIHB1bGxfdmFyYXR0bm9zX3dhbGtlcihu b2RlLCAmY29udGV4dCk7DQooZ2RiKSBwICooKFN1YkxpbmsgKilub2RlKS0+c3Vic2VsZWN0DQok MSA9IHt0eXBlID0gVF9RdWVyeX0NCg0KKGdkYikgZnJhbWUgMTINCiMxMiAweDAwMDA1NWU4Yzhk OGEwMDggaW4gc2V0X3JlbF9zaXplIChyb290PTB4NjI1MDAwMDViOTU4LApyZWw9MHg2MjUwMDAw MDYwNzAsIHJ0aT0yLCBydGU9MHg2MjkwMDAwMzVjNDApDQogICAgYXQgYWxscGF0aHMuYzo0MjQN CjQyNCAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBzZXRfc3VicXVlcnlfcGF0 aGxpc3Qocm9vdCwgcmVsLApydGksIHJ0ZSk7DQooZ2RiKSBwICooUXVlcnkgKikoKFN1Ykxpbmsg KikoKFJlc3RyaWN0SW5mbwoqKXJlbC0+YmFzZXJlc3RyaWN0aW5mby0+ZWxlbWVudHMtPnB0cl92 YWx1ZSktPmNsYXVzZSktPnN1YnNlbGVjdA0KJDIgPSB7dHlwZSA9IFRfUXVlcnksIGNvbW1hbmRU eXBlID0gQ01EX1NFTEVDVCwgcXVlcnlTb3VyY2UgPSBRU1JDX09SSUdJTkFMLAouLi59DQoNCmBn aXQgYmlzZWN0YCBmb3IgdGhpcyBhbm9tYWx5IHBvaW50ZWQgYXQgMjE1YjQzY2RjLg0KDQpJdCBs b29rcyBsaWtlIHRoZSBmYWlsdXJlIGNhdXNlZCBieSB0aGUgZm9sbG93aW5nOg0KMSkgRm9yIGEg c2VjdXJpeSB2aWV3LCB0aGUgcmV3cml0ZVRhcmdldFZpZXcoKSBjYWxsIHNldHMgc2VjdXJpdHlR dWFsczsNCjIpIHN1YnF1ZXJ5X3BsYW5uZXIoKSBzZXRzIHJvb3QtPnF1YWxfc2VjdXJpdHlfbGV2 ZWwgPSAxDQogKE1heChyb290LT5xdWFsX3NlY3VyaXR5X2xldmVsLCBsaXN0X2xlbmd0aChydGUt PnNlY3VyaXR5UXVhbHMpKSk7DQozKSBkZWNvbnN0cnVjdF9kaXN0cmlidXRlKCkgY2FsbHMgcHJv Y2Vzc19zZWN1cml0eV9iYXJyaWVyX3F1YWxzKCkgLT4NCiBkaXN0cmlidXRlX3F1YWxfdG9fcmVs cygpLCB3aGljaCBwZXJmb3Jtcw0KICJBZGQgY2xhdXNlIGluZm9ybWF0aW9uIHRvIGVpdGhlciB0 aGUgYmFzZXJlc3RyaWN0aW5mbyBvciBqb2luaW5mbyBsaXN0Ci4uLiI7DQo0KSBMYXRlciwgd2hl biBzZXRfcmVsX3NpemUoKSBjYWxsZWQsIGZvciB0aGUgY2FzZSByZWwtPnJ0ZWtpbmQgPT0KUlRF X1NVQlFVRVJZDQogd2UgZ2V0IHNldF9zdWJxdWVyeV9wYXRobGlzdCgpIGNhbGxlZCwgd2hpY2gg aW4gdHVybiBjYWxscw0KIHJlbW92ZV91bnVzZWRfc3VicXVlcnlfb3V0cHV0cygpLCB3aGVyZSBm b3JlYWNoKGxjLApyZWwtPmJhc2VyZXN0cmljdGluZm8pDQogd2UgaGF2ZSBwdWxsX3ZhcmF0dG5v cygpIGNhbGxlZCB3aXRoIHRoZSBjbGF1c2UtPnN1YnNlbGVjdCBoYXZpbmcgdHlwZQ0KIFRfUVVF UlksIGJ1dCBhIGNvbW1lbnQgZm9yIHB1bGxfdmFyYXR0bm9zKCkgc2F5czoNCiAqIEN1cnJlbnRs eSwgdGhpcyBkb2VzIG5vdCBzdXBwb3J0IHVucGxhbm5lZCBzdWJxdWVyaWVzOyB0aGF0IGlzIG5v dApuZWVkZWQNCiAqIGZvciBjdXJyZW50IHVzZXMuIC4uLg0KNSkgQW5kIHdlIHJlYWxseSBzdHVt YmxlIHVwb24gdGhlIEFzc2VydCBpbiBwdWxsX3ZhcmF0dG5vc193YWxrZXIoKS4NCg0KSUlJVUMs IDIxNWI0M2NkYyBwcm9kdWNlZCB0aGlzIGZhaWx1cmUgZHVlIHRvDQpwcm9jZXNzX3NlY3VyaXR5 X2JhcnJpZXJfcXVhbHMoKSBhZGRlZC4KCg== --===============3038717673285615335==--