search

cmoog / vscode-sql-notebook

Open SQL files as VSCode Notebooks.
https://marketplace.visualstudio.com/items?itemName=cmoog.sqlnotebook
MIT License
120 stars 16 forks source link

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

Open AJTonyKane opened 1 year ago

AJTonyKane commented 1 year ago

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

cmoog commented 1 year ago

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