<h3 dir="auto">Which version of ShardingSphere did you use?</h3>
<p dir="auto">5.0.0-RC1-SNAPSHOT</p>
<h3 dir="auto">Expected behavior</h3>
<p dir="auto">After I configured the encrypt rules for t_user_details, if I use logical column name to perform some DDL operations, for example:<br>
<code class="notranslate">CREATE TABLE t_user_details (user_id INT NOT NULL, pwd VARCHAR(45))</code><br>
It will execute DDL according to the configuration rules to generate the table as follows:<br>
<a target="_blank" rel="noopener noreferrer nofollow" href="https://user-images.githubusercontent.com/76552510/109746421-51e1b700-7c10-11eb-838d-3755ea0e4c96.png"><img src="https://user-images.githubusercontent.com/76552510/109746421-51e1b700-7c10-11eb-838d-3755ea0e4c96.png" alt="image" style="max-width: 100%;"></a></p>
<h3 dir="auto">Actual behavior</h3>
<p dir="auto"><a target="_blank" rel="noopener noreferrer nofollow" href="https://user-images.githubusercontent.com/76552510/109746427-560dd480-7c10-11eb-8bd2-e5d3ea45eaa7.png"><img src="https://user-images.githubusercontent.com/76552510/109746427-560dd480-7c10-11eb-8bd2-e5d3ea45eaa7.png" alt="image" style="max-width: 100%;"></a></p>
<h3 dir="auto">Reason analyze (If you can)</h3>
<p dir="auto">Not support this feature</p>
<p dir="auto">Some other sql please refer to <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="819778515" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/9563" data-hovercard-type="pull_request" data-hovercard-url="/apache/shardingsphere/pull/9563/hovercard" href="https://github.com/apache/shardingsphere/pull/9563">#9563</a><br>
about issue ： <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="816073867" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/9497" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/9497/hovercard" href="https://github.com/apache/shardingsphere/issues/9497">#9497</a></p>
<p dir="auto">Hi community,</p>
<p dir="auto">I found that there are duplicated order of <code class="notranslate">DatabaseRuleBuilder</code>, both <code class="notranslate">FixtureDatabaseRuleBuilder</code> and <code class="notranslate">FixtureDistributedRuleBuilder</code> are orderd <code class="notranslate">0</code>, which is the same with <code class="notranslate">SingleRuleBuilder</code>.</p>
<p dir="auto">In addition, according to the current build order, when <code class="notranslate">singleRule</code> is initialized, the <code class="notranslate">builtRules</code> does not include <code class="notranslate">encrypt</code> and <code class="notranslate">mask</code> rules.<br>
I want to adjust the single order to after encrypt and mask, so that it can be more intelligent during building, such as automatically loading the single table required by the feature, no additional user configuration is required. (ref <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="1498201420" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/22887" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/22887/hovercard" href="https://github.com/apache/shardingsphere/issues/22887">#22887</a>)</p>
<p dir="auto">Below is the order I plan to tweak, any suggestions are welcome, thanks.</p>
<h2 dir="auto">Before</h2>
<a target="_blank" rel="noopener noreferrer" href="https://user-images.githubusercontent.com/5668787/245347946-26315ec0-54f5-4e7a-8bf8-06eab8f72a99.png"><img width="677" alt="image" src="https://user-images.githubusercontent.com/5668787/245347946-26315ec0-54f5-4e7a-8bf8-06eab8f72a99.png" style="max-width: 100%;"></a>
<h2 dir="auto">After</h2>
<a target="_blank" rel="noopener noreferrer" href="https://user-images.githubusercontent.com/5668787/245347992-5ee26028-b690-4b13-8ac8-55810577f1a5.png"><img width="677" alt="image" src="https://user-images.githubusercontent.com/5668787/245347992-5ee26028-b690-4b13-8ac8-55810577f1a5.png" style="max-width: 100%;"></a>
<p dir="auto">Reference: <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="1485908726" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/22759" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/22759/hovercard" href="https://github.com/apache/shardingsphere/issues/22759">#22759</a></p>