Thread: Sorting difference in version 10 vs 13

Hi


I have performed logical replication from a 10.18 to 13.4.

in 13.4, order by asc gives underscores higher than other characters. 
all the LC parameters are identical across both instances.

Am I missing anything else?


Help appreciated.

Thanks

Akheel Ahmed <akheel.mailing.list@gmail.com> writes:
> in 13.4, order by asc gives underscores higher than other characters. 
> all the LC parameters are identical across both instances.
> Am I missing anything else?

OS-level differences, perhaps?

https://wiki.postgresql.org/wiki/Locale_data_changes

            regards, tom lane

Both are Amazon AWS Aurora instances. 10.x is on intel/amd64. 13.x is on their ARM based graviton.

select version();
                                                   version
-------------------------------------------------------------------------------------------------------------
 PostgreSQL 13.4 on aarch64-unknown-linux-gnu, compiled by aarch64-unknown-linux-gnu-gcc (GCC) 7.4.0, 64-bit
(1 row)

select version();
                                             version
--------------------------------------------------------------------------------------------------
 PostgreSQL 10.18 on x86_64-pc-linux-gnu, compiled by x86_64-pc-linux-gnu-gcc (GCC) 7.4.0, 64-bit
(1 row)

Akheel Ahmed <akheel.mailing.list@gmail.com> writes:

in 13.4, order by asc gives underscores higher than other characters. 
all the LC parameters are identical across both instances.
Am I missing anything else?

OS-level differences, perhaps?

https://wiki.postgresql.org/wiki/Locale_data_changes
			regards, tom lane

Aurora is sufficiently different from vanilla Postgresql that you need to ask Amazon.

Both are Amazon AWS Aurora instances. 10.x is on intel/amd64. 13.x is on their ARM based graviton.

select version();
                                                   version
-------------------------------------------------------------------------------------------------------------
 PostgreSQL 13.4 on aarch64-unknown-linux-gnu, compiled by aarch64-unknown-linux-gnu-gcc (GCC) 7.4.0, 64-bit
(1 row)

select version();
                                             version
--------------------------------------------------------------------------------------------------
 PostgreSQL 10.18 on x86_64-pc-linux-gnu, compiled by x86_64-pc-linux-gnu-gcc (GCC) 7.4.0, 64-bit
(1 row)

On 21/12/2021 3:12 pm, Tom Lane wrote:

Akheel Ahmed <akheel.mailing.list@gmail.com> writes:

in 13.4, order by asc gives underscores higher than other characters. 
all the LC parameters are identical across both instances.
Am I missing anything else?

OS-level differences, perhaps?

https://wiki.postgresql.org/wiki/Locale_data_changes
			regards, tom lane