Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Duplicate
-
1.0.11
-
None
Description
When a ColumnStore query is executed it triggers an explicit commit for non-ColumnStore due to the internal vtable processing. Example:
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; |