Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.1.6
-
None
-
None
-
2018-17, 2018-18, 2018-19, 2018-20, 2018-21
Description
1. Create a new table in TX:
CREATE TABLE `test` (
|
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
|
`col` varchar(100) DEFAULT NULL,
|
UNIQUE KEY `id` (`id`)
|
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
|
2. Run
mxs_adapter -c /etc/Columnstore.xml -u cdcuser -p cdcpassword -h localhost -P 4001 cdc_eli test
Result:
Table was not found in Columnstore. A DDL statement is suggested to create a respective table in Columnstore. The DDL contains syntax error:
CREATE TABLE cdc_eli.test (col varchar(100), domain int, event_number int, event_type varchar(50), id serial, sequence int, server_id int, timestamp int) ENGINE=ColumnStore;
|
Error is:
Error Code: 1069. Too many keys specified; max 0 keys allowed
Problem is in id serial. Columnstore doesn't support this.