|
CREATE TABLE `t` (
|
`id` bigint(20) NOT NULL COMMENT 'autoincrement=1',
|
`name` varchar(80) NOT NULL,
|
`country` varchar(14) NOT NULL
|
) ENGINE=Columnstore DEFAULT CHARSET=utf8
|
ID being autoincrement should be skipped from the INSERT statements following MariaDB server standards and it is also documented in https://mariadb.com/kb/en/library/columnstore-create-table/
Currently, with 1.2.5, when INSERTING without the "ID" column fails with an error message: Field 'id' doesn't have a default value
INSERT INTO t(name, country) VALUES ('foo', 'bar');
|
|