Bug Report

Which version of ShardingSphere did you use?

5.5.1

Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?

proxy

Expected behavior

select success

Actual behavior

Class MySQLComStmtExecuteExecutor throws NullPointerException

Reason analyze (If you can)

For some prepared query SQL statements with limit condition, class PaginationContext will throw a ClassCastException when init creating, causing the query fail, and the final manifestation is that class MySQLComStmtExecuteExecutor throws a NullPointerException

Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.

1、use Golang to execute the SQL statement

2、sql statement example：
select id, content from test_table where version=? and create_time>? order by create_time desc limit ?, ?

Example codes for reproduce this issue (such as a github link).

Class:PaginationContext
the obj is instanceof byte[], if it is forcefully converted to int, a ClassCastException will be thrown