Wrong INTEGER value was returned

[h-serizawa]

vertica-nodejs version: 1.1.4
Vertica Version: 25.3.0-0
Cluster: Single node

When executing the following statement, the wrong INTEGER value was returned. The value cast to VARCHAR was correct.

[Statement]
SELECT CAST(205900366134250666 AS VARCHAR) AS keyCast, 205900366134250666 AS keyOrig;

[JavaScript code]

import vertica from "vertica-nodejs";
const { Client } = vertica;

const client = new Client("vertica://dbadmin:@host:5433/dbname");
client.connect();
client.query("SELECT CAST(205900366134250666 AS VARCHAR) AS keyCast, 205900366134250666 AS keyOrig;", (err, res) => {
  console.log(err || res.rows[0]);
  client.end();
});

[Output]

# node main.js 
{ keyCast: '205900366134250666', keyOrig: 205900366134250660 }

Can you review this issue and fix it?

[h-serizawa]

The maximum integer value in JavaScript is 9,007,199,254,740,991, and in Vertica, it is 9,223,372,036,854,775,808. If the data type of the return value is VerticaType.Integer, the client driver calls textParsers.parseInteger() in pg-types. textParsers.parseInteger() calls the JavaScript built-in parseInt().

205,900,366,134,250,666 is higher than the maximum integer value, so it is recognized as an unsafe value for the integer. Number.isSafeInteger(205900366134250666) returns false.

So, is the solution to call textParsers.parseBigInteger() instead of parseInteger()?

[vertica-nodejs/packages/vertica-nodejs/lib/type-overrides.js]

23 - types.setTypeParser(VerticaType.Integer, types.getTypeParser(21, 'text'))
23 + types.setTypeParser(VerticaType.Integer, types.getTypeParser(20, 'text'))