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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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 Content-Type Size
crash2.sql text/x-sql 148 bytes

Responses

Browse pgsql-bugs by date

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