[sqlsmith] Crash in apply_projection_to_path - Mailing list pgsql-hackers

From Andreas Seltenreich
Subject [sqlsmith] Crash in apply_projection_to_path
Date
Msg-id 871t5pgwdt.fsf@credativ.de
Whole thread Raw
Responses Re: [sqlsmith] Crash in apply_projection_to_path  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hi,

the following query against the regression database crashes master as of
23b09e15.

select 1 from depth0 inner join depth1 on (depth0.c = depth1.c)        where depth0.c @@ depth1.c limit 1;

regards,
Andreas

Program terminated with signal SIGSEGV, Segmentation fault.
#0  create_projection_path (root=root@entry=0x6918e60,   rel=0x7f7f7f7f7f7f7f7f, subpath=0x69d6de8,
target=target@entry=0x69d7428)  at pathnode.c:2160
 
2160        pathnode->path.parallel_safe = rel->consider_parallel &&
#0  create_projection_path (root=root@entry=0x6918e60, rel=0x7f7f7f7f7f7f7f7f, subpath=0x69d6de8,
target=target@entry=0x69d7428)at pathnode.c:2160
 
#1  0x000000000067841e in apply_projection_to_path (root=0x6918e60, rel=0x69d5e18, path=0x69d6ee0, target=0x69d7428) at
pathnode.c:2251
#2  0x000000000065ff20 in grouping_planner (root=0x22e1850, root@entry=0x6918e60, inheritance_update=56 '8',
inheritance_update@entry=0'\000', tuple_fraction=2615.2579411764709, tuple_fraction@entry=0) at planner.c:1737
 
#3  0x0000000000661f44 in subquery_planner (glob=glob@entry=0x6918dc8, parse=parse@entry=0x235e3b0,
parent_root=parent_root@entry=0x0,hasRecursion=hasRecursion@entry=0 '\000', tuple_fraction=tuple_fraction@entry=0) at
planner.c:758
#4  0x0000000000662e2b in standard_planner (parse=0x235e3b0, cursorOptions=256, boundParams=0x0) at planner.c:307
#5  0x00000000006f40ed in pg_plan_query (querytree=0x235e3b0, cursorOptions=256, boundParams=0x0) at postgres.c:798
#6  0x00000000006f41e4 in pg_plan_queries (querytrees=<optimized out>, cursorOptions=256, boundParams=0x0) at
postgres.c:857
#7  0x00000000006f5c93 in exec_simple_query (query_string=<optimized out>) at postgres.c:1022



pgsql-hackers by date:

Previous
From: Sehrope Sarkuni
Date:
Subject: Re: Add jsonb_compact(...) for whitespace-free jsonb to text
Next
From: Bruce Momjian
Date:
Subject: Re: pg_xlog -> pg_xjournal?