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

3.5.0

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

首先这是一个普通的查询,表ls_scene_strategy 原字段如下: id,strategy_no,scene_no,strategy_category,strategy_value,create_by,create_time,commodity_no,commodity_name 现有字段: id,strategy_no,scene_no,strategy_category,strategy_value,create_by,create_time.即删除了commodity_no,commodity_name两个字段,对应的entity也删除了.但是查询就报错了.

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

报错信息

"msg": "\n### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Unknown column 'commodity_no' in 'field list'\n### The error may exist in com/ruoyi/ls/mapper/LsSceneStrategyMapper.java (best guess)\n### The error may involve defaultParameterMap\n### The error occurred while setting parameters\n### SQL: SELECT id,strategy_no,scene_no,strategy_category,strategy_value,create_by,create_time,commodity_no,commodity_name FROM ls_scene_strategy\n### Cause: java.sql.SQLSyntaxErrorException: Unknown column 'commodity_no' in 'field list'\n; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column 'commodity_no' in 'field list'", "code": 500

Comment From: xiboliyadiwangxie

public class LsSceneStrategyServiceImpl extends ServiceImpl implements LsSceneStrategyService { @Override public List list(LsSceneStrategy lsSceneStrategy) { LambdaQueryWrapper queryWrapper = new QueryWrapper().lambda(); queryWrapper.eq(StringUtils.isNotEmpty(lsSceneStrategy.getSceneNo()),LsSceneStrategy::getSceneNo,lsSceneStrategy.getSceneNo()); queryWrapper.eq(StringUtils.isNotEmpty(lsSceneStrategy.getStrategyCategory()),LsSceneStrategy::getStrategyCategory,lsSceneStrategy.getStrategyCategory()); queryWrapper.eq(StringUtils.isNotEmpty(lsSceneStrategy.getStrategyNo()),LsSceneStrategy::getStrategyNo,lsSceneStrategy.getStrategyNo()); return this.list(queryWrapper); } }