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:
[email protected]


Reply via email to