[#ODBC-131] Numeric field as integer - Firebird RDBMS Issue Tracker

ODBC Driver

Numeric field as integer

Created: 12/Aug/11 08:29 PM Updated: 31/May/12 03:29 PM

Component/s:

None

Affects Version/s:

2.0

Fix Version/s:

2.0.1

Environment:

Windows 7

Description

« Hide

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.

All

Comments

Change History

Subversion Commits

Sort Order:

[ Permalink | « Hide ]

Alexander Potapchenko added a comment - 13/Aug/11 09:24 AM

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?

[ Permalink | « Hide ]

Everton Lucas added a comment - 15/Aug/11 05:31 PM

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

[ Permalink | « Hide ]

Alexander Potapchenko added a comment - 15/Aug/11 05:43 PM

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