Closed mirromutth closed 8 months ago
Is your feature request related to a problem? Please describe.
Currently, we have Capability.LOCAL_FILES marked as disabled, and it is not actually supported. The statement like following:
Capability.LOCAL_FILES
LOAD DATA LOCAL INFILE '/path/to/file' INTO TABLE `my_table`;
After executing this statement (without error), the database server will immediately request the file content from the driver.
Note: MySQL 8.0+ has @@global.local_infiles disabled for security reasons, so this feature should be disabled by default.
@@global.local_infiles
Describe the solution you'd like
LocalInfileRequest
message.server
0xFB
LocalInfileResponse
message.client
LOCAL INFILE
QueryFlow
Additional context
See also MySQL and MariaDB docs
It is only supported in text protocol queries.
Reference from: mirromutth/r2dbc-mysql#110
Is your feature request related to a problem? Please describe.
Currently, we have
Capability.LOCAL_FILES
marked as disabled, and it is not actually supported. The statement like following:After executing this statement (without error), the database server will immediately request the file content from the driver.
Note: MySQL 8.0+ has
@@global.local_infiles
disabled for security reasons, so this feature should be disabled by default.Describe the solution you'd like
LocalInfileRequest
to packagemessage.server
, the header is0xFB
LocalInfileResponse
to packagemessage.client
, each such message contains a file chunk or an empty chunk (means End-Of-File)LOCAL INFILE
support in message decoderLOCAL INFILE
support inQueryFlow
, which should send file chunks and an empty chunk after receivingLocalInfileRequest
Additional context
See also MySQL and MariaDB docs
It is only supported in text protocol queries.
Reference from: mirromutth/r2dbc-mysql#110