Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
AJTonyKane opened this issue Nov 30, 2022 · 1 comment

Comments

@AJTonyKane
Copy link

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
Copy link
Owner

cmoog commented Dec 6, 2022

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants