This repository was archived by the owner on Mar 4, 2026. It is now read-only.
This repository was archived by the owner on Mar 4, 2026. It is now read-only.
Out of Bounds for non-existent value #197
Description
Environment details
- OS: CoreOS
- Node.js version: v8.9.4
- npm version: v6.0.1
@google-cloud/spannerversion: v1.4.1
Steps to reproduce
- ???
- ???
Not sure how to reproduce as this is quite odd. I'm paging data out of an interleaved table using a standard SELECT * FROM <TABLE> ORDER BY id LIMIT X OFFSET Y query. When querying this certain table I get the below error with an out of bounds value. However when I query the database for that record none exists (when querying for that value in the mentioned column).
"Error: Serializing column "created" encountered an error: Integer 149745544472341487 is out of bounds. Call row.toJSON({ wrapNumbers: true }) to receive a custom type."
1: "at Int.valueOf (/opt/app/node_modules/@google-cloud/spanner/src/codec.js:64:11)"
2: "at /opt/app/node_modules/@google-cloud/spanner/src/codec.js:96:25"
3: "at Array.reduce (<anonymous>)"
4: "at Array.<anonymous> (/opt/app/node_modules/@google-cloud/spanner/src/codec.js:85:16)"
5: "at rows.map.row (/opt/app/cache-warmers/batch.js:37:30)"
6: "at Array.map (<anonymous>)"
7: "at fetchBatch (/opt/app/cache-warmers/batch.js:37:15)"
8: "at <anonymous>"
9: "at process._tickCallback (internal/process/next_tick.js:188:7)"
Interestingly over time I see the two same values consistently reported. 149745544472341487 & 7394089836914076784.