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 1lFfyR-0004xE-Hl for pgsql-bugs@arkaria.postgresql.org; Fri, 26 Feb 2021 16:28:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lFfyQ-0005Eo-Go for pgsql-bugs@arkaria.postgresql.org; Fri, 26 Feb 2021 16:28:14 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lFbKv-00059J-79 for pgsql-bugs@lists.postgresql.org; Fri, 26 Feb 2021 11:31:09 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lFbKs-00055y-Hl for pgsql-bugs@lists.postgresql.org; Fri, 26 Feb 2021 11:31:08 +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=PT6jVAKxapSsbg0wYrSaxU5fgYSjynvOKIB7IweCp48=; b=LOGEyvwwZuhbJvidc3c6YJycxF fj5107q8VnaW/RVrskh+lxk7Bl3bl4PX7zDR7kbCQ3e7vqKXNqkLA/jZWlr2eFQ8sGooUmC++q9ka hmv8bHPXrGWf5laNrxJMliG+tYNe25gHTtFj3ocDqJk2zyo2dLWDkyXfjB4hM2sh09NFyey3/YKwC HNLNPLBI0JSc9R3DXBZqu9PmIyRwaA9Mdzl0xdNf2aPyzRsCfb2dQdd/L33Cv/G9rhdow2mitw96v mdMol6WYUWaV1L8QEZVTwj8ogsod36JuWkhuPKLzyyRL6ZAZN2jPv4VGR0qNZNkw3eeNIxKt/+BZi O74JD3Hg==; 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 1lFbKr-0008OW-3W for pgsql-bugs@lists.postgresql.org; Fri, 26 Feb 2021 11:31:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lFbKo-0002N6-If for pgsql-bugs@lists.postgresql.org; Fri, 26 Feb 2021 11:31:02 +0000 Content-Type: multipart/mixed; boundary="===============7437475213550585624==" MIME-Version: 1.0 Subject: BUG #16900: SELECT MAX subquery not allowed in WHERE clause when using WITH RECURSIVE To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: dan.farlow@gmail.com Reply-To: dan.farlow@gmail.com, pgsql-bugs@lists.postgresql.org Date: Fri, 26 Feb 2021 11:30:57 +0000 Message-ID: <16900-5b4d30739ea178c7@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============7437475213550585624== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjkwMApMb2dnZWQgYnk6ICAgICAgICAgIERhbmllbCBGYXJsb3cKRW1h aWwgYWRkcmVzczogICAgICBkYW4uZmFybG93QGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246 IDEzLjIKT3BlcmF0aW5nIHN5c3RlbTogICBtYWNPUyBNb2phdmUgMTAuMTQuNgpEZXNjcmlwdGlv bjogICAgICAgIAoKRXhhY3Qgc2VxdWVuY2UgdG8gcmVwcm9kdWNlIHByb2JsZW06DQoNCkNSRUFU RSBUQUJMRSBJRiBOT1QgRVhJU1RTDQogIFRhc2tzICh0YXNrX2lkIGludCwgc3VidGFza3NfY291 bnQgaW50KTsNCg0KVFJVTkNBVEUgVEFCTEUgVGFza3M7DQoNCklOU0VSVCBJTlRPDQogIFRhc2tz ICh0YXNrX2lkLCBzdWJ0YXNrc19jb3VudCkNClZBTFVFUw0KICAoJzEnLCAnMycpLA0KICAoJzIn LCAnMicpLA0KICAoJzMnLCAnNCcpOw0KDQoNCkNSRUFURSBUQUJMRSBJRiBOT1QgRVhJU1RTDQog IEV4ZWN1dGVkICh0YXNrX2lkIGludCwgc3VidGFza19pZCBpbnQpOw0KDQpUUlVOQ0FURSBUQUJM RSBFeGVjdXRlZDsNCg0KSU5TRVJUIElOVE8NCiAgRXhlY3V0ZWQgKHRhc2tfaWQsIHN1YnRhc2tf aWQpDQpWQUxVRVMNCiAgKCcxJywgJzInKSwNCiAgKCczJywgJzEnKSwNCiAgKCczJywgJzInKSwN CiAgKCczJywgJzMnKSwNCiAgKCczJywgJzQnKTsNCg0KV0lUSCBSRUNVUlNJVkUgcG9zc2libGVf dGFza3Nfc3VidGFza3MgQVMgKA0KICBTRUxFQ1QNCiAgICB0YXNrX2lkLCBzdWJ0YXNrc19jb3Vu dCBhcyBtYXhfc3VidGFza19jb3VudCwgMSBBUyBzdWJ0YXNrX2lkDQogIEZST00NCiAgICBUYXNr cw0KICBVTklPTiBBTEwNCiAgU0VMRUNUDQogICAgdGFza19pZCwgbWF4X3N1YnRhc2tfY291bnQs IHN1YnRhc2tfaWQgKyAxDQogIEZST00NCiAgICBwb3NzaWJsZV90YXNrc19zdWJ0YXNrcw0KICAt LSB1c2luZyBTRUxFQ1QgTUFYIGluIHRoZSBXSEVSRSBjbGF1c2UgYmVsb3cgaXMgd2hhdCBjYXVz ZXMgdGhlIGVycm9yDQogIFdIRVJFDQogICAgc3VidGFza19pZCA8IChTRUxFQ1QgTUFYKG1heF9z dWJ0YXNrX2NvdW50KSBGUk9NIFRhc2tzKSkNClNFTEVDVA0KICBQLnRhc2tfaWQsIFAuc3VidGFz a19pZA0KRlJPTQ0KICBwb3NzaWJsZV90YXNrc19zdWJ0YXNrcyBQDQpMRUZUIEpPSU4NCiAgRXhl Y3V0ZWQgRSBPTiBQLnRhc2tfaWQgPSBFLnRhc2tfaWQgQU5EIFAuc3VidGFza19pZCA9IEUuc3Vi dGFza19pZA0KV0hFUkUNCiAgRS50YXNrX2lkIElTIE5VTEwgT1IgRS5zdWJ0YXNrX2lkIElTIE5V TEw7DQoNCk91dHB1dCByZWNlaXZlZDogRVJST1I6IGFnZ3JlZ2F0ZSBmdW5jdGlvbnMgYXJlIG5v dCBhbGxvd2VkIGluIFdIRVJFDQoNCk91dHB1dCBleHBlY3RlZCAocmVzdWx0IHNldCBpbiBhbnkg b3JkZXIpOg0KDQorLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLSsNCnwgdGFza19pZCB8IHN1YnRh c2tfaWQgfA0KKy0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0rDQp8IDEgICAgICAgICAgfCAxICAg ICAgICAgICAgICAgIHwNCnwgMSAgICAgICAgICB8IDMgICAgICAgICAgICAgICAgfA0KfCAyICAg ICAgICAgIHwgMSAgICAgICAgICAgICAgICB8DQp8IDIgICAgICAgICAgfCAyICAgICAgICAgICAg ICAgIHwNCistLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tKw0KDQpQbGF0Zm9ybSBpbmZvcm1hdGlv bjogUG9zdGdyZVNRTCAxMy4yIG9uIHg4Nl82NC1hcHBsZS1kYXJ3aW4xOC43LjAsIGNvbXBpbGVk CmJ5IEFwcGxlIGNsYW5nIHZlcnNpb24gMTEuMC4wIChjbGFuZy0xMTAwLjAuMzMuMTcpLCA2NC1i aXQNCg0KQ29tbWVudHM6IEFzIGhpZ2hsaWdodGVkIGluIHRoZSBkb2NzIG9uIGFnZ3JlZ2F0ZSBm dW5jdGlvbnMgKHJlZjoKaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy9jdXJyZW50L3R1 dG9yaWFsLWFnZy5odG1sKSwgdGhlIGFnZ3JlZ2F0ZQptYXggY2Fubm90IGJlIHVzZWQgZGlyZWN0 bHkgaW4gdGhlIFdIRVJFIGNsYXVzZSBidXQgYSBxdWVyeSBjYW4gYmUgcmVzdGF0ZWQKc28gYXMg dG8gZ2V0IHRoZSBkZXNpcmVkIHJlc3VsdCB1c2luZyBhIHN1YnF1ZXJ5OyBoZW5jZSwgc29tZXRo aW5nIGxpa2UgdGhlCmV4YW1wbGUgaW4gdGhlIGRvY3MNCg0KU0VMRUNUIGNpdHkgRlJPTSB3ZWF0 aGVyIFdIRVJFIHRlbXBfbG8gPSBtYXgodGVtcF9sbyk7DQoNCmNhbiBiZSB0cmFuc2Zvcm1lZCB0 byANCg0KU0VMRUNUIGNpdHkgRlJPTSB3ZWF0aGVyDQogICAgV0hFUkUgdGVtcF9sbyA9IChTRUxF Q1QgbWF4KHRlbXBfbG8pIEZST00gd2VhdGhlcik7DQoNCkkgdHJpZWQgdGhpcyBzYW1lIGFwcHJv YWNoIGluIG15IFdJVEggcXVlcnksIGFzIHN0YXRlZCBhYm92ZSwgYnV0IHJlY2VpdmVkCiJFUlJP UjogYWdncmVnYXRlIGZ1bmN0aW9ucyBhcmUgbm90IGFsbG93ZWQgaW4gV0hFUkUiLiBJIGxvb2tl ZCBhdCB0aGUgZG9jcwpvbiBXSVRIIHF1ZXJpZXMgKHJlZjoKaHR0cHM6Ly93d3cucG9zdGdyZXNx bC5vcmcvZG9jcy9jdXJyZW50L3F1ZXJpZXMtd2l0aC5odG1sKSBidXQgZGlkIG5vdCBzZWUKYW55 IG1lbnRpb24gb2YgYWdncmVnYXRlIGZ1bmN0aW9uIHJlc3RyaWN0aW9uLg0KDQpUd28gb3RoZXIg dGhpbmdzIHBvc3NpYmx5IHdvcnRoIG1lbnRpb25pbmcgdGhhdCBtYXkgYmUgcmVsZXZhbnQ6DQox LiBUaGUgcHJvYmxlbWF0aWMgcXVlcnkgZXhlY3V0ZXMgYXMgZXhwZWN0ZWQgd2hlbiB1c2luZyBN eVNRTCB2ZXJzaW9uCjguMC4yMy4gKFRoaXMgc2VlbXMgdG8gYmUgcmVsZXZhbnQgc2luY2UgYSBy aXZhbCBkYXRhYmFzZSBoYXMgaW1wbGVtZW50ZWQKdGhpcyBhYmlsaXR5LikNCjIuIEkgY2FuIG1v ZGlmeSBteSBQb3N0Z3JlU1FMIHF1ZXJ5IHRvIHdvcmsgYXMgZXhwZWN0ZWQgYnkgbW9kaWZ5aW5n DQoNCldIRVJFDQogIHN1YnRhc2tfaWQgPCAoU0VMRUNUIE1BWChtYXhfc3VidGFza19jb3VudCkg RlJPTSBUYXNrcykNCg0KdG8gYmUgDQoNCldIRVJFDQogIHN1YnRhc2tfaWQgPCAoU0VMRUNUIG1h eF9zdWJ0YXNrX2NvdW50IEZST00gVGFza3MgT1JERVIgQlkKbWF4X3N1YnRhc2tfY291bnQgREVT QyBMSU1JVCAxKQoK --===============7437475213550585624==--