BUG #17706: ALTER TYPE leads to crash
От | PG Bug reporting form |
---|---|
Тема | BUG #17706: ALTER TYPE leads to crash |
Дата | |
Msg-id | 17706-fa10a46c1ac9ce5a@postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #17706: ALTER TYPE leads to crash
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 17706 Logged by: Sergey Shinderuk Email address: s.shinderuk@postgrespro.ru PostgreSQL version: 15.1 Operating system: Ubuntu 22.04 Description: With PL/pgSQL: create type foo as (a int, b int); create function bar() returns record as $$ declare r foo := row(123, 2^30); begin alter type foo alter attribute b type text; return r; end; $$ language plpgsql; postgres=# select bar(); server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. LOG: server process (PID 394076) was terminated by signal 11: Segmentation fault (Here 2^30 is interpreted as a string length.) With a cursor: postgres=# create type foo as (a int, b int); CREATE TYPE postgres=# begin; BEGIN postgres=*# declare c cursor for select (i, 2^30)::foo from generate_series(1,10) i; DECLARE CURSOR postgres=*# fetch c; row ---------------- (1,1073741824) (1 row) postgres=*# fetch c; row ---------------- (2,1073741824) (1 row) postgres=*# alter type foo alter attribute b type text; ALTER TYPE postgres=*# fetch c; server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.
В списке pgsql-bugs по дате отправления: