You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "vwater (via GitHub)" <gi...@apache.org> on 2024/02/27 12:31:58 UTC
[I] When querying multiple tables, the custom database and table sharding algorithm fails, but it takes effect when querying a single table. [shardingsphere]
vwater opened a new issue, #30320:
URL: https://github.com/apache/shardingsphere/issues/30320
<!-- 多数据源 -->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>dynamic-datasource-spring-boot-starter</artifactId>
<version>3.4.1</version>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.4.3.4</version>
</dependency>
<!-- sharding-sphere -->
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>shardingsphere-jdbc-core-spring-boot-starter</artifactId>
<version>5.2.1</version>
<exclusions>
<exclusion>
<artifactId>guava</artifactId>
<groupId>com.google.guava</groupId>
</exclusion>
<exclusion>
<artifactId>snakeyaml</artifactId>
<groupId>org.yaml</groupId>
</exclusion>
</exclusions>
</dependency>





--
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
Re: [I] When querying multiple tables, the custom database and table sharding algorithm fails, but it takes effect when querying a single table. [shardingsphere]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #30320:
URL: https://github.com/apache/shardingsphere/issues/30320#issuecomment-2027686685
There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.
--
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] When querying multiple tables, the custom database and table sharding algorithm fails, but it takes effect when querying a single table. [shardingsphere]
Posted by "vwater (via GitHub)" <gi...@apache.org>.
vwater commented on issue #30320:
URL: https://github.com/apache/shardingsphere/issues/30320#issuecomment-1966710407
Here is my demo, https://github.com/vwater/sharding-learn.git
I found that when sharding is combined with mybatisplus mybatisPlusTenantInterceptor, even if the code reaches the custom database sharding algorithm and custom table sharding algorithm, it will eventually perform a full database scan and a full table scan, causing the custom database sharding algorithm to fail.

--
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] When querying multiple tables, the custom database and table sharding algorithm fails, but it takes effect when querying a single table. [shardingsphere]
Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu commented on issue #30320:
URL: https://github.com/apache/shardingsphere/issues/30320#issuecomment-2230951276
`shardingsphere-jdbc-core-spring-boot-starter` is deprecated and removed in 5.3.0, please try new version and use ShardingSphere Driver.
--
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] When querying multiple tables, the custom database and table sharding algorithm fails, but it takes effect when querying a single table. [shardingsphere]
Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu closed issue #30320: When querying multiple tables, the custom database and table sharding algorithm fails, but it takes effect when querying a single table.
URL: https://github.com/apache/shardingsphere/issues/30320
--
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