zuoyedalaohu opened a new issue #10300: URL: https://github.com/apache/shardingsphere/issues/10300
[c.x.c.o.c.d.m.c.extOper.OpCustomMapper.getCustList.debug:143] ==> Preparing: SELECT concat(tab.cust_type,tab.cust_no) as id,tab.cust_no,tab.ub_cust_no,tab.cust_name, tab.cust_type,tab.salesman_code,tab.salesman_name,tab.salesman_dept_no, tab.salesman_dept_name,ifnull(tab.link_telphone,'') link_telphone,ifnull(tab.link_person,'') link_person,tab.if_limit, tab.limit_no,IFNULL(lmt.available_limit_amt,0) available_limit_amt,tab.belong_company, tab.state,tab.open_bank,tab.account_no from ( SELECT ci.cust_no, ci.ub_cust_no, ci.cust_name, 'JZ' AS cust_type, ci.salesman_code, ci.salesman_name, ci.salesman_dept_no, ci.salesman_dept_name, ci.link_telphone, ci.link_person, ci.if_limit, ci.limit_no, ci.belong_company, ci.mnemonic_code, ci.state, null as open_bank, null as account_no FROM op_deco_comp_info ci WHERE 1 = 1 and ci.belong_company in ( ? ) AND ci.state = ? UNION ALL SELECT si.cust_no, si.ub_cust_no, si.cust_name, 'GY' AS cust_type, si.salesman_code as salesman_code, si.salesman_n ame as salesman_name, si.salesman_dept_no as salesman_dept_no, si.salesman_dept_name as salesman_dept_name, si.link_telphone, si.link_person, '' as if_limit, '' as limit_no, si.belong_company, si.mnemonic_code, si.state, '' as open_bank, '' as account_no FROM op_supplier_info si WHERE 1 = 1 and si.belong_company in ( ? ) AND si.state = ? UNION ALL SELECT ti.cust_no, ti.ub_cust_no, ti.cust_name, 'YS' AS cust_type, '' as salesman_code, '' as salesman_name, '' as salesman_dept_no, '' as salesman_dept_name, ti.link_telephone as link_telphone, '' as link_person, '' as if_limit, '' as limit_no, ti.belong_company, ti.mnemonic_code, ti.state, ti.open_bank as open_bank, ti.account_no as account_no FROM op_transporter_info ti WHERE 1 = 1 and ti.belong_company in ( ? ) AND ti.state = ? UNION ALL SELECT ci.custom_no as cust_no, cr.ub_cust_no, ci.custom_name as cust_name, 'GR' AS cust_type, cr.salesman_code, cr.salesman_name, cr.salesman_dept_no, cr.salesman_dept_name, ci.telephone as link_telph one, ci.custom_name as link_person, cr.if_limit, cr.limit_no, cr.belong_company, ci.mnemonic_code, cr.state, '' as open_bank, '' as account_no FROM oper_custom_info ci,oper_custom_right cr WHERE 1 = 1 and ci.custom_no = cr.custom_no and cr.belong_company in ( ? ) AND cr.state = ? ) tab LEFT JOIN op_limit_info lmt ON tab.limit_no = lmt.limit_no where 1=1 limit ? , ? [c.x.c.o.c.d.m.c.extOper.OpCustomMapper.getCustList.debug:143] ==> Parameters: D00193(String), 1(String), D00193(String), 1(String), D00193(String), 1(String), D00193(String), 1(String), 0(Integer), 20(Integer) Caused by: java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Integer at org.apache.shardingsphere.sql.parser.binder.segment.select.pagination.PaginationContext.getValue(PaginationContext.java:57) at org.apache.shardingsphere.sql.parser.binder.segment.select.pagination.PaginationContext.<init>(PaginationContext.java:50) at org.apache.shardingsphere.sql.parser.binder.segment.select.pagination.engine.LimitPaginationContextEngine.createPaginationContext(LimitPaginationContextEngine.java:38) at org.apache.shardingsphere.sql.parser.binder.segment.select.pagination.engine.PaginationContextEngine.createPaginationContext(PaginationContextEngine.java:48) at org.apache.shardingsphere.sql.parser.binder.statement.dml.SelectStatementContext.<init>(SelectStatementContext.java:100) at org.apache.shardingsphere.sql.parser.binder.SQLStatementContextFactory.getDMLStatementContext(SQLStatementContextFactory.java:103) at org.apache.shardingsphere.sql.parser.binder.SQLStatementContextFactory.newInstance(SQLStatementContextFactory.java:87) at org.apache.shardingsphere.underlying.route.DataNodeRouter.createRouteContext(DataNodeRouter.java:99) at org.apache.shardingsphere.underlying.route.DataNodeRouter.executeRoute(DataNodeRouter.java:89) at org.apache.shardingsphere.underlying.route.DataNodeRouter.route(DataNodeRouter.java:76) at org.apache.shardingsphere.underlying.pluggble.prepare.PreparedQueryPrepareEngine.route(PreparedQueryPrepareEngine.java:54) at org.apache.shardingsphere.underlying.pluggble.prepare.BasePrepareEngine.executeRoute(BasePrepareEngine.java:96) at org.apache.shardingsphere.underlying.pluggble.prepare.BasePrepareEngine.prepare(BasePrepareEngine.java:83) at org.apache.shardingsphere.shardingjdbc.jdbc.core.statement.ShardingPreparedStatement.prepare(ShardingPreparedStatement.java:183) at org.apache.shardingsphere.shardingjdbc.jdbc.core.statement.ShardingPreparedStatement.execute(ShardingPreparedStatement.java:143) at sun.reflect.GeneratedMethodAccessor207.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59) at com.sun.proxy.$Proxy317.execute(Unknown Source) at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) at org.apache.ibatis.executor.ReuseExecutor.doQuery(ReuseExecutor.java:60) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83) at sun.reflect.GeneratedMethodAccessor203.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63) at com.sun.proxy.$Proxy315.query(Unknown Source) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) ... 86 common frames omitted -- 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. For queries about this service, please contact Infrastructure at: us...@infra.apache.org