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

Support committing a single SQL statement request #8729

Open
GodGavin opened this issue Jan 10, 2025 · 1 comment
Open

Support committing a single SQL statement request #8729

GodGavin opened this issue Jan 10, 2025 · 1 comment
Labels
customer issue enhancement New feature or request

Comments

@GodGavin
Copy link

I mean Execute an SQL statement and immediately synchronize commit it.
And only commit the modifications caused by this single SQL statement instead of committing the entire table.
for instance:
maybe like this
mysql>call dolt_execute_and_commit('-m','info','-sql','update *')

@fulghum fulghum added the enhancement New feature or request label Jan 17, 2025
@fulghum
Copy link
Contributor

fulghum commented Jan 17, 2025

Thanks for the feature suggestion, @GodGavin. I understand the appeal for this to be all wrapped up in a single, easy-to-execute statement and I see how that could be handy for customers.

For others reading this issue, the workaround would be to create a branch, execute the update/insert, create a dolt commit on the branch, and merge the branch back to the starting branch (or alternatively, cherry-pick the new commit on the branch to avoid creating a merge commit on the starting branch in case its history has moved forward). The effect and isolation of the changes should be the same, but obviously having this in a single command to execute would be a simpler experience for customers.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
customer issue enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

3 participants