Skip site navigation (1) Skip section navigation (2)

inheritance_planner() bug in 9.1

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: inheritance_planner() bug in 9.1
Date: 2011-01-12 22:52:06
Message-ID: 1294872726.30091.37.camel@jdavis-ux.asterdata.local (view raw or flat)
Thread:
Lists: pgsql-bugs
The attached SQL causes a crash in 9.1. It appears to be caused by:

    d1001a78ce612a16ea622b558f5fc2b68c45ab4c

The patch tries to copy all of the important data out of the child
context before it's reset; but it doesn't get everything. For instance,
grouping_planner() allocates subroot.glob->paramlist, and uses it in
subsequent iterations; but that isn't copied before the context is
reset. It looks like there are other things that need copying as well,
but it wasn't immediately clear to me what the best fix is.

Regards,
	Jeff Davis

Attachment: crash2.sql
Description: text/x-sql (148 bytes)

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2011-01-13 01:26:19
Subject: Re: inheritance_planner() bug in 9.1
Previous:From: chebeleuDate: 2011-01-12 21:56:44
Subject: BUG #5833: error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group