Load data with empty value '' makes wrong data

[actiontech-bot]

Raised by: @zhunina
Steps:

1. Execute

create table binary_columns(
   id int  primary key,
   c_binary binary(255) 
);

2. Load Data: load data local infile '/opt/loaddata/binary_columns' into table binary_columns fields terminated by ',' lines terminated by '\r\n' (id,c_binary); (data is attached: binary_columns.zip )
3. Result:
   1. 16 rows inserted, while 40 rows are expected
   2. the data of id=19: c_binary is '000000000...000', while '' was expected