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 1txfiG-00CxMf-4b for pgsql-committers@arkaria.postgresql.org; Thu, 27 Mar 2025 05:23:32 +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 1txfiE-00H4VS-8t for pgsql-committers@arkaria.postgresql.org; Thu, 27 Mar 2025 05:23:30 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1txfiD-00H4VJ-WA for pgsql-committers@lists.postgresql.org; Thu, 27 Mar 2025 05:23:30 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1txfiB-001S8E-0J for pgsql-committers@lists.postgresql.org; Thu, 27 Mar 2025 05:23:29 +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=OXKCXIOGDBY3b398WY0860Escp0zBr6VJbJe8tLMHhY=; b=ksp2ksmk+rqrNW/NAoLK0Ttjn8 TE5bAM0w6Mdd0Gx3iForxqdrt/uIZI4q5R3/VLNwhLElwdeFK8ddioRn+GNcJu9B0cDStfXm7t2wO 53U6YHkr4QFioutH4WXs7Ax5F5Lh+0Ho7vY9oyCj2JhOYMIUPw7/5uXKDJAXcKpVR+7a/pIcwhf6h mo6ee9R7qBnORJLeYj7ftWUPyceVidiOEs/Jz1w9PSGcWawxuFwGjOz7Tt6NI0x6pl9BMMe8QTl8Z JkWGE+8c54o/tXmh2dkLrJ/0xDtsUN0GRK5besVgGWQ3X31AAhNSBTW6c866qkuCkTdzr8rghDd7q YWO9rWgw==; 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 1txfi9-00DXlz-8x for pgsql-committers@lists.postgresql.org; Thu, 27 Mar 2025 05:23:25 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1txfi8-001CxO-1c for pgsql-committers@lists.postgresql.org; Thu, 27 Mar 2025 05:23:24 +0000 Content-Type: multipart/mixed; boundary="===============3955743474342066787==" MIME-Version: 1.0 From: David Rowley To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix query jumbling to account for NULL nodes X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 27 Mar 2025 05:23:24 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3955743474342066787== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IHF1ZXJ5IGp1bWJsaW5nIHRvIGFjY291bnQgZm9yIE5VTEwgbm9kZXMKClByZXZpb3VzbHkg TlVMTCBub2RlcyB3ZXJlIGlnbm9yZWQuICBUaGlzIGNvdWxkIGNhdXNlIGlzc3VlcyB3aGVyZSB0 aGUKY29tcHV0ZWQgcXVlcnkgSUQgY291bGQgbWF0Y2ggZm9yIHF1ZXJpZXMgd2hlcmUgZmllbGRz IHRoYXQgYXJlIG5leHQgdG8KZWFjaCBvdGhlciBpbiB0aGVpciBOb2RlIHN0cnVjdCB3aGVyZSBv bmUgZmllbGQgd2FzIE5VTEwgYW5kIHRoZSBvdGhlcgpub24tTlVMTC4gIEZvciBleGFtcGxlLCB0 aGUgUXVlcnkgc3RydWN0IGhhZCBkaXN0aW5jdENsYXVzZSBhbmQgc29ydENsYXVzZQpuZXh0IHRv IGVhY2ggb3RoZXIuICBJZiBzb21lb25lIHdyb3RlOwoKU0VMRUNUIERJU1RJTkNUIGMxIEZST00g dDsKCmFuZCB0aGVuOwoKU0VMRUNUIGMxIEZST00gdCBPUkRFUiBCWSBjMTsKCnRoZXNlIHdvdWxk IHByb2R1Y2UgdGhlIHNhbWUgcXVlcnkgSUQgc2luY2UsIGluIHRoZSBmaXJzdCBxdWVyeSwgd2UK aWdub3JlZCB0aGUgTlVMTCBzb3J0Q2xhdXNlIGFuZCBhcHBlbmRlZCB0aGUganVtYmxlIGJ5dGVz IGZvciB0aGUKZGlzdGljdENsYXVzZS4gIEluIHRoZSBsYXR0ZXIgcXVlcnksIHNpbmNlIHdlIGRp ZCBub3RoaW5nIGZvciB0aGUgTlVMTApkaXN0aW5jdENsYXVzZSB0aGVuIGp1bWJsZSB0aGUgbm9u LU5VTEwgc29ydENsYXVzZSwgYW5kIHNpbmNlIHRoZSBub2RlCnJlcHJlc2VudGF0aW9uIHN0b3Jl ZCBpcyB0aGUgc2FtZSBpbiBib3RoIGNhc2VzLCB0aGUgcXVlcnkgSURzIHdlcmUKaWRlbnRpY2Fs LgoKSGVyZSB3ZSBmaXggdGhpcyBieSBhbHdheXMgYWNjb3VudGluZyBmb3IgTlVMTCBub2RlcyBi eSByZWNvcmRpbmcgdGhhdAp3ZSBzYXcgYSBOVUxMIGluIHRoZSBqdW1ibGUgYnVmZmVyLiAgVGhp cyBmaXhlcyB0aGUgaXNzdWUgYXMgdGhlIG9yZGVyIHRoYXQKdGhlIE5VTEwgaXMgcmVjb3JkZWQg aXNuJ3QgdGhlIHNhbWUgaW4gdGhlIGFib3ZlIHR3byBxdWVyaWVzLgoKQXV0aG9yOiBCeWtvdiBJ dmFuIDxpLmJ5a292QG1vZGVybnN5cy5ydT4KQXV0aG9yOiBNaWNoYWVsIFBhcXVpZXIgPG1pY2hh ZWxAcGFxdWllci54eXo+CkF1dGhvcjogRGF2aWQgUm93bGV5IDxkZ3Jvd2xleW1sQGdtYWlsLmNv bT4KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9hYWZjZTc5NjZlMjM0MzcyYjJiYTg3 NmMwMTkzZjFlOSU0MGxvY2FsaG9zdC5sb2NhbGRvbWFpbgoKQnJhbmNoCi0tLS0tLQptYXN0ZXIK CkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZm L2YzMWFhZDliMDdiN2E2ZWY2OTNkNzA1OTgzMGJkMmYxNTA0OTc2YWUKCk1vZGlmaWVkIEZpbGVz Ci0tLS0tLS0tLS0tLS0tCmNvbnRyaWIvcGdfc3RhdF9zdGF0ZW1lbnRzL2V4cGVjdGVkL3NlbGVj dC5vdXQgfCAgODcgKysrKysrKysrKysrKystCmNvbnRyaWIvcGdfc3RhdF9zdGF0ZW1lbnRzL3Nx bC9zZWxlY3Quc3FsICAgICAgfCAgMjAgKysrKwpzcmMvYmFja2VuZC9ub2Rlcy9xdWVyeWp1bWJs ZWZ1bmNzLmMgICAgICAgICAgIHwgMTQwICsrKysrKysrKysrKysrKysrKysrKy0tLS0Kc3JjL2lu Y2x1ZGUvbm9kZXMvcXVlcnlqdW1ibGUuaCAgICAgICAgICAgICAgICB8ICAxMiArKysKNCBmaWxl cyBjaGFuZ2VkLCAyMzggaW5zZXJ0aW9ucygrKSwgMjEgZGVsZXRpb25zKC0pCgo= --===============3955743474342066787==--