You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/10/10 06:42:43 UTC
[GitHub] [shardingsphere] marker-wu opened a new issue, #13343: An error in the execution of the federation engine
marker-wu opened a new issue, #13343:
URL: https://github.com/apache/shardingsphere/issues/13343
When I executed this sql an error appeared：select * from oms_order_data a inner join oms_order_items b on a.zid =b.zid and a.zid=100161 and b.zid=100161;
here are my configuration：
Real table ddl:
--
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: notifications-unsubscribe@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #13343: An error in the execution of the federation engine
Posted by "strongduanmu (via GitHub)" <gi...@apache.org>.
strongduanmu commented on issue #13343:
URL: https://github.com/apache/shardingsphere/issues/13343#issuecomment-1519621929
Hi @marker-wu @China-Uncle, I have test this issue with master branch, I has been fixed. Can you try with the latest version 5.3.2? I think it has been fixed already.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] China-Uncle commented on issue #13343: An error in the execution of the federation engine
Posted by "China-Uncle (via GitHub)" <gi...@apache.org>.
China-Uncle commented on issue #13343:
URL: https://github.com/apache/shardingsphere/issues/13343#issuecomment-1521234315
> Hi @marker-wu @China-Uncle, I have test this issue with master branch, I has been fixed. Can you try with the latest version 5.3.2? I think it has been fixed already.
Hi, the previous problem has been fixed, now there is a new follow-up problem:
It is still a cross-database joint query
When the `id` int(11) unsigned field is used as a query condition, the parameter type needs to be Long.
Otherwise an exception will be thrown:
java.lang.Integer cannot be cast to java.lang.Long
The field of `create_time` datetime is used as the query condition, and the parameter type needs to be Timestamp.
Otherwise an exception will be thrown:
java.lang.String cannot be cast to java.lang.Long;
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] An error in the execution of the federation engine [shardingsphere]
Posted by "strongduanmu (via GitHub)" <gi...@apache.org>.
strongduanmu commented on issue #13343:
URL: https://github.com/apache/shardingsphere/issues/13343#issuecomment-1972369648
@sss534534 Maybe submitting a new issue will help solve your problem. The original problem has been solved.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] github-actions[bot] commented on issue #13343: An error in the execution of the federation engine
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #13343:
URL: https://github.com/apache/shardingsphere/issues/13343#issuecomment-1272350700
Hello , this issue has not received a reply for several days.
This issue is supposed to be closed.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu closed issue #13343: An error in the execution of the federation engine
Posted by "strongduanmu (via GitHub)" <gi...@apache.org>.
strongduanmu closed issue #13343: An error in the execution of the federation engine
URL: https://github.com/apache/shardingsphere/issues/13343
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] github-actions[bot] closed issue #13343: An error in the execution of the federation engine
Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #13343: An error in the execution of the federation engine
URL: https://github.com/apache/shardingsphere/issues/13343
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #13343: An error in the execution of the federation engine
Posted by "strongduanmu (via GitHub)" <gi...@apache.org>.
strongduanmu commented on issue #13343:
URL: https://github.com/apache/shardingsphere/issues/13343#issuecomment-1521240612
Hi @China-Uncle, can you submit a new issue to describe your exception?
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] China-Uncle commented on issue #13343: An error in the execution of the federation engine
Posted by "China-Uncle (via GitHub)" <gi...@apache.org>.
China-Uncle commented on issue #13343:
URL: https://github.com/apache/shardingsphere/issues/13343#issuecomment-1519440515
In which version was this bug fixed?
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] An error in the execution of the federation engine [shardingsphere]
Posted by "sss534534 (via GitHub)" <gi...@apache.org>.
sss534534 commented on issue #13343:
URL: https://github.com/apache/shardingsphere/issues/13343#issuecomment-1970993161
java.lang.ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long
I use data type 'bigint(20) unsigned' in mysql, and reproduce that problem again.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org