BUG #16801: Invalid memory access on WITH RECURSIVE with nested WITHs
От | PG Bug reporting form |
---|---|
Тема | BUG #16801: Invalid memory access on WITH RECURSIVE with nested WITHs |
Дата | |
Msg-id | 16801-393c7922143eaa4d@postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #16801: Invalid memory access on WITH RECURSIVE with nested WITHs
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 16801 Logged by: Alexander Lakhin Email address: exclusion@gmail.com PostgreSQL version: 13.1 Operating system: Ubuntu 20.04 Description: When executing the following query: WITH RECURSIVE rec(x) AS ( WITH outermost(x) AS ( SELECT ( WITH innermost as (SELECT 1) SELECT * FROM innermost ) ) SELECT * FROM outermost ) SELECT * FROM rec; valgrind detects an invalid read: ==00:00:00:04.145 217144== Invalid read of size 8 ==00:00:00:04.145 217144== at 0x302CB7: makeDependencyGraphWalker (parse_cte.c:549) ==00:00:00:04.145 217144== by 0x302EA1: makeDependencyGraph (parse_cte.c:439) ==00:00:00:04.145 217144== by 0x304557: transformWithClause (parse_cte.c:176) ==00:00:00:04.145 217144== by 0x2DD70A: transformSelectStmt (analyze.c:1202) ==00:00:00:04.145 217144== by 0x2DDAB4: transformStmt (analyze.c:301) ==00:00:00:04.145 217144== by 0x2DEDDA: transformOptionalSelectInto (analyze.c:246) ==00:00:00:04.145 217144== by 0x2DEE0F: transformTopLevelStmt (analyze.c:196) ==00:00:00:04.145 217144== by 0x2DEE71: parse_analyze (analyze.c:116) ==00:00:00:04.145 217144== by 0x55E69F: pg_analyze_and_rewrite (postgres.c:691) ==00:00:00:04.145 217144== by 0x55ED66: exec_simple_query (postgres.c:1155) ==00:00:00:04.145 217144== by 0x560D83: PostgresMain (postgres.c:4315) ==00:00:00:04.145 217144== by 0x4CC6B8: BackendRun (postmaster.c:4526) ==00:00:00:04.145 217144== Address 0x50890a8 is 24 bytes inside a block of size 32 client-defined ==00:00:00:04.145 217144== at 0x6B4831: palloc (mcxt.c:974) ==00:00:00:04.145 217144== by 0x42B624: new_list (list.c:134) ==00:00:00:04.145 217144== by 0x42BF1B: lcons (list.c:458) ==00:00:00:04.145 217144== by 0x302C73: makeDependencyGraphWalker (parse_cte.c:542) ==00:00:00:04.145 217144== by 0x302EA1: makeDependencyGraph (parse_cte.c:439) ==00:00:00:04.145 217144== by 0x304557: transformWithClause (parse_cte.c:176) ==00:00:00:04.145 217144== by 0x2DD70A: transformSelectStmt (analyze.c:1202) ==00:00:00:04.145 217144== by 0x2DDAB4: transformStmt (analyze.c:301) ==00:00:00:04.145 217144== by 0x2DEDDA: transformOptionalSelectInto (analyze.c:246) ==00:00:00:04.145 217144== by 0x2DEE0F: transformTopLevelStmt (analyze.c:196) ==00:00:00:04.145 217144== by 0x2DEE71: parse_analyze (analyze.c:116) ==00:00:00:04.145 217144== by 0x55E69F: pg_analyze_and_rewrite (postgres.c:691) ==00:00:00:04.145 217144== The first bad commit is 1cff1b95.
В списке pgsql-bugs по дате отправления: