wangfeigithub

Results 15 comments of wangfeigithub

`29 Sep 2020 11:11:32 INFO LdapDeltaUserGroupBuilder [UnixUserSyncThread] - timeStampVal = 20200707095724Zand currentDeltaSyncTime = 1594087044000 29 Sep 2020 11:11:32 INFO LdapDeltaUserGroupBuilder [UnixUserSyncThread] - Updating user count: 46, userName: testldap2 29 Sep...

Ldap will be synchronized on startup, but 401 will be synchronized every hour

> I use this sql to create table in TiDB, but it throws an exception: `Invalid default value for 'expected_date'`. How did you create this table in TiDB? Can you...

![image](https://user-images.githubusercontent.com/29723968/101596303-c9e47a80-3a2f-11eb-8675-9455da3d1466.png)

定位到问题了 我们业务库 有这样的数据 select cast('2020-00-00' as TIMESTAMP) 但是这个数据我们用presto mysql驱动查询tidb 没有问题 用你们的tidb驱动 就会有问题。

However, I also found the problem of enum. If the enum is empty, an error will be reported

![image](https://user-images.githubusercontent.com/29723968/101617529-b0512c00-3a4b-11eb-9c90-662b66a075b5.png) CREATE TABLE `sp_service_channel1` ( `sc_id` int(11) NOT NULL, `st_split_type` enum('n','r','l') NOT NULL, UNIQUE KEY `sc_id` (`sc_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin/*!90000 SHARD_ROW_ID_BITS=4 PRE_SPLIT_REGIONS=1 */; INSERT INTO `sp_service_channel1` (`sc_id`, `st_split_type`)...

You can try this case

> MySQL jdbc driver use ascii code to parse date , but TiKV java client use java class Date. That's why you can't read '2020-00-00' by presto-tidb-connector. We will update...