[CONJ-1075] LOAD DATA INFILE is broken on windows Created: 2023-05-04  Updated: 2023-11-06  Resolved: 2023-06-06

Status: Closed
Project: MariaDB Connector/J
Component/s: Other
Affects Version/s: None
Fix Version/s: 3.2.0, 2.7.11

Type: Bug Priority: Major
Reporter: ak Assignee: Diego Dupin
Resolution: Fixed Votes: 0
Labels: None
Environment:

Windows


Attachments: PNG File image.png    

 Description   

File path is concatenated to regexp without any escaping, causing invalid syntax with windows slashes.

https://github.com/mariadb-corporation/mariadb-connector-j/blob/745ef7b287363745ae4b11d44df2713d3c9b3d8d/src/main/java/org/mariadb/jdbc/message/ClientMessage.java#L304

Reported to DataGrip tracker https://youtrack.jetbrains.com/issue/DBE-16600

Example from there
```
LOAD DATA LOCAL INFILE
"z:\\EDEDE
ede.csv"
IGNORE INTO TABLE schama.table
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
IGNORE 1 LINES
(@col1, @col2, @col3, @col4, @col5,@date_str,@col7,@col8,@val)
set val= @val, date = STR_TO_DATE(@date_str, '%Y%m%d'), id = 12345;
```


Generated at Thu Feb 08 03:20:26 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.