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 1nta7X-00083H-08 for pgsql-bugs@arkaria.postgresql.org; Tue, 24 May 2022 19:23:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nta7U-0000xQ-CQ for pgsql-bugs@arkaria.postgresql.org; Tue, 24 May 2022 19:23:04 +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 1ntXEa-0007R4-CN for pgsql-bugs@lists.postgresql.org; Tue, 24 May 2022 16:18:12 +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 1ntXES-0006R0-TJ for pgsql-bugs@lists.postgresql.org; Tue, 24 May 2022 16:18:11 +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=8yLfA3uJv0vgOb6bkAFo0NXbOYMlqrMU8mW4sXHgeqg=; b=1MLwsqPT4rcsxvStsClOuIAujk oI0rVA9fWsPhOPZP3ssmKC7yRP59bcznL5rLk7UnMycOu7BG7WhGP8KRGSiYVHUp/DJGqZXET1WUH XI+8RNfA9ULdM500GN3fI+xS6Xlfm3kLHVQu+l/2Fqp0JLOG+4WUedkytmsDRd4sHeVO24fsf/oTq lHMwcG2QJJB9x8dvV67BDMq0XFDaJfrOac2h8dzgffMy/nJ37CqW4PMcrnDGzzFhd4XVDdH/hS/4U wBuVwgkqUP27J8K6rU7gLjNeJZLhOFLCfLVgu/B7iUfHtme8mHV6Qk9+A/bqUp/bOaaNEpGDDMeGj 5HY4qcjw==; 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 1ntXER-0001qm-Tg for pgsql-bugs@lists.postgresql.org; Tue, 24 May 2022 16:18:03 +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 1ntXEP-003fz7-Sb for pgsql-bugs@lists.postgresql.org; Tue, 24 May 2022 16:18:02 +0000 Content-Type: multipart/mixed; boundary="===============4104103746917386003==" MIME-Version: 1.0 Subject: BUG #17495: Regression in 15beta1 when filtering subquery including row_number window function To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: jeremyevans0@gmail.com Reply-To: jeremyevans0@gmail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 24 May 2022 16:17:35 +0000 Message-ID: <17495-7ffe2fa0b261b9fa@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 --===============4104103746917386003== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzQ5NQpMb2dnZWQgYnk6ICAgICAgICAgIEplcmVteSBFdmFucwpFbWFp bCBhZGRyZXNzOiAgICAgIGplcmVteWV2YW5zMEBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9u OiBVbnN1cHBvcnRlZC9Vbmtub3duCk9wZXJhdGluZyBzeXN0ZW06ICAgT3BlbkJTRCA3LjEvYW1k NjQKRGVzY3JpcHRpb246ICAgICAgICAKCkZyb20gdGVzdGluZyB3aXRoIDE1YmV0YTEsIEkgdGhp bmsgdGhlcmUgaXMgYSByZWdyZXNzaW9uIGluIGZpbHRlcmluZyBhCnN1YnF1ZXJ5IHVzaW5nIHRo ZSByZXN1bHQgb2YgdGhlIHJvd19udW1iZXIgd2luZG93IGZ1bmN0aW9uLiAgSGVyZSBpcyB0aGUK Y29kZToNCg0KQ1JFQVRFIFRFTVBPUkFSWSBUQUJMRSBhcnRpc3RzIChpZCBpbnRlZ2VyIFBSSU1B UlkgS0VZLCBuYW1lIHRleHQpOw0KQ1JFQVRFIFRFTVBPUkFSWSBUQUJMRSBhbGJ1bXMgKGlkIGlu dGVnZXIgUFJJTUFSWSBLRVksIG5hbWUgdGV4dCwgYXJ0aXN0X2lkCmludGVnZXIgUkVGRVJFTkNF UyBhcnRpc3RzKTsNCkNSRUFURSBURU1QT1JBUlkgVEFCTEUgdGFncyAoaWQgaW50ZWdlciAgUFJJ TUFSWSBLRVksIG5hbWUgdGV4dCk7DQpDUkVBVEUgVEVNUE9SQVJZIFRBQkxFIGFsYnVtc190YWdz IChhbGJ1bV9pZCBpbnRlZ2VyIFJFRkVSRU5DRVMgYWxidW1zLAp0YWdfaWQgaW50ZWdlciBSRUZF UkVOQ0VTIHRhZ3MpOw0KDQpJTlNFUlQgSU5UTyBhcnRpc3RzIChpZCwgbmFtZSkgVkFMVUVTICgx LCAnQXInKSwgKDIsICdBcjInKTsNCklOU0VSVCBJTlRPIGFsYnVtcyAoaWQsIG5hbWUsIGFydGlz dF9pZCkgVkFMVUVTICgxLCAnQWwnLCAxKSwgKDIsICdBbDInLAoyKTsNCklOU0VSVCBJTlRPIHRh Z3MgKGlkLCBuYW1lKSBWQUxVRVMgKDEsICdUJyksICgyLCAnVScpLCAoMywgJ1YnKSwgKDQsCidU MicpOw0KSU5TRVJUIElOVE8gYWxidW1zX3RhZ3MgKGFsYnVtX2lkLCB0YWdfaWQpIFZBTFVFUyAo MSwgMSksICgxLCAyKSwgKDEsIDMpLAooMiwgNCk7DQoNClNFTEVDVCBhbGJ1bXMuYXJ0aXN0X2lk IEFTIGIsIHRhZ3MuaWQgQVMgYywgcm93X251bWJlcigpIE9WRVIgKFBBUlRJVElPTiBCWQphbGJ1 bXMuYXJ0aXN0X2lkIE9SREVSIEJZIHRhZ3MubmFtZSkgQVMgeF9zZXF1ZWxfcm93X251bWJlcl94 IEZST00gdGFncwpJTk5FUiBKT0lOIGFsYnVtc190YWdzIE9OIChhbGJ1bXNfdGFncy50YWdfaWQg PSB0YWdzLmlkKSBJTk5FUiBKT0lOIGFsYnVtcwpPTiAoYWxidW1zLmlkID0gYWxidW1zX3RhZ3Mu YWxidW1faWQpOw0KDQotLSBSZWdyZXNzaW9uIGluIDE1YmV0YTEsIGluY2x1ZGVzICgxLCAzKSBl dmVuIHRob3VnaCB4X3NlcXVlbF9yb3dfbnVtYmVyX3gKPSAzIGZvciB0aGF0IHJvdw0KU0VMRUNU IGIsIGMgRlJPTSAoU0VMRUNUIGFsYnVtcy5hcnRpc3RfaWQgQVMgYiwgdGFncy5pZCBBUyBjLCBy b3dfbnVtYmVyKCkKT1ZFUiAoUEFSVElUSU9OIEJZIGFsYnVtcy5hcnRpc3RfaWQgT1JERVIgQlkg dGFncy5uYW1lKSBBUwp4X3NlcXVlbF9yb3dfbnVtYmVyX3ggRlJPTSB0YWdzIElOTkVSIEpPSU4g YWxidW1zX3RhZ3MgT04KKGFsYnVtc190YWdzLnRhZ19pZCA9IHRhZ3MuaWQpIElOTkVSIEpPSU4g YWxidW1zIE9OIChhbGJ1bXMuaWQgPQphbGJ1bXNfdGFncy5hbGJ1bV9pZCkpIEFTIHQxIFdIRVJF ICh4X3NlcXVlbF9yb3dfbnVtYmVyX3ggPD0gMik7DQoNClJlc3VsdHMgRnJvbSBQb3N0Z3JlU1FM IDguNC0xNDoNCg0KIGIgfCBjIHwgeF9zZXF1ZWxfcm93X251bWJlcl94IA0KLS0tKy0tLSstLS0t LS0tLS0tLS0tLS0tLS0tLS0tLQ0KIDEgfCAxIHwgICAgICAgICAgICAgICAgICAgICAxDQogMSB8 IDIgfCAgICAgICAgICAgICAgICAgICAgIDINCiAxIHwgMyB8ICAgICAgICAgICAgICAgICAgICAg Mw0KIDIgfCA0IHwgICAgICAgICAgICAgICAgICAgICAxDQooNCByb3dzKQ0KDQogYiB8IGMgDQot LS0rLS0tDQogMSB8IDENCiAxIHwgMg0KIDIgfCA0DQooMyByb3dzKQ0KDQpSZXN1bHRzIG9uIFBv c3RncmVTUUwgMTViZXRhMToNCg0KIGIgfCBjIHwgeF9zZXF1ZWxfcm93X251bWJlcl94IA0KLS0t Ky0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIDEgfCAxIHwgICAgICAgICAgICAgICAgICAg ICAxDQogMSB8IDIgfCAgICAgICAgICAgICAgICAgICAgIDINCiAxIHwgMyB8ICAgICAgICAgICAg ICAgICAgICAgMw0KIDIgfCA0IHwgICAgICAgICAgICAgICAgICAgICAxDQooNCByb3dzKQ0KDQog YiB8IGMgDQotLS0rLS0tDQogMSB8IDENCiAxIHwgMg0KIDEgfCAzDQogMiB8IDQNCig0IHJvd3Mp DQoNClRoaXMgd2FzIGRpc2NvdmVyZWQgYnkgdGhlIHRlc3RzIGZvciBTZXF1ZWwsIGEgUnVieSBk YXRhYmFzZSBhY2Nlc3MKbGlicmFyeS4NCg0KVGhhbmtzLA0KSmVyZW15Cgo= --===============4104103746917386003==--