Load data error

[Donxiaohao]

mysql version 14.14
dolt version 1.42.11

When I follow the official recommendation to batch import and use the load data command,I encountered the error shown above.

The same command is executed normally in mysql

Looking at the error message, the problem lies in the set, but the official website syntax description is supported.
I think this is a bug，

[timsehn]

This looks like we don't support SET syntax in our LOAD DATA. @jycor will look into this today. It may be easy to supportor it may take a few days.

[zachmu]

@jycor can you summarize what's left to do on this one?

[jycor]

The two linked PRs (dolthub/go-mysql-server#2653 and dolthub/vitess#362) add support for the SET clause in LOAD DATA statements, so we're able to assign column values during a LOAD DATA.

However, we are missing support for assigning user variables within a LOAD DATA query.
For example:

LOAD DATA INFILE <file_path> INTO TABLE t (i, j, @k) set k = concat('123', @k);

I'm currently working adding this.
Hopefully, will have something by the end of the week.

[jycor]

Hey @Donxiaohao, thanks for making this issue!
We've managed to support the features requested for LOAD DATA.

The fix is making its way to main, and we will have a release out for you later this week!
Please let us know if run into any more issues.

[Donxiaohao]

@jycor Thank you so much ， I will try