cube-js / cube-js/cube

Unexpected rounding of int64 values

Open
#9,136 2 comments 0 reactions 0 assignees View on GitHub
driver:bigquery
Dominant language
Rust
Stars
20.8k
Forks
2.1k
Avg merge
1d 2h
Merged PRs (30d)
181

Description

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

Related Cube.js schema
```javascript
cube(`test`, {
sql: `SELECT
-9222709539351053981 AS user_id`,
dimensions: {
user_id: {
sql: `user_id`,
type: `number`,
},
},
});
```

Related Cube.js generated SQL
```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

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.