<h2 dir="auto">Bug Report</h2>
<p dir="auto"><strong>For English only</strong>, other languages will not accept.</p>
<p dir="auto">Before report a bug, make sure you have:</p>
<ul dir="auto">
<li>Searched open and closed <a href="https://github.com/apache/incubator-shardingsphere/issues">GitHub issues</a>.</li>
<li>Read documentation: <a href="https://shardingsphere.apache.org/document/current/en/overview" rel="nofollow">ShardingSphere Doc</a>.</li>
</ul>
<p dir="auto">Please pay attention on issues you submitted, because we maybe need more details.<br>
If no response <strong>more than 7 days</strong> and we cannot reproduce it on current information, we will <strong>close it</strong>.</p>
<p dir="auto">Please answer these questions before submitting your issue. Thanks!</p>
<h3 dir="auto">Which version of ShardingSphere did you use?</h3>
<p dir="auto">4.0.0-RC2</p>
<h3 dir="auto">Which project did you use? Sharding-JDBC or Sharding-Proxy?</h3>
<p dir="auto">Sharding-JDBC</p>
<h3 dir="auto">Expected behavior</h3>
<p dir="auto">the query result is decrypt</p>
<h3 dir="auto">Actual behavior</h3>
<p dir="auto">the query result is still encrypt</p>
<h3 dir="auto">Reason analyze (If you can)</h3>
<p dir="auto">thie query result not use the encryptRule to decrypt</p>
<h3 dir="auto">Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.</h3>
<p dir="auto">spring:<br>
shardingsphere:<br>
datasource:<br>
names: master,slave0<br>
master:<br>
type: com.alibaba.druid.pool.DruidDataSource<br>
driver-class-name: org.h2.Driver<br>
url: jdbc:h2:mem:dbtest:public;DB_CLOSE_DELAY=-1;MODE=MySQL<br>
slave0:<br>
type: com.alibaba.druid.pool.DruidDataSource<br>
driver-class-name: org.h2.Driver<br>
url: jdbc:h2:mem:dbtest:public;DB_CLOSE_DELAY=-1;MODE=MySQL<br>
sharding:<br>
defaultDataSourceName: dataSource<br>
master-slave-rules:<br>
dataSource:<br>
master-data-source-name: master<br>
slave-data-source-names[0]: slave0<br>
load-balance-algorithm-type: ROUND_ROBIN<br>
encryptRule:<br>
encryptors:<br>
encryptor_aes:<br>
type: AES<br>
props:<br>
aes.key.value: 123456<br>
tables:<br>
company:<br>
columns:<br>
address:<br>
cipherColumn: address<br>
encryptor: encryptor_aes<br>
full_name:<br>
cipherColumn: full_name<br>
encryptor: encryptor_aes<br>
props:<br>
sql.show: true</p>
<h3 dir="auto">Example codes for reproduce this issue (such as a github link).</h3>
<p dir="auto">the profile as below:</p>
<p dir="auto">spring:<br>
  shardingsphere:<br>
    props:<br>
      sql.show: true<br>
      query.with.cipher.comlum: true<br>
    datasource:<br>
      name: ds0<br>
      ds0:<br>
        type: org.apache.commons.dbcp.BasicDataSource</p>
<p dir="auto">        driver-class-name: com.mysql.cj.jdbc.Driver</p>
<p dir="auto">        url: jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&amp;characterEncoding=utf-8&amp;serverTimezone=UTC</p>
<p dir="auto">        username: root</p>
<p dir="auto">        password: root</p>
<p dir="auto">        max-total: 100<br>
    sharding:<br>
      tables:<br>
        user:<br>
          actual-data-nodes: ds0.user_$-&gt;{0..4}<br>
          table-strategy:<br>
            inline:<br>
              sharding-column: id<br>
              algorithm-expression: user_$-&gt;{id % 5}<br>
    encrypt:<br>
      encryptors:<br>
        encryptor_aes:<br>
          type: aes<br>
          props.aes.key.value: 123456<br>
      tables:<br>
        user:<br>
          columns:<br>
            name:<br>
              cipherColumn: name<br>
              encryptor: encryptor_aes</p>