BUG in 6.5 - GROUP BY inheritance

From: Chris Bitmead <chris(dot)bitmead(at)bigfoot(dot)com>
To: pgsql-hackers(at)hub(dot)org
Subject: BUG in 6.5 - GROUP BY inheritance
Date: 1999-06-10 03:48:01
Message-ID: 375F3571.B459169B@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


The following query produces the following error

BUT...

if I take out the "*" from category* it starts to work. Unfortunately I
need the "*" for my purposes. Bug?

This is from CVS of about a week ago.

SELECT question.title, count(comment.oid) FROM question,
category*,comment WHERE comment.webobject = question.oid and
question.category = category.oid GROUP BY question.title;
ERROR: replace_vars_with_subplan_refs: variable not in target list

--
Chris Bitmead
http://www.bigfoot.com/~chris.bitmead
mailto:chris(dot)bitmead(at)bigfoot(dot)com

Browse pgsql-hackers by date

  From Date Subject
Next Message Kaare Rasmussen 1999-06-10 04:50:30 Re: [HACKERS] Priorities for 6.6
Previous Message Vadim Mikheev 1999-06-10 03:33:32 Re: [HACKERS] select order by for update