Comment 1 for bug 1599708

xiean@dw 11:27> show triggers; ---No Triggers and ，table structure is :
Empty set (0.00 sec)

xiean@dw 10:59> show create table fct_service_record\G
*************************** 1. row ***************************
       Table: fct_service_record
Create Table: CREATE TABLE `fct_service_record` (
  `record_id` int(11) unsigned NOT NULL COMMENT '记录单id',
  `source_no` varchar(50) DEFAULT '0' COMMENT '来源编号(live800,callcenter,意见反馈编号 唯一标识)',
  `admin_id` int(11) DEFAULT '0' COMMENT '记录单创建客服ID,dim_admin',
  `create_type` smallint(1) DEFAULT '1' COMMENT '记录单创建：1.自动创建 2.手动创建',
  `source_type` smallint(1) DEFAULT '0' COMMENT '来源类型(1.callcenter 2.live800 3.微信 4.旺旺 5.意见箱)',
  `belongs` smallint(1) DEFAULT '1' COMMENT '1.买家 2.卖家',
  `phone` char(20) DEFAULT '' COMMENT '来电电话',
  `user_id` int(11) DEFAULT '0' COMMENT '用户id',
  `user_name` varchar(64) DEFAULT NULL COMMENT '用户名称',
  `add_time` datetime DEFAULT NULL COMMENT '创建时间',
  `date_id` date NOT NULL DEFAULT '0000-00-00' COMMENT '创建日期',
  `is_event` smallint(1) NOT NULL DEFAULT '0' COMMENT '记录单是否有对应事件',
  `status` smallint(1) NOT NULL DEFAULT '1' COMMENT '记录单状态：0.删除 1.有效',
  `last_modified` datetime DEFAULT NULL COMMENT '最后修改时间，业务时间',
  `update_time` datetime DEFAULT NULL COMMENT 'etl加工时间',
  PRIMARY KEY (`record_id`,`date_id`),
  KEY `idx_admin_id` (`admin_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4 COMMENT='客服记录单表'
/*!50500 PARTITION BY RANGE COLUMNS(date_id)
(PARTITION p201412 VALUES LESS THAN ('2015-01-01') ENGINE = InnoDB,
 PARTITION p201501 VALUES LESS THAN ('2015-02-01') ENGINE = InnoDB,
 PARTITION p201502 VALUES LESS THAN ('2015-03-01') ENGINE = InnoDB,
 PARTITION p201503 VALUES LESS THAN ('2015-04-01') ENGINE = InnoDB,
 PARTITION p201504 VALUES LESS THAN ('2015-05-01') ENGINE = InnoDB,
 PARTITION p201505 VALUES LESS THAN ('2015-06-01') ENGINE = InnoDB,
 PARTITION p201506 VALUES LESS THAN ('2015-07-01') ENGINE = InnoDB,
 PARTITION p201507 VALUES LESS THAN ('2015-08-01') ENGINE = InnoDB,
 PARTITION p201508 VALUES LESS THAN ('2015-09-01') ENGINE = InnoDB,
 PARTITION p201509 VALUES LESS THAN ('2015-10-01') ENGINE = InnoDB,
 PARTITION p201510 VALUES LESS THAN ('2015-11-01') ENGINE = InnoDB,
 PARTITION p201511 VALUES LESS THAN ('2015-12-01') ENGINE = InnoDB,
 PARTITION p201512 VALUES LESS THAN ('2016-01-01') ENGINE = InnoDB,
 PARTITION p201601 VALUES LESS THAN ('2016-02-01') ENGINE = InnoDB,
 PARTITION p201602 VALUES LESS THAN ('2016-03-01') ENGINE = InnoDB,
 PARTITION p201603 VALUES LESS THAN ('2016-04-01') ENGINE = InnoDB,
 PARTITION p201604 VALUES LESS THAN ('2016-05-01') ENGINE = InnoDB,
 PARTITION p201605 VALUES LESS THAN ('2016-06-01') ENGINE = InnoDB,
 PARTITION p201606 VALUES LESS THAN ('2016-07-01') ENGINE = InnoDB,
 PARTITION p201607 VALUES LESS THAN ('2016-08-01') ENGINE = InnoDB,
 PARTITION p201608 VALUES LESS THAN ('2016-09-01') ENGINE = InnoDB,
 PARTITION p201609 VALUES LESS THAN ('2016-10-01') ENGINE = InnoDB,
 PARTITION p201610 VALUES LESS THAN ('2016-11-01') ENGINE = InnoDB,
 PARTITION p201611 VALUES LESS THAN ('2016-12-01') ENGINE = InnoDB,
 PARTITION p201612 VALUES LESS THAN ('2017-01-01') ENGINE = InnoDB) */
1 row in set (0.00 sec)