Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.0.6.1
-
CentOS 6.5
-
2017-15
Description
When the CrossEngineSupport is enabled, we can run the SQL on two tables with different engine type(ColumnStore, MyISAM) but the results is not normal.
CREATE TABLE `test_cs` (
`c1` int(11) DEFAULT NULL,
`c2` varchar(64) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
CREATE TABLE `test_myisam` (
`c1` int(11) DEFAULT NULL,
`c2` varchar(64) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
insert into test.test_cs values(1, 'cs测试');
insert into test.test_myisam values(2, 'myisam测试');
select * from test.test_cs union select * from test.test_myisam;
--------------+
c1 | c2 |
--------------+
2 | myisam?? |
1 | cs测试 |
--------------+
2 rows in set (0.14 sec)
It seems that the data of MyISAM table is not normal.