https://issues.apache.org/ooo/show_bug.cgi?id=121268
gg43 <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED CC| |[email protected] Latest|--- |AOO 3.4.1 Confirmation on| | Resolution|--- |IRREPRODUCIBLE QA Contact| |[email protected] --- Comment #1 from gg43 <[email protected]> --- Platform: Operating System: Windows 7 Home Premium Version 6.1.7601 Service Pack 1 Build 7601 (x64) Apache Open Office 3.4.1 AOO341m1 Build 9593 Rev 1372282 My test: Created a table (Table1) with 3 fields (month, item,. Import) Populated the table with the following values: 1, BOX 100 1, SQUARE, 120 2, BOX, 100 Created query (Query1): SELECT SUM (import) AS Import1 FROM Table1 WHERE month =? Created query (Query2) SELECT SUM (import) AS Import2 FROM Table1 WHERE item = ? Created query (Query3) SELECT Query1.Import1, Query2.Import2 FROM Query1, Query2 Executed Query3 providing as parameters month = 3 and item = BOX and the result was Import1 Import2 200 Query3 performed by providing as parameters month = 1 and item = CIRCLE and the result was Import1 Import2 220 Everything OK So I think the bug has been fixed or irreproducible If you are still seeing this problem after upgrading to AOO 3.4.1 please post the details and we can reopen the report -- You are receiving this mail because: You are the assignee for the bug.
