github-starred/better-auth
2
0
Fork 0
mirror of https://github.com/better-auth/better-auth.git synced 2026-05-22 22:32:01 -05:00
Code Issues 2.5k Packages Projects Releases 112 Wiki Activity

Email column of user table is case sensitive, #429

New Issue
Closed
opened 2026-03-13 07:45:31 -05:00 by GiteaMirror · 3 comments
GiteaMirror commented 2026-03-13 07:45:31 -05:00
Owner
Copy Link

Originally created by @EthanITA on GitHub (Dec 18, 2024).

Is this suited for github?

  • Yes, this is suited for github

To Reproduce

Using only Google social sign in, I just noticed that a person has 2 "User" with the same email, the only difference is one starts with a capital "S", and the other one in lowercase "s"

Current vs. Expected behavior

It should be case insensitive

What version of Better Auth are you using?

1.0.22

Provide environment information

- MacOS
- pnpm
- Drizzle ORM
- generated with the cli and then adapted the schema

export const user = pgTable("user", {
  id: text().primaryKey(),
  name: text().notNull(),
  email: text().notNull().unique(),
  emailVerified: boolean().notNull(),
  image: text(),
  role: text().$type<"user" | "admin">().default("user"),
  banned: boolean("banned"),
  banReason: text("banReason"),
  banExpires: timestamp("banExpires"),
  ...timestamps,
});

Which area(s) are affected? (Select all that apply)

Backend

Auth config (if applicable)

import { betterAuth } from "better-auth";
import { drizzleAdapter } from "better-auth/adapters/drizzle";
import { db } from "./drizzle";
import { admin, passkey } from "better-auth/plugins";
import { useEnv } from "./env";

export const auth = betterAuth({
  database: drizzleAdapter(db, {
    provider: "pg",
  }),
  emailAndPassword: {
    enabled: true,
  },
  socialProviders: {
    google: {
      clientId: useEnv.GOOGLE_CLIENT_ID,
      clientSecret: useEnv.GOOGLE_CLIENT_SECRET,
    },
  },
  plugins: [passkey(), admin()],
});

Additional context

No response

Originally created by @EthanITA on GitHub (Dec 18, 2024). ### Is this suited for github? - [x] Yes, this is suited for github ### To Reproduce Using only Google social sign in, I just noticed that a person has 2 "User" with the same email, the only difference is one starts with a capital "S", and the other one in lowercase "s" ### Current vs. Expected behavior It should be case insensitive ### What version of Better Auth are you using? 1.0.22 ### Provide environment information ```bash - MacOS - pnpm - Drizzle ORM - generated with the cli and then adapted the schema export const user = pgTable("user", { id: text().primaryKey(), name: text().notNull(), email: text().notNull().unique(), emailVerified: boolean().notNull(), image: text(), role: text().$type<"user" | "admin">().default("user"), banned: boolean("banned"), banReason: text("banReason"), banExpires: timestamp("banExpires"), ...timestamps, }); ``` ### Which area(s) are affected? (Select all that apply) Backend ### Auth config (if applicable) ```typescript import { betterAuth } from "better-auth"; import { drizzleAdapter } from "better-auth/adapters/drizzle"; import { db } from "./drizzle"; import { admin, passkey } from "better-auth/plugins"; import { useEnv } from "./env"; export const auth = betterAuth({ database: drizzleAdapter(db, { provider: "pg", }), emailAndPassword: { enabled: true, }, socialProviders: { google: { clientId: useEnv.GOOGLE_CLIENT_ID, clientSecret: useEnv.GOOGLE_CLIENT_SECRET, }, }, plugins: [passkey(), admin()], }); ``` ### Additional context _No response_
GiteaMirror added the bug label 2026-03-13 07:45:31 -05:00
GiteaMirror commented 2026-03-13 07:45:32 -05:00
Author
Owner
Copy Link

@daveycodez commented on GitHub (Dec 18, 2024):

Ooooof good catch. Maybe can be addressed with databaseHooks

@daveycodez commented on GitHub (Dec 18, 2024): Ooooof good catch. Maybe can be addressed with databaseHooks
GiteaMirror commented 2026-03-13 07:45:32 -05:00
Author
Owner
Copy Link

@Bekacru commented on GitHub (Dec 19, 2024):

we actually do normalize emails https://github.com/better-auth/better-auth/blob/main/packages/better-auth/src/oauth2/link-account.ts#L102

@Bekacru commented on GitHub (Dec 19, 2024): we actually do normalize emails https://github.com/better-auth/better-auth/blob/main/packages/better-auth/src/oauth2/link-account.ts#L102
GiteaMirror commented 2026-03-13 07:45:33 -05:00
Author
Owner
Copy Link

@EthanITA commented on GitHub (Dec 19, 2024):

we actually do normalize emails https://github.com/better-auth/better-auth/blob/main/packages/better-auth/src/oauth2/link-account.ts#L102

It’s a commit of Dec 6, then I guess it was caused because I recently updated the library. Thank you!

@EthanITA commented on GitHub (Dec 19, 2024): > we actually do normalize emails https://github.com/better-auth/better-auth/blob/main/packages/better-auth/src/oauth2/link-account.ts#L102 It’s a commit of Dec 6, then I guess it was caused because I recently updated the library. Thank you!
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
adapter
astro
awaiting external contributor
blocked
breaking
breaking change
bug
c-devops
core
credentials
database
dependencies
devops
devtools
docs
documentation
duplicate
elysia
enhancement
enterprise
expo
express
fastify
good first issue
help wanted
hono
identity
infra
integration
invalid
javascript
locked
maintenance
need-more-information
needs: info
needs: repro
nextjs
nuxt
oauth
organization
P0
payments
perf
platform
plugin
pull-request
Mirrored from GitHub Pull Request
 question
ready
regression
remix
security
social-provider
solid
stale
svelte
tanstack-start
tracking
version-bump
vue
wontfix
No Label bug
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
GiteaMirror ninjasurge
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/better-auth#429
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?