bai1986 opened a new issue #11671:
URL: https://github.com/apache/shardingsphere/issues/11671
When I execute the following SQL in the
apache-shardingsphere-5.0.0-RC1-SNAPSHOT-shardingsphere-proxy-bin, the
following error is reported：
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 >
'2021-08-03 10:39:11';
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')
the proxy logs as follows:
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')
at Buzz.execute(Unknown Source)
at Buzz.execute(Unknown Source)
at
org.apache.calcite.interpreter.TableScanNode.lambda$createEnumerable$1(TableScanNode.java:270)
at
org.apache.calcite.linq4j.EnumerableDefaults$28.moveNext(EnumerableDefaults.java:3667)
at
org.apache.calcite.linq4j.TransformedEnumerator.moveNext(TransformedEnumerator.java:35)
at
org.apache.calcite.linq4j.EnumerableDefaults.toLookup_(EnumerableDefaults.java:3563)
at
org.apache.calcite.linq4j.EnumerableDefaults$14.enumerator(EnumerableDefaults.java:2621)
at
org.apache.calcite.linq4j.EnumerableDefaults$MergeJoinEnumerator.getLeftEnumerator(EnumerableDefaults.java:4137)
at
org.apache.calcite.linq4j.EnumerableDefaults$MergeJoinEnumerator.leftMoveNext(EnumerableDefaults.java:4153)
at
org.apache.calcite.linq4j.EnumerableDefaults$MergeJoinEnumerator.start(EnumerableDefaults.java:4174)
at
org.apache.calcite.linq4j.EnumerableDefaults$MergeJoinEnumerator.<init>(EnumerableDefaults.java:4132)
at
org.apache.calcite.linq4j.EnumerableDefaults$13.enumerator(EnumerableDefaults.java:2187)
at Baz$7$1.<init>(Unknown Source)
at Baz$7.enumerator(Unknown Source)
at
org.apache.calcite.linq4j.AbstractEnumerable.iterator(AbstractEnumerable.java:33)
at org.apache.calcite.avatica.MetaImpl.createCursor(MetaImpl.java:90)
at
org.apache.calcite.avatica.AvaticaResultSet.execute(AvaticaResultSet.java:184)
at
org.apache.calcite.jdbc.CalciteResultSet.execute(CalciteResultSet.java:64)
at
org.apache.calcite.jdbc.CalciteResultSet.execute(CalciteResultSet.java:43)
at
org.apache.calcite.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:573)
... 16 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.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
