Amoebaformysqlcom. meidusa. amoeba. sqljep. ParseException: Notcomparable

An error occurs when you use Amoebaformysql for horizontal splitting. The rule uses the date field to split and configure the rule. xml segment as follows: odateNode02odate & lt ;! [Amoebamysql

An error occurs when you use Amoeba for mysql for horizontal splitting. horizontal splitting rules are used to split data based on the date field.
Configure the rule. xml snippet as follows:


Odate
<br>Odate&gt; to_date (&#39;1970-01-01 &#39;, &#39;yyyy-mm-DD&#39;) and odate &lt;to_date (&#39;1970-12-31&#39;, &#39;yyyy-mm-DD &#39;)<br>]&gt;<br>Node02<br><br><br>Odate<br><![CDATA[ <br>Odate&gt; to_date (&#39;1970-01-01 &#39;, &#39;yyyy-mm-DD&#39;) and odate &lt;to_date (&#39;1970-12-31&#39;, &#39;yyyy-mm-DD &#39;)<br>]&gt;<br>Node03<br><br><br>Odate<br><![CDATA[ <br>Odate&gt; to_date (&#39;1970-01-01 &#39;, &#39;yyyy-mm-DD&#39;) and odate &lt;to_date (&#39;1970-12-31&#39;, &#39;yyyy-mm-DD &#39;)<br>]&gt;<br>Node04<br><br><br>Odate<br><![CDATA[ <br>Odate&gt; to_date (&#39;1970-01-01 &#39;, &#39;yyyy-mm-DD&#39;) and odate &lt;to_date (&#39;1970-12-31&#39;, &#39;yyyy-mm-DD &#39;)<br>]&gt;<br>Node05<br><br></p> <p>Has anyone ever encountered such a problem?</p> </dd>