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 2020/12/15 08:32:58 UTC

[GitHub] [shardingsphere] duzhanfei commented on issue #8621: 【shardingproxy5.0.0】Can not route tables for `[PSNL_POTN_CUST_CNTWY]`, please make sure the tables are in same schema

duzhanfei commented on issue #8621:
URL: https://github.com/apache/shardingsphere/issues/8621#issuecomment-745136842


   ①  when the talbe name is PSNL_POTN_CUST_CNTWY  ,   
   tips in navicat showed as below  
   0002 - 2Unknown exception: [Can not route tables for `[PSNL_POTN_CUST_CNTWY]`, please make sure the tables are in same schema.
   
   ②when the talbe name is psnl_potn_cust_cntwy  , 
   The above error message will not appear in navicat ,
   but we can know that the route for the  table is incorrect: the default database is ds_0 , but   the routed database  for psnl_potn_cust_cntwy   is  ds_3
   <img width="761" alt="图片3" src="https://user-images.githubusercontent.com/46663706/102190549-2691da80-3ef3-11eb-8d8f-c2a2cb97ada9.png">
   
   
   by the way, 
   Are there any requirements for case in SQL statements when using proxy?
   Is the default database configured correctly?
   


----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org