Hi,
Thank you for providing a script, this is much easier comparing.
I can now reproduce the error you get.
Please enter a ticket with this script into the tracker, so they can fix this
issue.
Enter these both queries, so they can quickly find the bug:
The query with the wrong results:
SELEC
mount (minb) and should not be displayed (like in firebird 2.5, 2.1,
2.0)
Thanks
Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Mittwoch, 9. März 2016 13:25
An: firebird-support@yahoogroups.com
Betreff: Re: AW: AW: [firebird-support] coalesce bug
Hello,
> 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 grea
Hello,
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