Hello!
I have the select below that runs OK on my Informix Dynamic Sever 7.30.TC3
When I run it on 7.31.UC4 on dbaccess, it hangs and I have no return.
If I change
AND (R034FUN.NUMCAD = 4602 OR R034FUN.NUMCAD = 4024)
to AND (R034FUN.NUMCAD = 4602) (using only one value)
the command goes OK.

Is there a bug in 7.31 that was not in 7.30?

Thanks to all!

SELECT DISTINCT
R034FUN.NUMEMP R034FUNNUMEMP,
R034FUN.TIPCOL R034FUNTIPCOL,
R034FUN.NUMCAD R034FUNNUMCAD,
R038HCA.NUMEMP R038HCANUMEMP,
R038HCA.TIPCOL R038HCATIPCOL,
R038HCA.NUMCAD R038HCANUMCAD,
R038HCA.DATALT R038HCADATALT,
R038HCA.CODCAR R038HCACODCAR,
R038HCA.ESTCAR R038HCAESTCAR,
R038HFI.NUMEMP R038HFINUMEMP,
R038HFI.TIPCOL R038HFITIPCOL,
R038HFI.NUMCAD R038HFINUMCAD,
R038HFI.DATALT R038HFIDATALT,
R038HFI.CODFIL R038HFICODFIL,
R038HFI.EMPATU R038HFIEMPATU,
R016HIE.TABORG R016HIETABORG,
R016HIE.NUMLOC R016HIENUMLOC,
R016HIE.DATINI R016HIEDATINI,
R016HIE.CODLOC R016HIECODLOC,
R034FUN.ESTCAR R034FUNESTCAR,
R034FUN.CODCAR R034FUNCODCAR,
R034FUN.CODCHA R034FUNCODCHA,
R034FUN.NOMFUN R034FUNNOMFUN,
R034FUN.DATADM R034FUNDATADM,
R038HLO.NUMEMP R038HLONUMEMP,
R038HLO.TIPCOL R038HLOTIPCOL,
R038HLO.NUMCAD R038HLONUMCAD,
R038HLO.DATALT R038HLODATALT,
R038HLO.TABORG R038HLOTABORG,
R038HLO.NUMLOC R038HLONUMLOC,
R030EMP.NUMEMP R030EMPNUMEMP,
R016HIE.POSLOC R016HIEPOSLOC,
R038HVI.NUMEMP R038HVINUMEMP,
R038HVI.TIPCOL R038HVITIPCOL,
R038HVI.NUMCAD R038HVINUMCAD,
R038HVI.DATALT R038HVIDATALT,
R038HVI.CODVIN R038HVICODVIN,
'000' NIV00,
R034FUN.TIPCON R034FUNTIPCON,
R034FUN.CODEST R034FUNCODEST,
R030EMP.NOMEMP R030EMPNOMEMP
FROM R034FUN, R038HCA, R038HFI, R016HIE,
R038HLO, R030EMP, R038HVI, R016ORN, R022VIN
WHERE R034FUN.NUMEMP = 1
AND R034FUN.TIPCOL = 1
AND (R034FUN.NUMCAD = 4602 OR R034FUN.NUMCAD = 4024)
AND R038HLO.NUMEMP = R034FUN.NUMEMP
AND R038HLO.TIPCOL = R034FUN.TIPCOL
AND R038HLO.NUMCAD = R034FUN.NUMCAD
AND R038HFI.NUMEMP = R034FUN.NUMEMP
AND R038HFI.TIPCOL = R034FUN.TIPCOL
AND R038HFI.NUMCAD = R034FUN.NUMCAD
AND R038HCA.NUMEMP = R034FUN.NUMEMP
AND R038HCA.TIPCOL = R034FUN.TIPCOL
AND R038HCA.NUMCAD = R034FUN.NUMCAD
AND R016HIE.TABORG = R038HLO.TABORG
AND R016HIE.NUMLOC = R038HLO.NUMLOC
AND R016HIE.DATINI <= DATETIME(2003-6-30)YEAR TO DAY
AND R016HIE.DATFIM >= DATETIME(2003-6-30)YEAR TO DAY
AND R038HLO.TABORG = R016ORN.TABORG AND
R038HLO.NUMLOC = R016ORN.NUMLOC
AND R030EMP.NUMEMP = R034FUN.NUMEMP
AND R034FUN.NUMEMP = R038HVI.NUMEMP
AND R034FUN.TIPCOL = R038HVI.TIPCOL
AND R034FUN.NUMCAD = R038HVI.NUMCAD
AND R038HVI.CODVIN = R022VIN.CODVIN
AND R022VIN.CALFOL = 'S'
AND R038HLO.DATALT =
(SELECT MAX(DATALT)
FROM R038HLO TABELA001
WHERE TABELA001.NUMEMP = R038HLO.NUMEMP
AND TABELA001.TIPCOL = R038HLO.TIPCOL
AND TABELA001.NUMCAD = R038HLO.NUMCAD
AND TABELA001.DATALT <= DATETIME(2003-6-30)YEAR TO DAY)
AND R038HFI.DATALT =
(SELECT MAX(DATALT)
FROM R038HFI TAB2
WHERE TAB2.NUMEMP = R038HFI.NUMEMP
AND TAB2.TIPCOL = R038HFI.TIPCOL
AND TAB2.NUMCAD = R038HFI.NUMCAD
AND TAB2.NUMEMP = TAB2.EMPATU
AND TAB2.NUMCAD = TAB2.CADATU
AND TAB2.DATALT <= DATETIME(2003-6-30)YEAR TO DAY)
AND R038HCA.DATALT =
(SELECT MAX(DATALT)
FROM R038HCA TABELA002
WHERE TABELA002.NUMEMP = R038HCA.NUMEMP
AND TABELA002.TIPCOL = R038HCA.TIPCOL
AND TABELA002.NUMCAD = R038HCA.NUMCAD
AND TABELA002.DATALT <= DATETIME(2003-6-30)YEAR TO DAY)
AND R038HVI.DATALT =
(SELECT MAX(DATALT) FROM R038HVI TABELA003
WHERE TABELA003.NUMEMP = R038HVI.NUMEMP
AND TABELA003.TIPCOL = R038HVI.TIPCOL
AND TABELA003.NUMCAD = R038HVI.NUMCAD
AND TABELA003.DATALT <= DATETIME(2003-6-30)YEAR TO DAY)
AND 0 = 0 AND 1 = 1 ORDER BY 1 ASC,23 ASC,3 ASC

Hi,

I would suggest you test this qry with the lastest version of Informix.
It is always possible there was a bug - but in that case it wil certainly be fixed by now (9.40.UC2).

Unfortunetly the I can't change the DB version.
Which is the latest patch for this version?

It's only one report in the role system that doesn't works...

Thanks so far
Regards!

I think development is currently at level 7.31.UD7.
UD6 should be GA soon.