springboot项目报错net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "if" "IF"
net.sf.jsqlparser.parser.ParseException报错日志
错误和修改后的代码
错误的原因因为我在if中继续嵌套了if,虽然在数据库中运行的时候没有报错,但是在mybais中还是报错了。
//错误sql
if( water_call_record.qu_or_song = 1 , "区代理",if( water_call_record.qu_or_song = 2 , "送水点",if( water_call_record.qu_or_song = 3 , "超级管理员","未知"))) AS type,
//修改后的sql
CASE
WHEN water_call_record.qu_or_song =1 THEN '区代理'
WHEN water_call_record.qu_or_song =2 THEN '送水点'
WHEN water_call_record.qu_or_song =3 THEN '超级管理员'
ELSE '未知'
END
as type,