ts_parse reports different between MacOS, FreeBSD/Linux - Mailing list pgsql-general

From Mark Felder
Subject ts_parse reports different between MacOS, FreeBSD/Linux
Date
Msg-id 543023b3-7c17-4ed5-81d5-c6092ea98919@www.fastmail.com
Whole thread Raw
Responses Re: ts_parse reports different between MacOS, FreeBSD/Linux
List pgsql-general
Hello,

We have an application whose test suite fails on MacOS when running the search tests on unicode characters.

I've narrowed it down to the following:

macos=# select * from ts_parse('default','天');
 tokid | token
-------+-------
    12 | 天
(1 row)

freebsd=# select * from ts_parse('default','天');
 tokid | token
-------+-------
     2 | 天
(1 row)


This has been bugging me for a while, but it's a test our devs using MacOS just ignores for now as we know it passes
ourCI/CD pipeline on FreeBSD/Linux. It seems if anyone is shipping an app on MacOS and bundling Postgres they're going
tohave a bad time with searching. 


Please let me know if there's anything I can do to help. Will gladly test patches.



Thanks,



--
  Mark Felder
  ports-secteam & portmgr alumni
  feld@FreeBSD.org



pgsql-general by date:

Previous
From: "Joel Jacobson"
Date:
Subject: Re: Avoid excessive inlining?
Next
From: Adrian Klaver
Date:
Subject: Re: Missing rows after migrating from postgres 11 to 12 with logical replication