incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
Subject [Bug 121268] New: Nested Sum is Null
Date Wed, 24 Oct 2012 13:54:45 GMT

          Priority: P3
            Bug ID: 121268
           Summary: Nested Sum is Null
          Severity: normal
        Issue Type: DEFECT
    Classification: Application
                OS: All
          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

yields 0 on top level, but crashed the bigger query

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

View raw message