[BUG] The value of time type column is not same as tidb

[lilinghai]

Describe the bug

The value of time type column is not same as tidb What did you do

1. execute in tidb create table t1(id varchar(10),a time,index id(a)); insert into t1 values('ab',10); insert into t1 values('ab',12); insert into t1 values('ab',14); insert into t1 values('ab',16);
2. execute in tispark select * from t1 select * from t1 where a>12 and a<16

What do you expect

(('ab', datetime.timedelta(0, 10)), ('cd', datetime.timedelta(0, 12)), ('cd', datetime.timedelta(0, 14)), ('cd', datetime.timedelta(0, 16))) ('cd', datetime.timedelta(0, 14)) What happens instead

[('ab', 10000000000), ('cd', 12000000000), ('cd', 14000000000), ('cd', 16000000000)] []

Spark and TiSpark version info

Git Commit Hash: 9687b70202584883fe5b88d39fb62d64867ebde2 Git Branch: release-2.3 UTC Build Time: 2020-10-16 02:40:15 Supported Spark Version: 2.3 2.4 Current Spark Version: 2.4.3 Current Spark Major Version: 2.4 TimeZone: Asia/Shanghai

TIDB: release-4.0

[birdstorm]

can't reproduce

[lilinghai]

the reproduce code

[shiyuhang0]

/lifecycle frozen