当前使用版本(必填,否则不予处理)
3.4.1
该问题是如何引起的？(确定最新版也有问题再提!!!)
使用QueryWrapper
重现步骤(如果有就写完整)
报错信息
Error querying database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) TOTAL' at line 3
The error may exist in com/yq/code/system/authorization/local/dao/MenuDao.java (best guess)
The error may involve defaultParameterMap
The error occurred while setting parameters
SQL: SELECT COUNT(*) FROM (SELECT id,parent_id,path,level,sort_index,create_time,update_time,name,remark,url,icon,status,component,permission FROM s_menu WHERE (1 = ? AND PARENT_ID = ? AND )) TOTAL
Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) TOTAL' at line 3
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) TOTAL' at line 3]
Comment From: miemieYaho
给出你的复现demo以git形式