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

Re: BUG #2112: query kills db thread

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jim Dew" <jdew(at)yggdrasil(dot)ca>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2112: query kills db thread
Date: 2005-12-14 16:32:08
Message-ID: 21066.1134577928@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Jim Dew" <jdew(at)yggdrasil(dot)ca> writes:
> Stumbled upon a (broken) query that causes the 8.1.0 thread handling the
> query to die:
> select foo from (select null) as foo

Fixed in 8.0 and up.  If you need the patch for 8.1, it's pretty simple:

Index: src/backend/executor/execQual.c
===================================================================
RCS file: /cvsroot/pgsql/src/backend/executor/execQual.c,v
retrieving revision 1.183.2.1
diff -c -r1.183.2.1 execQual.c
*** src/backend/executor/execQual.c	22 Nov 2005 18:23:08 -0000	1.183.2.1
--- src/backend/executor/execQual.c	14 Dec 2005 16:25:05 -0000
***************
*** 541,547 ****
  	Assert(variable->varno != OUTER);
  	slot = econtext->ecxt_scantuple;
  
! 	tuple = slot->tts_tuple;
  	tupleDesc = slot->tts_tupleDescriptor;
  
  	/*
--- 541,547 ----
  	Assert(variable->varno != OUTER);
  	slot = econtext->ecxt_scantuple;
  
! 	tuple = ExecFetchSlotTuple(slot);
  	tupleDesc = slot->tts_tupleDescriptor;
  
  	/*

Thanks for the report!

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Ben GouldDate: 2005-12-14 16:45:22
Subject: BUG #2114: (patch) COPY FROM ... end of copy marker corrupt
Previous:From: Wojciech SobczukDate: 2005-12-14 16:17:10
Subject: BUG #2113: PostgreSQL hangs after running for 2 days

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