Angry-Rabbit opened a new issue, #17884:
URL: https://github.com/apache/shardingsphere/issues/17884
Hello~ As title said，Is there some way to set default table if sql has no
sharding column?
eg:
```
spring.shardingsphere.rules.sharding.tables.user_info.table-strategy.standard.sharding-column=created_time
```
In database has initialized many table that named with pattern
‘user_info_yyyyMM’:
user_info_202205
...
user_info_202401
According to current shardingsphere route strategy, if no sharding column in
sql will scan all availble initialized tables. For performance consideration,
So I'm wondering if there is a way to choose the default table, when a missing
sharding column field is detected. Like below sql: shardingsphere will auto
route to recently month table user_info_202204, user_info_202205;
```
select * from user_info t where t.name = 'david'
```
Thank you~
--
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]
