Re: SQL/JSON: JSON_TABLE
| От | Pavel Stehule |
|---|---|
| Тема | Re: SQL/JSON: JSON_TABLE |
| Дата | |
| Msg-id | CAFj8pRDjatEGJeq_Lz12qms9QH4HzHkj8RhGbn6VUXMm_amUHw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: SQL/JSON: JSON_TABLE (Nikita Glukhov <n.gluhov@postgrespro.ru>) |
| Список | pgsql-hackers |
Hi
út 12. 11. 2019 v 22:51 odesílatel Nikita Glukhov <n.gluhov@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
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)
┌──────────┐
│ ?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)
┌──────────┐
│ ?column? │
╞══════════╡
│ f │
└──────────┘
(1 row)
Regards
Pavel
--
Nikita Glukhov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
В списке pgsql-hackers по дате отправления: