strange behavior with decimals

[jorgediezchang]

With this query , the table and condition were removed

select saldo,mod(saldo,2) from

where

I got this result in tora

saldo | mod(saldo,2) 8429671.3499999996 | 1.3500000000000001

but when i did the same in sqlplus i got

saldo | mod(saldo,2) 8429671.35| 1.35

the definition of the table

SALDO NOT NULL NUMBER(19,6)

why i got this numbers in tora?

[ibre5041]

I don't get it, how could the query be executed when table name was removed? The 2nd is part probably caused by data type conversion OCINumber -> float -> String. Will have to check that.

[jorgediezchang]

Good morning Ivan

The query was simplified for the report of the issue.

We are testing tools to replace toad, since toad is so expensive for us as freelance developers in my country

I had a new issue yesterday:

I tested a query that returned 212 in Tora, but it seemed that there were missing rows from a previous analysis, after a bunch of modifications to the query and testing selecting parcial groups of data, i run the query in Toad and got 468 and the rows i know would be in the result.

Then I assume Tora has some issue, so I ordered the query to analize which rows were missing

Then I realize that in Tora the first 256 rows were missing in the browser view (odd number).

To confirm it, I did a select * from () where rownum < 250

And then i got the first 250 missing rows.

I don't know how to give you a environment to replicate this behaviour, but it happens.

best regards Jorge

2016-05-19 6:37 GMT-05:00 Ivan Brezina [email protected]:

I don't get it, how could the query be executed when table name was removed? The 2nd is part probably caused by data type conversion OCINumber -> float -> String. Will have to check that.

— You are receiving this because you authored the thread. Reply to this email directly or view it on GitHub https://github.com/tora-tool/tora/issues/35#issuecomment-220299567