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/02/01 09:59:06 UTC

[GitHub] [shardingsphere] 414135289 opened a new issue #9255: encrypt-rule does not support "not in" conditional column

414135289 opened a new issue #9255:
URL: https://github.com/apache/shardingsphere/issues/9255


   version 4.0.0
   
   When I used encrypt-rule for data encryption, I found a problem.When I use the not in condition to query the encrypted column, the component will not automatically encrypt the query field. From the source code,I found that there is no "not in" query condition in the SQLStatement object returned by the parse method of the SQLParserEngine class.
   
   For example：
   
       @Test
       public void notInTest(){
           String sql = "select * from a where a.a not in ('1','2') and a.b in ('11','22')";
           SQLParserEngine result = new SQLParserEngine("MySQL");
           SQLStatement statement = result.parse(sql,false);
       }
   
   ![image](https://user-images.githubusercontent.com/16203942/106443038-0031f980-64b7-11eb-817b-51d4b89a1526.png)
   
   So I want to know if this is a bug?


----------------------------------------------------------------
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 #9255: encrypt-rule does not support "not in" conditional column

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


   Hi @414135289 ，
   
   > I found that there is no "not in" query condition in the SQLStatement object 
   
   You're right, Ver 4.0.0 does not support the query with `not in` condition. 
   
   Hi @jingshanglu Do we parse `not in` condition into `SQLstatement` in our 5.0.0-alpha Version?


----------------------------------------------------------------
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] 414135289 closed issue #9255: encrypt-rule does not support "not in" conditional column

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


   


----------------------------------------------------------------
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] 414135289 commented on issue #9255: encrypt-rule does not support "not in" conditional column

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


   thanks


----------------------------------------------------------------
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] 414135289 closed issue #9255: encrypt-rule does not support "not in" conditional column

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


   


----------------------------------------------------------------
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 #9255: encrypt-rule does not support "not in" conditional column

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


   Hi @414135289 ，
   
   > I found that there is no "not in" query condition in the SQLStatement object 
   
   You're right, Ver 4.0.0 does not support the query with `not in` condition. 
   
   Hi @jingshanglu Do we parse `not in` condition into `SQLstatement` in our 5.0.0-alpha Version?


----------------------------------------------------------------
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] jingshanglu commented on issue #9255: encrypt-rule does not support "not in" conditional column

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


   @414135289 @tristaZero It's already supported in version 5.0.0-alpha.


----------------------------------------------------------------
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] 414135289 commented on issue #9255: encrypt-rule does not support "not in" conditional column

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


   thanks


----------------------------------------------------------------
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] jingshanglu commented on issue #9255: encrypt-rule does not support "not in" conditional column

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


   @414135289 @tristaZero It's already supported in version 5.0.0-alpha.


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