SQL/JSON: FOR ORDINALITY bug

From: Erik Rijkers <er(at)xs4all(dot)nl>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: SQL/JSON: FOR ORDINALITY bug
Date: 2022-05-03 15:19:01
Message-ID: a456b06f-2f05-209d-f5e6-fd6afc8486a6@xs4all.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
table15bug.sh application/x-shellscript 2.1 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2022-05-03 15:45:41 Re: Configuration Parameter/GUC value validation hook
Previous Message Robert Haas 2022-05-03 14:52:57 Re: Configuration Parameter/GUC value validation hook