incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 119979] New: Nested Query gives Wrong Result
Date Wed, 13 Jun 2012 14:11:29 GMT
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.

Mime
View raw message