load data sql be routed to mysql has been truncated

[yexiaoli88]

• dble version：5.6.29-dble-9.9.9.9-16ae8083a9edeb67ab102cded51446e27d7ee2f5-20190627073912
• preconditions ：

 CREATE TABLE sharding_four(ID INT NOT NULL,FirstName VARCHAR(20),LastName VARCHAR(20),Department VARCHAR(20),Salary INT);

test.txt:

201     "Mazojys        ddd     ggg"    "Fxoj"  "Finance"       7800

• configs：

schema.xml

<schema name="testdb" sqlMaxLimit="100" dataNode="dn4">
        <table name="sharding_four" dataNode="dn1,dn2,dn3,dn4" rule="hash-four"/>
    </schema>

rule.xml

<tableRule name="hash-four">
        <rule>
            <columns>id</columns>
            <algorithm>four-long</algorithm>
        </rule>
  </tableRule>
 <function name="four-long" class="Hash">
        <property name="partitionCount">4</property>
        <property name="partitionLength">1</property>
    </function>

• steps：
  1.load data in dble with listing all column names:

load data infile "/opt/test.txt" into table sharding_four (ID,FirstName,LastName,Department,Salary) FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINNATED BY '\n';
Query OK, 1 row affected, 2 warnings (0.01 sec)

2.check general.log

2019-08-01T10:03:50.101693Z	 1001 Query	LOAD DATA LOCAL INFILE '/opt/test.txt' INTO TABLE sharding_four (ID, FirstName, LastName, Department, Salary)

• expect result：

1. the sql route to mysql should not be truncated

• real result：

1. the sql route to mysql has been truncated

• supplements：
  1.

[PanternBao]

durid will skip the error part of sql when load data grammar is error.

durid issue:
alibaba/druid#3396

update doc :
https://github.com/actiontech/dble-docs-cn/blob/develop/3.SQL_Syntax/3.2_DML/3.2.09_LOAD_DATA.md

[wjl1619]

verified on version: 5.6.29-dble-9.9.9.9-0d3c776cbd7993a4287108af0ac140be4693ca58-20190820021310