<p dir="auto">Please answer these questions before submitting your issue. Thanks!<br>
第一次使用 ， 求教  ：</p>
<h3 dir="auto">Which version of Sharding-Jdbc do you using?</h3>
<p dir="auto">1.5.4  1.5.4.1 ... 等 都有</p>
<h3 dir="auto">Expected behavior</h3>
<h3 dir="auto">Actual behavior</h3>
<h3 dir="auto">Steps to reproduce the behavior</h3>
<h3 dir="auto">Please provide the reproduce example codes (such as github link) if possible.</h3>
<p dir="auto">使用官方提供的jdbc用例，<br>
private static void executeUpdate(final DataSource dataSource, final String sql) throws SQLException {<br>
Connection conn = null;<br>
PreparedStatement preparedStatement = null;<br>
try {<br>
conn = dataSource.getConnection();<br>
preparedStatement = conn.prepareStatement(sql);<br>
System.out.println(sql);<br>
preparedStatement.executeUpdate();<br>
} catch (Exception e) {<br>
e.printStackTrace();<br>
} finally {<br>
// DDL 操作不会释放   可能是分表时DDL操作  改写的问题。<br>
System.out.println("----------------------");<br>
preparedStatement.close();<br>
conn.close();<br>
}<br>
}</p>
<p dir="auto">场景： 仅分表 。<br>
DML类型的SQL  可以正常释放  归还到连接池。<br>
DDL类型的SQL   没有正常释放。</p>
<h2 dir="auto">Bug Report</h2>
<p dir="auto">in version 5.1.2,The SQL clause 'LIKE' is unsupported in encrypt rule,I dont konw why</p>
<h3 dir="auto">Which version of ShardingSphere did you use?</h3>
<p dir="auto">5.1.2</p>
<h3 dir="auto">Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?</h3>
<p dir="auto">ShardingSphere-JDBC</p>
<h3 dir="auto">Expected behavior</h3>
<p dir="auto">support 'like'</p>
<h3 dir="auto">Actual behavior</h3>
<div class="highlight highlight-source-java notranslate position-relative overflow-auto" dir="auto" data-snippet-clipboard-copy-content="Caused by: org.apache.shardingsphere.infra.exception.ShardingSphereException: The SQL clause 'LIKE' is unsupported in encrypt rule.
	at org.apache.shardingsphere.encrypt.rewrite.condition.EncryptConditionEngine.createBinaryEncryptCondition(EncryptConditionEngine.java:143)
	at org.apache.shardingsphere.encrypt.rewrite.condition.EncryptConditionEngine.createEncryptCondition(EncryptConditionEngine.java:126)
	at org.apache.shardingsphere.encrypt.rewrite.condition.EncryptConditionEngine.addEncryptConditions(EncryptConditionEngine.java:119)
	at org.apache.shardingsphere.encrypt.rewrite.condition.EncryptConditionEngine.addEncryptConditions(EncryptConditionEngine.java:107)
	at org.apache.shardingsphere.encrypt.rewrite.condition.EncryptConditionEngine.createEncryptConditions(EncryptConditionEngine.java:97)
	at org.apache.shardingsphere.encrypt.rewrite.context.EncryptSQLRewriteContextDecorator.createEncryptConditions(EncryptSQLRewriteContextDecorator.java:73)
	at org.apache.shardingsphere.encrypt.rewrite.context.EncryptSQLRewriteContextDecorator.decorate(EncryptSQLRewriteContextDecorator.java:53)
	at org.apache.shardingsphere.encrypt.rewrite.context.EncryptSQLRewriteContextDecorator.decorate(EncryptSQLRewriteContextDecorator.java:44)
	at org.apache.shardingsphere.infra.rewrite.SQLRewriteEntry.decorate(SQLRewriteEntry.java:86)
	at org.apache.shardingsphere.infra.rewrite.SQLRewriteEntry.createSQLRewriteContext(SQLRewriteEntry.java:78)
	at org.apache.shardingsphere.infra.rewrite.SQLRewriteEntry.rewrite(SQLRewriteEntry.java:67)
	at org.apache.shardingsphere.infra.context.kernel.KernelProcessor.rewrite(KernelProcessor.java:59)
	at org.apache.shardingsphere.infra.context.kernel.KernelProcessor.generateExecutionContext(KernelProcessor.java:47)
	at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.createExecutionContext(ShardingSpherePreparedStatement.java:471)
	at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.execute(ShardingSpherePreparedStatement.java:364)
	at sun.reflect.GeneratedMethodAccessor339.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
	at com.sun.proxy.$Proxy680.execute(Unknown Source)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
	at sun.reflect.GeneratedMethodAccessor347.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
	at com.sun.proxy.$Proxy678.query(Unknown Source)
	at com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.doQuery(MybatisSimpleExecutor.java:69)
	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
	at com.baomidou.mybatisplus.core.executor.MybatisCachingExecutor.query(MybatisCachingExecutor.java:165)
	at com.baomidou.mybatisplus.core.executor.MybatisCachingExecutor.query(MybatisCachingExecutor.java:92)
	at sun.reflect.GeneratedMethodAccessor329.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
	at com.sun.proxy.$Proxy677.query(Unknown Source)
	at sun.reflect.GeneratedMethodAccessor329.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
	at com.sun.proxy.$Proxy677.query(Unknown Source)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)"><pre class="notranslate"><span class="pl-smi">Caused</span> <span class="pl-s1">by</span>: <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">shardingsphere</span>.<span class="pl-s1">infra</span>.<span class="pl-s1">exception</span>.<span class="pl-s1">ShardingSphereException</span>: <span class="pl-s1">The</span> <span class="pl-c1">SQL</span> <span class="pl-s1">clause</span> <span class="pl-s">'LIKE'</span> <span class="pl-s1">is</span> <span class="pl-s1">unsupported</span> <span class="pl-s1">in</span> <span class="pl-s1">encrypt</span> <span class="pl-s1">rule</span>.
	<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">shardingsphere</span>.<span class="pl-s1">encrypt</span>.<span class="pl-s1">rewrite</span>.<span class="pl-s1">condition</span>.<span class="pl-s1">EncryptConditionEngine</span>.<span class="pl-en">createBinaryEncryptCondition</span>(<span class="pl-smi">EncryptConditionEngine</span>.<span class="pl-smi">java</span>:<span class="pl-c1">143</span>)
	<span class="pl-smi">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">shardingsphere</span>.<span class="pl-s1">encrypt</span>.<span class="pl-s1">rewrite</span>.<span class="pl-s1">condition</span>.<span class="pl-s1">EncryptConditionEngine</span>.<span class="pl-s1">createEncryptCondition</span>(<span class="pl-smi">EncryptConditionEngine</span>.<span class="pl-smi">java</span>:<span class="pl-c1">126</span>)
	<span class="pl-smi">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">shardingsphere</span>.<span class="pl-s1">encrypt</span>.<span class="pl-s1">rewrite</span>.<span class="pl-s1">condition</span>.<span class="pl-s1">EncryptConditionEngine</span>.<span class="pl-en">addEncryptConditions</span>(<span class="pl-smi">EncryptConditionEngine</span>.<span class="pl-smi">java</span>:<span class="pl-c1">119</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">shardingsphere</span>.<span class="pl-s1">encrypt</span>.<span class="pl-s1">rewrite</span>.<span class="pl-s1">condition</span>.<span class="pl-s1">EncryptConditionEngine</span>.<span class="pl-en">addEncryptConditions</span>(<span class="pl-smi">EncryptConditionEngine</span>.<span class="pl-smi">java</span>:<span class="pl-c1">107</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">shardingsphere</span>.<span class="pl-s1">encrypt</span>.<span class="pl-s1">rewrite</span>.<span class="pl-s1">condition</span>.<span class="pl-s1">EncryptConditionEngine</span>.<span class="pl-en">createEncryptConditions</span>(<span class="pl-smi">EncryptConditionEngine</span>.<span class="pl-smi">java</span>:<span class="pl-c1">97</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">shardingsphere</span>.<span class="pl-s1">encrypt</span>.<span class="pl-s1">rewrite</span>.<span class="pl-s1">context</span>.<span class="pl-s1">EncryptSQLRewriteContextDecorator</span>.<span class="pl-en">createEncryptConditions</span>(<span class="pl-smi">EncryptSQLRewriteContextDecorator</span>.<span class="pl-smi">java</span>:<span class="pl-c1">73</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">shardingsphere</span>.<span class="pl-s1">encrypt</span>.<span class="pl-s1">rewrite</span>.<span class="pl-s1">context</span>.<span class="pl-s1">EncryptSQLRewriteContextDecorator</span>.<span class="pl-en">decorate</span>(<span class="pl-smi">EncryptSQLRewriteContextDecorator</span>.<span class="pl-smi">java</span>:<span class="pl-c1">53</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">shardingsphere</span>.<span class="pl-s1">encrypt</span>.<span class="pl-s1">rewrite</span>.<span class="pl-s1">context</span>.<span class="pl-s1">EncryptSQLRewriteContextDecorator</span>.<span class="pl-en">decorate</span>(<span class="pl-smi">EncryptSQLRewriteContextDecorator</span>.<span class="pl-smi">java</span>:<span class="pl-c1">44</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">shardingsphere</span>.<span class="pl-s1">infra</span>.<span class="pl-s1">rewrite</span>.<span class="pl-s1">SQLRewriteEntry</span>.<span class="pl-en">decorate</span>(<span class="pl-smi">SQLRewriteEntry</span>.<span class="pl-smi">java</span>:<span class="pl-c1">86</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">shardingsphere</span>.<span class="pl-s1">infra</span>.<span class="pl-s1">rewrite</span>.<span class="pl-s1">SQLRewriteEntry</span>.<span class="pl-en">createSQLRewriteContext</span>(<span class="pl-smi">SQLRewriteEntry</span>.<span class="pl-smi">java</span>:<span class="pl-c1">78</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">shardingsphere</span>.<span class="pl-s1">infra</span>.<span class="pl-s1">rewrite</span>.<span class="pl-s1">SQLRewriteEntry</span>.<span class="pl-en">rewrite</span>(<span class="pl-smi">SQLRewriteEntry</span>.<span class="pl-smi">java</span>:<span class="pl-c1">67</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">shardingsphere</span>.<span class="pl-s1">infra</span>.<span class="pl-s1">context</span>.<span class="pl-s1">kernel</span>.<span class="pl-s1">KernelProcessor</span>.<span class="pl-en">rewrite</span>(<span class="pl-smi">KernelProcessor</span>.<span class="pl-smi">java</span>:<span class="pl-c1">59</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">shardingsphere</span>.<span class="pl-s1">infra</span>.<span class="pl-s1">context</span>.<span class="pl-s1">kernel</span>.<span class="pl-s1">KernelProcessor</span>.<span class="pl-en">generateExecutionContext</span>(<span class="pl-smi">KernelProcessor</span>.<span class="pl-smi">java</span>:<span class="pl-c1">47</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">shardingsphere</span>.<span class="pl-s1">driver</span>.<span class="pl-s1">jdbc</span>.<span class="pl-s1">core</span>.<span class="pl-s1">statement</span>.<span class="pl-s1">ShardingSpherePreparedStatement</span>.<span class="pl-en">createExecutionContext</span>(<span class="pl-smi">ShardingSpherePreparedStatement</span>.<span class="pl-smi">java</span>:<span class="pl-c1">471</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">shardingsphere</span>.<span class="pl-s1">driver</span>.<span class="pl-s1">jdbc</span>.<span class="pl-s1">core</span>.<span class="pl-s1">statement</span>.<span class="pl-s1">ShardingSpherePreparedStatement</span>.<span class="pl-en">execute</span>(<span class="pl-smi">ShardingSpherePreparedStatement</span>.<span class="pl-smi">java</span>:<span class="pl-c1">364</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">sun</span>.<span class="pl-s1">reflect</span>.<span class="pl-s1">GeneratedMethodAccessor339</span>.<span class="pl-en">invoke</span>(<span class="pl-smi">Unknown</span> <span class="pl-s1">Source</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">sun</span>.<span class="pl-s1">reflect</span>.<span class="pl-s1">DelegatingMethodAccessorImpl</span>.<span class="pl-en">invoke</span>(<span class="pl-smi">DelegatingMethodAccessorImpl</span>.<span class="pl-smi">java</span>:<span class="pl-c1">43</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">lang</span>.<span class="pl-s1">reflect</span>.<span class="pl-s1">Method</span>.<span class="pl-en">invoke</span>(<span class="pl-smi">Method</span>.<span class="pl-smi">java</span>:<span class="pl-c1">498</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">ibatis</span>.<span class="pl-s1">logging</span>.<span class="pl-s1">jdbc</span>.<span class="pl-s1">PreparedStatementLogger</span>.<span class="pl-en">invoke</span>(<span class="pl-smi">PreparedStatementLogger</span>.<span class="pl-smi">java</span>:<span class="pl-c1">59</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">com</span>.<span class="pl-s1">sun</span>.<span class="pl-s1">proxy</span>.<span class="pl-s1">$Proxy680</span>.<span class="pl-en">execute</span>(<span class="pl-smi">Unknown</span> <span class="pl-s1">Source</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">ibatis</span>.<span class="pl-s1">executor</span>.<span class="pl-s1">statement</span>.<span class="pl-s1">PreparedStatementHandler</span>.<span class="pl-en">query</span>(<span class="pl-smi">PreparedStatementHandler</span>.<span class="pl-smi">java</span>:<span class="pl-c1">64</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">ibatis</span>.<span class="pl-s1">executor</span>.<span class="pl-s1">statement</span>.<span class="pl-s1">RoutingStatementHandler</span>.<span class="pl-en">query</span>(<span class="pl-smi">RoutingStatementHandler</span>.<span class="pl-smi">java</span>:<span class="pl-c1">79</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">sun</span>.<span class="pl-s1">reflect</span>.<span class="pl-s1">GeneratedMethodAccessor347</span>.<span class="pl-en">invoke</span>(<span class="pl-smi">Unknown</span> <span class="pl-s1">Source</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">sun</span>.<span class="pl-s1">reflect</span>.<span class="pl-s1">DelegatingMethodAccessorImpl</span>.<span class="pl-en">invoke</span>(<span class="pl-smi">DelegatingMethodAccessorImpl</span>.<span class="pl-smi">java</span>:<span class="pl-c1">43</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">lang</span>.<span class="pl-s1">reflect</span>.<span class="pl-s1">Method</span>.<span class="pl-en">invoke</span>(<span class="pl-smi">Method</span>.<span class="pl-smi">java</span>:<span class="pl-c1">498</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">ibatis</span>.<span class="pl-s1">plugin</span>.<span class="pl-s1">Plugin</span>.<span class="pl-en">invoke</span>(<span class="pl-smi">Plugin</span>.<span class="pl-smi">java</span>:<span class="pl-c1">63</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">com</span>.<span class="pl-s1">sun</span>.<span class="pl-s1">proxy</span>.<span class="pl-s1">$Proxy678</span>.<span class="pl-en">query</span>(<span class="pl-smi">Unknown</span> <span class="pl-s1">Source</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">com</span>.<span class="pl-s1">baomidou</span>.<span class="pl-s1">mybatisplus</span>.<span class="pl-s1">core</span>.<span class="pl-s1">executor</span>.<span class="pl-s1">MybatisSimpleExecutor</span>.<span class="pl-en">doQuery</span>(<span class="pl-smi">MybatisSimpleExecutor</span>.<span class="pl-smi">java</span>:<span class="pl-c1">69</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">ibatis</span>.<span class="pl-s1">executor</span>.<span class="pl-s1">BaseExecutor</span>.<span class="pl-en">queryFromDatabase</span>(<span class="pl-smi">BaseExecutor</span>.<span class="pl-smi">java</span>:<span class="pl-c1">325</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">ibatis</span>.<span class="pl-s1">executor</span>.<span class="pl-s1">BaseExecutor</span>.<span class="pl-en">query</span>(<span class="pl-smi">BaseExecutor</span>.<span class="pl-smi">java</span>:<span class="pl-c1">156</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">com</span>.<span class="pl-s1">baomidou</span>.<span class="pl-s1">mybatisplus</span>.<span class="pl-s1">core</span>.<span class="pl-s1">executor</span>.<span class="pl-s1">MybatisCachingExecutor</span>.<span class="pl-en">query</span>(<span class="pl-smi">MybatisCachingExecutor</span>.<span class="pl-smi">java</span>:<span class="pl-c1">165</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">com</span>.<span class="pl-s1">baomidou</span>.<span class="pl-s1">mybatisplus</span>.<span class="pl-s1">core</span>.<span class="pl-s1">executor</span>.<span class="pl-s1">MybatisCachingExecutor</span>.<span class="pl-en">query</span>(<span class="pl-smi">MybatisCachingExecutor</span>.<span class="pl-smi">java</span>:<span class="pl-c1">92</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">sun</span>.<span class="pl-s1">reflect</span>.<span class="pl-s1">GeneratedMethodAccessor329</span>.<span class="pl-en">invoke</span>(<span class="pl-smi">Unknown</span> <span class="pl-s1">Source</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">sun</span>.<span class="pl-s1">reflect</span>.<span class="pl-s1">DelegatingMethodAccessorImpl</span>.<span class="pl-en">invoke</span>(<span class="pl-smi">DelegatingMethodAccessorImpl</span>.<span class="pl-smi">java</span>:<span class="pl-c1">43</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">lang</span>.<span class="pl-s1">reflect</span>.<span class="pl-s1">Method</span>.<span class="pl-en">invoke</span>(<span class="pl-smi">Method</span>.<span class="pl-smi">java</span>:<span class="pl-c1">498</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">ibatis</span>.<span class="pl-s1">plugin</span>.<span class="pl-s1">Plugin</span>.<span class="pl-en">invoke</span>(<span class="pl-smi">Plugin</span>.<span class="pl-smi">java</span>:<span class="pl-c1">63</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">com</span>.<span class="pl-s1">sun</span>.<span class="pl-s1">proxy</span>.<span class="pl-s1">$Proxy677</span>.<span class="pl-en">query</span>(<span class="pl-smi">Unknown</span> <span class="pl-s1">Source</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">sun</span>.<span class="pl-s1">reflect</span>.<span class="pl-s1">GeneratedMethodAccessor329</span>.<span class="pl-en">invoke</span>(<span class="pl-smi">Unknown</span> <span class="pl-s1">Source</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">sun</span>.<span class="pl-s1">reflect</span>.<span class="pl-s1">DelegatingMethodAccessorImpl</span>.<span class="pl-en">invoke</span>(<span class="pl-smi">DelegatingMethodAccessorImpl</span>.<span class="pl-smi">java</span>:<span class="pl-c1">43</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">lang</span>.<span class="pl-s1">reflect</span>.<span class="pl-s1">Method</span>.<span class="pl-en">invoke</span>(<span class="pl-smi">Method</span>.<span class="pl-smi">java</span>:<span class="pl-c1">498</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">ibatis</span>.<span class="pl-s1">plugin</span>.<span class="pl-s1">Plugin</span>.<span class="pl-en">invoke</span>(<span class="pl-smi">Plugin</span>.<span class="pl-smi">java</span>:<span class="pl-c1">63</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">com</span>.<span class="pl-s1">sun</span>.<span class="pl-s1">proxy</span>.<span class="pl-s1">$Proxy677</span>.<span class="pl-en">query</span>(<span class="pl-smi">Unknown</span> <span class="pl-s1">Source</span>)
	<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">ibatis</span>.<span class="pl-s1">session</span>.<span class="pl-s1">defaults</span>.<span class="pl-s1">DefaultSqlSession</span>.<span class="pl-en">selectList</span>(<span class="pl-smi">DefaultSqlSession</span>.<span class="pl-smi">java</span>:<span class="pl-c1">147</span>)</pre></div>
<h3 dir="auto">Reason analyze (If you can)</h3>
<div class="highlight highlight-source-java notranslate position-relative overflow-auto" dir="auto" data-snippet-clipboard-copy-content="static {
        LOGICAL_OPERATOR.add(&quot;AND&quot;);
        LOGICAL_OPERATOR.add(&quot;&amp;&amp;&quot;);
        LOGICAL_OPERATOR.add(&quot;OR&quot;);
        LOGICAL_OPERATOR.add(&quot;||&quot;);
        SUPPORTED_COMPARE_OPERATOR.add(&quot;=&quot;);
        SUPPORTED_COMPARE_OPERATOR.add(&quot;&lt;&gt;&quot;);
        SUPPORTED_COMPARE_OPERATOR.add(&quot;!=&quot;);
        SUPPORTED_COMPARE_OPERATOR.add(&quot;&gt;&quot;);
        SUPPORTED_COMPARE_OPERATOR.add(&quot;&lt;&quot;);
        SUPPORTED_COMPARE_OPERATOR.add(&quot;&gt;=&quot;);
        SUPPORTED_COMPARE_OPERATOR.add(&quot;&lt;=&quot;);
        SUPPORTED_COMPARE_OPERATOR.add(&quot;IS&quot;);
    }
private Optional&lt;EncryptCondition&gt; createBinaryEncryptCondition(final BinaryOperationExpression expression, final String tableName) {
        String operator = expression.getOperator();
        if (!LOGICAL_OPERATOR.contains(operator)) {
            if (SUPPORTED_COMPARE_OPERATOR.contains(operator)) {
                return createCompareEncryptCondition(tableName, expression, expression.getRight());
            }
            throw new ShardingSphereException(&quot;The SQL clause '%s' is unsupported in encrypt rule.&quot;, operator);
        }
        return Optional.empty();
    }"><pre class="notranslate"><span class="pl-k">static</span> {
        <span class="pl-smi">LOGICAL_OPERATOR</span>.<span class="pl-en">add</span>(<span class="pl-s">"AND"</span>);
        <span class="pl-smi">LOGICAL_OPERATOR</span>.<span class="pl-en">add</span>(<span class="pl-s">"&amp;&amp;"</span>);
        <span class="pl-smi">LOGICAL_OPERATOR</span>.<span class="pl-en">add</span>(<span class="pl-s">"OR"</span>);
        <span class="pl-smi">LOGICAL_OPERATOR</span>.<span class="pl-en">add</span>(<span class="pl-s">"||"</span>);
        <span class="pl-smi">SUPPORTED_COMPARE_OPERATOR</span>.<span class="pl-en">add</span>(<span class="pl-s">"="</span>);
        <span class="pl-smi">SUPPORTED_COMPARE_OPERATOR</span>.<span class="pl-en">add</span>(<span class="pl-s">"&lt;&gt;"</span>);
        <span class="pl-smi">SUPPORTED_COMPARE_OPERATOR</span>.<span class="pl-en">add</span>(<span class="pl-s">"!="</span>);
        <span class="pl-smi">SUPPORTED_COMPARE_OPERATOR</span>.<span class="pl-en">add</span>(<span class="pl-s">"&gt;"</span>);
        <span class="pl-smi">SUPPORTED_COMPARE_OPERATOR</span>.<span class="pl-en">add</span>(<span class="pl-s">"&lt;"</span>);
        <span class="pl-smi">SUPPORTED_COMPARE_OPERATOR</span>.<span class="pl-en">add</span>(<span class="pl-s">"&gt;="</span>);
        <span class="pl-smi">SUPPORTED_COMPARE_OPERATOR</span>.<span class="pl-en">add</span>(<span class="pl-s">"&lt;="</span>);
        <span class="pl-smi">SUPPORTED_COMPARE_OPERATOR</span>.<span class="pl-en">add</span>(<span class="pl-s">"IS"</span>);
    }
<span class="pl-k">private</span> <span class="pl-smi">Optional</span>&lt;<span class="pl-smi">EncryptCondition</span>&gt; <span class="pl-s1">createBinaryEncryptCondition</span>(<span class="pl-k">final</span> <span class="pl-smi">BinaryOperationExpression</span> <span class="pl-s1">expression</span>, <span class="pl-k">final</span> <span class="pl-smi">String</span> <span class="pl-s1">tableName</span>) {
        <span class="pl-smi">String</span> <span class="pl-s1">operator</span> = <span class="pl-s1">expression</span>.<span class="pl-en">getOperator</span>();
        <span class="pl-k">if</span> (!<span class="pl-smi">LOGICAL_OPERATOR</span>.<span class="pl-en">contains</span>(<span class="pl-s1">operator</span>)) {
            <span class="pl-k">if</span> (<span class="pl-smi">SUPPORTED_COMPARE_OPERATOR</span>.<span class="pl-en">contains</span>(<span class="pl-s1">operator</span>)) {
                <span class="pl-k">return</span> <span class="pl-en">createCompareEncryptCondition</span>(<span class="pl-s1">tableName</span>, <span class="pl-s1">expression</span>, <span class="pl-s1">expression</span>.<span class="pl-en">getRight</span>());
            }
            <span class="pl-k">throw</span> <span class="pl-k">new</span> <span class="pl-smi">ShardingSphereException</span>(<span class="pl-s">"The SQL clause '%s' is unsupported in encrypt rule."</span>, <span class="pl-s1">operator</span>);
        }
        <span class="pl-k">return</span> <span class="pl-smi">Optional</span>.<span class="pl-en">empty</span>();
    }</pre></div>
<h3 dir="auto">Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.</h3>
<h3 dir="auto">Example codes for reproduce this issue (such as a github link).</h3>