incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 118609] New: using aggregate function and/or "GROUP BY" in SQL-Select returns wrong data: first row in result table is missing
Date Wed, 16 Nov 2011 16:55:13 GMT
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: dbaneedsconfirm@openoffice.org
        ReportedBy: Oliver.Mager@gmx.net
                CC: ooo-issues@incubator.apache.org


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.

Mime
View raw message