mybatis / mybatis-3

MyBatis SQL mapper framework for Java
http://mybatis.github.io/mybatis-3/
Apache License 2.0
19.76k stars 12.85k forks source link

select error #3061

Open tanyp588 opened 9 months ago

tanyp588 commented 9 months ago

8TG6ECIIBJ3T(KCO7JM67_5 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 commented 9 months ago

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.