BUG in 6.5 - GROUP BY inheritance

Started by Nonameover 26 years ago1 messages
#1Noname
chris@tech.com.au

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.bitmead@bigfoot.com