Improve installation procedure and reduce SQL limitations (MCOL-3686)

[MCOL-3720] AUTO_INCREMENT should pass but warn Created: 2020-01-10  Updated: 2020-02-01  Resolved: 2020-02-01

Status: Closed
Project: MariaDB ColumnStore
Component/s: N/A
Affects Version/s: 1.4.2
Fix Version/s: Icebox

Type: Sub-Task Priority: Major
Reporter: Andrew Hutchings (Inactive) Assignee: Andrew Hutchings (Inactive)
Resolution: Not a Bug Votes: 0
Labels: None

Sprint: 2020-1, 2020-2, 2020-4, 2020-5, 2020-6, 2020-7

 Description   

When a CREATE TABLE contains an AUTO_INCREMENT this should be allowed through the DDL parser but warn that it will be ignored.

 Comments   
Comment by Andrew Hutchings (Inactive) [ 2020-01-10 ]

Additionally SEQUENCES should work if possible.

Comment by Andrew Hutchings (Inactive) [ 2020-02-01 ]

MariaDB generates the following error:

MariaDB [test]> create table t1 (a int auto_increment, b int) engine=columnstore;
 
ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key

This is independent of ColumnStore.

Generated at Thu Feb 08 02:44:56 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.