============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Jin Beom, Son
Your email address : cunix@hitel.net
Category : runtime: front-end
Severity : critical
Summary: Syntax Error from ( group by ) select
System Configuration
--------------------
Operating System : Solaris2.6 ( sparc )
PostgreSQL version : 6.5
Compiler used : gcc-2.8.1
Hardware:
---------
Sparc4 / 96MB /
Versions of other tools:
------------------------
gmake 3.75
flex 2.5.41.25
bison
--------------------------------------------------------------------------
Problem Description:
--------------------
select a.* from web_menu a, group_table b, user_group c, web_group_menu d where
c.id = 'js777' and c.group_id = b.group_id and d.group_id = b.group_id and d.me
= a.me group by a.me, a.up, a.menu_name, a.hyper_link_tag, a.memo order by up, m
e;
--------------------------------------------------------------------------
Test Case:
----------
QUERY: select a.* from web_menu a, group_table b, user_group c, web_group_menu d
where c.id = 'js777' and c.group_id = b.group_id and d.group_id = b.group_id an
d d.me = a.me group by a.me, a.up, a.menu_name, a.hyper_link_tag, a.memo order b
y up, me;
ERROR: Illegal use of aggregates or non-group column in target list
--------------------------------------------------------------------------
Solution:
---------
--------------------------------------------------------------------------
