"
### Error updating database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BIGINT) AS possibleDateTimeId,
CAST('2024-08-06 17:00:00' AS TIMESTA' at line 5
### The error may exist in class path resource [mapper/PossibleDateTimeMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: INSERT INTO t_possible_datetime (possible_datetime_id, possible_datetime, possible_datetime_status, user_id) SELECT possibleDateTimeId, possibleDateTime, possibleDateTimeStatus, userId FROM ( SELECT CAST(? AS BIGINT) AS possibleDateTimeId, CAST(? AS TIMESTAMP) AS possibleDateTime, CAST(? AS VARCHAR) AS possibleDateTimeStatus, CAST(? AS BIGINT) AS userId ) AS new_values WHERE NOT EXISTS ( SELECT 1 FROM t_possible_datetime WHERE user_id = new_values.userId AND possible_datetime = new_values.possibleDateTime );
### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BIGINT) AS possibleDateTimeId,
CAST('2024-08-06 17:00:00' AS TIMESTA' at line 5
; bad SQL grammar []"
Summary of resolutions or improvements
MySQL에서 CAST 함수를 사용 시, 허용되지 않는 Type을 수정
Note
RCA Rule
r: 꼭 반영해 주세요. 적극적으로 고려해 주세요. (Request changes)
c: 웬만하면 반영해 주세요. (Comment)
a: 반영해도 좋고 넘어가도 좋습니다. 그냥 사소한 의견입니다. (Approve)
Resolves #{이슈-번호}
Issue Define
Summary of resolutions or improvements
Note
RCA Rule
r: 꼭 반영해 주세요. 적극적으로 고려해 주세요. (Request changes)
c: 웬만하면 반영해 주세요. (Comment)
a: 반영해도 좋고 넘어가도 좋습니다. 그냥 사소한 의견입니다. (Approve)