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 1uwiPh-006Zox-RM for pgsql-bugs@arkaria.postgresql.org; Thu, 11 Sep 2025 14:36:41 +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 1uwiPg-0084bT-5W for pgsql-bugs@arkaria.postgresql.org; Thu, 11 Sep 2025 14:36:40 +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 1uwgZw-007LXQ-T8 for pgsql-bugs@lists.postgresql.org; Thu, 11 Sep 2025 12:39:09 +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 1uwgZt-000Bh1-0J for pgsql-bugs@lists.postgresql.org; Thu, 11 Sep 2025 12:39:08 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=9b5ATbzacYJqe9t8hmGHRcRMAgi7nCP26LAGVnxML3s=; b=jSO/7c+lOgIpKx1ODp2Wz6t3h/ /4EcJzcKIttsv4FGq4LbaJSkeLykLd14bHJgRs8d6eE/L5bJdk3L55p27QN2BWw/1Ml7UlWp0QVeF 5HMwgTHROx0F6LOlGhFt8VjATUzq8cernQwdsma9msUQKtzP5tivWv76karHkC0PLVxiHHFIQCCyc ohxxb7Dw3Niyk8cMsT+8aSDoRroOvtD8xInIPPujFdbSh57MHEDt4WsDBYA2L3vlOx5sQ6+q6mNjZ xQTC7PRvv9i8YkZWkKCPhZ/JaR/CZf/8oQvUEJJr/ly5ZJzYqJzBLIXouOOBcKUB4RB6K26rrjonB TRNF0ZMA==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uwgZs-004dSc-B6 for pgsql-bugs@lists.postgresql.org; Thu, 11 Sep 2025 12:39:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1uwgZr-008T1x-0m for pgsql-bugs@lists.postgresql.org; Thu, 11 Sep 2025 12:39:03 +0000 Content-Type: multipart/mixed; boundary="===============2350292193338001559==" MIME-Version: 1.0 Subject: BUG #19049: Assert failure when using skip arrays on an index key with DESC order To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: natalya@timescale.com Reply-To: natalya@timescale.com, pgsql-bugs@lists.postgresql.org Date: Thu, 11 Sep 2025 12:38:11 +0000 Message-ID: <19049-b7df801e71de41b2@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2350292193338001559== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTA0OQpMb2dnZWQgYnk6ICAgICAgICAgIE5hdGFseWEgQWtzbWFuCkVt YWlsIGFkZHJlc3M6ICAgICAgbmF0YWx5YUB0aW1lc2NhbGUuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMThyYzEKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMjQuMDQKRGVzY3JpcHRpb246ICAg ICAgICAKClJlcHJvZHVjZXI6CgotLSBTZXQgdXAgYSB0YWJsZSB3aXRoID49MiBERVNDIGluZGV4 IGtleXMKY3JlYXRlIHRhYmxlIG12ICh0MSBpbnQsIHQyIGludCwgczAgaW50LCBzMSBpbnQpOwpj cmVhdGUgaW5kZXggb24gbXYoczAsIHMxLCB0MSBkZXNjLCB0MiBkZXNjKTsKaW5zZXJ0IGludG8g bXYgc2VsZWN0IGYudCwgIGYudCwgMSBzMCwgMSBzMSBmcm9tIGdlbmVyYXRlX3NlcmllcygxLCAy ICoKcG93KDEwLCA0KTo6aW50KSBmKHQpOwphbmFseXplIG12OwoKLS0gTWFrZSBzdXJlIGluZGV4 IGlzIHVzZWQKc2V0IGVuYWJsZV9zZXFzY2FuPTA7CmV4cGxhaW4gKGNvc3RzIG9mZikgc2VsZWN0 IGRpc3RpbmN0IG9uKHMwLCBzMSkgKiBmcm9tIG12IHdoZXJlIHQyID49IC0xIGFuZAp0MSA8IDEw IG9yZGVyIGJ5IHMwLCBzMSwgdDEgZGVzYywgdDIgZGVzYzsKICAgICAgICAgICAgICAgICAgICAg ICAgUVVFUlkgUExBTgotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLQogVW5pcXVlCiAgIC0+ICBJbmRleCBPbmx5IFNjYW4gdXNpbmcgbXZf czBfczFfdDFfdDJfaWR4IG9uIG12CiAgICAgICAgIEluZGV4IENvbmQ6ICgodDEgPCAxMCkgQU5E ICh0MiA+PSAnLTEnOjppbnRlZ2VyKSkKKDMgcm93cykKCi0tIFRoaXMgcXVlcnkgY3Jhc2hlcyB3 aXRoIGFuIEFzc2VydAogc2VsZWN0IGRpc3RpbmN0IG9uKHMwLCBzMSkgKiBmcm9tIG12IHdoZXJl IHQyID49IC0xIGFuZCB0MSA8IDEwIG9yZGVyIGJ5CnMwLCBzMSwgdDEgZGVzYywgdDIgZGVzYzsK CkFzc2VydCBpczoKICAgICAgICAgICAgICAgIGlmIChTY2FuRGlyZWN0aW9uSXNGb3J3YXJkKGRp cikgJiYgYXJyYXktPmxvd19jb21wYXJlKQpBc3NlcnQoRGF0dW1HZXRCb29sKEZ1bmN0aW9uQ2Fs bDJDb2xsKCZhcnJheS0+bG93X2NvbXBhcmUtPnNrX2Z1bmMsCmFycmF5LT5sb3dfY29tcGFyZS0+ c2tfY29sbGF0aW9uLAp0dXBkYXR1bSwKYXJyYXktPmxvd19jb21wYXJlLT5za19hcmd1bWVudCkp KTsKClRoZSBwcm9ibGVtIGlzICJhcnJheS0+bG93X2NvbXBhcmUiIGNoYW5naW5nICJ0MTwxMCIg dG8gInQxPjEwIiBiZWNhdXNlIHQxCm9yZGVyIGlzIERFU0MuCgo= --===============2350292193338001559==--