Skip to Main Content
Forums

Programming Languages & Frameworks

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Integer overflow in version 2?

3622789Jan 19 2018 — edited Feb 14 2018

Hi,

I have some integration tests in which I create a record in a certain table with the highest id possible (the type is NUMBER(12, 0) so I use 999999999999).

The problem I'm having is that with version 2 of the Node driver when reading the data it's overflowing somewhere, as I get 'ID: -727379969' in the query results. It's as if now the integers were 32 bit. This didn't happen to me in version 1. I've tried in both Linux and Mac (64 bit machines).

Is this a bug?

Thank you.

Comments

Gaz in Oz

Please post a runnable example program plus table creation sql.

Please post input/output of the program showing the "error

Please also supply db version (4 digits), client and server OS version and architecture.

Any other information that may beuseful to re-create what you are seeing and doing.

1 person found this helpful
Christopher Jones-Oracle

Can you post at https://github.com/oracle/node-oracledb/issues  and include the info that @"Gaz in Oz" requested?

3622789

Done, thank you. https://github.com/oracle/node-oracledb/issues/833

A general note to people reading this thread: Node.js's number range is limited so you may need to fetch numbers as strings and use a 3rd party module such as bigint to handle them 'properly'.  Some details are in https://github.com/oracle/node-oracledb/issues/842 .  Perhaps a better general recommendation is to do all number calculations in SQL or PL/SQL.

node-oracledb 2.1 is out with the specific regression fixed.  My earlier comments about Node.js's number range still apply, of course.

1 - 5

Post Details

Added on Jan 19 2018
#node-js
5 comments
1,105 views