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.