Apache OpenOffice (AOO) Bugzilla – Issue 119979
Nested Query gives Wrong Result
Last modified: 2013-01-29 21:47:25 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.
This happens in AOO 3.4.1? Please add example file to this bug to help bug confirmation. Change component to none.