You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2011/11/16 17:55:13 UTC
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
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.
DO NOT REPLY [Bug 118609] using aggregate function and/or "GROUP BY"
in SQL-Select returns wrong data: first row in result table is missing
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118609
--- Comment #2 from Oliver <Ol...@gmx.net> 2011-11-16 21:12:57 UTC ---
We use ADO
--
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.
DO NOT REPLY [Bug 118609] using aggregate function and/or "GROUP BY"
in SQL-Select returns wrong data: first row in result table is missing
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118609
r4zoli <zr...@hdsnet.hu> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution| |WORKSFORME
--- Comment #3 from r4zoli <zr...@hdsnet.hu> 2011-11-17 15:03:21 UTC ---
I created your test data in MSSQL2008, when I connected with ADO from OOo 3.3,
I can confirm the behavior of queries, first rows is missing.
When used same file with OOo 3.4Beta, the queries runs correctly.
during OOo 3.4 development the bug was fixed.
No official, finished version of OOo 3.4. You can use beta until 3.4 is
finished in next year.
I will set this bug as worksforme.
--
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.
DO NOT REPLY [Bug 118609] using aggregate function and/or "GROUP BY"
in SQL-Select returns wrong data: first row in result table is missing
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118609
r4zoli <zr...@hdsnet.hu> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |CLOSED
--- Comment #4 from r4zoli <zr...@hdsnet.hu> 2011-11-17 15:03:55 UTC ---
Worksforme -> closing.
--
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.
DO NOT REPLY [Bug 118609] using aggregate function and/or "GROUP BY"
in SQL-Select returns wrong data: first row in result table is missing
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118609
r4zoli <zr...@hdsnet.hu> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |zreizinger@hdsnet.hu
--- Comment #1 from r4zoli <zr...@hdsnet.hu> 2011-11-16 19:14:33 UTC ---
Which connection you use? ODBC or ADO or JDBC?
Please try with OOo 3.4beta, some similar bugs solved in.
--
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.