transaction gets autocommitted if non columnstore query executed

It looks like ColumnStore is not respecting a transaction ROLLBACK if, inside the transaction, we issue a SELECT statement.

This happens regardless of the table engine (we tested with InnoDB and ColumStore).

Test case:

CREATE TABLE `countries_innodb` (
`code` varchar(255) NOT NULL
) ENGINE=InnoDB;

INSERT INTO countries_innodb (code) VALUES ('BR');

BEGIN;
INSERT INTO countries_innodb (code) VALUES ('UK');
SELECT 'INSIDE TRANSACTION' AS '';
ROLLBACK;

– Result: two countries.
– Expected: one country.
SELECT * FROM countries_innodb;

It looks like only the SELECT generates this behavior. If we INSERT or UPDATE multiple times, the transaction is still ROLL'd back fine.

Current version: 1.0.9.