[MCOL-3620] Auto Increment expects the column to be mentioned in the INSERT statement - Jira

XML

Word

Printable

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');

duplicates

MCOL-479 insert omitting not null autoincrement column results in warning

MCOL-780 auto increment needs to use MariaDB's auto increment methods

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.