[MCOL-4213] Unsupported auto_increment error is coming from Innodb engine Created: 2020-07-27  Updated: 2023-10-26  Resolved: 2023-10-26

Status: Closed
Project: MariaDB ColumnStore
Component/s: DDLProc
Affects Version/s: None
Fix Version/s: Icebox

Type: Bug Priority: Minor
Reporter: susil.behera Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None
Environment:

Server version: 10.5.4-MariaDB MariaDB Server
Columnstore: 1.5.2-1


 Description   

Columnstore doesn't support CREATE TABLE with auto_increment. But when someone executes it the error msg seems to come from Innodb engine.

CREATE TABLE t1 (a INT auto_increment) ENGINE=Columnstore;
ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key

Appropriate error msg should come from Columnstore engine.
Generated at Thu Feb 08 02:48:39 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.