zhoubin7 commented on issue #24058: URL: https://github.com/apache/shardingsphere/issues/24058#issuecomment-1425073364
> @zhoubin7 这真是个好消息，感谢您的反馈。 > > 可能分片场景下的子查询需要开启联合查询，可以尝试配置 [sql-federation-type](https://shardingsphere.apache.org/document/current/en/user-manual/common-config/props/)。  The error occurred while setting parameters ### SQL: SELECT u.user_id, u.dept_id, u.user_name, u.nick_name, u.email, u.avatar, u.phonenumber, u.password, u.sex, u.status, u.del_flag, u.login_ip, u.login_date, u.create_by, u.create_time, u.remark, u.user_type, u.last_password_modify_time, u.tenant_id, d.dept_id, d.parent_id, d.dept_name, d.order_num, d.leader, d.status AS dept_status, d.dept_type, d.ancestors, r.role_id, r.role_name, r.role_key, r.role_sort, r.data_scope, r.status AS role_status, t.name AS tenantName, r.status AS role_status, u.project_category_id FROM sys_user u LEFT JOIN sys_dept d ON u.dept_id = d.dept_id AND d.tenant_id = -1 LEFT JOIN sys_user_role ur ON u.user_id = ur.user_id AND ur.tenant_id = -1 LEFT JOIN sys_role r ON r.role_id = ur.role_id AND r.tenant_id = -1 LEFT JOIN sys_tenant t ON u.tenant_id = t.id WHERE u.user_name = ? AND u.tenant_id = -1 ### Cause: java.sql.SQLException: exception while executing query: java.lang.Long cannot be cast to java.lang.Integer ; uncategorized SQLException; SQL state [null]; error code [0]; exception while executing query: java.lang.Long cannot be cast to java.lang.Integer; nested exception is java.sql.SQLException: exception while executing query: java.lang.Long cannot be cast to java.lang.Integer at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441) at com.sun.proxy.$Proxy165.selectOne(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:160) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:89) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89) at com.sun.proxy.$Proxy170.selectUserByUserName(Unknown Source) Caused by: java.sql.SQLException: exception while executing query: java.lang.Long cannot be cast to java.lang.Integer at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:579) at org.apache.calcite.avatica.AvaticaPreparedStatement.executeQuery(AvaticaPreparedStatement.java:137) at org.apache.shardingsphere.sqlfederation.original.OriginalSQLFederationExecutor.executeQuery(OriginalSQLFederationExecutor.java:111) at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.executeFederationQuery(ShardingSpherePreparedStatement.java:312) at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.execute(ShardingSpherePreparedStatement.java:402) at com.p6spy.engine.wrapper.PreparedStatementWrapper.execute(PreparedStatementWrapper.java:362) at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64) Caused by: java.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Integer at Baz$14.apply(Unknown Source) at Baz$14.apply(Unknown Source) at org.apache.calcite.linq4j.EnumerableDefaults.toLookup_(EnumerableDefaults.java:3604) at org.apache.calcite.linq4j.EnumerableDefaults.toLookup(EnumerableDefaults.java:3594) at org.apache.calcite.linq4j.EnumerableDefaults.toLookup(EnumerableDefaults.java:3570) at org.apache.calcite.linq4j.DefaultEnumerable.toLookup(DefaultEnumerable.java:748) @RaigorJiang Unfortunately,New problems have been discovered -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
