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 2021/01/05 07:48:11 UTC

[GitHub] [shardingsphere] ywendy opened a new issue #8892: Data desensitization how to ignore case？

ywendy opened a new issue #8892:
URL: https://github.com/apache/shardingsphere/issues/8892


   ![image](https://user-images.githubusercontent.com/9620710/103619723-338f7000-4f6d-11eb-9bf1-69a198c8e3f8.png)
   
   how to ignore case table name ？ when my project use 
   INSERT INTO CRM_NETWORK_ANSWER(XXXXXX)VALUES(XXXXX)


----------------------------------------------------------------
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] ywendy commented on issue #8892: Data desensitization how to ignore case？

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


   > Which version do you use?
   > You mean ShardingSphere is case-sensitive for table name?
   yes ， my project has more sql ，but some sql use capital letter for table，some sql use lowercase letter for table ，when i config with upper ， it would report some error ！ I use v4.0.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] ywendy edited a comment on issue #8892: Data desensitization how to ignore case？

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


   > Which version do you use?
   > You mean ShardingSphere is case-sensitive for table name?
   yes ， my project has more sql ，but some sql use capital letter for table，some sql use lowercase letter for table ，when i config with upper ， it would report some error ！ I use v4.0.1
   @tristaZero 


----------------------------------------------------------------
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] RelaxBin commented on issue #8892: Data desensitization how to ignore case？

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


   Yes, in lower case, it work well


-- 
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] ywendy edited a comment on issue #8892: Data desensitization how to ignore case？

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


   > Which version do you use?
   > You mean ShardingSphere is case-sensitive for table name?
   
   yes ， my project has more sql ，but some sql use capital letter for table，some sql use lowercase letter for table ，when i config with upper ， it would report some error ！ I use v4.0.1
   @tristaZero 


----------------------------------------------------------------
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] sandynz closed issue #8892: Data desensitization how to ignore case？

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


   


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

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

[GitHub] [shardingsphere] RelaxBin commented on issue #8892: Data desensitization how to ignore case？

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


   > Hi @RelaxBin ,
   > 
   > What if `STUDENT_INFO` is lower-case? Does it work well?
   
   Yes, in lower case, it work well


-- 
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 #8892: Data desensitization how to ignore case？

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


   Hi @RelaxBin ,
   
   What if `STUDENT_INFO` is lower-case? Does it work well?


-- 
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 #8892: Data desensitization how to ignore case？

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


   Which version do you use? 
   You mean ShardingSphere is case-sensitive for table name?


----------------------------------------------------------------
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] xzbamiss commented on issue #8892: Data desensitization how to ignore case？

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


   I met the same problem as you。When the table name is in upper case，an exception will be reported。 eg: 'Cause: org.apache.shardingsphere.infra.exception.ShardingSphereException: Can not route tables for `[STUDENT_INFO]`, please make sure the tables are in same schema.'


-- 
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] RelaxBin removed a comment on issue #8892: Data desensitization how to ignore case？

Posted by GitBox <gi...@apache.org>.
RelaxBin removed a comment on issue #8892:
URL: https://github.com/apache/shardingsphere/issues/8892#issuecomment-814044441


   Yes, in lower case, it work well


-- 
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 #8892: Data desensitization how to ignore case？

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


   @JiekerTime Please give a look and test at this one.


-- 
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] JiekerTime commented on issue #8892: Data desensitization how to ignore case？

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


   Hi @RelaxBin @ywendy ! Your findings are very valuable!
   According to the rules of the source code, the table name configured by the encrypt rule must be the same as the case of the table name in SQL.This is because we maintain the encrypt rules through a map：
   ![image](https://user-images.githubusercontent.com/76552510/113852105-c50db880-97ce-11eb-8ffb-25a4c5f8b0ad.png)
   If you need to use this feature, please temporarily abide by this rule.
   We may consider optimizing this in the future.


-- 
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] xzbamiss edited a comment on issue #8892: Data desensitization how to ignore case？

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


   I met the same problem as you。When the table name is in upper case，an exception will be reported。 eg: 'Cause: org.apache.shardingsphere.infra.exception.ShardingSphereException: Can not route tables for `[STUDENT_INFO]`, please make sure the tables are in same schema.'       the version is 5.x


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