Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
-
Windows
Description
File path is concatenated to regexp without any escaping, causing invalid syntax with windows slashes.
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;
```