BUG #16548: Order by on array element giving disparity in result
От | PG Bug reporting form |
---|---|
Тема | BUG #16548: Order by on array element giving disparity in result |
Дата | |
Msg-id | 16548-d48610c6070e8ca7@postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #16548: Order by on array element giving disparity in result
Re: BUG #16548: Order by on array element giving disparity in result |
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 16548 Logged by: Manvendra Panwar Email address: manvendra2525@gmail.com PostgreSQL version: 12.2 Operating system: Ubuntu 18.04.1 LTS Description: create table bint (a int[]); insert into bint values (array[14]); insert into bint values (array[14]); insert into bint values (array[10]); insert into bint values (array[10,14,14,14]); insert into bint values (array[10,14,10,10]); insert into bint values (array[14,14,10,14]); insert into bint values (array[10,14,14,14]); insert into bint values (array[10,14]); insert into bint values (array[10,14]); insert into bint values (array[14,14,14,14]); insert into bint values (array[10,14,10,10]); insert into bint values (array[10,14]); insert into bint values (array[10,14]); insert into bint values (array[10,14]); insert into bint values (array[10,14]); insert into bint values (array[10,14]); insert into bint values (array[14,14,14,10]); insert into bint values (array[14,14,14,10]); insert into bint values (array[14,14,14,14]); insert into bint values (array[10,14]); insert into bint values (array[10,14]); insert into bint values (array[10,14,14,14]); insert into bint values (array[10,14]); commit; postgres=# select * from bint order by a[2] desc; a --------------- {14} {14} {10} {10,14,14,14} {10,14,10,10} {14,14,10,14} {10,14,14,14} {10,14} {10,14} {14,14,14,14} {10,14,10,10} {10,14} {10,14} {10,14} {10,14} {10,14} {14,14,14,10} {14,14,14,10} {14,14,14,14} {10,14} {10,14} {10,14,14,14} {10,14} (23 rows) postgres=# select * from bint order by a[2] desc limit 5; a --------------- {14} {10} {14} {10,14,10,10} {10,14,14,14} (5 rows)
В списке pgsql-bugs по дате отправления: