<table name="datetest" rule="rule_id" dataNode="dn1,dn2"/>
<table name="datetest2" rule="rule_id" dataNode="dn3,dn4"/>
<tableRule name="rule_id">
<rule>
<columns>id</columns>
<algorithm>hash2</algorithm>
</rule>
</tableRule>
<function name="hashDcar2" class="StringHash">
<property name="partitionCount">2</property>
<property name="partitionLength">1</property>
</function>
create table datetest(id long) in dn1 and dn2
create table datetest(id long) in dn3 and dn4
default
schema.xml
rule.xml
server.xml
step1. insert into datetest values(108);
step2. insert into datetest2 values(108);
step3. select A.id from datetest A join datetest2 B on A.id = B.id;
step4. select date(A.id) from datetest A join datetest2 B on A.id = B.id;
1.select A.id from datetest A join datetest2 B on A.id = B.id;
get result A.id = 108
2.select date(A.id) from datetest A join datetest2 B on A.id = B.id;
get result 2000-01-08
1.select A.id from datetest A join datetest2 B on A.id = B.id;
get result A.id = 108
2.select date(A.id) from datetest A join datetest2 B on A.id = B.id;
get result null
1.select date(108) in mysql and dble both get 2000-01-08
guess use date() implement in dble but do not support number like '108'
but mysql support select date(108)