Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
1.2.5, 5.5.2, 6.2.2
-
None
-
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)