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-issue-importer opened this issue Aug 12, 2011 · 5 comments
Closed

Numeric field as integer [ODBC131] #128

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

Comments

@firebird-issue-importer

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Aug 13, 2011

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Aug 15, 2011

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Aug 15, 2011

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 5, 2012

Modified by: @alexpotapchenko

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

resolution: Cannot Reproduce [ 5 ]

Fix Version: 2.0.1 [ 10430 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented May 31, 2012

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
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants