Unable to `LOAD DATA LOCAL INFILE` in DoltSQL shell
- Dominant language
- Go
- Stars
- 24.5k
- Forks
- 873
- Avg merge
- 1d 8h
- Merged PRs (30d)
- 120
Description
I have a dolt sql-server running on port 3307 (`dolt sql-server --port 3307`).
When I try to load a CSV in the DoltSQL shell, I get the following error message:
```
tmp/main*> LOAD DATA LOCAL INFILE '/Users/amx/table1.csv' INTO TABLE table1 FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 ROWS;
LOCAL supported only in sql-server mode
```
Contributor guide
No contributing guide indexed for this repository
Research direction
No source files or tests are named. Start by reproducing the issue with `dolt sql-server --port 3307`, then run the reported `LOAD DATA LOCAL INFILE` statement in the DoltSQL shell and trace the mode-handling entry point. Done means the command's behavior is corrected or its supported usage is made clear.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- cli, databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 30/100