https://issues.apache.org/ooo/show_bug.cgi?id=119979
Priority: P3
Bug ID: 119979
CC: [email protected]
Assignee: [email protected]
Summary: Nested Query gives Wrong Result
Severity: normal
Issue Type: DEFECT
Classification: Application
OS: All
Reporter: [email protected]
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.
