Hi
út 12. 11. 2019 v 22:51 odesílatel Nikita Glukhov <n.glu...@postgrespro.ru>
napsal:
> On 12.11.2019 20:54, Pavel Stehule wrote:
>
> > Hi
> >
> > please, can you rebase 0001-SQL-JSON-functions-v40.patch. I have a
> > problem with patching
> >
> > Pavel
>
> Attached 41th version of the patches rebased onto current master.
>
I can say so broken regress tests has related to locales
with czech locale LANG=cs_CZ.UTF8 following two tests fails
json_sqljson ... FAILED 148 ms
jsonb_sqljson ... FAILED 3791 ms
The problem is in comparison digits and chars. the result is locale depend.
postgres=# select '10' > 'a' collate "C";
┌──────────┐
│ ?column? │
╞══════════╡
│ f │
└──────────┘
(1 row)
postgres=# select '10' > 'a' collate "cs_CZ";
┌──────────┐
│ ?column? │
╞══════════╡
│ t │
└──────────┘
(1 row)
postgres=# select '10' > 'a' collate "en_US";
┌──────────┐
│ ?column? │
╞══════════╡
│ f │
└──────────┘
(1 row)
Regards
Pavel
>
> --
> Nikita Glukhov
> Postgres Professional: http://www.postgrespro.com
> The Russian Postgres Company
>
