dble icon indicating copy to clipboard operation
dble copied to clipboard

date return null when cross dn

Open Icarus124 opened this issue 1 year ago • 0 comments

  • dble version: 2.19.03
  • preconditions :
    create table datetest(id long) in dn1 and dn2 create table datetest(id long) in dn3 and dn4
  • configs: default schema.xml
<table name="datetest" rule="rule_id" dataNode="dn1,dn2"/>
<table name="datetest2" rule="rule_id" dataNode="dn3,dn4"/>

rule.xml

    <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>

server.xml

default

  • steps:
    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;
  • expect result:
    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
  • real result:
    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
  • supplements:
    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)

Icarus124 avatar Jun 18 '24 09:06 Icarus124