You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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)
The text was updated successfully, but these errors were encountered:
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)
The text was updated successfully, but these errors were encountered: