Subject | Re: [firebird-support] Query stop working after upgrade from 2.1.5 to 2.1.6 |
---|---|
Author | Macma |
Post date | 2014-09-03T08:24:34Z |
Hi,
I overcome this issue with this query
select
ke.I_ID_GRUPY,
ke.C_SYMBOL,
(
select first 1 cs.C_OPIS from T_CENY_SKLADNIKI as cs
left join T_CENY_W_OKRESIE as cwo on (cwo.I_ID_CENY_OKRS =
cs.I_ID_CENY_OKRS)
where cs.C_SYMBOL = ke.C_SYMBOL and cwo.I_ID_CENNIKA = any (select
I_ID_CENNIKA from R_KOSZTY as kk where kk.I_ID_KOSZTY = any (select ID
from IDY_DO_ZAPYTANIA))
) as C_OPIS_X,
sum(ke.N_VALUE) as N_VALUE_SUMA,
sum(ke.N_VATIN) as N_VATIN_SUMA,
sum(ke.N_COSTNETTO) as N_COSTNETTO_SUMA,
sum(ke.N_COSTBRUTTO) as N_COSTBRUTTO_SUMA,
ke.SI_WYKLADNIK, ke.SI_IDJEDNOSTKA, ke.SI_STPOTYPE, ke.SI_CURRENCYPERVALUE
from
R_KOSZTY k
left join R_KOSZT_OKRESY as ko on (ko.I_ID_KOSZTY = k.I_ID_KOSZTY)
left join R_KOSZT_ELEMENTY as ke on (ke.I_ID_KOSZT_OKRESY =
ko.I_ID_KOSZT_OKRESY)
where ke.SI_USEINSUMMARY = 1 and k.I_ID_KOSZTY = any (select ID from
IDY_DO_ZAPYTANIA)
group by ke.I_ID_GRUPY, ke.C_SYMBOL, C_OPIS_X, SI_WYKLADNIK,
SI_IDJEDNOSTKA, SI_STPOTYPE, SI_CURRENCYPERVALUE
order by max(ke.I_ORDER_INDEX)
I have to change "where kk.I_ID_KOSZTY = ko.I_ID_KOSZTY" to
"kk.I_ID_KOSZTY = any (select ID from IDY_DO_ZAPYTANIA)".
Best Regards,
macma
I overcome this issue with this query
select
ke.I_ID_GRUPY,
ke.C_SYMBOL,
(
select first 1 cs.C_OPIS from T_CENY_SKLADNIKI as cs
left join T_CENY_W_OKRESIE as cwo on (cwo.I_ID_CENY_OKRS =
cs.I_ID_CENY_OKRS)
where cs.C_SYMBOL = ke.C_SYMBOL and cwo.I_ID_CENNIKA = any (select
I_ID_CENNIKA from R_KOSZTY as kk where kk.I_ID_KOSZTY = any (select ID
from IDY_DO_ZAPYTANIA))
) as C_OPIS_X,
sum(ke.N_VALUE) as N_VALUE_SUMA,
sum(ke.N_VATIN) as N_VATIN_SUMA,
sum(ke.N_COSTNETTO) as N_COSTNETTO_SUMA,
sum(ke.N_COSTBRUTTO) as N_COSTBRUTTO_SUMA,
ke.SI_WYKLADNIK, ke.SI_IDJEDNOSTKA, ke.SI_STPOTYPE, ke.SI_CURRENCYPERVALUE
from
R_KOSZTY k
left join R_KOSZT_OKRESY as ko on (ko.I_ID_KOSZTY = k.I_ID_KOSZTY)
left join R_KOSZT_ELEMENTY as ke on (ke.I_ID_KOSZT_OKRESY =
ko.I_ID_KOSZT_OKRESY)
where ke.SI_USEINSUMMARY = 1 and k.I_ID_KOSZTY = any (select ID from
IDY_DO_ZAPYTANIA)
group by ke.I_ID_GRUPY, ke.C_SYMBOL, C_OPIS_X, SI_WYKLADNIK,
SI_IDJEDNOSTKA, SI_STPOTYPE, SI_CURRENCYPERVALUE
order by max(ke.I_ORDER_INDEX)
I have to change "where kk.I_ID_KOSZTY = ko.I_ID_KOSZTY" to
"kk.I_ID_KOSZTY = any (select ID from IDY_DO_ZAPYTANIA)".
Best Regards,
macma