Unable to delete user if `encrypted_password` is set to `null` about auth HOT 3 OPEN

listUsers via Supabase JS Admin API also fails w/ the same 500 error if the user w/ a NULL encrypted_password is in the page.

from auth.

Are you creating the user by writing data directly in the database?

from auth.

I've been working on migrating from firebase auth to supabase auth so I've had to insert/modify rows directly in auth.users. @hf there are some columns which are nullable currently but will cause crashes with null values. Those columns should probably be not null.

I think the affected columns are:

• encrypted_password
• confirmation_token
• recovery_token
• email_change_token_new
• email_change
• phone_change
• phone_change_token
• email_change_token_current
• email_change_confirm_status
• reauthentication_token

I'm not sure if that covers all of the columns that need to be not null but at least those are the ones I discovered seem to crash auth if they're null.

from auth.