[firebase-br] erro View apos atualizacao para versao 2.5

[Daniel Reis]

Pessoal,

 

Atualizei minha BD 2.1 para 2.5. Após a atualização uma de minhas views está
apresentando erro.

 

O erro só acontece se for executava a view. Se for executada somente o
select mostras os resultados normalmente sem erros.

 

Erro: 

 

Arithmetic overflow or division by zero has occurred.

 

 

CREATE VIEW VW_SPC2(

    CPJ_CDCLII006,

    CPJ_RZSOCA060,

    CPJ_CGCMFA014,

    CPF_DTNASD000,

    CPF_SEXOCA001,

    CPF_DOCOEA020,

    ECI_CDECII002,

    UFE_CDUFEA002,

    CPF_NOPAIA035,

    CPF_NOMAEA035,

    CPJ_ENDERA035,

    CPJ_CIDADA020,

    CPJ_CDUFEA030,

    CEP_CDCEPI005,

    CEP_DGCEPI003,

    CPJ_NMTE1A012,

    CRE_DTEMID000,

    CRE_DTVEND000,

    CRE_SERIEA003,

    CRE_NUNOFI006,

    CRE_VALORN017,

    CPJ_BAIRRA020,

    CRE_DEPARA002,

    CPF_NATURA020,

    EMP_CDEMPA003,

    NUMERO_ENDERECO)

AS

SELECT CPJ.CPJ_CDCLII006

      ,CPJ.CPJ_RZSOCA060

      ,CPJ.CPJ_CGCMFA014

      ,CPF.CPF_DTNASD000

      ,CPF.CPF_SEXOCA001

      ,CPF.CPF_DOCOEA020

      ,CPF.ECI_CDECII002

      ,CPF.UFE_CDUFEA002

      ,CPF.CPF_NOPAIA035

      ,CPF.CPF_NOMAEA035

      ,CPJ.CPJ_ENDERA035

      ,CPJ.CPJ_CIDADA020

      ,CPJ.CPJ_CDUFEA030

      ,CPJ.CEP_CDCEPI005

      ,CPJ.CEP_DGCEPI003

      ,CPJ.CPJ_NMTE1A012

      ,CRE.CRE_DTEMID000

      ,CRE.CRE_DTVEND000

      ,CRE.CRE_SERIEA003

      ,CRE.CRE_NUNOFI006

      ,CRE.CRE_VALORN017

      ,CPJ.CPJ_BAIRRA020

      ,CRE.CRE_DEPARA002

      ,CPF.CPF_NATURA020

      ,CRE.EMP_CDEMPA003

      ,NUMERO_ENDERECO

  FROM TB_CPJ CPJ INNER JOIN TB_CRE CRE ON (CPJ.CPJ_CDCLII006 =
CRE.CPJ_CDCLII006)

    INNER JOIN TB_CPF CPF ON (CPJ.CPJ_CDCLII006 = CPF.CPJ_CDCLII006)

WHERE

    CRE.CRE_SERIEA003 IN ('UNI','REN')

AND CRE.CPJ_CDCLII006 not in
(0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,85)

AND CRE.CRE_SITUAA001 <> 6

AND CRE.EMP_CDEMPA003 IN ('001','005','006')        --Empresa

AND CRE.CRE_DTVEND000 < (SELECT cast ('now' as timestamp) - 45 from
rdb$database)

AND CRE.CRE_VLPAGN017 < (CRE.CRE_VALORN017 + CRE.CRE_ACRESN017)

AND CRE.CRE_EMFATA003 <> '1'

AND CPJ.CPJ_CCOEMA001 = 'S'

AND CRE.CRE_VALORN017 > 5

AND CPJ.SCL_CDOBSI003 <> 6 --Nao emitir pra quem ja esta no spc

AND CPJ.CPJ_CDCLII006

NOT IN (

SELECT CPJ_CDCLII006 FROM TB_CON WHERE

       CON_DTPPGD000 >= (SELECT cast ('today' as date) from rdb$database)

       )

AND CPJ.CPJ_CDCLII006

NOT IN (

SELECT CPJ_CDCLII006 FROM TB_CON WHERE

       CON_DTPCOD000 >= (SELECT cast ('today' as date) from rdb$database)

       )

AND CPJ.CPJ_CDCLII006

IN (SELECT CPJ_CDCLII006 FROM TB_CON WHERE CON_SITUAA001 = 0)

;