<blockquote>
<p dir="auto">In order to make orchestration simpler and efficient, it is necesary to consider that we can get changed data from DataChangedEvent instead of getting them directly from registry in Orchestration module.</p>
</blockquote>
<p dir="auto">In the process of investigating <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="1575341598" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/24053" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/24053/hovercard" href="https://github.com/apache/shardingsphere/issues/24053">#24053</a>, I found that there are still many functions that are not supported by the parser engine, and I think we can improve it gradually.</p>
<p dir="auto">Here are some references:</p>
<h4 dir="auto">MySQL</h4>
<ul dir="auto">
<li>Document: <a href="https://dev.mysql.com/doc/refman/8.0/en/functions.html" rel="nofollow">https://dev.mysql.com/doc/refman/8.0/en/functions.html</a></li>
<li>PR: <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="1604177717" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/24396" data-hovercard-type="pull_request" data-hovercard-url="/apache/shardingsphere/pull/24396/hovercard" href="https://github.com/apache/shardingsphere/pull/24396">#24396</a></li>
</ul>
<h3 dir="auto">Tasks</h3>
<h4 dir="auto"></h4>
<ul class="contains-task-list">
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> REPEAT <a href="https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_repeat" rel="nofollow">https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_repeat</a></li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> EXTRACT <a href="https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_extract" rel="nofollow">https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_extract</a></li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> CAST <a href="https://dev.mysql.com/doc/refman/8.0/en/cast-functions.html#function_cast" rel="nofollow">https://dev.mysql.com/doc/refman/8.0/en/cast-functions.html#function_cast</a></li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> Optimize MySQLStatementSQLVisitor#visitCastFunction</li>
</ul>