[MCOL-4581] alter table rename column fails in ubuntu for char types Created: 2021-03-04  Updated: 2023-07-02

Status: Open
Project: MariaDB ColumnStore
Component/s: DDLProc
Affects Version/s: 5.5.2
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: David Hall (Inactive) Assignee: Leonid Fedorov
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Blocks
is blocked by MCOL-5189 syscat : add collation Closed

 Description   

See working_tpch1/misc/rename.negative.sql
All the queries of type
alter table qa_col_rename change CCHAR1 CCHAR1_R CHAR(1);
using char or varchar fail on ubuntu 18.04 with
ERROR 1815 (HY000) at line 165: Internal error: CAL0001: Alter table Failed: Changing the datatype of a column is not supported
The datatype in the alter statement is the same as in the original create table.
On CentOS 7 these same queries succeed.

Create table qa_col_rename (
CIDX INTEGER,
CBIGINT BIGINT,
CDECIMAL1 DECIMAL(1),
CDECIMAL4 DECIMAL(4),
CDECIMAL4_2 DECIMAL(4,2),
CDECIMAL5 DECIMAL(5),
CDECIMAL9 DECIMAL(9),
CDECIMAL9_2 DECIMAL(9,2),
CDECIMAL10 DECIMAL(10),
CDECIMAL18 DECIMAL(18),
CDECIMAL18_2 DECIMAL(18,2),
CINTEGER INTEGER,
CSMALLINT SMALLINT,
CTINYINT TINYINT,
CDATE DATE,
CDATETIME DATETIME,
CCHAR1 CHAR(1),
CCHAR2 CHAR(2),
CCHAR3 CHAR(3),
CCHAR4 CHAR(4),
CCHAR5 CHAR(5),
CCHAR6 CHAR(6),
CCHAR7 CHAR(7),
CCHAR8 CHAR(8),
CCHAR9 CHAR(9),
CCHAR255 CHAR(255),
CVCHAR1 VARCHAR(1),
CVCHAR2 VARCHAR(2),
CVCHAR3 VARCHAR(3),
CVCHAR4 VARCHAR(4),
CVCHAR5 VARCHAR(5),
CVCHAR6 VARCHAR(6),
CVCHAR7 VARCHAR(7),
CVCHAR8 VARCHAR(8),
CVCHAR255 VARCHAR(255)
)engine=columnstore;



 Comments   
Comment by David Hall (Inactive) [ 2021-03-04 ]

Is it possible that this is charset related? maybe. There is some indications that the default charset used in drone (where this was discoverd) is not the same as on my test machine (UTF8). However, this test passed on CentOS 7 in drone.

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