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/06/29 06:48:19 UTC

[GitHub] [shardingsphere] DongJigong opened a new issue #6208: sharding database strategy not work cause by SqlToken not append by string.

DongJigong opened a new issue #6208:
URL: https://github.com/apache/shardingsphere/issues/6208


   ## Bug Report
   
   **For English only**, other languages will not accept.
   
   Before report a bug, make sure you have:
   
   - Searched open and closed [GitHub issues](https://github.com/apache/shardingsphere/issues).
   - Read documentation: [ShardingSphere Doc](https://shardingsphere.apache.org/document/current/en/overview).
   
   Please pay attention on issues you submitted, because we maybe need more details. 
   If no response anymore and we cannot reproduce it on current information, we will **close it**.
   
   Please answer these questions before submitting your issue. Thanks!
   
   ### Which version of ShardingSphere did you use?
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   
   ### Expected behavior
   
   ### Actual behavior
   
   ### Reason analyze (If you can)
   
   ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
   
   ### Example codes for reproduce this issue (such as a github link).
   


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

[GitHub] [shardingsphere] DongJigong closed issue #6208: sharding database strategy not work cause by SqlToken not append by string.

Posted by GitBox <gi...@apache.org>.
DongJigong closed issue #6208:
URL: https://github.com/apache/shardingsphere/issues/6208


   


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

[GitHub] [shardingsphere] kimmking edited a comment on issue #6208: sharding database strategy not work cause by SqlToken not append by string.

Posted by GitBox <gi...@apache.org>.
kimmking edited a comment on issue #6208:
URL: https://github.com/apache/shardingsphere/issues/6208#issuecomment-651522755


   I can't reproduce this issue. @DongJigong 
   
   And in the latest version 5.x, we will force all dsXX in a same schema/table structure.
   
   BTW: this is not a supported feature.
   > I have to database with ds0 and ds3, the database ds0 configed as default database, table user belongs to ds0 but the
   table ums_claims belongs to ds3.


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

[GitHub] [shardingsphere] pengweizhong commented on issue #6208: sharding database strategy not work cause by SqlToken not append by string.

Posted by GitBox <gi...@apache.org>.
pengweizhong commented on issue #6208:
URL: https://github.com/apache/shardingsphere/issues/6208#issuecomment-651461485


   When a ‘‘Error querying database.’ exception occurs, first you need to check whether the SQL statement is queried across databases. In this case, SHARDING is not supported. For details, [please refer to the official documentation.](https://shardingsphere.apache.org/document/current/cn/features/sharding/use-norms/sql/#%E4%B8%8D%E6%94%AF%E6%8C%81%E7%9A%84sql)
   If it is not the above behavior, then check:
   
   1. Whether SQL can be run locally.
   2.  Check whether the query table name is a logical table name or a physical table name, if it is a logical table name, please check your code configuration


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

[GitHub] [shardingsphere] DongJigong edited a comment on issue #6208: sharding database strategy not work cause by SqlToken not append by string.

Posted by GitBox <gi...@apache.org>.
DongJigong edited a comment on issue #6208:
URL: https://github.com/apache/shardingsphere/issues/6208#issuecomment-650970925


       sharding:
         default-data-source-name: ds0
         tables:
           t_user:
             actual-data-nodes: ds3.t_user
   


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

[GitHub] [shardingsphere] pengweizhong commented on issue #6208: sharding database strategy not work cause by SqlToken not append by string.

Posted by GitBox <gi...@apache.org>.
pengweizhong commented on issue #6208:
URL: https://github.com/apache/shardingsphere/issues/6208#issuecomment-650996722


   I don’t quite understand what you mean. Are you saying that the sub-library and sub-table are not available? If so, please post the complete YML configuration and the sharding-jdbc version number.


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

[GitHub] [shardingsphere] DongJigong commented on issue #6208: sharding database strategy not work cause by SqlToken not append by string.

Posted by GitBox <gi...@apache.org>.
DongJigong commented on issue #6208:
URL: https://github.com/apache/shardingsphere/issues/6208#issuecomment-650970925


   ![image](https://user-images.githubusercontent.com/8855265/85982808-063f9380-ba19-11ea-8b14-b0464e03f76f.png)
   


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

[GitHub] [shardingsphere] DongJigong commented on issue #6208: sharding database strategy not work cause by SqlToken not append by string.

Posted by GitBox <gi...@apache.org>.
DongJigong commented on issue #6208:
URL: https://github.com/apache/shardingsphere/issues/6208#issuecomment-651036852


   Please help me @pengweizhong . You can review my console logs.


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

[GitHub] [shardingsphere] kimmking commented on issue #6208: sharding database strategy not work cause by SqlToken not append by string.

Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #6208:
URL: https://github.com/apache/shardingsphere/issues/6208#issuecomment-651522755


   I can't reproduce this issue. @DongJigong 


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

[GitHub] [shardingsphere] kimmking edited a comment on issue #6208: sharding database strategy not work cause by SqlToken not append by string.

Posted by GitBox <gi...@apache.org>.
kimmking edited a comment on issue #6208:
URL: https://github.com/apache/shardingsphere/issues/6208#issuecomment-651522755


   I can't reproduce this issue. @DongJigong 
   
   And in the latest version 5.x, we will force all dsXX in a same schema.
   
   BTW: this is not a supported feature.
   > I have to database with ds0 and ds3, the database ds0 configed as default database, table user belongs to ds0 but the
   table ums_claims belongs to ds3.


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

[GitHub] [shardingsphere] kimmking edited a comment on issue #6208: sharding database strategy not work cause by SqlToken not append by string.

Posted by GitBox <gi...@apache.org>.
kimmking edited a comment on issue #6208:
URL: https://github.com/apache/shardingsphere/issues/6208#issuecomment-651522755


   I can't reproduce this issue. @DongJigong 
   
   BTW: this is not a supported feature.
   > I have to database with ds0 and ds3, the database ds0 configed as default database, table user belongs to ds0 but the
   table ums_claims belongs to ds3.


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