Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s3Q9z-00Co7n-Pq for pgsql-committers@arkaria.postgresql.org; Sun, 05 May 2024 00:55:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1s3Q9x-003TmB-7b for pgsql-committers@arkaria.postgresql.org; Sun, 05 May 2024 00:55:22 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s3Q9w-003Tm3-Ur for pgsql-committers@lists.postgresql.org; Sun, 05 May 2024 00:55:21 +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 1s3Q9q-001UBl-B3 for pgsql-committers@lists.postgresql.org; Sun, 05 May 2024 00:55:20 +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=w1RAlFFfexZBJnSeSJVMcPXOw7SfZ0mytHeGzxkKPr4=; b=44OpCCi/yfFygzCj8OFMChU/ug Xh139pWHVfiq7DWsAZQGCPqx1XBinOh+uzs9zl/9SlerwA5WF9RMUnr8v0d+QrOT6wAOIQ2miQZkO C/Gj63DDk9v/2JnmoGS3HmEdE+zIotrOEiJKhgLVmIj2UcES3l2pYE43pmkJG9YGlH9hbHAksfts/ xbBKMMwP6HBRkIcs6fC9fU8tK4iT4f94sttc9FQkXDvrYIcG4PNxv41BUCp5wKgaqkjvcg7G6z3kl QpHuv71lFCqjlxkMbBYUR4xXY8GHxb8oo07Vth9UPAEXswOJWRNYq9hMx/3Lydau8CyAF1DNArgj+ R5gQTV1A==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s3Q9o-004mcL-SZ for pgsql-committers@lists.postgresql.org; Sun, 05 May 2024 00:55:13 +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 1s3Q9m-001Z37-Uu for pgsql-committers@lists.postgresql.org; Sun, 05 May 2024 00:55:12 +0000 Content-Type: multipart/mixed; boundary="===============2821113535153433857==" MIME-Version: 1.0 From: David Rowley To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix query pullup issue with WindowClause runCondition X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sun, 05 May 2024 00:55:12 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2821113535153433857== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IHF1ZXJ5IHB1bGx1cCBpc3N1ZSB3aXRoIFdpbmRvd0NsYXVzZSBydW5Db25kaXRpb24KCjk0 OTg1YzIxMCBhZGRlZCBjb2RlIHRvIGRldGVjdCB3aGVuIFdpbmRvd0Z1bmNzIHdlcmUgbW9ub3Rv bmljIGFuZAphbGxvd2VkIGFkZGl0aW9uYWwgcXVhbHMgdG8gYmUgInB1c2hlZCBkb3duIiBpbnRv IHRoZSBzdWJxdWVyeSB0byBiZQp1c2VkIGFzIFdpbmRvd0NsYXVzZSBydW5Db25kaXRpb25zIGlu IG9yZGVyIHRvIHNob3J0LWNpcmN1aXQgZXhlY3V0aW9uCmluIG5vZGVXaW5kb3dBZ2cuYy4KClRo ZSBOb2RlIHJlcHJlc2VudGF0aW9uIG9mIHJ1bkNvbmRpdGlvbnMgd2Fzbid0IHdlbGwgc2VsZWN0 ZWQgYW5kCmJlY2F1c2Ugd2UgZG8gcXVhbCBwdXNoZG93biBiZWZvcmUgcGxhbm5pbmcgdGhlIHN1 YnF1ZXJ5LCB0aGUgcGxhbm5pbmcKb2YgdGhlIHN1YnF1ZXJ5IGNvdWxkIHBlcmZvcm0gc3VicXVl cnkgcHVsbC11cCBvZiBuZXN0ZWQgc3VicXVlcmllcy4KRm9yIFdpbmRvd0Z1bmNzIHdpdGggYXJn cywgdGhlIGFyZ3VtZW50cyBjb3VsZCBiZSBjaGFuZ2VkIGFmdGVyIHB1c2hpbmcKdGhlIHF1YWwg ZG93biB0byB0aGUgc3VicXVlcnkuCgpUaGlzIHdhcyBtYWRlIG1vcmUgZGlmZmljdWx0IGJ5IHRo ZSBmYWN0IHRoYXQgdGhlIGNvZGUgZHVwbGljYXRlZCB0aGUKV2luZG93RnVuYyBpbnNpZGUgYW4g T3BFeHByIHRvIGluY2x1ZGUgaW4gdGhlIFdpbmRvd0NsYXVzZXMgcnVuQ29uZGl0aW9uCmZpZWxk LiAgVGhpcyBjb3VsZCByZXN1bHQgaW4gZHVwbGljYXRpb24gb2Ygc3VicXVlcmllcyBhbmQgYSBw dWxsLXVwIG9mCnN1Y2ggYSBzdWJxdWVyeSBjb3VsZCByZXN1bHQgaW4gYW5vdGhlciBpbml0cGxh biBwYXJhbWV0ZXIgYmVpbmcgaXNzdWVkCmZvciB0aGUgMm5kIHZlcnNpb24gb2YgdGhlIHN1YnBs YW4uICBUaGlzIGNvdWxkIHJlc3VsdCBpbiBlcnJvcnMgc3VjaCBhczoKCkVSUk9SOiAgV2luZG93 RnVuYyBub3QgZm91bmQgaW4gc3VicGxhbiB0YXJnZXQgbGlzdHMKClRvIGZpeCB0aGlzLCB3ZSBj aGFuZ2UgdGhlIG5vZGUgcmVwcmVzZW50YXRpb24gb2YgdGhlc2UgcnVuIGNvbmRpdGlvbnMKYW5k IGluc3RlYWQgb2Ygc3RvcmluZyBhbiBPcEV4cHIgY29udGFpbmluZyB0aGUgV2luZG93RnVuYyBp biBhIGxpc3QKaW5zaWRlIFdpbmRvd0NsYXVzZSwgd2Ugbm93IHN0b3JlIGEgbmV3IG5vZGUgdHlw ZSBuYW1lZApXaW5kb3dGdW5jUnVuQ29uZGl0aW9uIHdpdGhpbiBhIG5ldyBmaWVsZCBpbiB0aGUg V2luZG93RnVuYy4gIFRoZXNlIGdldAp0cmFuc2Zvcm1lZCBpbnRvIE9wRXhwcnMgbGF0ZXIgaW4g cGxhbm5pbmcgb25jZSBzdWJxdWVyeSBwdWxsLXVwIGhhcyBiZWVuCnBlcmZvcm1lZC4KClRoaXMg cHJvYmxlbSBkaWQgZXhpc3QgaW4gdjE1IGFuZCB2MTYsIGJ1dCB0aGF0IHdhcyBmaXhlZCBieSA5 ZDM2Yjg4M2IKYW5kIGU1ZDIwYmJkLgoKQ2F0IHZlcnNpb24gYnVtcCBkdWUgdG8gbmV3IG5vZGUg dHlwZSBhbmQgbW9kaWZ5aW5nIFdpbmRvd0Z1bmMgc3RydWN0LgoKQnVnOiAjMTgzMDUKUmVwb3J0 ZWQtYnk6IFp1bWluZyBKaWFuZwpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzE4MzA1 LTMzYzQ5YjRjODMwYjM3YjMlNDBwb3N0Z3Jlc3FsLm9yZwoKQnJhbmNoCi0tLS0tLQptYXN0ZXIK CkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZm LzdkMmM3ZjA4ZDljNWFkMDIxMDFjMGZiNDdjZDhlODU5ZGQ4OTA4M2IKCk1vZGlmaWVkIEZpbGVz Ci0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL25vZGVzL25vZGVGdW5jcy5jICAgICAgICAgICAg IHwgMjYgKysrKysrKysrKystLS0tCnNyYy9iYWNrZW5kL29wdGltaXplci9wYXRoL2FsbHBhdGhz LmMgICAgIHwgMzYgKysrKysrKy0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL29wdGltaXplci9w bGFuL2NyZWF0ZXBsYW4uYyAgIHwgIDIgKy0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3BsYW4vcGxh bm5lci5jICAgICAgfCA1NCArKysrKysrKysrKysrKysrKysrKysrKysrLS0tLS0tCnNyYy9iYWNr ZW5kL29wdGltaXplci9wcmVwL3ByZXBqb2ludHJlZS5jIHwgIDggLS0tLS0Kc3JjL2JhY2tlbmQv b3B0aW1pemVyL3V0aWwvY2xhdXNlcy5jICAgICAgfCAgMSArCnNyYy9iYWNrZW5kL29wdGltaXpl ci91dGlsL3BhdGhub2RlLmMgICAgIHwgIDMgKysKc3JjL2JhY2tlbmQvcGFyc2VyL3BhcnNlX2Ns YXVzZS5jICAgICAgICAgfCAgMSAtCnNyYy9iYWNrZW5kL3BhcnNlci9wYXJzZV9leHByLmMgICAg ICAgICAgIHwgIDEgKwpzcmMvYmFja2VuZC9wYXJzZXIvcGFyc2VfZnVuYy5jICAgICAgICAgICB8 ICAxICsKc3JjL2luY2x1ZGUvY2F0YWxvZy9jYXR2ZXJzaW9uLmggICAgICAgICAgfCAgMiArLQpz cmMvaW5jbHVkZS9ub2Rlcy9wYXJzZW5vZGVzLmggICAgICAgICAgICB8ICAyIC0tCnNyYy9pbmNs dWRlL25vZGVzL3BhdGhub2Rlcy5oICAgICAgICAgICAgIHwgIDEgKwpzcmMvaW5jbHVkZS9ub2Rl cy9wcmltbm9kZXMuaCAgICAgICAgICAgICB8IDMwICsrKysrKysrKysrKysrKysrCnNyYy9pbmNs dWRlL29wdGltaXplci9wYXRobm9kZS5oICAgICAgICAgIHwgIDEgKwpzcmMvdGVzdC9yZWdyZXNz L2V4cGVjdGVkL3dpbmRvdy5vdXQgICAgICB8IDE4ICsrKysrKysrKysrCnNyYy90ZXN0L3JlZ3Jl c3Mvc3FsL3dpbmRvdy5zcWwgICAgICAgICAgIHwgIDggKysrKysKc3JjL3Rvb2xzL3BnaW5kZW50 L3R5cGVkZWZzLmxpc3QgICAgICAgICAgfCAgMSArCjE4IGZpbGVzIGNoYW5nZWQsIDE0MyBpbnNl cnRpb25zKCspLCA1MyBkZWxldGlvbnMoLSkKCg== --===============2821113535153433857==--