CODEWITHSUNDEEP
singlestore
dmagda
dmagda

Reputation: 1795

MemSQL multi-operations transactions

It's not clear from MemSQL documentation whether multi-operations transactions are supported or not.

In simple words let's say I have the following transaction

BEGIN 
INSERT smth INTO table1
INSERT smth INTO table2
UPDATE table2 SET smt
DELETE FROM table3 WHERE smth
COMMIT

Will this be an atomic operation meaning that either the whole transactions succeeds or rollbacks if it lease one operand fails?

Upvotes: 2

Views: 920

Answers (1)

Jack Chen
Jack Chen

Reputation: 1214

These are supported, yes. You can observe this, if you run rollback, or if you run select queries from another client prior to the commit, you will see none of the DML effects.

Upvotes: 2

Related Questions