FirebirdSQL/firebird-odbc-driver

Numeric field as integer [ODBC131]

firebird-automations opened this issue · 5 comments

Submitted by: Everton Lucas (evtlucas)

I'm working in a project which I need to transfer some data from a firebird database to an oracle database. I'm using ODBC and Oracle Heterogeneous Services to connect in firebird from pl/sql procedures and functions.
When I'm reading numeric fields, the data inside these fields is returned as integer. (e.g. 812,43 returns as 812). The only way I can read the data correctly is dividing it by 100 and multiplying by 100 again. But when I need to use these one in a function(e.g. SUM), it returns as integer again, even when I perform the divide/multiply.

Commented by: @alexpotapchenko

It is more similar to a bug in Oracle.. Do you know way to reproduce it without Oracle?
The construction - sum ( CAST(field as float) ) can not help?

Commented by: Everton Lucas (evtlucas)

Maybe. Do you have some tip about how could I test if this bug is in Oracle or ODBC driver?

Commented by: @alexpotapchenko

I want to look at the ODBC trace log when you execute the query such as - "select numeric_field from table"

Modified by: @alexpotapchenko

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Cannot Reproduce [ 5 ]

Fix Version: 2.0.1 [ 10430 ]

Modified by: @alexpotapchenko

status: Resolved [ 5 ] => Closed [ 6 ]