jpenalver10 opened a new issue, #37581:
URL: https://github.com/apache/shardingsphere/issues/37581
Hi, I've a questions regarding the SINGLE table configuration, that are not
clear for me reading the documentation and making tests.
Regarding this configuration (using PostgreSQL):
```
rules:
- !SINGLE
tables:
- main.outbox_dm_tables.*
- main.db_sharding.*
- main.non-existing
defaultDataSource: main
```
I want to do some questions about the definition format of tables:
- main.outbox_dm_tables.* this would means "All tables from outbox_dm_tables
schema goes to main shard"?
- main.db_sharding.sharding_tenant_config this would means "Only the table
sharding_tenant_config from db_sharding schema goes to main shard"?
- As I know, the SINGLE rules are the default beahviour for all tables that
are not defined in other ways (not SHARDING etc) and I have defined a default
data source. It means that all tables in another schema (suppose
infrastructure) will be routing by default to main shard? In my config this
happens when I add this rule main.non-existing that is intentionally incorrect,
so all tables in a infrastructure schema are routing to default, but if I
removed the tablas can't be located by ShardingSphere.
--
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]
