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 1p3tLQ-0004uG-6H for pgsql-committers@arkaria.postgresql.org; Sat, 10 Dec 2022 06:28:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p3tLP-0002A6-3F for pgsql-committers@arkaria.postgresql.org; Sat, 10 Dec 2022 06:28:19 +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 1p3tLO-000270-S7 for pgsql-committers@lists.postgresql.org; Sat, 10 Dec 2022 06:28:18 +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 1p3tLM-0004qY-KB for pgsql-committers@lists.postgresql.org; Sat, 10 Dec 2022 06:28:18 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=dJ8x0lzPexJH/wSn3E7YxBLeVnjJJaYTHYK0suRaG+M=; b=LWdTQhdQpvn7r34kLPiLOkXXdf +1vHHfeLdPJZC4K6s+XNJoXIbMWyznU6PRn9Oh9huMTdQfJCcBWoIXvI/amxuYNxN4LGlVoCJ8ORC ACyfOlDsAEBamedEK0D5w/UoQV79fd3SEXeq2XXPq5FUvENChFBavpM3hUIWVx5juhduVh32wGRba atFSw5LsLTay8ZSrX0VcFIaMyPeqE8NVHVc+kIJ8b5KkiOKk4vclhrmUIMWc8udQg/vTPtGELOCx2 yB4ZWJCuN+Yw3Zb4TXsTk1IxDKwuiVliAnUa1rEPglzMd4dbh1Tw1b9Y+EdkmMcMgA9h6f+kLGCkv OqIuPWPA==; 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 1p3tLL-0005Um-C1 for pgsql-committers@lists.postgresql.org; Sat, 10 Dec 2022 06:28:15 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1p3tLK-002n69-0V for pgsql-committers@lists.postgresql.org; Sat, 10 Dec 2022 06:28:14 +0000 Content-Type: multipart/mixed; boundary="===============5229247141966835120==" MIME-Version: 1.0 From: David Rowley To: pgsql-committers@lists.postgresql.org Subject: pgsql: Add subquery pullup handling for WindowClause runCondition X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sat, 10 Dec 2022 06:28:14 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5229247141966835120== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QWRkIHN1YnF1ZXJ5IHB1bGx1cCBoYW5kbGluZyBmb3IgV2luZG93Q2xhdXNlIHJ1bkNvbmRpdGlv bgoKOWQ5YzAyY2NkIGFkZGVkIGNvZGUgdG8gYWxsb3cgV2luZG93QWdnIHRvIHRha2Ugc29tZSBz aG9ydGN1dHMgd2hlbiBhCm1vbm90b25pYyBXaW5kb3dGdW5jIHJlYWNoZWQgc29tZSB2YWx1ZSB0 aGF0IGl0IGNvdWxkIG5ldmVyIGNvbWUgYmFjawpmcm9tIGR1ZSB0byB0aGUgZnVuY3Rpb24ncyBt b25vdG9uaWMgbmF0dXJlLiAgVGhhdCBjb21taXQgYWRkZWQgYQpydW5Db25kaXRpb24gZmllbGQg dG8gV2luZG93Q2xhdXNlIHRvIHN0b3JlIHRoZSBjb25kaXRpb24gd2hpY2gsIHdoZW4gaXQKYmVj b21lcyBmYWxzZSB3ZSBjYW4gc3RhcnQgdGFraW5nIHNob3J0Y3V0cyBpbiBub2RlV2luZG93QWdn LmMuCgpIZXJlIHdlIGZpeCBhbiBpc3N1ZSB3aGVyZSBzdWJxdWVyeSBwdWxsdXBzIGRpZG4ndCBw cm9wZXJseSB1cGRhdGUgdGhlCnJ1bkNvbmRpdGlvbiB0byB1cGRhdGUgdGhlIFZhcnMgdG8gcHJv cGVybHkgcmVmZXJlbmNlIHRoZSBuZXcgcXVlcnkgbGV2ZWwuCgpIZXJlIHdlIGFsc28gYWRkIGEg bWlzc2luZyBjYWxsIHRvIHByZXByb2Nlc3NfZXhwcmVzc2lvbigpIGZvciB0aGUKV2luZG93Q2xh dXNlJ3MgcnVuQ29uZHRpb24uICBUaGUgV2luZG93RnVuY3MgaW4gdGhlIHRhcmdldGxpc3Qgd2ls bCBoYXZlCmhhZCB0aGlzIHByb2Nlc3MgZG9uZSwgc28gd2UgbXVzdCBhbHNvIGRvIGl0IGZvciB0 aGUgV2luZG93RnVuY3MgaW4gdGhlCnJ1bkNvbmRpdGlvbiBzbyB0aGF0IHRoZXkgY2FuIGJlIGNv cnJlY3RseSBmb3VuZCBpbiB0aGUgdGFyZ2V0bGlzdApkdXJpbmcgc2V0cmVmcy5jCgpCdWc6ICMx NzcwOQpSZXBvcnRlZC1ieTogQWxleGV5IE1ha2htdXRvdgpBdXRob3I6IFJpY2hhcmQgR3VvLCBE YXZpZCBSb3dsZXkKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8xNzcwOS00ZjU1NzE2 MGUzZThlZTlhQHBvc3RncmVzcWwub3JnCkJhY2twYXRjaC10aHJvdWdoOiAxNSwgd2hlcmUgOWQ5 YzAyY2NkIHdhcyBpbnRyb2R1Y2VkCgpCcmFuY2gKLS0tLS0tClJFTF8xNV9TVEFCTEUKCkRldGFp bHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzA0Nzg4 ZWU0YzVlZmNmYmYwMjZiOTY4YTA2NGZjZGQ3NGZjYmExNTQKCk1vZGlmaWVkIEZpbGVzCi0tLS0t LS0tLS0tLS0tCnNyYy9iYWNrZW5kL29wdGltaXplci9wbGFuL3BsYW5uZXIuYyAgICAgIHwgMyAr KysKc3JjL2JhY2tlbmQvb3B0aW1pemVyL3ByZXAvcHJlcGpvaW50cmVlLmMgfCA5ICsrKysrKysr KwoyIGZpbGVzIGNoYW5nZWQsIDEyIGluc2VydGlvbnMoKykKCg== --===============5229247141966835120==--