SQL/JSON: FOR ORDINALITY bug - Mailing list pgsql-hackers

From Erik Rijkers
Subject SQL/JSON: FOR ORDINALITY bug
Date
Msg-id a456b06f-2f05-209d-f5e6-fd6afc8486a6@xs4all.nl
Whole thread Raw
Responses Re: SQL/JSON: FOR ORDINALITY bug
List 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
Attachment

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Configuration Parameter/GUC value validation hook
Next
From: Tom Lane
Date:
Subject: Re: Configuration Parameter/GUC value validation hook