CREATE TABLE `countries_innodb` (

  `code` varchar(255) NOT NULL

) ENGINE=InnoDB;

CREATE TABLE `countries_columnstore` (

  `code` varchar(255) NOT NULL

) ENGINE=ColumnStore;

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

BEGIN;

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

SELECT * from countries_columnstore;

ROLLBACK;

-- Result: two countries.

-- Expected: one country.

SELECT * FROM countries_innodb;