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/08/11 02:24:00 UTC

[GitHub] [shardingsphere] zhuyaoming opened a new issue #6774: Shardingkey BUG

zhuyaoming opened a new issue #6774:
URL: https://github.com/apache/shardingsphere/issues/6774


   insert sql shardingsphrere modified shard key column to lowercase
   The bug select * from A where TENANT_ID = 1 is still uppercase, which leads to inconsistent case of the shard key column obtained in case 2.
   ------------------------------
   insert sql   shardingsphrere 修改为小写的 
   bug  select * from A where TENANT_ID= 1  仍然是大写的.导致2中情况获取到的分片键列大小写不一致.
   
   INSERT INTO A(TENANT_ID) VALUES(1)   分片键为      tenant_id=1
   SELECT * FROM A WHERE TENANT_ID= 1    分片键为  TENANT_ID= 1 


----------------------------------------------------------------
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] terrymanu closed issue #6774: Shardingkey BUG

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


   


----------------------------------------------------------------
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] zhuyaoming edited a comment on issue #6774: Shardingkey BUG

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


   > Hi @zhuyaoming which version are you using?
   > Is `tenant_id ` a generated key?
   @tristaZero 
   4.1.1 
   tenant_id is not a  generated key


----------------------------------------------------------------
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] terrymanu commented on issue #6774: Shardingkey BUG

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


   Closed because of no response anymore.


----------------------------------------------------------------
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] tristaZero commented on issue #6774: Shardingkey BUG

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


   Hi @zhuyaoming Thanks for your feedback.
   1. If possible, could you debug to find where ShardingJDBC lowercase the columnName? That will help us solve this issue efficiently!
   2. If impossible, we have to take some time to locate the problem. You can firstly set `sql.show` = `true`, so that we can get the actual SQLs and logic SQLs in the log.


----------------------------------------------------------------
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] tristaZero edited a comment on issue #6774: Shardingkey BUG

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


   Hi @zhuyaoming which version are you using?
   Is `tenant_id ` a generated key?


----------------------------------------------------------------
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] tristaZero commented on issue #6774: Shardingkey BUG

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


   Hi @zhuyaoming which version are you using?
   Does `tenant_id ` is a generated key?


----------------------------------------------------------------
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] zhuyaoming commented on issue #6774: Shardingkey BUG

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


   > Hi @zhuyaoming which version are you using?
   > Is `tenant_id ` a generated key?
   
   4.1.1 
   tenant_id is not a  generated key


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