strongduanmu opened a new issue #13948:
URL: https://github.com/apache/shardingsphere/issues/13948
## Bug Report
### Which version of ShardingSphere did you use?
5.0.0 version or master branch
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-Proxy.
Connecting to the proxy directly through cli will not cause an exception,
but using java or go programs to connect to the proxy will cause an exception.
### Expected behavior
Execute single table query successfully.
### Actual behavior
```
Exception in thread "main" java.sql.SQLException: Unknown exception:
[java.math.BigInteger cannot be cast to java.lang.Long]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:871)
at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1999)
at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:3403)
at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:471)
at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:3115)
at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:2344)
at
com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1373)
at
com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:788)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2011)
at
com.strongduanmu.proxy.ShardingProxyJdbcTest.testSelect(ShardingProxyJdbcTest.java:148)
at
com.strongduanmu.proxy.ShardingProxyJdbcTest.main(ShardingProxyJdbcTest.java:24)
```
### Reason analyze (If you can)
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule
configuration, when exception occur etc.
Configure a sharding rule, and then execute the following statement to
create a single table.
```sql
create table t_single(id int(11) unsigned, order_id bigint(20) unsinged) ;
insert into t_single(id, order_id) values(1, 1), (2, 2);
```
### Example codes for reproduce this issue (such as a github link).
--
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]
