Thread: Port Bug Report: Syntax Error from ( group by ) select

Port Bug Report: Syntax Error from ( group by ) select

From
Unprivileged user
Date:
============================================================================
                        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:
---------


--------------------------------------------------------------------------