[firebase-br] union c/problema sério

[marcelo luiz stefaniak - teflamar]

fb ficou maluco com o union, infelizmente:
as seguintes selects separadas retornam 250 registros
e juntas com union, retornam 245...  

SELECT DATA,CR2.COD,VALOR, 
CR2.CONTADB, 
CR2.CONTACR,
CR2.DUPLICATA, 
CR2.CLIENTE,EMP.NOME,CR01.NOME AS OPERACAO 
FROM CR2 
LEFT OUTER JOIN CADEMP EMP ON (EMP.COD = CR2.CLIENTE) 
LEFT OUTER JOIN CR01 ON (CR1.COD = CR2.COD) 
WHERE (CR2.CONTADB=:CONTA) 
AND CR2.DATA BETWEEN :DATAI AND :DATAF 
UNION 
SELECT CR2.DATA,CR2.COD,CR2.VALOR, 
CR2.CONTADB,
CR2.CONTACR,
CR2.DUPLICATA, 
CR2.CLIENTE,EMP.NOME,CR1.NOME AS OPERACAO 
FROM CR2 
LEFT OUTER JOIN CADEMP EMP ON (EMP.COD = CR2.CLIENTE) 
LEFT OUTER JOIN CR1 ON (CR1.COD = CR2.COD) 
WHERE (CR2.CONTACR=:CONTA) 
AND CR2.DATA BETWEEN :DATAI AND :DATAF