Unrecognized Node Type Warning - Mailing list pgsql-general

From Arora, Nick
Subject Unrecognized Node Type Warning
Date
Msg-id SN6PR03MB4542A7243DB304C5BC3214AAA57F9@SN6PR03MB4542.namprd03.prod.outlook.com
Whole thread Raw
Responses Re: Unrecognized Node Type Warning  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general

We are using PostgreSQL 12.13. We are noticing that queries that attempt to retrieve an element of an array by specifying its position cause a warning to be emitted: "WARNING:  unrecognized node type: 110".

 

Would appreciate your help diagnosing the issue and identifying steps to resolve.

 

Queries that reproduce the issue:

 

SELECT ('{0}'::int2[])[0];

WARNING:  unrecognized node type: 110

int2

------

 

(1 row)

 

 

SELECT ('0'::int2vector)[0];

WARNING:  unrecognized node type: 110

int2vector

------------

          0

(1 row)

 

SELECT (indkey::int2[])[0] FROM pg_index limit 1;

WARNING:  unrecognized node type: 110

indkey

--------

      1

(1 row)

 

SELECT scores[1], scores[2], scores[3], scores[4] FROM (select('{10,12,14,16}'::int[]) AS scores) AS round;

WARNING:  unrecognized node type: 110

WARNING:  unrecognized node type: 110

WARNING:  unrecognized node type: 110

WARNING:  unrecognized node type: 110

scores | scores | scores | scores

--------+--------+--------+--------

     10 |     12 |     14 |     16

(1 row)

 



This email and any attachments thereto may contain private, confidential, and privileged material for the sole use of the intended recipient. Any review, copying, or distribution of this email (or any attachments thereto) by others is strictly prohibited. If you are not the intended recipient, please contact the sender immediately and permanently delete the original and any copies of this email and any attachments thereto.

pgsql-general by date:

Previous
From: Tony Xu
Date:
Subject: Re: Would PostgreSQL 16 native transparent data encryption support database level encryption?
Next
From: Adrian Klaver
Date:
Subject: Re: JSONB operator unanticipated behaviour