woshiluoshao commented on issue #23511: URL: https://github.com/apache/shardingsphere/issues/23511#issuecomment-1381260576
> If you want to use the logical database name of ShardingSphere, please add readwrite_ds in front of all tables. zhsq is an object inside Oracle, please do not specify it in SQL, because ShardingSphere cannot know what it is. > > You can try > > ```sql > SELECT count(1) FROM readwrite_ds.T_TEMPLATE_CFG T JOIN readwrite_ds.t_dc_org_entity_info B ON T.org_code = B.org_code WHERE T.IS_VALID = '1' > ``` > > Or > > ```sql > SELECT count(1) FROM T_TEMPLATE_CFG T JOIN t_dc_org_entity_info B ON T.org_code = B.org_code WHERE T.IS_VALID = '1' > ``` this method uneffect , has exception unkonwdatasource -- 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]
