[firebird-support] Re: Query crash in Firebird 3.0.3

> Is it as expected ? No, please register it at tracker. Regards, Vlad

Re: [firebird-support] Re: Query crash in Firebird 3.0.3

Done : http://tracker.firebirdsql.org/browse/CORE-5743 On Thu, Feb 8, 2018 at 5:46 PM, hv...@users.sourceforge.net [firebird-support] wrote: > > > > Is it as expected ? > > No, please register it at tracker. > > Regards, > Vlad > > >

Re: [firebird-support] Query problem

Hi Your bolded subquery need to have value e.g. VAREPLU_ID but you not group by this field and server do not know its value then If I understand that correct, I should do something like this: SELECT VARER.PLU_NR, VAREFRVSTR_DETAIL.V509INDEX, Sum(VAREFRVSTR_DETAIL.ANTALSTK) AS AntalStk,

Re: [firebird-support] Query problem

Hi, Yes,  but source of one column is ommitedVAREFRVSTR_DETAIL.LAENGDE_NAVNYou group by VAREFRVSTR.LAENGDE_NAVN Change your group by or change source of column in subquery Regards,Karol Bieniaszewski Oryginalna wiadomość Od: "michael.vilhelm...@microcom.dk [firebird-support]"

Re: [firebird-support] Query problem

Thank you. Now I understand and now it works. Like this: SELECT VARER.PLU_NR, VAREFRVSTR_DETAIL.V509INDEX, Sum(VAREFRVSTR_DETAIL.ANTALSTK) AS AntalStk, (SELECT Sum(TRANSAKTIONER.SALGSTK) FROM TRANSAKTIONER WHERE TRANSAKTIONER.ART IN (0, 1) AND

[firebird-support] Query crash in Firebird 3.0.3

Hello, This query was known to work in Firebird 3.0.2 : select 2 as TYPE_MVT, TYPE_REGLEMENT, DEVISE, null as BANQUE sum(QUANTITE) as NOMBRE, sum(VALEUR) as MONTANT from JOURNAL_CAISSE where (TYPE_MOUVEMENT in (2, 3)) and (ANNULE is false) and (periode = ?) group by 1,2,3,4 Now,,