当前使用版本(必填,否则不予处理)
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