#
# Test add, modify, rename, drop column
# Author: Susil, susil.behera@mariadb.com
#
-- source ../include/have_columnstore.inc

--disable_warnings
DROP DATABASE IF EXISTS mcs87_db;
--enable_warnings

CREATE DATABASE mcs87_db;
USE mcs87_db;

CREATE TABLE t1 (c1 INT, c2 CHAR(1)) ENGINE=Columnstore CHARSET=latin1 COLLATE=latin1_swedish_ci;
INSERT INTO t1 VALUES (1, 'a'), (2, 'b'), (3, 'c'), (4, 'd'), (5, 'e');

#################
# Add New Column
#################

#BUG MCOL-4269
--error 1815
ALTER TABLE t1 ADD COLUMN c11 INT NOT NULL;

ALTER TABLE t1 ADD COLUMN c11 INT(1);
ALTER TABLE t1 ADD COLUMN c21 CHAR(2);

#Duplicate column name
--error 1060
ALTER TABLE t1 ADD COLUMN c11 INT(2);

#BUG MCOL-4267
--error 1178
ALTER TABLE t1 ADD COLUMN c12 CHAR(1) AFTER c11;

#BUG MCOL-4268
--error 1178
ALTER TABLE t1 ADD COLUMN c0 INT FIRST;

#################
# Modify Column
#################

#Bug MCOL-130
--error 1815
ALTER TABLE t1 MODIFY COLUMN c11 TINYINT;

#################
# Rename Column
#################
--error 1815
ALTER TABLE t1 CHANGE COLUMN c2 c2new CHAR(2);
ALTER TABLE t1 CHANGE COLUMN c2 c2new CHAR(1);
ALTER TABLE t1 CHANGE COLUMN c2new c2 CHAR(1);

#################
# DROP Column
#################
#Bug 4270
--error 1178
ALTER TABLE t1 DROP COLUMN IF EXISTS c11;
ALTER TABLE t1 DROP COLUMN c11;
ALTER TABLE t1 DROP COLUMN IF EXISTS c11;

--replace_regex /( COLLATE=latin1_swedish_ci)//
SHOW CREATE TABLE t1;
SELECT * FROM t1 ORDER BY c1;

# Clean UP
DROP DATABASE mcs87_db;