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.96) (envelope-from ) id 1vKsYC-00BwRs-18 for pgsql-bugs@arkaria.postgresql.org; Mon, 17 Nov 2025 06:17:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vKsY9-00COWV-2x for pgsql-bugs@arkaria.postgresql.org; Mon, 17 Nov 2025 06:17:17 +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.96) (envelope-from ) id 1vKsQH-00CIA7-1p for pgsql-bugs@lists.postgresql.org; Mon, 17 Nov 2025 06:09: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 1vKsQD-0089Qq-3A for pgsql-bugs@lists.postgresql.org; Mon, 17 Nov 2025 06:09:09 +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=zsvN3hgO1WD9kFtIvFBseZWOmFoIubaJX6Fp8+1KS10=; b=IiSNO62kZgiEGS9cINNFTrymTK JQAEXkHLem5K4Wg8yg5+wrlREqe6dn6mdXBQbK0OSk4cVigPueQjdzZ3osoCbmE1dyEKfWIw1cj1u sRz9omV+DIZkzdAe0UHdpzOG/AnmoxkubcSqyz+GHnfDuZZHTAZdq0fzMJZWBUdLHOnuqmk012gh+ UlZlvyUf2DHLyvwk5R6wVrkFHR/PP2dewYMXbmBb++6XhQB9+N7eJ9oxb3mlVc/wmnftac9fpPGnZ rPa/w1ipU8yPejU53ZOXLUQ4b8LrxKsXqX6Cia+jpKcmbv7ol508XGPcrb47xIF94ECoxWAZKr98D XFlyqHdQ==; 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 1vKsQC-00Fh90-DO for pgsql-bugs@lists.postgresql.org; Mon, 17 Nov 2025 06:09: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 1vKsQA-003r3i-0h for pgsql-bugs@lists.postgresql.org; Mon, 17 Nov 2025 06:09:02 +0000 Content-Type: multipart/mixed; boundary="===============2942975282416534036==" MIME-Version: 1.0 Subject: BUG #19114: ORDER BY ASC is tampering result when calculating distance btw vectors To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: naveenkrishna.s@sky.uk Reply-To: naveenkrishna.s@sky.uk, pgsql-bugs@lists.postgresql.org Date: Mon, 17 Nov 2025 06:08:30 +0000 Message-ID: <19114-b0d2502c853fe210@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 --===============2942975282416534036== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTExNApMb2dnZWQgYnk6ICAgICAgICAgIE5hdmVlbiBLcmlzaG5hIFMK RW1haWwgYWRkcmVzczogICAgICBuYXZlZW5rcmlzaG5hLnNAc2t5LnVrClBvc3RncmVTUUwgdmVy c2lvbjogMTQuMTMKT3BlcmF0aW5nIHN5c3RlbTogICBNYWMgT1MKRGVzY3JpcHRpb246ICAgICAg ICAKCkluIGEgdGFibGUgd2l0aCB2ZWN0b3IgY29sdW1uLApTRUxFQ1QgZW1iZWRkaW5nIDw9PiBD QVNUKCdbMC4wMSwgMC4yMywgLTAuMSwuLl0nIGFzIHZlY3RvcikKQVMgZGlzdGFuY2UKRlJPTSBt eV90YWJsZQpXSEVSRSBUUlVFCm9yZGVyIGJ5IGRpc3RhbmNlIGRlc2MKTElNSVQgMTAwOwoKaXMg Z2l2aW5nIDEwMCByZWNvcmRzIHdoZXJlYXMKClNFTEVDVCBlbWJlZGRpbmcgPD0+IENBU1QoJ1sw LjAxLCAwLjIzLCAtMC4xLC4uXScgYXMgdmVjdG9yKQpBUyBkaXN0YW5jZQpGUk9NIG15X3RhYmxl CldIRVJFIFRSVUUKb3JkZXIgYnkgZGlzdGFuY2UgYXNjCkxJTUlUIDEwMDsKCmlzIGdpdmluZyA0 MCByZWNvcmRzIGZvciBhIHNwZWNpZmljIGVtYmVkZGluZyBhbmQgYWx3YXlzIGxlc3MgdGhhbiB0 aGUgbGltaXQKZm9yIGFueSBxdWVyeSBlbWJlZGRpbmcuIFdoeSBpcyB0aGlzPwpJIGhhdmUgYWxz byBub3RpY2VkIGlmIEkgdXNlIE5VTExTIEZJUlNUIG9yIENPQUxFU0NFKGRpc3RhbmNlLCA5OTk5 OTk5OTk5OSkKaXQgaXMgcmV0dXJuaW5nIHRoZSByZXF1ZXN0ZWQgbGltaXQuIEJ1dCB3aGVuIEkg dHJpZWQgdG8gbGlzdCB0aGUgcmVjb3Jkcwp3aXRoIGRpc3RhbmNlIGFzIG51bGwsIHRoZXJlIHdl cmUgbm9uZS4KCg== --===============2942975282416534036==--