BUG #17440: not expected result from jsonb_path_query
От | PG Bug reporting form |
---|---|
Тема | BUG #17440: not expected result from jsonb_path_query |
Дата | |
Msg-id | 17440-b8f554829089cf0f@postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #17440: not expected result from jsonb_path_query
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 17440 Logged by: Edouard HIBON Email address: edouard.hibon@free.fr PostgreSQL version: 14.0 Operating system: windows 10 Description: Query 1 : SELECT jsonb_path_query('[1,2,3]' :: jsonb, '$') results in 1 value '[1,2,3]' :: jsonb as expected Query 2 : SELECT jsonb_path_query('[1,2,3]' :: jsonb, '$[*]') results in a set of 3 values '1', '2', '3' as expected Query 3 : SELECT jsonb_path_query('[1,2,3]' :: jsonb, '$[*] ? (@ <> null)') results in a set of 3 values '1', '2', '3' as expected Query 4 : SELECT jsonb_path_query('[1,2,3]' :: jsonb, '$ ? (@ <> null)') results in a set of 3 values '1', '2', '3' as for the queries 2 & 3 whereas I would expect only one value '[1,2,3]' as for the query 1 because there is no member accessor nor array element accessor in this jsonpath, and @ should represent the initial jsonb value being queried $ demo : https://dbfiddle.uk/?rdbms=postgres_14&fiddle=f09164502df5ee1bb620057689e6f810
В списке pgsql-bugs по дате отправления: