재현 방법
- 서비스 DB 로그에 에러가 출력됨
- 추후 문제를 일으킬 수 있어 처리 필요
발생 위치
searchBookInfo (/app/backend/src/v1/books/books.controller.ts:112:34)
추가 정보
2023-11-08 00:00:10:010 error: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'jiphyeonjeon.book_info_search_keywords.disassembled_title' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Error Stack: Error: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'jiphyeonjeon.book_info_search_keywords.disassembled_title' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
at PromisePoolConnection.query (/app/node_modules/.pnpm/mysql2@2.3.3/node_modules/mysql2/promise.js:93:22)
at Module.executeQuery (/app/backend/src/mysql.ts:24:26)
at processTicksAndRejections (node:internal/process/task_queues:95:5)
at async Promise.all (index 1)
at Module.searchInfo (/app/backend/src/v1/books/books.service.ts:302:48)
at searchBookInfo (/app/backend/src/v1/books/books.controller.ts:112:34)
재현 방법
발생 위치
searchBookInfo (/app/backend/src/v1/books/books.controller.ts:112:34)추가 정보