From 4ee8b24cfadf47452807fa2af801385ed60ab47c Mon Sep 17 00:00:00 2001
From: dujinkim <dujin.kim@dtsolution.co.kr>
Date: Mon, 15 Sep 2025 14:41:01 +0000
Subject: (대표님) 작업사항 - rfqLast, tbeLast, pdfTron, userAuth
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 lib/users/auth/verifyCredentails.ts | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'lib/users/auth')

diff --git a/lib/users/auth/verifyCredentails.ts b/lib/users/auth/verifyCredentails.ts
index 8cb3c434..b3dcd270 100644
--- a/lib/users/auth/verifyCredentails.ts
+++ b/lib/users/auth/verifyCredentails.ts
@@ -6,7 +6,7 @@ import crypto from 'crypto';
 // (처리 불필요) 키 암호화를 위한 fs 모듈 사용, 형제 경로 사용하며 public 경로 아니므로 파일이 노출되지 않음.
 import fs from 'fs';
 import path from 'path';
-import { eq, and, desc, gte, count } from 'drizzle-orm';
+import { eq, and, desc, gte, count ,sql } from 'drizzle-orm';
 import db from '@/db/db';
 import {
   users,
@@ -291,7 +291,7 @@ export async function verifyExternalCredentials(
       .from(users)
       .where(
         and(
-          eq(users.email, username),
+          sql`LOWER(${users.email}) = LOWER(${username})`, // 대소문자 구분 없이 비교
           eq(users.isActive, true) // 활성 유저만
         )
       )
-- 
cgit v1.2.3