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 2012/06/13 16:11:29 UTC
[Bug 119979] New: Nested Query gives Wrong Result
https://issues.apache.org/ooo/show_bug.cgi?id=119979
Priority: P3
Bug ID: 119979
CC: ooo-issues@incubator.apache.org
Assignee: needsconfirm@dba.openoffice.org
Summary: Nested Query gives Wrong Result
Severity: normal
Issue Type: DEFECT
Classification: Application
OS: All
Reporter: jd@cococo.de
Hardware: PC
Status: UNCONFIRMED
Version: AOO340
Component: MySQL Connector/OOo
Product: database access
When creating a query with the query wizard for adding values of other queries
(nested queries) the generated query is sometimes wrong if the embedded query
consist of a summation query.
Q1
SELECT SUM( "Betrag" ) AS "Fortbildung" FROM "Belege" WHERE "Art" LIKE
'%bildung%'
Q2
SELECT SUM( "Betrag" ) AS "Beratung" FROM "Belege" WHERE "Art" LIKE '%berat%'
The wizard generats
SELECT "Q1"."Fortbildung", "Q2"."Beratung" AS "Beratung" FROM "...", "..."
where "..." are the base tables!
The result is empty.
--
You are receiving this mail because:
You are on the CC list for the bug.
[Bug 119979] Nested Query gives Wrong Result
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119979
r4zoli <r4...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |r4zoli@apache.org
Component|MySQL Connector/OOo |none
--- Comment #1 from r4zoli <r4...@apache.org> ---
This happens in AOO 3.4.1?
Please add example file to this bug to help bug confirmation.
Change component to none.
--
You are receiving this mail because:
You are on the CC list for the bug.