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 1p3tKx-0004sN-Eq for pgsql-committers@arkaria.postgresql.org; Sat, 10 Dec 2022 06:27:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p3tKv-0001TH-CM for pgsql-committers@arkaria.postgresql.org; Sat, 10 Dec 2022 06:27:49 +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 1p3tKv-0001OI-4d for pgsql-committers@lists.postgresql.org; Sat, 10 Dec 2022 06:27:49 +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 1p3tKr-0004qC-Ut for pgsql-committers@lists.postgresql.org; Sat, 10 Dec 2022 06:27:48 +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=MPnzgi4voyZlhOGdkVMyseuyCVxd0751IXQRkPpWHno=; b=v11Ks54SB//3tJwnsR8gd11jzL AqHoL5gP1Qn225GWyV8l/A7kNwhYLuWDR+kTl2ScNkZ2nAPtyUks3M4JwysjMSiUOSHtT9nlQqv0J XMkce7+qDDovky2TIzrqF/yA2qgg4LxoAHdkRYEzB8Al2PJv7l4l/MeYu98QvMo0QfGL/l14GedAB z29ABxARXUi+EiDTMjRkXr5+V1tWgiJI5AZXhg38aAkyQNcUlnB163ox9g+r0Oogc/pZlPoejuZmZ //gWdGkkyP92cW5Hw8VtaFEe6QLl4XnHBVwEZh9cbMR3MoagfYkzpg3M+rrnPc3GEy7uWOtfIajJf gOdoEM/g==; 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 1p3tKq-0005Tx-GU for pgsql-committers@lists.postgresql.org; Sat, 10 Dec 2022 06:27:44 +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 1p3tKp-002n5K-32 for pgsql-committers@lists.postgresql.org; Sat, 10 Dec 2022 06:27:44 +0000 Content-Type: multipart/mixed; boundary="===============3524626934315674881==" 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:27:44 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3524626934315674881== 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 YzAyY2NkIHdhcyBpbnRyb2R1Y2VkCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0t LS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvOTQ5ODVjMjEwMjBh YTRhNDBkMGRkYTFhMjZhYzNlMzVhNTdlNDY4MQoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0t LS0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3BsYW4vcGxhbm5lci5jICAgICAgfCAzICsrKwpzcmMv YmFja2VuZC9vcHRpbWl6ZXIvcHJlcC9wcmVwam9pbnRyZWUuYyB8IDkgKysrKysrKysrCjIgZmls ZXMgY2hhbmdlZCwgMTIgaW5zZXJ0aW9ucygrKQoK --===============3524626934315674881==--