[MCOL-130] ALTER TABLE does not support changing data type Created: 2016-06-12  Updated: 2023-07-02  Resolved: 2023-07-02

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

Type: New Feature Priority: Major
Reporter: Justin Swanhart (Inactive) Assignee: Todd Stoffel (Inactive)
Resolution: Won't Do Votes: 2
Labels: None

Issue Links:
Blocks
blocks MCOL-4526 ALTER TABLE doesn't allow altering CH... Closed
Duplicate
is duplicated by MCOL-1131 Alter table fails to change the colum... Closed
Relates
relates to MCOL-321 support mariadb syntax for alter tabl... Closed
relates to MCOL-694 ALTER TABLE doesn't support AFTER Closed
relates to MCOL-3294 Allow moving a table to different sch... Closed
relates to MCOL-3695 ALTER TABLE .. DEFAULT CHARSET does n... Closed
Epic Link: ColumnStore Compatibility Improvements

 Description   

mysql> alter table t1 change c1 c2 tinyint;
ERROR 1815 (HY000): Internal error: CAL0001: Alter table Failed: Changing the datatype of a column is not supported



 Comments   
Comment by David Hall (Inactive) [ 2021-02-01 ]

Since MCOL-2000, the number of bytes in char, varchar or text field are affect by the charset.

Comment by David Hall (Inactive) [ 2021-02-01 ]

To support changing data type, we need to create a facility to copy an entire column to a new one with data conversion on each value. We can leverage the logic of add column to enable this.

Comment by Todd Stoffel (Inactive) [ 2023-07-02 ]

The "create date" on this ticket is pre-convergence with MariaDB server. If the issue still exists in a modern version of the engine/plugin please submit a new ticket.

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