BUG #18840: Segmentation fault in executing select unnest(array(oidvector))
The Post Office <noreply@postgresql.org>
From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: ylshiyu@126.com
Date: 2025-03-12T12:30:03Z
Lists: pgsql-bugs
The following bug has been logged on the website:
Bug reference: 18840
Logged by: yang lei
Email address: ylshiyu@126.com
PostgreSQL version: 16.8
Operating system: Ubuntu 22.04
Description:
Hi,
I encountered a segmentation fault when using 'select
unnest(array(oidvector))'.
bug demo:
CREATE TABLE my_table (
id SERIAL PRIMARY KEY,
oidvector_col oidvector
);
INSERT INTO my_table (oidvector_col) VALUES ('12345 67890 54321');
SELECT unnest(ARRAY(SELECT oidvector_col)) from my_table;
server closed the connection unexpectedly
This
probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: 2025-03-12
20:18:04.642 CST [1478] LOG: server process (PID 1578) was terminated by
signal 11: Segmentation fault
Commits
-
Fix ARRAY_SUBLINK and ARRAY[] for int2vector and oidvector input.
- f7ae51312f3d 14.18 landed
- c826cd1b1d42 17.5 landed
- 474aee3dfe88 13.21 landed
- 4618045bee4a 18.0 landed
- 13dd6f77265b 15.13 landed
- 0405982c7cba 16.9 landed