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 1t0Kbh-00AoqU-PJ for pgsql-bugs@arkaria.postgresql.org; Mon, 14 Oct 2024 12:55:29 +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 1t0Kbf-00DS6p-Jq for pgsql-bugs@arkaria.postgresql.org; Mon, 14 Oct 2024 12:55:27 +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 1t0HAT-00Bscd-Km for pgsql-bugs@lists.postgresql.org; Mon, 14 Oct 2024 09:15:10 +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.94.2) (envelope-from ) id 1t0HAQ-000yvU-9N for pgsql-bugs@lists.postgresql.org; Mon, 14 Oct 2024 09:15: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=ZvR/kGZBJTS3WuaPfSC6ns2u/0AQs2wnYdI2XUSjxHs=; b=v4dkOJZSGKfLjd1pKyoFejNfi0 q/Nr0z7O03eudn80aXxfQ0N5Sx+cDpSbZe88YWmdLNtOWdgiB6VuHyOv526suAYxw+SseueaeOV3J s3uTYr7OFXRABg21MSFsmBnWPBIVzHHfrcNDeGdApXQURLPoOCvOpRg43N98IXpmOGgw7gVvGfjhj i9PHtnij354VB+JRkswvdQ3nCC0aioKs0tiRfGV8e4sJR/joFZ7+sImwJTCzHuou5VwKI6x3Upxw/ jOqVG2izdsIGxQTcd97J0ym/WijwI8c6u8KyhFf4uHdJMKAPwC7UjOS+15ncVU7Y/oPjX1urBZ4hN 9ka1kljg==; 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 1t0HAO-002ajq-Is for pgsql-bugs@lists.postgresql.org; Mon, 14 Oct 2024 09:15:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1t0HAM-004UJD-LI for pgsql-bugs@lists.postgresql.org; Mon, 14 Oct 2024 09:15:03 +0000 Content-Type: multipart/mixed; boundary="===============0104017181888035160==" MIME-Version: 1.0 Subject: BUG #18654: From fuzzystrmatch, levenshtein function with costs parameters produce incorrect results To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: bjdev.gthb@laposte.net Reply-To: bjdev.gthb@laposte.net, pgsql-bugs@lists.postgresql.org Date: Mon, 14 Oct 2024 09:14:50 +0000 Message-ID: <18654-c09f568d3ba6dfcd@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 --===============0104017181888035160== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODY1NApMb2dnZWQgYnk6ICAgICAgICAgIGJqZGV2CkVtYWlsIGFkZHJl c3M6ICAgICAgYmpkZXYuZ3RoYkBsYXBvc3RlLm5ldApQb3N0Z3JlU1FMIHZlcnNpb246IDE1LjQK T3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMjIuMDQuNSBMVFMKRGVzY3JpcHRpb246ICAgICAg ICAKCkhpLA0KDQpUaGUgZXh0ZW5zaW9uIGZ1enp5c3RybWF0Y2ggcHJvcG9zZSBhbiBpbXBsZW1l bnRhdGlvbiBvZiBsZXZlbnNodGVpbgpmdW5jdGlvbi4NClRoZXJlIGlzIG9uZSB2ZXJzaW9uIHdp dGggY29zdHMgcGFyYW1ldGVycw0KbGV2ZW5zaHRlaW4odGV4dCBzb3VyY2UsIHRleHQgdGFyZ2V0 LCBpbnQgaW5zX2Nvc3QsIGludCBkZWxfY29zdCwgaW50CnN1Yl9jb3N0KSByZXR1cm5zIGludA0K DQpCdXQgaWYgd2UgdXNlIHRoaXMgZnVuY3Rpb24gd2l0aCBwYXJhbWV0ZXJzIG90aGVyIHRoYW4g MSAodGhlIGRlZmF1bHQpIHRoZQpyZXN1bHQgaXMgaW5jb3JyZWN0DQoNClNFTEVDVCBsZXZlbnNo dGVpbignaG9yc2VzJywnc2hvcnNlJywxLDEsMSkgPT4gMiAoY29ycmVjdCkNCg0KU0VMRUNUIGxl dmVuc2h0ZWluKCdob3JzZXMnLCdzaG9yc2UnLDEwMCwxMCwxKSA9PiAxMDEgKElOQ09SUkVDVCkN ClRoZSBjb3JyZWN0IHJlc3VsdCBpcyA2IChhbGwgdGhlIGxldHRlciBoYXZlIHRvIGJlIHN1YnN0 aXR1dGUgYW5kIGl0J3Mgbm90CnBvc3NpYmxlIHRvIGhhdmUgYSBsb3dlciBzY29yZSB3aXRoIG90 aGVycyBvcGVyYXRpb25zKQ0KSGVyZSwgaXQncyBlYXN5IHRvIHZlcmlmeSBtYW51YWxseSBidXQg eW91IGNhbiBjaGVjayB0aGF0IHVzaW5nIHB5dGhvbgppbXBsZW1lbnRhdGlvbiANCmZyb20gTGV2 ZW5zaHRlaW4gaW1wb3J0IGRpc3RhbmNlDQpkaXN0YW5jZSgiaG9yc2VzIiwic2hvcnNlIix3ZWln aHRzPSgxMDAsMTAsMSkpDQojID0+IDYNCg0KU0VMRUNUIGxldmVuc2h0ZWluKCdob3JzZXMnLCdz aG9yc2UnLDEsMTAsMTAwKSA9PiAxMiAoSU5DT1JSRUNUKQ0KVGhlIGNvcnJlY3QgcmVzdWx0IGlz IDExIChpbnNlcnQgInMiIGZpcnN0ICgrMSkgYW5kIHJlbW92ZSBsYXN0ICJzIigrMTApDQpIZXJl LCBpdCdzIGVhc3kgdG8gdmVyaWZ5IG1hbnVhbGx5IGJ1dCB5b3UgY2FuIGNoZWNrIHRoYXQgdXNp bmcgcHl0aG9uCmltcGxlbWVudGF0aW9uIA0KZnJvbSBMZXZlbnNodGVpbiBpbXBvcnQgZGlzdGFu Y2UNCmRpc3RhbmNlKCJob3JzZXMiLCJzaG9yc2UiLHdlaWdodHM9KDEsMTAsMTAwKSkNCiMgPT4g MTENCg0KU0VMRUNUIGxldmVuc2h0ZWluKCdob3JzZXMnLCdzaG9yc2UnLDEsMTAsMSkgPT4gMiAo SU5DT1JSRUNUKQ0KVGhlIGNvcnJlY3QgcmVzdWx0IGlzIDYNCnlvdSBjYW4gY2hlY2sgdGhhdCB1 c2luZyBweXRob24gaW1wbGVtZW50YXRpb24gDQpmcm9tIExldmVuc2h0ZWluIGltcG9ydCBkaXN0 YW5jZQ0KZGlzdGFuY2UoImhvcnNlcyIsInNob3JzZSIsd2VpZ2h0cz0oMSwxMCwxKSkNCiMgPT4g Ng0KDQpUaGUgdXNlIG9mIGNvc3QgcGFyYW1ldGVycyBvZiB0aGUgbGV2ZW5zaHRlaW4gZnVuY3Rp b24gaXMgdGhlcmVmb3JlIG5vdApwb3NzaWJsZSwgd2hpY2ggaXMgYSBzaGFtZS4NCg0KUmVnYXJk cwoK --===============0104017181888035160==--