incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 121268] New: Nested Sum is Null
Date Wed, 24 Oct 2012 13:54:45 GMT
https://issues.apache.org/ooo/show_bug.cgi?id=121268

          Priority: P3
            Bug ID: 121268
          Assignee: ooo-issues@incubator.apache.org
           Summary: Nested Sum is Null
          Severity: normal
        Issue Type: DEFECT
    Classification: Application
                OS: All
          Reporter: jd@cococo.de
          Hardware: All
            Status: UNCONFIRMED
           Version: AOO 3.4.1
         Component: code
           Product: database access

When summing up across a table where no entry is found normally a 0 is
returned. But if you take this intermediate result into a bigger query it
crashes the bigger query by yielding NULL for that one!

Bigger Query
------------
SELECT "4900 sonstige betriebliche Aufwendungen"."Aufwendungen", "4945
Fortbildungskosten"."Fortbildung" FROM "4900 sonstige betriebliche
Aufwendungen", "4945 Fortbildungskosten"

=> yields null, because of Nested Query!!

Nested Query
-------------
SELECT SUM( "Betrag" ) AS "Fortbildung" FROM "Belege" WHERE "Art" LIKE
'%bildung%'

yields 0 on top level, but crashed the bigger query

-- 
You are receiving this mail because:
You are the assignee for the bug.

Mime
View raw message