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 1qqpXX-001Feu-KU for pgsql-committers@arkaria.postgresql.org; Thu, 12 Oct 2023 06:51:23 +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 1qqpXV-003yzp-D4 for pgsql-committers@arkaria.postgresql.org; Thu, 12 Oct 2023 06:51: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 1qqpXU-003yzV-SQ for pgsql-committers@lists.postgresql.org; Thu, 12 Oct 2023 06:51: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 1qqpXR-00055J-6l for pgsql-committers@lists.postgresql.org; Thu, 12 Oct 2023 06:51: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=QeE2OQB6AtTQ7DA72utU1EXL6z6ekD3MJ1BkDUE2rAM=; b=brkDQxkNTyN9c8HP8w0PR/WKPC EeMz4hTBGgEqM5FsUV9eNkGFsx2DIxkTiNiotxhrzJq3OSIZ2Mqkq9CBwscJ22y4LVF42s+t+x4G6 DZ3H03x4BYt98kfh3/H4tM1FpmrHJUlunpQhmMQOJeEQ27/WXosXtxHIpiKiF4cNj0XFwxb0v5iKh sfvMk8ETMWEBA7ERN/rDZilqmQ24RvqioDUU04g22+rTSo3wyrdcsV9QVRTZhNycywnMGnMTJFOr8 HE7exaLFLIMXnJuLoGWhkxS0WNrMCPzjijA/IrC7zpmVyXVvatZ/7KjFne1bqkopQ9T6GKl7gA2La GCsaH+0A==; 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 1qqpXQ-0000kP-QE for pgsql-committers@lists.postgresql.org; Thu, 12 Oct 2023 06:51:16 +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 1qqpXP-0007Vu-U7 for pgsql-committers@lists.postgresql.org; Thu, 12 Oct 2023 06:51:16 +0000 Content-Type: multipart/mixed; boundary="===============0604410488664881477==" MIME-Version: 1.0 From: David Rowley To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix incorrect step generation in HASH partition pruning X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 12 Oct 2023 06:51:16 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0604410488664881477== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IGluY29ycmVjdCBzdGVwIGdlbmVyYXRpb24gaW4gSEFTSCBwYXJ0aXRpb24gcHJ1bmluZwoK Z2V0X3N0ZXBzX3VzaW5nX3ByZWZpeF9yZWN1cnNlKCkgaW5jb3JyZWN0bHkgYXNzdW1lZCB0aGF0 IGl0IGNvdWxkIHN0b3AKcmVjdXJzaXZlIHByb2Nlc3Npbmcgb2YgdGhlICdwcmVmaXgnIGxpc3Qg d2hlbiBjdXJfa2V5bm8gd2FzIG9uZSBiZWZvcmUKdGhlIHN0ZXBfbGFzdGtleW5vLiAgU2luY2Ug aGFzaCBwYXJ0aXRpb24gcHJ1bmluZyBjYW4gcHJ1bmUgdXNpbmcgSVMKTlVMTCBxdWFscywgYW5k IHRoZXNlIElTIE5VTEwgcXVhbHMgYXJlIG5vdCBwcmVzZW50IGluIHRoZSAncHJlZml4JwpsaXN0 LCB0aGVuIHRoYXQgbG9naWMgY291bGQgY2F1c2UgbW9yZSBsZXZlbHMgb2YgcmVjdXJzaW9uIHRo YW4gd2hhdCBpcwpuZWVkZWQgYW5kIGxlYWQgdG8gdGhlcmUgYmVpbmcgbm8gbW9yZSBpdGVtcyBp biB0aGUgJ3ByZWZpeCcgbGlzdCB0bwpwcm9jZXNzLiAgVGhpcyB3b3VsZCBtYW5pZmVzdCBpdHNl bGYgYXMgYSBjcmFzaCBpbiBzb21lIGNvZGUgdGhhdApleHBlY3RlZCB0aGUgJ3N0YXJ0JyBMaXN0 Q2VsbCBub3QgdG8gYmUgTlVMTC4KCkhlcmUgd2UgYWRqdXN0IHRoZSBsb2dpYyBzbyB0aGF0IGlu c3RlYWQgb2Ygc3RvcHBpbmcgcmVjdXJzaW9uIGF0IDEga2V5CmJlZm9yZSB0aGUgc3RlcF9sYXN0 a2V5bm8sIHdlIGp1c3QgbG9vayBhdCB0aGUgbGxhc3QocHJlZml4KSBpdGVtIGFuZAplbnN1cmUg d2Ugb25seSByZWN1cnNpdmVseSBwcm9jZXNzIHVwIHVudGlsIGp1c3QgYmVmb3JlIHdoaWNoZXZl ciB0aGUgbGFzdAprZXkgaXMuICBUaGlzIGVmZmVjdGl2ZWx5IGFsbG93cyBrZXlzIHRvIGJlIG1p c3NpbmcgaW4gdGhlICdwcmVmaXgnIGxpc3QuCgpUaGlzIGNoYW5nZSBkb2VzIG1lYW4gdGhhdCBz dGVwX2xhc3RrZXlubyBpcyBubyBsb25nZXIgbmVlZGVkLCBzbyB3ZQpyZW1vdmUgdGhhdCBmcm9t IHRoZSBzdGF0aWMgZnVuY3Rpb25zLiAgSSBhbHNvIHNwZW50IHF1aXRlIHNvbWUgdGltZQpyZWFk aW5nIHRoaXMgY29kZSBhbmQgdGVzdGluZyBpdCB0byB0cnkgdG8gY29udmluY2UgbXlzZWxmIHRo YXQgdGhlcmUKYXJlIG5vIG90aGVyIGlzc3Vlcy4gIFRoYXQgcmVzdWx0ZWQgaW4gdGhlIGlycmVz aXN0aWJsZSB0ZW1wdGF0aW9uIG9mCnJld3JpdGluZyBzb21lIGNvbW1lbnRzLCBtYW55IG9mIHdo aWNoIHdlcmUganVzdCBub3QgdHJ1ZSBvciBpbmNvbmNpc2UuCgpSZXBvcnRlZC1ieTogU2VyZ2Vp IEdsdWtob3YKUmV2aWV3ZWQtYnk6IFNlcmdlaSBHbHVraG92LCB0ZW5kZXIgd2FuZwpEaXNjdXNz aW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzJmMDljZTcyLTMxNWUtMmEzMy01ODlhLTg1MTlhZGE4 ZGY2MUBwb3N0Z3Jlc3Byby5ydQpCYWNrcGF0Y2gtdGhyb3VnaDogMTEsIHdoZXJlIHBhcnRpdGlv biBwcnVuaW5nIHdhcyBpbnRyb2R1Y2VkLgoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMK LS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmL2YwYzQwOWQ5 YzdhNmE5MmJiNGE2YjU4MTJmZmM1ZWY5NGI0YzhlZDAKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0t LS0tLS0tCnNyYy9iYWNrZW5kL3BhcnRpdGlvbmluZy9wYXJ0cHJ1bmUuYyAgICAgICAgICB8IDEw MyArKysrKystLS0tLS0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9wYXJ0aXRpb25fcHJ1bmUu b3V0IHwgMjE5ICsrKysrKysrKysrKysrKysrKysrKysrKy0tCnNyYy90ZXN0L3JlZ3Jlc3Mvc3Fs L3BhcnRpdGlvbl9wcnVuZS5zcWwgICAgICB8ICA1NSArKysrKystCjMgZmlsZXMgY2hhbmdlZCwg MzE1IGluc2VydGlvbnMoKyksIDYyIGRlbGV0aW9ucygtKQoK --===============0604410488664881477==--