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 1qqpY6-001Fhs-IS for pgsql-committers@arkaria.postgresql.org; Thu, 12 Oct 2023 06:51:58 +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 1qqpY4-003za0-CG for pgsql-committers@arkaria.postgresql.org; Thu, 12 Oct 2023 06:51:57 +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 1qqpY4-003zZb-4v for pgsql-committers@lists.postgresql.org; Thu, 12 Oct 2023 06:51:56 +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 1qqpY2-00055h-AQ for pgsql-committers@lists.postgresql.org; Thu, 12 Oct 2023 06:51:55 +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=a1C9MOv51wEnYES7RX6TVjSt5di7YcLzpUTROIRBQ1c=; b=E3AFkI3vBHI0KqGLhaViVHIIdW 5NbY1TyuUDf5tyACsV+m4ZeTXpB6WbP+lSMwSLA/YL5G12NcMJOCsCIjU7cGXKGTTYaNQreiA/EQB jtXzgAo1L48yLMjLYYaoM0OxJmu13LJtvhFK2aTCk7YnYlrIG1b8vdTKsseqO6JMrcy1hTLg/ey2C OdUTPen1tzHS50WW7i4prKY96l6NLm2MvgntY9JSVc3wzsqR3LrlPNMCngXjVVwPH/KvgxoBxl7qj re9a8UclluCYqEFgscgFPzDbCOgjDSkYbqfN3+u4Dm6HCMLGkdWOWJLeCfNsrck0AaGaZ5yuC/FPm e2S+gFnQ==; 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 1qqpY2-0000kd-0z for pgsql-committers@lists.postgresql.org; Thu, 12 Oct 2023 06:51:54 +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 1qqpY1-0007Wt-3L for pgsql-committers@lists.postgresql.org; Thu, 12 Oct 2023 06:51:53 +0000 Content-Type: multipart/mixed; boundary="===============9207492615251216926==" 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:53 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============9207492615251216926== 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 biBwcnVuaW5nIHdhcyBpbnRyb2R1Y2VkLgoKQnJhbmNoCi0tLS0tLQpSRUxfMTZfU1RBQkxFCgpE ZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi82 MzUyZjE2Mjc2NDEwMjVmOTA0MjNiNDQ3MTZiNmFkNWYyYWRiN2I2CgpNb2RpZmllZCBGaWxlcwot LS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9wYXJ0aXRpb25pbmcvcGFydHBydW5lLmMgICAgICAg ICAgfCAxMDMgKysrKysrLS0tLS0tCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvcGFydGl0aW9u X3BydW5lLm91dCB8IDIxOSArKysrKysrKysrKysrKysrKysrKysrKystLQpzcmMvdGVzdC9yZWdy ZXNzL3NxbC9wYXJ0aXRpb25fcHJ1bmUuc3FsICAgICAgfCAgNTUgKysrKysrLQozIGZpbGVzIGNo YW5nZWQsIDMxNSBpbnNlcnRpb25zKCspLCA2MiBkZWxldGlvbnMoLSkKCg== --===============9207492615251216926==--