Unexpected rounding of int64 values

[itestyoy]

Hi! Why does Cube round the last 3 digits in int64?
Result -9222709539351054000
But expected: -9222709539351053981

Related Cube.js schema

cube(`test`, {
  sql: `SELECT
         -9222709539351053981 AS user_id`,
  dimensions: {
    user_id: {
      sql: `user_id`,
      type: `number`,
    },
  },
});

Related Cube.js generated SQL

SELECT
  `test`.user_id AS `test__user_id`
FROM
  (
    SELECT
      -9222709539351053981 AS user_id
  ) AS `test`
GROUP BY
  1
ORDER BY
  1 ASC
LIMIT
  100;

DB: BigQuery

[igorlukanin]

Indeed, I was able to confirm this on v1.1.16.

My vague suspicion would be that, somewhere in the underlying client library for BigQuery, some precision loss happens because JavaScript just can't handle numbers that low/high. Or maybe it's in Cube's driver code.

Would you have the capacity to dig deeper and investigate this?

[itestyoy]

@igorlukanin Probably, this is somehow connected with wrapIntegers:

https://cloud.google.com/nodejs/docs/reference/bigquery/latest/overview#_google_cloud_bigquery_QueryResultsOptions_type

And also this:
googleapis/nodejs-bigquery#6

I’m not sure about Cube’s driver code, but after searching, I didn’t find any information about using the wrapIntegers option in Cube code.