Issue 28181 - Group by statement
Summary: Group by statement
Status: CLOSED DUPLICATE of issue 27286
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1.1
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-04-21 11:27 UTC by effevi
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description effevi 2004-04-21 11:27:02 UTC 
On query builder we were not able to obtain any type of group by clause. We try on Italian 
version and English version too, with both odbc:postgres and sdbc:postgres. This feature 
was functioning on 1.0.x and also 1.1.0. To replay to problem try 
 
select a, sum(b) from c group by a
Comment 1 effevi 2004-04-21 11:39:24 UTC 
This is the real sql sent to postgres. I obtained this one using the sdbc:postgres driver  
  
pq_driver: [PGRES_FATAL_ERROR]ERROR:  Attribute uservizi.sez must be GROUPed  
or used in an aggregate function  
 (caused by statement 'SELECT "sez", SUM( "dip" ) FROM  "public"."uservizi" "uservizi"  
WHERE  0 = 1')
Comment 2 Frank Schönheit 2004-04-21 16:35:38 UTC 
This is a duplicate of issue 27286.

*** This issue has been marked as a duplicate of 27286 ***
Comment 3 Frank Schönheit 2004-04-21 16:36:13 UTC 
As such, it should be fixed in 1.1.2