[GitHub] [shardingsphere] tristaZero commented on issue #7763: sql rewrite not work for select ... where cipherColumn is null

[GitBox <gi...@apache.org>]

tristaZero commented on issue #7763:
URL: https://github.com/apache/shardingsphere/issues/7763#issuecomment-707460950


   Hi @liuchaoheliang I supposed we fixed this bug on the master branch.
   ```
    Logic SQL: select * from t_encrypt where user_id is null
   [INFO ] 11:23:25.331 [ShardingSphere-Command-2] ShardingSphere-SQL - SQLStatement: org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dml.MySQLSelectStatement@3c0023c7
   [INFO ] 11:23:25.331 [ShardingSphere-Command-2] ShardingSphere-SQL - Actual SQL: dataSource ::: select *  from t_encrypt where user_cipher is null
   ```
   ```yaml
   rules:
   - !ENCRYPT
     encryptors:
       aes_encryptor:
         type: AES
         props:
           aes-key-value: 123456abc
       md5_encryptor:
         type: MD5
     tables:
       t_encrypt:
         columns:
           user_id:
             plainColumn: user_plain
             cipherColumn: user_cipher
             encryptorName: aes_encryptor
           order_id:
             cipherColumn: order_cipher
             encryptorName: md5_encryptor
   ```


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