报错场景
对若依进行Mybatis升级Mybatis-plus后，使用mybatisPlus的QueryWrapper方法，一直提醒报错 Cause: java.sql.SQLSyntaxErrorException: Unknown column ‘search_value’ in ‘field list’
但是对应实体类没有查找到这个字段。
报错信息
"msg": "\r\n### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Unknown column 'search_value' in 'field list'\r\n### The error may exist in com/ruoyi/codepunch/mapper/CpCheckInMapper.java (best guess)\r\n### The error may involve defaultParameterMap\r\n### The error occurred while setting parameters\r\n### SQL: SELECT check_in_id,user_id,group_id,check_in_date,check_in_time,search_value,create_by,create_time,update_by,update_time,remark,params FROM cp_check_in WHERE (group_id = ?) LIMIT ?\r\n### Cause: java.sql.SQLSyntaxErrorException: Unknown column 'search_value' in 'field list'\n; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column 'search_value' in 'field list'",
报错原因
自动生成的实体类继承了BaseEntity，里面有一些字段是用不上也找不着的，
searchValue，remark，params，取消继承即可。或：
对应实体类添加注解 @TableField(exist = false)