|Subject||AW: AW: [firebird-support] coalesce bug in fb 3.0 rc2?|
your are right. But in FB 3, it will be handled different.
I need the left join tlager_sum, because I’d like to have all records too there no records in tlager_sum. But in this case I get now in fb 3 the tteile.teilenr clean without the amaount of tlager_sum (the a.minb is greater than the coalesce(b.menge,0) and in this case, I get no referenced Record from tlager_sum), the one from tteile now in every case (left join).
Finally, I would get all records with a.minb > b.menge and all records, where a.minb is present an there is no record from the teilenr in tlager_sum.
> sorry, outlook corrects me in German. At the moment, I have no sulutionQuery:
> for the problem. Anything ideas?
a.teilenr, a.bezeichnung, a.minb, coalesce(b.menge,0) as m, a.typ
left join tlager_sum b on (a.teilenr = b.teilenr)
((a.minb > coalesce(b.menge,0)) and (a.typ = 1))
TEILENR BEZEICHNUNG MINB M TYP
PrSt110x44x3 Profilrohr E235,S2 110x44x3,0 mm gebeizt 5600mm 280
I would say your TLAGER_SUM contains a record with:
So results are correct?
If not give sample records for tteile and tlager_sum with DDL