Re: Corruption or wrong results with 14.10?

[Torsten Förtsch <tfoertsch123@xxxxxxxxx>]

On Thu, Nov 23, 2023 at 2:29 PM Daniel Westermann (DWE) <daniel.westermann@xxxxxxxxxxxxxxxx> wrote:

smrdbprod=# select crart_id, chemin, count(*) from smrr_mgr.formula group by  crart_id, chemin having count(*) > 1;

  crart_id   | chemin | count

-------------+--------+-------

 35054630000 | @      |     2

  4737310000 | @      |     2

 10632380000 | @      |     2

 14680880000 | @      |     2

  4627230000 | @      |     2

 10993780000 | @      |     2

....

I think I know what I have to do.

If you have moved the database from a system with glibc <2.28 to >=2.28, that could be the reason.

https://wiki.postgresql.org/wiki/Collations