Issue 119979 - Nested Query gives Wrong Result
Summary: Nested Query gives Wrong Result
Status: UNCONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 3.4.0
Hardware: PC All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-06-13 14:11 UTC by Jens611
Modified: 2013-01-29 21:47 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description Jens611 2012-06-13 14:11:29 UTC
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.
Comment 1 r4zoli 2012-09-09 06:35:59 UTC
This happens in AOO 3.4.1?

Please add example file to this bug to help bug confirmation.

Change component to none.