• dble version：
  5.6.29-dble-9.9.9.9-78a278906811927e31ad0cdc0cc19c2379963992-20191012125722
• preconditions ：
  create table sharding_2_t1(id int(4), B float(8,2)) ;
  prepare /tmp/test3.txt, filled with:

1||2
3||4

• configs：

schema.xml

rule.xml

server.xml

• steps：
  step1. query in dble

mysql> load data infile '/tmp/test3.txt' into table sharding_2_t1 FIELDS TERMINATED BY '||';
Query OK, 2 rows affected, 4 warnings (0.01 sec)

mysql> select * from sharding_2_t1;
+------+------+
| id   | B    |
+------+------+
|    1 | 0.00 |
|    3 | 0.00 |
+------+------+
2 rows in set (0.00 sec)

• expect result：
  1. step1 after load data, the data in table is :

+------+------+
| id   | B    |
+------+------+
|    1 | 2.00 |
|    3 | 4.00 |
+------+------+

• real result：
  1.
• supplements：
  tester should verify other fields terminated strings, of which "|||" is a must