[MCOL-3884] Alter table Failed: Changing the datatype of a column is not supported Created: 2020-03-13  Updated: 2023-12-30  Resolved: 2023-10-25

Status: Closed
Project: MariaDB ColumnStore
Component/s: DMLProc
Affects Version/s: 1.2.5, 5.5.2, 6.2.2
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: David Hill (Inactive) Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: None
Environment:

centos 7 single server


 Description   

MariaDB [(none)]> ALTER TABLE dpdcoredata.ttevents CHANGE COLUMN misc_json misc_json text DEFAULT NULL;
ERROR 1815 (HY000): Internal error: CAL0001: Alter table Failed: Changing the datatype of a column is not supported
MariaDB [(none)]> ALTER TABLE dpdcoredata.ttevents CHANGE COLUMN misc_json misc_json text DEFAULT NULL;

But I found this in the description of alter for columnstore:

ALTER TABLE tbl_name
alter_specification [, alter_specification] ...

alter_specification:
table_option ...

ADD [COLUMN] col_name column_definition
ADD [COLUMN] (col_name column_definition,...)
ALTER [COLUMN] col_name {SET DEFAULT literal | DROP DEFAULT}
CHANGE [COLUMN] old_col_name new_col_name column_definition
DROP [COLUMN] col_name
RENAME [TO] new_tbl_name

column_definition:
data_type
[NOT NULL | NULL]
[DEFAULT default_value]
[COMMENT '[compression=0|1];']

table_options:
table_option [[,] table_option] ... (see CREATE TABLE options)

 Comments   
Comment by hiller1 [ 2023-12-30 ]

MariaDB [test]> alter table t1 change name name varchar(2000);
ERROR 1815 (HY000): Internal error: CAL0001: Alter table Failed: Changing the datatype of a column is not supported

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