Welcome back to another installment of Dolt's monthly correctness updates! If you missed it, here's last month's update. We've been receiving fewer customer issues lately, so there was a focus on adding more features and expanding on existing functionality.

LOAD DATA Improvements

A new customer wanted to take advantage of the user variables and SET clauses in LOAD DATA statements. During the import process, it's possible to store fields into user variables and reference them later on. A common example is placing a @dummy user variable in the column list to skip a field during import. For example:

LOAD DATA INFILE 'data.txt' INTO TABLE t (col1, @dummy, col2);

In this case, the second field in the data.txt file is skipped during import.

SET clauses allow you to assign specific values to variables during the import process. For example:

LOAD DATA INFILE 'data.txt' INTO TABLE t (col1, col2) SET col3 = 123;

In this case, the value 123 is assigned to col3 for every row imported.

Lastly, it's possible to combine these two features to create more complex import statements. For example:

LOAD DATA INFILE 'data.txt' INTO TABLE t (col1, col2, @col3) SET col3 = @col3 + 1;

In this case, the value of col3 is incremented by 1 for every row imported.

We added support for these features in Dolt, so now the customer and you can use them in your LOAD DATA statements.

Metrics Summary

Since last time, we've increase the total number of enginetests from 44435 to 44689. We've added one skipped test to bringing our total number of skipped tests to 225. This yields a 99.50 percent pass rate.

This month has been pretty good for SQL functions. We've added support for 8 new functions, bringing our total to 316 out of 438, netting 73 percent coverage. The newly supported functions are:

• validate_password_strength()
• compress()
• uncompress()
• uncompressed_length()
• charset()
• get_format()
• icu_version()
• name_const()

Year-To-Date Reflection

It's been about half a year since we started doing these monthly updates, so it's a good time to reflect on our progress.

Here's a chart illustrating the number of customer issues created and closed, and the number of servers this year:

As you can see, we've been keeping pace with the number of incoming issues. Furthermore, despite the number of servers increasing, the number of incoming customer issues has remained relatively stable and even slightly decreased.

Conclusion

As usual, Dolt continues to grow and improve. If you have any features or bugs you want us to prioritize, make an issue on our Github Issues page. We also have community Discord! Feel free to join and chat with us there.