(임수민) 데이터룸 로그인 수정

1 files changed, 4 insertions, 3 deletions

diff --git a/lib/users/auth/email-auth.ts b/lib/users/auth/email-auth.ts
index 9b87add5..72cd46d8 100644
--- a/lib/users/auth/email-auth.ts
+++ b/lib/users/auth/email-auth.ts
@@ -1,6 +1,6 @@
 'use server';
 
-import { eq, and } from 'drizzle-orm';
+import { eq, and, sql } from 'drizzle-orm';
 import db from '@/db/db';
 import { users, mfaTokens } from '@/db/schema';
 import { isEmailWhitelisted } from '@/lib/email-whitelist/service';
@@ -34,18 +34,19 @@ export async function checkEmailAndStartAuth(email: string): Promise<{
 
     const normalizedEmail = email.toLowerCase().trim();
 
-    // 1. 사용자 존재 확인
+    // 1. 사용자 존재 확인 (대소문자 구분 없이 비교 - 기존 데이터 호환성)
     const [user] = await db
       .select({
         id: users.id,
         name: users.name,
         email: users.email,
+        language: users.language,
         isActive: users.isActive,
         isLocked: users.isLocked,
         lockoutUntil: users.lockoutUntil,
       })
       .from(users)
-      .where(eq(users.email, normalizedEmail))
+      .where(sql`LOWER(${users.email}) = LOWER(${normalizedEmail})`)
       .limit(1);
 
     if (!user) {