<p dir="auto">sharding is affected when encrypt。but query  is not decrypt.<br>
and I found The problem is (SQLServerResultSetMetaData)<br>
<code class="notranslate">this.rs.getColumn(var1).getTableName().getObjectName();</code> ,this code return "",so cann't decrypt<br>
for example config:<br>
<code class="notranslate">encrypt: encryptors: encryptor_aes: type: aes props: aes.key.value: 123456 tables: users: columns: mobile: cipherColumn: mobile_cipher encryptor: encryptor_aes props: query.with.cipher.column: true sql.show: true</code></p>
<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>