"providers" field in "raw_app_meta_data" in auth.users table does not contain "email"

[GA1]

Bug report

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

Describe the bug

I use google auth app locally as my only social sign in
My app has been working correctly for months with google sign in only. I have a sign in screen that correctly redirects me to google sign in page, after which I am redirected back to my app again.
I am trying to add sign up/in by email to my local supabase instance before I enable it in production.

To Reproduce

• Sign up with google in frontend.
• Sign out manually
• Sign up with magic link from my frontend by using the docs from here (https://supabase.com/docs/guides/auth/auth-email-passwordless)

      const { data, error } = await getSupabaseClient().auth.signInWithOtp({
        email: 'my.private.email@gmail.com',
        options: {
          shouldCreateUser: true,
          emailRedirectTo: 'https://example.com/welcome',
        },
      })

• Verify email by going to inbucket at: http://localhost:54324/ and verify the email
• go to my local supabase sql editor: http://localhost:54323/project/default/sql/1
• run query select * from auth.users;
• the column raw_app_meta_data has this:

    "raw_app_meta_data": {
      "provider": "google",
      "providers": [
        "google"
      ]
    },

note that if I reverse the order (first signup with magic link and then sign in with google) the object does look correctly:

    "raw_app_meta_data": {
      "provider": "email",
      "providers": [
        "email",
        "google"
      ]
    },

Expected behavior

the column raw_app_meta_data should have:

    "raw_app_meta_data": {
      "provider": "email",
      "providers": [
        "google",
        "email"
      ]
    },

System information

• OS: MAC
• Version of supabase cli 1.183.5
• Version of supabase-js: 2.45.2
• Version of Node.js: v20.11.1

[dikshantrajput]

"note that if I reverse the order (first signup with magic link and then sign in with google) the object does look correctly:"

What is the incorrect version of it? If you first sign in with google and then signup with magic link, you are getting providers in reverse order? is array indexing an issue here?

[GA1]

no

If I first sign in with google and then signup with magic link, I am getting providers: ["google"], and I expect providers: ["google", "email"]

[Hallidayo]

Hi, I've moved this issue over from the supabase repo as it seems more auth related.