vscode-sql-notebook
vscode-sql-notebook copied to clipboard
Error Attempting LOAD DATA LOCAL INFILE statement (cell output references streamFactory option)
I can run LOAD DATA LOCAL INFILE MySQL statements using the SQLTools extension, but when I have attempted running the same statement via SQL Notebook extension, I receive the following error message in Cell Output:
As a result of LOCAL INFILE command server wants to read <fully-qualified-file-name> file, but as of v2.0 you must provide streamFactory option returning ReadStream.
Not a big deal, since I have an alternate way to run successfully. But doing so does not provide any result message in VSCode after the activity indicator stops spinning, and I prefer the satisfying server response messages in the cell output typical when running other types of non-query statements in MySQL via SQL Notebook (ex. CREATE TABLE), so I thought it was worth mentioning in case it was an easy tweak. Regardless, still a big fan. Thanks
Hm, I'll take a look. Thanks for this report. Seems to be a quirk with the mysql node driver.