Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Numeric field as integer [ODBC131] #128

Closed
firebird-automations opened this issue Aug 12, 2011 · 5 comments
Closed

Numeric field as integer [ODBC131] #128

firebird-automations opened this issue Aug 12, 2011 · 5 comments

Comments

@firebird-automations
Copy link

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.

@firebird-automations
Copy link
Author

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?

@firebird-automations
Copy link
Author

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?

@firebird-automations
Copy link
Author

Commented by: @alexpotapchenko

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

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

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

resolution: Cannot Reproduce [ 5 ]

Fix Version: 2.0.1 [ 10430 ]

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants