https://issues.apache.org/ooo/show_bug.cgi?id=118609
Bug #: 118609
Issue Type: DEFECT
Summary: using aggregate function and/or "GROUP BY" in
SQL-Select returns wrong data: first row in result
table is missing
Classification: Application
Product: Database access
Version: OOo 3.3
Platform: PC
OS/Version: Windows XP
Status: UNCONFIRMED
Severity: trivial
Priority: P5
Component: none
AssignedTo: [email protected]
ReportedBy: [email protected]
CC: [email protected]
Test-Data in Table OOo_Dummy:
-----------------------------
Name Price lfd_no
A 1 10
B 2 20
C 3 30
A 4 40
B 5 50
C 6 60
SQL: Select Name FROM OOo_Dummy GROUP BY Name
=>
Name
B
C
(first row "A" is missing in result set)
SQL: Select SUM(Price) as Umsatz FROM OOo_Dummy
=>
Umsatz
(first row "21" is missing in result set)
last check:
SQL: Select Name, SUM(Price) as Umsatz FROM OOo_Dummy GROUP BY Name ORDER BY
Umsatz DESC
=>
Name Umsatz
B 7
A 5
(first row "C 9" is missing in result set)
SQL: Select Name, SUM(Price) as Umsatz FROM OOo_Dummy GROUP BY Name ORDER BY
Umsatz ASC
=>
Name Umsatz
B 7
C 9
(first row "A 5" is missing in result set)
So it is always the first row in our result set!
OO-Base: OOO330m20 (Build:9567)
Database: MS-SQL-Server 2000
Any ideas?
Oliver
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
