Horton
Menu

RE: ECPG: inconsistent behavior with the document in “GET/SET DESCRIPTOR.”

Masashi Kamura (Fujitsu) <kamura.masashi@fujitsu.com>

View thread
From: "Masashi Kamura (Fujitsu)" <kamura.masashi@fujitsu.com>
To: 'lakshmi' <lakshmigcdac@gmail.com>, "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2026-04-24T03:08:36Z
Lists: pgsql-hackers 
Hi,

Syntax rules in the SQL standard do not appear to include any restrictions on specifying COUNT multiple times.
However, since the behavior when COUNT is specified multiple times in SET DESCRIPTOR is not also defined, I consider this to be undefined behavior.

In Oracle's Pro*C, COUNT can be specified only once.

Specifying it multiple times results in a syntax error.

This issue has been occurring from PG14 to PG18, but no one has pointed it out until now.

For the reasons above, I would like to proceed with the policy of treating this as a syntax error.

Regards,
Masashi Kamura
Fujitsu Limited

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. ecpg: Reject multiple header items in GET/SET DESCRIPTOR