ER_NOT_ALLOWED_COMMAND

[jimmyolo]

when setting the permitLocalInfile: true and the pipelining: true at the same time, LOAD DATE INFILE command will not allow

[rusher]

Command "LOAD LOCAL INFILE" will result in a new exchange between connector and server.
This is the only case in protocol.

Connector when having finish sending a command and permitLocalInfile set to false can immediately send another command since the server will handle the command in order, and TCP guaranty FIFO order.

So those 2 options are incompatible.
if set together, this results having permitLocalInfile set to false.

If needing a connection with "LOAD LOCAL INFILE" enable, you cannot set option pipelining.
Still, an error would be a better solution than silently changing the value of permitLocalInfile to false.

[jimmyolo]

thanks for reply
close it

https://mariadb.com/kb/en/library/packet_local_infile/

[jimmyolo]

the latest version 2.0.2 still silently change permitLocalInfile to false
when option pipelining is true

1. should console.warn() or throw error ?
2. document these two options ?

this.pipelining = opts.pipelining === undefined || opts.pipelining;
this.permitLocalInfile = opts.permitLocalInfile || false;
if (this.pipelining && this.permitLocalInfile) {
  console.warn(...);
  this.permitLocalInfile = false;
}

[rusher]

corrected with f4cb727