diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/arrays.out C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/arrays.out --- C:/cirrus/src/test/regress/expected/arrays.out 2024-10-02 11:08:56.222982200 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/arrays.out 2024-10-02 11:13:38.569286600 +0000 @@ -2747,82 +2747,78 @@ (1 row) SELECT array_sort('{abc DEF 123abc,ábc sßs ßss DÉF,DŽxxDŽ džxxDž Džxxdž,ȺȺȺ,ⱥⱥⱥ,ⱥȺ}'::text[]); - array_sort ------------------------------------------------------------------- - {"abc DEF 123abc","ábc sßs ßss DÉF",ⱥȺ,ⱥⱥⱥ,ȺȺȺ,"DŽxxDŽ džxxDž Džxxdž"} + array_sort +---------------------------------------------------------------------------------------- + {"ábc sßs ßss DÉF",ⱥⱥⱥ,ⱥȺ,"abc DEF 123abc","DŽxxDŽ džxxDž Džxxdž",ȺȺȺ} (1 row) SELECT array_sort('{abc DEF 123abc,ábc sßs ßss DÉF,DŽxxDŽ džxxDž Džxxdž,ȺȺȺ,ⱥⱥⱥ,ⱥȺ}'::text[], 'desc'); - array_sort ------------------------------------------------------------------- - {"DŽxxDŽ džxxDž Džxxdž",ȺȺȺ,ⱥⱥⱥ,ⱥȺ,"ábc sßs ßss DÉF","abc DEF 123abc"} + array_sort +---------------------------------------------------------------------------------------- + {ȺȺȺ,"DŽxxDŽ džxxDž Džxxdž","abc DEF 123abc",ⱥȺ,ⱥⱥⱥ,"ábc sßs ßss DÉF"} (1 row) SELECT array_sort('{abc DEF 123abc,ábc sßs ßss DÉF,DŽxxDŽ džxxDž Džxxdž,ȺȺȺ,ⱥⱥⱥ,ⱥȺ}'::text[] COLLATE "pg_c_utf8", 'asc'); - array_sort ------------------------------------------------------------------- - {"abc DEF 123abc","ábc sßs ßss DÉF","DŽxxDŽ džxxDž Džxxdž",ȺȺȺ,ⱥȺ,ⱥⱥⱥ} -(1 row) - +ERROR: collation "pg_c_utf8" for encoding "WIN1252" does not exist +LINE 1: ...DŽ džxxDž Džxxdž,ȺȺȺ,ⱥⱥⱥ,ⱥȺ}'::text[] COLLATE "p... + ^ SELECT array_sort('{abc DEF 123abc,ábc sßs ßss DÉF,DŽxxDŽ džxxDž Džxxdž,ȺȺȺ,ⱥⱥⱥ,ⱥȺ}'::text[] COLLATE "pg_c_utf8", 'desc'); - array_sort ------------------------------------------------------------------- - {ⱥⱥⱥ,ⱥȺ,ȺȺȺ,"DŽxxDŽ džxxDž Džxxdž","ábc sßs ßss DÉF","abc DEF 123abc"} -(1 row) - +ERROR: collation "pg_c_utf8" for encoding "WIN1252" does not exist +LINE 1: ...DŽ džxxDž Džxxdž,ȺȺȺ,ⱥⱥⱥ,ⱥȺ}'::text[] COLLATE "p... + ^ -- nulls first/last tests SELECT array_sort('{abc DEF 123abc,ábc sßs ßss DÉF,null,DŽxxDŽ džxxDž Džxxdž,ȺȺȺ,ⱥⱥⱥ,ⱥȺ,null}'::text[]); - array_sort ----------------------------------------------------------------------------- - {"abc DEF 123abc","ábc sßs ßss DÉF",ⱥȺ,ⱥⱥⱥ,ȺȺȺ,"DŽxxDŽ džxxDž Džxxdž",NULL,NULL} + array_sort +-------------------------------------------------------------------------------------------------- + {"ábc sßs ßss DÉF",ⱥⱥⱥ,ⱥȺ,"abc DEF 123abc","DŽxxDŽ džxxDž Džxxdž",ȺȺȺ,NULL,NULL} (1 row) SELECT array_sort('{abc DEF 123abc,ábc sßs ßss DÉF,null,DŽxxDŽ džxxDž Džxxdž,ȺȺȺ,ⱥⱥⱥ,ⱥȺ,null}'::text[], 'asc'); - array_sort ----------------------------------------------------------------------------- - {"abc DEF 123abc","ábc sßs ßss DÉF",ⱥȺ,ⱥⱥⱥ,ȺȺȺ,"DŽxxDŽ džxxDž Džxxdž",NULL,NULL} + array_sort +-------------------------------------------------------------------------------------------------- + {"ábc sßs ßss DÉF",ⱥⱥⱥ,ⱥȺ,"abc DEF 123abc","DŽxxDŽ džxxDž Džxxdž",ȺȺȺ,NULL,NULL} (1 row) SELECT array_sort('{abc DEF 123abc,ábc sßs ßss DÉF,null,DŽxxDŽ džxxDž Džxxdž,ȺȺȺ,ⱥⱥⱥ,ⱥȺ,null}'::text[], 'desc'); - array_sort ----------------------------------------------------------------------------- - {NULL,NULL,"DŽxxDŽ džxxDž Džxxdž",ȺȺȺ,ⱥⱥⱥ,ⱥȺ,"ábc sßs ßss DÉF","abc DEF 123abc"} + array_sort +-------------------------------------------------------------------------------------------------- + {NULL,NULL,ȺȺȺ,"DŽxxDŽ džxxDž Džxxdž","abc DEF 123abc",ⱥȺ,ⱥⱥⱥ,"ábc sßs ßss DÉF"} (1 row) SELECT array_sort('{abc DEF 123abc,ábc sßs ßss DÉF,null,DŽxxDŽ džxxDž Džxxdž,ȺȺȺ,ⱥⱥⱥ,ⱥȺ,null}'::text[], 'nulls first'); - array_sort ----------------------------------------------------------------------------- - {NULL,NULL,"abc DEF 123abc","ábc sßs ßss DÉF",ⱥȺ,ⱥⱥⱥ,ȺȺȺ,"DŽxxDŽ džxxDž Džxxdž"} + array_sort +-------------------------------------------------------------------------------------------------- + {NULL,NULL,"ábc sßs ßss DÉF",ⱥⱥⱥ,ⱥȺ,"abc DEF 123abc","DŽxxDŽ džxxDž Džxxdž",ȺȺȺ} (1 row) SELECT array_sort('{abc DEF 123abc,ábc sßs ßss DÉF,null,DŽxxDŽ džxxDž Džxxdž,ȺȺȺ,ⱥⱥⱥ,ⱥȺ,null}'::text[], 'nulls first'); - array_sort ----------------------------------------------------------------------------- - {NULL,NULL,"abc DEF 123abc","ábc sßs ßss DÉF",ⱥȺ,ⱥⱥⱥ,ȺȺȺ,"DŽxxDŽ džxxDž Džxxdž"} + array_sort +-------------------------------------------------------------------------------------------------- + {NULL,NULL,"ábc sßs ßss DÉF",ⱥⱥⱥ,ⱥȺ,"abc DEF 123abc","DŽxxDŽ džxxDž Džxxdž",ȺȺȺ} (1 row) SELECT array_sort('{abc DEF 123abc,ábc sßs ßss DÉF,null,DŽxxDŽ džxxDž Džxxdž,ȺȺȺ,ⱥⱥⱥ,ⱥȺ,null}'::text[], 'asc nulls first'); - array_sort ----------------------------------------------------------------------------- - {NULL,NULL,"abc DEF 123abc","ábc sßs ßss DÉF",ⱥȺ,ⱥⱥⱥ,ȺȺȺ,"DŽxxDŽ džxxDž Džxxdž"} + array_sort +-------------------------------------------------------------------------------------------------- + {NULL,NULL,"ábc sßs ßss DÉF",ⱥⱥⱥ,ⱥȺ,"abc DEF 123abc","DŽxxDŽ džxxDž Džxxdž",ȺȺȺ} (1 row) SELECT array_sort('{abc DEF 123abc,ábc sßs ßss DÉF,null,DŽxxDŽ džxxDž Džxxdž,ȺȺȺ,ⱥⱥⱥ,ⱥȺ,null}'::text[], 'asc nulls last'); - array_sort ----------------------------------------------------------------------------- - {"abc DEF 123abc","ábc sßs ßss DÉF",ⱥȺ,ⱥⱥⱥ,ȺȺȺ,"DŽxxDŽ džxxDž Džxxdž",NULL,NULL} + array_sort +-------------------------------------------------------------------------------------------------- + {"ábc sßs ßss DÉF",ⱥⱥⱥ,ⱥȺ,"abc DEF 123abc","DŽxxDŽ džxxDž Džxxdž",ȺȺȺ,NULL,NULL} (1 row) SELECT array_sort('{abc DEF 123abc,ábc sßs ßss DÉF,null,DŽxxDŽ džxxDž Džxxdž,ȺȺȺ,ⱥⱥⱥ,ⱥȺ,null}'::text[], 'desc nulls first'); - array_sort ----------------------------------------------------------------------------- - {NULL,NULL,"DŽxxDŽ džxxDž Džxxdž",ȺȺȺ,ⱥⱥⱥ,ⱥȺ,"ábc sßs ßss DÉF","abc DEF 123abc"} + array_sort +-------------------------------------------------------------------------------------------------- + {NULL,NULL,ȺȺȺ,"DŽxxDŽ džxxDž Džxxdž","abc DEF 123abc",ⱥȺ,ⱥⱥⱥ,"ábc sßs ßss DÉF"} (1 row) SELECT array_sort('{abc DEF 123abc,ábc sßs ßss DÉF,null,DŽxxDŽ džxxDž Džxxdž,ȺȺȺ,ⱥⱥⱥ,ⱥȺ,null}'::text[], 'desc nulls last'); - array_sort ----------------------------------------------------------------------------- - {"DŽxxDŽ džxxDž Džxxdž",ȺȺȺ,ⱥⱥⱥ,ⱥȺ,"ábc sßs ßss DÉF","abc DEF 123abc",NULL,NULL} + array_sort +-------------------------------------------------------------------------------------------------- + {ȺȺȺ,"DŽxxDŽ džxxDž Džxxdž","abc DEF 123abc",ⱥȺ,ⱥⱥⱥ,"ábc sßs ßss DÉF",NULL,NULL} (1 row) -- multidimensional array tests