select error

[tanyp588]

Error querying database. Cause: java.sql.SQLException: Incorrect arguments to mysqld_stmt_execute
The error may exist in URL [jar:file:/data/tomcatapps/hfhhxwyy-adminweb-1.0.0.jar!/BOOT-INF/lib/admin-service-1.0.0.jar!/mapper/base/UserInfoMapper.xml]
The error may involve defaultParameterMap
The error occurred while setting parameters
SQL: SELECT count(0) FROM t_user_info ui LEFT JOIN sys_dept sd ON ui.dept_id = sd.dept_id AND sd.tenant_id = 166 LEFT JOIN t_user_type ut ON ui.user_type_id = ut.id AND ut.tenant_id = 166 LEFT JOIN t_user_major um ON ui.user_major_id = um.id AND um.tenant_id = 166 LEFT JOIN t_user_subject us ON ui.user_subject_id = us.id AND us.tenant_id = 166 LEFT JOIN (SELECT DISTINCT (user_info_id) FROM t_user_info_register WHERE tenant_id = 166) uir ON ui.id = uir.user_info_id LEFT JOIN (SELECT DISTINCT (user_info_id) FROM t_user_info_register WHERE register_info_id = ? AND tenant_id = 166) uirs ON ui.id = uirs.user_info_id WHERE ui.audit_status = '1' AND ui.tenant_id = 166
Cause: java.sql.SQLException: Incorrect arguments to mysqld_stmt_execute

; uncategorized SQLException; SQL state [HY000]; error code [1210]; Incorrect arguments to mysqld_stmt_execute; nested exception is java.sql.SQLException: Incorrect arguments to mysqld_stmt_execute

[harawata]

Hello @tanyp588 ,

To investigate, we need to reproduce the problem first.
Please create a demo project that reproduces the exception with a minimum set of classes/tables/columns and share it on your GitHub repo.
Here are some project templates and examples.