Cannot login after signout using Drizzle Adapter with Turso

Environment

System:
OS: Linux 6.1 Manjaro Linux
CPU: (8) x64 Intel(R) Core(TM) i7-7700HQ CPU @ 2.80GHz
Memory: 10.74 GB / 15.51 GB
Container: Yes
Shell: 5.9 - /bin/zsh
Binaries:
Node: 20.5.1 - ~/.nvm/versions/node/v20.5.1/bin/node
Yarn: 1.22.19 - /usr/bin/yarn
npm: 9.8.0 - ~/.nvm/versions/node/v20.5.1/bin/npm
pnpm: 8.6.12 - /usr/bin/pnpm

Reproduction URL

https://github.com/kyujulian/next-auth-login-issue

Describe the issue

When using drizzle-adapter package the adapter cannot retrieve the 'provider' and 'providerAccountId' on the database, causing the auth to throw OAuthAccountNotLinked Error when trying to login after a signout, even though there's only one provider.

How to reproduce

After going through the setup process on the reproduction URL,

Login with a given provider, signout then try to login again (with the same provider I configured only github for that reason) .

Expected behavior

Expected the adapter to link correctly to the account stored in the db.

Start with the reproduction URL and trace the Drizzle adapter flow for the sign-in, signout, and repeat sign-in sequence using Turso. Check why the stored provider and providerAccountId are not retrieved, then verify that the configured GitHub account links successfully after signout and login again.