当前使用版本(必填,否则不予处理)

com.baomidou mybatis-plus-boot-starter 3.2.0

该问题是如何引起的？(确定最新版也有问题再提!!!)

数据库主键非id 使用@TableId(value = "product_id") 无用

重现步骤(如果有就写完整)

1.pom.xml com.baomidou mybatis-plus-boot-starter 3.2.0 2.application.yml mybatis-plus: configuration: map-underscore-to-camel-case: true log-impl: org.apache.ibatis.logging.stdout.StdOutImpl auto-mapping-behavior: full auto-mapping-unknown-column-behavior: warning mapper-locations: classpath:mapper//Mapper.xml global-config: # 逻辑删除配置 db-config: # 删除前 logic-not-delete-value: 1 # 删除后 logic-delete-value: 0 id-type: assign_uuid logging: level: root: info com.example: debug 3.实体类 @Data @TableName(value = "product_info") public class ProductInfo implements Serializable {

private static final long serialVersionUID = 1L;



@TableId(value = "product_id")
public String productId;

/**
 * 商品名称
 */
private String productName;

/**
 * 单价
 */
private BigDecimal productPrice;

/**
 * 库存
 */
private Integer productStock;

/**
 * 描述
 */
private String productDescription;

/**
 * 小图
 */
private String productIcon;

/**
 * 商品状态,0正常1下架
 */
private Integer productStatus;

/**
 * 类目编号
 */
private Integer categoryType;

/**
 * 创建时间
 */
private LocalDateTime createTime;

/**
 * 修改时间
 */
private LocalDateTime updateTime;

} 4.建表语句 -- 商品 create table product_info ( product_id varchar(32) not null, product_name varchar(64) not null comment '商品名称', product_price decimal(8,2) not null comment '单价', product_stock int not null comment '库存', product_description varchar(64) comment '描述', product_icon varchar(512) comment '小图', product_status tinyint(3) DEFAULT '0' COMMENT '商品状态,0正常1下架', category_type int not null comment '类目编号', create_time timestamp not null default current_timestamp comment '创建时间', update_time timestamp not null default current_timestamp on update current_timestamp comment '修改时间', primary key (product_id) ); INSERT INTO product_info (product_id, product_name, product_price, product_stock, product_description, product_icon, product_status, category_type, create_time, update_time) VALUES ('157875196366160022','皮蛋粥',0.01,39,'好吃的皮蛋粥','//fuss10.elemecdn.com/0/49/65d10ef215d3c770ebb2b5ea962a7jpeg.jpeg',0,1,'2017-03-28 19:39:15','2017-07-02 11:45:44'), ('157875227953464068','慕斯蛋糕',10.90,200,'美味爽口','//fuss10.elemecdn.com/9/93/91994e8456818dfe7b0bd95f10a50jpeg.jpeg',1,1,'2017-03-28 19:35:54','2017-04-21 10:05:57'), ('164103465734242707','蜜汁鸡翅',0.02,982,'好吃','//fuss10.elemecdn.com/7/4a/f307f56216b03f067155aec8b124ejpeg.jpeg',0,1,'2017-03-30 17:11:56','2017-06-24 19:20:54');

报错信息

service调用this.getById("157875196366160022")返回 SELECT product_id,product_name,product_price,product_stock,product_description,product_icon,product_status,category_type,create_time,update_time FROM product_info WHERE null="157875196366160022"

Comment From: miemieYaho

给出git形式的demo