Re: AW: AW: AW: [firebird-support] coalesce bug in fb 3.0 rc2?

2016-03-10 Thread 'Arno Brinkman' fbsupp...@abvisie.nl [firebird-support]
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

AW: AW: AW: [firebird-support] coalesce bug in fb 3.0 rc2?

2016-03-10 Thread 'Checkmail' check_m...@satron.de [firebird-support]
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

Re: AW: AW: [firebird-support] coalesce bug in fb 3.0 rc2?

2016-03-09 Thread 'Arno Brinkman' fbsupp...@abvisie.nl [firebird-support]
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

AW: AW: [firebird-support] coalesce bug in fb 3.0 rc2?

2016-03-09 Thread 'Checkmail' check_m...@satron.de [firebird-support]
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