详解MyBatisPlus逻辑删除与唯一索引冲突问题

CREATE TABLE `eam_location` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `location_id` varchar(50) UNIQUE NOT NULL COMMENT '位置代码',
  `location_level` tinyint(1) NOT NULL COMMENT '位置级别',
  `location_name` varchar(50) NOT NULL COMMENT '位置名称',
  `parent_location_id` varchar(50) COMMENT '上级位置代码',
  `delete_flag` tinyint(1) DEFAULT 0 COMMENT '软删除',
  `version` int(11) DEFAULT 1 COMMENT '乐观锁',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `eam_location` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `location_id` varchar(50) NOT NULL COMMENT '位置代码',
  `location_level` tinyint(1) NOT NULL COMMENT '位置级别',
  `location_name` varchar(50) NOT NULL COMMENT '位置名称',
  `parent_location_id` varchar(50) COMMENT '上级位置代码',
  `delete_flag` datetime COMMENT '软删除',
  `version` int(11) DEFAULT 1 COMMENT '乐观锁',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_location_delete_flag`(`location_id`, `delete_flag`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

@AllArgsConstructor
@NoArgsConstructor
@Builder(toBuilder = true)
@Data
@EqualsAndHashCode(callSuper = false)
public class EamEquipmentType implements Serializable {

  private static final long serialVersionUID = 1L;

  
  @TableId(value = "id", type = IdType.AUTO)
  private Integer id;

  
  private String typeId;

  
  private String typeName;

  
  private String manufacture;

  
  private String model;

  
  private Boolean typeBom;

  
  private Integer typeBomId;

  
  private LocalDateTime createTime;

  
  @TableLogic()
  @TableField(fill = FieldFill.INSERT)
  private LocalDateTime deleteFlag;

  
  @Version
  @TableField(fill = FieldFill.INSERT)
  private Integer version;

mybatis-plus:
 global-config:
  db-config:
   logic-delete-value: "now()" #逻辑删除值是个db获取时间的函数
   logic-not-delete-value: "null" #逻辑未删除值为字符串 "null"