BUG in 6.5 - GROUP BY inheritance

From: chris(at)tech(dot)com(dot)au
To: pgsql-hackers(at)hub(dot)org
Cc: chris(at)tech(dot)com(dot)au
Subject: BUG in 6.5 - GROUP BY inheritance
Date: 1999-06-09 14:43:22
Message-ID: 199906091443.AAA26884@tech.com.au
Views: Whole Thread | Raw Message | 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 Tom Lane 1999-06-09 14:48:22 Re: [HACKERS] Re: [PORTS] Anyone working on linux Alpha?
Previous Message Tom Lane 1999-06-09 14:41:02 Re: [HACKERS] Postgres 6.5 beta2 and beta3 problem