Drop table is not Rolled Back

Help
1

Hello everyone,

I can’t find something related to the transactions in the official documentation. The insert is rolledback well but the drop table is ignored.
Below is a simple example. After calling the transaction, the table is deleted forever.

CREATE PROCEDURE test_transaction() AS
BEGIN
START TRANSACTION;
drop table test;
ROLLBACK;
END

2

Hi Lucian,

All DDL statements (CREATE,DROP, ATLER, etc.) in MemSQL aren’t transactional. If you put DDL instead of a transaction the transaction will be implicitly committed before the DDL stmt executed (This is for compatibility with MySQL which has the same behavior).

3

Thank you for the answer! I was expecting something like this, but I couldn’t find anything related

1 Like