Hi Folks,
When I execute the following snap of code in python:
c = max.sql("SELECT C.ID_STATUS_CHAMADA, SE.ID_STATUS_CDR,
R.ID_MOTIVO_REJEICAO, COUNT(C.ID_CDR), FIXED(SUM(C.VR_CHAMADA),18,5)
FROM CDR_REJEITADO R, CDR_COBILLING C, STATUS_EVENTO SE WHERE R.ID_CDR
= C.ID_CDR AND SE.ID_STATUS_EVENTO = 31 AND C.ID_LOTE_REMESSA = 90240
AND SE.ID_STATUS_CHAMADA = C.ID_STATUS_CHAMADA GROUP BY
C.ID_STATUS_CHAMADA, SE.ID_STATUS_CDR, R.ID_MOTIVO_REJEICAO")
for r in c:
print r
it returns a wrong result:
(5, 2, 8, 2, 0.23999999999999999)
('****', '****', '******', '***********', -0.0)
('****', '****', '******', '***********', -1.0037900000003859e+64)
('****', '****', '******', '***********', '********************')
('17', '****', '******', '***********', -0.0)
('****', '****', '******', '***********', -1.0000003643599998e+43)
('****', '****', '0', '***********', '********************')
(0, '****', 5, '9999', '********************')
('****', '****', '******', '0', -1.3880000000000002e+64)
('0', 2, '******', '***********', -1.0038500000388e+64)
('****', '****', '******', '65000000', -1.0000000036193704e+64)
But if I remove the sum column of the sql statment:
c = max.sql("SELECT C.ID_STATUS_CHAMADA, SE.ID_STATUS_CDR,
R.ID_MOTIVO_REJEICAO, COUNT(C.ID_CDR), FROM CDR_REJEITADO R,
CDR_COBILLING C, STATUS_EVENTO SE WHERE R.ID_CDR = C.ID_CDR AND
SE.ID_STATUS_EVENTO = 31 AND C.ID_LOTE_REMESSA = 90240 AND
SE.ID_STATUS_CHAMADA = C.ID_STATUS_CHAMADA GROUP BY
C.ID_STATUS_CHAMADA, SE.ID_STATUS_CDR, R.ID_MOTIVO_REJEICAO")
for r in c:
print r
it returns a correct result:
(5, 2, 8, 2)
(5, 2, 9, 6)
(5, 2, 10, 4)
(5, 2, 11, 4)
(5, 2, 15, 564)
(5, 2, 17, 648)
(5, 2, 43, 2)
(5, 2, 65, 898)
(5, 2, 67, 2)
(5, 2, 68, 90)
(5, 2, 80, 4)
Also the value of the sum column returned in the first row of the firts
resultset is almost wrong. It is showing 0.23999999999999999, but the
correct is 0.24.
It looks like the float type miscalculate the next row in the result set.
Any ideas on a fix or bypass the problem?
Regards,
Mário A. Pinho
--------------------------------------------------------------
Esta mensagem foi crianda utilizando o Webmail da 4freesystem.
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
