Auth refresh_tokens truncated – need column type fix

Auth refresh_tokens truncated – need column type fix

We are currently on the free plan but we are getting
auth.refresh_tokens.token/parent/user_id are varchar(255); refresh tokens are being truncated to 12 chars, causing 500 on refresh, this causes auto log out of the webapp because of token refresh mismatch.

Login response refresh_token is short (e.g., gh2syfijkurh) instead of a long JWT.

Evidence:
SELECT column_name, data_type, character_maximum_length FROM information_schema.columns WHERE table_schema='auth' AND table_name='refresh_tokens'; → shows varchar(255).
Sample tokens length 12 from SELECT length(token), token FROM auth.refresh_tokens ORDER BY len ASC LIMIT 5;.

But i need supabase themself to help alter the table from VarChar255 to text so as to be able to get the long refresh tokens.

please advise
Was this page helpful?