vscode-sql-notebook icon indicating copy to clipboard operation
vscode-sql-notebook copied to clipboard

Error Attempting LOAD DATA LOCAL INFILE statement (cell output references streamFactory option)

Open AJTonyKane opened this issue 2 years ago • 1 comments

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

AJTonyKane avatar Nov 30 '22 23:11 AJTonyKane

Hm, I'll take a look. Thanks for this report. Seems to be a quirk with the mysql node driver.

cmoog avatar Dec 06 '22 20:12 cmoog