Issue 28181

Summary:	Group by statement
Product:	Base	Reporter:	effevi <fvioli>
Component:	code	Assignee:	marc.neumann
Status:	CLOSED DUPLICATE	QA Contact:	issues@dba <issues>
Severity:	Trivial
Priority:	P3	CC:	issues
Version:	OOo 1.1.1
Target Milestone:	---
Hardware:	PC
OS:	Linux, all
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

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