<p dir="auto">When I execute the following SQL in the apache-shardingsphere-5.0.0-RC1-SNAPSHOT-shardingsphere-proxy-bin, the following error is reported：<br>
select product_id, apply_id from coupon_activity_map     inner join coupon_products_map  on coupon_activity_map.coupon_apply_id = coupon_products_map.apply_id             where product_id in (1900080401,100022,20468821) and coupon_activity_map.activity_end_date &gt; '2021-08-03 10:39:11';</p>
<p dir="auto">ERROR 1815 (HY000): Internal error: exception while executing query: class java.sql.Timestamp cannot be cast to class java.lang.Long (java.sql.Timestamp is in module java.sql of loader 'platform'; java.lang.Long is in module java.base of loader 'bootstrap')</p>
<p dir="auto">the proxy logs as follows:<br>
Caused by: java.lang.ClassCastException: class java.sql.Timestamp cannot be cast to class java.lang.Long (java.sql.Timestamp is in module java.sql of loader 'platform'; java.lang.Long is in module java.base of loader 'bootstrap')<br>
at Buzz.execute(Unknown Source)<br>
at Buzz.execute(Unknown Source)<br>
at org.apache.calcite.interpreter.TableScanNode.lambda$createEnumerable$1(TableScanNode.java:270)<br>
at org.apache.calcite.linq4j.EnumerableDefaults$28.moveNext(EnumerableDefaults.java:3667)<br>
at org.apache.calcite.linq4j.TransformedEnumerator.moveNext(TransformedEnumerator.java:35)<br>
at org.apache.calcite.linq4j.EnumerableDefaults.toLookup_(EnumerableDefaults.java:3563)<br>
at org.apache.calcite.linq4j.EnumerableDefaults$14.enumerator(EnumerableDefaults.java:2621)<br>
at org.apache.calcite.linq4j.EnumerableDefaults$MergeJoinEnumerator.getLeftEnumerator(EnumerableDefaults.java:4137)<br>
at org.apache.calcite.linq4j.EnumerableDefaults$MergeJoinEnumerator.leftMoveNext(EnumerableDefaults.java:4153)<br>
at org.apache.calcite.linq4j.EnumerableDefaults$MergeJoinEnumerator.start(EnumerableDefaults.java:4174)<br>
at org.apache.calcite.linq4j.EnumerableDefaults$MergeJoinEnumerator.(EnumerableDefaults.java:4132)<br>
at org.apache.calcite.linq4j.EnumerableDefaults$13.enumerator(EnumerableDefaults.java:2187)<br>
at Baz$7$1.(Unknown Source)<br>
at Baz$7.enumerator(Unknown Source)<br>
at org.apache.calcite.linq4j.AbstractEnumerable.iterator(AbstractEnumerable.java:33)<br>
at org.apache.calcite.avatica.MetaImpl.createCursor(MetaImpl.java:90)<br>
at org.apache.calcite.avatica.AvaticaResultSet.execute(AvaticaResultSet.java:184)<br>
at org.apache.calcite.jdbc.CalciteResultSet.execute(CalciteResultSet.java:64)<br>
at org.apache.calcite.jdbc.CalciteResultSet.execute(CalciteResultSet.java:43)<br>
at org.apache.calcite.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:573)<br>
... 16 common frames omitted</p>
<h2 dir="auto">Bug Report</h2>
<h3 dir="auto">Which version of ShardingSphere did you use?</h3>
<p dir="auto">master</p>
<h3 dir="auto">Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?</h3>
<p dir="auto">Proxy</p>
<h3 dir="auto">Actual behavior</h3>
<p dir="auto">When using server PreparedStatement to execute TCL, the transaction state in <code class="notranslate">BackendConnection</code> is incorrect.</p>