BUG #14080: JSONB order changes when using json_pretty()

Поиск
Список
Период
Сортировка
От jack@fastly.com
Тема BUG #14080: JSONB order changes when using json_pretty()
Дата
Msg-id 20160408224345.15199.8059@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #14080: JSONB order changes when using json_pretty()  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14080
Logged by:          Jack
Email address:      jack@fastly.com
PostgreSQL version: 9.5.2
Operating system:   Mac OSX
Description:

while looking though datasets I noticed json_pretty is retuning a different
record.

This query will return an id that I expect and other defendant queries seem
to work
```
select jsonb_array_elements(details->'version'->'domains'), id from services
order by id limit 1 offset 400;
```

This query returns a random record both the id and the json are valid they
are just the wrong one.

```
select jsonb_pretty(details->'version'->'domains'), id from services order
by id limit 1 offset 400;
```

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Miklós Fazekas
Дата:
Сообщение: Re: released savepoint blocking further statements
Следующее
От: Hector Bejarano
Дата:
Сообщение: Re: BUG #14079: Issues with query