binlog_format = MIXED
CREATE TABLE `TROUBLESHOOT_230203` (
`SEQNO` bigint(20) NOT NULL AUTO_INCREMENT,
`INDATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`SEQNO`)
복제 구성 후 스케줄로 들어오는 데이터가 REPLICA에 복제되지 않아 복제중단.
NOT NULL 컬럼에 NULL이 입력되는 버그로 인한 이슈
NOT NULL
인 INDATE컬럼에 NULL을 삽입 시 CURRENT_TIMESTAMP
가 입력됨.When explicit_defaults_for_timestamp was disabled and a NULL was inserted into a generated column declared as TIMESTAMP NOT NULL, the server would attempt to convert the inserted value to CURRENT_TIMESTAMP. Such an insertion is now rejected with ER_BAD_NULL_ERROR. (Bug #29449518)