Need to remove constraints from the test table ddl script that I gave you first. And I think the table name needs to be changed too. CREATE TABLE `bjh`.`test` ( `MSHP_ID` varchar(16) NOT NULL , `STR_CD` varchar(7) NOT NULL , `SAVE_PNT` decimal(15,3) DEFAULT NULL , `USE_PNT` decimal(15,3) DEFAULT NULL , `REST_PNT` decimal(15,3) DEFAULT NULL , `BAL_PNT` decimal(15,3) DEFAULT NULL , `TRF_PNT` decimal(15,3) DEFAULT 0.000 , `LAST_TRAN_TP` varchar(1) DEFAULT NULL , `LAST_TRAN_DT` varchar(8) DEFAULT NULL , `LAST_CBIL_PBC_DT` varchar(8) DEFAULT NULL , `LAST_CREDIT_TRAN_DT` varchar(8) DEFAULT NULL , `JOIN_PNT_SUPY_YN` varchar(1) DEFAULT '0' , `APP_JOIN_PNT_SUPY_YN` varchar(1) DEFAULT '0', `ADD_JOIN_PNT_SUPY_YN` varchar(1) DEFAULT '0' , `REMK` varchar(400) DEFAULT NULL , `REG_DTM` varchar(25) DEFAULT NULL , `REG_EMP_ID` varchar(20) DEFAULT NULL , `MOD_DTM` varchar(25) DEFAULT NULL , `MOD_EMP_ID` varchar(20) DEFAULT NULL , `IP` varchar(30) DEFAULT NULL COMMENT , PRIMARY KEY (`MSHP_ID`,`STR_CD`), CONSTRAINT `CHK_RESTPNT_RANGE` CHECK (abs(`REST_PNT`) < 1000000000) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/2069980 Title: The insert trigger does not work while performing pt-osc. To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/percona-toolkit/+bug/2069980/+subscriptions -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
