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:
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 in fb 3.0 rc2?
Hello,
> your are right. But i
sum.
Thanks
Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Mittwoch, 9. März 2016 09:04
An: firebird-support@yahoogroups.com
Betreff: Re: AW: [firebird-support] coalesce bug in fb 3.0 rc2?
Hello,
> sorry, outlook corrects me in
On 2016-03-09 7:57, 'Checkmail' check_m...@satron.de [firebird-support]
wrote:
> Hello again,
>
> sorry, outlook corrects me in German. At the moment, I have no
> sulution for the problem. Anything ideas?
I think you should create a sample database to demonstrate this
problem, and create a
: [firebird-support] coalesce bug in fb 3.0 rc2?
Hell Mark,
I would get all material, where the minimum inventory amount iss maller the the
inventory amount.
Tlager_sum contains the inventory amount, tteile.minb the theoretical minimum
amount it should be.
Now, the simplified
irebird-support@yahoogroups.com
Betreff: Re: [firebird-support] coalesce bug in fb 3.0 rc2?
On 2016-03-08 16:18, 'Checkmail' check_m...@satron.de
<mailto:check_m...@satron.de>
[firebird-support] wrote:
> Hello,
>
> in the further version of firebird I can execute the following an
On 2016-03-08 16:18, 'Checkmail' check_m...@satron.de
[firebird-support] wrote:
> Hello,
>
> in the further version of firebird I can execute the following and
> get
> the real value of m (exists in tlager_sum)
>
> select a.teilenr, a.bezeichnung, a.minb, coalesce(b.menge,0) as m,
> a.typ
>
>
Hello,
in the further version of firebird I can execute the following and get the
real value of m (exists in tlager_sum)
select a.teilenr, a.bezeichnung, a.minb, coalesce(b.menge,0) as m, a.typ
from tteile a left join tlager_sum b on (a.teilenr = b.teilenr)
where ((a.minb >