CHAR类型字段保存后，变为CHARACTOR

Viewed 22
2.1 query

建表语句

CREATE TABLE `zxw_charactor`
(
  `a` tinyint NOT NULL,
  `c1` char(10),
  `c2` char(100),
  `c3` char(200),
  `c4` char(255)
) 
UNIQUE KEY(`a`) 
DISTRIBUTED BY HASH(`a`) BUCKETS 1 
PROPERTIES
(
  "replication_num" = "2",
  "enable_unique_key_merge_on_write" = "true"
);

创建成功后，SHOW CREATE TABLE

CREATE TABLE `zxw_charactor` (
  `a` TINYINT NOT NULL,
  `c1` CHAR(10) NULL,
  `c2` CHAR(100) NULL,
  `c3` CHAR(200) NULL,
  `c4` CHARACTER(255) NULL
) ENGINE=OLAP
UNIQUE KEY(`a`)
DISTRIBUTED BY HASH(`a`) BUCKETS 1
PROPERTIES (
"replication_allocation" = "tag.location.default: 2",
"min_load_replica_num" = "-1",
"is_being_synced" = "false",
"storage_medium" = "hdd",
"storage_format" = "V2",
"inverted_index_storage_format" = "V1",
"enable_unique_key_merge_on_write" = "true",
"light_schema_change" = "true",
"disable_auto_compaction" = "false",
"enable_single_replica_compaction" = "false",
"group_commit_interval_ms" = "10000",
"group_commit_data_bytes" = "134217728",
"enable_mow_light_delete" = "false"
);

因为有元数据同步的需求，发现类型不一致的问题，没有查询到相关介绍，这算显示的bug吗

Zhouxw44
1 Answers

目前影响大吗，这个会在char的长度为255或者不指定长度的时候显示为CHARACTER。

黄海军@SelectDB4403