Subject Query crash in Firebird 3.0.3
Author Pierre Y.
Post date 2018-02-08T15:02:26Z
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,, in Firebird 3.0.3 I get :

Overflow occurred during data type conversion.
conversion error from string "2".

I have to cast "2" as Integer to make it work again.

select
  cast(2 as Integer) 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

Is it as expected ?

Regards,

--
Pierre Yager
Crisalid