<p dir="auto">version<br>
5.0.0-alpha</p>
<p dir="auto">my config<br>
spring.shardingsphere.props.query-with-cipher-column=true<br>
spring.shardingsphere.rules.encrypt.tables.user_info.columns.name.cipherColumn=name_enc<br>
spring.shardingsphere.rules.encrypt.tables.user_info.columns.name.encryptorName=name_encryptor<br>
spring.shardingsphere.rules.encrypt.tables.user_info.columns.mobile.cipherColumn=mobile_enc<br>
spring.shardingsphere.rules.encrypt.tables.user_info.columns.mobile.encryptorName=mobile_encryptor<br>
spring.shardingsphere.rules.encrypt.tables.user_info.columns.ident.cipherColumn=ident_enc<br>
spring.shardingsphere.rules.encrypt.tables.user_info.columns.ident.encryptorName=idcard_encryptor<br>
spring.shardingsphere.rules.encrypt.tables.user_info.columns.value.cipherColumn=value_enc<br>
spring.shardingsphere.rules.encrypt.tables.user_info.columns.value.encryptorName=addr_encryptor<br>
spring.shardingsphere.rules.encrypt.tables.test_name.columns.name.cipherColumn=name_enc<br>
spring.shardingsphere.rules.encrypt.tables.test_name.columns.name.encryptorName=name_encryptor<br>
spring.shardingsphere.rules.encrypt.tables.users.columns.name.cipherColumn=name_enc<br>
spring.shardingsphere.rules.encrypt.tables.users.columns.name.encryptorName=name_encryptor</p>
<p dir="auto">2021-02-02 17:24:11.161  INFO 1832 --- [           main] ShardingSphere-SQL                       : Logic SQL: select ui.*,u.name,tn.name from user_info ui left join  users u on u.id = ui.id left join test_name tn on tn.name = u.name where ui.id &gt; 0<br>
2021-02-02 17:24:11.163  INFO 1832 --- [           main] ShardingSphere-SQL                       : Actual SQL: ds0 ::: select <code class="notranslate">ui</code>.<code class="notranslate">id</code>, <code class="notranslate">ui</code>.<code class="notranslate">cust_id</code>, <code class="notranslate">ui</code>.<code class="notranslate">unique_id</code>, <code class="notranslate">ui</code>.<code class="notranslate">name_enc</code> AS name, <code class="notranslate">ui</code>.<code class="notranslate">name_assisted</code>, <code class="notranslate">ui</code>.<code class="notranslate">ident_enc</code> AS ident, <code class="notranslate">ui</code>.<code class="notranslate">mobile_enc</code> AS mobile, <code class="notranslate">ui</code>.<code class="notranslate">password</code>, <code class="notranslate">ui</code>.<code class="notranslate">reg_time</code>, <code class="notranslate">ui</code>.<code class="notranslate">modify_time</code>, <code class="notranslate">ui</code>.<code class="notranslate">reg_source</code>, <code class="notranslate">ui</code>.<code class="notranslate">reg_app_channel</code>, <code class="notranslate">ui</code>.<code class="notranslate">reg_device_info</code>, <code class="notranslate">ui</code>.<code class="notranslate">status</code>, <code class="notranslate">ui</code>.<code class="notranslate">is_mobile_authed</code>, <code class="notranslate">ui</code>.<code class="notranslate">complate_cust_info</code>, <code class="notranslate">ui</code>.<code class="notranslate">time_inst</code>, <code class="notranslate">ui</code>.<code class="notranslate">time_upd</code>, <code class="notranslate">ui</code>.<code class="notranslate">has_checked</code>, <code class="notranslate">ui</code>.<code class="notranslate">value_enc</code> AS value, <code class="notranslate">ui</code>.<code class="notranslate">system</code>,u.name_enc AS name,tn.name_enc AS name from user_info ui left join  users u on u.id = ui.id left join test_name tn on <strong>tn.name = u.name</strong> where ui.id &gt; 0</p>
<p dir="auto">left join ....  on tn.name = u.name  ,there will be rewrite to tn.name_enc = u.name_enc</p>
<p dir="auto">I query the field infromation of the table with the "select COLUMN_NAME FROM information_schema.COLUMNS WHERE TABLE_NAME='goods'" statement,but result is null.<br>
the "goods" is the source table of subtable.</p>
<p dir="auto">I found through debug that the reason is that the information stored in the mysql database is<br>
the subtable information ,so it cannot be obtained.</p>
<p dir="auto">if I want query the column information of the table by source table names,what  to do .</p>