supabase javascript lib returns incorrect numeric value for bigint column

[andyk]

Bug report

• [x ] I confirm this is a bug with Supabase, not with my own application.
• [ x] I confirm I have searched the Docs, GitHub Discussions, and Discord.

Describe the bug

The value returned by the javascript supabase lib for a column of type bigint is wrong for large integer values. It seems to be rounded. Maybe because of overflow in javascript's numeric type.

Maybe related to supabase/supabase#13612.

Here is my code in my Create React App:

        supabase.from('NewThoughts').select('*').then(response => {
            console.log("THOUGHTS:");
            console.log(response.data);
        });

(screenshot of code)

Here is the result in my browser console:

Here is my table in supabase

But if (per the advice in this stackoverflow post) i change the code to:

        supabase.from('NewThoughts').select('id::text').then(response => {
            console.log("THOUGHTS:");
            console.log(response.data);
        });

the values returned from the lib seems correct

Env

• OS: macOS
• Browser (if applies) Chrome Version 111.0.5563.146 (Official Build) (arm64)
• Version of supabase-js: 2.15.0
• Version of Node: 19.8.1
• Version of npm: 9.6.2

Additional context

> npm list
headlong@0.1.0 /Users/andyk/Development/headlong/frontend
├── @emotion/react@11.10.6
├── @emotion/styled@11.10.6
├── @mui/material@5.11.16
├── @mui/styled-engine-sc@5.11.11
├── @supabase/supabase-js@2.15.0
├── axios@0.19.2
├── cra-build-watch@1.4.1
├── react-scripts@5.0.1
├── react-window@1.8.8
├── socket.io-client@4.6.1
└── styled-components@5.3.9

> npm --version
9.6.2
> node --version
v19.8.1

[GaryAustin1]

JavaScript does not support bigint. You can cast to a string.
supabase.from('table_name').select('id, num::text');

[andyk]

Makes sense. Could the lib check the column type and throw an error instead of returning incorrect values?

[soedirgo]

Thanks @andyk - let's track this on https://github.com/supabase/postgrest-js/issues/319.

[andyk]

Sounds great