pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: martin@schlossarek.me
Subject: BUG #18057: unaccent removes intentional spaces
Date: Tue, 15 Aug 2023 19:54:57 +0000
Message-ID: <18057-62712cad01bd202c@postgresql.org> (raw)

The following bug has been logged on the website:

Bug reference:      18057
Logged by:          Martin Schlossarek
Email address:      martin@schlossarek.me
PostgreSQL version: 15.1
Operating system:   Fedora 38
Description:        

I discovered that the unaccent extension also removes intentional spaces
that are explicitly specified in the accent.rules. As far as I see it
correctly, all fraction characters are affected, for example:

```sql
# select unaccent('1½');
--- expected output: 1 1/2
--- actual output: 11/2
```

Affected characters:
```bash
$ curl -s
"https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob_plain;f=contrib/unaccent/unaccent.rules;h...;
| grep -E " "
¼        1/4
½        1/2
¾        3/4
⅐        1/7
⅑        1/9
⅒        1/10
⅓        1/3
⅔        2/3
⅕        1/5
⅖        2/5
⅗        3/5
⅘        4/5
⅙        1/6
⅚        5/6
⅛        1/8
⅜        3/8
⅝        5/8
⅞        7/8
⅟        1/
↉        0/3
```



view thread (10+ messages)  latest in thread

Message-ID: <18057-62712cad01bd202c@postgresql.org>
Permalink:  ../18057-62712cad01bd202c@postgresql.org/
Also on:    postgresql.org/message-id/18057-62712cad01bd202c@postgresql.org

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, martin@schlossarek.me
  Subject: Re: BUG #18057: unaccent removes intentional spaces
  In-Reply-To: <18057-62712cad01bd202c@postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox