incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
Subject [Bug 119979] New: Nested Query gives Wrong Result
Date Wed, 13 Jun 2012 14:11:29 GMT

          Priority: P3
            Bug ID: 119979
           Summary: Nested Query gives Wrong Result
          Severity: normal
        Issue Type: DEFECT
    Classification: Application
                OS: All
          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. 

SELECT SUM( "Betrag" ) AS "Fortbildung" FROM "Belege" WHERE "Art" LIKE

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.

View raw message