SQL/JSON: FOR ORDINALITY bug

Поиск
Список
Период
Сортировка
От Erik Rijkers
Тема SQL/JSON: FOR ORDINALITY bug
Дата
Msg-id a456b06f-2f05-209d-f5e6-fd6afc8486a6@xs4all.nl
обсуждение исходный текст
Ответы Re: SQL/JSON: FOR ORDINALITY bug  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
Hi

I've copied some statements from the .pdf called:
"TECHNICAL REPORT ISO/IEC TR 19075-6   First edition 2017-03
Part SQL Notation support 6: (JSON) for JavaScript Object"
(not available anymore although there should be a similar replacement file)

In that pdf I found the data and statement (called 'table 15' in the 
.pdf) as in the attached bash file.  But the result is different: as 
implemented by 15devel, the column rowseq is always 1.  It seems to me 
that that is wrong; it should count 1, 2, 3 as indeed the example-result 
column in that pdf shows.

What do you think?

Erik Rijkers
Вложения

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Configuration Parameter/GUC value validation hook
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Configuration Parameter/GUC value validation hook