Support BEGIN WORK

[tiksn]

I want to use XCA for storing certificates in Dolt repository.

With a dolt version 0.41.5 I can't do that because I am getting error

Syntax error at possition 11 near 'WORK' QMYSQL: unable to begin transation

Query is

BEGIN WORK

From MySql Documentation seams that there are many aliases for the same operation

BEGIN [WORK]
COMMIT [WORK] [AND [NO] CHAIN] [[NO] RELEASE]
ROLLBACK [WORK] [AND [NO] CHAIN] [[NO] RELEASE]
SET autocommit = {0 | 1}

It would be nice to have those aliases.

[fulghum]

Hey Tigran, thanks for opening this issue. Using Dolt as the backing store for XCA sounds like a cool idea!

Adding parser support for BEGIN WORK, COMMIT WORK, and ROLLBACK WORK should be pretty straightforward. I‘ll check with @jcor11599 and see if he‘s able to knock this one out quickly for you.

[jycor]

Hey @tiksn, do you just need the BEGIN WORK, COMMIT WORK, and ROLLBACK WORK statements? or do you need AND NO CHAIN and NO RELEASE options as well?

Do you have an example of the query being run/generated?

[jycor]

Support for this syntax has made its way to main. Feel free to build from main to test it out. Otherwise, we'll do a release sometime this week.

[tiksn]

@jcor11599 so far XCA works fine with Dolt SQL Server (after applying schema manually). Thanks for the feature.

[timsehn]

Great to hear!