https://issues.apache.org/ooo/show_bug.cgi?id=121268
Priority: P3
Bug ID: 121268
Assignee: [email protected]
Summary: Nested Sum is Null
Severity: normal
Issue Type: DEFECT
Classification: Application
OS: All
Reporter: [email protected]
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.
