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 2021/11/29 08:27:42 UTC
[GitHub] [shardingsphere] qiuweilu opened a new issue #13846: Bug when specifying data table
qiuweilu opened a new issue #13846:
URL: https://github.com/apache/shardingsphere/issues/13846
## Bug Report
version
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>shardingsphere-jdbc-core-spring-boot-starter</artifactId>
<version>5.0.0</version>
</dependency>
question
example
SELECT user_share.*, act_stats.*, user_info.info_nickname, user_info.info_photo, user_info.info_gender
FROM user_share
INNER JOIN act_stats_${tabIndex} act_stats ON user_share.share_id = act_stats.bind_fkid
INNER JOIN user_info ON user_info.user_id = user_share.user_id
WHERE user_share.user_id = #{userId,jdbcType=BIGINT} AND share_del = 0
ORDER BY share_id DESC
describe
In 4.1.1, I can use “act_stats_${tabIndex}” assign table index，and it works ok. Now, it can't work, i print sql is right, but act_stats's data can't return.
--
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] qiuweilu commented on issue #13846: Bug when specifying data table
Posted by GitBox <gi...@apache.org>.
qiuweilu commented on issue #13846:
URL: https://github.com/apache/shardingsphere/issues/13846#issuecomment-983246410
describe
act_stats,act_stats_0,act_stats_1 ... act_stats_10，the foreign key of the sub table is is fk_id，but sometimes I want assign a fixed table, when I do this and it can't work.
--
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] terrymanu commented on issue #13846: Bug when specifying data table
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #13846:
URL: https://github.com/apache/shardingsphere/issues/13846#issuecomment-991854578
There are no enough information, I just close the issue.
--
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] zjcnb commented on issue #13846: Bug when specifying data table
Posted by GitBox <gi...@apache.org>.
zjcnb commented on issue #13846:
URL: https://github.com/apache/shardingsphere/issues/13846#issuecomment-982455023
@qiuweilu Can you provider a demo project? We will check it.
--
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] terrymanu closed issue #13846: Bug when specifying data table
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #13846:
URL: https://github.com/apache/shardingsphere/issues/13846
--
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